I need to develop an admin panel which can send and monitor push notifications. The data I gonna monitor for each message includes:
- amount of unique devices to send notification (with or no topic)
- amount of unique devices with recieved notification (with or no topic)
- amount of unique devices with opened notification (with no topic)
To collect this data I've decided to use Google BigQuery API. In FCM documentation I've founded query examples for first two items but I don't know how to count opened messages
So I need a help to solve this quizz. You can help me with one one of things:
- Query example to get amount of opend messages from BigQuery
- Demonstration of another wway to collect data if BigQuery is not appropriate for my purposes
Thank you in advance