Create, update, delete, and query DoubleClick for Publishers Placements.
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 Placements. For example:
SELECT * FROM [Placements]
Additionally, you can specify the Id or filter by any other column.
SELECT * FROM [Placements] WHERE Id = '28544791'
To create a new Placement, the Name, and TargetedAdUnitIds fields are required.
INSERT INTO [Placements] (Name, TargetedAdUnitIds ) VALUES ('placement', '21622217303,21622217300')
You can update any field not marked as read-only by specifying the Id column.
UPDATE [Placements] SET Name = 'New Placement', Description = 'New Description' WHERE Id = '28544791'
The delete operation is not supported for this table.
Uniquely identifies the Placement. This attribute is read-only and is assigned by Google when a placement is created.
The name of the Placement. This value is required and has a maximum length of 255 characters.
A description of the Placement. This value is optional and its maximum length is 65,535 characters.
A string used to uniquely identify the Placement for purposes of serving the ad. This attribute is read-only and is assigned by Google when a placement is created.
The status of the Placement. This attribute is read-only.
The allowed values are ACTIVE, INACTIVE, ARCHIVED.
The collection of AdUnit object IDs that constitute the Placement.
The date and time this placement was last modified.