with ads_data as ( SELECT ad_id, adset_id, campaign_id, status, sum(impressions) clicks, sum(spend) as investment FROM `reby-cloud.facebook_ads.insights` ai left join `reby-cloud.facebook_ads.ads` ads on ai.ad_id = ads.id --WHERE DATE(_PARTITIONTIME) = "2021-07-06" group by 1,2,3,4 ) select * from ads_data where ad_id = '23843560033720454' order by clicks desc
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter