Total feedback
—
All normalized rows returned from the current sheet tab.
Piper Operations
Live Google Sheets intelligence over product feedback
Piper Feedback Intelligence
Live operational insights from Piper feedback across teachers, students, and product workflows.
This first pass stays deterministic: it reads sheet rows, normalizes headers, and produces useful heuristics without faking an LLM layer.
Operational workflows
Each action refetches live analysis and focuses the relevant output.
Top feedback type
—
Highest recurring issue category from the analyzed set.
Top severity
—
Most common severity label after normalization.
Average rating
—
Only shown when a numeric rating is present in the source rows.
Top context
—
Most affected page or interaction context from live feedback.
Severity breakdown
Lightweight operational view of issue intensity across the current Piper sheet slice.
Feedback type mix
Top recurring issue themes, useful for triage and backlog shaping.
Momentum heatmap
Most common learning friction moments and requested support types.
Context matrix
Affected screens and routes| Context | Count |
|---|---|
| No context data yet. | |
Operating notes
- Waiting for live feedback analysis.
Results
Operational summary
Total feedback items—
Top feedback type—
Top severity—
Average rating—
Top affected context—
Generated at—
Recent evidence
Latest normalized rows from the Piper sheet. This stays honest: if the source is empty or unavailable, this panel says so.
No evidence loaded yet.
Recommended fix
Affected screen—
User problem—
Proposed UI change—
Expected impact—
Teacher feedback table
Filtered for teacher-like roles| Feedback category | Issue description | Frequency | Severity | Suggested fix |
|---|---|---|---|---|
| No teacher feedback yet. | ||||
Codex patch prompt
A copyable engineering prompt will appear here once live analysis completes.
No prompt available yet.
Trend detection
- No trend data yet.
Action matrix
| Category | Count | Severity pattern |
|---|---|---|
| No matrix yet. | ||
Product experiment
- Hypothesis
- Experiment design
- Success metric
- Expected outcome
Ready for live Piper feedback
Connect the Google Sheet through Netlify environment variables to move from waiting state to real operational intelligence.