Khoros Marketing

Explore the interactive ERD

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