From Prospect Table to Active Pipeline

A prospect table tracks what you’ve found. A pipeline tracks what you’re doing about it. The transition from one to the other is where prospecting becomes strategy — where researched funders turn into active pursuits with timelines, owners, and expected outcomes.

What Makes a Pipeline Different From a List

A list of qualified funders is static. It tells you who’s a good match but not what to do next. A pipeline is dynamic — it reflects your current commitments, tracks progress through stages, and shows where your team’s effort is going.

Stage awareness

Every opportunity in your pipeline has a status: researching, LOI in progress, full proposal drafting, submitted, awaiting decision. You can see at a glance where everything stands.

Timeline management

Deadlines, submission windows, expected decision dates — the pipeline connects your prospects to the calendar.

Capacity planning

If you have three proposals due in the same month and the staff to handle two, the pipeline makes that visible before it becomes a crisis.

Revenue forecasting

Even rough estimates of grant amounts and win probability let you forecast incoming funding — essential for organizational planning.

Moving Prospects Into the Pipeline

Not every qualified prospect becomes a pipeline entry immediately. The transition happens when you commit resources — even if those resources are just “we’re going to write the LOI next month.”

Confirmed go decision

The go/no-go framework from the previous module is the gateway. A prospect enters the pipeline when someone has said 'yes, we're pursuing this.'

Assigned ownership

Someone is responsible for this opportunity. If it's unassigned, it's still a prospect, not a pipeline item.

Defined next action

What happens next? Write the LOI. Request the application. Schedule a call with the program officer. A pipeline item without a next action is an orphan.

Estimated timeline

When does the next action happen? When is the deadline? When do you expect a decision? These dates make the pipeline plannable.

Pro tip

The cleanest rule: a prospect becomes a pipeline item when it has an owner and a next action with a date. Until then, it stays in the prospect table.

Pipeline Stages

Keep your stages simple and meaningful. Every additional stage adds maintenance burden — only create stages that represent real transitions in your workflow.

A practical set for most grant teams:

Researching — You’ve committed to investigating this funder further. Active evaluation is underway.

LOI / Pre-Application — A letter of inquiry, concept paper, or pre-application is in progress.

Full Proposal — You’re writing or have submitted a full proposal.

Submitted — Application is with the funder. You’re waiting.

Decision Received — Awarded, declined, or asked to revise.

A pipeline with five clear stages beats one with twelve granular stages that nobody maintains. The test: can your whole team tell you the current stage of every active opportunity without checking the pipeline? If not, simplify.

The Pipeline as Strategic Tool

Beyond tracking individual opportunities, the pipeline reveals strategic patterns:

Concentration risk. If 60% of your pipeline value is with one funder, you’re exposed. The pipeline makes this visible.
Seasonal bottlenecks. If every deadline falls in March and September, you can plan for those crunch periods or shift your prospecting to find funders with different cycles.
Program area gaps. Your organization runs five programs but your pipeline only has funders for two. That’s a strategic gap the pipeline can surface.

In Grantable

In Grantable, the pipeline isn’t a separate system — it’s a dashboard view of the files and folders in your workspace. When you move a prospect into your /Applications folder and the AI sets the status, funder, and due date as metadata, it appears on your dashboard automatically. You can view your pipeline as a sortable list, a kanban board by status, or a calendar by deadline. You can update any field inline, or tell the AI in conversation — “mark the Smith Foundation as submitted.” The pipeline connects directly to the documents you’re drafting because they’re the same files. For a deeper look at how the dashboard works, see Pipeline Analytics in Track E.

Check your understanding

You have a prospect table with 25 qualified funders and a pipeline with 8 active opportunities. Three more prospects have strong fit scores but no assigned owner or next action. Where do those three belong?

Key Takeaways

A pipeline tracks active commitments — prospects with owners, next actions, and timelines
Prospects transition to pipeline items when someone says 'go' and takes responsibility
Keep stages simple — five clear stages beats twelve granular ones nobody maintains
Use the pipeline strategically: spot concentration risk, seasonal bottlenecks, and program area gaps

Next Lesson

Your pipeline needs current information to stay useful. Funder monitoring — watching for changes, new RFPs, and shifting priorities — keeps your pipeline alive instead of stale.