Unable to find the right metrics for Total Cost, Converted Clicks, Cost/Converted Click etc

258 views
Skip to first unread message

anirudh maddy

unread,
May 28, 2019, 2:38:41 AM5/28/19
to AdWords API and Google Ads API Forum

This is what I'm doing currently. I need to show data campaigns wise as well as cumulative results. 
 
My query goes something like this :

"query": "SELECT  customer.currency_code, metrics.impressions, metrics.clicks, metrics.ctr, metrics.conversions, metrics.all_conversions        , metrics.cost_per_conversion   ,metrics.cost_per_all_conversions, metrics.all_conversions_value, metrics.conversions_value,  metrics.current_model_attributed_conversions_from_interactions_rate FROM campaign WHERE segments.date >= '"+fromDate +"' AND segments.date <= '"+ toDate +"' ORDER BY campaign.start_date ASC"

I'm unable to figure out which metrics I must pick to get the data for the below items. 

Total Clicks = Clicks (Summation from each campaign)
This is how I'm calculating the fields like Total Clicks, Total Impressions, etc 

I'm unable to figure out the right metrics for getting values for the below items:
1. Total Cost 
2. Total Converted Clicks 
3. Cost/Converted Click 
4. Click Conversion Rate 

Google Ads API Forum Advisor Prod

unread,
May 28, 2019, 5:08:11 AM5/28/19
to adwor...@googlegroups.com
Hi,

Thanks for reaching out. Kindly refer to my response below.

1. Total Cost - metrics.cost_micros
2. Total Converted Clicks - metrics.conversions (if this is not what you meant, kindly elaborate further so I can better assist you)
3. Cost/Converted Click - metrics.cost_per_conversion  (if this is not what you meant, kindly elaborate further so I can better assist you)
4. Click Conversion Rate - metrics.all_conversions_from_interactions_rate

You can also refer to this report migration guide for the equivalent fields in the Google Ads API. Let me know if this helps.

Regards,
Dannison
Google Ads API Team

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