Hi Adwords API Team, I have stumbled across this old thread after observing exactly the same geo missmatching issue between downloading our Click_performance_report data and our geo_performance_report data.
A separate, related, thread states that this issue was resolved in one of the 2014 Adwords API releases. Of cours that doesn;t seem to be the case in our Adwords API data downloads. Can someone on your team investigate our issue if possible? What IDs do you need from me to do so? Regards, Sean On Thursday, 23 January 2014 19:58:41 UTC, Josh Radcliff (AdWords API Team) wrote: > > Hi Hazar, > > One alternate idea for meeting your use case would be to upload your > transaction ID by click ID as an offline conversion > <https://developers.google.com/adwords/api/docs/reference/v201309/OfflineConversionFeedService.OfflineConversionFeed>. > > After uploading these conversions you could then use the *Geo > Performance Report* and include *ConversionTypeName* and *ConversionValue* > in the list of fields. This would eliminate the need for data from the > Click Performance Report altogether, provided you are ultimately interested > in seeing data at the transaction ID level. > > Would that approach work for you? > > Thanks, > Josh, AdWords API Team > > On Wednesday, January 22, 2014 11:48:46 AM UTC-5, Josh Radcliff (AdWords > API Team) wrote: >> >> Hi, >> >> I ran both reports for your campaign and adgroup and I verified there are >> some differences between the two, specifically on the *Metro area* and >> *City* fields. We're looking into this and I will post back when I have >> an update. One thing to note is that the Geo Performance Report also >> includes impressions, so when testing I included a *Predicate* that >> filtered to *Clicks > 0*. With that filter in place I was able to tie >> the # of clicks between the two reports and identify the rows with >> mismatched values. >> >> As mentioned previously, there is currently an issue with the Ad ID >> (AdGroupCreativeId) in the Click Performance Report. As a result, the ID >> returned will not tie back to Ad ID values in other reports. We're aware >> of this one as well and are working on it. >> >> Best regards, >> Josh, AdWords API Team >> >> On Saturday, January 4, 2014 6:16:02 AM UTC-5, Ittai Chorev wrote: >>> >>> Hi, >>> >>> We've also seen this problem and have posted about it a few months ago: >>> https://groups.google.com/d/msg/adwords-api/faoaijq2xjo/9lmhrWiYoUAJ >>> >>> The Click Performance Report reports incorrect Geos and incorred >>> AdGroupCreativeId. >>> >>> I think it would be a good idea to note the bug in the documentation if >>> there's no plan on fixing it soon. It's a pity that we're all wasting time >>> on known bugs. >>> (Of course actually fixing it would be a lot more preferable!) >>> >>> Ittai >>> >>> On Friday, January 3, 2014 5:33:28 PM UTC+2, Josh Radcliff (AdWords API >>> Team) wrote: >>>> >>>> Hi, >>>> >>>> Could you send over the reporting requests you are using for each of >>>> the reports (please make sure to remove any sensitive data such as refresh >>>> or access tokens, client secret, etc.). It would also help to know the >>>> customer ID of the accounts you are querying. You can send this *only >>>> to me* by clicking *Reply to author*. >>>> >>>> Thanks, >>>> Josh, AdWords API Team >>>> >>>> On Thursday, December 26, 2013 5:30:25 AM UTC-5, Hazar Hayat wrote: >>>>> >>>>> I am using GoogleClickID from CLICK_PERFORMANCE_REPORT to get my user >>>>> locations against the revenue. >>>>> >>>>> I am using GEO_PERFORMANCE_REPORT to get clicks and cost data on user >>>>> locations. >>>>> >>>>> I am using the following query to join both the reports. >>>>> >>>>> select >>>>> >>>>> a.ClientID,a.CampaignID,a.AdGroupID,a.Country,a.Metro,a.Region,a.City,b.Country,b.Metro,b.Region,b.City >>>>> >>>>> from GEO_PERFORMANCE_REPORT a >>>>> join CLICK_PERFORMANCE_REPORT b on a.ClientID=b.ClientID and >>>>> a.CampaignID=b.CampaignID and a.AdGroupID=b.AdGroupID >>>>> and a.Country=b.Country and a.Metro=b.Metro and a.Region=b.Region and >>>>> a.City=b.City >>>>> where Clicks>0 >>>>> >>>>> After reviewing the results i see that some clicks data from >>>>> GEO_PERFORMANCE_REPORT is missing in the CLICK_PERFORMANCE_REPORT. >>>>> >>>>> For example for ClientId=xxx and CampaignId=yyy and AdgroupId=zzz we >>>>> have the following data in the GEO_PERFORMANCE_REPORT >>>>> >>>>> >>>>> >>>>> Day >>>>> >>>>> ClientId >>>>> >>>>> CampaignId >>>>> >>>>> AdgroupId >>>>> >>>>> Country >>>>> >>>>> Metro >>>>> >>>>> Region >>>>> >>>>> City >>>>> >>>>> Clicks >>>>> >>>>> 12/10/2013 0:00 >>>>> >>>>> xxx >>>>> >>>>> yyy >>>>> >>>>> zzz >>>>> >>>>> United States >>>>> >>>>> Arizona >>>>> >>>>> Tucson >>>>> >>>>> 1 >>>>> >>>>> >>>>> >>>>> And for the same ad group we have the following data in the >>>>> CLICK_PERFORMANCE_REPORT. >>>>> >>>>> >>>>> Day >>>>> >>>>> ClientId >>>>> >>>>> CampaignId >>>>> >>>>> AdgroupId >>>>> >>>>> Country >>>>> >>>>> Metro >>>>> >>>>> Region >>>>> >>>>> City >>>>> >>>>> 12/10/2013 0:00 >>>>> >>>>> xxx >>>>> >>>>> yyy >>>>> >>>>> zzz >>>>> >>>>> United States >>>>> >>>>> Minnesota >>>>> >>>>> Unspecified >>>>> >>>>> Is there any reason why all clicks data is not present in the >>>>> CLICK_PERFORMANCE_REPORT or there is any mismatch in the location data of >>>>> the both the reports. >>>>> >>>>> Thanks >>>>> Regards >>>>> >>>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/b90f23a3-2768-40d3-81f0-b784cf7bb846%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
