Companies
Create, update, and query DoubleClick for Publishers Companies.
Select
The following queries are processed server side. The driver processes other SELECT queries client-side in memory.
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. |
| 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. |