Data Dictionary

At Creatable, we track the entire funnel, starting with social engagements and ending with conversions on site. You will find the breakdown of metrics by category below.

Engagement on Social Media

This is a summary of consumer engagement with creator content on social media as a result of influence campaigns, team campaigns and your overall team program.

Engagement on Site

This is a summary of consumer engagement with creator content that is published to your site on product pages, creator storefronts and other experiences on your site.

Sales

This is a summary of sales that were generated from consumer engagement with creator content and trackable links on your site and social media.

Reports

A variety of reports are available on the platform, enabling brands to dive deep into the performance of their creators, campaigns, and content.

Overview - Engagement on social

Metric

Definition

Unit

Display

Type

Example

Earned Media Value

The monetary value of the engagements and views generated via creator posts on social media

Pennies

$100,000.00

integer

10000000

Engagements

The total number of likes, shares, comments, and saves from all social posts

Engagements

100,000

integer

10000000

Average Engagement Rate

Average engagement rate across all organic social posts (excluding boosted posts)

Percentage

3.2%

float

0.032

Social Views

The total number of views from all social posts

Views

10,000,000

integer

10000000

New Posts

Posts created within the selected date range

Posts

10,000,000

integer

10000000

Overview - Engagement on site

Video Views

The number of video views on your site

Views

100,000

integer

100000

Photo Views

The total number of photo views on your site

Views

100,000

integer

100000

Storefront Views

The total number of storefront views on your site

Views

100,000

integer

100000

Video Visits

A video visit is a session on your site that involved at least one video event

Visits

100,000

integer

100000

Photo Visits

A photo visit is a session on your site that involved at least one photo event

Visits

100,000

integer

100000

Storefront Visits

A storefront visit is a session on your site that involved at least one storefront event

Visits

100,000

integer

100000

Overview - Sales

Total Sales

The total amount of all qualified sales

Pennies

$100,000.00

integer

10000000

Revenue per Video View

Video sales divided by video views

Pennies

$100,000.00

integer

10000000

Revenue per Photo View

Photo sales divided by photo views

Pennies

$100,000.00

integer

10000000

Total Conversions

The total count of all qualified conversions

Orders

$10,000,000.00

integer

10000000

Video Conversion Rate

Video Conversions divided by video visits

Percentage

3.20%

float

0.032

Photo Conversion Rate

Photo Conversions divided by photo visits

Percentage

3.20%

float

0.032

Storefront Conversion Rate

Storefront conversions divided by storefront visits

Percentage

3.20%

float

0.032

Average Order Value

The sum of all order values / order count

Pennies

$100,000.00

integer

10000000

Team Performance

Metric

Definition

Unit

Display

Type

Example

Creator

First and Last Name of Creator

Text

Johnny Jones

string

--

Creator ID

The ID of creator provided by the platform

Number

123456

int

--

Employee ID

Employee ID of creator as supplied by creator

Text

AZ123456

string

--

Sales

The total amount of all qualified sales per creator

Pennies

$100,000.00

integer

10000000

Orders

The total count of all qualified sales per creator

Orders

10,000,000

integer

10000000

AOV

Total sales divided by the count of qualified sales per creator

Pennies

100000

integer

10000000

Site views

Total video and photo views per creator

Views

10,000,000

integer

10000000

Social views

The total number of views from all social posts per creator

Views

10,000,000

integer

10000000

Engagements

The total number of likes, shares, comments and saves from social media posts

Engagements

10,000,000

integer

10000000

Followers

The total amount of followers per creator

Followers

10,000,000

integer

10000000

Employee ID

Employee ID of creator as supplied by creator

Text

AZ123456

string

--

Workplace location

Work location of creator as supplied by creator

Text

Anaheim - 138

string

--

Region

Region that work location is associated with

Text

Southwest

string

--

Tier

Creator tier as designated by brand admin

Text

Gold

string

--

Team Activity

Metric

Definition

Unit

Display

Type

Example

Creator

First and Last Name of Creator

Text

Johnny Jones

string

--

Creator ID

The ID of creator provided by the platform

Number

123456

int

--

Content Uploaded

Count of assets uploaded

Number

100,000

int

1000000

Last upload date

Date of last asset uploaded

Date

mm/dd/yyyy

date

03/23/2025

Social posts

Count of social posts

Number

100,000

int

100000

Last social post date

Date of last social post

Date

mm/dd/yyyy

date

03/23/2025

Employee ID

Employee ID of creator as supplied by creator

Number

AZ123456

int

--

Workplace location

Work location of creator as supplied by creator

Text

Anaheim - 138

string

--

Region

Region that work location is associated with

Text

Southwest

string

--

Tier

Creator tier as designated by brand admin

Text

Gold

string

--

Social Engagement Report

Metric

Definition

Unit

Display

Type

Example

Social Platform

The social platform that a post occurred on

Text

Instagram

string

--

Social Post Link

The URL of a social post

Link

https://www.domain.com

string

--

Post date

The date the social post was created on social media

Date

mm/dd/yyyy

date

03/23/2025

Boosted

If the social post was boosted or not

Indicator

true / false

boolean

--

Creator

First and Last Name of Creator

Text

Johnny Jones

string

--

Creator ID

The ID of creator provided by the platform

Number

123456

int

