Impact | Media Performance Standard Dataset
Below are the measures and dimensions Alight Analytics considers standard for Impact - Media Performance dataset. There is a one day lag on Impact, and data is pulled for 30 days.
Field Name | Type | Description |
Media Partner | Text | Media Partner Name |
Join Date | Timestamp | Join Date |
Media Type | Text | Media Type |
Relationship | Text | Relationship Name |
Company URL |
Text | URL of Company |
Raw Impressions | Decimal | Raw Impressions |
Impressions | Decimal | Impressions |
Total Clicks | Decimal | Total Clicks |
Clicks | Decimal | Clicks |
Sales | Decimal | Sales |
Reversed Sales | Decimal | Reversed Sales |
Salerr | Decimal | Sale RR |
Reversed Revenue | Decimal | Reversed Revenue |
Reversed Sale Cost | Decimal | Reversed Sale Cost |
Leads | Decimal | Leads |
Reversed Leads | Decimal | Reversed Leads |
Leadrr |
Decimal | Leadrr |
Reversed Lead Cost | Decimal | Reversed Lead Cost |
Data Posts | Decimal | Data Posts |
Recruit Actions | Decimal | Recruit Actions |
Calls | Decimal | Number of calls |
Answered | Decimal | Number of calls answered |
Converted Calls | Decimal | Number of calls converted |
Downloads | Decimal | Number of downloads |
Installs | Decimal | Number of installs |
Other Mobile Actions | Decimal | Number of other mobile actions |
Actions | Decimal | Actions |
Sales Revenue | Decimal | Sales revenue |
Data Post Revenue | Decimal | Revenue from data post |
Call Revenue | Decimal | Revenue from calls |
Mobile Install Revenue | Decimal | Revenue from mobile installs |
Other Mobile Revenue | Decimal | Revenue from other mobile actions |
Revenue | Decimal | Revenue |
Sale Cost | Decimal | Cost of sale |
Lead Cost | Decimal | Cost of lead |
Data Post Cost | Decimal | Cost of data post |
Download Cost | Decimal | Cost of download |
Recruit Cost | Decimal | Cost of recruit |
Call Cost | Decimal | Cost of call |
CPC Cost | Decimal | Cost of CPC |
Install Cost | Decimal | Cost of install |
Other Mobile Cost | Decimal | Cost of other mobile actions |
Action Cost | Decimal | Action cost |
Client Cost | Decimal | Client Cost |
Other Cost | Decimal | Other Cost |
Total Cost | Decimal | Total Cost |
SKUs |
Decimal | SKU |
Quantity |
Decimal | Quantity |
Goods Cost | Decimal | Cost of goods |
Margin | Decimal | Margin |
Total Business Cost | Decimal | Total business cost |
ROI | Decimal | Return on investment |
Viewable Impressions | Decimal | Viewable impressions |
Rules Actions | Decimal | Rules actions |
Rules Revenue | Decimal | Rules revenue |
Algo Actions | Decimal | Algo Actions |
Algo Revenue | Decimal | Algo Revenue |
AOV | Decimal | Average Order Value |
Sale CR | Decimal | Sale CR |
Lead CR | Decimal | Lead CR |
Sale CPA | Decimal | Sale CPA |
Lead CPA | Decimal | Lead CPA |
CPC | Decimal | CPC |
Campaign ID | Text | Campaign ID |
MP ID | Text | MP ID |
ID | Text | ID |
Name | Text | Name |
Description | Text | Description |
Website | Text | Website |
State | Text | State |
Currency | Text | Currency |
Timezone | Text | Timezone |
Partner Type | Text | Partner Type |
Promotional Countries | Text | Promotional Countries |
Promotional Categories | Text | Promotional Categories |
Linked Accounts | Text | Linked Accounts |
Account Manager | Text | Account Manager |
Date Created | Timestamp | Date Created |
Date Last Updated | Timestamp | Date Last Updated |
Created By | Text | Created By |
Last Updated By | Text | Last Updated By |
URI | Text | URI |
Country | Text | Country |
Postal Code | Text | Postal Code |
City | Text | City |
Address 1 | Text | Address 1 |
Address 2 | Text | Address 2 |
Address State | Text | Address State |
Phone Country | Text | Phone Country |
Phone Number | Text | Phone Number |
Contact First Name | Text | Contact First Name |
Contact Last Name | Text | Contact Last Name |
Contact Email Address | Text | Contact Email Address |
Phone Number | Text | Phone Number |
Property ID | Text | Property ID |
Property URL | Text | Property URL |
Property Name | Text | Property Name |
Property Type | Text | Property Type |
Promotional Methods Type | Text | Promotional Methods Type |
Promotional Methods Is Primary | Text | Promotional Methods Is Primary |
Report Start Date | Date | Report Start Date |
Report End Date | Date | Report End Date |
Insert Date | Timestamp | Internal use: When the row was inserted in the table. |
ChannelMix Profile | Text | When needed, distinguishes between Impact accounts – Contents defined by Alight. |