Sprout Social: Most-used fields

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.

API name

Adverity UI name

Description

Use in Adverity

activity_metadata

activity_metadata

Contains information about the first of each Sprout Action(s) taken on a message, such as the actor and timestamp. Depending on network limitations, this may include Reply, Tag, Complete, and Like actions. This field is available for the Messages endpoint.

dimension

comments_count

comments_count

The total count of comments or replies on a profile or post.

metric

comments_count_total

comments_count_total

The overall total count of comments for a TikTok profile.

metric

comments_organic

comments_organic

The number of comments received on content through organic (unpaid) reach.

metric

content_category

content_category

A unified categorization of the content (e.g., album, video, photo, link, poll, or text).

dimension

created_date

created_date

The date and time when a post or other entity was created.

dimension

created_time

created_time

An ISO 8601 timestamp representing the publication date and time of the message or post.

dimension

customer_id

customer_id

The unique identifier for the Sprout Social customer account.

dimension

customer_profile.groups

customer_profile.groups

An array of group IDs that the customer profile belongs to within Sprout Social.

dimension

customer_profile.link

customer_profile.link

A URL link to the customer’s social media profile.

dimension

customer_profile.name

customer_profile.name

The human-facing name of the social network profile.

dimension

customer_profile.native_id

customer_profile.native_id

The unique ID used by the native social network to identify the profile.

metric

customer_profile.native_name

customer_profile.native_name

The user name, screen name, or page URL used by the native social network to identify a unique profile.

dimension

customer_profile.network_metadata

customer_profile.network_metadata

Metadata specific to the social network of the customer profile.

dimension

customer_profile.network_type

customer_profile.network_type

The type of social network (e.g., X, Facebook, Instagram) for the customer profile.

dimension

customer_profile_id

customer_profile_id

The unique ID used by Sprout Social to identify a social network profile.

metric

engagements

engagements

The total number of interactions with content or a profile, such as likes, comments, shares, or clicks.

metric

engagements_other

engagements_other

Engagements that are not categorized as likes, replies, reposts, or post link clicks.

metric

facebook.impressions

facebook.impressions

The number of times content was displayed on Facebook.

metric

facebook.impressions_organic

facebook.impressions_organic

The number of times content was displayed organically on Facebook.

metric

facebook.impressions_paid

facebook.impressions_paid

The number of times content was displayed through paid promotion on Facebook.

metric

followers_gained

followers_gained

The total number of new followers gained by the profile.

metric

followers_gained_organic

followers_gained_organic

The number of new followers gained through organic (unpaid) reach.

dimension

followers_gained_paid

followers_gained_paid

The number of followers gained through paid promotions on a social media profile. This metric is available for Facebook and LinkedIn Owned Profile Metrics.

dimension

followers_lost

followers_lost

The total number of followers who unfollowed the profile.

metric

from.guid

from.guid

The native ID of the author’s profile, prefixed with a Sprout code indicating the data source.

dimension

from.name

from.name

The display name of the message author.

dimension

from.profile_picture

from.profile_picture

The URL to the author’s profile picture.

dimension

from.screen_name

from.screen_name

The social media handle or screen name of the author, which is mutable on most networks.

dimension

groups

groups

A list of groups associated with the customer profile.

dimension

guid

guid

A globally unique identifier for the entity.

dimension

hashtags

hashtags

A list of hashtags associated with the content.

dimension

impressions

impressions

The total number of times a post or profile content was displayed to users.

metric

impressions_nonviral

impressions_nonviral

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.

metric

impressions_nonviral_unique

impressions_nonviral_unique

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.

metric

impressions_organic

impressions_organic

The total number of times organic content (unpaid) was displayed to users.

metric

impressions_organic_unique

impressions_organic_unique

The number of unique users who saw organic content (unpaid) at least once.

metric

impressions_paid

impressions_paid

The number of times content from the profile was displayed through paid promotion.

metric

impressions_paid_unique

impressions_paid_unique

The number of unique users who saw content from the profile through paid promotion.

metric

impressions_unique

impressions_unique

The number of unique users who saw content from the profile.

metric

impressions_viral

impressions_viral

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.

metric

impressions_viral_unique

impressions_viral_unique

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.

metric

inbox_counts_sent

inbox_counts_sent

The count of messages sent from the profile’s inbox.

dimension

inbox_received_sent

inbox_received_sent

