Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Sprout Social connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Sprout Social connector:
Customer Tags
Get the list of message tags created in Sprout Social. It includes all active and archived tags, regardless of when the tag was created. For more information, see Customer Tags Endpoint.
Fields
tag_id
NUMERIC
any_group
BOOLEAN
text
STRING
groups
STRING
active
BOOLEAN
Customer Groups
Get the list of groups created in Sprout Social. For more information, see Customer Groups Endpoint.
Fields
group_id
NUMERIC
name
STRING
Customer Users
Get the list of users that are active for your customer. For more information, see Customer Users Endpoint.
Fields
id
NUMERIC
name
STRING
Customer Profile
Get the list of customer profile IDs you have access to. For more information, see Customer Profiles Endpoint.
Fields
customer_profile_id
NUMERIC
network_type
STRING
name
STRING
native_name
STRING
link
STRING
native_id
STRING
groups
STRING
Analytics Posts
Used to query for individual sent posts based on specific filter criteria. For more information, see Post Analytics Endpoint.
Fields
text
STRING
perma_link
STRING
sent
BOOLEAN
created_time
TIMESTAMP
Metrics
For more information, see Metrics & Fields.
lifetime.comments_count
NUMERIC
lifetime.impressions
NUMERIC
lifetime.impressions_organic
NUMERIC
lifetime.impressions_organic_unique
NUMERIC
lifetime.impressions_unique
NUMERIC
lifetime.story_taps_back
NUMERIC
lifetime.story_taps_forward
NUMERIC
lifetime.story_exits
NUMERIC
lifetime.likes
NUMERIC
lifetime.saves
NUMERIC
lifetime.shares_count
NUMERIC
lifetime.reactions
NUMERIC
lifetime.video_views
NUMERIC
lifetime.video_views_organic
NUMERIC
lifetime.post_content_clicks
NUMERIC
lifetime.post_content_clicks_other
NUMERIC
lifetime.impressions_paid_unique
NUMERIC
lifetime.impressions_paid
NUMERIC
video_length
NUMERIC
lifetime.video_views_p95
NUMERIC
lifetime.video_views_30s_complete
NUMERIC
lifetime.video_views_partial_paid
NUMERIC
lifetime.video_views_p95_organic
NUMERIC
lifetime.video_views_p95_paid
NUMERIC
lifetime.video_views_paid
NUMERIC
lifetime.video_views_partial_organic
NUMERIC
lifetime.video_views_partial
NUMERIC
lifetime.video_views_partial_autoplay
NUMERIC
lifetime.post_activity_unique
NUMERIC
lifetime.question_answers_unique
NUMERIC
lifetime.comments_count_unique
NUMERIC
lifetime.reactions_unique
NUMERIC
lifetime.shares_count_unique
NUMERIC
lifetime.engagements_follower_unique
NUMERIC
lifetime.engagements_unique
NUMERIC
lifetime.impressions_follower
NUMERIC
lifetime.impressions_follower_paid
NUMERIC
lifetime.impressions_follower_paid_unique
NUMERIC
lifetime.impressions_follower_unique
NUMERIC
lifetime.impressions_follower_organic
NUMERIC
lifetime.impressions_nonfollower
NUMERIC
lifetime.impressions_nonfollower_organic
NUMERIC
lifetime.impressions_nonfollower_paid
NUMERIC
lifetime.impressions_nonviral
NUMERIC
lifetime.impressions_nonviral_unique
NUMERIC
lifetime.impressions_viral
NUMERIC
lifetime.impressions_viral_unique
NUMERIC
lifetime.negative_feedback
NUMERIC
lifetime.negative_feedback_unique
NUMERIC
lifetime.post_video_play_clicks
NUMERIC
lifetime.post_content_clicks_unique
NUMERIC
lifetime.post_other_clicks_unique
NUMERIC
lifetime.post_video_play_clicks_unique
NUMERIC
lifetime.question_answers
NUMERIC
lifetime.reactions_angry
NUMERIC
lifetime.reactions_haha
NUMERIC
lifetime.reactions_love
NUMERIC
lifetime.reactions_sad
NUMERIC
lifetime.reactions_wow
NUMERIC
lifetime.video_view_time_per_view
NUMERIC
lifetime.video_view_time
NUMERIC
lifetime.video_view_time_organic
NUMERIC
lifetime.video_views_10s
NUMERIC
lifetime.video_views_10s_autoplay
NUMERIC
lifetime.video_views_10s_click_to_play
NUMERIC
lifetime.video_views_10s_organic
NUMERIC
lifetime.video_views_10s_paid
NUMERIC
lifetime.video_views_10s_sound_on
NUMERIC
lifetime.video_views_10s_unique
NUMERIC
lifetime.video_views_autoplay
NUMERIC
lifetime.video_views_click_to_play
NUMERIC
lifetime.video_views_30s_complete_autoplay
NUMERIC
lifetime.video_views_30s_complete_click_to_play
NUMERIC
lifetime.video_views_30s_complete_unique
NUMERIC
lifetime.video_views_30s_complete_organic
NUMERIC
lifetime.video_views_p95_organic_unique
NUMERIC
lifetime.video_views_30s_complete_paid
NUMERIC
lifetime.video_views_p95_paid_unique
NUMERIC
lifetime.video_views_organic_unique
NUMERIC
lifetime.video_views_paid_unique
NUMERIC
lifetime.video_views_sound_on
NUMERIC
lifetime.video_views_unique
NUMERIC
lifetime.video_views_sound_off
NUMERIC
lifetime.video_views_10s_sound_off
NUMERIC
lifetime.video_view_time_paid
NUMERIC
lifetime.video_views_partial_click_to_play
NUMERIC
lifetime.post_photo_view_clicks
NUMERIC
lifetime.post_photo_view_clicks_unique
NUMERIC
lifetime.post_link_clicks
NUMERIC
lifetime.post_link_clicks_unique
NUMERIC
lifetime.video_views_p100_per_view
NUMERIC
lifetime.impression_source_for_you
NUMERIC
lifetime.impression_source_follow
NUMERIC
lifetime.impression_source_hashtag
NUMERIC
lifetime.impression_source_personal_profile
NUMERIC
lifetime.impression_source_sound
NUMERIC
lifetime.impression_source_unspecified
NUMERIC
Analytics Profile
Used to query profile-level metrics for a given set of profiles. For more information, see Owned Profile Analytics Endpoint.
Note: This table in Daton doesn't support any primary key.
Fields
dimensions
RECORD
Metrics
For more information, see Metrics & Fields.
impressions
NUMERIC
reactions
NUMERIC
lifetime_snapshot.followers_count
NUMERIC
net_follower_growth
NUMERIC
post_media_views
NUMERIC
video_views
NUMERIC
likes
NUMERIC
comments_count
NUMERIC
shares_count
NUMERIC
post_content_clicks
NUMERIC
post_link_clicks
NUMERIC
post_content_clicks_other
NUMERIC
post_media_clicks
NUMERIC
post_hashtag_clicks
NUMERIC
post_detail_expand_clicks
NUMERIC
post_profile_clicks
NUMERIC
engagements_other
NUMERIC
post_app_engagements
NUMERIC
post_app_installs
NUMERIC
post_app_opens
NUMERIC
posts_sent_count
NUMERIC
posts_sent_by_post_type
RECORD
posts_sent_by_content_type
RECORD
followers_gained
NUMERIC
followers_gained_organic
NUMERIC
followers_gained_paid
NUMERIC
followers_lost
NUMERIC
impressions_organic
NUMERIC
impressions_viral
NUMERIC
impressions_nonviral
NUMERIC
impressions_paid
NUMERIC
tab_views
NUMERIC
tab_views_login
NUMERIC
tab_views_logout
NUMERIC
post_impressions
NUMERIC
post_impressions_organic
NUMERIC
post_impressions_viral
NUMERIC
post_impressions_nonviral
NUMERIC
post_impressions_paid
NUMERIC
impressions_unique
NUMERIC
impressions_organic_unique
NUMERIC
impressions_viral_unique
NUMERIC
impressions_nonviral_unique
NUMERIC
impressions_paid_unique
NUMERIC
profile_views
NUMERIC
profile_views_login
NUMERIC
profile_views_logout
NUMERIC
profile_views_login_unique
NUMERIC
reactions_love
NUMERIC
reactions_haha
NUMERIC
reactions_wow
NUMERIC
reactions_sad
NUMERIC
reactions_angry
NUMERIC
post_photo_view_clicks
NUMERIC
post_video_play_clicks
NUMERIC
profile_actions
NUMERIC
post_engagements
NUMERIC
cta_clicks_login
NUMERIC
question_answers
RECORD
offer_claims
NUMERIC
positive_feedback_other
NUMERIC
event_rsvps
NUMERIC
place_checkins
NUMERIC
place_checkins_mobile
NUMERIC
profile_content_activity
NUMERIC
negative_feedback
NUMERIC
video_views_organic
NUMERIC
video_views_paid
NUMERIC
video_views_autoplay
NUMERIC
video_views_click_to_play
NUMERIC
video_views_repeat
NUMERIC
video_view_time
NUMERIC
video_views_unique
NUMERIC
video_views_30s_complete
NUMERIC
video_views_30s_complete_organic
NUMERIC
video_views_30s_complete_paid
NUMERIC
video_views_30s_complete_autoplay
NUMERIC
video_views_30s_complete_click_to_play
NUMERIC
video_views_30s_complete_repeat
NUMERIC
video_views_30s_complete_unique
NUMERIC
video_views_partial
NUMERIC
video_views_partial_organic
NUMERIC
video_views_partial_paid
NUMERIC
video_views_partial_autoplay
NUMERIC
video_views_partial_click_to_play
NUMERIC
video_views_partial_repeat
NUMERIC
video_views_10s
NUMERIC
video_views_10s_organic
NUMERIC
video_views_10s_paid
NUMERIC
video_views_10s_autoplay
NUMERIC
video_views_10s_click_to_play
NUMERIC
video_views_10s_repeat
NUMERIC
video_views_10s_unique
NUMERIC
lifetime_snapshot.following_count
NUMERIC
net_following_growth
NUMERIC
profile_views_unique
NUMERIC
saves
NUMERIC
story_replies
NUMERIC
email_contacts
NUMERIC
get_directions_clicks
NUMERIC
phone_call_clicks
NUMERIC
text_message_clicks
NUMERIC
website_clicks
NUMERIC
pin_count
NUMERIC
inbox_counts_sent
RECORD
inbox_received_sent
NUMERIC
comments_count_total
NUMERIC
lifetime_snapshot.followers_by_country
RECORD
lifetime_snapshot.followers_by_gender
RECORD
lifetime_snapshot.followers_online
NUMERIC
likes_total
NUMERIC
profile_views_total
NUMERIC
shares_count_total
NUMERIC
video_views_total
NUMERIC
Messages
Provides detailed data and metadata about your Sprout Social messages. For more information, see Messages Endpoint.
Fields
network
STRING
activity_metadata.first_like.time_elapsed
ARRAY<MAP>
created_time
DATE
post_category
STRING
post_type
STRING
perma_link
STRING
text
STRING
from
MAP
profile_guid
STRING
internal.tags.id
ARRAY<NUMBER>
internal.sent_by.id
NUMBER
internal.sent_by.email
STRING
content_category
STRING
from.guid
STRING
from.name
STRING
from.profile_picture
STRING
from.screen_name
STRING
guid
STRING
customer_profile_id
STRING
internal
MAP
internal.sent_by.first_name
STRING
internal.sent_by.last_name
STRING
sent
BOOLEAN
inbox_permalink
STRING
title
STRING
clickthrough_link
MAP
clickthrough_link.name
STRING
clickthrough_link.long
STRING
clickthrough_link.short
STRING
hashtags
ARRAY<STRING>
visual_media
ARRAY<MAP>
pinterest.board_name
STRING
activity_metadata
ARRAY<MAP>
Last updated