The issue is soved. Cost is in micro currency units therefore we need to
divide it by 100.
https://developers.google.com/adwords/api/docs/guides/reporting
"Money fields in reports
Fields of type Money are returned in micro currency units (micros) but may
be prefixed with "auto: " or may simply be the string "auto" if automatic
bidding is used. For example, $1.23 will come back as 123 (1.23 x
1,000,000). Micro amounts always refer to the account's local currency.
When filtering on money fields, you'll have to provide the value in micros.
For example, WHERE AverageCpc > 100 will return rows where the
AverageCpc is greater than $1 (one unit of the account currency)."
On Thursday, June 20, 2019 at 8:11:58 AM UTC+2, marvel tales wrote:
>
> Hi,
>
> I would like to download Shopping Performance Report for the last 30 days
> in order to have metrics at product level.
> I am receiving extreme values as AverageCPC and Cost from the Shopping
> Performance Report.
>
> This is the query I use:
> 'SELECT
> AccountDescriptiveName,CampaignId,CampaignName,AdGroupName,AdGroupId,'
>
> 'OfferId,Impressions,Clicks,AverageCpc,Cost,Ctr,AllConversions,ConversionValue,'
> 'CategoryL1,CategoryL2,CategoryL3,CategoryL4,CategoryL5,'
> 'CrossDeviceConversions,'
> 'SearchImpressionShare,'
> 'SearchClickShare,'
> 'CustomAttribute1,'
> 'CustomAttribute2,'
> 'Brand,CampaignStatus,AdGroupStatus '
> 'FROM SHOPPING_PERFORMANCE_REPORT '
> 'WHERE CampaignStatus = "ENABLED" AND AdGroupStatus =
> "ENABLED" '
> 'DURING LAST_30_DAYS '
>
>
> An example from the downloaded data
> ClicksAvg_CPC Cost
>
> 2
> 567
> 1134
>
> Where am I doing wrong?
>
> I would appreciate if someone can help me.
>
> Thanks.
> Kind regards.
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/0adc3fef-3cda-4fae-9541-232085ea0765%40googlegroups.com.