Sprout Social fields

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

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

60 metrics110 dimensions

AUDIENCE

profile_performance__audience
Field label Audience (followers)
Description Number of followers as a lifetime snapshot
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
profile_performance__audience_gained
Field label Audience gained
Description Number of followers gained during the chosen reporting period
Field type metric
Data type int.number.value
profile_performance__audience_lost
Field label Audience lost
Description Number of followers lost during the chosen reporting period
Field type metric
Data type int.number.value
profile_performance__net_audience_growth
Field label Net audience growth
Description Number of net follower growth calculated as followers gained minus followers lost
Field type metric
Data type int.number.value

AUTHOR

posts__author_name
Field label Author name
Description The display name of the author
Field type dimension
Data type string.text.value
posts__author_id
Field label Author ID
Description The native ID of the authors' profile prefixed with a Sprout code that represents where the data was collected
Field type dimension
Data type string.text.value
posts__author_screen_name
Field label Author screen name
Description The screen name of the author
Field type dimension
Data type string.text.value
posts__author_profile_picture
Field label Author profile picture
Description A link to the author's profile picture
Field type dimension
Data type string.text.url

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

ENGAGEMENT

profile_performance__reactions
Field label Reactions
Description Number of reactions for a post. Available for Twitter, Instagram, Facebook and LinkedIn
Field type metric
Data type int.number.value
profile_performance__comments
Field label Comments
Description Number of comments for a post. Called replies for Twitter. Available for Twitter, Instagram, Facebook and LinkedIn
Field type metric
Data type int.number.value
profile_performance__shares
Field label Shares
Description Number of post shares. Called retweets for Twitter. Available for Twitter, Instagram, Facebook and LinkedIn
Field type metric
Data type int.number.value
profile_performance__likes
Field label Likes
Description Total number of likes for the post. Available for Twitter, Facebook and Instagram
Field type metric
Data type int.number.value
profile_performance__likes_tiktok
Field label Likes (TikTok)
Description Total number of likes for the post on TikTok
Field type metric
Data type int.number.value
profile_performance__post_link_clicks
Field label Post link clicks
Description Number of post link clicks. Available for Twitter and Facebook
Field type metric
Data type int.number.value
profile_performance__post_clicks_other
Field label Post clicks (other)
Description Number of other post clicks. Available for Twitter and Facebook
Field type metric
Data type int.number.value
profile_performance__post_clicks_all
Field label Post clicks (all)
Description Total number of all post clicks. Available for Twitter and LinkedIn
Field type metric
Data type int.number.value
profile_performance__saves
Field label Saves (Instagram)
Description Number of post saves on Instagram
Field type metric
Data type int.number.value
profile_performance__story_replies
Field label Story replies (Instagram)
Description Number of story replies on Instagram
Field type metric
Data type int.number.value
tags__performance__engagements
Field label Engagements
Description Engagements accumulated over a lifetime of the post
Field type metric
Data type int.number.value
tags__performance__engagement_rate
Field label Engagement rate (per impression)
Description The number of times users engaged with your content as a percentage of impressions. Calculated as Engagements / Impressions
Field type metric
Data type float.number.ratio
tags__performance__reactions
Field label Reactions
Description Reactions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
tags__performance__likes
Field label Likes
Description Likes accumulated over the lifetime of the post
Field type metric
Data type int.number.value
tags__performance__comments
Field label Comments
Description Comments count accumulated over a lifetime of the post
Field type metric
Data type int.number.value
tags__performance__shares
Field label Shares
Description Shares count accumulated over a lifetime of the post
Field type metric
Data type int.number.value
tags__performance__saves
Field label Saves
Description Saves count accumulated over a lifetime of the post. Only available for Instagram and Pinterest
Field type metric
Data type int.number.value
tags__performance__post_link_clicks
Field label Post link clicks
Description Post link clicks accumulated over a lifetime of the post
Field type metric
Data type int.number.value

ENGAGEMENTS

