Purchase data export

Created: 04.05.2023

Updated: 01.06.2023

Author: Alexander Sugakov

Data Export

Data is exported upon request for a specific time period into a file. By default, the export is done in CSV format (comma separated). By default, the export is based on UTC+3 time zone.

General Description

The exported file contains a list of purchase events received by the platform during the specified time period. Events are NOT deduplicated (when comparing the quantity and total amount of purchases for the period with data from analytical platforms, we compare the data after deduplication based on the 'uniqueTransactionId' field).

Data Structure

Field	Type	Value (default)	Description
contextType	Enum8	0 - HOMEPAGE, 1 - CATEGORY, 2 - PRODUCT, 3 - CART, 4 - OTHER, 5 - SEARCH	Type of the page from which the event was sent, in accordance with the Page Context
contextData	Array(String)		The contents of the array with context data
uid	FixedString(32)		Internal customer identifier (slid)
moscowTime	DateTime		Date and time of the event (by default in UTC+3)
sessionId	FixedString(32)	1234567890	Internal session identifier
url	String	"https://www.example.com/?url_params=123"	URL from which the event was sent
browser	LowCardinality(String)	"Safari”	User's browser type
device	LowCardinality(String)	"Tablet”	User's device type
os	LowCardinality(String)	"Mac OS X”	User's operating system type
eventName	LowCardinality(String)	"Purchase"	Event name (human-readable)
eventValue	Uint32		Event value
eventCurrency	LowCardinality(String)		Currency
uniqueTransactionId	String		Unique transaction identifier
eventCart	Array		Contents of the cart in the format: "Product SKU, quantity, price per unit"