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