So there's no ambiguity, this is the query we were using in AdWords API: SELECT ExternalCustomerId, Date, AdNetworkType1, Device, ConversionTypeName, ConversionCategoryName, Conversions, ConversionRate, CostPerConversion FROM ACCOUNT_PERFORMANCE_REPORT DURING LAST_30_DAYS
On Monday, December 7, 2020 at 12:42:49 PM UTC-5 Pete Lavetsky (AdWords API Guru) wrote: > 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/463429cd-5809-4ebe-9e2c-d544bc439f48n%40googlegroups.com.
