Hello,
Any updates to this question?
Thanks,
Adam
On Friday, November 3, 2023 at 5:46:32 PM UTC+1 Adam Nagy wrote:
Greetings Google dev team,
To the following query I can get negative conversion values, namely numbers
like "-2e-9" or "-7e-9", so very small negative number seemingly:
SELECT campaign.advertising_channel_type, campaign.resource_name,
ad_group.resource_name, ad_group_ad.resource_name, segments.date,
segments.conversion_action, segments.conversion_action_category,
segments.conversion_action_name,
metrics.all_conversions_value_by_conversion_date FROM ad_group_ad WHERE
segments.date >= '2023-09-01' AND segments.date <= '2023-11-15' AND
*metrics.all_conversions_value_by_conversion_date
< 0* ORDER BY segments.date DESC
And for this I get a result something like (customer information redacted)
{
campaign: {
advertising_channel_type: 2,
resource_name: 'customers/customerId/campaigns/campaignId'
},
ad_group: { resource_name: 'customers/customerId/adGroups/adGroupId' },
ad_group_ad: {
resource_name: 'customers/customerId/adGroupAds/adgroupId~adId',
ad: resource_name: 'customers/customerId/ads/adId'
},
segments: {
date: '2023-09-30',
conversion_action:
'customers/customerId/conversionActions/conversionActionId',
conversion_action_category: 4,
conversion_action_name: 'conversionActionName'
},
metrics: { *all_conversions_value_by_conversion_date: -7e-9* }
}
I am happy to share request id-s and the concrete query as well, but as a
preliminary question: is this a known and expected behaviour? Does the
all_conversions_value_by_conversion_date:
-7e-9 part hold actual information or is it effectively 0?
Thanks in advance,
Adam
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords 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/2ac13891-9f0f-4916-bdd0-b93cb55f1530n%40googlegroups.com.
