"SELECT segments.date, campaign.id, campaign.name, customer.currency_code, campaign.app_campaign_setting.app_id, campaign.app_campaign_setting.app_store, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, metrics.impressions, metrics.clicks, metrics.cost_micros, campaign.final_url_suffix, campaign.tracking_url_template, campaign_criterion.location.geo_target_constant FROM location_view WHERE segments.date >= '2019-07-01' AND segments.date <= '2019-07-01' ORDER BY segments.date"
|
||||||