Compare periods via AWQL

[Sasha Matijasic]

Hi,

is it possible to have compare to previous period option via AWQL?

For example, in a query like this:

select CampaignName, Clicks from CAMPAIGN_PERFORMANCE_REPORT

where Status = ACTIVE and Impressions > 0

during LAST_MONTH

I get Clicks for the given period. In AdWords GUI, I can turn on Compare mode and select Previous period (or same period last year or custom) and get clicks for comparison period.

I haven't found the same option in API.

Am I missing something or should I simply execute 2 queries, one for each time period?

Thanks,

sasha

[Michael Cloonan (AdWords API Team)]

Hello Sasha,

There is no way to provide these automatic comparisons via the AdWords API. You can work around this like you suggested by running multiple reports, one for each time period. Alternatively, if the time periods are contiguous, you can still get all the data at once and segregate it programmatically by the Date on each given line.

Regards,

Mike, AdWords API Team

[Will Atkins]

Hi there,

I know this comment is old, but I still have the same question.

Can a compare to range be specified when downloading a report?

Is this something that may be available in the future?  I looked through the Beta documentation and didn't spot it, would be a nice feature to have and would cut down on the amount of requests?

Thanks,

Will

[Dhanya Sundararaju (AdWords API Team)]

Hi Will,

Via API, when downloading a report, compare to range is not available. Currently, this feature is not available in Google Ads API v0, either. However, this is a popular request and our team is looking into the possibility of exposing via API. But, unfortunately, I cannot comment on any timelines for this feature. Please do keep an eye on our blog for any updates or announcements about upcoming releases. 

Regards,
Dhanya, AdWords API Team