Actually I am using ad hoc report to download all the AdWord's objects like Campaign, Ad Groups, Advertises, and Keywords. For example to download Campaigns object, iam using Campaign Performance Report. (https://developers.google.com/adwords/api/docs/appendix/reports) I am only requesting for campaign's attributes, not metrics.
<reportDefinition><selector><fields>CampaignId</fields><fields>CampaignName</fields><fields>ExactMatchImpressionShare</fields><fields>BudgetLostImpressionShare</fields><fields>ImpressionShare</fields><fields>QualityLostImpressionShare</fields><fields>Date</fields><dateRange><min>{min.date}</min><max>{max.date}</max></dateRange></selector><reportName>Custom Campaign Report</reportName><reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat></reportDefinition> Then I download the metrics using Ad Performance Report with all the adword's object id (https://developers.google.com/adwords/api/docs/appendix/reports) <reportDefinition><selector><fields>AdGroupId</fields><fields>CampaignId</fields><fields>Id</fields><fields>KeywordId</fields><fields>Clicks</fields><fields>Impressions</fields><fields>Cost</fields><fields>AverageCpc</fields><fields>AverageCpm</fields><fields>AveragePosition</fields><fields>Ctr</fields><fields>Conversions</fields><fields>CostPerConversion</fields><fields>ConversionRate</fields><dateRange><min>{min.date}</min><max>{max.date}</max></dateRange></selector><reportName>Custom Ads Stats Report</reportName><reportType>AD_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat></reportDefinition> When I join both results and make a group by campaign id.I get the metrics for all the campaigns and this works great with Campaigns and AdGroups. But when I try this with Ads or Keywords it does not work. In case of Advertises I get less Ads than the AdWord's Platform (adwords.google.com) and in case of Keywords, my keywords does not join with my stats. In addition I get one keyword named 'Content', which it does not appear in the platform. If my campaign have 60 keywords, i get 61 with that keyword and that have a lot of stats/metrics. Why does it work with campaign, adgroup but doesn't with the rest of the reports? Is there any other way to get these reports ? Thanks in advance Regards Ad Peformance Request: <reportDefinition><selector><fields>AdGroupId</fields><fields>CampaignId</fields><fields>KeywordId</fields><fields>Id</fields><fields>Cost</fields><fields>AdNetworkType1</fields><fields>Headline</fields><fields>Status</fields><fields>CreativeDestinationUrl</fields><fields>DisplayUrl</fields><fields>ImageAdUrl</fields><fields>Description1</fields><fields>Description2</fields><fields>ImageCreativeName</fields><fields>AdType</fields><fields>CreativeApprovalStatus</fields><dateRange><min>{min.date}</min><max>{max.date}</max></dateRange></selector><reportName>Custom AD Report</reportName><reportType>AD_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat><includeZeroImpressions>true</includeZeroImpressions></reportDefinition> Query : select ag.name as 'adgroupName', ad.head_line as 'head_line', ad.description_line1 as 'description_line1', ad.description_line2 as 'description_line2', ad.display_url as 'display_url', ad.ad_approval_status as 'adApprovalStatus', ad.image_url as 'image_url', SUM(s.impressions) as 'impressions', SUM(clicks) as 'clicks', SUM(s.clicks)/SUM(s.impressions) as 'ctr', (SUM(s.avg_position * s.impressions)/SUM(s.impressions)) as 'position', SUM (s.cost) as 'cost' from adwords_advertises ad inner join adwords_stats s on s.ad_id = ad.ad_id and s.adgroup_id = ad.adgroup_id and s.campaign_id = ad.campaign_id and s.keyword_id = ad.keyword_id and s.date between @from and @to inner join adwords_adgroups ag on s.adgroup_id = ag.adgroup_id and s.campaign_id = ag.campaign_id inner join adwords_campaign_detail c on s.campaign_id = c.campaign_id AND c.fox_intelligence_id = @fox_id group by ag.name, ad.ad_approval_status, ad.image_url,ad.head_line,ad.description_line1,ad.description_line2,ad.display_url KeyWord Request: <reportDefinition><selector><fields>Id</fields><fields>AdGroupId</fields><fields>CampaignId</fields><fields>KeywordText</fields><fields>Status</fields><fields>DestinationUrl</fields><dateRange><min>{min.date}</min><max>{max.date}</max></dateRange></selector><reportName>Custom Keywords Report</reportName><reportType>KEYWORDS_PERFORMANCE_REPORT</reportType><dateRangeType>CUSTOM_DATE</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat></reportDefinition> Keyword Query: select acd.fox_intelligence_id as 'fox_id', ak.keyword as 'keyword', acd.campaign_status as 'campaignStatus', COALESCE(SUM(astats.impressions),0) as 'impressions', COALESCE(SUM(astats.clicks),0) as 'clicks', COALESCE(SUM(astats.clicks)/SUM(astats.impressions) ,0) as 'ctr', COALESCE(AVG(astats.avg_cpc),0) as 'cpc', COALESCE(AVG(astats.avg_cpm),0) as 'cpm', COALESCE(AVG(astats.conv1_per_click) ,0) as 'convertion', COALESCE(SUM(astats.cost),0) as 'cost', COALESCE(SUM(astats.avg_position * astats.impressions)/sum(astats.impressions) ,0) as 'position', ak.keyword_state as 'keywordStatus', ag.name as 'adgroupName', ag.status as 'adgroupStatus' from adwords_campaign_detail acd inner join adwords_adgroups ag on acd.campaign_id=ag.campaign_id inner join adwords_keywords ak on ak.adgroup_id = ag.adgroup_id and ak.campaign_id = acd.campaign_id left outer join adwords_stats astats on astats.campaign_id=acd.campaign_id and astats.keyword_id=ak.keyword_id and astats.adgroup_id=ag.adgroup_id and astats.date between @from and @to where acd.fox_intelligence_id = @fox_id group by acd.fox_intelligence_id,ak.keyword,acd.campaign_status,ak.keyword_state,ag.name,ag.status -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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.