I am trying to request conversion_action.category alongside other metrics like this but am facing en error with the field conversion_action.category. Is there any way to extract this field alongside the other metrics, a key on wich i can join 2 reqs?

[canetti axel-bryan]

Hi, 

I'm trying to extract informations about campaigns and encounter a problem with this request : 

SELECT

  segments.date,

  campaign.name,

  ad_group_criterion.keyword.text,

  ad_group_criterion.labels,

  ad_group_criterion.criterion_id,

  metrics.impressions,

  metrics.conversions,

  metrics.average_cpc,

  metrics.clicks,

  metrics.ctr,

  metrics.cost_micros,

  metrics.cost_per_all_conversions,

  metrics.cost_per_conversion,

segments.conversion_action_category

FROM

  keyword_view

WHERE

  segments.date DURING LAST_30_DAYS

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API team.

I understand that you are encountering an issue while executing the query. After checking the query using Query Validator, I found that it is invalid. Kindly note that the Google Ads API only reflects the Google Ads UI. If the fields are not compatible or selectable in the UI for a particular report, then I'm afraid that it is also not possible in the API. Furthermore, report types aggregate data at different levels so we don't recommend combining data from different reports for analysis. I suggest to continue using the Query Validator and Query Builder tools to easily build valid queries.

On the other hand, if you are able to generate the exact report in the UI, then kindly provide a uncropped UI screenshot (with visible customer Id) so we can further investigate.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rzt05:ref" (ADR-00226996)

Thanks,
 

Google Ads API Team