Search
Clear search
Close search
Google apps
Main menu

This help center content is for DFP sales management, which might not be enabled in your network.

DART Sales Manager reporting and DFP sales management

The following table helps you map information from legacy DART Sales Manager (DSM) reports to DFP sales management reporting. Reports for DFP sales management are now created with the DFP reporting tool. Learn more.

When using the table:

  • First, find the legacy filter, field, or metric in the Legacy DSM column.

  • Next, use the DFP sales management column to locate the equivalent information in DFP sales management. You’ll see the settings that are needed to see this data in your report. The actual item is bold.

    • Note that the column indicates only one of the ways you can see this data. It may be possible to use a different combination of settings to see the same data.
    • A value of NA indicates that the legacy item was not used often, so we didn't include an equivalent in DFP sales management. In a few cases, it means we're still trying to determine if we'll add an equivalent item.


Legacy DSM DFP sales management
Ad Actuals Report type: Sales
Date range: One or more full months
Metric: Reconciliation > DFP volume
Ad End Date / Proposal Product End Date Report type: Sales
Dimension: Sales > Proposal line item
Attribute: End time
Ad Final Value to Month (Gross) NA
Ad Final Value (Local Gross) Report type: Sales
Metric: Billing > Billable revenue (gross) (local)
Ad ID Report type: Historical
Dimension: Delivery > Line item
Attribute: The report will automatically include the ID.
Ad Local End Date Report type: Sales
Dimension: Sales > Proposal line item
Attribute: End time
Ad Local Start Date Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Start time
Ad Name Comments Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Comments
Ad Name / Proposal Product Name Report type: Sales
Dimension: Sales > Proposal line item
When you select the Proposal line item dimension, the report will automatically include the names.
Ad Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (net)
Ad Reconciled Quantity Report type: Sales
Date range: One or more full months
Metric: Reconciliation > Reconciled volume
Ad Reconciled Subtotal (Local) Report type: Sales
Date range: One or more full months
Metric: Reconciliation > Reconciled Revenue
Ad Reconciled Total (Local) Report type: Sales
Metric: Billing > Billable Revenue (net) (local)
Ad Size Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Sizes
Ad Start Date / Proposal Product Start Date Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Start time
Ad Status Report type: Sales
Dimension: Sales > Proposal line item
Attribution: Proposal line item status
Ad Subtotal Value (Local Gross) Report type: Sales
Metric: Billable revenue before manual adjustment (gross) (local)
Ad Total Booked Value (Gross) NA
Ad Type Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Type / priority
Address 1 NA
Address 2 NA
Adjustment % Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Product adjustment
Advertiser ID Report type: Sales
Dimension: Sales > Proposal
Attribute: Advertiser ID
Advertiser Label Report type: Sales
Dimension: Delivery > Advertiser
Attribute: Labels
Advertiser Name Report type: Sales
Dimension: Sales > Proposal
Attribute: Advertiser
Advertiser Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate
There are several Rate attributes to choose from, including Rate (gross) and Rate (net).
Agency Commission Report type: Sales
Dimension: Sales > Proposal
Attribute: Agency commission rate
Agency Commission Value NA
Agency Description NA
Agency ID Report type: Sales
Dimension: Sales > Proposal
Attribute: Agency IDs
If there are multiple agencies for one proposal, all agencies will be listed and separated by commas.
Agency Name Report type: Sales
Dimension: Sales > Proposal
Attribute: Agencies
If there are multiple agencies for one proposal, all agencies will be listed and separated by commas.
Approval Rule NA
Approval Status Report type: Sales
Dimension: Sales > Proposal
Attribute: Approval Stage
Archived Report type: Sales
Dimension: Sales > Proposal
Attribute: Archival status
Base Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Listing rate (net)
Listing rate includes Premium from DFP sales management rate card.
Billing Cap Report type: Sales
Dimension: Sales > Proposal / Proposal Line Item
Attribute: Caps and rollovers
Billing Schedule Report type: Sales
Dimension: Sales > Proposal / Proposal Line Item
Attribute: Billing schedule
Billing Source Report type: Sales
Dimension: Sales > Proposal / Proposal Line Item
Attribute: Billing source
Budget Report type: Sales
Metric: Sales contract > Budget
Campaign End Date Report type: Sales
Dimension: Sales > Proposal
Attribute: End time
Campaign Start Date Report type: Sales
Dimension: Sales > Proposal
Attribute: Start time
City NA
Comments NA
Content Category NA
Contracted Ad Goal Quantity Report type: Sales
Metric: Sales total > Total contracted volume
Contracted Ad Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate
There are several Rate attributes to choose from, including Rate (gross) and Rate (net).
Contracted Agency Commission Value Report type: Sales
Metric: Contracted revenue > Contracted agency commission
Contracted Gross Value Report type: Sales
Metric: Contracted revenue > Contracted revenue (gross)
Contracted Local Gross Value Report type: Sales
Metric: Contracted revenue > Contract revenue (gross)(local)
Contracted Local Net Value Report type: Sales
Metric: Contracted revenue > Contracted revenue (net)(local)
Contracted Local Value Report type: Sales
Metric: Contracted revenue > Contracted revenue (net)(local)
Contracted Net Value Report type: Sales
Metric: Contracted revenue > Contracted revenue (net)
Contracted Quantity Report type: Sales
Metric: Sales contract > Contracted volume / Contracted impressions
Contracted volume can be days, impressions, or clicks.
Contracted impressions can only be impressions.
Cost Type Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate type
Countries NA
Country NA
Creative Specification ID NA
Creative Specification Name NA
Currency Code Report type: Sales
Dimension: Sales > Proposal
Attribute: Currency
DART Ad ID Report type: Historical
Dimension: Delivery > Line item
Attribute: The report will automatically include the ID.
DART Adapt NA
DART Order ID Report type: Historical
Dimension: Delivery > Order
Attribute: The report will automatically include the ID.
DART Order Status NA
DFP orders do not have status.
Dart Served Report type: Sales
Dimension: Sales > Product
Attribute: Product type
Delivery NA
Description NA
DFP Billing Source[DBS] NA
Email NA
Enable Monthly Rate NA
End Date Report type: Sales
Dimension: Sales > Proposal line item
Attribute: End time
Exchange Rate Report type: Sales
Dimension: Sales > Proposal
Attribution: Exchange rate
External Ad ID NA
External Advertiser ID Report type: Sales
Dimension: Delivery > Advertiser
Attribute: External Advertiser ID
External Agency ID Report type: Sales
Dimension: Sales > Proposal agency
Attribute: External Agency ID
Fax NA
First Name NA
Flat Fee Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate type
Geo Targeting NA
Geography NA
Gross Contracted Value Report type: Sales
Metric: Contracted revenue > Contracted revenue (gross)
Gross Local Ad Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (gross) (local)
Gross Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (gross)
Internet Related NA
Interstitial NA
Keyword NA
Keywords and Key-values NA
Last Name NA
Last Proposal Status Report type: Sales
Dimension: Sales > Proposal
Attribute: Proposal status
Last Reconciliation Date Report type: Sales
Date range: One or more full months
Metric: Reconciliation > Last reconciliation time
Last Version Date NA
Last Version Number NA
Lifetime Ad Clicks NA
Lifetime Ad Contracted NA
Lifetime Ad Impressions NA
Lifetime Ad Reconciled Quantity NA
Lifetime Ad Reconciled Value NA
Lifetime Ad Scheduled NA
Line Item Commission Value Report type: Sales
Metric: Contracted revenue > Contracted agency commission
DFP sales management calculates four type of agency commissions: Contracted, Billable, Pipeline, and Unified. The revenue numbers are prorated to the date range you set for the report.
Line Item ID Report type: Sales
Dimension: Sales > Proposal line item
When you select the Proposal line item dimension, the report will automatically include the ID.
Line Item Name Report type: Sales
Dimension: Sales > Proposal line item
When you select the Proposal line item dimension, the report will automatically include the name.
Local Ad Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (net) (local)
Local Gross Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (gross) (local)
Local Gross Value NA
Local Net Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (net) (local)
Local Net Value NA
Local Value NA
Mediavisor RFP Campaign ID NA
MediaVisor Site Placement ID NA
NDSA Billing Source Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Billing source
Net Contract Value Report type: Sales
Metric: Contracted revenue (net)
Net Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (net)
Net Value NA
Not Served by DART Report type: Sales
Dimension: Sales > Product
Attribute: Product type
Offline Charge Report type: Sales
Dimension: Sales > Product
Attribute: Product type
Order End Date Report type: Historical
Dimension: Delivery > Order
Attribute: End date
Order ID Report type: Historical
Dimension: Delivery > Order
Attribute: The report will automatically include the ID.
Order Name Report type: Historical
Dimension: Delivery > Order
Attribute: The report will automatically include the name.
Order Name / Proposal Name Report type: Sales
Dimension: Sales > Proposal
When you select the Proposal dimension, the report will automatically include the name.
Order Start Date Report type: Historical
Dimension: Delivery > Order
Attribute: Start date
Order/Proposal End Date Report type: Sales
Dimension: Sales > Proposal
Attribute: End time
Order/Proposal Start Date Report type: Sales
Dimension: Sales > Proposal
Attribute: Start time
OSI Report type: Historical
Dimension: Delivery > Line item
Metric: Total > Delivery indicator
Package ID Appears when you export a report and choose to include IDs in the export options.
Package Name Appears by default.
Package Use Only NA
Partner Name NA
Phone NA
PO Number Report type: Sales
Dimension: Sales > Proposal
Attribute: PO number
Postal Code NA
Pricing Mode Report type: Sales
Dimension: Sales > Proposal
Attribute: Pricing model
Pricing Source NA
Primary Traffickers NA
Priority Report type: Sales
Dimension: Sales > Product
Attribute: Type / priority
Probability of Close Report type: Sales
Dimension: Sales > Proposal
Attribute: Probability of close
Product Comments Report type: Sales
Dimension: Sales > Product
Attribute: Notes
Product Creation Date NA
Product Creator NA
Product Custom Fields Report type: Sales
Dimension: Sales > Product
Attribute: custom field name
Product Description NA
Can be covered by the Notes attribute under the Product dimension, or the Description attribute under the Product template dimension.
Product End Date NA
Product ID Report type: Sales
Dimension: Sales > Product
When you select the Product dimension, the report will automatically include the ID.
Product Name Report type: Sales
Dimension: Sales > Product
When you select the Product dimension, the report will automatically include the name.
Product Size NA
Product Start Date NA
Product Status Report type: Sales
Dimension: Sales > Product
Attribute: Status
Product Type Report type: Sales
Dimension: Sales > Product
Attribute: Product Type
Promotional NA
Proposal - Contact/Surname NA
Proposal Approval Status Report type: Sales
Dimension: Sales > Proposal
Attribute: Proposal status
Proposal Commission Value Report type: Sales
Metric: Contracted revenue > Contracted agency commission
Proposal Creation Date Report type: Sales
Dimension: Sales > Proposal
Attribute: Creation time
Proposal Creation Date/Time (Local) Report type: Sales
Dimension: Sales > Proposal
Attribute: Creation time
Proposal Creator Report type: Sales
Dimension: Sales > Proposal
Attribute: Creator
Proposal Custom Fields Report type: Sales
Dimension: Sales > Proposal
Attribute: custom field names
Proposal Due Date Report type: Sales
Dimension: Sales > Proposal
Attribute: Expire time
Proposal End Date/Time (Local) Report type: Sales
Dimension: Sales > Proposal
Attribute: End time
Proposal ID Report type: Sales
Dimension: Sales > Proposal
When you select the Proposal dimension, the report will automatically include the ID.
Proposal line item custom fields Report type: Sales
Dimension: Sales > Proposal line item
Attribute: custom field names
Proposal Line item fields Report type: Sales
Dimension: Sales > Proposal line item
Attribute: field names
Proposal Name Report type: Sales
Dimension: Sales > Proposal
When you select the Proposal dimension, the report will automatically include the name.
Proposal Product End Date NA
See Ad End Date
Proposal Product ID Report type: Sales
Dimension: Sales > Proposal line item
When you select the Proposal line item dimension, the report will automatically include the ID.
Proposal Product Name Report type: Sales
Dimension: Sales > Proposal line item
When you select the Proposal line item dimension, the report will automatically include the name.
Proposal Product Rate Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Rate (net) / Rate (gross)
Proposal Product Start Date NA
Proposal Start Date/Time (Local) Report type: Sales
Dimension: Sales > Proposal
Attribute: Start time
Proposal Time Zone NA
Rate CPC NA
Rate CPD NA
Rate CPM NA
Reconciliation 1 Quantity Comments[RC1] NA
Reconciliation Quantity[RQ1] Report type: Sales
Date range: One or more full months
Metric: Reconciliation > Reconciled volume
Reservation Date NA
Reservation Status Report type: Sales
Dimension: Sales > Proposal Line Item
Attribute: Reservation status
Restricted NA
Rollover Balance Report type: Sales
Date range: One or more full months
Metric: Billing > Delivery rollover
Sales Channel NA
Sales Channel ID NA
Sales Manager Billing Source Report type: Sales
Dimension: Sales > Proposal
Attribute: Billing source
Sales Manager Billing Source[PBS] Report type: Sales
Dimension: Sales > Proposal
Attribute: Billing source
Sales Manager Campaign End Date Report type: Sales
Dimension: Sales > Proposal
Attribute: End time
Sales Manager Campaign Start Date Report type: Sales
Dimension: Sales > Proposal
Attribute: Start time
Sales Region NA
Sales Team Report type: Sales
Dimension: Sales > Proposal
Attribute: Sales planners
Salesperson Report type: Sales
Dimension: Sales > Proposal
Attribute: Salesperson
Salesperson ID Report type: Sales
Dimension: Sales > Proposal
Attribute: Salesperson
Salesperson(Primary) Report type: Sales
Dimension: Sales > Proposal
Attribute: Salesperson
Scheduled Ad Goal Quantity NA
Scheduled Quantity NA
Secondary Traffickers NA
Served by DART Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Product type
Site ID Report type: Sales
Dimension: Inventory > Ad unit
When you select the Proposal line item dimension, the report will automatically include the ID.
Site Included NA
Site Name Report type: Sales
Dimension: Inventory > Ad unit
When you select the Proposal line item dimension, the report will automatically include the name.
Sites Report type: Sales
Dimension: Inventory > Ad unit
When you select the Ad unit dimension, the report will automatically include the sites delivery data.
Size Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Sizes
Slotting Calendar ID NA
Slotting Calendar Name NA
Sold Time Report type: Sales
Dimension: Sales > Proposal
Attribute: Sold time
Start Date Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Start time
State/Region NA
Status Report type: Sales
Dimension: Sales > Proposal
Attribute: Proposal status
Team Name Report type: Sales
Dimension: Sales > Proposal
Attribute: Teams
Third Party [TP] NA
Total Contracted Value of Ad Report type: Sales
Metric: Sales total > Total contracted revenue (net)
Total Contracted Value of Ad(Gross) Report type: Sales
Metric: Sales total > Total contracted revenue (gross)
Total CPC NA
Total CPD NA
Total CPM NA
Total Value of Booked Ad NA
Total Value of Proposal Product NA
User-Entered Adjustment Comments[AAC] NA
User-Entered Adjustment[AAV] NA
VAT Code NA
VAT Percentage(%) Report type: Sales
Dimension: Sales > Proposal
Attribute: VAT rate
Weight Report type: Sales
Dimension: Sales > Proposal line item
Attribute: Goal (%)
Workflow Group NA
Zone ID NA
Zone Included NA
Zone Name NA
Was this article helpful?
How can we improve it?