Fetching Asset Attributes and Metrics

Page Summary

outlined_flag

• Retrieve a list of assets and their attributes, including resource name and type, using Search Ads 360 Query Language.

• Access type-specific attributes, such as mobile app IDs, by filtering the asset.type value in your query.

• Query asset metrics at the ad group, campaign, or customer level through respective resources like ad_group_asset , campaign_asset , and customer_asset .

• Segment asset metric results by fields like ad_group.id to analyze performance for specific combinations of assets and ad groups, campaigns, or customers.

Asset attributes

You can get a list of assets and their attributes by sending a Search Ads 360 Query Language query to the SearchAds360Service. Assets are represented by the asset entity, which exposes a number of asset-specific fields.

The following 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 SitelinkAsset or MobileAppAsset .

For example, the following query lists the mobile app IDs for all MobileAppAsset objects in an account by filtering the asset.type value for MobileAppAsset .

  SELECT 
  
 asset 
 . 
 id 
 , 
  
 asset 
 . 
 name 
 , 
  
 asset 
 . 
 resource_name 
 , 
  
 asset 
 . 
 mobile_app_asset 
 . 
 app_store 
 FROM 
  
 asset 
 WHERE 
  
 asset 
 . 
 type 
  
 = 
  
 'MOBILE_APP' 
 

Asset metrics

Asset metrics are made available through a few resources:

• ad_group_asset
• campaign_asset
• customer_asset

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