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:

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:

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.
Redshift Schema Limitation

Redshift schema do not support the following columns:

* Advertiser
* Report
* Type
* Platform

These columns are static for a given report.
limitation with Redshift specifically (due to how the glue crawler operates) is that the partition columns that are always constant get omitted. As a result, these 4 fields are not available in datasets when querying with Redshift:

How did we do?