`ad_network_type` segmentation conversions issue

[Patryk Tucki]

`ad_network_type` segmentation used without additional conversion related segmentation like `conversion_action` results in hiding some conversions.

SELECT metrics.all_conversions, segments.device
FROM ad_group_ad
WHERE customer.id = 'HIDDEN'

Sum of "all_conversions" metrics from all rows: 225963.

SELECT metrics.all_conversions, segments.device, segments.conversion_action
FROM ad_group_ad
WHERE customer.id = 'HIDDEN'

Sum of "all_conversions" metrics from all rows: 225963.

SELECT metrics.all_conversions, segments.ad_network_type
FROM ad_group_ad
WHERE customer.id = 'HIDDEN'

Sum of "all_conversions" metrics from all rows: 225959 (invalid number).

SELECT metrics.all_conversions, segments.ad_network_type, segments.conversion_action
FROM ad_group_ad
WHERE customer.id = 'HIDDEN'

Sum of "all_conversions" metrics from all rows: 225963.

I would expect the sum of "all_conversions" metrics from all rows to always be equal (regardless of segmentation used).

[AdWords API and Google Ads API Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-api/c/-2iYMZ9PGgQ/m/ZCJouuEABgAJ) from the forum as it wasn't routed to our support queue. 

Thanks,

Peter Laurence Napa Oliquino 

Google Ads API Team

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to our API support team.

For our team to further look into the discrepancy, could you provide the complete request and response logs, with the request-id, of the below queries :

SELECT metrics.all_conversions, segments.ad_network_type
FROM ad_group_ad
WHERE customer.id = 'HIDDEN'
Sum of "all_conversions" metrics from all rows: 225959 (invalid number).

SELECT metrics.all_conversions, segments.ad_network_type, segments.conversion_action
FROM ad_group_ad
WHERE customer.id = 'HIDDEN'
Sum of "all_conversions" metrics from all rows: 225963.

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2I0AmA:ref