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.
Description
- The Conversion Data schema contains one row per conversion recorded in Rockerbox.
- It includes detailed information about the conversion event including user identifiers, timestamps, order metadata, and any other contextual information passed to Rockerbox via conversion event tracking or batch files (flat files).
Table Creation
- One table is created for a single conversion event tracked in Rockerbox.
- The table is manually created in the Rockerbox UI.
Partition Keys
date
Primary Key
While data warehouses do not enforce primary key constraints, theconversion_key functions as the logical primary key for the table.
Field Reference
| Name | Description | Type |
|---|---|---|
| type | The type of the report (only visible in Snowflake integrations) | str |
| report | The name of the report (only visible in Snowflake integrations) | str |
| advertiser | Rockerbox Account ID (only visible in Snowflake integrations) | str |
| identifier | Conversion event ID (only visible in Snowflake integrations) | int |
| date | Date when the conversion event occurred | date |
| timestamp_conv | Timestamp of the conversion event (ISO 8601 UTC) | timestamp |
| conversion_hash_id | A hash identifier for a unique conversion (based on conversion_key) | str |
| conversion_key | Unique delivered conversion ID (e.g., Order ID or equivalent) | str |
| order_id | Unique identifier for the purchase / order as tracked in Shopify or customer POS system | str |
| hash_ip_conv | The IP address (SHA256 hashed) of the users device when they converted | str |
| action | Name of the conversion event (e.g., purchase) | str |
| new_to_file | 1 if this is a new customer (first-time conversion seen), else 0 | int |
| onsite_count | Total number of times the user appeared on your site before this conversion | int |
| base_id | Primary user identifier | str |
| uid | Rockerbox user ID cookie | str |
| currency_code | Reporting currency for revenue and spend | str |
| fx_rate_to_usd | Exchange rate to USD (1 if already USD) | float |
| revenue | Conversion revenue associated with this event | float |
| rb_sync_id | Rockerbox internal sync identifier | int |
| updated_at | Timestamp when this record was last updated | timestamp |
| original_url | Original URL associated with the conversion | str |
| request_referrer | Referrer of the page where the conversion occurred | str |
| utm_parameters | Dictionary of all UTM query parameters passed in the URL | dict |
| url_parameters | Dictionary of all non-UTM query parameters passed in the URL | dict |