| 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 |
