Report of Keywords does not match result in Google Ads UI

[Nikita Kulik]

Im using this query to pull conversions data

SELECT

segments.date,

campaign.id,

ad_group.id,

segments.conversion_action,

segments.conversion_action_name,

segments.external_conversion_source,

customer.id,

keyword_view.resource_name,

segments.ad_network_type,

ad_group.name,

ad_group.status,

campaign.name,

campaign.status,

campaign.advertising_channel_type,

segments.conversion_action_category,

ad_group_criterion.keyword.text,

ad_group_criterion.keyword.match_type,

ad_group_criterion.status,

metrics.conversions_value,

metrics.all_conversions_value,

metrics.all_conversions,

metrics.conversions,

metrics.view_through_conversions,

ad_group.labels

FROM keyword_view

WHERE segments.date BETWEEN '2021-01-01' AND '2022-04-30'

but in response there is missing one ad group with 6 conversions, which I can get using other than keyword_view resource. And which I see in UI

[Google Ads API Forum Advisor]

Hi,

Thanks for reaching out to us.

Could you provide us with the complete request and response logs with the request-id, so our teacan better check?If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Thanks,

Nirmita Google Ads API Team

 

ref:_00D1U1174p._5004Q2aRACn:ref