Ads API - which fields are of type Money?

[Mike Sullivan]

I followed the blog series on the query builder with great interest (thank you):

https://ads-developers.googleblog.com/2021/05/the-query-builder-blog-series-part-8.html

But where do you find which fields are of type Money, or returned in micros? For example, metrics.average_cpc is returned from the googleAdsFields as dataType DOUBLE.

In the Discovery document (also referenced in the blog), doesn't help. Is there a list of Money-type fields available somewhere?

[AdWords API and Google Ads API Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-api/c/IqeSk_SOMqY) from the forum as it wasn't routed to our support queue.

Cheers,

Peter Laurence Oliquino

Google Ads API Team

[Google Ads API Forum Advisor]

Hi,

I appreciate your patience to this concern. Allow me to provide support.

I am afraid that there is currently no documentation where we can see all the list of money fields or metrics that will return values in terms of micros. With this, allow me to raise a feature request to my team, subject for review.

For the meantime, please follow our blog to receive updates and new releases.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2IvDmn:ref

[Pete Lavetsky (AdWords API Guru)]

Hey Mike,

You can solve this by using the GoogleAdsFieldService : https://developers.google.com/google-ads/api/reference/rpc/v8/GoogleAdsFieldService

SELECT name, category, data_type, selectable, filterable, sortable, selectable_with, metrics, segments, is_repeated, type_url, enum_values, attribute_resources where name like \'%micros%\'

Pete

[Google Ads API Forum Advisor]

Hi,

Apart from what was just suggested, you may also check out our metrics documentation to search for fields with micros. Also, you may for now continue to follow our blog for updates or announcements regarding your original inquiry.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2IvDmn:ref

[Mike Sullivan]

Thanks to Pete and Peter for the ideas, but there are a lot of money metrics that do not include the word 'micros' in the names or the descriptions. As a really obvious example:

 average_cpc : "The total cost of all clicks divided by the total number of clicks received."  

The discovery document also provides no additional clues, just echoing the description. 

I also tried 'cost', but there are still the odd exceptions like benchmark_average_max_cpc  - "An indication of how other advertisers are bidding on similar products."  Obscure, I know, but it exists.

I realize there are only 120 metrics, but things change over time (API v8 already?) and it would be nice to have an automated method to determine if a number is a micro or not...

m

[Google Ads API Forum Advisor]

Hi Mike,

Thanks for the reply. The way to determine that a field is a money field is if there is a suffix 'micros' at the end of metric's name. However, our team is aware that some of the money fields don't have this suffix. With this, you may keep an eye on our blog or directly in the documentation for updates on your request regarding the faster way to identify money fields.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2IvDmn:ref