Hi Abraham, Thanks for that insight.
As stated, we're attempting to migrate the last of our reports over from AdWords API to Ads API. As a more basic example lets talk about migrating our ACCOUNT_PERFORMANCE_REPORT ( https://developers.google.com/google-ads/api/docs/migration/reports#account_performance ) Here's our query using the new fields from the migration documentation. Keep in mind this exact same query, using the AdWords API fields, worked. All we've done is change the fields over to the Ads API corresponding fields. query: "select customer.id, segments.date, segments.ad_network_type, segments.device, segments.conversion_action_name, segments.conversion_action_category, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.cost_per_conversion from customer where segments.date DURING LAST_30_DAYS " And we get the same PROHIBITED_SEGMENT_WITH_METRIC_IN_SELECT_OR_WHERE_CLAUSE error, which as you've pointed out is a valid error. Just to confirm, specific field combinations that worked in the AdWords API no longer work in the Ads API correct? Assuming the above is true, how are we to construct a query that will allow us to get metrics.conversions_from_interactions_rate and metrics.cost_per_conversion segmented by their segments.conversion_action_name or segments.conversion_action_category? ie. how do we get Google to tell us our Cost per Conversion for specific Conversion Action names or Conversion Action categories? Thanks Pete On Wednesday, December 2, 2020 at 10:52:39 AM UTC-5 adsapiforumadvisor wrote: > Hello Pete, > > Thank you for reaching out to Google Ads API support. > > The PROHIBITED_SEGMENT_WITH_METRIC_IN_SELECT_OR_WHERE_CLAUSE QueryError > <https://developers.google.com/google-ads/api/reference/rpc/v6/QueryErrorEnum.QueryError#prohibited_segment_with_metric_in_select_or_where_clause> > occurs > when a field in the SELECT clause is not selectable with another field in > the SELECT (or WHERE) clause. This is a different requirement than when > "campaign" is specified in the FROM clause. > > You can see the fields/resources segments.conversion_action_category > <https://developers.google.com/google-ads/api/fields/v6/segments#segments.conversion_action_category> > is > compatible with by expanding "selectable with" > <https://developers.google.com/google-ads/api/fields/v6/segments#segments.conversion_action_category>. > > In your query "segments.conversion_action_category" and > "segments.conversion_action_name" are not selectable with > "metrics.conversions_from_interactions_rate" or > "metrics.cost_per_conversion" in the same SELECT clause. > > Please let us know if you have any further questions. > > Regards, > Abraham > [image: Google Logo] > Abraham Williams > Google Ads API Team > > > ref:_00D1U1174p._5004Q28lroo:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/56b30079-0d94-4f3a-b859-27c94e39ff43n%40googlegroups.com.
