Documentation Index

Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt

Use this file to discover all available pages before exploring further.

Smarp metrics and dimensions

  • Updated on Mar 5, 2026
  • Published on Aug 5, 2025
Prev Next

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

11 metrics119 dimensions

CAMPAIGN

clicks__posts__campaigns__id
Field label Campaign ID
Field type dimension
Data type string.text.value
clicks__posts__campaigns__name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
posts__campaigns__id
Field label Campaign ID
Field type dimension
Data type string.text.value
posts__campaigns__name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
shares__posts__campaigns__id
Field label Campaign ID
Field type dimension
Data type string.text.value
shares__posts__campaigns__name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaigns__id
Field label Campaign ID
Field type dimension
Data type string.text.value
campaigns__name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value

CLICK

clicks__id
Field label Click ID
Field type dimension
Data type string.text.value
clicks__created_at
Field label Click created at
Description Date and time when the click was performed
Field type dimension
Data type string.time.datetime
clicks__created_date
Field label Click created at date
Description Date when the click was performed
Field type dimension
Data type string.time.date
clicks__sharer_id
Field label Sharer ID
Description ID of the sharer
Field type dimension
Data type string.text.value
clicks__post_id
Field label Post ID
Description ID of the post
Field type dimension
Data type string.text.value
clicks__social_network
Field label Social network
Description Social network where the click was performed
Field type dimension
Data type string.text.value
clicks__count
Field label Click count
Description Number of times the shared post was clicked. Note that Smarp only counts unique clicks
Field type metric
Data type int.number.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

GROUP

clicks__users__groups__id
Field label Group ID
Field type dimension
Data type string.text.value
clicks__users__groups__name
Field label Group name
Description Name of the group, e.g. based on geography or departments
Field type dimension
Data type string.text.value
shares__users__groups__id
Field label Group ID
Field type dimension
Data type string.text.value
shares__users__groups__name
Field label Group name
Description Name of the group, e.g. based on geography or departments
Field type dimension
Data type string.text.value
users__groups__id
Field label Group ID
Field type dimension
Data type string.text.value
users__groups__name
Field label Group name
Description Name of the group, e.g. based on geography or departments
Field type dimension
Data type string.text.value
groups__id
Field label Group ID
Field type dimension
Data type string.text.value
groups__name
Field label Group name
Description Name of the group, e.g. based on geography or departments
Field type dimension
Data type string.text.value

POST

clicks__posts__id
Field label Post ID
Field type dimension
Data type string.text.value
clicks__posts__published_at
Field label Post published at
Description Date and time when the post was published
Field type dimension
Data type string.time.datetime
clicks__posts__published_date
Field label Post published at date
Description Date when the post was published
Field type dimension
Data type string.time.date
clicks__posts__title
Field label Post title
Description Title of the post
Field type dimension
Data type string.text.value
clicks__posts__url
Field label Post url
Description URL of the post
Field type dimension
Data type string.text.url
clicks__posts__type
Field label Post type
Description Type shows whether the post is e.g. link, article, image or video post
Field type dimension
Data type string.text.value
posts__id
Field label Post ID
Field type dimension
Data type string.text.value
posts__published_at
Field label Post published at
Description Date and time when the post was published
Field type dimension
Data type string.time.datetime
posts__published_date
Field label Post published at date
Description Date when the post was published
Field type dimension
Data type string.time.date
posts__title
Field label Post title
Description Title of the post
Field type dimension
Data type string.text.value
posts__url
Field label Post url
Description URL of the post
Field type dimension
Data type string.text.url
posts__type
Field label Post type
Description Type shows whether the post is e.g. link, article, image or video post
Field type dimension
Data type string.text.value
shares__posts__id
Field label Post ID
Field type dimension
Data type string.text.value
shares__posts__published_at
Field label Post published at
Description Date and time when the post was published
Field type dimension
Data type string.time.datetime
shares__posts__published_date
Field label Post published at date
Description Date when the post was published
Field type dimension
Data type string.time.date
shares__posts__title
Field label Post title
Description Title of the post
Field type dimension
Data type string.text.value
shares__posts__url
Field label Post url
Description URL of the post
Field type dimension
Data type string.text.url
shares__posts__type
Field label Post type
Description Type shows whether the post is e.g. link, article, image or video post
Field type dimension
Data type string.text.value
posts__count
Field label Post count
Description Number of posts. Note that posts that were published in private channels are not counted
Field type metric
Data type int.number.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
system_metadata.query_excluded_accounts
Field label Excluded invalid accounts
Description A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type dimension
Data type string.text.json

SHARE

