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 |
Updated about 2 years ago