Advantage Client Orders Fields Table

INTERNET_ERP_ClientOrders_AllCampaigns_YYYYMMDD_2400_Timezone.csv (or zip)

INTERNET_ERP_ClientOrders_<CampaignID>_YYYYMMDD_2400_Timezone.csv (or zip)

INTERNET_ERP_ClientOrders_SelectedCampaigns_YYYYMMDD_2400_Timezone.csv (or zip)

Example of zip file includes ClientOrders_Selected Campaigns and INTERNET_ERP_ClientOrders_Selected campaigns directory.

File names via FTP:

INTERNET_Advantage_ClientOrders_PreAllCampaigns_20190222_1029_CST.csv

INTERNET_Advantage_ClientOrders_PostAllCampaigns_20190222_1029_CST.csv

Unique campaign order number generated based on campaign and vendor (Invoice number)

The Order ID matches with the reports for a buyer organization.

For client orders with ad serving, the order ID represents a single line per flight

Ad serving: Vendor name

Summary/description generated based on the campaign and vendor (Maximum characters: 40)

External vendor code (Maximum characters: 6)

Select Advantage ID on the directory vendor page

Select Advantage ad serving ID under the Setup Advantage Account page

Title or name of the vendor payee (Maximum characters: 30) or service provider

Buyer name/title (Maximum characters: 40)

Client (entity or organization responsible for payment ) code or campaign ID (Maximum characters: 6)

Select Advantage ID in client details page

Client name or title (Maximum characters: 30)

Division ID code (Maximum characters: 6)

Select ID in Basis campaign details

Product ID code (Maximum characters: 6)

Select ID in campaign details

Campaign order sales class ID code for billing (Maximum characters: 6)

Select ID in campaign details

Confirm sales class at media plan approval

Advantage ERP Campaign ID linking orders to Basis campaigns (Maximum characters: 6)

Select Advantage Campaign ID in campaign details at media plan approval and editable upon revision

Market (audience location) code (Maximum characters: 4)

Summary/description of the market (Maximum characters: 40)

Client purchase order number (Maximum characters: 25)

Vendor representative code (Maximum characters: 4)

Additional vendor representative code (Maximum characters: 4)

Indication of the buy is purchased from a vendor as a net or gross purchase type (net or gross spend)

Ad serving: Net

Comment for order header based on the Order ID/Name (Maximum characters: 254)

Unique line numbers generated based on the placements starting with 1

Pre and Post-bills line numbers are based on the 1 plus the month and year (2 digits). Example: 1 + May + 2018 = 10518

Ad serving is displayed as a line per flight corresponding with the order ID.

The line number does not change and increments as line items are added.

Headline (Maximum characters: 60)

Ad number on the order (Maximum characters: 30)

Ad number description/summary (Maximum characters: 30)

Web site address (uniform resource locator) or description of the property (Maximum characters: 60)

Web site address for the ad server name

Ad size (Maximum characters: 6)

Ad size description/summary (format) to identify the size (Maximum characters: 60)

Copy comments (Maximum characters: 40)

Placement name (Maximum characters: 160)

(Maximum characters: 160)

Internet type code (Maximum characters: 6)

Job number linking to the order ID/Name

Component number linking to the order ID/Name

First day of the campaign (planning or live status)

(mm/dd/yyy)

Last day of the campaign (planning or live status)

(mm/dd/yyy)

Unit rate type

(net cost type - CPM, CPC, CPA, NA (dCPM))

Cost/price of unit (net rate)

Ad serving: Ad serving rate

Quantity of projected impressions

Ad serving: Quantity of estimated impressions

Value based on cost type, guaranteed imps, and rate (net contracted cost)

If your DSP line item has a tactic add-on applied, it is included in this value.

Ad Serving: Ad serving cost

Indication campaign revision code

For example, 0 = New and 1 = Revised

(N/A when billing after delivered.)

Ad serving: 1 (Revised)

Insert or canceled status code (I=Insert (new), C = Canceled)

Ad serving: I

Campaigns with media system layout, such as N1 = Tribune (Maximum characters: 2)

Ad serving: CT

Process status

For example, Null = Pending