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

• Customer Groups

• Customer Users

• Customer Profile

• Analytics Posts

• Analytics Profile

• Messages

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

Field Name	Data Type
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

Field Name	Data Type
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

Field Name	Data Type
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

Field Name	Data Type
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

Field Name	Data Type
text	STRING
perma_link	STRING
sent	BOOLEAN
created_time	TIMESTAMP

Metrics

For more information, see Metrics & Fields.

Field Name	Data Type
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

Field Name	Data Type
dimensions	RECORD

Metrics

For more information, see Metrics & Fields.

Field Name	Data Type
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

Field Name	Data Type
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>