Missing past historical data that can be seen in Google Ads platform, but doesn't show upt Big Query

I'm using BigQuery to store our Google Ads campaign performance information for our clients. To pull the data, I'm using a very simple query:

select *  from yl-adwords.ads.AdBasicStats_[our manager ID]  where ExternalCustomerId = [our media client's ID]  

This query pulls back to 1/17/21. We took on this new client on 2/16/21, so we're able to get the past 30 days of data. However, the Google Ads account data goes back to 2019.

What's odd is for our other client accounts, when we get access using similar queries, we can pull back historical data with no issue. We're pulling others back to 2018, even though we started working with them ini 2020.

Do I need to schedule a backfill in BQ to get this new data? Or has anyone else experienced this issue?

https://stackoverflow.com/questions/66804013/missing-past-historical-data-that-can-be-seen-in-google-ads-platform-but-doesn March 26, 2021 at 12:46AM