posts__lifetime_engagements
Field label Engagements
Description Engagements accumulated over a lifetime of the post
Field type metric
Data type int.number.value
posts__engagement_rate
Field label Engagement rate (per impression)
Description The number of times users engaged with your content as a percentage of impressions. Calculated as Engagements / Impressions
Field type metric
Data type float.number.ratio
posts__lifetime_reactions
Field label Reactions
Description Reactions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_likes
Field label Likes
Description Likes accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_comments_count
Field label Comments
Description Comments count accumulated over a lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_shares_count
Field label Shares
Description Shares count accumulated over a lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_saves_count
Field label Saves
Description Saves count accumulated over a lifetime of the post. Only available for Instagram and Pinterest
Field type metric
Data type int.number.value
posts__lifetime_post_link_clicks
Field label Post link clicks
Description Post link clicks accumulated over a lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_post_content_clicks
Field label Post clicks (all)
Description Post content clicks accumulated over a lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_ctr
Field label CTR
Description Click-Through Rate accumulated over a lifetime of the post
Field type metric
Data type float.number.ratio

IMPRESSIONS

profile_performance__impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
profile_performance__reach
Field label Reach
Description Number of unique impressions, not available for TikTok
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
posts__lifetime_impressions
Field label Impressions
Description Impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__impressions_organic
Field label Organic impressions
Description Organic impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__impressions_viral
Field label Viral impressions
Description Viral impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__impressions_nonviral
Field label Non-viral impressions
Description Non-viral impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__impressions_paid
Field label Paid impressions
Description Paid impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__impressions_follower
Field label Follower impressions
Description Follower impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__impressions_nonfollower
Field label Non-fan impressions
Description Non-fan impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_impressions_unique
Field label Reach
Description Unique impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
tags__performance__impressions
Field label Impressions
Description Impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
tags__performance__reach
Field label Reach
Description Unique impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value

INSTAGRAM

posts__story_taps_back
Field label Story taps back
Description Number of story taps back over a lifetime of the post. Only available for Instagram
Field type metric
Data type int.number.value
posts__story_taps_forward
Field label Story taps forward
Description Number of story taps forward over a lifetime of the post. Only available for Instagram
Field type metric
Data type int.number.value
posts__exits_count
Field label Exits count
Description Exits count accumulated over a lifetime of a post. Only available for Instagram
Field type metric
Data type int.number.value

MESSAGE VOLUME

profile_performance__published_posts
Field label Number of published posts
Description Number of published posts
Field type metric
Data type int.number.value

POST

posts__post_id
Field label Post ID
Description A unique ID associated with the post. Takes the form of "p:[profile_id]_[post_id]"
Field type dimension
Data type string.text.value
posts__post_text
Field label Post text
Description Field containing the text of the post
Field type dimension
Data type string.text.value
posts__post_title
Field label Post title
Description Title of the post
Field type dimension
Data type string.text.value
posts__post_tags
Field label Post tags
Description Tags associated with the post. If multiple tags are used for a given post, they'll be separated by a comma
Field type dimension
Data type string.text.value
posts__post_type
Field label Post type
Description Uniquely identifies the social network and type of message this is
Field type dimension
Data type string.text.value
posts__post_category
Field label Post category
Description A unified version of post type, these names are not network specific
Field type dimension
Data type string.text.value
posts__content_category
Field label Post content type
Description Unified categorization of the content; the hierarchy is album, video, photo, link, or text
Field type dimension
Data type string.text.value
posts__hashtags
Field label Post hashtags
Description Hashtags associated with the message
Field type dimension
Data type string.text.value
posts__network
Field label Post network
Description The social network that the data came from (e.g. INSTAGRAM)
Field type dimension
Data type string.text.value
posts__post_permalink
Field label Post permalink
Description A permanent link to the post in the source platform
Field type dimension
Data type string.text.url
posts__clickthrough_link
Field label Post clickthrough link
Description A clickthrough link to another entity that appears on the post
Field type dimension
Data type string.text.url
posts__post_created_time
Field label Post created datetime
Description Publication date and time of the post, it will be a valid iso8601 timestamp
Field type dimension
Data type string.time.datetime
posts__post_created_date
Field label Post created date
Description Publication date of the post
Field type dimension
Data type string.time.date

