The Trade Desk | Basic Performance Stats Standard Dataset
Below are the measures and dimensions Alight Analytics considers standard for the Trade Desk Basic Performance Stats Standard dataset.
This dataset pulls data from a report that is created by the user in their Trade Desk user interface. Please see the screenshots below for assistance with creating the Basic Performance Stats report using the template within the Trade Desk user interface. You can view a more in-depth tutorial on creating Trade Desk reports here.
| Field Name | Field Type | Description |
| Report Date | DATE | The date the activity occurred |
| Advertiser | STRING | Naming convention of your advertiser |
| Campaign | STRING | Naming convention of your campaign |
| Ad Group | STRING | Naming convention of your ad group (known as a line item or package) |
| Media Type | STRING | Type of media used |
| Ad Format | STRING | Format of your creative (for example, 300x250, 728x90, 120x600) |
| Creative | STRING | Naming convention of your creative |
| Creative ID | STRING | ID associated with your creative, written as a series of letters and numbers (for example. h3mrsbiq) |
| Device Type | STRING | Specific type of a device |
| Advertiser Currency Code | STRING | Currency that your advertiser uses |
| Advertiser Cost (Advertiser Currency) | FLOAT | Partner cost + agency fees (if applied in the campaign's fees and rates) |
| Impressions | INTEGER | Total number of impressions won. For DOOH, this is the number of auctions won, which reveals how many times your ad played back. Also referred to as "spot play" or "served impression." |
| Clicks | INTEGER | Total number of clicks |
| Player Starts | INTEGER | Number of times that a video ad is started |
| Player Views | INTEGER | Number of times that a video ad was viewed |
| Player 25% Complete | INTEGER | Number of player ads played through to the first quarter |
| Player 50% Complete | INTEGER | Number of videos played through to the mid-point |
| Player 75% Complete | INTEGER | Number of videos played through to the third quarter |
| Player Completed Views | INTEGER | Number of video ads watched through to completion |
| Click Conversion 01 | FLOAT | Number of conversions attributed to clicks for the conversion labeled as TD 01 in the Trade Desk user interface |
| Click Conversion 02 | FLOAT | Number of conversions attributed to clicks for the conversion labeled as TD 02 in the Trade Desk user interface |
| Click Conversion 03 | FLOAT | Number of conversions attributed to clicks for the conversion labeled as TD 03 in the Trade Desk user interface |
| Click Conversion 04 | FLOAT | Number of conversions attributed to clicks for the conversion labeled as TD 04 in the Trade Desk user interface |
| Click Conversion 05 | FLOAT | Number of conversions attributed to clicks for the conversion labeled as TD 05 in the Trade Desk user interface |
| View Through Conversion 01 | FLOAT | Total number of conversions attributed to views for the conversion labeled as TD 01 in the Trade Desk user interface |
| View Through Conversion 02 | FLOAT | Total number of conversions attributed to views for the conversion labeled as TD 02 in the Trade Desk user interface |
| View Through Conversion 03 | FLOAT | Total number of conversions attributed to views for the conversion labeled as TD 03 in the Trade Desk user interface |
| View Through Conversion 04 | FLOAT | Total number of conversions attributed to views for the conversion labeled as TD 04 in the Trade Desk user interface |
| View Through Conversion 05 | FLOAT | Total number of conversions attributed to views for the conversion labeled as TD 05 in the Trade Desk user interface |
| Total Click + View Conversions 01 | FLOAT | Total number of conversions, from both click attribution conversion count and view attribution conversion count, in the relative reporting column number for the assigned tracking tags |
| Total Click + View Conversions 02 | FLOAT | Total number of conversions, from both click attribution conversion count and view attribution conversion count, in the relative reporting column number for the assigned tracking tags |
| Total Click + View Conversions 03 | FLOAT | Total number of conversions, from both click attribution conversion count and view attribution conversion count, in the relative reporting column number for the assigned tracking tags |
| Total Click + View Conversions 04 | FLOAT | Total number of conversions, from both click attribution conversion count and view attribution conversion count, in the relative reporting column number for the assigned tracking tags |
| Total Click + View Conversions 05 | FLOAT | Total number of conversions, from both click attribution conversion count and view attribution conversion count, in the relative reporting column number for the assigned tracking tags |
| All Last Click + View Conversions | FLOAT | All pixels' total number of conversions, as calculated by (total click + view-through conversions) |
| All Last Click + View Conversions Revenue | FLOAT | The sum of all pixels' conversion revenue |
| Report Start Date | DATE | The start date of the report that was pulled |
| Report End Date | DATE | The end date of the report that was pulled |
| Insert Date | TIMESTAMP | ChannelMix Field - When the row was inserted into ChannelMix |
| ChannelMix Profile | STRING | ChannelMix Field - The descriptive name assigned to this data segment |
Creating the Basic Performance Stats Report using the Trade Desk user interface:
NOTE: You can view a more in-depth tutorial on creating Trade Desk reports here.
- Navigate to the "My Reports" page and select "Basic Perfomance Stats" within the standard templates.
- Select the fields listed above for the standard dataset dimensions and metrics (note that this screenshot is not a complete representation of all fields listed above).
- Complete your report creation:
- Select the desired advertiser.
- Select the date range that you’d like to include in your report each day. If you choose a window of time (e.g. Last 7 Days) then ChannelMix will refresh the data for any days that already exist in your data warehouse with the newest data available. We recommend selecting Last 7 Days or Last 14 Days for ongoing reports and a custom date range for backfill reports.
- Add the advertiser name to the Generated Schedule Name so it describes the report you are creating (e.g. “McDonalds | Last7Days | Basic Performance Stats”).
- Click “Run” on the report.
- Provide the name of the report to Alight Analytics via a ChannelMix Help Center ticket.