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 |
|---|---|---|---|
comments_count |
comments_count |
The total number of comments received on content from a profile. |
metric |
content_category |
content_category |
A unified categorization of the content, such as album, video, photo, link, poll, or text. |
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 IDs for the groups associated with the customer profile. |
dimension |
customer_profile.link |
customer_profile.link |
The URL or link associated with 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 ID used by the native social network to identify the customer profile. |
dimension |
customer_profile.native_name |
customer_profile.native_name |
The user name, screen name, or page URL used by the native social network to identify the customer profile. |
dimension |
customer_profile.network_metadata |
customer_profile.network_metadata |
Additional metadata fields available for a subset of profile types, such as address and store codes for Google My Business and Facebook locations. |
dimension |
customer_profile.network_type |
customer_profile.network_type |
The type of social network for the customer profile (e.g., X, Facebook, Instagram). |
dimension |
customer_profile_id |
customer_profile_id |
The unique identifier used by Sprout to identify a social network profile. |
dimension |
followers_gained |
followers_gained |
The total number of new followers gained by the profile. |
metric |
from |
from |
Represents the social network profile that published the message, including all nested ‘from’ fields. |
dimension |
guid |
guid |
The native ID of the message, prefixed with a Sprout code representing the message type. |
dimension |
hashtags |
hashtags |
An array of hashtags associated with the message, without the ‘#’ character. |
dimension |
impressions |
impressions |
The total number of times content from a profile was displayed to users. |
metric |
impressions_organic |
impressions_organic |
The total number of impressions from organic (unpaid) distribution for content from a profile. |
metric |
impressions_organic_unique |
impressions_organic_unique |
The unique number of people who saw content from a profile through organic (unpaid) distribution. |
metric |
instagram.post_impressions_organic |
instagram.post_impressions_organic |
The number of times an Instagram post was seen through unpaid, organic distribution. |
metric |
lifetime.annotation_clicks |
lifetime.annotation_clicks |
The total number of clicks on annotations within a YouTube video. |
dimension |
net_following_growth |
net_following_growth |
The change in the number of profiles being followed. |
metric |
network |
network |
The social network from which the data originated (e.g., INSTAGRAM, FACEBOOK, X). |
dimension |
perma_link |
perma_link |
The permanent URL to the message or post on the social network. |
dimension |
post_category |
post_category |
A unified, network-agnostic categorization of the post type. |
dimension |
post_content_clicks_other |
post_content_clicks_other |
The total number of clicks on content within a post that are not categorized as link, photo view, or video play clicks. |
metric |
post_impressions |
post_impressions |
The total number of times a post was displayed. This metric is available for Facebook owned profiles. |
metric |
post_impressions_organic |
post_impressions_organic |
The total number of organic impressions for a post. This metric is available for Facebook owned profiles. |
metric |
post_link_clicks |
post_link_clicks |
The total number of clicks on links within posts from the profile. |
metric |
post_type |
post_type |
Uniquely identifies the social network and specific type of message or post (e.g., TWEET, INSTAGRAM_MEDIA). |
dimension |
posts_sent_by_content_type |
posts_sent_by_content_type |
The number of posts sent by content type (e.g., photo, video, link). |
dimension |
posts_sent_by_post_type |
posts_sent_by_post_type |
The number of posts sent, categorized by their specific post type (e.g., Tweet, Instagram Media, Facebook Post). |
dimension |
posts_sent_count |
posts_sent_count |
The total number of posts sent by the profile. |
metric |
profile_guid |
profile_guid |
The ID of the tracked profile, prefixed with a Sprout code representing the data collection source. |
dimension |
reactions |
reactions |
The total number of reactions received on content from a profile. |
metric |
reporting_period.by(day) |
reporting_period.by(day) |
A dimension used to break down analytics data by day. |
dimension |
shares_count |
shares_count |
The total number of times a message or post was shared. |
metric |
tag.active |
tag.active |
Indicates whether the tag is currently active or archived in Sprout Social. |
dimension |
tag.any_group |
tag.any_group |
Indicates whether this tag is available to any customer group. |
dimension |
tag.groups |
tag.groups |
An array of IDs of the groups where this tag is available. |
dimension |
tag.text |
tag.text |
The descriptive text of the tag. |
dimension |
tag_id |
tag_id |
The unique identifier used by Sprout to identify a message tag. |
dimension |
text |
text |
The textual content in the body of the message or post. |
dimension |
title |
title |
The text that serves as a title for a message, separate from its main body. |
dimension |
video_views |
video_views |
The total number of video views. |
metric |