Geographic Cost value is off

[Todd Evans]

We are currently running the following gaql to acquire Geographic information.

The Cost data(metrics.cost_micros) returned from this gaql needs to be divided by 1,000,000 to get the "Real" Cost.  We feel this needs to be corrected in the API.

SELECT campaign.name ,ad_group.name, geographic_view.location_type ,segments.ad_network_type ,segments.geo_target_city ,segments.geo_target_state ,geographic_view.country_criterion_id ,segments.geo_target_metro ,metrics.impressions, metrics.clicks, metrics.cost_micros FROM geographic_view  WHERE segments.date BETWEEN '2019-01-01' AND '2019-12-31' 

See attached screen shot of some data returned by the API

[AdWords API and Google Ads API Forum]

Reposting the last inquiry from the forum as it wasn't routed to our support queue.

Thanks,

Lakshmi, Google Ads API Team

[Google Ads API Forum Advisor Prod]

Hello,

Money fields in the API reports return as microunits, so you will need to divide these values by 1,000,000 to get the correct amount. 

Regards,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2DxDWO:ref