PUSH statistics

Alfa1

Well-known member
Please add statistics for push notifications:
  • Number of subscribers
  • Platforms / OS
  • Revoked subscriptions
  • Notifications sent
  • Notifications clicked (not sure if it is possible to track, but would be interesting to see)
 

AndrewSimm

Active member
It is a good suggestion, though I don't know if everything you are asking for is available.

I believe this query will pull the number of subscriptions, which is device-based
SQL:
select count(1) as subscriptions
from xf_user_push_subscription
I believe this query will pull the number of distinct users who have subscribed
SQL:
select count(distinct(user_id)) as users
from xf_user_push_subscription
Outside of these, you could probably get the browser using the endpoint
****
**
***
 
Top