WordPress relevance report: work so far

A compact status page for the report package: what has been built, what evidence is now stored in SQLite, how the Evidence Map supports decisions, and which source areas still need fuller historical exports.

SQLite tables

108

current report database

Decision rows

8

stored in decision_question_evidence

Imported files

20

tracked with SHA-256 hashes

Partial source areas

5

explicitly listed in source_gaps

Integrity

ok

SQLite PRAGMA integrity_check

Built So Far

Foundation
Ticket and issue history

Loaded Core Trac, Gutenberg issues, wordpress-develop PRs, status flow, reporters, labels, and classification tables into SQLite.

Participation
Quarterly community flow

Built quarterly views for new and closed work, first-time and repeat reporters, newcomer return cohorts, PR authors, maintainer split, contributor depth, and concentration.

Project load
Backlog and maintenance shape

Added open backlog, age buckets, category mix, response time, close time, reopened events, and closure-flow visuals.

Market
Adoption and builder context

Added W3Techs, HTTP Archive, BuiltWith, traffic-tier, new-site proxy, WooCommerce, and enterprise-adoption signals.

Ecosystem
Activity outside trackers

Added release credits, committers, Make/Core posts and comments, WordCamps, Events, Translate, Five for the Future, support snapshots, archived support-view estimates, plugin, and theme sources.

Demand
Developer and search proxies

Added Stack Overflow, Wikimedia, autocomplete query intent, npm, Packagist, GitHub topic search, HN hiring, Remote OK, Remotive, and annual plus quarterly WordPress Jobs signals.

Decision evidence
Evidence map

Added a SQLite-backed decision_question_evidence table and visual Evidence Map so each decision answer is labeled as direct, mixed, or proxy-backed.

Packaging
Refreshable report set

Generated focused companion pages, a data inventory, source gap plan, goal audit, refresh validation, and a compressed SQLite download.

Stored Evidence Scale

Representative row counts from the SQLite database. The full inventory is in data_inventory.html.

Core tickets65k rows
Gutenberg issues32k rows
wordpress-develop PRs12k rows
Classified quarter rows716 rows
Make/Core comments34k rows
WordCamp records1,458 rows
Support topics sampled1,315 rows
Support archive rows135 rows
Plugin sample rows13k rows
Theme sample rows900 rows
Decision evidence rows8 rows

Report Surfaces

Main report Three-view decision report with scorecard, Evidence Map, participation, project load, and market position. Evidence Map Decision questions labeled as direct, mixed, or proxy-backed evidence. Decision brief Short shareable readout with the same Evidence Map. Project load Backlog, closures, category mix, response, and close-time views. Market position Installed share, tracked share, new-site proxy, and demand signals. New-site choice Builder comparison and newly found-site proxy. Ecosystem activity Non-ticket activity: releases, Make/Core, events, support, support archive estimates, plugins, and themes. Developer interest Help-seeking, package use, GitHub topic breadth, and code review. Source gap plan What remains partial and which source family would improve it next. Data inventory SQLite tables, source hashes, row counts, and downloadable database.

Still Partial

These are not blockers for the current readout, but they are the areas where a fuller external source would improve the next revision.

Developer Interest Proxy Quarterly Stack Overflow tag volume, Wikimedia pageviews, npm @wordpress package downloads, Packagist Composer package snapshots, wordpress-develop PR and line review-comment activity, GitHub repository interest and topic-search snapshots, and a compact attention/demand summary are included as public attention and contribution proxies; they do not measure general search-query interest.
partial
Job Demand HN Who is hiring WordPress/WooCommerce, PHP, and agency/studio mention counts, Remote OK and Remotive current remote-job term counts, annual and quarterly WordPress Jobs board open-listing snapshots, a compact proxy-direction summary, and a job-demand companion view are included; broader multi-year labor-market demand still needs a hiring-platform time series.
partial
New Site Share History Current report includes BuiltWith current Net New Pipeline, HTTP Archive monthly origin counts, quarterly derived tracked-share history, builder momentum summaries, rank-tier detected-origin adoption, a compact new-site choice summary, and a dedicated new-site choice companion view; not a multi-year newly created site cohort.
partial
Search Interest Wikimedia Pageviews API quarterly article-view trends, Stack Overflow tag-volume context, a current Google autocomplete suggestion snapshot, a compact attention/demand summary, and a search-interest companion view are included as public-interest and query-intent proxies; true search-volume history still needs Google Trends or another search provider.
partial
Support Forum History Current report includes public support queue snapshots, quarterly Internet Archive support-view estimates from 2018 onward, resolved/unresolved/no-reply summaries, last-activity buckets, forum-level unanswered summaries, a support-load companion view, and major-plugin support-thread totals; not a full long-term topic/reply history.
partial

Generated from community_health.sqlite. Main report: index.html. Refresh command: python3 refresh_report_artifacts.py --skip-main-report --allow-low-disk.