0
0
Fork 0
mirror of https://github.com/discourse/discourse.git synced 2026-08-05 15:18:34 +08:00
discourse/db/post_migrate
Krzysztof Kotlarek bf8d011bdd
FEATURE: Reclassify likely crawlers in site traffic reporting (#42199)
Previously, CrawlerScorer wrote a score to every browser pageview event,
but nothing consumed it, so the site traffic chart still counted
automated sessions as logged-in or anonymous humans and overstated
community traffic.

Classify events scoring above CrawlerScorer::BOT_SCORE_THRESHOLD, as
likely crawlers. Their daily counts are rolled up per logged-in state
into a new browser_pageview_crawler_daily_rollups table, subtracted from
the logged-in and anonymous series, and shown as their own "Likely
crawlers" series ahead of the known-crawler one.

All of this sits behind the new improved_crawler_detection upcoming
change, which also replaces experimental_detect_crawler_pageviews as the
gate on scoring. The rollup job backfills all existing history on its
first run, then refreshes yesterday and today. Disabling the change
restores the original counters and hides the series while leaving the
rollups in place, so re-enabling takes effect without a backfill.

<img width="993" height="755" alt="Screenshot 2026-07-31 at 12 22 13 pm"
src="https://github.com/user-attachments/assets/6163b731-c2ba-4e53-8cc7-4eba78f4190d"
/>
2026-08-04 10:08:53 +08:00
..
20260112082200_drop_reviewable_action_logs.rb
20260311064518_clean_existing_tag_localization_names.rb FIX: Clean localized tag names (#38488) 2026-03-12 12:54:50 +08:00
20260319054730_delete_redundant_everyone_posting_review_groups.rb FEATURE: Support group based category posting review modes (#38707) 2026-04-07 10:41:16 +08:00
20260319054731_drop_permission_from_category_posting_review_groups.rb FEATURE: Support group based category posting review modes (#38707) 2026-04-07 10:41:16 +08:00
20260330161714_drop_pinned_post_number_from_nested_topics.rb FEATURE: First iteration of nested replies (#38888) 2026-04-16 08:06:44 -05:00
20260422135650_strip_upload_label_escapes.rb FIX: Prevent backslash accumulation in upload markdown labels (#39461) 2026-06-03 18:10:38 +02:00
20260512061336_convert_reporting_improvements_everyone_to_staff.rb UX: Allow more specific enabled for options for upcoming changes (#39916) 2026-05-13 10:22:06 +10:00
20260601043020_rename_anonymous_auto_group_to_anonymous_users.rb DEV: Rename anonymous group to anonymous_users (#40435) 2026-06-02 09:29:46 +10:00
20260602104726_recalculate_topic_counters_without_small_actions.rb FEATURE: Exclude small actions from topic counters and unread tracking (#40481) 2026-06-08 08:03:55 +02:00
20260603115312_remove_admin_dashboard_sections_setting.rb DEV: Persist dashboard configuration in table and *not* on closure of the dialog (#40546) 2026-06-04 10:53:59 +08:00
20260607161322_move_unified_new_setting_from_groups.rb FEATURE: Add upcoming change for unified new view (#40631) 2026-06-09 11:34:22 +10:00
20260624140945_ensure_unique_flag_name_keys.rb FIX: Ensure each flag gets a unique name_key (#40899) 2026-06-24 16:37:59 +02:00
20260629081606_remove_reporting_improvements_setting.rb DEV: Remove reporting_improvements upcoming change (#41259) 2026-07-01 07:52:02 +08:00
20260702102111_remove_create_revision_on_bulk_topic_moves_setting.rb FIX: Record bulk tag and category changes as their own revision (#41364) 2026-07-02 16:51:57 +02:00
20260707184150_backfill_push_notification_level.rb UX: Consolidate chat notifications into live notification preferences (#41538) 2026-07-14 08:32:48 +02:00
20260721122254_remove_rich_editor_setting.rb DEV: Remove rich_editor site setting (#41873) 2026-07-23 19:49:20 -03:00
20260728050038_remove_experimental_detect_crawler_pageviews_setting.rb FEATURE: Reclassify likely crawlers in site traffic reporting (#42199) 2026-08-04 10:08:53 +08:00
20260728162521_backfill_send_shortcut.rb FEATURE: Make the message send shortcut a core user option (#42105) 2026-07-28 13:58:12 -07:00