ChannelMix | Attribution
The ChannelMix Attribution Dataset is used to support the Attribution template dashboard for both Tableau and Power BI. The dataset is an output of multiple model results which are designed to be aggregated by date.
The dataset refreshes daily as new conversion paths are created and processed. Dates in the template dashboard are relative to the current date and show the most recent results per model and filter combination.
| Field Name | Field Type | Description |
| Segment Column | TEXT | Name of the column used for segmenting the dataset e.g. Campaign, Geography, etc. |
| Segment Type | TEXT | The value of the segment column for these results e.g. Name of a Campaign, Oklahoma, etc. |
| Interaction Column | TEXT | Name of the column to attribute value across e.g. ChannelMix Channel, Source, etc. |
| Interaction Type | TEXT | The value of the interaction type for this record e.g. Paid Social, Display, etc. |
| Filter | TEXT | Names of the transformations performed on interaction paths prior to attributing value e.g. Filter Direct, Compress Paths |
| Last Interaction Window | TEXT | [Deprecated] |
| Last Interaction Date | DATE | The date used for training attribution models. Only paths that ended on this date will be counted in attribution results. |
| Lookback Window | TEXT | The description of days in the past from the conversion date that an interaction can be considered included in the conversion path e.g. last_30_days, last_60_days, last_90_days, last_180_days, lifetime |
| Model | TEXT |
The name of the methodology used to model your interaction data. First, Last, Linear, U-Shaped, Smooth-U, Bell, Time Decay, Data Driven |
| Attribution Value | DOUBLE PRECISION | The calculated value of the channel |
| Cost | DOUBLE PRECISION | The total cost spent on the last interaction date from existing ChannelMix Pipeline OneView |
| Impressions | DOUBLE PRECISION | The total impressions generated on the last interaction date from existing ChannelMix Pipeline OneView |
| Clicks | DOUBLE PRECISION | The total clicks generated on the last interaction datefrom existing ChannelMix Pipeline OneView |
| Conversions | DOUBLE PRECISION | The total conversions generated on the last interaction date. |
| Conversion Value | DOUBLE PRECISION | The total conversion value generated on the last interaction date. |
| Conversion Goal Number | TEXT | The Goal or Transaction used during attribution |
| Conversion Name Pretty | TEXT | A descriptive name for the goal or transaction e.g. Get Started Form Fill, PDF Download, etc. |
| Multi Touch Path Fraction | DOUBLE PRECISION | How many paths have more than one interaction for the corresponding last interaction date |
| Avg N Touches to Conversion | DOUBLE PRECISION | The average number of interactions for the corresponding last interaction date |
| Mean Days to Conversion | DOUBLE PRECISION | The average number of interactions for the corresponding last interaction date |
| Last Interaction Start Date | DATE | [Deprecated] The minimum date associated to the Last Interaction Window date range |
| Last Interaction End Date | DATE | [Deprecated] The maximum date associated to the Last Interaction Window date range |
| Lookback Start Date | DATE | The minimum date associated to the Lookback Window date range |
| Run Date | DATE | The date in which the attribution model was produced |
| With CMX ID | BOOLEAN | A flag to indicate if ChannelMix ID has been used or not |
| Model ID | TEXT | A unique ID related to each model |
| 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 |