Content Flywheel: Feedback to Fresh Ideas

The flywheel turns customer/audience feedback into content ideas that never repeat. It gets smarter with each run because it maintains a persistent tracker.

Customer Feedback → Theme Analysis → Content Ideas → Tracker Update
       ↑                                                    │
       └────────────────────────────────────────────────────┘

/analyze Command

Purpose: Categorize raw customer feedback into actionable themes.

Input Sources

• Google Sheet, CSV, survey responses, community posts, support tickets, onboarding questionnaires

Output Format

FEEDBACK ANALYSIS — [Source Name]
─────────────────────────────────
Total entries analyzed: [count]

THEME RANKINGS:
Rank | Theme | Frequency | % of Total | Key Phrases Used
1    | [theme] | [count] | [%] | "[exact customer words]"

NOTABLE QUOTES:
- "[verbatim customer quote]" — re: [theme]

/flywheel Command

Purpose: Generate fresh content ideas based on analyzed themes, deduped against the tracker.

Idea Generation Rules

• Ideas must be rooted in actual customer language/pain points
• Each idea needs: topic, format, angle, and which theme it serves
• Check every idea against the tracker — if a substantially similar idea exists, skip it
• Prioritize themes with highest frequency but lowest existing coverage

Output Format

CONTENT FLYWHEEL — Run [date]
──────────────────────────────
EMAIL NEWSLETTER IDEAS:
1. Topic: [topic] | Theme: [theme] | Angle: [angle]

YOUTUBE VIDEO IDEAS:
1. Topic: [topic] | Theme: [theme] | Format: [tutorial/commentary] | Angle: [angle]

SOCIAL MEDIA IDEAS:
1. Topic: [topic] | Platform: [platform] | Theme: [theme] | Format: [carousel/thread/reel]

NEW IDEAS GENERATED: [count]
DUPLICATES AVOIDED: [count]

Defaults: 5 email, 5 YouTube, 10 social, 5 community ideas per run.

/track Command

Purpose: Manage the content recommendations tracker.

Tracker File: content-tracker.md

# Content Tracker
Last updated: [date]
Total ideas tracked: [count]

## Generated Ideas
| Date | Channel | Topic | Theme | Status |
|------|---------|-------|-------|--------|
| [date] | Email | [topic] | [theme] | new/used/skipped |

Track Operations

• Add: After each /flywheel run, new ideas auto-append
• Mark used: track [topic] as used — moves idea to Used section
• Status check: track status — shows ideas per channel, used vs unused
• Clean: track clean — archive ideas older than 90 days

Rules

1. NEVER generate a content idea that substantially duplicates something in the tracker
2. Always use actual customer language in ideas, not marketing jargon
3. The tracker file is the single source of truth
4. Theme ranking drives idea priority
5. Every /flywheel run MUST update the tracker automatically
6. If no feedback data is available, ask for it

Anti-Patterns

• Don't generate generic content ideas disconnected from actual feedback
• Don't skip the tracker check — duplication is the #1 failure mode
• Don't overweight old themes — rerun /analyze with fresh data regularly
• Don't mark ideas as "used" automatically — only the user decides what got published

#content-sop #content-strategy #flywheel #ideation