Delivery / sent ratio
In order to calculate the ratio of delivered messages to sent messages, you can use the following query:
select date, sender_id, sum(delivered_count) / sum(sent_count) as d2s from sender_firebase_statistics where date >= '2024-04-10' and sender_id in (102, 69) group by sender_id, date order by date;Daily clicks data
select date, sum(clicked_count) from sender_firebase_statistics where sender_id = 69 and date >= '2024-05-01' group by date;Daily clicks to delivery ration
select date, sum(clicked_count)/sum(delivered_count) from sender_firebase_statistics where sender_id = 69 and date >= '2024-05-01' group by date;