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.

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