# Who is subscribed to each newsletter?

**URL:** <https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907>\
**Category:** Using Ghost\
**Created:** [September 20, 2022, 2:34pm UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907 "2022-09-20T14:34:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![BruceInLouisville](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/bruceinlouisville/32/40997_2.png) [@BruceInLouisville](https://forum.ghost.org/u/BruceInLouisville)\
**Post date:** [September 20, 2022, 2:34pm UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907/1 "2022-09-20T14:34:09Z")

</div>

I have a number of newsletters on my site, and various people are subscribed to each. After looking around for a while, I did not find a way to see which members are subscribed to which newsletters other than going into each member’s record. Am I missing something?

---

<div class="post-metadata">

**Author:** ![Berkeley\_Scanner](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/berkeley_scanner/32/18474_2.png) [@Berkeley\_Scanner](https://forum.ghost.org/u/Berkeley_Scanner)\
**Post date:** [September 21, 2022, 1:30am UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907/2 "2022-09-21T01:30:54Z")

</div>

I recently asked Ghost a similar question:

_I see how to export members - which produces a spreadsheet with some of their account info._

_But it does not appear to include which of my newsletters they are signed up for._

This was the response:

_You can see which newsletters your members are subscribed to on each of their individual member profile pages, but this data is not included in member exports. This sounds like a great idea, though!_

_I’d be more than happy to pass along this feedback to our team, for potential improvements to the platform. Though I wouldn’t be able to make any guarantees, I can definitely communicate the use case !_

\*\*

In the meantime, I started trying to set up a Zap to create a spreadsheet with this kind of info… but I had to put it aside for the time being.

---

<div class="post-metadata">

**Author:** ![BruceInLouisville](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/bruceinlouisville/32/40997_2.png) [@BruceInLouisville](https://forum.ghost.org/u/BruceInLouisville)\
**Post date:** [September 21, 2022, 11:46am UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907/3 "2022-09-21T11:46:59Z")

</div>

Thanks for the info! Glad they at least have it on their feature list, maybe.

If I had access to the backend database, I could pull it out with a query. But, my hosting setup doesn’t include FTP access or MySQL access, so no can do. And I’m not really up for going through hundreds of records one at a time.

---

<div class="post-metadata">

**Author:** ![Berkeley\_Scanner](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/berkeley_scanner/32/18474_2.png) [@Berkeley\_Scanner](https://forum.ghost.org/u/Berkeley_Scanner)\
**Post date:** [October 15, 2022, 6:42am UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907/4 "2022-10-15T06:42:35Z")

</div>

I only launched recently so I ended up on a rabbit hole going through all 500 or so members… I added tags to people who had no email - or only had my weekly email or only had news alerts… That really only captured the data at a single point in time, but it did allow me to tailor/segment a newsletter in a way that I could not have otherwise done. It probably wasn’t worth it … I asked them again if they could make this easier. It seems like it would be super feasible to output this in the member spreadsheet.

---

<div class="post-metadata">

**Author:** ![BruceInLouisville](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/bruceinlouisville/32/40997_2.png) [@BruceInLouisville](https://forum.ghost.org/u/BruceInLouisville)\
**Post date:** [October 15, 2022, 10:49pm UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907/5 "2022-10-15T22:49:55Z")

</div>

Yes – I’m sure the data is in the database. Just a matter of putting it into the query and pulling the data into the report.

---

<div class="post-metadata">

**Author:** ![Berkeley\_Scanner](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/berkeley_scanner/32/18474_2.png) [@Berkeley\_Scanner](https://forum.ghost.org/u/Berkeley_Scanner)\
**Post date:** [October 20, 2022, 7:10am UTC](https://forum.ghost.org/t/who-is-subscribed-to-each-newsletter/32907/6 "2022-10-20T07:10:25Z")

</div>

An awesome Ghost support person (Jon Hickman) gave me the solution. There’s a filter called “received mail” - and you can use it to find out who is on which list.

 ![Screen Shot 2022-10-19 at 9.26.35 PM](https://us1.discourse-cdn.com/flex015/uploads/ghost2/original/3X/0/3/030766979d051c628ac98c2f74f02422f07ef5cf.png)

I needed this as a work-around because I wanted to send my weekly email to my daily list. And then also to the weekly email folks who were NOT on the daily list… as I’m working to promote it. I used labels to create the segment I needed.

Anyway, the “received mail” filter was perfect. I checked by exporting both lists and deduping to confirm that was showing me the right results, and it was.
