# Sprout Social schema ERD

Table and field reference for the Fivetran Sprout Social connector.

## Table & Field Reference

### case_message

| Column | Type | Keys |
| --- | --- | --- |
| cases_id | Unknown | PK, FK |
| message_guid | Unknown | PK, FK |
| anchor | Unknown |  |
| case_message_direction | Unknown |  |

### case_tag

| Column | Type | Keys |
| --- | --- | --- |
| cases_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |
| updated_by | Unknown |  |
| updated_on | Unknown |  |

### cases

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_by | Unknown |  |
| assignees | Unknown |  |
| closed_time | Unknown |  |
| created_by | Unknown |  |
| created_time | Unknown |  |
| group_id | Unknown |  |
| priority | Unknown |  |
| queue_id | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_time | Unknown |  |

### instagram_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comments_count | Int |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| email_contacts | Int |  |
| followers_by_age_gender | Json |  |
| followers_by_city | Json |  |
| followers_by_country | Json |  |
| followers_count | Int |  |
| followers_gained | Int |  |
| followers_lost | Int |  |
| get_directions_clicks | Int |  |
| impressions | Int |  |
| impressions_unique | Int |  |
| likes | Int |  |
| net_follower_growth | Int |  |
| phone_call_clicks | Int |  |
| posts_sent_by_content_type | Json |  |
| posts_sent_by_post_type | Json |  |
| posts_sent_count | Int |  |
| profile_views_unique | Int |  |
| reactions | Long |  |
| saves | Int |  |
| shares_count | Int |  |
| story_replies | Int |  |
| text_message_clicks | Int |  |
| video_views | Long |  |
| website_clicks | Int |  |

### facebook_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comments_count | Int |  |
| cta_clicks_login | Int |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| event_rsvps | Int |  |
| followers_count | Int |  |
| followers_gained | Int |  |
| followers_gained_organic | Int |  |
| followers_gained_paid | Int |  |
| followers_lost | Int |  |
| impressions | Int |  |
| impressions_nonviral | Int |  |
| impressions_organic | Int |  |
| impressions_paid | Int |  |
| impressions_unique | Int |  |
| impressions_viral | Int |  |
| likes | Int |  |
| negative_feedback | Int |  |
| net_follower_growth | Int |  |
| offer_claims | Int |  |
| place_checkins | Int |  |
| positive_feedback_other | Int |  |
| post_content_clicks_other | Int |  |
| post_engagements | Int |  |
| post_link_clicks | Int |  |
| post_photo_view_clicks | Int |  |
| post_video_play_clicks | Int |  |
| posts_sent_by_content_type | Json |  |
| posts_sent_by_post_type | Json |  |
| posts_sent_count | Int |  |
| profile_actions | Int |  |
| profile_views | Int |  |
| question_answers | Json |  |
| reactions | Int |  |
| reactions_angry | Int |  |
| reactions_haha | Int |  |
| reactions_love | Int |  |
| reactions_sad | Int |  |
| reactions_wow | Int |  |
| shares_count | Int |  |
| tab_views | Int |  |
| tab_views_login | Int |  |
| tab_views_logout | Int |  |
| video_view_time | Double |  |
| video_views | Long |  |
| video_views_10_s | Long |  |
| video_views_10_s_autoplay | Long |  |
| video_views_10_s_click_to_play | Long |  |
| video_views_10_s_organic | Long |  |
| video_views_10_s_paid | Long |  |
| video_views_10_s_repeat | Long |  |
| video_views_10_s_unique | Long |  |
| video_views_30_s_complete | Long |  |
| video_views_30_s_complete_autoplay | Long |  |
| video_views_30_s_complete_click_to_play | Long |  |
| video_views_30_s_complete_organic | Long |  |
| video_views_30_s_complete_paid | Long |  |
| video_views_30_s_complete_repeat | Long |  |
| video_views_30_s_complete_unique | Long |  |
| video_views_autoplay | Long |  |
| video_views_click_to_play | Long |  |
| video_views_organic | Long |  |
| video_views_paid | Long |  |
| video_views_partial | Long |  |
| video_views_partial_autoplay | Long |  |
| video_views_partial_click_to_play | Long |  |
| video_views_partial_organic | Long |  |
| video_views_partial_paid | Long |  |
| video_views_partial_repeat | Long |  |
| video_views_repeat | Long |  |

