# Khoros Marketing schema ERD

Table and field reference for the Fivetran Khoros Marketing connector.

## Table & Field Reference

### customer_feedback

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account | Unknown |  |
| agent_name | Unknown |  |
| agent_username | Unknown |  |
| author_display_name | Unknown |  |
| author_username | Unknown |  |
| comment | Unknown |  |
| customer_name | Unknown |  |
| date | Unknown |  |
| first_responder_display_name | Unknown |  |
| first_responder_username | Unknown |  |
| initiative | Unknown |  |
| label | Unknown |  |
| nps_rating | Unknown |  |
| stream_item_text | Unknown |  |
| stream_item_url | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| channel | Unknown | FK |
| account | Unknown |  |
| account_id | Unknown |  |
| date | Unknown |  |
| metric | Unknown |  |
| value | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| channel | Unknown | PK |
| channel_profile_id | Unknown | PK |
| account_number | Unknown |  |
| account_number_added_date | Unknown |  |
| address_city | Unknown |  |
| address_state | Unknown |  |
| address_street_1 | Unknown |  |
| address_zip | Unknown |  |
| case_number | Unknown |  |
| case_number_added_date | Unknown |  |
| last_update_date | Unknown |  |
| note_added_date | Unknown |  |
| note_author_email | Unknown |  |
| note_author_name | Unknown |  |
| note_content | Unknown |  |
| note_initiative | Unknown |  |
| note_updated_date | Unknown |  |
| note_updater_email | Unknown |  |
| note_updater_name | Unknown |  |
| order_number | Unknown |  |
| order_number_added_date | Unknown |  |
| phone_number | Unknown |  |
| profile_email | Unknown |  |
| profile_full_name | Unknown |  |
| profile_label | Unknown |  |

### stream_item_data

| Column | Type | Keys |
| --- | --- | --- |
| stream_item_id | Unknown | PK |
| channel | Unknown | FK |
| channel_profile_id | Unknown | FK |
| account | Unknown |  |
| author_display_name | Unknown |  |
| author_profile_url | Unknown |  |
| author_username | Unknown |  |
| bot_assigned | Unknown |  |
| channel_item_id | Unknown |  |
| current_state | Unknown |  |
| first_responded_date | Unknown |  |
| first_responder_display_name | Unknown |  |
| first_responder_username | Unknown |  |
| initiative | Unknown |  |
| label | Unknown |  |
| native_url | Unknown |  |
| parent_channel_item_id | Unknown |  |
| parent_stream_item_id | Unknown |  |
| parent_stream_item_type | Unknown |  |
| parent_stream_item_url | Unknown |  |
| published_date | Unknown |  |
| rating | Unknown |  |
| responded_from_account | Unknown |  |
| responded_within_sla | Unknown |  |
| stream_id | Unknown |  |
| stream_ids | Unknown |  |
| stream_item_note | Unknown |  |
| stream_item_note_display_name | Unknown |  |
| stream_item_note_timestamp | Unknown |  |
| stream_item_note_username | Unknown |  |
| stream_item_text | Unknown |  |
| stream_item_type | Unknown |  |
| stream_item_url | Unknown |  |
| stream_name | Unknown |  |
| stream_names | Unknown |  |
| stream_type | Unknown |  |
| stream_types | Unknown |  |
| topic_id | Unknown |  |
| topic_name | Unknown |  |

### stream_item_action

