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.

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.