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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.