Prospect Flow Dashboard

Added today

—

— vs yesterday

This week

—

— vs prior 7 days

ICP qualified

—

— of — in range

Active pipeline

—

— open opportunities

Avg ICP score

—

All prospects in range

Range

Source

Last refresh: —

Top of funnel

Daily prospect intake

Total prospects added per day, all sources.

Channel mix

Prospects by source

Where the flow is coming from.

Conversion path

Pipeline by stage

Where prospects sit right now, and where they're stuck.

By source

Channel performance

Which channels are producing real pipeline.

Source	Prospects	ICP qualified	Avg score	In pipeline	Won	Win rate

Latest activity

Recent additions

The newest 25 prospects in the master feed.

Date	Company	Contact	Source	Score	Stage	Signal

Column	Type	Allowed values
Date added	Date	YYYY-MM-DD or any date format Google Sheets understands
Company	Text	—
Contact name	Text	—
Contact title	Text	—
Email	Text	—
Segment	Text	A, B, C
Source	Text	LinkedIn Jobs, Apollo, Upwork, Fiverr, Community, Referral, Content, Direct, Other
ICP score	Number	0–100
Signal	Text	e.g. "Hiring ServiceNow Admin", "Intent on G2"
Stage	Text	New, Contacted, Engaged, Replied, Meeting, Opportunity, Won, Lost
Owner	Text	—
Pipeline value	Number	USD, numeric only
Notes	Text	—

Scoring guide

One simple, defensible model — total to 100. ICP qualified = score ≥ 60.

Firmographic fit — 40 points. Right size (50–1,000), right industry, right geography.
Signal strength — 40 points. Active job posting = 40, intent < 30 days = 25, Partner Finder = 20, database only = 5.
Role match — 20 points. Decision-maker = 20, influencer = 10, junior = 0.

Need a starter CSV with these columns and 5 example rows? Download template.

Daily prospect intake

Prospects by source

Pipeline by stage

Channel performance

Recent additions

Connect your master feed

Get the CSV URL from Google Sheets

Hosting

Master feed schema

Scoring guide