SSIS Components for Google Ad Manager

Build 24.0.9060

Labels

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

Select

The following queries are processed server side by the Google Ad 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'

Insert

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

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

Update

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'

Delete

The DELETE operation is not supported for this table.

Columns

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060