Campaign performance report. Filter by performance comparison for different dates.

[Александр Великий]

Hello,

I'm trying to get a report of Campaigns with cost two days bofore larger then one day before (yesterday). It there a way to do it via AWQL query or I will need to run two queries and then filter them on my side?

[Shwetha Vastrad (AdWords API Team)]

Hi Alex,

You can include the "Date" field in the AWQL query to segment the report data by date and specify the DateRange during which you want to get data. This way you'll be able to get the statistics segmented for each date in a single report. 

Regards,

Shwetha, AdWords API Team.

[Александр Великий]

Thank you,

But is there a way to filter it that way I specified?

[Shwetha Vastrad (AdWords API Team)]

Hi Alex,

I'm afraid filtering results that way is not possible. You can specify a particular value to filter for rows based on cost but you can't add a filter to get campaigns where cost for two days before is larger that the cost of the previous day.