Placements

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

Select

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

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.


Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Uniquely identifies the Placement. This attribute is read-only and is assigned by Google when a placement is created.
Name	String	False	The name of the Placement. This value is required and has a maximum length of 255 characters.
Description	String	False	A description of the Placement. This value is optional and its maximum length is 65,535 characters.
PlacementCode	String	True	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.
Status	String	True	The status of the Placement. This attribute is read-only. 使用できる値は次のとおりです。ACTIVE, INACTIVE, ARCHIVED
TargetedAdUnitIds	String	False	The collection of AdUnit object IDs that constitute the Placement.
LastModifiedDateTime	Datetime	True	The date and time this placement was last modified.