Data Dictionary
Start typing to search…

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

Updated about 1 month ago