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

[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 
documentation
 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

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

[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