| 1 | advertiser | Rockerbox account ID. | str |
| 2 | type | Dataset type (e.g., platform_data). | str |
| 3 | platform | Name of the advertising platform (LinkedIn). | str |
| 4 | report | Dataset name (platform_performance_linkedin). | str |
| 5 | identifier | Unique identifier of the account in the advertising platform. | str |
| 6 | date | Date the performance metrics occurred. | 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 | Identifier used to pull spend from an advertising platform. This is typically the ad_id, but may differ based on your account setup. | str |
| 13 | campaign_group_name | Name of the campaign group. Campaign groups provide a way to manage status, budget, and performance across multiple campaigns. | str |
| 14 | campaign_group_id | Unique identifier of the campaign group. | str |
| 15 | campaign_name | Name of the campaign. Campaigns define the ad set and budget (daily/total). | str |
| 16 | campaign_id | Unique identifier of the campaign. | str |
| 17 | campaign_type | Type of campaign (synonymous with ad placement). Possible values include TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC_ADS, SPONSORED_CONTENT. | str |
| 18 | creative_id | Unique identifier of the creative (ad). | str |
| 19 | creative_type | Type of ad creative (e.g., Text Ads, Sponsored Content, Message Ads, Conversation Ads, Sponsored Video, Carousel Ad, Dynamic Ads). | str |
| 20 | spend | Estimated total spend in the ad account’s local currency. | float |
| 21 | currency_code | ISO currency code of the ad account (e.g., EUR, USD). | str |
| 22 | spend_usd | Estimated total spend in USD. | float |
| 23 | clicks | Count of chargeable clicks. | int |
| 24 | impressions | Count of impressions for Sponsored Content and Sponsored Messaging. | int |
| 25 | company_page_clicks | Count of clicks to view the company page. | int |
| 26 | landing_page_clicks | Count of clicks directing users to the creative landing page. | int |
| 27 | follows | Count of follows (Sponsored Content and Follower Ads only). | int |
| 28 | likes | Count of likes (Sponsored Content only). | int |
| 29 | comments | Count of comments (Sponsored Content only). | int |
| 30 | video_completions | Count of video ads viewed to 97–100% completion. | int |
| 31 | total_engagements | Count of all user interactions with the ad unit. | int |
| 32 | post_click_attribution_window_size | Number of days after a click that conversions are attributed to the ad. | int |
| 33 | view_through_attribution_window_size | Number of days after a view that conversions are attributed to the ad. | int |
| 34 | conversion_value | Value of conversions in the ad account’s local currency, based on advertiser-defined rules. | float |
| 35 | external_website_conversions | Sum of external_website_post_click_conversions + external_website_post_view_conversions. | int |
| 36 | external_website_post_view_conversions | Count of conversion actions taken after a user views the ad. | int |
| 37 | external_website_post_click_conversions | Count of conversion actions taken after a user clicks the ad. | int |
| 38 | rb_sync_id | Identifier used by Rockerbox to sync the dataset to your warehouse. | str |
| 39 | updated_at | Timestamp of the most recent row update. | timestamp |
