I’m having an issue querying table *bigquery-public-data.google_ads_transparency_center.creative_stats* for a specific advertiser.
For example:
SELECT distinct creative_id FROM bigquery-public-data.google_ads_transparency_center.creative_stats
where advertiser_id = ‘AR01847332847816278017’
The query above outputs only three creatives, but if you look it up in the transparency center UI - https://adstransparency.google.com/advertiser/AR01847332847816278017 it will be ~200
I thought it was a time-related problem, but one of the three creatives was 1 day old, and another was 6 months old. Meaning it doesn’t output only the last N days of creatives.
I also tried using the time-travel window as follows:
SELECT *
FROM bigquery-public-data.google_ads_transparency_center.creative_stats
FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 10 MINUTE);
But I got the next error:
Access Denied: Table bigquery-public-data:google_ads_transparency_center.creative_stats@1735919371368: User does not have permission to query table bigquery-public-data:google_ads_transparency_center.creative_stats@1735919371368, or perhaps it does not exist.