Impact | Advanced Action Listings Standard Dataset
Below are the measures and dimensions Alight Analytics considers standard for Impact - Action dataset. There is a one day lag on Impact, and data is pulled for 30 days.
At ID |
Whole Number |
At ID |
Action Date |
Date Time |
Date of Action |
Action ID |
Text |
Unique identifier for the action |
Action Tracker |
Text |
Display name for the action tracker (or event type) that tracked the conversion associated with the action |
Campaign ID |
Whole Number |
Unique identifier for the campaign (or program) that the action is associated with |
Media Partner |
Text |
Media Partner Name |
OID |
Text |
The unique identifier for the order associated with this conversion. For example, in a retail sale, this could be the Order ID the brand assigned the customer for their purchase. |
Payout |
Decimal |
Commission amount calculated for the action that will be paid out to the partner |
Category | Text | Primary Category |
Promo Code |
Text |
Populates with the promotional code applied to the conversion if one was used. |
Rate | Decimal |
Rate |
Sales Amount |
Decimal |
Revenue amount associated with this action |
Shared ID |
Text |
The Shared ID value associated with the winning click for the action. This value is a query string parameter that you can append to the tracking link, typically used to share traffic segments (or other information) with the brand |
Status |
Text |
Status of action listing |
Sub ID 1 |
Text |
The first Sub ID value associated with the winning click for the action. This value is a query string parameter that you can append to the tracking link that will appear in your reporting. |
Sub ID 2 |
Text |
The second Sub ID value associated with the winning click for the action. This value is a query string parameter that you can append to the tracking link that will appear in your reporting. |
Sub ID 3 |
Text |
The third Sub ID value associated with the winning click for the action. This value is a query string parameter that you can append to the tracking link that will appear in your reporting. |
MP ID | Whole Number |
Media Partner ID |
Original Sale Amount |
Decimal |
Original amount for the action before any modifications |
ID | Whole Number | Action listing ID |
Original Payout | Decimal | Original payout amount for the action calculated by the template terms before any modifications. |
Insert Date | Date Time | Internal use: When the row was inserted in the table. |
ChannelMix Profile | Text |
When needed, distinguishes between Impact accounts – Contents defined by ChannelMix. |