| report | The name of the report (only visible in Snowflake integrations) | str |
| advertiser | Rockerbox Account ID (only visible in Snowflake integrations) | str |
| identifier | Conversion segment ID (only visible in Snowflake integrations) | int |
| date | Date when the conversion event occurred | date |
| timestamp_conv | Timestamp of when the conversion occurred (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., your Order ID) | str |
| action | Name of the conversion event | str |
| new_to_file | 1 if new customer (first-time conversion seen), else 0 | int |
| onsite_count | Total number of times the user appeared on your site | int |
| total_events | Number of marketing touchpoints before conversion | int |
| event_id | Unique identifier for each marketing touchpoint | str |
| timestamp_events | Timestamp of the marketing event (ISO 8601 UTC) | timestamp |
| sequence_number | Order of the touchpoint in the user journey (1 = earliest) | int |
| hash_ip_events | Hashed IP of the user for that event | str |
| type | Report type (e.g., platform_data, attribution) | str |
| uid | Rockerbox user ID cookie | str |
| user_agent_events | User agent string from the marketing event | str |
| base_id | Primary user identifier | str |
| currency_code | Reporting currency for revenue and spend | str |
| fx_rate_to_usd | Exchange rate to USD (1 if already USD) | float |
| platform | Name of platform (always Rockerbox for this dataset) | str |
| spend_key | Platform spend identifier (usually Ad ID or composite key) | str |
| matches | List of categorization rules matched (last one is used) | dict |
| tier_1 | Five-level categorization tiers aligned to UI taxonomy (most broad) | str each |
| tier_2 | Five-level categorization tiers aligned to UI taxonomy | str each |
| tier_3 | Five-level categorization tiers aligned to UI taxonomy | str each |
| tier_4 | Five-level categorization tiers aligned to UI taxonomy | str each |
| tier_5 | Five-level categorization tiers aligned to UI taxonomy (most granular) | str each |
| original_url | URL of the marketing touchpoint | str |
| request_referrer | Referrer of the page where the user came from | str |
| utm_parameters | Dictionary of all UTM query parameters passed in the URL | dict |
| url_parameters | Other non-UTM URL parameters | dict |
| tier_one | Source data fields for taxonomy_lookup categorization | str each |
| tier_two | Source data fields for taxonomy_lookup categorization | str each |
| tier_three | Source data fields for taxonomy_lookup categorization | str each |
| tier_four | Source data fields for taxonomy_lookup categorization | str each |
| tier_five | Source data fields for taxonomy_lookup categorization | str each |
| normalized | Fractional attribution assigned by multi‑touch model | float |
| revenue_normalized | Conversion revenue assigned by model | float |
| first_touch | 1 if first touchpoint, else 0 | int |
| revenue_first_touch | Full revenue if it’s the first touch, else 0 | float |
| last_touch | 1 if last touchpoint, else 0 | int |
| revenue_last_touch | Full revenue if it’s the last touch, else 0 | float |
| even | Equal fractional credit across touchpoints | float |
| revenue_even | Revenue attributed under even weight distribution | float |
| rb_sync_id | Rockerbox internal sync identifier | int |
| updated_at | Timestamp when the record was last updated | timestamp |
| marketing_type | Touchpoint category (e.g., onsite, creative, mail, etc.) | str |
