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.