The count of pins received and sent within the Pinterest inbox. This metric is available for Pinterest Owned Profile Metrics.

dimension

instagram.impressions

instagram.impressions

The number of times content was displayed on Instagram.

metric

instagram.post_impressions_organic

instagram.post_impressions_organic

The number of times an Instagram post was displayed organically.

metric

lifetime.annotation_click_through_rate

lifetime.annotation_click_through_rate

The rate at which viewers clicked on annotations displayed on YouTube videos over their lifetime. This metric is available for YouTube Post Metrics.

dimension

lifetime.annotation_clicks

lifetime.annotation_clicks

The total number of clicks on annotations displayed on YouTube videos over their lifetime. This metric is available for YouTube Post Metrics.

dimension

lifetime.annotation_impressions

lifetime.annotation_impressions

The total number of times annotations were displayed on YouTube videos over their lifetime. This metric is available for YouTube Post Metrics.

dimension

lifetime.card_impressions

lifetime.card_impressions

The total number of times YouTube cards were displayed on videos over their lifetime. This metric is available for YouTube Post Metrics.

dimension

lifetime.comments_count

lifetime.comments_count

The total count of comments or replies on a post over its lifetime.

metric

lifetime.dislikes

lifetime.dislikes

The total number of dislikes received on content over its lifetime.

dimension

lifetime.engagements

lifetime.engagements

The total number of interactions with a post, including likes, comments, shares, and other actions, over its lifetime.

metric

lifetime.estimated_minutes_watched

lifetime.estimated_minutes_watched

The estimated total number of minutes viewers spent watching video content over its lifetime.

dimension

lifetime.impression_source_hashtag

lifetime.impression_source_hashtag

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.

dimension

lifetime.impressions

lifetime.impressions

The total number of times a post was displayed to users over its lifetime.

metric

lifetime.impressions_organic

lifetime.impressions_organic

The total number of organic (unpaid) impressions received over its lifetime.

metric

lifetime.impressions_paid

lifetime.impressions_paid

The total number of paid impressions received over its lifetime.

dimension

lifetime.impressions_unique

lifetime.impressions_unique

The number of unique users who saw content over its lifetime.

dimension

lifetime.likes

lifetime.likes

The total number of likes or positive reactions a post received over its lifetime.

metric

lifetime.negative_feedback

lifetime.negative_feedback

The total number of negative feedback actions received on content over its lifetime.

dimension

lifetime.post_content_clicks

lifetime.post_content_clicks

The total number of clicks on the content of a post over its lifetime.

metric

lifetime.post_content_clicks_other

lifetime.post_content_clicks_other

The total number of clicks on a post’s content that are not categorized as link, photo, or video clicks over its lifetime. This metric is available for X, Facebook, and YouTube Post Metrics.

dimension

lifetime.post_followers_gained

lifetime.post_followers_gained

The number of new followers gained as a direct result of a specific post over its lifetime.

dimension

lifetime.post_followers_lost

lifetime.post_followers_lost

The number of followers lost as a direct result of a specific post over its lifetime.

dimension

lifetime.post_hashtag_clicks

lifetime.post_hashtag_clicks

The total number of clicks on hashtags within a post over its lifetime.

dimension

lifetime.post_link_clicks

lifetime.post_link_clicks

The total number of clicks on links within a post over its lifetime.

metric

lifetime.post_media_clicks

lifetime.post_media_clicks

The total number of clicks on media (images, videos) within a post over its lifetime.

dimension

lifetime.post_media_views

lifetime.post_media_views

The total number of views for media (images, videos) within a post over its lifetime.

dimension

lifetime.post_photo_view_clicks

lifetime.post_photo_view_clicks

The total number of clicks to expand or view a photo within a post over its lifetime.

dimension

lifetime.post_profile_clicks

lifetime.post_profile_clicks

The total number of clicks on the profile name or picture originating from a post over its lifetime.

dimension

lifetime.post_video_play_clicks

lifetime.post_video_play_clicks

The total number of clicks to play a video within a post over its lifetime.

dimension

lifetime.reactions

lifetime.reactions

The total number of reactions (e.g., likes, loves, wows) a post received over its lifetime.

metric

lifetime.reactions_angry

lifetime.reactions_angry

The total number of “angry” reactions received on content over its lifetime.

dimension

lifetime.reactions_haha

lifetime.reactions_haha

The total number of “haha” reactions received on content over its lifetime.

