Asset Level Data Via API

[saif khan]

Hi Team,

I am trying to pull Asset Level data for PMAX, App and Demand Gen campaigns using API.

Attached is the columns that I need to pull.

Can you help me with the query(Table name and column Name)?

Regards,

Saif Khan

[saif khan]

Can I get an update on this?

[Google Ads API Forum Advisor]

Hi Saif,

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

Based on the screenshot provided, I would recommend you to use the ad_group_asset resource to retrieve the fields and metrics from the Google Ads API. I would also suggest you to refer to the Reporting documentation as it explains in detail regarding the types of reports that are available to extract the asset level data from the Google Ads API. Please find the sample GAQL query as per your requirement:

SELECT ad_group_asset.source, asset.id, ad_group_asset.status, ad_group_asset.field_type, 
metrics.average_cpm, metrics.interaction_rate, metrics.interactions, metrics.clicks, 
metrics.impressions, metrics.cost_micros, metrics.average_cost FROM ad_group_asset

You can use the search or searchStream methods in making the API calls while retrieving the data. Additionally, you can utilize the Google Ads Query Builder and Query Validator to build and validate the queries for retrieving the data from the Google Ads API.
 

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

Thanks,
 

Google Ads API Team

[saif khan]

Hi Team,

Thanks for the update.

I used the query provided and I was able to fetch the data, but it was specific to Search Campaigns.

SELECT ad_group_asset.source, asset.id, ad_group_asset.status, ad_group_asset.field_type,
metrics.average_cpm, metrics.interaction_rate, metrics.interactions, metrics.clicks,

metrics.impressions, metrics.cost_micros, metrics.average_cost,campaign.id, ad_group.id,campaign.name FROM ad_group_asset

Can you please let me know if we can fetch Assets data for PMAX, APP, Demand Gen Campaigns.

Regards,

Saif Khan

[Google Ads API Forum Advisor]

Hi,

I would recommend that you refer to this guide for PMAX reporting at asset level. 
I would recommend that you refer to ad_group_ad_asset_view for App ads.
I would recommend that you refer to campaign_asset to fetch data for demand gen campaigns.

Hope this helps. If you have any more queries, please feel free to get back to us.