Purchase Event Stream Data Sets

purchase

Target Location: s3://[bucket_name]/purchase/dt=[dt]/client_id=[id]/[filename].csv

Field Name	Data Type	Example	Description
event_id	string	018da7fe-4803-7d10-a547-68f0fb16af82	A uuid7 string that represents a unique event.
event_time	timestamp	2024-02-14T21:42:15.520123Z	A timestamp string with microsecond level precision (YYYY-MM-DD HH:MM:SS.SSSSSS) The time is in UTC.
client_id	int	3386	Client identifier. Foreign key to the Client lookup data.
profile_id	string	597fa1d224c17c309b02400	Unique identifier for the user profile. Referred to as SID in the API.
purchase_id	string	abcd123	The unique ID of the purchase
purchase_time	timestamp	2025-08-24 21:21:49	The timestamp when the purchase occurred. Format is YYYY-MM-DD HH:MM:SS, recorded in UTC.
purchase_count	int	4	Number of purchases made by the profile (i.e., this is the nth purchase).
total_price	int	2198	The total price paid for the items purchased in cents
total_qty	int	2	The total quantity of items included in the purchase.
items	JSON	[{"qty":5,"price":1099,"title":"Apple","id":"1","url":"https://example.com/1234/water_bottle","tags":["yellow"]}]	A list of items purchased by the user
first_purchase	boolean	true	Indicates whether this purchase is the profile’s first purchase (true) or a repeat (false).
vars	JSON	{“color”:”blue, “material”:”stainless steel”}	A JSON object containing client-defined custom variables.
chnl	string	online	Channel through which the purchase was made (e.g., online, app).
adjustments	JSON	[{"title":"tax","price":5050},{"title":"discount","price":-1000},{"title":"shipping","price":1000}]	Discounts applied to the purchase
message_id	string	15273725.1064	Unique identifier for the message, prim.

Note:
- If purchases are backfilled, the purchase time will be in the past.
- This dataset is only for complete purchases.