### tiktok_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comments_count_total | Int |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| followers_by_country | Json |  |
| followers_by_gender | Json |  |
| followers_count | Int |  |
| followers_online | Int |  |
| likes_total | Int |  |
| net_follower_growth | Int |  |
| posts_sent_by_post_type | Json |  |
| posts_sent_count | Int |  |
| profile_views_total | Int |  |
| shares_count_total | Int |  |
| video_views_total | Long |  |

### tiktok_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| from | Json |  |
| guid | String |  |
| impression_source_follow | Int |  |
| impression_source_for_you | Int |  |
| impression_source_hashtag | Int |  |
| impression_source_personal_profile | Int |  |
| impression_source_sound | Int |  |
| impression_source_unspecified | Int |  |
| impressions_unique | Int |  |
| internal | Json |  |
| likes | Int |  |
| perma_link | String |  |
| post_category | String |  |
| post_type | String |  |
| reactions | Int |  |
| sent | Boolean |  |
| shares_count | Int |  |
| text | String |  |
| video_length | Long |  |
| video_view_time | Double |  |
| video_view_time_per_view | Double |  |
| video_views | Long |  |
| video_views_p_100_per_view | Unknown |  |
| visual_media | Json |  |

### instagram_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| from | Json |  |
| guid | String |  |
| hashtags | Json |  |
| impressions | Int |  |
| impressions_unique | Int |  |
| internal | Json |  |
| likes | Int |  |
| perma_link | String |  |
| post_category | String |  |
| post_type | String |  |
| profile_guid | String |  |
| reactions | Int |  |
| saves | Int |  |
| sent | Boolean |  |
| shares_count | Int |  |
| story_exits | Int |  |
| story_taps_back | Int |  |
| story_taps_forward | Int |  |
| text | String |  |
| video_views | Long |  |
| visual_media | Json |  |

### pinterest_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| followers_count | Int |  |
| followers_gained | Int |  |
| followers_lost | Int |  |
| inbox_counts_sent | Json |  |
| inbox_received_sent | Json |  |
| net_follower_growth | Int |  |
| net_following_growth | Int |  |
| pin_count | Int |  |

### twitter_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| engagements_other | Int |  |
| from | Json |  |
| guid | String |  |
| hashtags | Json |  |
| impressions | Int |  |
| internal | Json |  |
| likes | Int |  |
| perma_link | String |  |
| post_app_engagements | Int |  |
| post_app_installs | Int |  |
| post_app_opens | Int |  |
| post_category | String |  |
| post_content_clicks | Int |  |
| post_content_clicks_other | Int |  |
| post_detail_expand_clicks | Int |  |
| post_followers_gained | Int |  |
| post_followers_lost | Int |  |
| post_hashtag_clicks | Int |  |
| post_link_clicks | Int |  |
| post_media_clicks | Int |  |
| post_media_views | Int |  |
| post_profile_clicks | Int |  |
| post_type | String |  |
| profile_guid | String |  |
| reactions | Int |  |
| sent | Boolean |  |
| shares_count | Int |  |
| text | String |  |
| title | String |  |
| video_views | Long |  |
| visual_media | Json |  |

### tag_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| tag_id | Int | PK, FK |

### tag

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Int | PK |
| id | Int | PK |
| active | Boolean |  |
| any_group | Boolean |  |
| text | String |  |

### group

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Int | PK |
| id | Int | PK |
| name | String |  |

### linkedin_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| from | Json |  |
| guid | String |  |
| impressions | Int |  |
| internal | Json |  |
| perma_link | String |  |
| post_category | String |  |
| post_content_clicks | Int |  |
| post_type | String |  |
| profile_guid | String |  |
| reactions | Int |  |
| sent | Boolean |  |
| shares_count | Int |  |
| text | String |  |
| title | String |  |
| video_views | Long |  |
| visual_media | Json |  |

### pinterest_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| board_name | String |  |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| from | Json |  |
| guid | String |  |
| internal | Json |  |
| perma_link | String |  |
| post_category | String |  |
| post_type | String |  |
| saves | Int |  |
| visual_media | Json |  |

### profile_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Int | PK |
| customer_id | Int | PK, FK |
| profile_id | Int | PK, FK |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Int | PK |
| id | Int | PK |
| name | String |  |
| native_id | String |  |
| native_name | String |  |
| network_type | String |  |

