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