Question on keyword_performance_report migration

[Hao Long]

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

[Google Ads API Forum Advisor]

Hi Hao,

Thank you for reaching out.

With regards to your concern, it looks like we have a separate thread for this issue. We can keep correspondence related to this issue on the other thread to limit any confusion.

Thanks,

Nirmita Google Ads API Team

 

ref:_00D1U1174p._5004Q2YpAr8:ref