Daily breakdowns with AWQL

[Olof Nilsson]

Hi!

I'm using the AdWords API to pull performance data from the Budget Performance Report in python:    

# Create report query.

report_query = ('SELECT AssociatedCampaignName, ConvertedClicks, Cost '

                    'FROM BUDGET_PERFORMANCE_REPORT '

                    'WHERE Cost > 0 '

                    'DURING {START}, {END}')

I've tried to find information as to wether there is any way to get this with a daily breakdown (one row per date) instead of aggregated over the whole period {START} -> {END}?

If not, is this possible using any other of the performance reports?

/Olof

[Yin Niu]

Hello, 

You won't be able to get daily breakdown using Budget Performance Report. You might want to take a look at Campaign performance report which has BudgetId field. 

Thanks,

Yin, AdWords API Team. 

[bastien rabaute]

Hi Olof,

This query works for me. Similar to what you need I hope.

select

Date, CampaignName, ConvertedClicks, Cost

from CAMPAIGN_PERFORMANCE_REPORT

WHERE Cost > 0

during 20150101,20150201

Bastien

Try AWQL.me for your AWQL queries. It's free !