Keyword performance Report

[Hao Long]

Hi Team,

we are working on keyword performance report migration from adwords to ads(keyword_view) api. we found there have some records existing adwords api but not in ads api. 

exception case:

account: UK_Vertical_Parts_and_Accessories_Exact_1(7390598815)

campaign: TextAds_UK_MatchType_Vertical-9300600-EXACT-Parts & Accessories-Auto - Parts-1766ec53-5fd8-47e8-b4dc-aafb425b5aa5

[Google Ads API Forum Advisor]

Hi Hao,

Thanks for reaching out. Can you please provide us with more details on this issue? For example, can you provide us with the queries that you are using from the AdWords API and the Ads API?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2VPepU:ref

[Hao Long]

Thanks Matt,

Below list the info you mentioned in previous conversation:

Google Adwords API: KEYWORDS_PERFORMANCE_REPORT

Fields list:

Date
AdGroupId
CampaignId
Id
Interactions
InteractionRate
SearchAbsoluteTopImpressionShare
SearchBudgetLostAbsoluteTopImpressionShare
SearchBudgetLostTopImpressionShare
SearchExactMatchImpressionShare
SearchImpressionShare
SearchRankLostAbsoluteTopImpressionShare
SearchRankLostImpressionShare
SearchRankLostTopImpressionShare
SearchTopImpressionShare
HistoricalQualityScore
HistoricalSearchPredictedCtr
HistoricalLandingPageQualityScore
HistoricalCreativeQualityScore

Migrated Google 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-01-20' and '2022-01-23' 

[Google Ads API Forum Advisor]

Hi Hao,

Thanks for providing the queries. Can you please provide the results for each report as well?

Can you also please verify if the Ads API reporting results match your UI?

[Hao Long]

 

we setcustomerid as 7390598815 when build google ads service and execute query as attached in previous mail i sent. compare with Adwords API there have huge data volume gap. data from Google Ads API missing lot of data, such as the ads data under below campaign:

account: UK_Vertical_Parts_and_Accessories_Exact_1(7390598815)

campaign: TextAds_UK_MatchType_Vertical-9300600-EXACT-Parts & Accessories-Auto - Parts-1766ec53-5fd8-47e8-b4dc-aafb425b5aa5

could you please help on this data issue?

[Google Ads API Forum Advisor]

Hi Hao,

Checking the UI, I see that there are ~100,000 keywords in the campaign, but just under 2,000 received an impression in the given date range. The Ads API excludes zero impressions by default when a report is segmented. This could explain why you are seeing fewer results in the Ads API report. 

Please ensure that you are excluding zero impressions in both APIs. If this is not the source of the issue, please provide us with the results from the reports, including the complete report definition.

[Hao Long]

Thanks i will have a try, to make sure align with Google Adwords API return could you please advice how to including 0 impression keywords records in Ads API?

Thanks

Hao

[Google Ads API Forum Advisor]

Hi Hao,

In the Ads API, if a report is segmented, there isn't a way to explicitly include zero impressions (via predicate, for example). 

Please let us know if you have any further questions on this.

Regards,

[Hao Long]

still trying and i have another question: if i want to get keywords structure then i could not migrate to keyword_view? cause 0 impression keywords have been filter. am right?