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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.