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.

NameTypeDescription
event_datedateThe date the survey was submitted. Based on the time zone of the shop at the moment the survey was submitted.
event_date.daydateThe day the survey was submitted. Derived from event_date.
event_date.weekdateThe Sunday of the week during which the survey was submitted. Derived from event_date.
event_date.monthdateThe month during which the survey was submitted. Derived from event_date.
event_date.quarterdateThe first month of the quarter during which the survey was submitted. Derived from event_date.
event_date.yeardateThe year during which the survey was submitted. Derived from event_date.
event_hourstringThe hour of the day the 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
survey_typestringThe survey platform used (e.g. Triple Whale PPS, Fairing, Kno).
order_idstringThe unique order ID, assigned by the shop platform (Shopify, Amazon).
customer_emailstringThe customer’s email address.
customer_idstringThe unique customer ID, assigned by the shop platform (Shopify, Amazon).
customer_phonestringThe customer's phone number.
questionstringThe specific survey question asked to the customer.
question_typestringThe type of the question asked (e.g. standard, custom).
answerstringThe response provided by the customer to the survey question.
sourcestringThe source of the customer before arriving at the survey (e.g. TikTok, Instagram, Youtube).