--

Views

Count of  views per social post

Views

10,000,000

integer

10000000

Likes

Count of likes per post

Likes

10,000,000

integer

10000000

Shares

Count of shares per post

Shares

10,000,000

integer

10000000

Saves

Count of saves per post

Saves

10,000,000

integer

10000000

Comments

Count of comments per post

Comments

10,000,000

integer

10000000

Earned Media Value

The monetary value of the engagements and views generated via creator posts on social media

Pennies

$100,000.00

integer

10000000

Employee ID

Employee ID of creator as supplied by creator

Number

AZ123456

int

--

Workplace location

Work location of creator as supplied by creator

Text

Anaheim - 138

string

--

Region

Region that work location is associated with

Text

Southwest

string

--

Tier

Creator tier as designated by brand admin

Text

Gold

string

--

Site Engagement Report

Metric

Definition

Unit

Display

Type

Example

Asset ID

The platform generated ID of an on site Video or Photo asset

Unique ID

123456789

int

--

Asset Title

The title of the on site Video or Photo asset

Text

"A Video Title"

string

--

Creator

First and Last Name of Creator

Text

Johnny Jones

string

--

Sales on Site

The total amount of all qualified sales per on site asset

Pennies

$100,000.00

integer

10000000

Orders

The total count of all qualified sales per on site post

Orders

10,000,000

integer

10000000

AOV

Total sales divided by the count of qualified sales per on site asset

Pennies

$100,000.00

integer

10000000

Views on Site

The total of all views that occurred per on site asset

Views

10,000,000

integer

10000000

Creator ID

The ID of creator provided by the platform

Number

123456

int

--

Employee ID

Employee ID of creator as supplied by creator

Number

AZ123456

int

--

Workplace location

Work location of creator as supplied by creator

Text

Anaheim - 138

string

--

Region

Region that work location is associated with

Text

Southwest

string

--

Tier

Creator tier as designated by brand admin

Text

Gold

string

--

Campaign ID

The unique ID of the campaign associated with the on site Video or Photo asset

Unique ID

123456789

int

--

Campaign Title

The name of the campaign associated with the on site Video or Photo post

Text

"A Campaign Title"

string

--

Sales Report

Metric

Definition

Unit

Display

Type

Example

Transaction ID

The brand designated ID of a qualified transaction

Unique ID

123456789

string

--

Transaction Date

The date of a qualified transaction

Date

mm/dd/yyyy

date

03/23/2025

Asset ID

The platform generated ID of a video, photo or product

Unique ID

123456789

int

--

Asset Title

The title of the on site Video or Photo asset

Text

"A Video Title"

string

--

Asset Type

Video, photo, storefront or Product link

Text

"Video"

string

--

Creator

First and Last Name of Creator

Text

Johnny Jones

string

--

Creator ID

The ID of creator provided by the platform

Number

123456

int

--

Employee ID

Employee ID of creator as supplied by creator

Number

AZ123456

int

--

Site Referral

Referral source of the qualifying event that was credited with the qualifying transaction

N/A

N/A

N/A

N/A

Amount

The dollar value of the qualified transaction

Pennies

$100,000.00

integer

10000000

Workplace location

Work location of creator as supplied by creator

Text

Anaheim - 138

string

--

Region

Region that work location is associated with

Text

Southwest

string

--

Tier

Creator tier as designated by brand admin

Text

Gold

string

--

Campaign ID

The unique ID of the campaign associated with the on site Video or Photo asset

Unique ID

123456789

int

--

Campaign Title

The name of the campaign associated with the on site asset

Text

"A Campaign Title"

string

--

Transaction Detail Report

Transaction ID

The brand designated ID of a qualified transaction

Unique ID

123456789

string

--

Transaction Date

The date of a qualified transaction

Date

mm/dd/yyyy

date

03/23/2025

Transaction Item Date

The date that a particular item within a transaction occurred

Date

mm/dd/yyyy

date

03/23/2025

Status

Transactions with a Transaction Date <30 days old will be pending, all other transactions will be qualified

Status

"Pending" or "Qualified"

string

--

Product ID

The Product ID of an item in a transaction

Unique ID

123456789

string

--

SKU

The SKU of an item in a transaction

Product

ABC123

string

--

Product Title

The title of a product in a transaction

Text

"Large T-Shirt"

string

--

Asset ID

The platform generated ID of a video, photo or product

Unique ID

123456789

int

--

Asset Title

The title of the on site asset

Text

"A Video Title"

string

--

Asset Type

Video, photo, storefront or Product link

Text

"Video"

string

--

Quantity

The number of products per transaction item

Items

10,000,000

integer

10000000

Item Price

The price per product per transaction item

Pennies

$100,000.00

integer

10000000

Total Amount

Item price multiplied by quantity

Pennies

$100,000.00

integer

10000000

Creator ID

The ID of creator provided by the platform

Number

123456

int

--

Employee ID

Employee ID of creator as supplied by creator

Number

AZ123456

int

--

Creator

First and Last Name of Creator

Text

Johnny Jones

string

--

Workplace location

Work location of creator as supplied by creator

Text

Anaheim - 138

string

--

Region

Region that work location is associated with

Text

Southwest

string

--

Tier

Creator tier as designated by brand admin

Text

Gold

string

--