Querying public google_ads_transparency_center table doesn't show all the needed data.

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.

In general, BigQuery public datasets may not have all of the data that exists for that domain. As per Google Ads Transparency Center overview (pasted below) in the BigQuery public data marketplace, it contains data for “the European Economic Area or Turkey” only while https://adstransparency.google.com lets you query globally. If you filter to specific countries in that site (instead of shown “Anywhere”), you’ll see different number of ads.

–

Overview