dimension

lifetime.reactions_love

lifetime.reactions_love

The total number of “love” reactions received on content over its lifetime.

dimension

lifetime.reactions_sad

lifetime.reactions_sad

The total number of “sad” reactions received on content over its lifetime.

dimension

lifetime.reactions_wow

lifetime.reactions_wow

The total number of “wow” reactions received on content over its lifetime.

dimension

lifetime.saves

lifetime.saves

The total number of times a post was saved by users over its lifetime.

metric

lifetime.shares_count

lifetime.shares_count

The total number of times a post was shared or reposted by users over its lifetime.

metric

lifetime.subscribers_gained

lifetime.subscribers_gained

The total number of new subscribers gained on a video channel over its lifetime.

dimension

lifetime.subscribers_lost

lifetime.subscribers_lost

The total number of subscribers lost on a video channel over its lifetime.

dimension

lifetime.video_view_percentage

lifetime.video_view_percentage

The average percentage of a video that was watched over its lifetime.

dimension

lifetime.video_view_time

lifetime.video_view_time

The total amount of time viewers spent watching videos over their lifetime.

dimension

lifetime.video_view_time_organic

lifetime.video_view_time_organic

The total amount of time viewers spent watching organic videos over their lifetime.

dimension

lifetime.video_view_time_paid

lifetime.video_view_time_paid

The total amount of time viewers spent watching paid videos over their lifetime.

dimension

lifetime.video_views

lifetime.video_views

The total number of video views for a post over its lifetime.

metric

lifetime.video_views_organic

lifetime.video_views_organic

The total number of organic (unpaid) video views over their lifetime.

metric

lifetime.video_views_paid

lifetime.video_views_paid

The total number of paid video views over their lifetime.

dimension

lifetime.video_views_unique

lifetime.video_views_unique

The total number of unique users who watched videos over their lifetime.

dimension

lifetime_snapshot.followers_by_age_gender

lifetime_snapshot.followers_by_age_gender

A lifetime snapshot of the audience breakdown by age and gender demographics.

dimension

lifetime_snapshot.followers_by_country

lifetime_snapshot.followers_by_country

A lifetime snapshot of the audience breakdown by country.

dimension

lifetime_snapshot.followers_by_gender

lifetime_snapshot.followers_by_gender

A lifetime snapshot of the audience breakdown by gender.

dimension

lifetime_snapshot.followers_count

lifetime_snapshot.followers_count

The total number of followers for the profile as a lifetime snapshot.

metric

lifetime_snapshot.followers_online

lifetime_snapshot.followers_online

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.

dimension

lifetime_snapshot.following_count

lifetime_snapshot.following_count

The total number of profiles a social media account is following. This metric is available for Instagram and Pinterest Owned Profile Metrics.

metric

likes

likes

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.

metric

likes_organic

likes_organic

The number of likes received on content through organic (unpaid) reach.

metric

likes_total

likes_total

The total number of likes received on posts or profile content.

metric

location.city

location.city

An estimation of the city where a message was posted or where the audience of a profile is located. For Listening Messages, it’s an estimation of the city where the message was posted. For Instagram, it is part of ‘Followers By City’.

dimension

location.country

location.country

An estimation of the country where a message was posted or where the audience of a profile is located. For Listening Messages, it’s an estimation of the country where the message was posted. For Instagram and TikTok, it is part of ‘Followers By Country’.

dimension

location.province

location.province

An estimation of the province or state where a message was posted. This field is available for Listening Message Fields.

dimension

mentions

mentions

The number of times the profile or its content was mentioned by other users.

metric

name

name

The name of an entity, such as a profile, topic, or tag.

dimension

native_id

native_id

The unique identifier of the entity as provided by the native social network.

dimension

native_name

native_name

The name of the entity as it appears on the native social network.

dimension

negative_feedback

negative_feedback

Information about negative interactions with a post or profile. While ‘negative_feedback’ itself is not directly listed as a standalone metric, ‘lifetime.negative_feedback’ is present. It likely refers to a broader category that includes negative sentiment comments or other disengagements.

metric

negative_sentiments_count

negative_sentiments_count

The count of messages or comments expressing a negative sentiment.

dimension

net_follower_growth

net_follower_growth

The overall change in the number of followers for a social profile over a specific period, calculated as followers gained minus followers lost.

metric

net_following_growth

net_following_growth

