Weekly Data Ending on Saturday?

[Mark Hansen]

Our AdWords API application pulls weekly data from a variety of reports (e.g., Campaign Performance Report) using the week field: https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report#week

By default, this weekly data is reported for weeks ending on Sunday (starting on Monday).

Is there a way to get the data segmented by week ending on Saturday instead?  

By comparison, the Google Analytics API provides the ga:week dimension for weeks ending on Saturday and ga:isoWeek for weeks ending on Sunday.

[Umesh Dengale]

Hello,

Currently, there is no way to change the Week field definition. If you need a different definition of the Week then you'd want to include the Date field instead and aggregate the data accordingly on your side.

Thanks,

Umesh, AdWords API Team.

[Mark Hansen]

Thanks Umesh - that makes sense.  However some daily data (using Date field) cannot be aggregated into weekly, such as Avg. Pos. Is there any way to calculate Avg. Pos. for a week ending on Saturday?

-- Mark

[Umesh Dengale]

Hi Mark,

You should be able to pull the report specifying a custom date range including the days you are interested in and no other segmentation fields need to be specified.

[Mark Hansen]

Hi Umesh,

Yes, but if I want to get the last 52 weeks (ending on Saturday) for Avg. Pos., then I need to make 52 queries - don't I?  Then, that does not scale very well across multiple accounts and campaigns.

I get your point - but I'm just wondering if there is a more efficient way to get week ending on Saturday for Avg. Pos. without having to run a separate query for each week.

Thanks,

Mark

[Michael Cloonan (AdWords API Team)]

Hello Mark,

Unfortunately, there is no way to customize which day of the week the Week field starts on, nor is there an alternative field that starts on Sunday rather than Monday. I apologize for the inconvenience.

Regards,

Mike, AdWords API Team

[Mark Hansen]

OK, Thanks Mike and Umesh for explaining this to me.  So, Google Analytics provides two versions of week: ga:isoWeek and ga:week for ending on Saturday vs. Sunday.  It would be nice to see something similar in AdWords.