Hotjar data warehouse table groups

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

Table: SURVEY

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
survey__question_choice_allow_comment
Display name Question choice comment allowed
Description Flag indicating whether users can comment if they select this choice
Field type dimension
Data type string.text.value
survey__question_id
Display name Question ID
Description The question's unique identifier
Field type dimension
Data type string.text.value
survey__question_image_url
Display name Question image URL
Description The image URL associated with the question, if there is one
Field type dimension
Data type string.text.url
survey__question_is_required
Display name Question is required
Description Flag indicating whether the question is required
Field type dimension
Data type bool
survey__question_label
Display name Question labels
Description Information about the naming of the low label and high label. This field will only be used for rating-1-5, rating-1-7, nps, reaction question types
Field type dimension
Data type string.text.value
survey__question_text
Display name Question text
Description The text of the question
Field type dimension
Data type string.text.value
survey__response_url
Display name Survey responses URL
Description The Hotjar API URL for the responses of this survey
Field type dimension
Data type string.text.url
survey__survey_id
Display name Survey ID
Description The survey's unique identifier
Field type dimension
Data type string.text.value
survey__survey_name
Display name Survey name
Description The survey's name
Field type dimension
Data type string.text.value
survey__survey_responses__answers_comment
Display name Comment
Description Optional comment provided by the user
Field type dimension
Data type string.text.value
survey__survey_responses__atom
Display name Datetime
Field type dimension
Data type string.time.datetime
survey__survey_responses__browser
Display name Browser
Description The browser on which the response was captured
Field type dimension
Data type string.text.value
survey__survey_responses__country
Display name Country
Description 2-letter code of the user's country. The country code list can be found here https://www.iso.org/iso-3166-country-codes.html
Field type dimension
Data type string.geo.country
survey__survey_responses__date
Display name Date
Field type dimension
Data type string.time.date
survey__survey_responses__device
Display name Device
Description The device type used to submit the response. It can be any of "tablet", "mobile", "desktop"
Field type dimension
Data type string.text.value
survey__survey_responses__hotjar_user_id
Display name Hotjar user ID
Description A unique identifier for the user that submitted the response
Field type dimension
Data type string.text.value
survey__survey_responses__is_complete
Display name Response is complete
Description Flag indicating whether the response is completed or not
Field type dimension
Data type bool
survey__survey_responses__os
Display name OS
Description The user's operating system
Field type dimension
Data type string.text.value
survey__survey_responses__recording_url
Display name Response recording URL
Description A link to the Hotjar Recording that contains that response, if it exists
Field type dimension
Data type string.text.url
survey__survey_responses__response_answer
Display name Answer
Description Answer of the user
Field type dimension
Data type string.text.value
survey__survey_responses__response_id
Display name Response ID
Description The response unique identifier
Field type dimension
Data type string.text.value
survey__survey_responses__response_origin_url
Display name Response origin URL
Description The URL of the site where the user submitted the response
Field type dimension
Data type string.text.url
survey__survey_responses__window_size_height
Display name Window height
Description The window size of the user's browse
Field type dimension
Data type string.text.value
survey__survey_responses__window_size_width
Display name Window width
Description The window size of the user's browse
Field type dimension
Data type string.text.value
survey__survey_status
Display name Survey is enabled
Description Flag indicating whether the survey is enabled or not
Field type dimension
Data type bool
survey__survey_type
Display name Survey type
Description The type of the survey. It can be one of link, full_screen, or popover
Field type dimension
Data type string.text.value

Table: SURVEY_RESPONSES

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