Warehousing: Data Schemas

The Rockerbox Data Warehouse integration includes schemas unique to the offering. They include two categories of data:

• Platform Performance
• Rockerbox datasets

Platform Performance

Platform Performance reports are datasets generated by pulling and standardizing from ad platforms directly. These datasets will include metrics like spend, clicks, impressions, and platform-attributed conversions, and allow you to easily compare Rockerbox-attributed performance with that of the platforms.

Rockerbox currently supports the following platforms:

• Google
• Facebook
• Bing
• Pinterest
• TikTok
• LinkedIn

For more information on how to use this data, check out our additional docs on Platform Performance.

Rockerbox Datasets

Rockerbox datasets include key reports created by Rockerbox. These includes:

• MTA
• Buckets Breakdown
• Conversions

Some additional capabilities of these datasets include:

• The MTA includes columns for your UTM and URL parameters to help you identify the platform and ad that drove the user to the site
• Both the MTA and Buckets Breakdown reports include platform and platform_join_key columns that allow you to easily join against the respective platform's Platform Performance datasets.
• The Conversions report includes a column that contains all additional attributes passed to Rockerbox in the conversion event

📘

Schemas Differ between Warehousing and Standard Reports

Note that the Warehouse schemas include some variation between the Standard Reports. Be sure to view the appropriate schemas.