The net increase or decrease in the number of followers (followers gained minus followers lost).

metric

network

network

The social network platform from which the data originated (e.g., INSTAGRAM, FACEBOOK).

dimension

network_type

network_type

The type of social media network (e.g., Facebook, Instagram, Twitter).

dimension

neutral_sentiments_count

neutral_sentiments_count

The count of messages or comments expressing a neutral sentiment.

dimension

perma_link

perma_link

The permanent URL that links directly to the specific social media message or post on its native social network.

dimension

pin_count

pin_count

The total number of pins associated with a Pinterest profile. This metric is available for Pinterest Owned Profile Metrics.

dimension

place_checkins

place_checkins

The number of times users checked into a specific place associated with the profile or content.

metric

positive_sentiments_count

positive_sentiments_count

The count of messages or comments expressing a positive sentiment.

dimension

post_app_engagements

post_app_engagements

The number of engagements with an app promoted through a post. This metric is available for X Owned Profile Metrics.

dimension

post_app_installs

post_app_installs

The number of app install attempts initiated from a post. This metric is available for X Owned Profile Metrics.

dimension

post_app_opens

post_app_opens

The number of app opens originating from a post. This metric is available for X Owned Profile Metrics.

dimension

post_category

post_category

A categorical classification of the post content.

dimension

post_content_clicks

post_content_clicks

The total number of clicks on the content of a post.

metric

post_content_clicks_other

post_content_clicks_other

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.

metric

post_detail_expand_clicks

post_detail_expand_clicks

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.

dimension

post_engagements

post_engagements

The total number of engagements on a post (e.g., likes, comments, shares, clicks).

metric

post_hashtag_clicks

post_hashtag_clicks

The number of clicks on hashtags within a post.

dimension

post_impressions

post_impressions

The total number of times a post was displayed to users.

metric

post_impressions_nonviral

post_impressions_nonviral

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.

metric

post_impressions_organic

post_impressions_organic

The total number of times organic posts were displayed to users.

metric

post_impressions_paid

post_impressions_paid

The number of times a post was displayed through paid promotion.

metric

post_impressions_viral

post_impressions_viral

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.

metric

post_link_clicks

post_link_clicks

The total number of clicks on links within a post.

metric

post_media_clicks

post_media_clicks

The total number of clicks on media (images, videos) within a post.

dimension

post_media_views

post_media_views

The total number of views for media (images, videos) within a post.

dimension

post_photo_view_clicks

post_photo_view_clicks

The total number of clicks to expand or view a photo within a post.

metric

post_profile_clicks

post_profile_clicks

The total number of clicks on the profile name or picture originating from a post.

dimension

post_type

post_type

Uniquely identifies the social network and type of message or post (e.g., TWEET, FACEBOOK_POST, INSTAGRAM_MEDIA).

dimension

post_video_play_clicks

post_video_play_clicks

The total number of clicks to play a video within a post.

metric

posts_sent_by_content_type

posts_sent_by_content_type

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.

dimension

posts_sent_by_post_type

posts_sent_by_post_type

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.

dimension

posts_sent_count

posts_sent_count

The total number of posts sent from the profile.

metric

profile_guid

profile_guid

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.

dimension

profile_views

profile_views

The total number of times a social media profile was viewed.

metric

profile_views_total

profile_views_total

The total number of times a social media profile was viewed.

dimension

profile_views_unique

profile_views_unique

The number of unique users who viewed the social media profile.

dimension

question_answers

question_answers

The total number of answers received for questions posted on social media. This metric is available for Facebook Post Metrics.

dimension

reactions

reactions

The total number of reactions (e.g., likes, loves, wows) received on a profile or post.

metric

reactions_angry

reactions_angry

The total number of “angry” reactions received on content.

metric

reactions_haha

reactions_haha

The total number of “haha” reactions received on content.

metric

reactions_love

reactions_love

The total number of “love” reactions received on content.

metric

reactions_sad

reactions_sad

The total number of “sad” reactions received on content.

metric

reactions_wow

reactions_wow

The total number of “wow” reactions received on content.

metric

replies

replies

The number of replies to messages or comments.

metric

reporting_period.by(day)

reporting_period.by(day)

A dimension used to break down analytics data by day.

dimension

saves

saves

The total number of times a post or content was saved by users on a profile.

metric

saves_organic

saves_organic

The number of times content was saved organically by users.

metric

