Sprout Social Connector Reference

199 metrics51 dimensions

Fields

The Sprout Social connector exposes 250 fields (199 metrics, 51 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Sprout Social Fields

Sprout Social connector fields

The connector report of the Sprout Social connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Account ID of the connected account
account_name	TEXT	Account name	Account name of the connected account
date	DATE	Date	The Date

Sprout Social post_fields fields

The post_fields report of the Sprout Social connector includes 25 fields.

ID	Type	Name	Description
post_author_guid	TEXT	Post Author GUID	The native ID of the authors' profile prefixed with a Sprout code that represents where the data was collected.
post_author_name	TEXT	Post Author Name	The display name of the author.
post_author_profile_picture	IMAGE_URL	Post Author Profile Picture	URL to the profile picture of the post author.
post_author_screen_name	TEXT	Post Author Screen Name	Also commonly called "handle," this field is mutable on most networks, but not changed as often as the display name.
post_category	TEXT	Post Category	A unified version of post_type, these names are not network specific.
post_clickthrough_link_long	TEXT	Post Clickthrough Long	The full length (long) URL to the link.
post_clickthrough_link_name	TEXT	Post Clickthrough Link	The name given to the link as named during post time.
post_clickthrough_link_short	TEXT	Post Clickthrough Short	The short URL of the given link, either provided at post time or generated.
post_content_category	TEXT	Post Content Category	Unified categorization of the content. The hierarchy is album, video, photo, link, poll or text.
post_created_time	TIMESTAMP	Post Created Time	An iso8601 timestamp representing the publication date and time of the message.
post_customer_profile_id	TEXT	Post Customer Profile ID	ID of the profile associated with this message.
post_guid	TEXT	Post GUID	The native ID of the message prefixed with a Sprout code that represents where this type of message is.
post_hashtags	TEXT	Post Hashtags	Array of hashtags associated with the message (does not include the "#" character).
post_network	TEXT	Post Network	The social network that the data came from (e.g. INSTAGRAM).
post_permalink	TEXT	Post Permalink	URL to the message on the social network.
post_profile_guid	TEXT	Post Profile GUID	The ID of the profile being tracked prefixed with an Sprout code that represents where the data was collected. When the message was made by the profile being tracked, this field will be identical to post_author_guid.
post_sender_email	TEXT	Post Sender Email	Email address of the team member that sent this message.
post_sender_first_name	TEXT	Post Sender First Name	First name of the team member that sent this message.
post_sender_id	TEXT	Post Sender ID	ID of the team member that sent this message via Sprout.
post_sender_last_name	TEXT	Post Sender Last Name	Last name of the team member that sent this message.
post_tags_ids	TEXT	Post Tags IDs	Array of tag IDs this message is associated with. Includes active and archived tags.
post_tags_names	TEXT	Post Tags Names	Array of tag names this message is associated with, resolved from the tag IDs. Includes active and archived tags.
post_text	TEXT	Post Text	The text in the body of the message.
post_title	TEXT	Post Text	Text that is separate from the usual body of the message, usually shown as a title for the message in the social network.
post_type	TEXT	Post Type	Uniquely identifies the social network and type of message this is.

Sprout Social post_metrics fields

The post_metrics report of the Sprout Social connector includes 111 fields.

Sprout Social post_metrics fields (post_annotation_click_through_rate to post_impressions_nonviral)

ID	Type	Name	Description
post_annotation_click_through_rate	NUMERIC	Post Annotation Click Through Rate (Lifetime)	The through rate of the post annotation clicks (lifetime)
post_annotation_clickable_impressions	NUMERIC	Post Annotation Clickable Impressions (Lifetime)	The number of the post annotation clickable impressions (lifetime)
post_annotation_clicks	NUMERIC	Post Annotation Clicks (Lifetime)	The number of the post annotation clicks (lifetime)
post_annotation_closable_impressions	NUMERIC	Post Annotation Closable Impressions (Lifetime)	The number of the post annotation closable impressions (lifetime)
post_annotation_close_rate	NUMERIC	Post Annotation Close Rate (Lifetime)	The rate of the post annotation closes (lifetime)
post_annotation_closes	NUMERIC	Post Annotation Closes (Lifetime)	The number of the post annotation closes (lifetime)
post_annotation_impressions	NUMERIC	Post Annotation Impressions (Lifetime)	The number of the post annotation impressions (lifetime)
post_app_engagements	NUMERIC	Post App Engagements (Lifetime)	The number of the post app engagements (lifetime)
post_app_installs	NUMERIC	Post App Installs (Lifetime)	The number of the post app installs (lifetime)
post_app_opens	NUMERIC	Post App Opens (Lifetime)	The number of the post app opens (lifetime)
post_card_click_rate	NUMERIC	Post Card Click Rate (Lifetime)	The rate of the post card clicks (lifetime)
post_card_clicks	NUMERIC	Post Card Clicks (Lifetime)	The number of the post card clicks (lifetime)
post_card_impressions	NUMERIC	Post Card Impressions (Lifetime)	The number of the post card impressions (lifetime)
post_card_teaser_click_rate	NUMERIC	Post Card Teaser Click Rate (Lifetime)	The rate of the post card teaser clicks (lifetime)
post_card_teaser_clicks	NUMERIC	Post Card Teaser Clicks (Lifetime)	The number of the post card teaser clicks (lifetime)
post_card_teaser_impressions	NUMERIC	Post Card Teaser Impressions (Lifetime)	The number of the post card teaser impressions (lifetime)
post_comments	NUMERIC	Post Comments (Lifetime)	The number of the post comments (lifetime)
post_comments_negative	NUMERIC	Post Negative Comments (Lifetime)	The number of the post negative comments (lifetime)
post_comments_neutral	NUMERIC	Post Neutral Comments (Lifetime)	The number of the post neutral comments (lifetime)
post_comments_positive	NUMERIC	Post Positive Comments (Lifetime)	The number of the post positive comments (lifetime)
post_comments_unclassified	NUMERIC	Post Unclassified Comments (Lifetime)	The number of the post unclassified comments (lifetime)
post_content_clicks	NUMERIC	Post Content Clicks (Lifetime)	The number of the post content clicks (lifetime)
post_content_clicks_other	NUMERIC	Post Other Content Clicks (Lifetime)	The number of the post other content clicks (lifetime)
post_detail_expand_clicks	NUMERIC	Post Detail Expand Clicks (Lifetime)	The number of the post detail expand clicks (lifetime)
post_engagements_other	NUMERIC	Post Other Engagements (Lifetime)	The number of the post other engagements (lifetime)
post_estimated_minutes_watched	NUMERIC	Post Estimated Minutes Watched (Lifetime)	The estimation of watched minutes for the post (lifetime)
post_estimated_red_minutes_watched	NUMERIC	Post Estimated Red Minutes Watched (Lifetime)	The estimation of watched red minutes for the post (lifetime)
post_followers_gained	NUMERIC	Post Followers Gained (Lifetime)	The number of the followers gained from the post (lifetime)
post_followers_lost	NUMERIC	Post Followers Lost (Lifetime)	The number of the followers lost from the post (lifetime)
post_hashtag_clicks	NUMERIC	Post Hashtag Clicks (Lifetime)	The number of the post hashtag clicks (lifetime)
post_impression_source_follow	NUMERIC	Post Impression Source Follow (Lifetime)	The number of impressions got from follows (lifetime)
post_impression_source_for_you	NUMERIC	Post Impression Source for You (Lifetime)	The number of impressions got from 'for you' (lifetime)
post_impression_source_hashtag	NUMERIC	Post Impression Source Hashtag (Lifetime)	The number of impressions got from hashtags (lifetime)
post_impression_source_personal_profile	NUMERIC	Post Impression Source Personal Profile (Lifetime)	The number of impressions got from personal profile (lifetime)
post_impression_source_sound	NUMERIC	Post Impression Source Sound (Lifetime)	The number of impressions got from sound (lifetime)
post_impression_source_unspecified	NUMERIC	Post Impression Source Unspecified (Lifetime)	The number of impressions got from unspecified source (lifetime)
post_impressions	NUMERIC	Post Impressions (Lifetime)	The number of the post impressions (lifetime)
post_impressions_follower	NUMERIC	Post Follower Impressions (Lifetime)	The number of the post follower impressions (lifetime)
post_impressions_nonfollower	NUMERIC	Post Non-follower Impressions (Lifetime)	The number of the post non-follower impressions (lifetime)
post_impressions_nonviral	NUMERIC	Post Non-viral Impressions (Lifetime)	The number of the post non-viral impressions (lifetime)

Sprout Social post_metrics fields (post_impressions_organic to post_video_view_time_paid)

ID	Type	Name	Description
post_impressions_organic	NUMERIC	Post Organic Impressions (Lifetime)	The number of the post organic impressions (lifetime)
post_impressions_paid	NUMERIC	Post Paid Impressions (Lifetime)	The number of the post paid impressions (lifetime)
post_impressions_viral	NUMERIC	Post Viral Impressions (Lifetime)	The number of the post viral impressions (lifetime)
post_likes	NUMERIC	Post Likes (Lifetime)	The number of the post likes (lifetime)
post_link_clicks	NUMERIC	Post Link Clicks (Lifetime)	The number of the post link clicks (lifetime)
post_link_in_bio_clicks	NUMERIC	Post SproutLink Clicks (Lifetime)	The number of the post link in bio clicks (lifetime)
post_media_clicks	NUMERIC	Post Media Clicks (Lifetime)	The number of the post media clicks (lifetime)
post_media_views	NUMERIC	Post Media Views (Lifetime)	The number of the post media views (lifetime)
post_photo_view_clicks	NUMERIC	Post Photo View Clicks (Lifetime)	The number of the post photo view clicks (lifetime)
post_post_shares	NUMERIC	Post Post-shares (Lifetime)	The number of the post post-shares (lifetime)
post_profile_clicks	NUMERIC	Post Profile Clicks (Lifetime)	The number of the post profile clicks (lifetime)
post_question_answers	NUMERIC	Post Question Answers (Lifetime)	The number of the post question answers (lifetime)
post_reach	NUMERIC	Post Reach (Lifetime)	The number of the post unique impressions (lifetime)
post_reach_follower	NUMERIC	Post Follower Reach (Lifetime)	The number of the post follower unique impressions (lifetime)
post_reach_nonviral	NUMERIC	Post Non-viral Reach (Lifetime)	The number of the post non-viral unique impressions (lifetime)
post_reach_organic	NUMERIC	Post Organic Reach (Lifetime)	The number of the post organic unique impressions (lifetime)
post_reach_paid	NUMERIC	Post Paid Reach (Lifetime)	The number of the post paid unique impressions (lifetime)
post_reach_viral	NUMERIC	Post Viral Reach (Lifetime)	The number of the post viral unique impressions (lifetime)
post_reactions	NUMERIC	Post Reactions (Lifetime)	The number of the post reactions (lifetime)
post_reactions_angry	NUMERIC	Post Angry Reactions (Lifetime)	The number of the post angry reactions (lifetime)
post_reactions_haha	NUMERIC	Post Haha Reactions (Lifetime)	The number of the post haha reactions (lifetime)
post_reactions_love	NUMERIC	Post Love Reactions (Lifetime)	The number of the post love reactions (lifetime)
post_reactions_sad	NUMERIC	Post Sad Reactions (Lifetime)	The number of the post sad reactions (lifetime)
post_reactions_wow	NUMERIC	Post Wow Reactions (Lifetime)	The number of the post wow reactions (lifetime)
post_red_video_views	NUMERIC	Post Red Video Views (Lifetime)	The number of the post red video views (lifetime)
post_reels_unique_session_plays	NUMERIC	Post Reels Unique Session Plays (Lifetime)	The reels unique session plays (lifetime)
post_saves	NUMERIC	Post Saves (Lifetime)	The number of the post saves (lifetime)
post_sentiment_score	NUMERIC	Post Net Sentiment Score (Lifetime)	The sentiment score of the post comments (lifetime)
post_shares	NUMERIC	Post Shares (Lifetime)	The number of the post shares (lifetime)
post_story_exits	NUMERIC	Post Story Exits (Lifetime)	The number of the post story exits (lifetime)
post_story_taps_back	NUMERIC	Post Story Taps Back (Lifetime)	The number of the post story taps back (lifetime)
post_story_taps_forward	NUMERIC	Post Story Taps Forward (Lifetime)	The number of the post story taps forward (lifetime)
post_video_ad_break_cost_per_impression	NUMERIC	Post Video Ad Break Ad Cost per Impression (CPM) (Lifetime)	The video ad break cost per impression (lifetime)
post_video_ad_break_earnings	NUMERIC	Post Video Ad Break Ad Earnings (Lifetime)	The amount of the post video ad break ad earnings (lifetime)
post_video_ad_break_impressions	NUMERIC	Post Video Ad Break Ad Impressions (Lifetime)	The number of the post video ad break ad impressions (lifetime)
post_video_length	NUMERIC	Post Video Length (Lifetime)	The length of the video in the post (lifetime)
post_video_play_clicks	NUMERIC	Post Video Play Clicks (Lifetime)	The number of the post video play clicks (lifetime)
post_video_view_time	NUMERIC	Post Video View Time (Lifetime)	The total time of the post video views (lifetime)
post_video_view_time_organic	NUMERIC	Post Organic Video View Time (Lifetime)	The total time of the post organic video views (lifetime)
post_video_view_time_paid	NUMERIC	Post Paid Video View Time (Lifetime)	The total time of the post paid video views (lifetime)

Sprout Social post_metrics fields (post_video_view_time_per_view to post_views)

ID	Type	Name	Description
post_video_view_time_per_view	NUMERIC	Post Average Video Time Watched (Lifetime)	The average time of the post video views (lifetime)
post_video_views	NUMERIC	Post Video Views (Lifetime)	The number of the post video views (lifetime)
post_video_views_30s_complete	NUMERIC	Post Full Video Views (Lifetime)	The number of the post full video views (lifetime)
post_video_views_30s_complete_autoplay	NUMERIC	Post Autoplay Full Video Views (Lifetime)	The number of the post autoplay full video views (lifetime)
post_video_views_30s_complete_click_to_play	NUMERIC	Post Click to Play Full Video Views (Lifetime)	The number of the post click to play full video views (lifetime)
post_video_views_30s_complete_organic	NUMERIC	Post Organic Full Video Views (Lifetime)	The number of the post organic full video views (lifetime)
post_video_views_30s_complete_paid	NUMERIC	Post Paid Full Video Views (Lifetime)	The number of the post paid full video views (lifetime)
post_video_views_30s_complete_unique	NUMERIC	Post Unique Full Video Views (Lifetime)	The number of the unique post full video views (lifetime)
post_video_views_autoplay	NUMERIC	Post Autoplay Video Views (Lifetime)	The number of the post autoplay video views (lifetime)
post_video_views_click_to_play	NUMERIC	Post Click to Play Video Views (Lifetime)	The number of the post click to play video views (lifetime)
post_video_views_organic	NUMERIC	Post Organic Video Views (Lifetime)	The number of the post organic video views (lifetime)
post_video_views_organic_unique	NUMERIC	Post Unique Organic Video Views (Lifetime)	The number of the unique post organic video views (lifetime)
post_video_views_p100_per_view	NUMERIC	Post Full Video Watch Rate (Lifetime)	The rate of times the post video watched fully (lifetime)
post_video_views_p95	NUMERIC	Post 95% Video Views (Lifetime)	The number of the post 95% video views (lifetime)
post_video_views_p95_organic	NUMERIC	Post Organic 95% Video Views (Lifetime)	The number of the post organic 95% video views (lifetime)
post_video_views_p95_organic_unique	NUMERIC	Post Unique Organic 95% Video Views (Lifetime)	The number of the unique post organic 95% video views (lifetime)
post_video_views_p95_paid	NUMERIC	Post Paid 95% Video Views (Lifetime)	The number of the post paid 95% video views (lifetime)
post_video_views_p95_paid_unique	NUMERIC	Post Unique Paid 95% Video Views (Lifetime)	The number of the unique post paid 95% video views (lifetime)
post_video_views_paid	NUMERIC	Post Paid Video Views (Lifetime)	The number of the post paid video views (lifetime)
post_video_views_paid_unique	NUMERIC	Post Unique Paid Video Views (Lifetime)	The number of the unique post paid video views (lifetime)
post_video_views_partial	NUMERIC	Post Partial Video Views (Lifetime)	The number of the post partial video views (lifetime)
post_video_views_partial_autoplay	NUMERIC	Post Autoplay Partial Video Views (Lifetime)	The number of the post autoplay partial video views (lifetime)
post_video_views_partial_click_to_play	NUMERIC	Post Click to Play Partial Video Views (Lifetime)	The number of the post click to play partial video views (lifetime)
post_video_views_partial_organic	NUMERIC	Post Organic Partial Video Views (Lifetime)	The number of the post organic partial video views (lifetime)
post_video_views_partial_paid	NUMERIC	Post Paid Partial Video Views (Lifetime)	The number of the post paid partial video views (lifetime)
post_video_views_sound_off	NUMERIC	Post Sound Off Video Views (Lifetime)	The number of the post sound off video views (lifetime)
post_video_views_sound_on	NUMERIC	Post Sound On Video Views (Lifetime)	The number of the post sound on video views (lifetime)
post_video_views_unique	NUMERIC	Post Unique Video Views (Lifetime)	The number of the unique post video views (lifetime)
post_videos_added_to_playlist	NUMERIC	Post Video Added to Playlist (Lifetime)	The number of times the post video added to a playlist (lifetime)
post_videos_removed_from_playlist	NUMERIC	Post Video Removed from Playlist (Lifetime)	The number of times the post video removed from a playlist (lifetime)
post_views	NUMERIC	Post Views (Lifetime)	The number of the post views (lifetime)

Sprout Social profile_metrics fields

The profile_metrics report of the Sprout Social connector includes 86 fields.

Sprout Social profile_metrics fields (profile_actions to profile_pin_count)

ID	Type	Name	Description
profile_actions	NUMERIC	Profile Actions	Profile actions
profile_app_engagements	NUMERIC	Profile App Engagements	Profile app engagements
profile_app_installs	NUMERIC	Profile App Install Attempts	Profile app install attempts
profile_app_opens	NUMERIC	Profile App Opens	Profile app opens
profile_clicks	NUMERIC	Profile Clicks	Profile clicks
profile_clicks_other	NUMERIC	Profile Other Post Clicks	Profile other post clicks
profile_comments	NUMERIC	Profile Comments Count	Profile comments count
profile_comments_total	NUMERIC	Profile Total Comments (TikTok)	Profile total comments count (TikTok)
profile_content_clicks	NUMERIC	Profile Post Content Clicks	Profile post content clicks
profile_detail_expand_clicks	NUMERIC	Profile Post Detail Expand Clicks	Profile post detail expand clicks
profile_engagements	NUMERIC	Profile Engagements	The number of engagements with the profile
profile_engagements_other	NUMERIC	Profile Other Engagements	Profile other engagements
profile_fans	NUMERIC	Profile Fans (Lifetime Snapshot)	The number of fans of the profile (lifetime snapshot)
profile_fans_gained	NUMERIC	Profile Fans Gained	The number of gained fans of the profile
profile_fans_gained_organic	NUMERIC	Profile Fans Gained Organic	The number of organically gained fans of the profile
profile_fans_gained_paid	NUMERIC	Profile Fans Gained Paid	The number of gained fans of the profile (paid)
profile_fans_lost	NUMERIC	Profile Fans Lost	The number of lost fans of the profile
profile_followers	NUMERIC	Profile Followers (Lifetime Snapshot)	The audience/followers of the profile (lifetime snapshot)
profile_followers_gained	NUMERIC	Profile Followers Gained	The audience/followers gained by the profile
profile_followers_gained_organic	NUMERIC	Profile Organic Followers Gained	The audience/followers gained by the profile organically
profile_followers_gained_paid	NUMERIC	Profile Paid Followers Gained	The audience/followers gained by the profile (paid)
profile_followers_lost	NUMERIC	Profile Followers Lost	The audience/followers lost by the profile
profile_followers_net_growth	NUMERIC	Profile Followers Net Growth	Net growth of the profile audience/followers
profile_followers_online	NUMERIC	Profile Followers Online (Lifetime Snapshot)	The online following/followers of the profile (lifetime snapshot)
profile_following	NUMERIC	Profile Following (Lifetime Snapshot)	The following/followers of the profile (lifetime snapshot)
profile_following_net_growth	NUMERIC	Profile Following Net Growth	Profile following net growth
profile_hashtag_clicks	NUMERIC	Profile Post Hashtag Clicks	Profile post hashtag clicks
profile_impressions	NUMERIC	Profile Impressions	The number of the profile impressions
profile_impressions_nonviral	NUMERIC	Profile Impressions Non-viral	The number of the non-viral profile impressions
profile_impressions_organic	NUMERIC	Profile Impressions Organic	The number of the organic profile impressions
profile_impressions_paid	NUMERIC	Profile Impressions Paid	The number of the paid profile impressions
profile_impressions_total	NUMERIC	Profile Impressions Total	The number of the total profile impressions
profile_impressions_viral	NUMERIC	Profile Impressions Viral	The number of the viral profile impressions
profile_inbox_received_sent	NUMERIC	Profile Inbox Received Sent	Profile inbox received sent
profile_likes	NUMERIC	Profile Likes	Profile likes
profile_likes_total	NUMERIC	Profile Total Likes (TikTok)	Profile total likes (TikTok)
profile_link_clicks	NUMERIC	Profile Post Link Clicks	Profile post link clicks
profile_media_clicks	NUMERIC	Profile Post Media Clicks	Profile post media clicks
profile_media_views	NUMERIC	Profile Post Media Views	Profile Media views
profile_pin_count	NUMERIC	Profile Pin Count	Profile pin count

Sprout Social profile_metrics fields (profile_post_engagements to profile_video_views_partial_paid)

ID	Type	Name	Description
profile_post_engagements	NUMERIC	Profile Post Engagements	Profile post engagements
profile_post_impressions	NUMERIC	Profile Post Impressions	The number of the profile post impressions
profile_post_impressions_nonviral	NUMERIC	Profile Post Impressions Non-viral	The number of the non-viral profile post impressions
profile_post_impressions_organic	NUMERIC	Profile Post Impressions Organic	The number of the organic profile post impressions
profile_post_impressions_paid	NUMERIC	Profile Post Impressions Paid	The number of the paid profile post impressions
profile_post_impressions_viral	NUMERIC	Profile Post Impressions Viral	The number of the viral profile post impressions
profile_posts_sent	NUMERIC	Profile Posts Sent	Profile posts sent count
profile_quotes	NUMERIC	Profile Quotes Count	Profile quotes count
profile_reach	NUMERIC	Profile Reach	The reach (unique impressions) of the profile. Not supported for TikTok profiles.
profile_reach_nonviral	NUMERIC	Profile Non-viral Reach	Non-viral reach (unique impressions) of the profile.
profile_reach_organic	NUMERIC	Profile Organic Reach	Organic reach (unique impressions) of the profile.
profile_reach_paid	NUMERIC	Profile Paid Reach	Paid reach (unique impressions) of the profile.
profile_reach_viral	NUMERIC	Profile Viral Reach	Viral reach (unique impressions) of the profile.
profile_reactions	NUMERIC	Profile Reactions	Profile reactions
profile_reposts	NUMERIC	Profile Reposts Count	Profile reposts count
profile_saves	NUMERIC	Profile Saves Count	Profile saves count
profile_shares	NUMERIC	Profile Shares Count	Profile shares count
profile_shares_total	NUMERIC	Profile Total Shares (TikTok)	Profile total shares count (TikTok)
profile_story_replies	NUMERIC	Profile Story Replies	Profile story replies
profile_tab_views	NUMERIC	Profile Tab Views	The number of the profile tab views
profile_tab_views_login	NUMERIC	Profile Logged In Tab Views	The number of the logged in profile tab views
profile_tab_views_logout	NUMERIC	Profile Logged Out Tab Views	The number of the logged out profile tab views
profile_video_view_time	NUMERIC	Profile Video View Time	Profile video view time
profile_video_views	NUMERIC	Profile Video Views	Profile video views
profile_video_views_30s_complete	NUMERIC	Profile Full Video Views	Profile full video views
profile_video_views_30s_complete_autoplay	NUMERIC	Profile Autoplay Full Video Views	Profile autoplay full video views
profile_video_views_30s_complete_click_to_play	NUMERIC	Profile Click to Play Full Video Views	Profile click to play full video views
profile_video_views_30s_complete_organic	NUMERIC	Profile Organic Full Video Views	Profile organic full video views
profile_video_views_30s_complete_paid	NUMERIC	Profile Paid Full Video Views	Profile paid full video views
profile_video_views_30s_complete_repeat	NUMERIC	Profile Repeat Full Video Views	Profile repeat full video views
profile_video_views_30s_complete_unique	NUMERIC	Profile Unique Full Video Views	Profile unique full video views
profile_video_views_autoplay	NUMERIC	Profile Autoplay Video Views	Profile autoplay video views
profile_video_views_click_to_play	NUMERIC	Profile Click to Play Video Views	Profile click to play video views
profile_video_views_organic	NUMERIC	Profile Organic Video Views	Profile organic video views
profile_video_views_paid	NUMERIC	Profile Paid Video Views	Profile paid video views
profile_video_views_partial	NUMERIC	Profile Partial Video Views	Profile partial video views
profile_video_views_partial_autoplay	NUMERIC	Profile Autoplay Partial Video Views	Profile autoplay partial video views
profile_video_views_partial_click_to_play	NUMERIC	Profile Click to Play Partial Video Views	Profile click to play partial video views
profile_video_views_partial_organic	NUMERIC	Profile Organic Partial Video Views	Profile organic partial video views
profile_video_views_partial_paid	NUMERIC	Profile Paid Partial Video Views	Profile paid partial video views

Sprout Social profile_metrics fields (profile_video_views_partial_repeat to profile_views_total)

ID	Type	Name	Description
profile_video_views_partial_repeat	NUMERIC	Profile Repeat Partial Video Views	Profile repeat partial video views
profile_video_views_repeat	NUMERIC	Profile Repeat Video Views	Profile repeat video views
profile_video_views_total	NUMERIC	Profile Total Video Views (TikTok)	Profile total video views (TikTok)
profile_video_views_unique	NUMERIC	Profile Unique Video Views	Profile unique video views
profile_views	NUMERIC	Profile Views	Profile views
profile_views_total	NUMERIC	Profile Total Views (TikTok)	Profile total views (TikTok)

Sprout Social profile_properties fields

The profile_properties report of the Sprout Social connector includes 5 fields.

ID	Type	Name	Description
profile_group_ids	TEXT	Profile Group IDs	An array of group IDs this profile belongs to.
profile_id	TEXT	Profile ID	The customer profile ID used by Sprout to identify this social network profile
profile_name	TEXT	Profile Name	The human-facing name of the social network profile
profile_native_name	TEXT	Profile Native Name	The user name, screen name, page URL, etc. the social network uses to identify a unique profile
profile_network_type	TEXT	Profile Network Type	The type of social network (X, Facebook, Instagram, etc.)

Sprout Social other fields

The Sprout Social connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
profile_engagement_rate_per_follower	PERCENT	Profile Engagement Rate per Follower	The number of engagements with the profile per follower	profile_calculated
profile_engagement_rate_per_impression	PERCENT	Profile Engagement Rate per Impression	The number of engagements with the profile per impression	profile_calculated
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors