Revisions of yesterdays report data

13 views
Skip to first unread message

doug s

unread,
Aug 19, 2009, 1:43:59 PM8/19/09
to AdWords API Forum
Forgive me for asking this again. I am pretty sure I did, but I can't
find your response.

Our application pulls daily adgroup/creative/keyword reports every
night for many accounts. We would like to pull them as soon as
possible past midnight so we have ample time to process them.

I am not 100% certain, but it does seem that Google does go back and
revise historical impression, click, etc data.

Can you recommend how long we should wait after midnight before
pulling yesterdays data? When should we consider any given days report
data 100% finalized and complete?

Thanks!

Zweitze

unread,
Aug 19, 2009, 4:23:14 PM8/19/09
to AdWords API Forum
It depends on what you need to store.

Impressions, average Position:
Three to six hours after midnight according to the timezone of the
account.
(Adwords states three hours, some people here state six hours)

Clicks, Cost and derived values like CTR and CPC:
Same as Impressions/Position, but if you advertize on the Content
network, you may become a victim of click fraud by these website
owners. Allow two days for Google to verify and fix that.

Conversions and Conversion values, and derived values like
ConversionRate, CostPerConversion:
Allow for 30 days. End users get a cookie when they click, and when
they finally reach the conversion page that cookie is used by the
conversion script. The life time of that cookie is thirty days, so
after thirty days it's final. And yes, conversions are attributed to
date of the last click, and because of that you can derive the
ConversionRate, CostPerConversion etc. by comparing with the clicks
and cost of that day.

Note: if you store the data in a database, you better create a small
app that checks the totals - you'll notice that it gets off every now
and then. I use a period of 32 days, and still find differences every
once and while.

timprepscius

unread,
Aug 20, 2009, 11:40:08 AM8/20/09
to AdWords API Forum
Do not necessarily believe what was written by Zweitze.
I pull 3 weeks. I've seen clicks change at >2 weeks ago.

AdWords API Advisor

unread,
Aug 20, 2009, 1:06:58 PM8/20/09
to AdWords API Forum
Hi Doug,

The official statement regarding these times can be found here:
http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=14052.
While 3 hours is the minimum time suggested, we recommend waiting 4-6
hours for most reports. There are no explicit guarantees that the
reports won't change in the future, but the differences should me
minor after this point if at all.

Best,
- Eric Koleda, AdWords API Team

David Levy

unread,
Sep 2, 2009, 10:05:22 AM9/2/09
to AdWords API Forum
Hi Eric,

I read this statement and I am not sure I understood the part
regarding Conversions "Conversion tracking reports are delayed by 24
hours. ".
That means the conversions value included in the StatsRecord (from a
getCriterionStats call for instance) of day D won't be known precisely
before D+2 ? or after D+1 ?
(if D = Monday, D+1 would be Tuesday at 0AM, D+2 would be Wednesday at
0AM)

Thanks !

On 20 août, 20:06, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hi Doug,
>
> The official statement regarding these times can be found here:http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=14052.
> While 3 hours is the minimum time suggested, we recommend waiting 4-6
> hours for most reports.  There are no explicit guarantees that the
> reports won't change in the future, but the differences should me
> minor after this point if at all.
>
> Best,
> - Eric Koleda, AdWords API Team
>
> On Aug 19, 1:43 pm, doug s <dstall...@raybeam.com> wrote:
>
> > Forgive me for asking this again. I am pretty sure I did, but I can't
> > find your response.
>
> > Our application pulls daily adgroup/creative/keyword reports every
> > night for many accounts. We would like to pull them as soon as
> > possible pastmidnightso we have ample time to process them.

AdWords API Advisor

unread,
Sep 2, 2009, 3:14:48 PM9/2/09
to AdWords API Forum
Hi David,

The 24 hour delay means that Monday's conversion data may not be
complete until 12:00 AM on Wednesday. This is due to the nature of
conversions, where there is a 24 hour window allowed from click to
conversion. More information about this can be found on the AdWords
Help Center: http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=86281.
As this question relates more to core AdWords functionality than the
API, if you need further clarification I would recommend following up
on the General AdWords Forum: http://www.google.com/support/forum/p/AdWords?hl=en.

Best,
- Eric
Reply all
Reply to author
Forward
0 new messages