Schema: Data Warehouse - Platform Performance - LinkedIn

Order

Name

Description

Type

1

advertiser

Rockerbox Account ID

str

2

type

The dataset type (e.g., platform_data)

str

3

platform

The name of the ad platform (e.g., Adwords)

str

4

report

The name of the dataset (e.g., platform_performance_adwords)

str

5

identifier

The unique identifier of the account in the advertising platform

str

6

date

The date that the action occured

date

7

tier_1

Marketing channel categorization level 1

str

8

tier_2

Marketing channel categorization level 2

str

9

tier_3

Marketing channel categorization level 3

str

10

tier_4

Marketing channel categorization level 4

str

11

tier_5

Marketing channel categorization level 5

str

12

mta_tiers_join_key

The unique identifier used to pull spend from an advertisting platform. This is typically the ad_id, but may differ based on your account setup

str

13

campaign_group_name

The name of the campaign group. Campaign groups provide advertisers a way to manage status, budget, and performance across multiple related campaigns

str

14

campaign_group_id

The unique identifier of the campaign group

str

15

campaign_name

The name of the campaign. Campaigns define the ad schedule and budget (daily/total)

str

16

campaign_id

The unique identifier of the campaign

str

17

campaign_type

The type of the campaign. These are synonomous with ad placements – possible values: TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC, CONTENT

str

18

creative_id

The unique identifier of the creative (ad)

str

19

creative_type

The type of ad creative – possible values: Text Ads, Sponsored Content, Message Ads, Conversation Ads, Sponsored Video, Sponsored Carousel Ad, Dynamic Ads

str

20

spend

The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in the ad platform account’s local currency

float

21

currency_code

The local currency of your account in the ad platform (e.g., EUR, USD)

str

22

spend_usd

The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in USD.

float

23

clicks

The count of chargeable clicks.

int

24

impressions

This is the count of impressions for Sponsored Content and sends for Sponsored Messaging.

int

25

company_page_clicks

The count of clicks to view the company page.

int

26

landing_page_clicks

The count of clicks which take the user to the creative landing page.

int

27

follows

The count of follows. Sponsored Content and Follower ads only.

int

28

likes

The count of likes. Sponsored Content only.

int

29

comments

The count of comments. Sponsored Content only.

int

30

video_completions

The count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE.

int

31

total_engagements

The count of all user interactions with the ad unit.

int

32

post_click_attribution_window_size

The number of days after clicking an ad that conversions are attributed to that ad

int

33

view_through_attribution_window_size

The number of days after viewing an ad that conversions are attributed to that ad

int

34

conversion_value

Value of the conversions in the account’s local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range

float

35

external_website_conversions

The sum of externalWebsitePostClickConversions + externalWebsitePostViewConversions

int

36

external_website_post_view_conversions

The count of conversion actions taken after the user views the ad

int

37

external_website_post_click_conversions

The count of conversion actions taken after the user clicks the ad

int

38

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

str

39

updated_at

timestamp


How did we do?