mirror of
https://github.com/discourse/discourse.git
synced 2026-08-06 13:08:40 +08:00
539eff3f93This PR adds two KPI tiles to the Traffic section — bounce rate and average session duration — measured per browsing session as real engaged time: the seconds a tab is both visible and focused. It builds on the per-session engagement core already captures (`browser_pageview_session_engagements`), so the only new table is its daily summary `browser_pageview_session_engagement_daily_rollups` — additive, no existing schema changes. Key technical changes: 1. Reuse core's capture. Engaged time is already recorded per session by core's `human-activity-tracker` → `/srv/se` beacon → `browser_pageview_session_engagements`; this PR adds no second tracker, endpoint, table, or site setting. 2. Key engagement capture on `persist_browser_pageview_events` alone. `Middleware::RequestTracker#is_engagement_tracking_request?` and the `discourse-engagement-tracking-enabled` meta tag no longer also require the `dashboard_improvements` upcoming change, so engagement is captured wherever pageview events are persisted rather than only where the redesigned dashboard is enabled. 3. Pre-compute in a scheduled job. The existing `Jobs::MaintainBrowserPageviewRollups` job, which already maintains the country and referrer rollups on the same cadence and setting gate, now also rolls sessions into `browser_pageview_session_engagement_daily_rollups`, one row per `(date, logged_in)`, so the dashboard reads this small summary instead of scanning raw events. A session is bounced when it has a single pageview and under ten engaged seconds (no engagement counts as zero). Sessions that started within the last ten minutes are held out of aggregation until a later run, so a live session is not counted as a zero-engagement bounce before the client's first engagement flush (three minutes in) has arrived. Engagement rolls up only from the first engagement row's date forward, because pageview rows predate this feature and have no engagement data — counting them would make all of history look like instant bounces. 4. Show the tiles only when there's data. They render when `persist_browser_pageview_events` is on, alongside the existing Direct traffic KPI, with a neutral placeholder until the first visits are recorded; duration is formatted as `Xm Ys`. |
||
|---|---|---|
| .. | ||
| access_control_list_fabricator.rb | ||
| admin_notice_fabricator.rb | ||
| allowed_pm_users.rb | ||
| api_key_fabricator.rb | ||
| api_key_scope_fabricator.rb | ||
| application_request_fabricator.rb | ||
| associated_group_fabricator.rb | ||
| badge_fabricator.rb | ||
| bookmark_fabricator.rb | ||
| browser_pageview_event_fabricator.rb | ||
| browser_pageview_session_engagement_daily_rollup_fabricator.rb | ||
| browser_pageview_session_engagement_fabricator.rb | ||
| category_fabricator.rb | ||
| category_group_fabricator.rb | ||
| category_localization_fabricator.rb | ||
| category_moderation_group_fabricator.rb | ||
| color_scheme_color_fabricator.rb | ||
| color_scheme_fabricator.rb | ||
| custom_emoji_fabricator.rb | ||
| dimissed_topic_user.rb | ||
| do_not_disturb_fabricator.rb | ||
| draft_fabricator.rb | ||
| email_change_request_fabricator.rb | ||
| email_log_fabricator.rb | ||
| email_token_fabricator.rb | ||
| embeddable_host_fabricator.rb | ||
| embeddable_host_tag_fabricator.rb | ||
| external_upload_stub_fabricator.rb | ||
| flag_fabricator.rb | ||
| flag_post_action_fabricator.rb | ||
| form_template_fabricator.rb | ||
| group_fabricator.rb | ||
| group_history_fabricator.rb | ||
| group_request_fabricator.rb | ||
| group_user_fabricator.rb | ||
| ignored_user_fabricator.rb | ||
| incoming_email_fabricator.rb | ||
| incoming_link_fabricator.rb | ||
| invite_fabricator.rb | ||
| invited_user_fabricator.rb | ||
| like_fabricator.rb | ||
| moved_post_fabricator.rb | ||
| muted_user.rb | ||
| nested_topic_fabricator.rb | ||
| notification_fabricator.rb | ||
| optimized_image_fabricator.rb | ||
| optimized_video_fabricator.rb | ||
| permalink_fabricator.rb | ||
| post_action_fabricator.rb | ||
| post_custom_field_fabricator.rb | ||
| post_detail_fabricator.rb | ||
| post_fabricator.rb | ||
| post_localization_fabricator.rb | ||
| post_reply_key_fabricator.rb | ||
| post_revision_fabricator.rb | ||
| problem_check_tracker_fabricator.rb | ||
| published_page_fabricator.rb | ||
| push_subscription_fabricator.rb | ||
| redelivering_webhook_event_fabricator.rb | ||
| reviewable_claimed_topic_fabricator.rb | ||
| reviewable_fabricator.rb | ||
| reviewable_note_fabricator.rb | ||
| reviewable_score_fabricator.rb | ||
| screened_email_fabricator.rb | ||
| screened_ip_address_fabricator.rb | ||
| screened_url_fabricator.rb | ||
| search_log_fabricator.rb | ||
| shared_draft_fabricator.rb | ||
| sidebar_section_fabricator.rb | ||
| sidebar_section_link_fabricator.rb | ||
| sidebar_url_fabricator.rb | ||
| single_sign_on_record_fabricator.rb | ||
| site_setting_group_fabricator.rb | ||
| skipped_email_log_fabricator.rb | ||
| tag_fabricator.rb | ||
| tag_group_fabricator.rb | ||
| tag_group_permission_fabricator.rb | ||
| tag_localization_fabricator.rb | ||
| tag_user_fabricator.rb | ||
| theme_fabricator.rb | ||
| theme_field_fabricator.rb | ||
| theme_settings_migration_fabricator.rb | ||
| theme_site_setting_fabricator.rb | ||
| topic_allowed_group_fabricator.rb | ||
| topic_allowed_user_fabricator.rb | ||
| topic_embed_fabricator.rb | ||
| topic_fabricator.rb | ||
| topic_link_click_fabricator.rb | ||
| topic_link_fabricator.rb | ||
| topic_localization_fabricator.rb | ||
| topic_tag_fabricator.rb | ||
| topic_timer_fabricator.rb | ||
| topic_user_fabricator.rb | ||
| topic_view_stat_fabricator.rb | ||
| translation_override_fabricator.rb | ||
| upload_fabricator.rb | ||
| user_action_fabricator.rb | ||
| user_api_key_fabricator.rb | ||
| user_associated_account_fabricator.rb | ||
| user_avatar_fabricator.rb | ||
| user_badge_fabricator.rb | ||
| user_custom_field_fabricator.rb | ||
| user_email_fabricator.rb | ||
| user_fabricator.rb | ||
| user_field_fabricator.rb | ||
| user_field_option_fabricator.rb.rb | ||
| user_history_fabricator.rb | ||
| user_option_fabricator.rb | ||
| user_password_fabricator.rb | ||
| user_profile_fabricator.rb | ||
| user_second_factor_fabricator.rb | ||
| user_security_key_fabricator.rb | ||
| user_status_fabricator.rb | ||
| user_visit_fabricator.rb | ||
| watched_word_fabricator.rb | ||
| watched_word_group_fabricator.rb | ||
| web_crawler_request_fabricator.rb | ||
| web_hook_event_fabricator.rb | ||
| web_hook_fabricator.rb | ||