shares__id
Field label Share ID
Field type dimension
Data type string.text.value
shares__shared_at
Field label Shared at
Description Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z
Field type dimension
Data type string.time.datetime
shares__shared_date
Field label Shared at date
Description Date when post was shared, e.g. 2019-08-24
Field type dimension
Data type string.time.date
shares__sharer_id
Field label Sharer ID
Description ID of the user who shared the post
Field type dimension
Data type string.text.value
shares__post_id
Field label Post ID
Description ID of the post
Field type dimension
Data type string.text.value
shares__social_network
Field label Share social network
Description Name of the social network where the post was shared, e.g. LinkedIn or Facebook
Field type dimension
Data type string.text.value
shares__count
Field label Share count
Description Number of unique times the post has been shared in social media
Field type metric
Data type int.number.value
shares__unique_click_count
Field label Share unique click count
Description Number of unique clicks on the shared post. No clicks are recorded for image posts
Field type metric
Data type int.number.value
shares__like_count
Field label Share like count
Description Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared
Field type metric
Data type int.number.value
shares__comment_count
Field label Share comment count
Description Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared
Field type metric
Data type int.number.value
shares__resharer_count
Field label Resharer count
Description Number of times the shared post was retweeted or otherwise reshared
Field type metric
Data type int.number.value

TEAM

teams__id
Field label Team ID
Field type dimension
Data type string.text.value
teams__name
Field label Team name
Description Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users
Field type dimension
Data type string.text.value
teams__group_id
Field label Team group ID
Description ID of the team
Field type dimension
Data type string.text.value

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
clicks__posts__year
Field label Year
Field type dimension
Data type string.time.year
clicks__posts__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
clicks__posts__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
clicks__posts__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
clicks__posts__month
Field label Month
Field type dimension
Data type string.time.month
clicks__posts__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
clicks__posts__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
clicks__posts__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
clicks__posts__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
clicks__posts__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
clicks__posts__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
clicks__posts__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
clicks__posts__date
Field label Date
Field type dimension
Data type string.time.date
clicks__posts__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
posts__year
Field label Year
Field type dimension
Data type string.time.year
posts__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
posts__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
posts__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
posts__month
Field label Month
Field type dimension
Data type string.time.month
posts__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
posts__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
posts__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
posts__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
posts__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
posts__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
posts__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
posts__date
Field label Date
Field type dimension
Data type string.time.date
posts__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
shares__posts__year
Field label Year
Field type dimension
Data type string.time.year
shares__posts__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
shares__posts__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
shares__posts__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
shares__posts__month
Field label Month
Field type dimension
Data type string.time.month
shares__posts__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
shares__posts__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
shares__posts__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
shares__posts__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
shares__posts__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
shares__posts__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
shares__posts__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
shares__posts__date
Field label Date
Field type dimension
Data type string.time.date
shares__posts__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

USER

clicks__users__id
Field label User ID
Field type dimension
Data type string.text.value
clicks__users__first_name
Field label User first name
Description First name of the user
Field type dimension
Data type string.text.value
clicks__users__last_name
Field label User last name
Description Last name of the user
Field type dimension
Data type string.text.value
clicks__users__phone_number
Field label User phone number
Description Phone number of the user
Field type dimension
Data type string.text.value
clicks__users__group_id
Field label User group ID
Description ID of the group to which the user belongs to
Field type dimension
Data type string.text.value
shares__users__id
Field label User ID
Field type dimension
Data type string.text.value
shares__users__first_name
Field label User first name
Description First name of the user
Field type dimension
Data type string.text.value
shares__users__last_name
Field label User last name
Description Last name of the user
Field type dimension
Data type string.text.value
shares__users__phone_number
Field label User phone number
Description Phone number of the user
Field type dimension
Data type string.text.value
shares__users__group_id
Field label User group ID
Description ID of the group to which the user belongs to
Field type dimension
Data type string.text.value
users__id
Field label User ID
Field type dimension
Data type string.text.value
users__first_name
Field label User first name
Description First name of the user
Field type dimension
Data type string.text.value
users__last_name
Field label User last name
Description Last name of the user
Field type dimension
Data type string.text.value
users__phone_number
Field label User phone number
Description Phone number of the user
Field type dimension
Data type string.text.value
users__group_id
Field label User group ID
Description ID of the group to which the user belongs to
Field type dimension
Data type string.text.value
users__count
Field label User count
Description Number of Smarp users
Field type metric
Data type int.number.value
users__linkedin_connections
Field label LinkedIn connections
Description The amount of LinkedIn connections user has
Field type metric
Data type int.number.value
users__twitter_connections
Field label Twitter connections
Description The amount of Twitter connections user has
Field type metric
Data type int.number.value
users__total_connections
Field label Total connections
Description The total amount of connections user has. This includes Twitter and LinkedIn
Field type metric
Data type int.number.value

© Supermetrics 2025