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_created_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 |