Labels

Create, update, delete, and query DoubleClick for Publishers Labels.

Select

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

Retrieve a list of Labels. For example:

SELECT * FROM [Labels]

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

SELECT * FROM [Labels] WHERE Id = '370450571'

To create a new Label, the Name field is required.

INSERT INTO [Labels] (Name) VALUES ('new lbl')

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

UPDATE [Labels] SET Description = 'New Description', Name = 'New updated lbl name' WHERE Id = '370341705'

The DELETE operation is not supported for this table.

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Unique ID of the Label. This value is readonly and is assigned by Google.
Name	String	False	Name of the Label. This value is required to create a label and has a maximum length of 127 characters.
Description	String	False	A description of the label. This value is optional and its maximum length is 255 characters.
IsActive	Boolean	True	Specifies whether or not the label is active. This attribute is read-only.
AdCategory	String	False	Indicates the Ad Category associated with the label.
Types	String	False	The types of the Label. The allowed values are COMPETITIVE_EXCLUSION, AD_UNIT_FREQUENCY_CAP, AD_EXCLUSION, CREATIVE_WRAPPER, CANONICAL_CATEGORY, UNKNOWN.