Tracking Subscribers in Locations

[mgordon]

Hello all! I was wondering best practices or advice on tracking subscriber counts within areas of your community. At the moment we have a feed that tracks the count for admins of the platform but it cannot be downloaded or fully reported on without manually checking.

Any help would be awesome!

[StanGromer · Accepted solution]

If you utilize the bulk data API, you can get the counts out of there easily enough.

You can manually look at who is subscribed to a specific node by just crafting a URL such as 

https://community.DOMAIN.com/restapi/vc/boards/id/BOARD-ID/subscribers/email/board/

 Change DOMAIN and BOARD-ID to your domain and the node ID you want track.

Engineering wise as Claudius suggests here 

Count of subscribers: 
SELECT count(*) FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

Subscribers: 
SELECT subscriber FROM subscriptions WHERE target.type = 'thread' AND target.id = '2250'

---

[mgordon]

Thank you much appreciated!