Sprout Social

Explore the interactive ERD

Table & Field Reference

case_message

Column	Type	Keys
`cases_id`	Unknown	PKFK
`message_guid`	Unknown	PKFK
`anchor`	Unknown
`case_message_direction`	Unknown

case_tag

Column	Type	Keys
`cases_id`	Unknown	PKFK
`tag_id`	Unknown	PKFK
`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	PKFK

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	PKFK
`profile_id`	Int	PKFK

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