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
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.