| Column | Type | Keys |
| --- | --- | --- |
| stream_item_id | Unknown | PK, FK |
| channel | Unknown | FK |
| channel_profile_id | Unknown | FK |
| account | Unknown |  |
| action | Unknown |  |
| action_date | Unknown |  |
| agent_name | Unknown |  |
| agent_username | Unknown |  |
| assigned_to_name | Unknown |  |
| assigned_to_username | Unknown |  |
| author_display_name | Unknown |  |
| author_profile_url | Unknown |  |
| author_username | Unknown |  |
| channel_item_id | Unknown |  |
| from_state | Unknown |  |
| initiative | Unknown |  |
| label | Unknown |  |
| native_url | Unknown |  |
| note | Unknown |  |
| parent_channel_item_id | Unknown |  |
| parent_stream_item_type | Unknown |  |
| responded_from_account | Unknown |  |
| responded_within_sla | Unknown |  |
| response_id | Unknown |  |
| response_text | Unknown |  |
| stream_id | Unknown |  |
| stream_item_date | Unknown |  |
| stream_item_text | Unknown |  |
| stream_item_type | Unknown |  |
| stream_item_url | Unknown |  |
| stream_name | Unknown |  |
| stream_names | Unknown |  |
| stream_type | Unknown |  |
| stream_types | Unknown |  |
| team | Unknown |  |
| to_state | Unknown |  |
| topic_id | Unknown |  |
| topic_name | Unknown |  |

### daily_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| channel | Unknown | FK |
| account | Unknown |  |
| account_id | Unknown |  |
| date | Unknown |  |
| metric | Unknown |  |
| value | Unknown |  |

### ad_net_value

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | Unknown | PK |
| channel | Unknown | FK |
| ad_account | Unknown |  |
| ad_account_currency | Unknown |  |
| ad_campaign | Unknown |  |
| ad_campaign_id | Unknown |  |
| ad_click_all | Unknown |  |
| ad_comment | Unknown |  |
| ad_created_date | Unknown |  |
| ad_engagement | Unknown |  |
| ad_engagement_rate | Unknown |  |
| ad_impression | Unknown |  |
| ad_link_click | Unknown |  |
| ad_media_engagement | Unknown |  |
| ad_name | Unknown |  |
| ad_reaction | Unknown |  |
| ad_save | Unknown |  |
| ad_set | Unknown |  |
| ad_set_end_date | Unknown |  |
| ad_set_id | Unknown |  |
| ad_set_start_date | Unknown |  |
| ad_share | Unknown |  |
| ad_text | Unknown |  |
| ad_title | Unknown |  |
| ad_video_play | Unknown |  |
| ad_video_view_10_s | Unknown |  |
| ad_video_view_10_s_cost | Unknown |  |
| ad_video_view_3_s | Unknown |  |
| ad_video_view_3_s_cost | Unknown |  |
| ad_video_watch_100_percent | Unknown |  |
| ad_video_watch_25_percent | Unknown |  |
| ad_video_watch_50_percent | Unknown |  |
| ad_video_watch_75_percent | Unknown |  |
| ad_video_watch_95_percent | Unknown |  |
| add_of_payment_info | Unknown |  |
| add_of_payment_info_cost | Unknown |  |
| add_of_payment_info_value | Unknown |  |
| add_to_cart | Unknown |  |
| add_to_cart_cost | Unknown |  |
| add_to_cart_value | Unknown |  |
| add_to_wishlist | Unknown |  |
| add_to_wishlist_cost | Unknown |  |
| add_to_wishlist_value | Unknown |  |
| app_install | Unknown |  |
| app_install_cost | Unknown |  |
| app_installs_value | Unknown |  |
| application_submitted | Unknown |  |
| application_submitted_cost | Unknown |  |
| application_submitted_value | Unknown |  |
| budget | Unknown |  |
| budget_type | Unknown |  |
| buying_type | Unknown |  |
| checkout_initiated | Unknown |  |
| checkout_initiated_cost | Unknown |  |
| checkout_initiated_value | Unknown |  |
| content_view | Unknown |  |
| content_view_cost | Unknown |  |
| content_view_value | Unknown |  |
| cpc_all | Unknown |  |
| cpc_cost_per_link_click | Unknown |  |
| cpm_cost_per_1000_impression | Unknown |  |
| ctr_all | Unknown |  |
| ctr_link_click_through_rate | Unknown |  |
| custom_conversion | Unknown |  |
| custom_conversion_cost | Unknown |  |
| custom_conversion_value | Unknown |  |
| delivery_start_date | Unknown |  |
| device | Unknown |  |
| download | Unknown |  |
| download_cost | Unknown |  |
| download_value | Unknown |  |
| event_response | Unknown |  |
| image_link | Unknown |  |
| label | Unknown |  |
| landing_page_view | Unknown |  |
| landing_page_view_cost | Unknown |  |
| landing_page_view_value | Unknown |  |
| lead | Unknown |  |
| lead_cost | Unknown |  |
| lead_form | Unknown |  |
| lead_form_cost | Unknown |  |
| lead_form_value | Unknown |  |
| lead_value | Unknown |  |
| link | Unknown |  |
| objective | Unknown |  |
| optimization_goal | Unknown |  |
| page_engagement_from_ad | Unknown |  |
| page_engagement_rate_from_ad | Unknown |  |
| page_like | Unknown |  |
| page_photo_view | Unknown |  |
| plan | Unknown |  |
| platform | Unknown |  |
| position | Unknown |  |
| purchase | Unknown |  |
| purchase_cost | Unknown |  |
| purchase_roas_return_on_ad_spend | Unknown |  |
| purchase_value | Unknown |  |
| registration_completed | Unknown |  |
| registration_completed_cost | Unknown |  |
| registration_completed_value | Unknown |  |
| search | Unknown |  |
| search_cost | Unknown |  |
| search_value | Unknown |  |
| social_account | Unknown |  |
| spend | Unknown |  |
| status | Unknown |  |
| subscription | Unknown |  |
| subscription_cost | Unknown |  |
| subscription_value | Unknown |  |
| time_elapsed_percentage | Unknown |  |
| total_conversion | Unknown |  |
| total_conversion_cost | Unknown |  |
| total_conversion_value | Unknown |  |

