Integer Id fields in GEO_PERFORMANCE_REPORT

[Devesh Parekh]

According to https://developers.google.com/adwords/api/docs/appendix/reports#geo, CountryCriteriaId and RegionCriteriaId should be Integers, but the when I send an AWQL query to the reportdownload endpoint (https://adwords.google.com/api/adwords/reportdownload/v201306) to return those fields, I get Strings. Example query: SELECT CountryCriteriaId, RegionCriteriaId, Impressions FROM GEO_PERFORMANCE_REPORT DURING 20130101,20130723

Can you make them Integers?

-- 
Devesh

[Takeshi Hagikura (AdWords API Team)]

Hi, 

Was there a non numerical value for Id field?

If not, you can map it to Integers in a programing language. 
Basically the result is returned as CSV or XML as you specified when you download a report.

Best,

- Takeshi, 

[Devesh Parekh]

Hi Takeshi,

Yes, all the values for these ID fields are non-numerical (like "Ireland" and "Cork"), and you can verify it by running the example query I provided. According to the documentation, these should be Integers, and I would much prefer to have the report behave as documented instead of as the way it currently behaves.

-- 
Devesh

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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 a topic in the Google Groups "AdWords API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/EiGdtzXY30s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Takeshi Hagikura (AdWords API Team)]

Hi Devesh,

Thanks. Confirmed the situation. 

Escalated a request to fix the fieldType to String. 

Best,

- Takeshi, AdWords API Team

[Devesh Parekh]

Thanks, Takeshi. Can you also request that they add integer id fields to the report?

-- 

Devesh

[Devesh Parekh]

Hi Takeshi,

This bug is causing the reporting endpoint to return data that I cannot automatically map to an ID. For example, when I run "SELECT CityCriteriaId, MetroCriteriaId, RegionCriteriaId, CountryCriteriaId, MostSpecificCriteriaId, Impressions,Clicks FROM GEO_PERFORMANCE_REPORT WHERE AdGroupId=8385025797 DURING 20140501,20140515", I get the following two rows, which are referring to two different Zacatecas, but I can't tell which Zacatecas by reading the report:

Unspecified,,Zacatecas,Mexico,Zacatecas,---,---

Unspecified,,Zacatecas,Mexico,Zacatecas,---,---

If the report returned integer IDs like the documentation says (https://developers.google.com/adwords/api/docs/appendix/reports#geo), I would know which Zacatecas each line is referring to.

-- 
Devesh

[Josh Radcliff (AdWords API Team)]

Hi Devesh,

I've submitted a separate enhancement request to add fields for the Long IDs to the report. We may not switch the meaning of the existing fields since that could cause problems for developers who are expecting a combination of Long and String values in those fields. I'll post here when I have updates on either issue.

Cheers,

Josh, AdWords API Team

[Devesh Parekh]

Thanks, Josh. Can you add the CLICK_PERFORMANCE_REPORT to the enhancement request as well?

-- 
Devesh

[Josh Radcliff (AdWords API Team)]

Hi Devesh,

Good point -- I have updated the request to include CLICK_PERFORMANCE_REPORT.

Cheers,

Josh, AdWords API Team

[peter.r...@smarter-ecommerce.com]

Hi 

It would help us if you fix the data type in the report reference as well as in the report reference CSV files to download. We use this information to generate some stuff and have to change the datatype each time we update our Adwords API versions. 

Thanks! 

Peter