PROHIBITED SEGMENT WITH METRIC

[Jessie]

Hi,

Using Google Ads api, I was trying to query a table group_placement_view to build a report, but the problem is I'm getting the error message below.

errors {

  error_code {

    query_error: PROHIBITED_SEGMENT_WITH_METRIC_IN_SELECT_OR_WHERE_CLAUSE

  }

  message: "Cannot select the following segments because at least one unsupported metric is found in SELECT or WHERE clause: \'segments.conversion_action_category\'(unsupported metrics: \'average_cpv\', \'conversions_from_interactions_rate\', \'engagement_rate\', \'average_cost\', \'active_view_impressions\', \'active_view_measurable_cost_micros\', \'interaction_event_types\', \'interactions\', \'cost_micros\', \'video_views\', \'active_view_ctr\', \'cost_per_all_conversions\', \'active_view_measurable_impressions\', \'engagements\', \'all_conversions_from_interactions_rate\', \'cost_per_conversion\', \'ctr\', \'interaction_rate\', \'active_view_cpm\', \'impressions\', \'active_view_viewability\', \'video_view_rate\', \'active_view_measurability\', \'average_cpc\', \'clicks\', \'average_cpm\')."

}

Thanks,

Jessie

[Google Ads API Forum Advisor Prod]

Hi Jessie,

Thank you for reaching out. The PROHIBITED_SEGMENT_WITH_METRIC_IN_SELECT_OR_WHERE_CLAUSE is encountered because a segment may have been included together with a metric that it is incompatible with in the SELECT or WHERE clause. 

Indeed, in the group_placement_view, the available metrics are those under the Metrics dropdown, however, not all of those metrics are compatible when included with the segments.conversion_action_category field. To learn which metrics you can use alongside the said segment field, you may refer to this documentation.

I hope this helps and feel free to write back if you have any further clarifications.

Thanks and regards,
Peter
Google Ads API Team

ref:_00D1U1174p._5001UAqnYC:ref