JDBC Driver for Google Ad Manager

Build 22.0.8462

Proposals

Create, update, and query DoubleClick for Publishers Proposals.

Columns

Name Type ReadOnly Description
Id [KEY] Long True

The unique ID of the Proposal. This attribute is read-only.

IsProgrammatic Boolean False

Flag that specifies whether this Proposal is for programmatic deals. This value is default to false.

DfpOrderId Long True

The unique ID of corresponding Order. This will be null if the Proposal has not been pushed to Ad Manager. This attribute is read-only.

Name String False

The name of the Proposal. This value has a maximum length of 255 characters. This value is copied to Order.name when the proposal turns into an order. This attribute can be configured as editable after the proposal has been submitted. Please check with your network administrator for editable fields configuration.

StartDateTime Datetime True

The date and time at which the order and line items associated with the Proposal are eligible to begin serving. This attribute is derived from the proposal line item of the proposal which has the earliest ProposalLineItem.startDateTime. This attribute will be null, if this proposal has no related line items, or none of its line items have a start time. This attribute is read-only.

EndDateTime Datetime True

The date and time at which the order and line items associated with the Proposal stop being served. This attribute is derived from the proposal line item of the proposal which has the latest ProposalLineItem.endDateTime. This attribute will be null, if this proposal has no related line items, or none of its line items have an end time. This attribute is read-only.

Status String True

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

The allowed values are DRAFT, PENDING_APPROVAL, APPROVED, REJECTED, UNKNOWN.

IsArchived Boolean True

The archival status of the Proposal. This attribute is read-only.

Advertiser String False

The advertiser, to which this Proposal belongs, and a set of Contact objects associated with the advertiser. The ProposalCompanyAssociation.type of this attribute should be ProposalCompanyAssociationType.ADVERTISER. This attribute is required when the proposal turns into an order, and its ProposalCompanyAssociation.companyId will be copied to Order.advertiserId. This attribute becomes readonly once the Proposal has been pushed.

Agencies String False

List of agencies and the set of Contact objects associated with each agency. This attribute is optional. A Proposal only has at most one Company with ProposalCompanyAssociationType.PRIMARY_AGENCY type, but a Company can appear more than once with different ProposalCompanyAssociationType values. If primary agency exists, its ProposalCompanyAssociation.companyId will be copied to Order.agencyId when the proposal turns into an order.

InternalNotes String False

Provides any additional notes that may annotate the Proposal. This attribute is optional and has a maximum length of 65,535 characters. This attribute can be configured as editable after the proposal has been submitted. Please check with your network administrator for editable fields configuration.

PrimarySalesperson String False

The primary salesperson who brokered the transaction with the advertiser. This attribute is required when the proposal turns into an order. This attribute can be configured as editable after the proposal has been submitted. Please check with your network administrator for editable fields configuration.

SalesPlannerIds Long False

List of unique IDs of User objects who are the sales planners of the Proposal. This attribute is optional. A proposal could have 8 sales planners at most. This attribute can be configured as editable after the proposal has been submitted. Please check with your network administrator for editable fields configuration.

PrimaryTraffickerId Long False

The unique ID of the User who is primary trafficker and is responsible for trafficking the Proposal. This attribute is required when the proposal turns into an order, and will be copied to Order.primaryTraffickerId . This attribute can be configured as editable after the proposal has been submitted. Please check with your network administrator for editable fields configuration.

SellerContactIds Long False

Users who are the seller's contacts.

AppliedTeamIds Long False

The IDs of all teams that the Proposal is on directly. This attribute is optional. This attribute can be configured as editable after the proposal has been submitted. Please check with your network administrator for editable fields configuration.

AppliedLabels String False

The set of labels applied directly to the Proposal. This attribute is optional.

EffectiveAppliedLabels String True

Contains the set of labels applied directly to the proposal as well as those inherited ones. If a label has been negated, only the negated label is returned. This attribute is read-only.

CurrencyCode String False

The currency code of this Proposal. This attribute is optional and defaults to network's currency code.

IsSold Boolean True

Indicates whether the proposal has been sold, i.e., corresponds to whether the status of an Order is OrderStatus.APPROVED or OrderStatus.PAUSED. This attribute is read-only.

LastModifiedDateTime Datetime True

The date and time this Proposal was last modified. This attribute is read-only.

MarketplaceInfo String False

The marketplace info of this proposal if it has a corresponding order in Marketplace.

BuyerRfp String False

The buyer RFP associated with this Proposal, which is optional. This field will be null if the proposal is not initiated from RFP.

HasBuyerRfp Boolean False

Whether a Proposal contains a BuyerRfp field. If this field is true, it indicates that the Proposal in question orignated from a buyer.

DeliveryPausingEnabled Boolean False

Whether pausing is consented for the Proposal. This field is optional and defaults to true. If false, it indicates that the buyer and the seller agree that the proposal should not be paused.

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