StackAdapt | Campaign Dataset
Below are the fields Alight Analytics considers standard for the StackAdapt Campaign dataset v_stackadapt_campaign. There is a one day lag on StackAdapt, and we pull for the previous 7 days. Data is aggregated by day and campaign.
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 |
|
|
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 seconds or longer” visits that happened as a result of your campaign. |
|
Unique Impressions |
Integer |
|
|
View Percent |
Decimal |
Ad viewability. |
|
Channel |
Text |
Campaign type. |
|
Budget |
Decimal |
|
|
Bid Amount Total |
Decimal |
|
|
Bid Type |
Text |
|
|
Start Date |
Date |
|
|
End Date |
Date |
|
|
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. |