clicks stat
select toDate(timestamp) as date, sum(clicked_count) from subscribers_activities where date >= ‘2023-09-01’ group by date; select distinct subscriber_id from subscribers_activities where toDate(timestamp) >= ‘2023-09-01’ and clicked_count > 0;
delivery stat
select channel_id, value, sum(delivered_count) as delivers from subscriber_sources_activities where toDate(datetime) >= ‘2024-02-01’ and toDate(datetime) < ‘2024-03-01’ and key = ‘campaign’ group by value, channel_id order by delivers desc;