Negative tiny conversion value for all_conversions_value_by_conversion_date

[Adam Nagy]

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

[Adam Nagy]

Hello,

Any updates to this question?

Thanks,

Adam