# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Sprout Social connector:

* [Customer Tags](#customer-tags) 
* [Customer Groups](#customer-groups) 
* [Customer Users ](#customer-users)
* [Customer Profile ](#customer-profile)
* [Analytics Posts](#analytics-posts) 
* [Analytics Profile](#analytics-profile) 
* [Messages](#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](https://api.sproutsocial.com/docs/#customer-tags-endpoint).

**Fields**

<table><thead><tr><th width="288">Field Name</th><th width="266">Data Type</th></tr></thead><tbody><tr><td>tag_id</td><td>NUMERIC</td></tr><tr><td>any_group</td><td>BOOLEAN</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>groups</td><td>STRING</td></tr><tr><td>active</td><td>BOOLEAN</td></tr></tbody></table>

#### Customer Groups&#x20;

Get the list of groups created in Sprout Social. For more information, see [Customer Groups Endpoint](https://api.sproutsocial.com/docs/#customer-groups-endpoint).

**Fields**

<table><thead><tr><th width="288">Field Name</th><th width="266">Data Type</th></tr></thead><tbody><tr><td>group_id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr></tbody></table>

#### Customer Users&#x20;

Get the list of users that are active for your customer. For more information, see [Customer Users Endpoint](https://api.sproutsocial.com/docs/#customer-users-endpoint).

**Fields**

<table><thead><tr><th width="288">Field Name</th><th width="266">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr></tbody></table>

#### Customer Profile&#x20;

Get the list of customer profile IDs you have access to. For more information, see [Customer Profiles Endpoint](https://api.sproutsocial.com/docs/#customer-profiles-endpoint).

**Fields**

<table><thead><tr><th width="288">Field Name</th><th width="266">Data Type</th></tr></thead><tbody><tr><td>customer_profile_id</td><td>NUMERIC</td></tr><tr><td>network_type</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>native_name</td><td>STRING</td></tr><tr><td>link</td><td>STRING</td></tr><tr><td>native_id</td><td>STRING</td></tr><tr><td>groups</td><td>STRING</td></tr></tbody></table>

#### Analytics Posts&#x20;

Used to query for individual sent posts based on specific filter criteria. For more information, see [Post Analytics Endpoint](https://api.sproutsocial.com/docs/#post-analytics-endpoint).

**Fields**

<table><thead><tr><th width="288">Field Name</th><th width="266">Data Type</th></tr></thead><tbody><tr><td>text</td><td>STRING</td></tr><tr><td>perma_link</td><td>STRING</td></tr><tr><td>sent</td><td>BOOLEAN</td></tr><tr><td>created_time</td><td>TIMESTAMP</td></tr></tbody></table>

**Metrics**

For more information, see [Metrics & Fields](https://api.sproutsocial.com/docs/#metrics--fields).

<table><thead><tr><th width="321">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>lifetime.comments_count</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_organic_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.story_taps_back</td><td>NUMERIC</td></tr><tr><td>lifetime.story_taps_forward</td><td>NUMERIC</td></tr><tr><td>lifetime.story_exits</td><td>NUMERIC</td></tr><tr><td>lifetime.likes</td><td>NUMERIC</td></tr><tr><td>lifetime.saves</td><td>NUMERIC</td></tr><tr><td>lifetime.shares_count</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.post_content_clicks</td><td>NUMERIC</td></tr><tr><td>lifetime.post_content_clicks_other</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_paid_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_paid</td><td>NUMERIC</td></tr><tr><td>video_length</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_p95</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_30s_complete</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_partial_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_p95_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_p95_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_partial_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_partial</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_partial_autoplay</td><td>NUMERIC</td></tr><tr><td>lifetime.post_activity_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.question_answers_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.comments_count_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.shares_count_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.engagements_follower_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.engagements_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_follower</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_follower_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_follower_paid_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_follower_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_follower_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_nonfollower</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_nonfollower_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_nonfollower_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_nonviral</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_nonviral_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_viral</td><td>NUMERIC</td></tr><tr><td>lifetime.impressions_viral_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.negative_feedback</td><td>NUMERIC</td></tr><tr><td>lifetime.negative_feedback_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.post_video_play_clicks</td><td>NUMERIC</td></tr><tr><td>lifetime.post_content_clicks_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.post_other_clicks_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.post_video_play_clicks_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.question_answers</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions_angry</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions_haha</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions_love</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions_sad</td><td>NUMERIC</td></tr><tr><td>lifetime.reactions_wow</td><td>NUMERIC</td></tr><tr><td>lifetime.video_view_time_per_view</td><td>NUMERIC</td></tr><tr><td>lifetime.video_view_time</td><td>NUMERIC</td></tr><tr><td>lifetime.video_view_time_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_autoplay</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_click_to_play</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_sound_on</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_autoplay</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_click_to_play</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_30s_complete_autoplay</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_30s_complete_click_to_play</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_30s_complete_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_30s_complete_organic</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_p95_organic_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_30s_complete_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_p95_paid_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_organic_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_paid_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_sound_on</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_sound_off</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_10s_sound_off</td><td>NUMERIC</td></tr><tr><td>lifetime.video_view_time_paid</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_partial_click_to_play</td><td>NUMERIC</td></tr><tr><td>lifetime.post_photo_view_clicks</td><td>NUMERIC</td></tr><tr><td>lifetime.post_photo_view_clicks_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.post_link_clicks</td><td>NUMERIC</td></tr><tr><td>lifetime.post_link_clicks_unique</td><td>NUMERIC</td></tr><tr><td>lifetime.video_views_p100_per_view</td><td>NUMERIC</td></tr><tr><td>lifetime.impression_source_for_you</td><td>NUMERIC</td></tr><tr><td>lifetime.impression_source_follow</td><td>NUMERIC</td></tr><tr><td>lifetime.impression_source_hashtag</td><td>NUMERIC</td></tr><tr><td>lifetime.impression_source_personal_profile</td><td>NUMERIC</td></tr><tr><td>lifetime.impression_source_sound</td><td>NUMERIC</td></tr><tr><td>lifetime.impression_source_unspecified</td><td>NUMERIC</td></tr></tbody></table>

#### Analytics Profile&#x20;

Used to query profile-level metrics for a given set of profiles. For more information, see [Owned Profile Analytics Endpoint](https://api.sproutsocial.com/docs/#owned-profile-analytics-endpoint).

**Note**: This table in Daton doesn't support any primary key.

**Fields**

<table><thead><tr><th width="288">Field Name</th><th width="266">Data Type</th></tr></thead><tbody><tr><td>dimensions</td><td>RECORD</td></tr></tbody></table>

**Metrics**

For more information, see [Metrics & Fields](https://api.sproutsocial.com/docs/#metrics--fields).

<table><thead><tr><th width="320">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>impressions </td><td>NUMERIC</td></tr><tr><td>reactions </td><td>NUMERIC</td></tr><tr><td>lifetime_snapshot.followers_count </td><td>NUMERIC</td></tr><tr><td>net_follower_growth </td><td>NUMERIC</td></tr><tr><td>post_media_views </td><td>NUMERIC</td></tr><tr><td>video_views </td><td>NUMERIC</td></tr><tr><td>likes </td><td>NUMERIC</td></tr><tr><td>comments_count </td><td>NUMERIC</td></tr><tr><td>shares_count </td><td>NUMERIC</td></tr><tr><td>post_content_clicks </td><td>NUMERIC</td></tr><tr><td>post_link_clicks </td><td>NUMERIC</td></tr><tr><td>post_content_clicks_other </td><td>NUMERIC</td></tr><tr><td>post_media_clicks </td><td>NUMERIC</td></tr><tr><td>post_hashtag_clicks </td><td>NUMERIC</td></tr><tr><td>post_detail_expand_clicks </td><td>NUMERIC</td></tr><tr><td>post_profile_clicks </td><td>NUMERIC</td></tr><tr><td>engagements_other </td><td>NUMERIC</td></tr><tr><td>post_app_engagements </td><td>NUMERIC</td></tr><tr><td>post_app_installs </td><td>NUMERIC</td></tr><tr><td>post_app_opens </td><td>NUMERIC</td></tr><tr><td>posts_sent_count </td><td>NUMERIC</td></tr><tr><td>posts_sent_by_post_type </td><td>RECORD</td></tr><tr><td>posts_sent_by_content_type </td><td>RECORD</td></tr><tr><td>followers_gained </td><td>NUMERIC</td></tr><tr><td>followers_gained_organic </td><td>NUMERIC</td></tr><tr><td>followers_gained_paid </td><td>NUMERIC</td></tr><tr><td>followers_lost </td><td>NUMERIC</td></tr><tr><td>impressions_organic </td><td>NUMERIC</td></tr><tr><td>impressions_viral </td><td>NUMERIC</td></tr><tr><td>impressions_nonviral </td><td>NUMERIC</td></tr><tr><td>impressions_paid </td><td>NUMERIC</td></tr><tr><td>tab_views </td><td>NUMERIC</td></tr><tr><td>tab_views_login </td><td>NUMERIC</td></tr><tr><td>tab_views_logout </td><td>NUMERIC</td></tr><tr><td>post_impressions </td><td>NUMERIC</td></tr><tr><td>post_impressions_organic </td><td>NUMERIC</td></tr><tr><td>post_impressions_viral </td><td>NUMERIC</td></tr><tr><td>post_impressions_nonviral </td><td>NUMERIC</td></tr><tr><td>post_impressions_paid </td><td>NUMERIC</td></tr><tr><td>impressions_unique </td><td>NUMERIC</td></tr><tr><td>impressions_organic_unique </td><td>NUMERIC</td></tr><tr><td>impressions_viral_unique </td><td>NUMERIC</td></tr><tr><td>impressions_nonviral_unique </td><td>NUMERIC</td></tr><tr><td>impressions_paid_unique </td><td>NUMERIC</td></tr><tr><td>profile_views </td><td>NUMERIC</td></tr><tr><td>profile_views_login </td><td>NUMERIC</td></tr><tr><td>profile_views_logout </td><td>NUMERIC</td></tr><tr><td>profile_views_login_unique </td><td>NUMERIC</td></tr><tr><td>reactions_love </td><td>NUMERIC</td></tr><tr><td>reactions_haha </td><td>NUMERIC</td></tr><tr><td>reactions_wow </td><td>NUMERIC</td></tr><tr><td>reactions_sad </td><td>NUMERIC</td></tr><tr><td>reactions_angry </td><td>NUMERIC</td></tr><tr><td>post_photo_view_clicks </td><td>NUMERIC</td></tr><tr><td>post_video_play_clicks </td><td>NUMERIC</td></tr><tr><td>profile_actions </td><td>NUMERIC</td></tr><tr><td>post_engagements </td><td>NUMERIC</td></tr><tr><td>cta_clicks_login </td><td>NUMERIC</td></tr><tr><td>question_answers </td><td>RECORD</td></tr><tr><td>offer_claims </td><td>NUMERIC</td></tr><tr><td>positive_feedback_other </td><td>NUMERIC</td></tr><tr><td>event_rsvps </td><td>NUMERIC</td></tr><tr><td>place_checkins </td><td>NUMERIC</td></tr><tr><td>place_checkins_mobile </td><td>NUMERIC</td></tr><tr><td>profile_content_activity </td><td>NUMERIC</td></tr><tr><td>negative_feedback </td><td>NUMERIC</td></tr><tr><td>video_views_organic </td><td>NUMERIC</td></tr><tr><td>video_views_paid </td><td>NUMERIC</td></tr><tr><td>video_views_autoplay </td><td>NUMERIC</td></tr><tr><td>video_views_click_to_play </td><td>NUMERIC</td></tr><tr><td>video_views_repeat </td><td>NUMERIC</td></tr><tr><td>video_view_time </td><td>NUMERIC</td></tr><tr><td>video_views_unique </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete_organic </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete_paid </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete_autoplay </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete_click_to_play </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete_repeat </td><td>NUMERIC</td></tr><tr><td>video_views_30s_complete_unique </td><td>NUMERIC</td></tr><tr><td>video_views_partial </td><td>NUMERIC</td></tr><tr><td>video_views_partial_organic </td><td>NUMERIC</td></tr><tr><td>video_views_partial_paid </td><td>NUMERIC</td></tr><tr><td>video_views_partial_autoplay </td><td>NUMERIC</td></tr><tr><td>video_views_partial_click_to_play </td><td>NUMERIC</td></tr><tr><td>video_views_partial_repeat </td><td>NUMERIC</td></tr><tr><td>video_views_10s </td><td>NUMERIC</td></tr><tr><td>video_views_10s_organic </td><td>NUMERIC</td></tr><tr><td>video_views_10s_paid </td><td>NUMERIC</td></tr><tr><td>video_views_10s_autoplay </td><td>NUMERIC</td></tr><tr><td>video_views_10s_click_to_play </td><td>NUMERIC</td></tr><tr><td>video_views_10s_repeat </td><td>NUMERIC</td></tr><tr><td>video_views_10s_unique </td><td>NUMERIC</td></tr><tr><td>lifetime_snapshot.following_count </td><td>NUMERIC</td></tr><tr><td>net_following_growth </td><td>NUMERIC</td></tr><tr><td>profile_views_unique </td><td>NUMERIC</td></tr><tr><td>saves </td><td>NUMERIC</td></tr><tr><td>story_replies </td><td>NUMERIC</td></tr><tr><td>email_contacts </td><td>NUMERIC</td></tr><tr><td>get_directions_clicks </td><td>NUMERIC</td></tr><tr><td>phone_call_clicks </td><td>NUMERIC</td></tr><tr><td>text_message_clicks </td><td>NUMERIC</td></tr><tr><td>website_clicks </td><td>NUMERIC</td></tr><tr><td>pin_count </td><td>NUMERIC</td></tr><tr><td>inbox_counts_sent </td><td>RECORD</td></tr><tr><td>inbox_received_sent </td><td>NUMERIC</td></tr><tr><td>comments_count_total </td><td>NUMERIC</td></tr><tr><td>lifetime_snapshot.followers_by_country </td><td>RECORD</td></tr><tr><td>lifetime_snapshot.followers_by_gender </td><td>RECORD</td></tr><tr><td>lifetime_snapshot.followers_online </td><td>NUMERIC</td></tr><tr><td>likes_total </td><td>NUMERIC</td></tr><tr><td>profile_views_total </td><td>NUMERIC</td></tr><tr><td>shares_count_total </td><td>NUMERIC</td></tr><tr><td>video_views_total</td><td>NUMERIC</td></tr></tbody></table>

#### Messages&#x20;

Provides detailed data and metadata about your Sprout Social messages. For more information, see [Messages Endpoint](https://api.sproutsocial.com/docs/#messages-endpoint).

**Fields**

<table><thead><tr><th width="257">Field Name</th><th width="127">Data Type</th></tr></thead><tbody><tr><td>network </td><td>STRING</td></tr><tr><td>activity_metadata.first_like.time_elapsed </td><td>ARRAY&#x3C;MAP></td></tr><tr><td>created_time </td><td>DATE</td></tr><tr><td>post_category </td><td>STRING</td></tr><tr><td>post_type </td><td>STRING</td></tr><tr><td>perma_link </td><td>STRING</td></tr><tr><td>text </td><td>STRING</td></tr><tr><td>from </td><td>MAP</td></tr><tr><td>profile_guid </td><td>STRING</td></tr><tr><td>internal.tags.id </td><td>ARRAY&#x3C;NUMBER></td></tr><tr><td>internal.sent_by.id </td><td>NUMBER</td></tr><tr><td>internal.sent_by.email </td><td>STRING</td></tr><tr><td>content_category </td><td>STRING</td></tr><tr><td>from.guid </td><td>STRING</td></tr><tr><td>from.name </td><td>STRING</td></tr><tr><td>from.profile_picture </td><td>STRING</td></tr><tr><td>from.screen_name </td><td>STRING</td></tr><tr><td>guid </td><td>STRING</td></tr><tr><td>customer_profile_id </td><td>STRING</td></tr><tr><td>internal </td><td>MAP</td></tr><tr><td>internal.sent_by.first_name </td><td>STRING</td></tr><tr><td>internal.sent_by.last_name </td><td>STRING</td></tr><tr><td>sent </td><td>BOOLEAN</td></tr><tr><td>inbox_permalink </td><td>STRING</td></tr><tr><td>title </td><td>STRING</td></tr><tr><td>clickthrough_link </td><td>MAP</td></tr><tr><td>clickthrough_link.name </td><td>STRING</td></tr><tr><td>clickthrough_link.long </td><td>STRING</td></tr><tr><td>clickthrough_link.short </td><td>STRING</td></tr><tr><td>hashtags </td><td>ARRAY&#x3C;STRING></td></tr><tr><td>visual_media </td><td>ARRAY&#x3C;MAP></td></tr><tr><td>pinterest.board_name </td><td>STRING</td></tr><tr><td>activity_metadata </td><td>ARRAY&#x3C;MAP></td></tr></tbody></table>