Simplesat data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: ANSWER

answers__answer_id
Display name Answer ID
Description The unique ID for answer in Simplesat
Field type dimension
Data type string.text.value
answers__answer_label
Display name Answer label
Description Text label associated with the rating (Great, I'm satisfied!)
Field type dimension
Data type string.text.value
answers__channel
Display name Channel
Description The channel source the answer arrived from
Field type dimension
Data type string.text.value
answers__customer_company_name
Display name Customer company name
Description The name of the customer company
Field type dimension
Data type string.text.value
answers__customer_email
Display name Customer email
Description The email of the customer the answer came from
Field type dimension
Data type string.text.value
answers__customer_id
Display name Customer ID
Description The unique ID of the customer the answer came from
Field type dimension
Data type string.text.value
answers__customer_modified_date
Display name Customer modified date
Description The modified date of the customer
Field type dimension
Data type string.time.date
answers__customer_name
Display name Customer name
Description The name of the customer the answer came from
Field type dimension
Data type string.text.value
answers__date
Display name Date
Field type dimension
Data type string.time.date
answers__external_ticket_id
Display name External ticket ID
Description The external (unique) ID of the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__follow_up_answer_comment
Display name Follow-up answer comment
Description The comment of the answer's follow-up question
Field type dimension
Data type string.text.value
answers__follow_up_answer_id
Display name Follow-up answer ID
Description The unique ID of the answer's follow-up question
Field type dimension
Data type string.text.value
answers__follow_up_answer_modified_date
Display name Follow-up answer modified date
Description The modified date of the answer's follow-up question
Field type dimension
Data type string.time.date
answers__follow_up_question_id
Display name Follow-up question ID
Description The unique ID of the follow-up question
Field type dimension
Data type string.text.value
answers__follow_up_question_modified_date
Display name Follow-up question modified date
Description The modified date of the follow-up question
Field type dimension
Data type string.time.date
answers__follow_up_question_title
Display name Follow-up question title
Description The title of the follow-up question
Field type dimension
Data type string.text.value
answers__follow_up_question_type
Display name Follow-up question type
Description The type of the follow-up question
Field type dimension
Data type string.text.value
answers__ip_address
Display name IP address
Description The IP address of respondent
Field type dimension
Data type string.text.value
answers__is_primary
Display name Is for primary question
Description True/false value of whether an answer comes from the first "primary" question of a survey
Field type dimension
Data type bool
answers__modified_date
Display name Modified date
Description The date answer was modified
Field type dimension
Data type string.time.date
answers__question_id
Display name Question ID
Description The unique ID of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_metric
Display name Question metric
Description The metric of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_modified_date
Display name Question modified date
Description The date question was modified
Field type dimension
Data type string.time.date
answers__question_title
Display name Question title
Description The title of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_type
Display name Question type
Description The type of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__rating
Display name Rating
Description The number value for answer (can be 0-10 depending on the question)
Field type dimension
Data type int.number.value
answers__sentiment
Display name Sentiment
Description The sentiment of the rating. Each rating is mapped to a sentiment which are positive, neutral and negative
Field type dimension
Data type string.text.value
answers__survey_date
Display name Survey modified date
Description The date survey was modified
Field type dimension
Data type string.time.date
answers__survey_id
Display name Survey ID
Description The unique ID of the survey the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__survey_name
Display name Survey name
Description The name of the survey the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__team_member_email
Display name Team member email
Description The email of the team member owning the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__team_member_external_id
Display name Team member external ID
Description The external unique ID of the team member owning the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__team_member_id
Display name Team member ID
Description The unique ID of the team member owning the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__team_member_name
Display name Team member name
Description The name of the team member owning the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__ticket_id
Display name Ticket ID
Description The unique ID of the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__ticket_subject
Display name Ticket subject
Description The subject of the ticket the answer is connected to
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value