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

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