Reporting

You can get a list of assets and their attributes by sending a Google Ads Query Language (GAQL) query to the GoogleAdsService. Assets are represented by the asset entity, which exposes a number of asset-specific fields.

Asset attributes

The following GAQL query lists all assets in an advertiser's account along with their resource name and type.

SELECT
  asset.id,
  asset.name,
  asset.resource_name,
  asset.type
FROM asset

Note that there are type-specific attributes that you could add to the above query to read properties specific to assets such as ImageAsset or YoutubeVideoAsset.

For example, the following query lists the YouTube video IDs for all YoutubeVideoAsset objects in an account by filtering the asset.type value (see the documentation for a list of possible type values) for YoutubeVideoAsset.

SELECT
  asset.id,
  asset.name,
  asset.resource_name,
  asset.youtube_video_asset.youtube_video_id
FROM asset
WHERE asset.type = 'YOUTUBE_VIDEO'

Asset metrics

Asset metrics are made available through a few resources:

With these resources, asset metrics can be queried at each respective level. For instance, when querying the ad_group_asset resource, the ad_group.id field can be used to segment the results, thereby retrieving metrics for each unique combination of ad_group and asset:

SELECT
  ad_group.id,
  asset.id,
  metrics.clicks,
  metrics.impressions
FROM ad_group_asset
WHERE segments.date DURING LAST_MONTH
ORDER BY metrics.impressions DESC

Ad-level metrics

Ad-level performance metrics for assets are aggregated in the ad_group_ad_asset_view. This view collects metrics for assets per individual ad. Thus, querying this view returns a row per ad group and ad.

The ad_group_ad_asset_view exposes the view-specific attribute performance_label that gives insight into the performance characteristics of this specific asset-ad pairing. The possible values of the performance_label fields are enumerated in the following table.

performance_labelDescription
BESTBest performing assets.
GOODGood performing assets.
LOWWorst performing assets.
LEARNINGThe asset has started getting impressions but the stats are not statistically significant enough to get an asset performance label.
PENDINGThis asset does not yet have any performance information. This may be because it is still under review.
UNKNOWNRepresents value unknown in this version.
UNSPECIFIEDNot specified.

The following GAQL query returns impressions, clicks, costs, and conversions for all assets in an account during the last month, sorted by their performance_label:

SELECT
  ad_group_ad_asset_view.ad_group_ad,
  ad_group_ad_asset_view.asset,
  ad_group_ad_asset_view.field_type,
  ad_group_ad_asset_view.performance_label,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions
FROM ad_group_ad_asset_view
WHERE segments.date DURING LAST_MONTH
ORDER BY ad_group_ad_asset_view.performance_label