StackAdapt | Native Ad Dataset
Below are the fields Alight Analytics considers standard for the StackAdapt Native Ad dataset v_stackadapt_native_ad. There is a one day lag on StackAdapt data, and we pull for the previous 7 days. Data is aggregated by day and ad.
This dataset is a great place to start if you're new to this source. If you don't see fields that you need for your reporting, please reach out - they may be available.
This dataset can be automatically activated without a ticket through Dataset Activation.
|
Field Name |
Type |
Additional Description |
|
Report Date |
Date |
The date the activity occurred. |
|
Campaign ID |
Integer |
|
|
Campaign |
Text |
|
|
Creative ID |
Integer |
|
|
Creative |
Text |
|
|
Channel |
Text |
Campaign type. |
|
Impressions |
Integer |
|
|
Clicks |
Integer |
|
|
CTR |
Decimal |
Click-through rate. |
|
Media Cost |
Decimal |
|
|
eCPA |
Decimal |
Effective cost per action or acquisition. |
|
eCPC |
Decimal |
Effective cost per click. |
|
eCPE |
Decimal |
Effective cost per engagement. |
|
eCPM |
Decimal |
Effective cost per mile. |
|
eCPV |
Decimal |
Effective cost per visit. |
|
Conversions |
Decimal |
|
|
CVR |
Decimal |
Conversion rate. |
|
Average Time (Sec) |
Decimal |
Average time that users spend on the landing page after clicking on your StackAdapt ad. |
| Total Time (Sec) |
Decimal |
Total time spent on the landing page by users who clicked on your StackAdapt ad. |
|
15s Engagements (LP) |
Decimal |
Number of "15 second or longer" visits that happened as a result of your campaign. |
|
Engagement Rate |
Decimal |
The ratio of users who clicked on your ad and then remained on the landing page for at least 15 seconds. |
|
Page Starts |
Integer |
How many times the page was loaded after a user clicks through from the ad. |
|
Unique Impressions |
Integer |
|
|
View Percent |
Decimal |
Ad viewability. |
|
Created At |
Date |
|
|
Updated At |
Date |
|
|
Brand Name |
Text |
|
|
Click URL |
Text |
|
|
Audit Status |
Text |
Indicator of whether an an has been audited or not. |
|
State |
Text |
Campaign status, e.g. active / paused / pending / draft. |
|
Line Item ID |
Integer |
|
|
Line Item |
Text |
Campaign group as defined by StackAdapt. |
|
Advertiser ID |
Integer |
|
|
Advertiser |
Text |
Client. |
|
Insert Date |
Date |
Internal use: when the row was inserted in the table. |
|
ChannelMix Profile |
Text |
When needed, distinguishes between accounts. |