SSIS Components for Google Ad Manager

Build 24.0.9060

Orders

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

Select

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

Retrieve a list of Orders. For example:

SELECT * FROM [ Orders ]

Additionally, you can specify the Id or filter by any other column.

SELECT * FROM [Orders] WHERE Id = '2112977260'

Insert

To create a new Order, the Name, AdvertiserId, and TraffickerId fields are required.

INSERT INTO [Orders] (Name, AdvertiserId, TraffickerId) VALUES ('Ord313', '4410125029', '244525926')

Update

You can update the Notes of an Order row by specifying the Id column.

UPDATE [Orders] SET Notes = 'Updated notes22222' WHERE Id = '2112977260'

Delete

You can delete an Order row by specifying the Id column.

DELETE FROM [Orders] WHERE Id = '2108997295'

Columns

Name Type ReadOnly Description
Id [KEY] Long False

The unique ID of the Order. This value is readonly and is assigned by Google.

Name String False

The name of the Order. This value is required to create an order and has a maximum length of 255 characters.

StartDateTime Datetime True

The date and time at which the Order and its associated line items are eligible to begin serving. This attribute is readonly and is derived from the line item of the order which has the earliest LineItem.startDateTime.

EndDateTime Datetime True

The date and time at which the Order and its associated line items stop being served. This attribute is readonly and is derived from the line item of the order which has the latest LineItem.endDateTime.

UnlimitedEndDateTime Bool False

Specifies whether or not the Order has an unlimited end date. This attribute is readonly and is true if any of the order's line items has LineItem.unlimitedEndDateTime set to true.

Status String True

The status of the Order. This attribute is read-only.

IsArchived Bool False

The archival status of the Order. This attribute is readonly.

Notes String False

Provides any additional notes that may annotate the Order. This attribute is optional and has a maximum length of 65,535 characters.

ExternalOrderId Int False

An arbitrary ID to associate to the Order, which can be used as a key to an external system. This value is optional.

PoNumber String False

The purchase order number for the Order. This value is optional and has a maximum length of 63 characters.

CurrencyCode String True

The ISO currency code for the currency used by the Order. This value is read-only and is the network's currency code.

AdvertiserId Long False

The unique ID of the Company, which is of type Company.Type.ADVERTISER, to which this order belongs. This attribute is required.

AdvertiserContactIds String False

List of IDs for advertiser contacts of the order.

AgencyId Long False

The unique ID of the Company, which is of type Company.Type.AGENCY, with which this order is associated. This attribute is optional.

AgencyContactIds String False

List of IDs for agency contacts of the order.

CreatorId Long True

The unique ID of the User who created the Order on behalf of the advertiser. This value is readonly and is assigned by Google.

TraffickerId Long False

The unique ID of the User responsible for trafficking the Order. This value is required for creating an order

SecondaryTraffickerIds String False

The IDs of the secondary traffickers associated with the order. This value is optional.

SalespersonId Long False

The unique ID of the User responsible for the sales of the Order. This value is optional.

SecondarySalespersonIds String False

The IDs of the secondary salespeople associated with the order. This value is optional.

TotalImpressionsDelivered Long True

Total impressions delivered for all line items of this Order. This value is read-only and is assigned by Google.

TotalClicksDelivered Long True

Total clicks delivered for all line items of this Order. This value is read-only and is assigned by Google.

TotalViewableImpressionsDelivered Long True

Total viewable impressions delivered for all line items of this Order. This value is read-only and is assigned by Google. Starting in v201705, this will be null when the order does not have line items trafficked against a viewable impressions goal.

TotalBudget String False

Total budget for all line items of this Order. This value is a readonly field assigned by Google and is calculated from the associated LineItem.costPerUnit values.

AppliedLabels String False

The set of labels applied directly to this order.

EffectiveAppliedLabels String True

Contains the set of labels applied directly to the order as well as those inherited from the company that owns the order. If a label has been negated, only the negated label is returned. This field is readonly and is assigned by Google.

LastModifiedByApp String True

The application which modified this order. This attribute is read only and is assigned by Google.

IsProgrammatic Bool False

Specifies whether or not the Order is a programmatic order. This value is optional and defaults to false.

AppliedTeamIds String False

The IDs of all teams that this order is on directly.

LastModifiedDateTime Datetime True

The date and time this order was last modified.

CustomFieldName String True

This is the name of the custom field. There will be as many custom columns as custom fields are related to Orders.

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