Asset
Asset is a part of an ad which can be shared across multiple ads. It can be an image (ImageAsset), a video (YoutubeVideoAsset), etc. Assets are immutable and cannot be removed. To stop an asset from serving, remove the asset from the entity that is using it.
Table Specific Information
Select
Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.
Columns
Name
Type
Behavior
Description
AssetBookOnGoogleAsset
String
Attribute
BookOnGoogleAsset column for table Asset
AssetCalloutAssetAdScheduleTargets
String
Attribute
CalloutAssetAdScheduleTargets column for table Asset
AssetCalloutAssetCalloutText
String
Attribute
CalloutAssetCalloutText column for table Asset
AssetCalloutAssetEndDate
Date
Attribute
CalloutAssetEndDate column for table Asset
AssetCalloutAssetStartDate
Date
Attribute
CalloutAssetStartDate column for table Asset
AssetFinalMobileUrls
String
Attribute
FinalMobileUrls column for table Asset
AssetFinalUrlSuffix
String
Attribute
FinalUrlSuffix column for table Asset
AssetFinalUrls
String
Attribute
FinalUrls column for table Asset
AssetId
Long
Attribute
Id column for table Asset
AssetImageAssetFileSize
Long
Attribute
ImageAssetFileSize column for table Asset
AssetImageAssetFullSizeHeightPixels
Long
Attribute
ImageAssetFullSizeHeightPixels column for table Asset
AssetImageAssetFullSizeUrl
String
Attribute
ImageAssetFullSizeUrl column for table Asset
AssetImageAssetFullSizeWidthPixels
Long
Attribute
ImageAssetFullSizeWidthPixels column for table Asset
AssetImageAssetMimeType
String
Attribute
ImageAssetMimeType column for table Asset
AssetLeadFormAssetBackgroundImageAsset
String
Attribute
LeadFormAssetBackgroundImageAsset column for table Asset
AssetLeadFormAssetBusinessName
String
Attribute
LeadFormAssetBusinessName column for table Asset
AssetLeadFormAssetCallToActionDescription
String
Attribute
LeadFormAssetCallToActionDescription column for table Asset
AssetLeadFormAssetCallToActionType
String
Attribute
LeadFormAssetCallToActionType column for table Asset
AssetLeadFormAssetCustomDisclosure
String
Attribute
LeadFormAssetCustomDisclosure column for table Asset
AssetLeadFormAssetDeliveryMethods
String
Attribute
LeadFormAssetDeliveryMethods column for table Asset
AssetLeadFormAssetDescription
String
Attribute
LeadFormAssetDescription column for table Asset
AssetLeadFormAssetDesiredIntent
String
Attribute
LeadFormAssetDesiredIntent column for table Asset
AssetLeadFormAssetFields
String
Attribute
LeadFormAssetFields column for table Asset
AssetLeadFormAssetHeadline
String
Attribute
LeadFormAssetHeadline column for table Asset
AssetLeadFormAssetPostSubmitCallToActionType
String
Attribute
LeadFormAssetPostSubmitCallToActionType column for table Asset
AssetLeadFormAssetPostSubmitDescription
String
Attribute
LeadFormAssetPostSubmitDescription column for table Asset
AssetLeadFormAssetPostSubmitHeadline
String
Attribute
LeadFormAssetPostSubmitHeadline column for table Asset
AssetLeadFormAssetPrivacyPolicyUrl
String
Attribute
LeadFormAssetPrivacyPolicyUrl column for table Asset
AssetName
String
Attribute
Name column for table Asset
AssetPolicySummaryApprovalStatus
String
Attribute
PolicySummaryApprovalStatus column for table Asset
AssetPolicySummaryPolicyTopicEntries
String
Attribute
PolicySummaryPolicyTopicEntries column for table Asset
AssetPolicySummaryReviewStatus
String
Attribute
PolicySummaryReviewStatus column for table Asset
AssetPromotionAssetAdScheduleTargets
String
Attribute
PromotionAssetAdScheduleTargets column for table Asset
AssetPromotionAssetDiscountModifier
String
Attribute
PromotionAssetDiscountModifier column for table Asset
AssetPromotionAssetEndDate
Date
Attribute
PromotionAssetEndDate column for table Asset
AssetPromotionAssetLanguageCode
String
Attribute
PromotionAssetLanguageCode column for table Asset
AssetPromotionAssetMoneyAmountOffAmountMicros
Long
Attribute
PromotionAssetMoneyAmountOffAmountMicros column for table Asset
AssetPromotionAssetMoneyAmountOffCurrencyCode
String
Attribute
PromotionAssetMoneyAmountOffCurrencyCode column for table Asset
AssetPromotionAssetOccasion
String
Attribute
PromotionAssetOccasion column for table Asset
AssetPromotionAssetOrdersOverAmountAmountMicros
Long
Attribute
PromotionAssetOrdersOverAmountAmountMicros column for table Asset
AssetPromotionAssetOrdersOverAmountCurrencyCode
String
Attribute
PromotionAssetOrdersOverAmountCurrencyCode column for table Asset
AssetPromotionAssetPercentOff
Long
Attribute
PromotionAssetPercentOff column for table Asset
AssetPromotionAssetPromotionCode
String
Attribute
PromotionAssetPromotionCode column for table Asset
AssetPromotionAssetPromotionTarget
String
Attribute
PromotionAssetPromotionTarget column for table Asset
AssetPromotionAssetRedemptionEndDate
Date
Attribute
PromotionAssetRedemptionEndDate column for table Asset
AssetPromotionAssetRedemptionStartDate
Date
Attribute
PromotionAssetRedemptionStartDate column for table Asset
AssetPromotionAssetStartDate
Date
Attribute
PromotionAssetStartDate column for table Asset
AssetResourceName
String
Attribute
ResourceName column for table Asset
AssetSitelinkAssetAdScheduleTargets
String
Attribute
SitelinkAssetAdScheduleTargets column for table Asset
AssetSitelinkAssetDescription1
String
Attribute
SitelinkAssetDescription1 column for table Asset
AssetSitelinkAssetDescription2
String
Attribute
SitelinkAssetDescription2 column for table Asset
AssetSitelinkAssetEndDate
Date
Attribute
SitelinkAssetEndDate column for table Asset
AssetSitelinkAssetLinkText
String
Attribute
SitelinkAssetLinkText column for table Asset
AssetSitelinkAssetStartDate
Date
Attribute
SitelinkAssetStartDate column for table Asset
AssetStructuredSnippetAssetHeader
String
Attribute
StructuredSnippetAssetHeader column for table Asset
AssetStructuredSnippetAssetValues
String
Attribute
StructuredSnippetAssetValues column for table Asset
AssetTextAssetText
String
Attribute
TextAssetText column for table Asset
AssetTrackingUrlTemplate
String
Attribute
TrackingUrlTemplate column for table Asset
AssetType
String
Attribute
Type column for table Asset
AssetUrlCustomParameters
String
Attribute
UrlCustomParameters column for table Asset
AssetYoutubeVideoAssetYoutubeVideoId
String
Attribute
YoutubeVideoAssetYoutubeVideoId column for table Asset
AssetYoutubeVideoAssetYoutubeVideoTitle
String
Attribute
YoutubeVideoAssetYoutubeVideoTitle column for table Asset
CustomerId
Long
Attribute
ClientCustomerId column for table Asset
ConversionAction
String
Segment
ConversionAction column for table Segments
ConversionActionCategory
String
Segment
ConversionActionCategory column for table Segments
ConversionActionName
String
Segment
ConversionActionName column for table Segments
ConversionAdjustment
Bool
Segment
ConversionAdjustment column for table Segments
ConversionLagBucket
String
Segment
ConversionLagBucket column for table Segments
ConversionOrAdjustmentLagBucket
String
Segment
ConversionOrAdjustmentLagBucket column for table Segments
ExternalConversionSource
String
Segment
ExternalConversionSource column for table Segments
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name
Type
Description
ManagerId
Long
Id of the manager account on behalf of which you are requesting customer data.
Last updated