[v2] Topic Analytics for Curated Tree Prioritization

[nicholaspsmith]

Overview

Track what topics users are learning to prioritize creating curated skill trees.

Part of

Memoryloop v2 Pivot - Branch 014-goal-based-learning

Analytics Tracked

• Normalized topic names (lowercase, trimmed)
• User count per topic
• Total cards generated per topic
• Average retention rate per topic
• Explicit curation requests

Database

topic_analytics table

• id (uuid)
• normalizedTopic (varchar, unique)
• userCount (integer)
• totalCards (integer)
• avgRetention (float)
• requestedCuration (boolean)
• firstSeen, lastSeen (timestamps)

API Endpoints

• GET /api/analytics/topics - List top topics (admin)
• POST /api/analytics/topics/request-curation - User requests curated tree

Admin Dashboard (future)

• Top 10 topics by user count
• Topics with curation requests
• One-click to create GitHub issue for curation

Topic Normalization

• Lowercase
• Trim whitespace
• Remove common prefixes ("learn ", "study ", "master ")
• Consider fuzzy matching for similar topics

Acceptance Criteria

• Topics tracked when goals created
• Analytics aggregated correctly
• Top 10 surfaced monthly (SC-009)
• Users can request curation for their topic

Dependencies

• Issue [v2] Database Schema: Learning Goals and Skill Trees #220 (Database Schema)
• Issue [v2] Goal Creation and Skill Tree Generation #221 (Goal Creation)

Related Spec

See specs/014-goal-based-learning/spec.md - User Story 6