ChannelMix | Predictive Modeling Pacing Dataset
The ChannelMix Predictive Modeling Pacing Dataset is used to power the Pacing Summary tabs of paid media dashboards. It contains a subset of recommendations that ChannelMix has cached and provides all relevant information necessary to pace the recommendation over the given optimization window.
The dataset is refreshed at the same cadence as the Predictive Model - monthly by default.
New data generated has the Planning status, meaning the optimization window has not started yet and will not appear in the dashboard. Once the current date falls within the optimization window, the recommendations will enter Active state and appear in the dashboard. Inactive date (within an optimization period that ended more than 60 days ago) are no longer shown in the dashboard.
|
Field Name |
Field Type |
Description |
| Cluster ID | INTEGER | A unique ID given to all members of a cluster. |
| Report Date | DATE | A single date in the optimization window for this record. |
| Start Date | DATE | First date in this recommendation's optimization window. |
| End Date | DATE | Final date in this recommendation's optimization window. |
| Status | TEXT | Is this optimization window active, inactive, or in the planning state? |
| Feature | TEXT | Name of the feature in the dataset. |
| Spend | DOUBLE PRECISION | Recommended daily spend for the given feature. |
| Control | DOUBLE PRECISION | Daily value of the feature if its part of the control feature set. |
| Daily Pace | DOUBLE PRECISION | Expected value of the target variable for a given report date according to the chosen recommendation. |
| Budget | DOUBLE PRECISION | The total budget for the given recommendation. |
| Conversions | DOUBLE PRECISION | The total number of conversions expected for the given recommendation. |
| Model ID | TEXT | Unique ID relating this record to the model that generated it. |
| Scenario ID | TEXT | Unique ID used to distinguish date scenarios. |
| Scenario Name | TEXT | Descriptive name for the given scenario. |
| Category | TEXT | Category value, if applicable. |
| Category Type | TEXT | Feature used to build categories, if applicable. |
| Pacing ID | TEXT | Unique ID to identify this cached recommendation. |
| Cost Per | DOUBLE PRECISION | Aggregate cost per for this recommendation. |
| N Days | INTEGER | Number of days in this recommendation's optimization window. |
| To Cache | TEXT | Is this one of the cached recommendations? If so, which one? |
| Target Variable | TEXT | Name of the selected target variable in the database. |
| Target Variable Pretty | TEXT | Formatted name for the given target variable. |
| Feature Type | TEXT | Name of the field in the database used to build features. |
| OneView Name | TEXT | Name of the OneView powering this dataset. |
| Insert Date | TIMESTAMP | The date in which the record was loaded into the data warehouse |
| ChannelMix Profile | TEXT | The ChannelMix Profile associated to the data |
Version 2023.3