Automattic / Automattic/jetpack

Newsletter: include more info in export CSV

Open
#40,260 1 comment 0 reactions 0 assignees View on GitHub
[Experiment] AI labels added [Feature] Subscriptions Enhancement
Dominant language
PHP
Stars
1.8k
Forks
898
Avg merge
1d 18h
Merged PRs (30d)
774

Description

Currently Export only includes emails, no other info.

![Image](https://github.com/user-attachments/assets/bba4b4ea-74b3-43ca-8064-cececb69c85c)

Let's include more data for easier migration to alternative services, for subscriber profiles we currently have:

![Image](https://github.com/user-attachments/assets/a707ea7f-af52-4806-b1f2-b80c980b43e8)

Include at least:
- Newsletter categories (if enabled)
- Paid/free subscriber (if enabled)
- Subscription date
- WP.com username
- Reader/email subscription

Optionally, we have:
- HTML/text email format
- Instant/daily/weekly schedule
- Click rate
- Open rate
- Emails sent
- Country

All these also let customers do their own analysis on their chosen software like Google Sheets.

Contributor guide

Open the contributing guide

Research direction

Inspect the Newsletter CSV export entry point and the subscriber profile data sources; the issue does not name specific files or tests. Done means the export includes the required category, payment status, subscription date, WordPress.com username, and reader/email subscription fields, with the optional fields clarified or included.

Written by the indexing model from the issue text.

Assessment

Tech stack
php, wordpress
Domain
backend, data
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.