PROFILE

profile_performance__customer_profile_id
Field label Sprout profile ID
Description The profile ID used by Sprout to identify this social network profile
Field type dimension
Data type string.text.value
profile_performance__customers__customer_profile_native_id
Field label Profile native ID
Description The unique ID of the profile on the social network
Field type dimension
Data type string.text.value
profile_performance__customers__customer_profile_name
Field label Profile name
Description The name of the profile in Sprout Social
Field type dimension
Data type string.text.value
profile_performance__customers__native_customer_profile_name
Field label Native profile name
Description The name of the profile in the social network
Field type dimension
Data type string.text.value
profile_performance__customers__network_type
Field label Profile network type
Description The social network type associated with the profile
Field type dimension
Data type string.text.value
profile_performance__customers__customer_profile_groups
Field label Profile group IDs
Description A pipe-separated list of group IDs that the profile belongs to
Field type dimension
Data type string.text.value
posts__customer_profile_id
Field label Sprout profile ID
Description The Sprout-specific ID associated with the social network profile
Field type dimension
Data type string.text.value
posts__profile_id
Field label Profile ID
Description The ID of the profile being tracked, prefixed with an Sprout code that represents where the data was collected
Field type dimension
Data type string.text.value
posts__customers__customer_profile_native_id
Field label Profile native ID
Description The unique ID of the profile on the social network
Field type dimension
Data type string.text.value
posts__customers__customer_profile_name
Field label Profile name
Description The name of the profile in Sprout Social
Field type dimension
Data type string.text.value
posts__customers__native_customer_profile_name
Field label Native profile name
Description The name of the profile in the social network
Field type dimension
Data type string.text.value
posts__customers__network_type
Field label Profile network type
Description The social network type associated with the profile
Field type dimension
Data type string.text.value
posts__customers__customer_profile_groups
Field label Profile group IDs
Description A pipe-separated list of group IDs that the profile belongs to
Field type dimension
Data type string.text.value
tags__sprout_profile_id
Field label Sprout profile ID
Description The customer profile ID used by Sprout to identify this social network profile
Field type dimension
Data type string.text.value
tags__profile_name
Field label Profile name
Description The name of the profile in Sprout Social
Field type dimension
Data type string.text.value
tags__profile_network_type
Field label Profile network type
Description The social network type associated with the profile
Field type dimension
Data type string.text.value
tags__performance__profile_id
Field label Profile ID
Description The ID of the profile being tracked, prefixed with an Sprout code that represents where the data was collected
Field type dimension
Data type string.text.value
tags__profile__customer_profile_native_id
Field label Profile native ID
Description The unique ID of the profile on the social network
Field type dimension
Data type string.text.value
tags__profile__native_customer_profile_name
Field label Native profile name
Description The name of the profile in the social network
Field type dimension
Data type string.text.value
tags__profile__customer_profile_groups
Field label Profile group IDs
Description A pipe-separated list of group IDs that the profile belongs to
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

SENDER

posts__post_sender_id
Field label Sender ID
Description ID of the team member that sent this post via Sprout
Field type dimension
Data type string.text.value
posts__post_sender_email
Field label Sender email
Description Email address of the team member that sent this post
Field type dimension
Data type string.text.value
posts__post_sender_first_name
Field label Sender first name
Description First name of the team member that sent this post
Field type dimension
Data type string.text.value
posts__post_sender_last_name
Field label Sender last name
Description Last name of the team member that sent this post
Field type dimension
Data type string.text.value

TAG

