Schema Overview - Rockerbox Data Foundation Docs

Available Datasets

The datasets available for data warehouse integration are designed to provide a comprehensive view of your marketing data. Not only do they provide an up to date view of your marketing data, but they also provide a standardized set of schemas that can be used as a your marketing data foundation.

First-Party Event Data: User-generated events and outcomes built on Rockerbox first party tracking.
Attribution Data: Modeled credit and attributed revenue.
Platform Data: Ad platform-reported spend, conversions, and performance metrics.
Normalization & Metadata: Lookup, mapping, and enrichment tables for standardized reporting across sources.

Schema Listing

Type	Schema	Description
First-Party Events	Log Conversions	Event-level dataset with one row per conversion event occurrence, including geographic, device, and revenue information and excluding PII.
First-Party Events	Log Conversions User Identifiers	Event-level dataset with one row per conversion event occurrence, including only user identifiers and any PII tracked on each conversion.
First-Party Events	Clickstream	Event-level dataset with one row per Page View and Conversion event tracked onsite, attributed to click-based marketing touchpoints with standardized tier structure and spend keys applied.
First-Party Events	Clickstream Event Parameters	Log-level dataset containing key-value event parameters associated with each Clickstream event, supporting detailed behavioral analysis and custom reporting.
Attribution	Log MTA	Event-level dataset with one row per marketing touchpoint in each user path to conversion, excluding all PII.
Attribution	Log MTA User Identifiers	Event-level dataset with one row per marketing touchpoint in each user path to conversion, including only user data associated with each marketing touchpoint.
Attribution	Aggregate MTA	Aggregate dataset providing attributed conversions, revenue, and spend across all channels, structured as a pivot of log-level MTA and unioned with aggregate spend data
Platform	Platform - `<Platform>`	Platform-reported spend, conversions, and performance metrics. Supported Platforms: Google, Meta, Bing, TikTok, Snapchat, Pinterest, LinkedIn.
Normalization & Metadata	Taxonomy Lookup	Latest reporting taxonomy for all channels with spend tracking. Used to apply mapping updates over historical data.
Normalization & Metadata	Conversion Event Metadata	Metadata of all conversion events tracked in Rockerbox..

Entity Relationship Diagram

Note: This diagram captures join keys and important fields to illustrate relationships between entities. Complete field references are documented per schema.