Assets Extensions

[cv]

Hi,

I want to get All Assets set in account and Its Total.

I am aware that Original Ad Extensions are moved to Assets. earlier I used to use this query

SELECT campaign.id
                    , campaign.name
                    , segments.placeholder_type
                    , campaign.status
                    , ad_group.status
                FROM
                    feed_item

                WHERE metrics.impressions > 0 AND campaign.status IN ('ENABLED','PAUSED') AND ad_group.status IN ('ENABLED','PAUSED')

I need all the assets there in account and its total as shown in image.

[Google Ads API Forum Advisor]

Hi,

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

By reviewing your query, I understand that you would like to retrieve all assets set in account and its total. Kindly find the below query to retrieve all assets set in account and its total using the asset_group report :
 

{
  "query": "SELECT asset_group.name, metrics.interactions, metrics.interaction_rate, metrics.average_cost, metrics.cost_micros, metrics.impressions, metrics.clicks, metrics.conversions_from_interactions_rate, metrics.conversions, metrics.cost_per_conversion, asset_group.resource_name FROM asset_group",
  "summaryRowSetting": "SUMMARY_ROW_WITH_RESULTS"
}

You can use Query Builder to create your query and Query Validator to validate your query. Also, kindly try making the request to the search endpoint which returns all rows that match the search query. 

Hope this helps. Let us know if you have any further queries.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rz6Ao:ref"

Thanks,
 

Google Ads API Team