Slack metrics and dimensions

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Slack data into Google Sheets, Looker Studio, Power BI, Excel

Early Access9 metrics97 dimensions

AVATAR IMAGE

user__image_24px_url
Field label Image 24px URL
Field type dimension
Data type string.text.url
user__image_192px_url
Field label Image 192px URL
Field type dimension
Data type string.text.url
user__image_512px_url
Field label Image 512px URL
Field type dimension
Data type string.text.url
messages__user__image_24px_url
Field label Image 24px URL
Field type dimension
Data type string.text.url
messages__user__image_192px_url
Field label Image 192px URL
Field type dimension
Data type string.text.url
messages__user__image_512px_url
Field label Image 512px URL
Field type dimension
Data type string.text.url

CHANNEL

channel__channel
Field label Channel name
Field type dimension
Data type string.text.value
channel__topic
Field label Topic
Field type dimension
Data type string.text.value
channel__purpose
Field label Purpose
Field type dimension
Data type string.text.value
channel__created_date
Field label Created date
Field type dimension
Data type string.time.date
channel__is_archived
Field label Is archived
Field type dimension
Data type string.text.value
channel__is_ext_shared
Field label Is shared externally
Field type dimension
Data type string.text.value
channel__id
Field label ID
Field type dimension
Data type string.text.value
channel__previous_names
Field label Previous names
Field type dimension
Data type string.text.value

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

MESSAGES

messages__text
Field label Message text
Description The text content of the message
Field type dimension
Data type string.text.value
messages__subtype
Field label Message subtype
Description Subtype of the message (e.g., join or leave events)
Field type dimension
Data type string.text.value
messages__type
Field label Message type
Description Type of the message, typically 'message'
Field type dimension
Data type string.text.value
messages__sent_time
Field label Message sent time
Description The time when the message was sent
Field type dimension
Data type string.time.datetime
messages__latest_reply_time
Field label Latest reply times
Description Timestamp of the most recent reply in the thread
Field type dimension
Data type string.time.datetime
messages__client_msg_id
Field label Client message ID
Description A unique identifier for the message set by the client
Field type dimension
Data type string.text.value
messages__team
Field label Team ID
Description The team ID associated with the message
Field type dimension
Data type string.text.value
messages__reply_users
Field label Reply users
Description IDs of users who replied to the message
Field type dimension
Data type string.text.value
messages__reactions
Field label Reactions
Description List of reactions added to the message
Field type dimension
Data type string.text.value
messages__attachments
Field label Attachment URLs
Description URLs of any attachments included in the message
Field type dimension
Data type string.text.value
messages__files
Field label File URLs
Description URLs of files shared within the message
Field type dimension
Data type string.text.value

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

STATS

channel__member_count
Field label Members
Field type metric
Data type int.number.value
channel__channel_count
Field label Channels
Field type metric
Data type int.number.value
user__user_count
Field label Users
Field type metric
Data type int.number.value
user_group__user_count
Field label Users
Field type metric
Data type int.number.value
user_group__user_group_count
Field label User groups
Field type metric
Data type int.number.value
messages__message_count
Field label Messages
Description Number of messages
Field type metric
Data type int.number.value
messages__user_count
Field label Users posting
Description Number of users posting messages
Field type metric
Data type int.number.value
messages__reply_count
Field label Replies
Description Number of replies to the message
Field type metric
Data type int.number.value
messages__reply_users_count
Field label Replying users
Description Count of unique users who replied to the message
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric

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
messages__year
Field label Year
Field type dimension
Data type string.time.year
messages__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
messages__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
messages__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
messages__month
Field label Month
Field type dimension
Data type string.time.month
messages__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
messages__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
messages__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
messages__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
messages__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
messages__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
messages__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
messages__date
Field label Date
Field type dimension
Data type string.time.date
messages__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

USER

user__name
Field label Display name
Field type dimension
Data type string.text.value
user__real_name
Field label Real name
Field type dimension
Data type string.text.value
user__first_name
Field label First name
Field type dimension
Data type string.text.value
user__last_name
Field label Last name
Field type dimension
Data type string.text.value
user__user_id
Field label User ID
Field type dimension
Data type string.text.value
user__status
Field label Status
Field type dimension
Data type string.text.value
user__title
Field label Title
Field type dimension
Data type string.text.value
user__email
Field label Email
Field type dimension
Data type string.text.value
user__is_admin
Field label Is admin
Field type dimension
Data type bool
user__is_owner
Field label Is owner
Field type dimension
Data type bool
user__is_primary_owner
Field label Is primary owner
Field type dimension
Data type bool
user__is_restricted
Field label Is restricted
Field type dimension
Data type bool
user__is_ultra_restricted
Field label Is ultra restricted
Field type dimension
Data type bool
user__is_a_bot
Field label Is a bot
Field type dimension
Data type bool
user__has_two_factor_auth
Field label Has two-factor auth
Field type dimension
Data type bool
user__is_deleted
Field label Is deleted
Field type dimension
Data type bool
user__timezone
Field label Timezone
Field type dimension
Data type string.time.timezone
user__phone
Field label Phone
Field type dimension
Data type string.text.phone
user__is_email_confirmed
Field label Is email confirmed
Field type dimension
Data type bool
messages__user_id
Field label User ID
Description The ID of the user who sent the message
Field type dimension
Data type string.text.value
messages__user__name
Field label Display name
Field type dimension
Data type string.text.value
messages__user__real_name
Field label Real name
Field type dimension
Data type string.text.value
messages__user__first_name
Field label First name
Field type dimension
Data type string.text.value
messages__user__last_name
Field label Last name
Field type dimension
Data type string.text.value
messages__user__user_id
Field label User ID
Field type dimension
Data type string.text.value
messages__user__status
Field label Status
Field type dimension
Data type string.text.value
messages__user__title
Field label Title
Field type dimension
Data type string.text.value
messages__user__email
Field label Email
Field type dimension
Data type string.text.value
messages__user__is_admin
Field label Is admin
Field type dimension
Data type bool
messages__user__is_owner
Field label Is owner
Field type dimension
Data type bool
messages__user__is_primary_owner
Field label Is primary owner
Field type dimension
Data type bool
messages__user__is_restricted
Field label Is restricted
Field type dimension
Data type bool
messages__user__is_ultra_restricted
Field label Is ultra restricted
Field type dimension
Data type bool
messages__user__is_a_bot
Field label Is a bot
Field type dimension
Data type bool
messages__user__has_two_factor_auth
Field label Has two-factor auth
Field type dimension
Data type bool
messages__user__is_deleted
Field label Is deleted
Field type dimension
Data type bool
messages__user__timezone
Field label Timezone
Field type dimension
Data type string.time.timezone
messages__user__phone
Field label Phone
Field type dimension
Data type string.text.phone
messages__user__is_email_confirmed
Field label Is email confirmed
Field type dimension
Data type bool

USER GROUP

user_group__name
Field label Name
Field type dimension
Data type string.text.value
user_group__description
Field label Description
Field type dimension
Data type string.text.value
user_group__handle
Field label Handle
Field type dimension
Data type string.text.value
user_group__created_date
Field label Created date
Field type dimension
Data type string.time.date
user_group__is_external
Field label Is external
Field type dimension
Data type bool
user_group__auto_type
Field label Auto type
Field type dimension
Data type string.text.value
user_group__id
Field label ID
Field type dimension
Data type string.text.value