### published_post

| Column | Type | Keys |
| --- | --- | --- |
| khoros_post_id | Unknown | PK |
| channel | Unknown | FK |
| account | Unknown |  |
| account_set | Unknown |  |
| account_set_id | Unknown |  |
| asset_id | Unknown |  |
| channel_account_id | Unknown |  |
| channel_post_id | Unknown |  |
| dark | Unknown |  |
| facebook_post_click_button_click | Unknown |  |
| facebook_post_click_link_click | Unknown |  |
| facebook_post_click_other_click | Unknown |  |
| facebook_post_click_photo_view | Unknown |  |
| facebook_post_click_video_play | Unknown |  |
| facebook_post_comment | Unknown |  |
| facebook_post_engaged_fan | Unknown |  |
| facebook_post_engaged_user | Unknown |  |
| facebook_post_fan_impression | Unknown |  |
| facebook_post_fan_impression_paid | Unknown |  |
| facebook_post_fan_reach | Unknown |  |
| facebook_post_fan_reach_paid | Unknown |  |
| facebook_post_impression | Unknown |  |
| facebook_post_impression_organic | Unknown |  |
| facebook_post_impression_paid | Unknown |  |
| facebook_post_impression_viral | Unknown |  |
| facebook_post_negative_feedback | Unknown |  |
| facebook_post_negative_feedback_hide | Unknown |  |
| facebook_post_negative_feedback_hide_all | Unknown |  |
| facebook_post_negative_feedback_report | Unknown |  |
| facebook_post_negative_feedback_unlike_page | Unknown |  |
| facebook_post_negative_feedback_user | Unknown |  |
| facebook_post_reach | Unknown |  |
| facebook_post_reach_organic | Unknown |  |
| facebook_post_reach_paid | Unknown |  |
| facebook_post_reach_viral | Unknown |  |
| facebook_post_reaction | Unknown |  |
| facebook_post_reaction_angry | Unknown |  |
| facebook_post_reaction_haha | Unknown |  |
| facebook_post_reaction_like | Unknown |  |
| facebook_post_reaction_love | Unknown |  |
| facebook_post_reaction_sad | Unknown |  |
| facebook_post_reaction_wow | Unknown |  |
| facebook_post_share | Unknown |  |
| facebook_post_unique_engagement_rate | Unknown |  |
| facebook_post_video_avg_watch_time | Unknown |  |
| facebook_post_video_length | Unknown |  |
| facebook_post_video_view_30_s_autoplayed | Unknown |  |
| facebook_post_video_view_30_s_clicked_to_play | Unknown |  |
| facebook_post_video_view_30_s_organic | Unknown |  |
| facebook_post_video_view_30_s_paid | Unknown |  |
| facebook_post_video_view_3_s | Unknown |  |
| facebook_post_video_view_3_s_autoplayed | Unknown |  |
| facebook_post_video_view_3_s_clicked_to_play | Unknown |  |
| facebook_post_video_view_3_s_organic | Unknown |  |
| facebook_post_video_view_3_s_paid | Unknown |  |
| facebook_post_video_view_complete_organic | Unknown |  |
| facebook_post_video_view_complete_paid | Unknown |  |
| facebook_post_video_viewer_3_s | Unknown |  |
| facebook_post_video_viewer_3_s_organic | Unknown |  |
| facebook_post_video_viewer_3_s_paid | Unknown |  |
| facebook_post_video_viewer_complete_organic | Unknown |  |
| facebook_post_video_viewer_complete_paid | Unknown |  |
| image_link | Unknown |  |
| initiative | Unknown |  |
| initiative_id | Unknown |  |
| instagram_post_comment | Unknown |  |
| instagram_post_impression | Unknown |  |
| instagram_post_like | Unknown |  |
| instagram_post_reach | Unknown |  |
| instagram_post_save | Unknown |  |
| instagram_post_share_reel | Unknown |  |
| instagram_post_video_play_reel | Unknown |  |
| instagram_post_video_view | Unknown |  |
| instagram_story_chapter_exit | Unknown |  |
| instagram_story_chapter_impression | Unknown |  |
| instagram_story_chapter_reach | Unknown |  |
| instagram_story_chapter_replie | Unknown |  |
| instagram_story_chapter_taps_back | Unknown |  |
| instagram_story_chapter_taps_forward | Unknown |  |
| khoros_account_id | Unknown |  |
| khoros_link_id | Unknown |  |
| khoros_publishing_event_id | Unknown |  |
| khoros_stream_item_key | Unknown |  |
| label | Unknown |  |
| link | Unknown |  |
| link_description | Unknown |  |
| link_title | Unknown |  |
| linkedin_post_click | Unknown |  |
| linkedin_post_comment | Unknown |  |
| linkedin_post_impression | Unknown |  |
| linkedin_post_like | Unknown |  |
| linkedin_post_share | Unknown |  |
| linkedin_post_video_time_watched | Unknown |  |
| linkedin_post_video_time_watched_3_s | Unknown |  |
| linkedin_post_video_view_3_s | Unknown |  |
| linkedin_post_video_viewer | Unknown |  |
| media_link | Unknown |  |
| media_type | Unknown |  |
| permalink | Unknown |  |
| pinterest_avg_play_time | Unknown |  |
| pinterest_outbound_click | Unknown |  |
| pinterest_pin_click | Unknown |  |
| pinterest_post_comment | Unknown |  |
| pinterest_post_impression | Unknown |  |
| pinterest_post_like | Unknown |  |
| pinterest_post_save | Unknown |  |
| pinterest_total_play_time | Unknown |  |
| pinterest_video_start | Unknown |  |
| pinterest_video_view | Unknown |  |
| pinterest_video_view_10_s | Unknown |  |
| pinterest_video_view_95 | Unknown |  |
| plan | Unknown |  |
| post_engagement | Unknown |  |
| post_engagement_advanced | Unknown |  |
| post_engagement_rate | Unknown |  |
| post_engagement_rate_advanced | Unknown |  |
| post_link_shortener_click | Unknown |  |
| post_text | Unknown |  |
| post_title | Unknown |  |
| published_date | Unknown |  |
| response | Unknown |  |
| sinaweibo_post_comment | Unknown |  |
| sinaweibo_post_repost | Unknown |  |
| tiktok_post_comment | Unknown |  |
| tiktok_post_like | Unknown |  |
| tiktok_post_reach | Unknown |  |
| tiktok_post_video_view | Unknown |  |
| tiktok_post_video_views_complete | Unknown |  |
| tiktok_video_average_watch_time | Unknown |  |
| tiktok_video_length | Unknown |  |
| tiktok_video_share | Unknown |  |
| tiktok_video_total_play_time | Unknown |  |
| twitter_post_click_app_install_click_advanced | Unknown |  |
| twitter_post_click_app_open_click_advanced | Unknown |  |
| twitter_post_click_detail_expand_advanced | Unknown |  |
| twitter_post_click_email_click_advanced | Unknown |  |
| twitter_post_click_follow_click_advanced | Unknown |  |
| twitter_post_click_hashtag_click_advanced | Unknown |  |
| twitter_post_click_media_click_advanced | Unknown |  |
| twitter_post_click_permalink_click_advanced | Unknown |  |
| twitter_post_click_profile_click_advanced | Unknown |  |
| twitter_post_click_url_click_advanced | Unknown |  |
| twitter_post_impression_advanced | Unknown |  |
| twitter_post_like | Unknown |  |
| twitter_post_like_advanced | Unknown |  |
| twitter_post_native_retweet | Unknown |  |
| twitter_post_native_retweet_audience | Unknown |  |
| twitter_post_reach_advanced | Unknown |  |
| twitter_post_reply | Unknown |  |
| twitter_post_reply_advanced | Unknown |  |
| twitter_post_retweet_advanced | Unknown |  |
| twitter_post_retweet_quoted_advanced | Unknown |  |
| twitter_post_retweet_unquoted_advanced | Unknown |  |
| twitter_post_unlike_advanced | Unknown |  |
| twitter_post_unreply_advanced | Unknown |  |
| twitter_post_unretweet_advanced | Unknown |  |
| twitter_post_video_start_advanced | Unknown |  |
| twitter_post_video_view_25_percent_advanced | Unknown |  |
| twitter_post_video_view_50_percent_advanced | Unknown |  |
| twitter_post_video_view_75_percent_advanced | Unknown |  |
| twitter_post_video_view_95_percent_advanced | Unknown |  |
| twitter_post_video_view_advanced | Unknown |  |
| twitter_post_video_view_complete_advanced | Unknown |  |
| user_email | Unknown |  |
| user_id | Unknown |  |
| users | Unknown |  |
| vk_post_comment | Unknown |  |
| vk_post_like | Unknown |  |
| vk_post_repost | Unknown |  |
| web_analytics_bounce_from_social | Unknown |  |
| web_analytics_conversion_from_social | Unknown |  |
| web_analytics_conversion_value_from_social | Unknown |  |
| web_analytics_new_visitor_from_social | Unknown |  |
| web_analytics_page_view_from_social | Unknown |  |
| web_analytics_visit_from_social | Unknown |  |
| youtube_post_comment | Unknown |  |
| youtube_post_dislike | Unknown |  |
| youtube_post_like | Unknown |  |
| youtube_post_video_view | Unknown |  |

## Relationships

- account(channel) → profile(channel)
- stream_item_data(channel_profile_id) → profile(channel_profile_id)
- stream_item_data(channel) → profile(channel)
- stream_item_action(channel_profile_id) → profile(channel_profile_id)
- stream_item_action(channel) → profile(channel)
- stream_item_action(stream_item_id) → stream_item_data(stream_item_id)
- daily_summary(channel) → profile(channel)
- ad_net_value(channel) → profile(channel)
- published_post(channel) → profile(channel)