leaStudios Help Scout AI Dashboard

leaStudios Help Scout AI Dashboard WordPress plugin that ingests Help Scout AI Beacon CSV exports and renders a unified weekly dashboard of customer interactions across every Beacon in your portfolio. Built for teams running many Beacons who would otherwise be merging spreadsheets by hand. Status: 1.0.0 released. Plugin is functional end-to-end. Requirements | Requirement | Minimum | |---|---| | WordPress | 6.4 | | PHP | 8.2 | | Composer | Any recent | Data model Three custom tables live under {$wpdb-prefix}leastudioshelpscoutaidashboard: | Table | Purpose | Dedupe key | |---|---|---| | interactions | One row per Help Scout AI Beacon Q&A turn. | (sessionid, occurredat) — overlapping CSV exports merge instead of double-counting. | | articlerefs | Normalized article references attached to interactions (typically 1–3 per row). | (interactionid, articleid) — a single article surfaced across many interactions stores metadata once. | | reports | One row per uploaded CSV file (filename, hash, size, row counts, timestamp). | SHA-256 of file contents — re-uploading the same file is a no-op. | The schema version is tracked in option('leastudioshelpscoutaidashboarddbversion') for