Creatives
Update and query DoubleClick for Publishers Creatives.
Select
The following queries are processed server side by the Google Ad Manager APIs. The driver processes other SELECT queries client-side in memory.
Retrieve a list of Creatives. For example:
SELECT * FROM [Creatives]
Additionally, you can specify the Id or filter by any other column.
SELECT * FROM [Creatives] WHERE Id = '138206791680'
Update
You can update any field not marked as read-only by specifying the Id column.
UPDATE [Creatives] SET Name = 'Updated creative' WHERE Id = '138206791680'
Insert
The insert operation is not supported for this table.
Delete
The delete operation is not supported for this table.
Columns
| Name | Type | ReadOnly | Description |
| CompanyId | Long | False |
The ID of the advertiser that owns the creative. This attribute is required. |
| Id [KEY] | Long | True |
Uniquely identifies the Creative. This value is read-only and is assigned by Google when the creative is created. This attribute is required for updates. |
| Name | String | False |
The name of the creative. This attribute is required and has a maximum length of 255 characters. |
| Width | Int | False |
The width of the Creative. |
| Height | Int | False |
The height of the Creative. |
| IsAspectRatio | Bool | False |
Whether the size defined by height and width represents an aspect ratio. |
| PreviewUrl | String | True |
The URL of the creative for previewing the media. This attribute is read-only and is assigned by Google when a creative is created. |
| PolicyLabels | String | True |
Set of policy labels detected for this creative. This attribute is read-only. |
| AppliedLabels | String | False |
The set of labels applied to this creative. |
| LastModifiedDateTime | Datetime | True |
The date and time this creative was last modified. |
| ThirdPartyDataDeclaration | String | False |
The third party companies associated with this creative. This is distinct from any associated companies that Google may detect programmatically. |
| Snippet | String | True |
The HTML snippet that this creative delivers. This attribute is required. |
| ExpandedSnippet | String | True |
The HTML snippet that this creative delivers with macros expanded. This attribute is read-only and is set by Google. |
| CreativeTemplateVariableValues | String | False |
Stores values of CreativeTemplateVariable in the CreativeTemplate. |
| SslScanResult | String | True |
The SSL compatibility scan result for this creative. |
| SslManualOverride | String | False |
The manual override for the SSL compatibility of this creative. This attribute is optional and defaults to SslManualOverride.NO_OVERRIDE. |
| LockedOrientation | String | True |
A locked orientation for this creative to be displayed in. |
| AssetSize | String | True |
The asset size of an internal redirect creative. Note that this may differ from size if users set overrideSize to true. This attribute is read-only and is populated by Google. |
| InternalRedirectUrl | String | False |
The internal redirect URL of the DFA or DART for Publishers hosted creative. This attribute has a maximum length of 1024 characters. |
| IsSafeFrameCompatible | Bool | True |
Whether the Creative is compatible for SafeFrame rendering. |
| Html5Asset | String | False |
The HTML5 asset. To preview the HTML5 asset, use the CreativeAsset.assetUrl. In this field, the CreativeAsset.assetByteArray must be a zip bundle and the CreativeAsset.fileName must have a zip extension. |
| DestinationUrl | String | False |
The URL the user is directed to if they click on the creative. This attribute is only required if the template snippet contains the %u or %%DEST_URL%% macro. It has a maximum length of 1024 characters |
| DestinationUrlType | String | False |
The action that should be performed if the user clicks on the creative. This attribute is optional and defaults to DestinationUrlType.CLICK_TO_WEB. |
| HtmlSnippet | String | False |
The HTML snippet that this creative delivers. |
| CustomCreativeAssets | String | False |
A list of file assets that are associated with this creative, and can be referenced in the snippet. |
| OverrideSize | Bool | True |
Allows the creative size to differ from the actual HTML5 asset size. This attribute is optional. thirdPartyImpressionTrackingUrls. |
| IsInterstitial | Bool | False |
True if this internal redirect creative is interstitial. |
| PrimaryImageId | Long | True |
Uniquely identifies the Creative. This value is read-only and is assigned by Google when the creative is created. This attribute is required for updates. |
| PrimaryImageName | String | True |
The name of the creative. This attribute is required and has a maximum length of 255 characters. |
| PrimaryImageSize | Long | True |
Primary image size. |
| PrimaryImageUrl | String | True |
Primary image url. |
| AltText | String | False |
Alternative text to be rendered along with the creative used mainly for accessibility. This field is optional and has a maximum length of 500 characters. |
| ThirdPartyImpressionTrackingUrls | String | False |
A list of impression tracking URL to ping when this creative is displayed. This field is optional and each string has a maximum length of 1024 characters. |
| AmpRedirectUrl | String | False |
The URL of the AMP creative. |