BQ dataset - Google Ads Transparency Center

[lucie_rabochova]

Hello,

I'm just thinking how to correctly present data I got from this BQ extract. Especially I mean table public.google_ad_stats and its metrics like time_shown_upper_bound and times_shown_lower_bound. Is there any online documentation available? Does anyboby has SQL script or guide me how to clean it to be ready for dashboard?

I need to have clean impressions (lower and upper) number, per creative_id and advertiser_id, per date. It looks like it is duplicated and duplicated.

https://console.cloud.google.com/marketplace/details/bigquery-public-data/google-ads-transparency-ce...