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
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
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
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