Simplesat fields

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

Supermetrics brings all your Simplesat data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

2 metrics69 dimensions

ANSWER

answers__answer_id
Field label Answer ID
Description The unique ID for answer in Simplesat
Field type dimension
Data type string.text.value
answers__answer_label
Field label Answer label
Description Text label associated with the rating (Great, I'm satisfied!)
Field type dimension
Data type string.text.value
answers__rating
Field label 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
Field label 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__channel
Field label Channel
Description The channel source the answer arrived from
Field type dimension
Data type string.text.value
answers__ip_address
Field label IP address
Description The IP address of respondent
Field type dimension
Data type string.text.value
answers__is_primary
Field label 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__created_datetime
Field label Created date and time
Description The date and time answer was created
Field type dimension
Data type string.time.datetime
answers__created_date
Field label Created date
Description The date answer was created
Field type dimension
Data type string.time.date
answers__modified_datetime
Field label Modified date and time
Description The date and time answer was modified
Field type dimension
Data type string.time.datetime
answers__modified_date
Field label Modified date
Description The date answer was modified
Field type dimension
Data type string.time.date
answers__average_rating
Field label Average rating
Description The average number value for answer (can be 0-10 depending on the question)
Field type metric
Data type float.number.value
answers__rating_count
Field label Rating count
Description The count of ratings
Field type metric
Data type int.number.value

CUSTOMER

answers__customer_id
Field label Customer ID
Description The unique ID of the customer the answer came from
Field type dimension
Data type string.text.value
answers__customer_name
Field label Customer name
Description The name of the customer the answer came from
Field type dimension
Data type string.text.value
answers__customer_email
Field label Customer email
Description The email of the customer the answer came from
Field type dimension
Data type string.text.value
answers__customer_company_name
Field label Customer company name
Description The name of the customer company
Field type dimension
Data type string.text.value
answers__customer_modified_datetime
Field label Customer modified date and time
Description The modified date and time of the customer
Field type dimension
Data type string.time.datetime
answers__customer_modified_date
Field label Customer modified date
Description The modified date of the customer
Field type dimension
Data type string.time.date

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

FOLLOW-UP ANSWER

answers__follow_up_answer_id
Field label 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_comment
Field label 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_modified_datetime
Field label Follow-up answer modified date and time
Description The modified date and time of the answer's follow-up question
Field type dimension
Data type string.time.datetime
answers__follow_up_answer_modified_date
Field label Follow-up answer modified date
Description The modified date of the answer's follow-up question
Field type dimension
Data type string.time.date

FOLLOW-UP QUESTION

answers__follow_up_question_id
Field label 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_title
Field label 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
Field label Follow-up question type
Description The type of the follow-up question
Field type dimension
Data type string.text.value
answers__follow_up_question_modified_datetime
Field label Follow-up question modified date and time
Description The modified date and time of the follow-up question
Field type dimension
Data type string.time.datetime
answers__follow_up_question_modified_date
Field label Follow-up question modified date
Description The modified date of the follow-up question
Field type dimension
Data type string.time.date

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

QUESTION

answers__question_id
Field label Question ID
Description The unique ID of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_title
Field label Question title
Description The title of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_metric
Field label Question metric
Description The metric of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_type
Field label Question type
Description The type of sent question in Simplesat
Field type dimension
Data type string.text.value
answers__question_modified_datetime
Field label Question modified date and time
Description The date and time question was modified
Field type dimension
Data type string.time.datetime
answers__question_modified_date
Field label Question modified date
Description The date question was modified
Field type dimension
Data type string.time.date

SURVEY

answers__survey_id
Field label 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
Field label Survey name
Description The name of the survey the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__survey_modified_datetime
Field label Survey modified date and time
Description The date and time survey was modified
Field type dimension
Data type string.time.datetime
answers__survey_date
Field label Survey modified date
Description The date survey was modified
Field type dimension
Data type string.time.date

TICKET

answers__ticket_id
Field label Ticket ID
Description The unique ID of the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__external_ticket_id
Field label 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__ticket_subject
Field label Ticket subject
Description The subject of the ticket the answer is connected to
Field type dimension
Data type string.text.value
answers__team_member_id
Field label 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
Field label 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__team_member_email
Field label 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
Field label 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

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
answers__year
Field label Year
Field type dimension
Data type string.time.year
answers__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
answers__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
answers__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
answers__month
Field label Month
Field type dimension
Data type string.time.month
answers__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
answers__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
answers__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
answers__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
answers__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
answers__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
answers__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
answers__date
Field label Date
Field type dimension
Data type string.time.date
answers__atom
Field label Datetime
Field type dimension
Data type string.time.datetime