Sprout Social
Metrics & Dimensions List
Updated: 2026-08-01
Important
Two reports are available:
sprout_social__profile_analytics_day- day-by-day performance of each connected profilesprout_social__post_analytics_lifetime- lifetime performance of each published post
Sprout Social aggregates several networks behind one schema, so a given column is only
populated for the networks that support it. Metrics prefixed with lifetime_ are the
totals accumulated by a post since it was published.
Sprout publishes a readable name for some of its metrics without defining them. Where that is the case, the description below is the metric's official name rather than a full definition.
Profile Table
The unique identifier for the Sprout Social customer account.
ID of the profile associated with this message.
The type of social network profile the data came from, for example INSTAGRAM.
The date the metrics are reported for.
The overall change in the number of followers for a social profile over a specific period, calculated as followers gained minus followers lost.
The total number of new followers gained by the profile.
The total number of followers who unfollowed the profile.
The number of times content from the profile was displayed to users during the reporting period.
The number of unique users who saw content from the profile during the reporting period.
The number of times unpaid content from the profile was displayed to users during the reporting period.
The number of times content from the profile was displayed through paid promotion during the reporting period.
The number of reactions, such as likes, loves and wows, received by the profile during the reporting period.
The number of likes received by the profile during the reporting period.
The number of comments and replies received by the profile during the reporting period.
The number of times content from the profile was shared during the reporting period.
The number of times content from the profile was saved by users during the reporting period.
The number of video views on the profile during the reporting period.
The time spent watching videos on the profile during the reporting period, in seconds.
The number of clicks on post content during the reporting period.
The number of clicks on links in posts during the reporting period.
Posts Table
The unique identifier for the Sprout Social customer account.
The native ID of the message prefixed with a Sprout code that represents where this type of message is.
ID of the profile associated with this message.
The type of social network profile the data came from, for example INSTAGRAM.
The social network the data came from, for example INSTAGRAM.
Uniquely identifies the social network and type of message this is.
A unified version of post_type, these names are not network specific.
Unified categorization of the content. The hierarchy is album, video, photo, link, poll or text.
A timestamp representing the publication date and time of the message.
The text in the body of the message.
URL to the message on the social network.
The display name of the author.
The account handle, also called the screen name. It changes less often than the display name.
Email address of the team member that sent this message.
A unique identifier for the tag.
A Boolean field that indicates whether the organic posts have received paid promotion to increase reach.
The total number of times the post was displayed to users since it was published.
The total number of unique users who saw the post since it was published.
The total number of times the post was displayed to users through unpaid reach since it was published.
The total number of times the post was displayed through paid promotion since it was published.
The total number of reactions, such as likes, loves and wows, received by the post since it was published.
The total number of likes received by the post since it was published.
The total number of comments and replies received by the post since it was published.
The total number of times the post was shared since it was published.
Post Shares.
The total number of views of the post's video since it was published.
The total time spent watching the post's video since it was published, in seconds.
Average Video Time Watched.
The total number of times the post was saved by users since it was published.
The total number of "love" reactions received on content.
The total number of "haha" reactions received on content.
The total number of "wow" reactions received on content.
The total number of "sad" reactions received on content.
The total number of "angry" reactions received on content.
The total number of clicks on the post's content since it was published.
The total number of clicks on links in the post since it was published.
Post Photo View Clicks.
Post Video Play Clicks.
The number of clicks on a post's content that are not categorized as link, photo, or video clicks. This metric is available for X and Facebook Owned Profile Metrics, and YouTube Calculated Post Metrics.
The number of times a video has been viewed through unpaid or natural distribution channels. This metric excludes views obtained through paid promotion. Primarily available for Facebook video content.
The total number of video views acquired through paid promotion.
Reels Unique Session Plays.
Story Exits.
Story Taps Back.
Story Taps Forward.
Views.
SproutLink Clicks.
Poll Votes.
The total number of unique users who watched videos.
Estimated Minutes Watched.
Subscribers Gained.
Subscribers Lost.
Video Dislikes.
Full Video Watch Rate.
Impression Source Follow.
Impression Source For You.
Impression Source Hashtag.
Impression Source Personal Profile.
Impression Source Sound.
Impression Source Unspecified.
Quotes.
Reposts.
Engagements that are not categorized as likes, replies, reposts, or post link clicks.