PUSH statistics

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
****
**
***
 
Please add statistics for push notifications:
  • Platforms / OS
Please clarify what this does mean:
  • The total number of subscribers per platform
  • The total number of subscriptions per platform
  • The number of new subscribers per platform per X
  • The number of new subscriptions per platform per X
  • Smth. else
?
  • Revoked subscriptions
Please clarify what this does mean?
 
Last edited:
Top Bottom