Hatch | Sales Standard Dataset
This article details the dataset structure that Alight Analytics considers standard for the Sales 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 |
| Order ID | Dimension | Order ID (usefull to regroup several purchases, i.e. basket) |
| Order Status | Dimension | Sales type |
| Cookie | Dimension | Cookie value |
| Brand Name | Dimension | Affiliate Name |
| Country Name | Dimension | Lead country |
| Retailer Name | Dimension | Retailer Name |
| Category Name | Dimension | Product Category |
| Lead ID | Dimension | Lead Id |
| Pixel String | Dimension | Pixel string |
| Vendor Name | Dimension | Product Brand |
| Product ID | Dimension | Internal Hatch Id |
| MPN | Dimension | Product MPN |
| EAN | Dimension | Product MPN |
| Product Tag | Dimension | Product Tag |
| Campaign Name | Dimension | Hatch Campaign ref |
| Description | Dimension | Product description |
| QTY | Number | Order quantity |
| Original Price | Currency | Product price |
| Original Total Amount | Currency | Order amount (depending on orderStatus) |
| Original Currency | Dimension | Product currency |
| Converted Price | Currency | Product converted price |
| Converted Total Amount | Currency | Order amount converted |
| Converted Currency | Dimension | Product converted currency |
| 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 |
| My Sale | Boolean | Was this a my sale? Returns yes or no |
| 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 |