Hotjar fields

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

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

52 dimensions

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

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

survey__question_text
Field label Question text
Description The text of the question
Field type dimension
Data type string.text.value
survey__question_id
Field label Question ID
Description The question's unique identifier
Field type dimension
Data type string.text.value
survey__question_type
Field label Question type
Description The type of the question. Possible values are reaction,long-text, short-text, single-option, multiple-option, email, rating-1-5, rating-1-7, nps, statement, thank-you
Field type dimension
Data type string.text.value
survey__question_label
Field label 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_image_url
Field label 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
Field label Question is required
Description Flag indicating whether the question is required
Field type dimension
Data type bool
survey__question_choice_text
Field label Question choice text
Description The text of the choice
Field type dimension
Data type string.text.value
survey__question_choice_allow_comment
Field label Question choice comment allowed
Description Flag indicating whether users can comment if they select this choice
Field type dimension
Data type string.text.value

RESPONSE

survey__survey_responses__response_answer
Field label Answer
Description Answer of the user
Field type dimension
Data type string.text.value
survey__survey_responses__answers_comment
Field label Comment
Description Optional comment provided by the user
Field type dimension
Data type string.text.value
survey__survey_responses__response_id
Field label Response ID
Description The response unique identifier
Field type dimension
Data type string.text.value
survey__survey_responses__is_complete
Field label Response is complete
Description Flag indicating whether the response is completed or not
Field type dimension
Data type bool
survey__survey_responses__recording_url
Field label 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_origin_url
Field label 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__survey_name
Field label Survey name
Description The survey's name
Field type dimension
Data type string.text.value
survey__survey_id
Field label Survey ID
Description The survey's unique identifier
Field type dimension
Data type string.text.value
survey__survey_type
Field label 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
survey__survey_status
Field label Survey is enabled
Description Flag indicating whether the survey is enabled or not
Field type dimension
Data type bool
survey__response_url
Field label Survey responses URL
Description The Hotjar API URL for the responses of this survey
Field type dimension
Data type string.text.url

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
survey__survey_responses__year
Field label Year
Field type dimension
Data type string.time.year
survey__survey_responses__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
survey__survey_responses__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
survey__survey_responses__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
survey__survey_responses__month
Field label Month
Field type dimension
Data type string.time.month
survey__survey_responses__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
survey__survey_responses__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
survey__survey_responses__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
survey__survey_responses__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
survey__survey_responses__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
survey__survey_responses__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
survey__survey_responses__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
survey__survey_responses__date
Field label Date
Field type dimension
Data type string.time.date
survey__survey_responses__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

USER

survey__survey_responses__hotjar_user_id
Field label 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__country
Field label 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__device
Field label 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__browser
Field label Browser
Description The browser on which the response was captured
Field type dimension
Data type string.text.value
survey__survey_responses__os
Field label OS
Description The user's operating system
Field type dimension
Data type string.text.value
survey__survey_responses__window_size_height
Field label 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
Field label Window width
Description The window size of the user's browse
Field type dimension
Data type string.text.value