### twitter_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comments_count | Int |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| engagements_other | Int |  |
| followers_count | Int |  |
| impressions | Int |  |
| likes | Int |  |
| net_follower_growth | Int |  |
| post_app_engagements | Int |  |
| post_app_installs | Int |  |
| post_app_opens | Int |  |
| post_content_clicks | Int |  |
| post_content_clicks_other | Int |  |
| post_detail_expand_clicks | Int |  |
| post_hashtag_clicks | Int |  |
| post_link_clicks | Int |  |
| post_media_clicks | Int |  |
| post_media_views | Int |  |
| post_profile_clicks | Int |  |
| posts_sent_by_content_type | Json |  |
| posts_sent_by_post_type | Json |  |
| posts_sent_count | Int |  |
| reactions | Int |  |
| shares_count | Int |  |
| video_views | Long |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| guid | Unknown | PK |
| case_id | Unknown |  |
| clickthrough_link_long | Unknown |  |
| clickthrough_link_name | Unknown |  |
| clickthrough_link_short | Unknown |  |
| content_category | Unknown |  |
| created_time | Unknown |  |
| customer_profile_id | Unknown |  |
| from_guid | Unknown |  |
| from_name | Unknown |  |
| from_profile_picture | Unknown |  |
| from_screen_name | Unknown |  |
| hashtags | Unknown |  |
| inbox_permalink | Unknown |  |
| internal_tags | Unknown |  |
| network | Unknown |  |
| perma_link | Unknown |  |
| post_category | Unknown |  |
| post_type | Unknown |  |
| profile_guid | Unknown |  |
| sent | Unknown |  |
| sent_by_email | Unknown |  |
| sent_by_first_name | Unknown |  |
| sent_by_id | Unknown |  |
| sent_by_image | Unknown |  |
| sent_by_last_name | Unknown |  |
| text | Unknown |  |
| title | Unknown |  |
| visual_media | Unknown |  |
| custom_** |  |  |

### youtube_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| annotation_click_through_rate | Int |  |
| annotation_clickable_impressions | Int |  |
| annotation_clicks | Int |  |
| annotation_closable_impressions | Int |  |
| annotation_close_rate | Int |  |
| annotation_closes | Int |  |
| annotation_impressions | Int |  |
| card_click_rate | Int |  |
| card_clicks | Int |  |
| card_impressions | Int |  |
| card_teaser_click_rate | Int |  |
| card_teaser_clicks | Int |  |
| card_teaser_impressions | Int |  |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| dislikes | Int |  |
| estimated_minutes_watched | Int |  |
| estimated_red_minutes_watched | Int |  |
| from | Json |  |
| guid | String |  |
| internal | Json |  |
| likes | Int |  |
| perma_link | String |  |
| post_category | String |  |
| post_content_clicks_other | Int |  |
| post_type | String |  |
| profile_guid | String |  |
| reactions | Int |  |
| red_video_views | Long |  |
| sent | Boolean |  |
| shares_count | Int |  |
| subscribers_gained | Int |  |
| subscribers_lost | Int |  |
| text | String |  |
| title | String |  |
| video_view_percentage | Int |  |
| video_view_time_per_view | Double |  |
| video_views | Long |  |
| videos_added_to_playlist | Int |  |
| videos_removed_from_playlist | Int |  |
| visual_media | Json |  |

