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 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:
For more information on how to use this data, check out our additional docs on Platform Performance.
Rockerbox datasets include key reports created by Rockerbox. These includes:
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
Note that the Warehouse schemas include some variation between the Standard Reports. Be sure to view the appropriate schemas.
Redshift schema do not support the following columns:
These columns are static for a given report.