Hatch | Leads Standard Dataset
ChannelMix
This article details the dataset structure that Alight Analytics considers standard for the Leads Report dataset from Hatch. There is a 1 day lag with a 7 day span that will be run daily.
| Field | Type | Description |
| Report Date | Date | Lead date |
| Time | Dimension | Lead time |
| Session Key | Dimension | Lead session key |
| Lead ID | Dimension | Lead Id |
| Country | Dimension | Lead country |
| Brand Name | Dimension | Affiliate Name |
| Retailer ID | Dimension | Retailer ID |
| Feed ID | Dimension | Retailer ID (Legacy) |
| Retailer Name | Dimension | Retailer Name |
| Product ID | Dimension | Internal Hatch Id |
| MPN | Dimension | Product MPN |
| Product Tag | Dimension | Product Tag |
| Campaign Name | Dimension | Hatch Campaign ref |
| Model Name | Dimension | Model Name |
| Vendor Name | Dimension | Product Brand |
| Category Name | Dimension | Product Category |
| Original Price | Currency | Product price |
| Original Currency | Dimension | Product currency |
| Converted Price | Currency | Product converted price |
| Converted Currency | Dimension | Product converted currency |
| Device Type | Dimension | Lead device origin |
| Operating System | Dimension | Lead OS origin |
| CID | Dimension | Lead CID |
| VAR1 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR2 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR3 | Currency | These variables store any extra parameters that had been defined during the setup |
| VAR4 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR5 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR6 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR7 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR8 | Dimension | These variables store any extra parameters that had been defined during the setup |
| VAR9 | Dimension | These variables store any extra parameters that had been defined during the setup |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset |
| ChannelMix Profile | Dimension | ChannelMix Field: the ChannelMix Profile associated to the data |