Post-Purchase Survey Table

The Post-Purchase Survey table holds responses from customers following their purchases, detailing their feedback on various aspects like service, product satisfaction, and marketing channels. Querying this table offers insights into customer satisfaction, preferences, and the effectiveness of marketing strategies, enabling businesses to enhance customer experience and tailor their marketing efforts.

📘

Note

event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Date	event_date	date	The date the post-purchase survey was submitted. Based on the time zone of the shop at the moment the survey was submitted.
Event Day	event_date.day	date	The day the event occurred. Derived from event_date.
Event Week	event_date.week	date	The Sunday of the week during which the event occurred. Derived from event_date.
Event Month	event_date.month	date	The month during which the event occurred. Derived from event_date.
Event Quarter	event_date.quarter	date	The first month of the quarter during which the event occurred. Derived from event_date.
Event Year	event_date.year	date	The year during which the event occurred. Derived from event_date.
Event Hour	event_hour	string	The hour of the day the post-purchase survey was submitted, according to a 24-hour clock. Based on the time zone of the shop at the moment the survey was submitted. Example values: 07, 16, 21
Answer	answer	string	The response provided by the customer to the survey question. Example values: Online search, Social media, From a friend
Customer Email	customer_email	string	The customer’s email address. Example value: [email protected]
Customer ID	customer_id	string	The unique customer ID. Assigned by the main shop platform. Example value: 5209503793328
Customer Phone	customer_phone	string	The customer's phone number. Example value: 18005550199
Order ID	order_id	string	The unique order ID. Assigned by the main shop platform. Example value: 4930225799243
Survey Question	question	string	The specific survey question asked to the customer. Example value: How did you first hear about us?
Question Type	question_type	string	The type of the question asked. Example values: standard, custom
Source	source	string	The traffic source or referral channel that directed the customer to the survey. Example values: google, facebook, snapchat
Survey Type (Platform)	survey_type	string	The post-purchase survey platform used. Example values: KNO, TW-survey, FAIRING