> ## Documentation Index
> Fetch the complete documentation index at: https://data-foundation.rockerbox.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Schema Overview

> Learn about the datasets available for data warehouse integration

## 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       | Conversion Data              | A log-level dataset with one row per conversion event occurrence, including user identifiers, timestamps, order metadata, and any additional context passed to Rockerbox.                    |
| First-Party Events       | Clickstream                  | A log-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 | A log-level dataset containing key-value event parameters associated with each Clickstream event, supporting detailed behavioral analysis and custom reporting.                              |
| Attribution              | Log Level MTA                | A log-level dataset with one row per marketing touchpoint in each user path to conversion, supporting user journey analysis and custom reporting based on Rockerbox attribution.             |
| Attribution              | Aggregate MTA                | An 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.                                                                          |

***

## Entity Relationship Diagram

```mermaid theme={null}
erDiagram
    CONVERSIONS ||--o{ LOG_LEVEL_MTA : "date, conversion_key"
    CLICKSTREAM ||--o{ CLICKSTREAM_EVENT_PARAMETERS : "date, event_id"
    TAXONOMY_LOOKUP |o--o{ LOG_LEVEL_MTA : "spend_key -> join_key"
    TAXONOMY_LOOKUP |o--o{ AGGREGATE_MTA : "date, platform_join_key -> join_key"
    TAXONOMY_LOOKUP |o--o{ CLICKSTREAM : "spend_key -> join_key"

    CONVERSIONS {
        string conversion_key 
        timestamp timestamp_conv
        date date
        string action
        string currency_code
    }

    LOG_LEVEL_MTA {
        string event_id
        string conversion_key 
        string spend_key 
        int sequence_number
        timestamp timestamp_events
        string marketing_type
        string platform
        string tier_1
        string tier_2
        string tier_3
        string tier_4
        string tier_5
    }

    AGGREGATE_MTA {
        string conversion_event_id
        string platform_join_key 
        date date
        string platform
        string tier_1
        string tier_2
        string tier_3
        string tier_4
        string tier_5
        float included_spend
        float normalized
    }

    TAXONOMY_LOOKUP {
        string join_key 
        string parent_platform
        string platform
        string tier_1
        string tier_2
        string tier_3
        string tier_4
        string tier_5
    }

    CLICKSTREAM {
        string event_id 
        string session_id
        string uid
        string original_url
        string spend_key
        string tier_1
        string tier_2
        string tier_3
        string tier_4
        string tier_5
    }

    CLICKSTREAM_EVENT_PARAMETERS {
        string event_id 
        string query_param_name
        string value
    }
```

### ER Diagram Notes

* Each Log Level MTA record optionally maps to a Taxonomy Lookup record via spend\_key → join\_key
* Each Aggregate MTA record optionally maps to a Taxonomy Lookup record via platform\_join\_key → join\_key