Standard Client Orders and Vendor Billing Table
|
Standard Client Orders and Vendor Billing Report Fields |
||
|---|---|---|
|
Report Name (file name format) |
VendorBilling_OrderID_YYYYMMDD_2400_timezone (military time) VendorBilling_<CampaignID>_YYYYMMDD_2400_Timezone VendorBilling_SelectedCampaigns_YYYYMMDD_2400_Timezone |
Vendor Billing
|
|
ClientOrders_AllCampaigns_OrderID_YYYYMMDD_2400_Timezone ClientOrders_<campaignID>_OrderID_YYYYMMDD_2400_Timezone ClientOrders_SelectedCampaigns_OrderID_YYYYMMDD_2400_Timezone |
Client Orders | |
| Column Name | Description | Report |
|---|---|---|
|
Order ID |
Unique alphanumeric number assigned with the vendor/campaign identification |
Client Orders Vendor Billing |
|
Client |
Entity or organization responsible for payment and involved with planning and analysis |
Client Orders Vendor Billing |
|
Brand |
Entity or organization owner of goods, services, or range of products that represents the company |
Client Orders Vendor Billing |
|
Initiative |
Campaign details of a marketing strategy including brand, budget, duration, and performance |
Client Orders Vendor Billing |
|
Campaign
Campaign Name |
Title/name of the campaign (line item(s) or package) |
Client Orders
Vendor Billing |
|
Campaign ID |
Unique identification number for an organization using letters and/or numbers for a campaign (collection of line items) |
Client Orders Vendor Billing |
| Campaign Status |
Current stage of the campaign: Planning, Approved, Live, Completed, or Archived. |
Client Orders Vendor Billing |
|
Description |
Overall details (goals and strategy), process, purchase, and delivery of an ad |
Client Orders Vendor Billing |
| Vendor |
Name of the organization selling and offering products, content, and services for payment DSP line items: Displays Basis DSP |
Client Orders Vendor Billing |
| Payee |
Name of the entity selling and offering products, content, and services for payment including properties of websites along with ad server DSP line items: Displays Basis DSP |
Client Orders Vendor Billing |
|
Property |
Name of the inventory (advertising space) Add-ons: Name of the service provider DSP line items: Displays Basis DSP |
Client Orders Vendor Billing |
|
Flight Start Date |
First day of the flight Start Date can fall before the billing period. |
Client Orders Vendor Billing |
|
Flight End Date |
Last day of the flight End Date can fall after the billing period. |
Client Orders Vendor Billing |
| Cost Type |
Cost per type, such as CPC, for DSP-dCPM (gross or net cost type) |
Client Orders Vendor Billing |
|
Media Contracted Units |
Number of media units ordered based on the insertion order (net contracted units) |
Client Orders |
|
Rate |
Amount charged the campaign based on the insertion order (net rate) |
Vendor Billing |
| Net Media Contracted Rate |
Media amount charged the campaign based on the insertion order (Net view) |
Client Orders |
|
Net Contracted Units |
Number of net units ordered based on the insertion order |
Vendor Billing |
|
Net Media Contracted Amount
Net Contracted Amount |
Total amount charged to the client with successful delivery of the line item. Amount includes margin or markup and other media costs.
|
Client Orders
Vendor Billing |
|
Net Ad Serving Contracted Rate |
Total ad serving charged based on the contracted rate and units (Net view) |
Client Orders |
|
Net Ad Serving Contracted Amount |
Total ad serving cost based on the contracted rate and units (Net view) |
Client Orders |
| Net Add-on Contracted Amount | Total add-ons cost based on the contracted rate (Net view) | Client Orders |
| Margin or Markup % Contracted |
Upcharge rate by percentage (%) of normal cost |
Client Orders |
| Margin or Markup Cost Contracted | Amount of the upcharge (Gain) | Client Orders |
| Gross Media Contracted Rate |
Total rates the client/brand pays for the campaign including media, ad serving, and margin or markup (Gross view) |
Client Orders |
| Gross Media Contracted Amount |
Total contracted amount (price) including media, ad serving, margin or markup, etc. fees to a buyer (Gross view) |
Client Orders |
|
Gross Ad Serving Contracted Rate |
Total ad serving charged based on the contracted rate and units (Gross view) |
Client Orders |
| Gross Ad Serving Contracted Amount | Total ad serving cost based on the contracted rate and units (Gross view) | Client Orders |
| Gross Add-on Contracted Amount | Total add-ons cost based on the contracted rate (Gross view) | Client Orders |
| Gross Total Contracted Rate | Grand total the client/brand pays for the campaign(Gross view) | Client Orders |
| Gross Total Contracted Amount | Grand total contracted amount (price) for the campaign (Gross view) | Client Orders |
|
Delivered Units
Net Delivered Units |
Number of units delivered (capped) |
Client Orders
Vendor Billing |
|
Net Spend |
Net amount of billed media (per flight) If your DSP line item has a tactic add-on applied, it is excluded from this value. |
Vendor Billing |
| Net Media Spend |
Net amount of billed media (per flight) If your DSP line item has a tactic add-on applied, it is included in this value. |
Client Orders |
| Net Ad Serving Spend | Total of ad serving amount charged for the billed units to date (Net view) | Client Orders |
| Net Add-on Spend | Total of add-ons amount charged for the billed units to date (Net view) | Client Orders |
| Gross Media Spend |
Total client amount charged for the billed units to date, also known as total spend (per flight) (Gross view) |
Client Orders |
| Gross Ad Serving Spend |
Total of ad serving amount charged for the billed units to date (Gross view) |
Client Orders |
| Gross Total Spend |
Grand total amount for the campaign (Gross view) including media, ad serving, add-ons, etc. |
Client Orders |
| Month | Month and year of the report | Vendor Billing |
| Approval Time stamp |
Client approval upload of the date and time format mm/dd/yyyy HH:MM AM/PM |
Client Orders |
| Revision Time stamp |
Revised plan for the date and time format mm/dd/yyyy HH:MM AM/PM |
Vendor Billing |
| Naming Conventions | Line item naming convention generated for this campaign. | Client Orders |