Schema: Data Warehouse

Order	Name	Description	Type
1	type	The report type (e.g., platform_data)	str
2	report	The name of the report	str
3	advertiser	Rockerbox Account ID	str
4	identifier	conversion segment id	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	email	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 passed to Rockerbox on the conversion event	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