JDBC Driver for Google Ad Manager

Build 22.0.8462

Placements

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

Select

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'

Insert

To create a new Placement, the Name, and TargetedAdUnitIds fields are required.

INSERT INTO [Placements] (Name, TargetedAdUnitIds ) VALUES ('placement', '21622217303,21622217300')

Update

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'

Delete

The delete operation is not supported for this table.

Columns

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.

The allowed values are 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462