Schema: Data Warehouse - Platform Performance - LinkedIn
Rockerbox Account ID
The dataset type (e.g., platform_data)
The name of the ad platform (e.g., Adwords)
The name of the dataset (e.g., platform_performance_adwords)
The unique identifier of the account in the advertising platform
The date that the action occured
Marketing channel categorization level 1
Marketing channel categorization level 2
Marketing channel categorization level 3
Marketing channel categorization level 4
Marketing channel categorization level 5
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
The name of the campaign group. Campaign groups provide advertisers a way to manage status, budget, and performance across multiple related campaigns
The unique identifier of the campaign group
The name of the campaign. Campaigns define the ad schedule and budget (daily/total)
The unique identifier of the campaign
The type of the campaign. These are synonomous with ad placements – possible values: TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC, CONTENT
The unique identifier of the creative (ad)
The type of ad creative – possible values: Text Ads, Sponsored Content, Message Ads, Conversation Ads, Sponsored Video, Sponsored Carousel Ad, Dynamic Ads
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
The local currency of your account in the ad platform (e.g., EUR, USD)
The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in USD.
The count of chargeable clicks.
This is the count of impressions for Sponsored Content and sends for Sponsored Messaging.
The count of clicks to view the company page.
The count of clicks which take the user to the creative landing page.
The count of follows. Sponsored Content and Follower ads only.
The count of likes. Sponsored Content only.
The count of comments. Sponsored Content only.
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.
The count of all user interactions with the ad unit.
The number of days after clicking an ad that conversions are attributed to that ad
The number of days after viewing an ad that conversions are attributed to that ad
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
The sum of externalWebsitePostClickConversions + externalWebsitePostViewConversions
The count of conversion actions taken after the user views the ad
The count of conversion actions taken after the user clicks the ad
Identifier used by Rockerbox to sync dataset to your warehouse