Hi team,

How to get CPI(cost per install) for UAC with Ads API?  The 
metrics.cost_micros can not be selected together with 
segments.conversion_action_name or segments.conversion_action_category. 
Should I query campaign cost_micros first, then query install numbers? This 
is not very convenient.

query sql:
select campaign.id, campaign.name, segments.conversion_action_category, 
metrics.conversions,  metrics.cost_micros from campaign  where  campaign.id 
= 'xxx' and  segments.date = '2020-04-10' and  metrics.conversions > 0

error:
Request ID 0fs_ACYcCmqlPooYqRfXdA failed due to GoogleAdsException. 
Underlying errors:
  Error 0: 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: 
\'cost_micros\')."

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/149177b6-dbce-4699-b9ed-5a65cbbd5524%40googlegroups.com.
  • How to get CPI(cost p... 'Dong Chen' via AdWords API and Google Ads API Forum

Reply via email to