Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Provide users with insight into each member's activity by displaying emails received and opened. #12461

Closed
sanne-san opened this issue Dec 8, 2020 · 0 comments
Closed

Provide users with insight into each member's activity by displaying emails received and opened. #12461

sanne-san opened this issue Dec 8, 2020 · 0 comments
Assignees
@kevinansfield @sanne-san

Comments

@sanne-san
Copy link
Member

sanne-san commented Dec 8, 2020 •
edited

To help users get insight into each member's engagement with their newsletters, we want to show high level stats on their profile, as well as show an activity feed for each email they've received/opened.

PR stats: TryGhost/Admin#1795 (comment)

PR activity feed: TryGhost/Admin#1796 (comment)
@kevinansfield kevinansfield mentioned this issue Dec 9, 2020
Merged
kevinansfield added a commit to kevinansfield/Ghost that referenced this issue Dec 9, 2020
@kevinansfield
Added members.email_{count,opened_count} column migrations
0010a5e 
refs TryGhost#12461

- adds `members.email_count` and `members.email_opened_count` columns to contain cached counts for faster queries when outputting member data via API
- adds migration to populate cached counts with existing data
  - tested locally on ~50k members which took ~4sec on mysql
- updates members output serializer to include the new fields in API output
kevinansfield added a commit that referenced this issue Dec 9, 2020
@kevinansfield
Added members.email_{count,opened_count} column migrations (#12470)
b1aafd7 
refs #12461

- adds `members.email_count` and `members.email_opened_count` columns to contain cached counts for faster queries when outputting member data via API
- adds migration to populate cached counts with existing data
  - tested locally on ~50k members which took ~4sec on mysql
- updates members output serializer to include the new fields in API output
kevinansfield added a commit that referenced this issue Dec 9, 2020
@kevinansfield
Updated email stats aggregator for new member count columns
baf635e 
refs #12461

- added two default aggregations for overall email count and opened email count
- when number of tracked emails is sufficient add the open rate aggregation to the update query
kevinansfield added a commit to TryGhost/Admin that referenced this issue Dec 9, 2020
@sanne-san @kevinansfield
✨ Added email stats overview to member details page (#1795)
23cc61e 
refs TryGhost/Ghost#12461

- Added "Emails received", "Emails opened", and "Avg. open rate" to member details
- Adjusted visual display of avatar, name and email. Made email a mailto link
- Rearranged Name and Email fields to reduce height
- Changed height of the notes textarea

Co-authored-by: Kevin Ansfield <kevin@lookingsideways.co.uk>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kevinansfield kevinansfield

@sanne-san sanne-san

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kevinansfield @sanne-san