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 |