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.
Name | Type | Description |
---|---|---|
event_date | date | The date the survey was submitted. Based on the time zone of the shop at the moment the survey was submitted. |
event_date.day | date | The day the survey was submitted. Derived from event_date . |
event_date.week | date | The Sunday of the week during which the survey was submitted. Derived from event_date . |
event_date.month | date | The month during which the survey was submitted. Derived from event_date . |
event_date.quarter | date | The first month of the quarter during which the survey was submitted. Derived from event_date . |
event_date.year | date | The year during which the survey was submitted. Derived from event_date . |
event_hour | string | The 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_type | string | The survey platform used (e.g. Triple Whale PPS, Fairing, Kno). |
order_id | string | The unique order ID, assigned by the shop platform (Shopify, Amazon). |
customer_email | string | The customer’s email address. |
customer_id | string | The unique customer ID, assigned by the shop platform (Shopify, Amazon). |
customer_phone | string | The customer's phone number. |
question | string | The specific survey question asked to the customer. |
question_type | string | The type of the question asked (e.g. standard, custom). |
answer | string | The response provided by the customer to the survey question. |
source | string | The source of the customer before arriving at the survey (e.g. TikTok, Instagram, Youtube). |