Campaign - Asset Level Data - Using API

[Ethinos DM]

Hello Team,

We want below data using API.

We want to fetch campaign asset-level data (like images and YouTube videos, which are assets) and also want to fetch how particular assets are performing according to a particular date range.

So, in the meantime, we want to fetch all asset data, including their performance , impressions and spends date-wise.

[Ethinos DM]

We want above data using API .

[Google Ads API Forum Advisor]

Hello,

Greetings from the Google Ads API Team.

With regards to your concern, can you please confirm if the sample GAQL query for the Google Ads API below is of help towards your concern?

Sample Query:

SELECT 
  asset.youtube_video_asset.youtube_video_id, 
  asset.youtube_video_asset.youtube_video_title, 
  campaign.id, 
  asset.image_asset.full_size.height_pixels, 
  asset.image_asset.file_size, 
  asset.image_asset.full_size.url, 
  asset.image_asset.full_size.width_pixels, 
  metrics.clicks, 
  metrics.ctr, 
  metrics.impressions, 
  metrics.all_conversions_value 
FROM ad_group_ad_asset_view 
WHERE 
  asset.id = <INSERT_ASSET_ID_HERE> 
  AND campaign.id = <INSERT_CAMPAIGN_ID_HERE>
  AND segments.date BETWEEN 'YYYMMDD' AND 'YYYMMDD' 

Please note that you may modify the fields present in the WHERE clause to query specific data, please refer to this query builder for more information(https://developers.google.com/google-ads/api/fields/v14/ad_group_ad_asset_view_query_builder).

I hope this information helps you. 

This message is in relation to case "ref:_00D1U1174p._5004Q2oA6tJ:ref"

Thanks,
 

Google Ads API Team

[Ethinos DM]

Thank you this is very helpful ! :)

[Ethinos DM]

Also, I have one question: how can we print the below values in PHP?

 

1. asset.callout_asset.end_date

2. asset.callout_asset.start_date

 

For asset.id, we are using $googleAdsRow->getAsset()->getId() to print that value, but where do we find out exactly which function we have to call? For the above callout_asset, I didn't get an exact function to print the values.