Pepperjam | Transaction History Standard Dataset
ChannelMix
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 |