sent

sent

A boolean value indicating if the message was sent by the requested profiles (true) or received by them (false).

dimension

sentiment

sentiment

The overall sentiment expressed in messages or comments (e.g., positive, negative, neutral).

dimension

shares_count

shares_count

The total number of times a message or post was shared.

metric

shares_count_total

shares_count_total

The total number of times content was shared by users.

metric

story_replies

story_replies

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).

metric

tag.active

tag.active

Indicates if a tag is currently active.

dimension

tag.any_group

tag.any_group

Indicates whether a message tag is available in any customer group. This field is part of the Customer Tags Endpoint response.

dimension

tag.groups

tag.groups

An array of IDs of the groups that a specific tag is available in. This field is part of the Customer Tags Endpoint response.

dimension

tag.text

tag.text

The textual content of the tag.

dimension

tag.type

tag.type

The type of the tag, such as LABEL or CAMPAIGN. This field is part of the Customer Tags Endpoint response.

dimension

tag_id

tag_id

A unique identifier for the tag.

dimension

text

text

The textual content of the message or post.

dimension

title

title

The title of the post or content.

dimension

topic_id

topic_id

A unique identifier for a listening topic.

dimension

video_length

video_length

The duration or length of the video content.

dimension

video_view_time

video_view_time

The total duration (in seconds) that videos were watched on a profile or for a specific post.

metric

video_views

video_views

The total number of views for a video on a profile or individual post.

metric

video_views_10s

video_views_10s

The number of times a video was viewed for at least 10 seconds.

metric

video_views_10s_autoplay

video_views_10s_autoplay

The number of times a video was viewed for at least 10 seconds due to autoplay.

metric

video_views_10s_click_to_play

video_views_10s_click_to_play

The number of times a video was viewed for at least 10 seconds due to a user clicking to play.

metric

video_views_10s_organic

video_views_10s_organic

The number of times a video was viewed for at least 10 seconds through organic reach.

metric

video_views_10s_paid

video_views_10s_paid

The number of times a video was viewed for at least 10 seconds through paid promotion.

metric

video_views_10s_unique

video_views_10s_unique

The number of unique users who viewed a video for at least 10 seconds.

metric

video_views_30s_complete

video_views_30s_complete

The number of times a video was viewed for at least 30 seconds or to completion.

metric

video_views_30s_complete_autoplay

video_views_30s_complete_autoplay

The number of times a video was viewed for at least 30 seconds or to completion due to autoplay.

metric

video_views_30s_complete_click_to_play

video_views_30s_complete_click_to_play

The number of times a video was viewed for at least 30 seconds or to completion due to a user clicking to play.

metric

video_views_30s_complete_organic

video_views_30s_complete_organic

The number of times a video was viewed for at least 30 seconds or to completion through organic reach.

metric

video_views_30s_complete_paid

video_views_30s_complete_paid

The number of times a video was viewed for at least 30 seconds or to completion through paid promotion.

metric

video_views_30s_complete_repeat

video_views_30s_complete_repeat

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.

metric

video_views_30s_complete_unique

video_views_30s_complete_unique

The number of unique users who viewed a video for at least 30 seconds or to completion.

metric

video_views_autoplay

video_views_autoplay

The number of times a video started playing automatically. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.

metric

video_views_click_to_play

video_views_click_to_play

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.

metric

video_views_organic

video_views_organic

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.

metric

video_views_paid

video_views_paid

The total number of video views acquired through paid promotion.

metric

video_views_partial

video_views_partial

The number of times a video was partially viewed. This metric is available for Facebook Owned Profile Metrics and Facebook Post Metrics.

metric

video_views_partial_autoplay

video_views_partial_autoplay

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.

metric

video_views_partial_click_to_play

video_views_partial_click_to_play

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.

metric

video_views_partial_organic

video_views_partial_organic

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.

metric

video_views_partial_paid

video_views_partial_paid

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.

metric

video_views_partial_repeat

video_views_partial_repeat

The number of times a video was partially viewed during a repeat play. This metric is available for Facebook Owned Profile Metrics.

metric

video_views_repeat

video_views_repeat

The number of times a video was replayed. This metric is available for Facebook Owned Profile Metrics.

metric

video_views_total

video_views_total

The total number of video views.

dimension

video_views_unique

video_views_unique

The total number of unique users who watched videos.

metric

visual_media

visual_media

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.

dimension