how to get the monetary unit of metrics.average_cpc(such as $/¥)

29 views
Skip to first unread message

倪长春

unread,
Oct 14, 2020, 11:13:15 PM10/14/20
to AdWords API and Google Ads API Forum
Hi Sir, this is what I urgently need to solve, and I really hope to get your help, thank you very much.
I am trying to query something with this method: 
SELECT metrics.impressions, metrics.clicks, metrics.ctr, metrics.average_cpc, metrics.cost_micros FROM ad_group_ad " 
Excuse me, how can I get the monetary unit of metrics.average_cpc and metrics.cost_micros?

Google Ads API Forum Advisor Prod

unread,
Oct 15, 2020, 11:43:29 AM10/15/20
to loonx...@gmail.com, adwor...@googlegroups.com

Hi Changchun, 

Thank you for reaching out. The monetary unit returned for the query is based on the currency setup of the client customer account. You could query the customer.currency_code from the customer resource and then query currency_constant.symbol from currency_constant resource to get the currency symbol. You could also map the currency code to the currency symbol using this table

Thanks and regards,
Xiaoming, Google Ads API Team


Google Logo
Xiaoming
Google Ads API Team
 


ref:_00D1U1174p._5004Q269Ptz:ref
Reply all
Reply to author
Forward
0 new messages