Hatch | Leads Standard Dataset
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 |