Get total row metrics of asset report

[Lộc Đoàn]

Hi Google Ads team,

How do I get total rows metrics of asset in the asset reports by using Google Ads API?

I've tried to check the total rows for site links and callouts, but it seems the total rows is not equal to the sum of all the above rows.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

I understand that you want to get the total count of assets in your account via API. You may use this asset resource to get all the assets via API. Please note that the asset resource does not support fetching metrics. You may use this Google Ads Query builder to build your query using the asset resource.

Hope this helps. If this does not answer your query, please feel free to get back to us.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vFlXv:ref" (ADR-00266822)

Thanks,
 

Google Ads API Team

[Lộc Đoàn]

Hi Google Ads team,

I want to get the metrics of the row total. For example, in the picture I show you say Total Callouts, and it has metrics of interaction, impr., clicks. I want to get these metrics of this row. And I want to get it through Google Ads API. One more thing is that as I get individual rows' metrics to sum it up, it is not equal to the value at the Total Callouts row. For individual row, I get metrics data from campaign_asset and ad_group_asset. For the Total Callouts row, I don't know where to get the metrics from. Can you give me advice on how to get the metrics of the total rows, not only for Callouts, but for other assets, like sitelinks, structured snippets, etc...

Thanks in advance

[Google Ads API Forum Advisor]

Hi,

In order to get the overall sum of the metrics you can use the 'SummaryRowSetting' to the Summary_row_only. If you are facing any discrepancy for 'Total Callouts' for any particular campaign or assets, please provide us with the complete API logs (request and response with request-id and request header) generated at your end and uncropped UI screenshot by highlighting the discrepancies.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

Kindly note that it's not expected to see report discrepancies between API and UI. It usually occurs, if we didn't follow the these steps:

• The segments and fields of the API and UI should be the same.
• The date range should also be the same.
• Comparing the API and UI at the same level as possible.

[Lộc Đoàn]

Hi,

I used your suggestion and am able to get the summary data.

My query is: SELECT asset.name,asset.id,customer_asset.field_type,metrics.interactions,metrics.video_views,metrics.cross_device_conversions,metrics.impressions,metrics.clicks,metrics.cost_micros FROM customer_asset  WHERE segments.date >= '2024-08-01' AND segments.date <= '2024-08-28' AND customer_asset.field_type = 'CALLOUT'

Request id is: -Gx9W9BVC3KUEdfX45rhcg

The sum of clicks that API return is: 5244.

The sum of 'Total: Callout' row on UI is: 1750

 Please help me check.

[Google Ads API Forum Advisor]

Hi,

I have raised your concern with the rest of our team and one of my teammates will reach out to you once we have an update.

[Google Ads API Forum Advisor]

Hi,

To get the total row with non-overcounted metrics for each asset field type when the asset is used as extension you could use the asset_field_type_view . This should provide you the same result as seen in the UI.