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 discussion group: http://googleadsdeveloper.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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
