Pepperjam | Transaction History Standard Dataset

Below are the fields Alight Analytics considers standard for the Transaction History dataset from Pepperjam. There is a 1-day lag, 5-day lookback window on this dataset and data will be refreshed daily.

Field Name Type Description
report_date Date   
process_date Date Time  
sale_date Date Time  
commission Number  
company Dimension  
item_id Dimension  
link_type Dimension  
order_id Dimension  
publisher Dimension  
publisher_commission Number  
publisher_id Dimension  
publisher_type Dimension  
publisher_join_date Date Time  
publisher_request_date Date Time  
publisher_company Dimension  
publisher_status Dimension  
publisher_first_name Dimension  
publisher_last_name Dimension  
publisher_country Dimension  
publisher_state Dimension  
publisher_term Dimension  
publisher_transparency Dimension  
publisher_website Dimension  
revision Dimension  
sale_amount Number  
site_commission Number  
status Dimension  
transaction_id Dimension  
transaction_type Dimension  
website_url Dimension  
insert_date Date Time Internal use: when the row was inserted in the table  
channelmix_profile Dimension Contents defined by Alight
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.