source-param-deliveries

Query

This query is used to get source param deliveries for a June 2024 period. It will return sum of deliveries for all possible pairs of source parameter keys and values.

select key, value, sum(delivered_count) from subscriber_sources_activities where datetime >= '2024-06-01' and datetime < '2024-07-01' group by key, value;

Export

clickhouse-client --host=127.0.0.1 --port=9000 --user=default --database=statistics --query "select key, value, sum(delivered_count) from subscriber_sources_activities where datetime >= '2024-06-01' and datetime < '2024-07-01' group by key, value;" --format CSV > /tmp/source_param_deliveries.csv