Re: Daily breakdowns with AWQL

2016-01-22 Thread 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 !




Le mardi 19 janvier 2016 14:59:13 UTC+1, Olof Nilsson a écrit :
>
> 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
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/fd658602-f74b-48f8-97ac-0d494dd8822e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Daily breakdowns with AWQL

2016-01-19 Thread 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. 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/21cfa206-a5f4-4d35-a38c-c7290cbc95af%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Daily breakdowns with AWQL

2016-01-19 Thread 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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/bcb58001-f700-4da5-95f2-17cb8605da22%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.