I am currently using Api V201209. El viernes, 5 de abril de 2013 17:05:58 UTC-3, Federico J. Sutin Citterio escribió: > > 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 [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.
