Reporting: Get aggregated account statistics per day - DAY not supported as field?

2013-01-14 Thread Manuel Th
I am trying to get account statistics aggregated by each day in the last 7 
days. I thought this would be possible by adding Day, Month and Year as a 
field in my awql query, but it gives me a 
ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT error although the 
fields are defined in the report document. How do I do this? Thanks

I am using the following query:

SELECT
Clicks, Cost, Impressions, Conversions, Day, Month, Year
FROM ACCOUNT_PERFORMANCE_REPORT
 DURING LAST_7_DAYS


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

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





Re: Reporting: Get aggregated account statistics per day - DAY not supported as field?

2013-01-14 Thread David Torres (AdWords API Team)
Hi,

The name of the field you should use in your report query is the one 
defined in the first column of the 
documentationhttps://developers.google.com/adwords/api/docs/appendix/reports#account
 tables. 
I believe your problem is that you are using *day* when it should be *date.*
*
*
Best,

- David Torres - AdWords API Team

On Friday, January 11, 2013 9:42:17 AM UTC-5, Manuel Th wrote:

 I am trying to get account statistics aggregated by each day in the last 7 
 days. I thought this would be possible by adding Day, Month and Year as a 
 field in my awql query, but it gives me a 
 ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT error although the 
 fields are defined in the report document. How do I do this? Thanks

 I am using the following query:

 SELECT
 Clicks, Cost, Impressions, Conversions, Day, Month, Year
 FROM ACCOUNT_PERFORMANCE_REPORT
  DURING LAST_7_DAYS




-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

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