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 On Monday, July 29, 2013 11:18:03 AM UTC-7, Devesh Parekh wrote: > > Thanks, Takeshi. Can you also request that they add integer id fields to > the report? > > -- > Devesh > > On Sunday, July 28, 2013 11:45:08 PM UTC-7, Takeshi Hagikura (AdWords API > Team) wrote: >> >> Hi Devesh, >> >> Thanks. Confirmed the situation. >> Escalated a request to fix the fieldType to String. >> >> Best, >> - Takeshi, AdWords API Team >> >> On Saturday, July 27, 2013 3:10:21 AM UTC+9, Devesh Parekh wrote: >>> >>> 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 >>> >>> >>> On Thu, Jul 25, 2013 at 10:49 PM, Takeshi Hagikura (AdWords API Team) < >>> adwordsapiad...@google.com> wrote: >>> >>>> 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, >>>> >>>> On Wednesday, July 24, 2013 9:19:34 AM UTC+9, Devesh Parekh wrote: >>>>> >>>>> 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 >>>>> >>>> -- >>>> -- >>>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ >>>> 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. >>>> >>>> >>>> >>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/d/optout.
