CustomFields

Create, update, and query DoubleClick for Publishers Custom Fields.

Select

The following queries are processed server side by the Google Ad Manager APIs.

Retrieve a list of CustomFields. For example:

SELECT * FROM [CustomFields]

Additionally, you can specify the Id or filter by any other column.

SELECT * FROM [CustomFields] WHERE Id = '1238676'

To create a new CustomField, the Name, EntityType, DataType, and Visibility fields are required.

INSERT INTO [CustomFields] (Name, EntityType, DataType, Visibility) VALUES ('ASEF', 'LINE_ITEM', 'STRING', 'FULL')

You can update any field not marked as read-only by specifying the Id column.

UPDATE [CustomFields] SET Description = 'New Description' WHERE Id = '1238676'

The DELETE operation is not supported for this table.


Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Unique ID of the CustomField. This value is readonly and is assigned by Google.
Name	String	False	Name of the CustomField. This value is required to create a custom field. The max length is 127 characters.
Description	String	False	A description of the custom field. This value is optional. The maximum length is 511 characters.
IsActive	Boolean	True	Specifies whether or not the custom field is active. This attribute is read-only.
EntityType	String	False	The type of entity that this custom field is associated with. This attribute is read-only if there exists a CustomFieldValue for this field. The allowed values are LINE_ITEM, ORDER, CREATIVE, PRODUCT_TEMPLATE, PRODUCT, PROPOSAL, PROPOSAL_LINE_ITEM, USER, UNKNOWN.
DataType	String	False	The type of data this custom field contains. This attribute is read-only if a CustomFieldValue exists for this field. The allowed values are STRING, NUMBER, TOGGLE, DROP_DOWN, UNKNOWN.
Visibility	String	False	How visible/accessible this field is in the UI. The allowed values are API_ONLY, READ_ONLY, FULL.