The total number of conversions in ad_group_ad_asset_view is less than in ad_group_ad

[Kirill Arkhipenko]

Hello Google Ads API team,

Our customer wants to see report with date and asset_id / asset_name breakdown, and we use this query to get the statistics from ad_group_ad_asset_view:

SELECT
segments.date,
asset.id,
asset.name,
metrics.conversions
FROM ad_group_ad_asset_view
WHERE segments.date BETWEEN '2021-05-01' AND '2021-05-01';

However, the customer reported seeing significantly fewer conversions than the dashboard shows.

Indeed, when we run the following query for ad_group_ad, we see more conversions:

SELECT
segments.date,
ad_group_ad.ad.id,
ad_group_ad.ad.name,
metrics.conversions
FROM ad_group_ad
WHERE segments.date BETWEEN '2021-05-01' AND '2021-05-01';

How can this behavior be explained?

[Google Ads API Forum Advisor]

Hello Kirill,

Thank you for reaching out to us.

Please do note that reports have different source of data which is the primary reason why they return different results. The ad_group_ad returns all related metrics for an ad group ad while the ad_group_ad_asset_view returns all metrics between an AdGroupAd and an Asset. As for the behavior between 2 reports and how metrics or statistics are calculated for their entity specialization, we highly suggest that you reach out to the Product Support Team via this link instead. The Product specialists there should be able to provide more details regarding on this.

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2I0J21:ref