### facebook_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clickthrough_link | Json |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| engagements_follower_unique | Int |  |
| engagements_unique | Int |  |
| from | Json |  |
| guid | String |  |
| hashtags | Json |  |
| impressions | Int |  |
| impressions_follower | Int |  |
| impressions_follower_unique | Int |  |
| impressions_nonfollower | Int |  |
| impressions_nonviral | Int |  |
| impressions_paid | Int |  |
| impressions_unique | Int |  |
| impressions_viral | Int |  |
| internal | Json |  |
| likes | Int |  |
| negative_feedback | Int |  |
| negative_feedback_unique | Int |  |
| perma_link | String |  |
| post_category | String |  |
| post_content_clicks | Int |  |
| post_content_clicks_other | Int |  |
| post_content_clicks_unique | Int |  |
| post_link_clicks | Int |  |
| post_link_clicks_unique | Int |  |
| post_other_clicks_unique | Int |  |
| post_photo_view_clicks | Int |  |
| post_photo_view_clicks_unique | Int |  |
| post_type | String |  |
| post_video_play_clicks | Long |  |
| post_video_play_clicks_unique | Long |  |
| profile_guid | String |  |
| question_answers | Json |  |
| reactions | Int |  |
| reactions_angry | Int |  |
| reactions_haha | Int |  |
| reactions_love | Int |  |
| reactions_sad | Int |  |
| reactions_wow | Int |  |
| sent | Boolean |  |
| shares_count | Int |  |
| text | String |  |
| title | String |  |
| video_ad_break_cost_per_impression | Int |  |
| video_ad_break_earnings | Int |  |
| video_ad_break_impressions | Int |  |
| video_length | Long |  |
| video_view_time | Double |  |
| video_view_time_organic | Long |  |
| video_view_time_paid | Long |  |
| video_view_time_per_view | Double |  |
| video_views | Long |  |
| video_views_10_s | Long |  |
| video_views_10_s_autoplay | Long |  |
| video_views_10_s_click_to_play | Long |  |
| video_views_10_s_organic | Long |  |
| video_views_10_s_paid | Long |  |
| video_views_10_s_sound_off | Long |  |
| video_views_10_s_sound_on | Long |  |
| video_views_10_s_unique | Long |  |
| video_views_30_s_complete | Long |  |
| video_views_30_s_complete_autoplay | Long |  |
| video_views_30_s_complete_click_to_play | Long |  |
| video_views_30_s_complete_organic | Long |  |
| video_views_30_s_complete_paid | Long |  |
| video_views_30_s_complete_unique | Long |  |
| video_views_autoplay | Long |  |
| video_views_click_to_play | Long |  |
| video_views_organic | Long |  |
| video_views_p_95 | Long |  |
| video_views_p_95_organic | Long |  |
| video_views_p_95_organic_unique | Long |  |
| video_views_p_95_paid | Long |  |
| video_views_p_95_paid_unique | Long |  |
| video_views_paid | Long |  |
| video_views_partial | Long |  |
| video_views_partial_autoplay | Long |  |
| video_views_partial_click_to_play | Long |  |
| video_views_partial_organic | Long |  |
| video_views_partial_paid | Long |  |
| video_views_sound_off | Long |  |
| video_views_sound_on | Long |  |
| visual_media | Json |  |

### linkedin_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comments_count | Int |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| followers_count | Int |  |
| followers_gained | Int |  |
| followers_gained_organic | Int |  |
| followers_gained_paid | Int |  |
| followers_lost | Int |  |
| impressions | Int |  |
| impressions_unique | Int |  |
| net_follower_growth | Int |  |
| post_content_clicks | Int |  |
| posts_sent_by_content_type | Json |  |
| posts_sent_by_post_type | Json |  |
| posts_sent_count | Int |  |
| reactions | Int |  |
| shares_count | Int |  |

### threads_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comments_count | Int |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| followers_by_city | Json |  |
| followers_by_country | Json |  |
| followers_by_gender | Json |  |
| likes | Int |  |
| profile_views | Int |  |
| quotes_count | Int |  |
| reposts_count | Long |  |
| shares_count | Int |  |

### threads_profile_post

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| clickthrough_link | String |  |
| comments_count | Int |  |
| content_category | String |  |
| created_time | Instant |  |
| customer_id | String |  |
| customer_profile_id | Long |  |
| guid | String |  |
| impression_source_follow | Int |  |
| likes | Int |  |
| network | String |  |
| perma_link | String |  |
| post_category | String |  |
| post_shares_count | Int |  |
| post_type | String |  |
| profile_guid | String |  |
| reactions | Int |  |
| sent | Boolean |  |
| sent_by_id | Int |  |
| sentiment_comments_negative_count | Int |  |
| sentiment_comments_neutral_count | Int |  |
| sentiment_comments_positive_count | Int |  |
| sentiment_comments_unclassified_count | Int |  |
| shares_count | Int |  |
| text | String |  |
| visual_media | Json |  |

### user

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Int | PK |
| id | Int | PK |
| name | String |  |

### youtube_profile_analytic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_id | String |  |
| customer_profile_id | Long |  |
| date | LocalDate |  |
| followers_count | Int |  |
| followers_gained | Int |  |
| followers_lost | Int |  |
| net_follower_growth | Int |  |

## Relationships

- case_message(message_guid) → message(guid)
- case_message(cases_id) → cases(id)
- case_tag(tag_id) → tag(id)
- case_tag(cases_id) → cases(id)
- tag_group(tag_id) → tag(id)
- profile_group(profile_id) → profile(id)
- profile_group(customer_id) → profile(customer_id)