Create, update, delete, and query DoubleClick for Publishers Labels.
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 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.
Unique ID of the Label. This value is readonly and is assigned by Google.
Name of the Label. This value is required to create a label and has a maximum length of 127 characters.
A description of the label. This value is optional and its maximum length is 255 characters.
Specifies whether or not the label is active. This attribute is read-only.
Indicates the Ad Category associated with the label.
The types of the Label.
The allowed values are COMPETITIVE_EXCLUSION, AD_UNIT_FREQUENCY_CAP, AD_EXCLUSION, CREATIVE_WRAPPER, CANONICAL_CATEGORY, UNKNOWN.