Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Type | Description |
---|---|---|---|---|
Time | Year | answers_year | dim | |
Year of week (Sun-Sat) | answers_year_of_week | dim | ||
Year of week (Mon-Sun) | answers_year_of_week_iso | dim | ||
Year & month | answers_year_month | dim | ||
Month | answers_month | dim | ||
Year & week (Sun-Sat) | answers_year_week | dim | ||
Year & week (Mon-Sun) | answers_year_week_iso | dim | ||
Week (Sun-Sat) | answers_week | dim | ||
Week (Mon-Sun) | answers_week_iso | dim | ||
Day of month | answers_day_of_month | dim | ||
Day of week (Sun-Sat) | answers_day_of_week_name | dim | ||
Day of week (Mon-Sun) | answers_day_of_week_name_iso | dim | ||
Date | answers_date | dim | ||
Datetime | answers_atom | dim | ||
Answer | Answer ID | answers_answer_id | dim | The unique ID for answer in Simplesat |
Answer label | answers_answer_label | dim | Text label associated with the rating (Great, I'm satisfied!) | |
Rating | answers_rating | dim | The number value for answer (can be 0-10 depending on the question) | |
Sentiment | answers_sentiment | dim | The sentiment of the rating. Each rating is mapped to a sentiment which are positive, neutral and negative | |
Channel | answers_channel | dim | The channel source the answer arrived from | |
IP address | answers_ip_address | dim | The IP address of respondent | |
Is for primary question | answers_is_primary | dim | True/false value of whether an answer comes from the first "primary" question of a survey | |
Created date and time | answers_created_datetime | dim | The date and time answer was created | |
Created date | answers_modified_date | dim | The date answer was created | |
Modified date and time | answers_modified_datetime | dim | The date and time answer was modified | |
Modified date | answers_modified_date | dim | The date answer was modified | |
Question | Question ID | answers_question_id | dim | The unique ID of sent question in Simplesat |
Question title | answers_question_title | dim | The title of sent question in Simplesat | |
Question metric | answers_question_metric | dim | The metric of sent question in Simplesat | |
Question type | answers_question_type | dim | The type of sent question in Simplesat | |
Question modified date and time | answers_question_modified_datetime | dim | The date and time question was modified | |
Question modified date | answers_question_modified_date | dim | The date question was modified | |
Follow-up question | Follow-up question ID | answers_follow_up_question_id | dim | The unique ID of the follow-up question |
Follow-up question title | answers_follow_up_question_title | dim | The title of the follow-up question | |
Follow-up question type | answers_follow_up_question_type | dim | The type of the follow-up question | |
Follow-up question modified date and time | answers_follow_up_question_modified_datetime | dim | The modified date and time of the follow-up question | |
Follow-up question modified date | answers_follow_up_question_modified_date | dim | The modified date of the follow-up question | |
Follow-up answer | Follow-up answer ID | answers_follow_up_answer_id | dim | The unique ID of the answer's follow-up question |
Follow-up answer comment | answers_follow_up_answer_comment | dim | The comment of the answer's follow-up question | |
Follow-up answer modified date and time | answers_follow_up_answer_modified_datetime | dim | The modified date and time of the answer's follow-up question | |
Follow-up answer modified date | answers_follow_up_answer_modified_date | dim | The modified date of the answer's follow-up question | |
Customer | Customer ID | answers_customer_id | dim | The unique ID of the customer the answer came from |
Customer name | answers_customer_name | dim | The name of the customer the answer came from | |
Customer email | answers_customer_email | dim | The email of the customer the answer came from | |
Customer company name | answers_customer_company_name | dim | The name of the customer company | |
Customer modified date and time | answers_customer_modified_datetime | dim | The modified date and time of the customer | |
Customer modified date | answers_customer_modified_date | dim | The modified date of the customer | |
Ticket | Ticket ID | answers_ticket_id | dim | The unique ID of the ticket the answer is connected to |
External ticket ID | answers_external_ticket_id | dim | The external (unique) ID of the ticket the answer is connected to | |
Ticket subject | answers_ticket_subject | dim | The subject of the ticket the answer is connected to | |
Team member ID | answers_team_member_id | dim | The unique ID of the team member owning the ticket the answer is connected to | |
Team member name | answers_team_member_name | dim | The name of the team member owning the ticket the answer is connected to | |
Team member email | answers_team_member_email | dim | The email of the team member owning the ticket the answer is connected to | |
Team member external ID | answers_team_member_external_id | dim | The external unique ID of the team member owning the ticket the answer is connected to | |
Survey | Survey ID | answers_survey_id | dim | The unique ID of the survey the ticket the answer is connected to |
Survey name | answers_survey_name | dim | The name of the survey the ticket the answer is connected to | |
Survey modified date and time | answers_survey_modified_datetime | dim | The date and time survey was modified | |
Survey modified date | answers_survey_date | dim | The date survey was modified | |
Average rating | answers_average_rating | met | The average number value for answer (can be 0-10 depending on the question) | |
Rating count | answers_rating_count | met | The count of ratings |