Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[peter . rietzler]

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


Am Dienstag, 20. Mai 2014 23:11:44 UTC+2 schrieb 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
>
> On Monday, May 19, 2014 8:25:37 PM UTC-4, Devesh Parekh wrote:
>>
>> 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) 
>  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/
h

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[Josh Radcliff (AdWords API Team)]

Hi Devesh,

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

Cheers,
Josh, AdWords API Team

On Monday, June 2, 2014 9:13:22 PM UTC-4, Devesh Parekh wrote:
>
> Thanks, Josh. Can you add the CLICK_PERFORMANCE_REPORT to the enhancement 
> request as well?
>
> -- 
> Devesh
>
> On Tuesday, May 20, 2014 2:11:44 PM UTC-7, Josh Radcliff (AdWords API 
> Team) wrote:
>>
>> 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
>>
>> On Monday, May 19, 2014 8:25:37 PM UTC-4, Devesh Parekh wrote:
>>>
>>> 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) 
>>  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.
>>>  
>>

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[Devesh Parekh]

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

-- 
Devesh

On Tuesday, May 20, 2014 2:11:44 PM UTC-7, Josh Radcliff (AdWords API Team) 
wrote:
>
> 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
>
> On Monday, May 19, 2014 8:25:37 PM UTC-4, Devesh Parekh wrote:
>>
>> 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) 
>  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
Grou

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[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

On Monday, May 19, 2014 8:25:37 PM UTC-4, Devesh Parekh wrote:
>
> 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 becau

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[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

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.

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[Devesh Parekh]

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

--- 
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/groups/opt_out.

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[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

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

--- 
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/groups/opt_out.

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

[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


On Thu, Jul 25, 2013 at 10:49 PM, Takeshi Hagikura (AdWords API Team) <
adwordsapiadvisor+take...@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 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 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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

--- 
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/groups/opt_out.

Re: Integer Id fields in GEO_PERFORMANCE_REPORT

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

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 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/groups/opt_out.

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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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

--- 
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/groups/opt_out.