tags__tag_text
Field label Tag text
Description The text of the tag
Field type dimension
Data type string.text.value
tags__tag_id
Field label Tag ID
Description The ID used by Sprout to identify this post tag
Field type dimension
Data type string.text.value
tags__tag_type
Field label Tag type
Description The type of the tag
Field type dimension
Data type string.text.value
tags__is_active
Field label Is active
Description Whether this tag is active (or archived) in Sprout Social
Field type dimension
Data type bool
tags__is_in_group
Field label Is in group
Description Whether or not this tag is available in any customer group
Field type dimension
Data type bool
tags__tag_groups
Field label Tag groups
Description A pipe-separated list of group IDs that the tag belongs to
Field type dimension
Data type string.text.value

TIKTOK

posts__impressions_follow
Field label Impressions (follow)
Description Impressions from source follow accumulated over the lifetime of the post. Only available for TikTok
Field type metric
Data type int.number.value
posts__impressions_for_you
Field label Impressions (for you)
Description Impressions from source for you accumulated over the lifetime of the post. Only available for TikTok
Field type metric
Data type int.number.value
posts__impressions_hashtag
Field label Impressions (hashtag)
Description Impressions from source hashtag accumulated over the lifetime of the post. Only available for TikTok
Field type metric
Data type int.number.value
posts__impression_personal_profile
Field label Impressions (personal profile)
Description Impressions from source personal profile accumulated over the lifetime of the post. Only available for TikTok
Field type metric
Data type int.number.value
posts__impressions_sound
Field label Impressions (sound)
Description Impressions from source sound accumulated over the lifetime of the post. Only available for TikTok
Field type metric
Data type int.number.value
posts__impressions_unspecified
Field label Impressions (unspecified)
Description Impressions from source unspecified accumulated over the lifetime of the post. Only available for TikTok
Field type metric
Data type int.number.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
profile_performance__year
Field label Year
Field type dimension
Data type string.time.year
profile_performance__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
profile_performance__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
profile_performance__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
profile_performance__month
Field label Month
Field type dimension
Data type string.time.month
profile_performance__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
profile_performance__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
profile_performance__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
profile_performance__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
profile_performance__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
profile_performance__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
profile_performance__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
profile_performance__date
Field label Date
Field type dimension
Data type string.time.date
profile_performance__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
posts__timezone
Field label Timezone
Description The selected timezone to report data on
Field type dimension
Data type string.time.timezone
tags__performance__year
Field label Year
Field type dimension
Data type string.time.year
tags__performance__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
tags__performance__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
tags__performance__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
tags__performance__month
Field label Month
Field type dimension
Data type string.time.month
tags__performance__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
tags__performance__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
tags__performance__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
tags__performance__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
tags__performance__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
tags__performance__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
tags__performance__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
tags__performance__date
Field label Date
Field type dimension
Data type string.time.date
tags__performance__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
tags__performance__timezone
Field label Timezone
Description The selected timezone to report data on
Field type dimension
Data type string.time.timezone

VIDEO

profile_performance__video_views
Field label Video views
Description Views accumulated over a lifetime of the video
Field type metric
Data type int.number.value
posts__lifetime_video_views
Field label Video views
Description Views accumulated over a lifetime of the video
Field type metric
Data type int.number.value
posts__video_length
Field label Video length
Description Total lifetime length of the video in seconds
Field type metric
Data type int.duration.seconds
posts__lifetime_video_view_time
Field label Video view time
Description Total lifetime video view time in seconds
Field type metric
Data type int.duration.seconds
tags__performance__video_views
Field label Video views
Description Views accumulated over a lifetime of the video
Field type metric
Data type int.number.value

VISUAL MEDIA

posts__media_url
Field label Media URL
Description A link to the full media shared on the message, e.g. photos and videos
Field type dimension
Data type string.text.url
posts__thumbnail_url
Field label Thumbnail URL
Description A link to a thumbnail image
Field type dimension
Data type string.text.url
posts__display_url
Field label Display URL
Description A link to s high resolution display image
Field type dimension
Data type string.text.url
posts__media_type
Field label Media type
Description A type of the media
Field type dimension
Data type string.text.value

VOLUME

tags__tagged_published_posts
Field label Tagged published posts
Description The number of tagged posts published
Field type metric
Data type int.number.value