RE: Cost_micros way higher than expected.

2022-04-15 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
Hello, As Colin indicated, the value is being returned in micros, which is 1,000,000 times the account currency. This is briefly discussed in the AdWords API documentation, though the concept applies to the Ads API as well. Regards, Matt Google Ads API Team Matt Google Ads API Team ref:_00D1U1

Re: Cost_micros way higher than expected.

2022-04-14 Thread 'Colin Lee' via Google Ads API and AdWords API Forum
The *metrics.cost_micros* field is in micros, and you will need to divide by 1,000,000 to get the actual cost value. On Wednesday, April 13, 2022 at 1:51:32 PM UTC-4 a.long.h...@gmail.com wrote: > > Hello, > > I am currently building an ETL pipeline using the new Google Ads API > > We were pre

Re: Cost_micros way higher than expected.

2022-04-13 Thread Alex Long
query = f""" SELECT segments.date, customer.id, customer.descriptive_name, campaign.id, campaign.name, campaign.status, ad_group.id, ad_group.name, ad_group.status, ad_group_ad.ad.name, ad_group_ad.ad.id, ad_group_ad.status, segments.ad_network_type, segments.device, metrics.impressions, metrics.c

Cost_micros way higher than expected.

2022-04-13 Thread Alex Long
Hello, I am currently building an ETL pipeline using the new Google Ads API We were previously using the Adwords API. I am able to successfully pull data down using the API, but the cost_micros is showing with either 0 value or 6 digits. See attached picture. Is this a currency issue? How d