Content Idea Pipeline & Scorer

The problem this kills

Content ideas come from everywhere - a Slack thread, a sticky note on your monitor, a "can we write about this?" from sales, a half-remembered comment in a meeting. They pile up in five different places, nothing gets compared on the same terms, and the calendar ends up filled with whatever was loudest or most recent instead of what's actually worth doing.

Content managers and marketing ops people drown in this. You become the human filing cabinet, re-typing ideas into a master spreadsheet, trying to remember whether someone already pitched "a guide to onboarding emails" three weeks ago, and quietly guessing which ideas deserve a slot. The good ideas get buried; the same idea gets logged twice; the calendar fills with filler.

This tool ends that. Every idea enters one front door. Each one is scored on the same factors - strategic fit, effort, and search potential - so the backlog ranks itself best-first. Near-duplicates get caught before they clutter the list. And nothing moves into "planned" until your content lead reviews the score, says yes, and assigns an owner.

What you'll build

A small, private web app for your team:

• A one-door idea intake form where anyone submits a topic, audience, format, and target keyword - no more scattered sources.
• Automatic scoring on strategic fit, effort, and search potential, rolled into a single rank - with the scoring weights you choose, so it reflects your strategy.
• A ranked backlog that sorts itself best-first, so the strongest ideas rise to the top automatically.
• A near-duplicate guard that flags when a new idea looks a lot like one already in the backlog, before it gets logged twice.
• An approval gate where the content lead promotes a scored idea from "backlog" to "planned," assigns an owner, and only then does it count as committed work.
• A CSV export of the planned ideas in the exact columns your editorial calendar expects - so this is useful today, even with zero integrations.

What's inside the Implementation Plan

The plan is a complete, paste-and-go runbook for Claude Code. You don't write code - you paste, answer questions, and approve.

It opens by interviewing you about your business - where your ideas come from today, the systems and spreadsheets you use, your real content formats and audience names, your keyword and topic list, how you actually judge an idea, how heavily you want to weight fit vs. effort vs. search potential, your typical and peak idea volume, and the messy edge cases (seasonal ideas, evergreen vs. timely, ideas with no keyword yet). It reflects a short tailored spec back to you and waits for your thumbs-up before building anything. The result is a tool shaped around how you actually work - not a generic template.

From there it walks you step by step: database, login, the intake form, the scoring engine with your weights, the near-duplicate guard, the AI scoring assist, the ranked backlog, the approval-and-assign gate, email notifications, and the CSV export - each step ending in a ready-to-copy prompt.

The governance it includes (this is the point)

This isn't a toy form. Every runbookify plan builds in the controls that make a tool safe for real work:

• Login so only your team can see or submit ideas.
• Row-level security so people only ever see their own organization's ideas.
• A complete audit trail - who submitted, how it scored, who promoted it, who it was assigned to, and exactly when.
• A hard human-in-the-loop approval gate - scoring drafts a rank, but a person reviews and approves before an idea becomes planned, committed work.
• Duplicate guards so the same idea (matched on its normalized topic/title) can't be logged twice.

Who it's for

Content managers and marketing ops teams drowning in idea sources - Slack messages, sticky notes, sales requests, exec wishes - who want one ranked backlog and a clear, defensible way to decide what actually gets made. If you can fill out a form and read a spreadsheet, you can build this.

You've got this - paste the first prompt and let the interview tailor it to your team.