Hi Google Support Team, We are working on keyword_performance_report migration from AdWords to Ads API. and we found below case when we testing the download files:
1. the data download from Google AdWords API have the same records on this March 2. the data download from Google Ads API have obvious decrease compare with data download from AdWords API could you please help on below questions: 1. why AdWords returned the same records number on each day and Ads returned obvious decrease numbers? Row count compare: env date Rowcount Ads 2022-03-05 10275385 Ads 2022-03-06 10924272 Ads 2022-03-07 10831192 AdWords 2022-03-05 970981645 AdWords 2022-03-06 970981645 AdWords 2022-03-07 970981645 2. could you please help investigate some exception case(records exist AdWords but missing in Ads)? Exception cases: Date AdGroupId CampaignId ad_group_name campaign_name customer_id customer_name 2022-03-05 77712238466 6500353114 Software Ad Group (09-12-2019 04:19:50 141034206) DE Computers Campaign (09-12-2019 04:19:50 16785686) abcId: 1141446 3143963915 DE_Vertical_Fashion_Exact 3 2022-03-07 94678127908 8487092597 Parts & Accessories Adgroup (12-09-2019 00:40:44 143549496) CA EN Auto - Parts Campaign (12-09-2019 00:40:42 16861306) abcId: 1146646 6773546364 CA_Vertical_Parts_and_Accessories_Broad_1 2022-03-06 67213699423 1748512008 Wooden Toys Adgroup (03-26-2019 23:59:27 140735476) Toys Campaign (03-26-2019 23:59:27 16774476) abcId: 1140836 2535296905 eBay Electronics Text 1 2022-03-05 64636151008 1557184032 Default Adgroup (09-12-2018 13:40:49 139561076) UK Default Campaign (09-12-2018 13:40:28 16765316) abcId: 1140186 2669144749 Vertical_Null_Broad_2 2022-03-06 113663750862 12074361779 Ansichtskarten Adgoup (09-17-2019 09:21:25 141477166) DE Collectibles Campaign (09-17-2019 09:21:25 16798066) abcId: 1141576 + Geo testing GROUP C 4265469197 DE_Vertical_Parts_and_Accessories_Phrase 6 2022-03-06 86773941973 8671903874 Téléphones fixes, accessoires (12-19-2019 07:26:20 143870496) FR Telecomm Campaign (12-19-2019 07:26:20 16882186) abcId: 1151476 1317258270 FR_Vertical_Home_Garden_Phrase_3 Download detail as below: MCC account: 574-984-7778 AdWords Query: select Date AdGroupId CampaignId Id Interactions InteractionRate SearchAbsoluteTopImpressionShare SearchBudgetLostAbsoluteTopImpressionShare SearchBudgetLostTopImpressionShare SearchExactMatchImpressionShare SearchImpressionShare SearchRankLostAbsoluteTopImpressionShare SearchRankLostImpressionShare SearchRankLostTopImpressionShare SearchTopImpressionShare HistoricalQualityScore HistoricalSearchPredictedCtr HistoricalLandingPageQualityScore HistoricalCreativeQualityScore from keyword_performance_report where date between "2022-03-07" and "2022-03-09" Ads Query: select segments.date, ad_group.id, campaign.id, ad_group_criterion.criterion_id, metrics.interactions, metrics.interaction_rate, metrics.search_absolute_top_impression_share, metrics.search_budget_lost_absolute_top_impression_share, metrics.search_budget_lost_top_impression_share, metrics.search_exact_match_impression_share, metrics.search_impression_share, metrics.search_rank_lost_absolute_top_impression_share, metrics.search_rank_lost_impression_share, metrics.search_rank_lost_top_impression_share, metrics.search_top_impression_share, metrics.historical_quality_score, metrics.historical_search_predicted_ctr, metrics.historical_landing_page_quality_score, metrics.historical_creative_quality_score from keyword_view where segments.date between "2022-03-07" and "2022-03-09" and metrics.impressions >= 0 Thanks Hao -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/170068b7-08d5-45b8-9294-1b846cbbb364n%40googlegroups.com.
