Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Adept

Tracking Subscribers in Locations

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!

2 Replies 2

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'


 

Thank you much appreciated! 

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.