Schema: Data Warehouse - Conversions
Order | Name | Description | Type |
1 | type | The report type (e.g., platform_data) Note: this static column is only visible in Snowflake integrations | str |
2 | report | The name of the report Note: this static column is only visible in Snowflake integrations | str |
3 | advertiser | Rockerbox Account ID Note: this static column is only visible in Snowflake integrations | str |
4 | identifier | conversion segment id Note: this static column is only visible in Snowflake integrations | int |
5 | action | Name of the conversion event | str |
6 | conversion_hash_id | Identifier per unique conversion (this is a hash of the conversion_key value) | str |
7 | date | Date when the action occurred | date |
8 | timestamp_conv | Timestamp of when the conversion occurred (ISO 8601 format in UTC) | timestamp |
9 | hash_ip_conv | The IP address (SHA256 hashed) of the users device when they converted | str |
10 | conversion_key | An identifier used to denote a unique conversion event (this is typically your provided Order ID) | str |
11 | order_id | str | |
12 | revenue | The revenue associated with conversion (e.g. order value) | float |
13 | new_to_file | At the time of conversion, if Rockerbox has seen that user make a Purchase before, then new_to_file = 0. Otherwise, they are considered a new customer and new_to_file = 1. | int |
14 | base_id | Primary User ID | str |
15 | uid | Rockerbox User ID cookie | str |
16 | external_id | The user ID sent to Rockerbox from a third party (e.g. Shopify Customer ID) | str |
17 | The email address associated with the user | str | |
18 | phone_number | The phone number associated with the user | str |
19 | user_agent_conv | User agent string associated with the user | str |
20 | additional_attributes | Custom conversion parameters | dict |
21 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | int |
22 | updated_at | Time the cache record was updated most recently | timestamp |