CData Python Connector for Google Ad Manager

Build 24.0.9060

Companies

Create, update, and query DoubleClick for Publishers Companies.

Select

The following queries are processed server side.

Retrieve a list of Companies. For example:

SELECT * FROM [Companies]

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

SELECT * FROM [Companies] WHERE Id = '4410125029'

Insert

To create a new Company, the Name and Type fields are required.

INSERT INTO [Companies] (Name, Type) VALUES ('CompName', 'ADVERTISER')

Update

You can update any field not marked as read-only by specifying the Id column.

UPDATE [Companies] SET Name = 'New CompName' WHERE Id = '4410125029'

Delete

The DELETE operation is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Uniquely identifies the Company. This value is read-only and is assigned by Google when the company is created. This attribute is required for updates.

Name String False

The full name of the company. This attribute is required and has a maximum length of 127 characters.

Type String False

Specifies what kind of company this is. This attribute is required.

The allowed values are HOUSE_ADVERTISER, HOUSE_AGENCY, ADVERTISER, AGENCY, AD_NETWORK, PARTNER, CHILD_PUBLISHER, VIEWABILITY_PROVIDER, UNKNOWN.

Address String False

Specifies the address of the company. This attribute is optional and has a maximum length of 65,535 characters.

Email String False

Specifies the email of the company. This attribute is optional and has a maximum length of 128 characters.

FaxPhone String False

Specifies the fax phone number of the company. This attribute is optional and has a maximum length of 63 characters.

PrimaryPhone String False

Specifies the primary phone number of the company. This attribute is optional and has a maximum length of 63 characters.

ExternalId String False

Specifies the external ID of the company. This attribute is optional and has a maximum length of 255 characters.

Comment String False

Specifies the comment of the company. This attribute is optional and has a maximum length of 1024 characters.

CreditStatus String False

Specifies the company's credit status. This attribute is optional and defaults to CreditStatus.ACTIVE when basic credit status settings are enabled, and CreditStatus.ON_HOLD when advanced credit status settings are enabled.

The allowed values are ACTIVE, ON_HOLD, CREDIT_STOP, INACTIVE, BLOCKED.

Settings String False

Specifies the default billing settings of this Company. This attribute is optional.

AppliedLabels String False

The set of labels applied to this company.

PrimaryContactId Long False

The ID of the Contact who is acting as the primary contact for this company. This attribute is optional.

AppliedTeamIds String False

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

ThirdPartyCompanyId Int False

Specifies the ID of the Google-recognized canonicalized form of this company. This attribute is optional.

LastModifiedDateTime Datetime True

The date and time this company was last modified.

ChildPublisher String False

Info required for when Company Type is CHILD_PUBLISHER.

ViewabilityProvider String False

Info required for when Company Type is VIEWABILITY_PROVIDER.

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