Sprout Social: Most-used fields#
The table below gives information about most-used fields that you can import from Sprout Social. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
activity_metadata Dimension
This field contains metadata about the initial Sprout Social actions performed on a message, such as replies, tags, completions, and likes, including the actor and timestamp of these activities.
comments_count Metric
The total count of comments or replies on a profile or post.
comments_count_total Metric
The overall total count of comments for a TikTok profile.
comments_organic Metric
The number of comments received on content through organic (unpaid) reach.
content_category Dimension
A unified categorization of the content (e.g., album, video, photo, link, poll, or text).
created_date Dimension
The date and time when a post or other entity was created.
created_time Dimension
An ISO 8601 timestamp representing the publication date and time of the message or post.
customer_id Dimension
The unique identifier for the Sprout Social customer account.
customer_profile.groups Dimension
An array of group IDs that the customer profile belongs to within Sprout Social.
customer_profile.link Dimension
A URL link to the customer's social media profile.
customer_profile.name Dimension
The human-facing name of the social network profile.
customer_profile.native_id Metric
The unique ID used by the native social network to identify the profile.
customer_profile.native_name Dimension
The user name, screen name, or page URL used by the native social network to identify a unique profile.
customer_profile.network_metadata Dimension
Metadata specific to the social network of the customer profile.
customer_profile.network_type Dimension
The type of social network (e.g., X, Facebook, Instagram) for the customer profile.
customer_profile_id Metric
The unique ID used by Sprout Social to identify a social network profile.
engagements Metric
The total number of interactions with content or a profile, such as likes, comments, shares, or clicks.
engagements_other Dimension
Engagements that are not categorized as likes, replies, reposts, or post link clicks.
facebook.impressions Metric
The number of times content was displayed on Facebook.
followers_gained Metric
The total number of new followers gained by the profile.
followers_gained_organic Metric
The number of new followers gained through organic (unpaid) reach.
followers_gained_paid Metric
The number of followers gained through paid promotions on a social media profile. This metric is available for Facebook and LinkedIn Owned Profile Metrics.
followers_lost Metric
The total number of followers who unfollowed the profile.
from.guid Dimension
The native ID of the author's profile, prefixed with a Sprout code indicating the data source.
from.name Dimension
The display name of the message author.
from.profile_picture Dimension
The URL to the author's profile picture.
from.screen_name Dimension
The social media handle or screen name of the author, which is mutable on most networks.
groups Dimension
An array of IDs representing the groups a social network profile belongs to.
guid Dimension
A globally unique identifier for the entity.
hashtags Dimension
A list of hashtags associated with the content.
impressions Metric
The total number of times a post or profile content was displayed to users.
impressions_nonviral Metric
The number of times content from a social media profile was displayed to users through non-viral means, such as direct views or algorithmic reach. This metric is available for Facebook Owned Profile Metrics.
impressions_nonviral_unique Dimension
The number of unique users who saw content from a social media profile through non-viral means. This metric is available for Facebook Owned Profile Metrics.
impressions_organic Metric
The total number of times organic content (unpaid) was displayed to users.
impressions_organic_unique Dimension
The number of unique users who saw organic content (unpaid) at least once.
impressions_paid Metric
The number of times content from the profile was displayed through paid promotion.
impressions_paid_unique Dimension
The number of unique users who saw content from the profile through paid promotion.
impressions_unique Metric
The number of unique users who saw content from the profile.
impressions_viral Metric
The number of times content from a social media profile was displayed to users through viral means, such as shares or mentions by friends. This metric is available for Facebook Owned Profile Metrics.
impressions_viral_unique Dimension
The number of unique users who saw content from a social media profile through viral means. This metric is available for Facebook Owned Profile Metrics.
inbox_counts_sent Dimension
The count of messages sent from the profile's inbox.
inbox_received_sent Dimension
The count of pins received and sent within the Pinterest inbox. This metric is available for Pinterest Owned Profile Metrics.
instagram.impressions Metric
The number of times content was displayed on Instagram.
instagram.post_impressions_organic Metric
The number of times an Instagram post was displayed organically.
lifetime.annotation_click_through_rate Dimension
The rate at which viewers clicked on annotations displayed on YouTube videos over their lifetime. This metric is available for YouTube Post Metrics.
lifetime.annotation_clicks Dimension
The total number of clicks on annotations displayed on YouTube videos over their lifetime. This metric is available for YouTube Post Metrics.
lifetime.annotation_impressions Dimension
The total number of times annotations were displayed on YouTube videos over their lifetime. This metric is available for YouTube Post Metrics.
lifetime.card_click_rate Dimension
The rate at which cards in YouTube videos are clicked.
lifetime.card_impressions Dimension
The total number of times YouTube cards were displayed on videos over their lifetime. This metric is available for YouTube Post Metrics.
lifetime.card_teaser_click_rate Dimension
The rate at which card teasers in YouTube videos are clicked.
lifetime.comments_count Metric
The total count of comments or replies on a post over its lifetime.
lifetime.dislikes Dimension
The total number of dislikes on a YouTube video.
lifetime.engagements Metric
The total number of interactions with a post, including likes, comments, shares, and other actions, over its lifetime.
lifetime.engagements_follower_unique Dimension
The total number of unique engagements generated by followers for a post over its lifetime.
lifetime.engagements_other Dimension
The total number of other engagements received on a post or profile that do not fall into other specific engagement categories.
lifetime.engagements_per_video_view Metric
The ratio of total video engagements to the total number of video views.
lifetime.engagements_unique Dimension
The total number of unique users who performed an interaction with a post over its lifetime, including actions such as likes, comments, shares, and other clicks.
lifetime.estimated_minutes_watched Dimension
The estimated total number of minutes users watched the YouTube video.
lifetime.impression_source_follow Dimension
The number of impressions originating from users who follow the profile on TikTok.
lifetime.impression_source_for_you Dimension
The number of impressions originating from the 'For You' page on TikTok.
lifetime.impression_source_hashtag Dimension
The total number of impressions a post received from users discovering it via hashtags over its lifetime. This metric is available for TikTok Post Metrics.
lifetime.impression_source_personal_profile Dimension
The number of impressions originating from views on the personal profile page on TikTok.
lifetime.impression_source_sound Dimension
The number of impressions originating from the sound page on TikTok.
lifetime.impression_source_unspecified Dimension
The number of impressions originating from unspecified sources on TikTok.
lifetime.impressions Metric
The total number of times a post was displayed to users over its lifetime.
lifetime.impressions_nonviral_unique Dimension
The number of unique users who saw the content through non-viral distribution.
lifetime.impressions_organic Metric
The total number of organic (unpaid) impressions received over its lifetime.
lifetime.impressions_organic_unique Metric
The number of unique users who saw the content through organic distribution.
lifetime.impressions_paid Dimension
The total number of paid impressions received over its lifetime.
lifetime.impressions_paid_unique Dimension
The number of unique users who saw the content through paid distribution.
lifetime.impressions_unique Metric
The total number of unique users who saw the content (reach).
lifetime.impressions_viral_unique Dimension
The number of unique users who saw the content through viral distribution.
lifetime.likes Metric
The total number of likes or positive reactions a post received over its lifetime.
lifetime.link_in_bio_clicks Dimension
The total number of clicks on the link in bio on Instagram.
lifetime.post_content_clicks Dimension
The total number of clicks on any content within the post.
lifetime.post_content_clicks_other Dimension
The total number of clicks on the post content that are not categorized as link, photo, or video play clicks.
lifetime.post_followers_gained Dimension
The number of new followers gained as a direct result of a specific post over its lifetime.
lifetime.post_followers_lost Dimension
The number of followers lost as a direct result of a specific post over its lifetime.
lifetime.post_hashtag_clicks Dimension
The total number of clicks on hashtags within a post over its lifetime.
lifetime.post_link_clicks Dimension
The total number of clicks on links included in the post.
lifetime.post_other_clicks_unique Dimension
The number of unique clicks on a post's content over its lifetime that are not categorized as link, photo, or video clicks.
lifetime.post_photo_view_clicks Dimension
The total number of clicks on photos within the post to view them.
lifetime.post_video_play_clicks Dimension
The total number of clicks to play videos embedded in the post.
lifetime.reactions Metric
The total number of reactions (e.g., likes, loves, wows) a post received over its lifetime.
lifetime.reactions_angry Dimension
The total number of angry reactions received on a Facebook post.
lifetime.reactions_haha Dimension
The total number of 'Haha' reactions received on a Facebook post.
lifetime.reactions_love Dimension
The total number of 'Love' reactions received on a Facebook post.
lifetime.reactions_sad Dimension
The total number of 'Sad' reactions received on a Facebook post.
lifetime.reactions_wow Dimension
The total number of 'Wow' reactions received on a Facebook post.
lifetime.reels_unique_session_plays Dimension
The total number of unique play sessions for Reels content.
lifetime.saves Metric
The total number of times a post was saved by users over its lifetime.
lifetime.shares_count Metric
The total number of times a post was shared or reposted by users over its lifetime.
lifetime.story_exits Dimension
The total number of times users exited an Instagram story.
lifetime.story_taps_back Dimension
The total number of times users tapped back to the previous content in an Instagram story.
lifetime.story_taps_forward Dimension
The total number of times users tapped forward to the next content in an Instagram story.
lifetime.subscribers_gained Dimension
The total number of new subscribers gained from a YouTube video or channel.
lifetime.subscribers_lost Dimension
The total number of subscribers lost from a YouTube video or channel.
lifetime.video_view_percentage Dimension
The average percentage of a video that was watched over its lifetime.
lifetime.video_view_time Dimension
The total amount of time viewers spent watching videos over their lifetime.
lifetime.video_view_time_organic Dimension
The total amount of time viewers spent watching organic videos over their lifetime.
lifetime.video_view_time_paid Dimension
The total amount of time viewers spent watching paid videos over their lifetime.
lifetime.video_view_time_per_view Metric
The average amount of time, in seconds, a user watched a video per view.
lifetime.video_views Metric
The total number of video views for a post over its lifetime.
lifetime.video_views_30s_complete Dimension
The total number of times a video was watched for at least 30 seconds or to completion, whichever comes first.
lifetime.video_views_30s_complete_organic Dimension
The total number of times a video was watched for at least 30 seconds or to completion through organic distribution.
lifetime.video_views_30s_complete_paid Dimension
The total number of times a video was watched for at least 30 seconds or to completion through paid distribution.
lifetime.video_views_organic Metric
The total number of organic video views.
lifetime.video_views_organic_unique Dimension
The total number of unique users who viewed the video through organic distribution.
lifetime.video_views_p100_per_view Dimension
The rate at which a video was watched to 100% completion per view.
lifetime.video_views_paid Dimension
The total number of paid video views.
lifetime.video_views_paid_unique Dimension
The total number of unique users who viewed the video through paid distribution.
lifetime.video_views_partial Dimension
The total number of times a video was partially viewed (less than 30 seconds or completion).
lifetime.video_views_partial_organic Dimension
The total number of times a video was partially viewed through organic distribution.
lifetime.video_views_partial_paid Dimension
The total number of times a video was partially viewed through paid distribution.
lifetime.video_views_unique Dimension
The total number of unique users who viewed the video.
lifetime.videos_added_to_playlist Dimension
The total number of times the YouTube video was added to a playlist.
lifetime.videos_removed_from_playlist Dimension
The total number of times the YouTube video was removed from a playlist.
lifetime.vote_count Dimension
The total number of votes received on a poll.
lifetime_snapshot.followers_by_age_gender Dimension
A lifetime snapshot of the audience breakdown by age and gender demographics.
lifetime_snapshot.followers_by_country Dimension
A lifetime snapshot of the audience breakdown by country.
lifetime_snapshot.followers_by_gender Dimension
A lifetime snapshot of the audience breakdown by gender.
lifetime_snapshot.followers_count Metric
The total number of followers for the profile as a lifetime snapshot.
lifetime_snapshot.followers_online Dimension
The number of followers who are currently online for a TikTok profile at the time the snapshot was taken. This metric is available for TikTok Owned Profile Metrics.
lifetime_snapshot.following_count Metric
The total number of profiles a social media account is following. This metric is available for Instagram and Pinterest Owned Profile Metrics.
likes Metric
The total number of likes received on a social media post or associated with a topic. This metric is available across various social networks for both owned profiles and individual posts, as well as for messages within Listening Topics.
likes_organic Metric
The number of likes received on content through organic (unpaid) reach.
likes_total Metric
The total number of likes received on posts or profile content.
location.city Dimension
An estimation of the city where the message was posted. This data is primarily available for X (formerly Twitter) and can be inferred from other networks based on the author's bio or message content.
location.country Dimension
An estimation of the country where the message was posted. This data is primarily available for X (formerly Twitter) and can be inferred from other networks based on the author's bio or message content.
location.province Dimension
An estimation of the province where the message was posted. This data is primarily available for X (formerly Twitter) and can be inferred from other networks based on the author's bio or message content.
mentions Metric
A list of other profiles mentioned within the message content.
name Dimension
The human-facing name of the social network profile or the display name of the author of a message. It can also represent the name of a customer, group, user, or topic within Sprout Social.
native_id Dimension
The unique identifier of a social network profile as assigned by the native social network (e.g., Twitter, Instagram). This ID is used by the social network to identify a profile.
native_name Dimension
The user name, screen name, or page URL that the native social network uses to identify a unique profile.
negative_sentiments_count Dimension
The count of messages or comments expressing a negative sentiment.
net_follower_growth Metric
The overall change in the number of followers for a social profile over a specific period, calculated as followers gained minus followers lost.
net_following_growth Metric
The net increase or decrease in the number of followers (followers gained minus followers lost).
network Dimension
The social network platform from which the data originated (e.g., INSTAGRAM, FACEBOOK).
network_type Dimension
The type of social network (e.g., X, Facebook, Instagram) associated with a profile or message.
neutral_sentiments_count Dimension
The count of messages or comments expressing a neutral sentiment.
perma_link Dimension
The permanent URL that links directly to the specific social media message or post on its native social network.
pin_count Dimension
The total number of pins associated with a Pinterest profile. This metric is available for Pinterest Owned Profile Metrics.
positive_sentiments_count Dimension
The count of messages or comments expressing a positive sentiment.
post_app_engagements Dimension
The number of engagements with an app promoted through a post. This metric is available for X Owned Profile Metrics.
post_app_installs Dimension
The number of app install attempts initiated from a post. This metric is available for X Owned Profile Metrics.
post_app_opens Dimension
The number of app opens originating from a post. This metric is available for X Owned Profile Metrics.
post_category Dimension
A categorical classification of the post content.
post_content_clicks Metric
The total number of clicks on the content of a post.
post_content_clicks_other Metric
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.
post_detail_expand_clicks Dimension
The number of times users clicked to expand the details of a post. This metric is available for X Owned Profile Metrics and X Post Metrics.
post_engagements Metric
The total number of engagements on a post (e.g., likes, comments, shares, clicks).
post_hashtag_clicks Dimension
The number of clicks on hashtags within a post.
post_impressions Metric
The total number of times a post was displayed to users.
post_impressions_nonviral Dimension
The number of times a post was displayed to users through non-viral means. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
post_impressions_organic Metric
The total number of times organic posts were displayed to users.
post_impressions_paid Dimension
The number of times a post was displayed through paid promotion.
post_impressions_viral Dimension
The number of times a post was displayed to users through viral means (e.g., shares by friends). This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
post_link_clicks Metric
The total number of clicks on links within a post.
post_media_clicks Dimension
The total number of clicks on media (images, videos) within a post.
post_media_views Dimension
The total number of views for media (images, videos) within a post.
post_profile_clicks Dimension
The total number of clicks on the profile name or picture originating from a post.
post_type Dimension
Uniquely identifies the social network and type of message or post (e.g., TWEET, FACEBOOK_POST, INSTAGRAM_MEDIA).
posts_sent_by_content_type Dimension
The count of posts sent, broken down by their content type (e.g., photo, video, text). This metric is available for X, Facebook, Instagram, and LinkedIn Owned Profile Metrics.
posts_sent_by_post_type Dimension
The count of posts sent, broken down by their specific post type (e.g., Tweet, Facebook Post, Instagram Media). This metric is available for X, Facebook, Instagram, LinkedIn, and TikTok Owned Profile Metrics.
posts_sent_count Metric
The total number of posts sent from the profile.
profile_guid Dimension
The unique ID of the tracked profile, prefixed with a Sprout code. If the message was from the tracked profile, this is identical to from.guid.
profile_views Metric
The total number of times a social media profile was viewed.
profile_views_total Dimension
The total number of times a social media profile was viewed.
question_answers Dimension
The total number of answers received for questions posted on social media. This metric is available for Facebook Post Metrics.
reactions Metric
The total number of reactions (e.g., likes, loves, wows) received on a profile or post.
reactions_angry Metric
The total number of "angry" reactions received on content.
reactions_haha Metric
The total number of "haha" reactions received on content.
reactions_love Metric
The total number of "love" reactions received on content.
reactions_sad Metric
The total number of "sad" reactions received on content.
reactions_wow Metric
The total number of "wow" reactions received on content.
replies Metric
The number of replies to messages or comments.
reporting_period.by(day) Dimension
A dimension used to break down analytics data by day.
saves Metric
The total number of times a post or content was saved by users on a profile.
saves_organic Metric
This metric indicates the number of times users have organically saved content (e.g., Instagram posts or Pinterest pins) to their collections or boards, without any paid promotion.
sent Dimension
A boolean value indicating if the message was sent by the requested profiles (true) or received by them (false).
sentiment Dimension
The overall sentiment expressed in messages or comments (e.g., positive, negative, neutral).
shares_count Metric
The total number of times a message or post was shared.
shares_count_total Metric
The total number of times content was shared by users.
story_replies Metric
The total number of replies received on stories. This metric is available for Instagram Owned Profile Metrics and Instagram Post Metrics (as lifetime.comments_count for story replies).
tag.active Dimension
Indicates if a tag is currently active.
tag.any_group Dimension
Indicates whether a message tag is available in any customer group. This field is part of the Customer Tags Endpoint response.
tag.groups Dimension
An array of IDs of the groups that a specific tag is available in. This field is part of the Customer Tags Endpoint response.
tag.text Dimension
The textual content of the tag.
tag.type Dimension
The type of the tag, such as LABEL or CAMPAIGN. This field is part of the Customer Tags Endpoint response.
tag_id Dimension
A unique identifier for the tag.
text Dimension
The textual content of the message or post.
title Dimension
The title of the post or content.
topic_id Dimension
A unique identifier for a listening topic.
video_length Dimension
The duration or length of the video content.
video_view_time Metric
The total duration (in seconds) that videos were watched on a profile or for a specific post.
video_views Metric
The total number of views for a video on a profile or individual post.
video_views_30s_complete Metric
The number of times a video was viewed for at least 30 seconds or to completion.
video_views_30s_complete_autoplay Metric
The number of times a video was viewed for at least 30 seconds or to completion due to autoplay.
video_views_30s_complete_click_to_play Metric
The number of times a video was viewed for at least 30 seconds or to completion due to a user clicking to play.
video_views_30s_complete_organic Metric
The number of times a video was viewed for at least 30 seconds or to completion through organic reach.
video_views_30s_complete_paid Metric
The number of times a video was viewed for at least 30 seconds or to completion through paid promotion.
video_views_30s_complete_repeat Metric
The number of times a video was viewed for at least 30 seconds and was replayed. This metric is available for Facebook Owned Profile Metrics.
video_views_30s_complete_unique Metric
The number of unique users who viewed a video for at least 30 seconds or to completion.
video_views_autoplay Metric
The number of times a video started playing automatically. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_click_to_play Metric
The number of times a video started playing due to a user click. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_organic Metric
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.
video_views_paid Metric
The total number of video views acquired through paid promotion.
video_views_partial Metric
The number of times a video was partially viewed. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_partial_autoplay Metric
The number of times a video was partially viewed after starting via autoplay. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_partial_click_to_play Metric
The number of times a video was partially viewed after starting via a user click. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_partial_organic Metric
The number of times a video was partially viewed through organic reach. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_partial_paid Metric
The number of times a video was partially viewed through paid promotions. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.
video_views_partial_repeat Metric
The number of times a video was partially viewed during a repeat play. This metric is available for Facebook Owned Profile Metrics.
video_views_repeat Metric
The number of times a video was replayed. This metric is available for Facebook Owned Profile Metrics.
video_views_total Metric
The total number of video views.
video_views_unique Dimension
The total number of unique users who watched videos.
visual_media Dimension
An array of media shared on the message, such as photos and videos, often including URLs for the full media, high-resolution display images, and thumbnail images. This field is available in Message Metadata and Listening Message Fields.