What is the best time to download YESTERDAY report?

[Danil Starovoytov]

Hi everybody,

I need to get SEARCH_QUERY_PERFORMANCE_REPORT report every day. I use YESTERDAY date range type. And I need to get it as soon as possible.

There is GMT+2 timezone set in our AdWords account settings.

I made a script to get the report every 30 minutes:

11:00:04 PM - Report lines count: 3600

11:50:04 PM - Report lines count: 3600

00:10:03 AM - Report lines count: 4117

00:30:04 AM - Report lines count: 4117

01:00:03 AM - Report lines count: 4124

01:30:04 AM - Report lines count: 4184

02:00:04 AM - Report lines count: 4184

02:30:04 AM - Report lines count: 4184
...

I have read here about 3 hours delay

In most cases, your account statistics (such as clicks, conversions and impressions) are delayed by less than three hours.

It seems at 01:30 AM report mostly is up to date. And I thought 02:00 AM is ok to get the report. 

But today the report was fetched at 02:05 AM (4360 items fetched) and at 09:08 AM (4245 items fetched). 

The number of items decreased in yesterday's report. How could this happen?

[Peter Oliquino (AdWords API Team)]

Hi Danil,

The discrepancy could be due to the adjustments mentioned in the same link that you provided. While it is mentioned that data of today can be retrieved fully the following day, certain factors may still influence the adjustments done by the system. That being said, our recommendation would be to regenerate the report at an even later time to see whether adjustments have been made and that the data you retrieved is already final.

Best regards,

Peter

AdWords API Team