users
and it has no dimensions or filter.users
, grouped by channel_id
and date_yyyymmdd
dimensions, without filters.sessions
, grouped by the date_yyyymmdd
dimension with filter clauses activity_type = AD_VIEW
and origin_campaign_id = 666
number_of_transactions
, grouped ty the date_yyyymmdd
dimension with filter clauses on channel_id = 666
. Then a filter is applied on the calculated metric to only keep days with more than 200k transactions.