Keywords Data Not matched in Ads API and Adwords API

[cv]

Hi,

I can see that few keywords are not fetched through Ads API.

I was trying to do query in Adwords API and Matching data with Ads API.

Adwords API is giving 92 keywords where as Ads API is giving only 77

Why this Different?

AWQL:

SELECT Id, Criteria, KeywordMatchType, CampaignId, CampaignName, AdGroupId, AdGroupName, QualityScore, Impressions, Clicks, Conversions, ConversionValue FROM KEYWORDS_PERFORMANCE_REPORT WHERE Id NOT_IN [3000000, 3000006] AND Status = 'ENABLED' AND AdGroupStatus = 'ENABLED' AND CampaignStatus = 'ENABLED' AND AdNetworkType2 = 'SEARCH' AND CampaignStatus = 'ENABLED' AND AdGroupStatus = 'ENABLED' AND Status = 'ENABLED' DURING LAST_30_DAYS

GAQL:

SELECT ad_group_criterion.criterion_id, ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type, campaign.id, campaign.name, ad_group.id, ad_group.name, ad_group_criterion.quality_info.quality_score, metrics.impressions, metrics.clicks, metrics.conversions, metrics.conversions_value, segments.ad_network_type FROM keyword_view WHERE ad_group_criterion.criterion_id NOT IN (3000000,3000006) AND ad_group_criterion.status = "ENABLED" AND ad_group.status = "ENABLED" AND campaign.status = "ENABLED" AND segments.ad_network_type = "SEARCH" AND campaign.status = "ENABLED" AND ad_group.status = "ENABLED" AND ad_group_criterion.status = "ENABLED" AND segments.date DURING LAST_30_DAYS

Thanks,

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for raising your concern.

The possible reason why few keywords are not fetched in Google Ads API is because segment fields are included in the SELECT clause of GAQL. Please note that rows with zero impressions are always excluded when segmenting a Google Ads API report according to this guide.

With this, could you try removing the segment fields in the Google Ads API reporting and try to compare again the 2 reports?

However, before doing the above suggestion, could you provide the following details via Reply privately to author option to further investigate?

• Customer ID
• Complete report definition used in AdWords API reporting
• Complete request and response logs (with the request-id)

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2Dv0Kc:ref