Skip to main content

​
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.
  • Rockerbox First Party Data: Transactional and aggregate conversion and attribution datasets built on Rockerbox first party tracking.
  • Platform Reported Data: Aggregate spend, conversions, and performance metrics as reported by each major ad platform (e.g., Meta, Google).

​
Schema Listing

TypeSchemaDescription
Rockerbox First PartyConversion DataContains one row for each occurrence of a conversion event. Includes user identifiers, timestamps, order metadata, and any other context passed to Rockerbox.
Rockerbox First PartyLog Level MTAContains one row per marketing touchpoint in each user path to conversion. Useful for user path / user journey analysis and any custom analysis or reporting based on Rockerbox attribution.
Rockerbox First PartyAggregate MTAProvides aggregate attribution (conversions and revenue) and spend data across all channels. This dataset is a “pivot” of log level MTA that is then unioned with aggregate spend data.
Rockerbox First PartyTaxonomy LookupLatest reporting taxonomy for all channels with spend tracking. Used to apply mapping updates over historical data.
Platform ReportedPlatform PerformancePlatform-reported spend, conversions, and performance metrics. Supported Platforms: Google, Meta, Bing, TikTok, Snapchat, Pinterest, LinkedIn.

​
Entity Relationship Diagram

​
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