What a freelance client pipeline should answer
A pipeline is a view of potential work from the first inquiry to a decision. For a freelancer, it should answer three questions: what is the client deciding, what needs to happen next and when will you review it? A contact list answers who someone is. A pipeline adds the current commercial conversation. Keep delivery tasks separate once the sale is agreed so an active project is not confused with an undecided proposal.
Start with a small set of stages
Choose stages that reflect a change in the client decision, not every task you perform. The following is a suggested manual workflow; these labels are not a claim about every default stage in LeadPilot. If your CRM already has equivalent labels, use those rather than rebuilding the board.
- New inquiry: a request arrived and still needs a first review.
- Discovery: you are clarifying the outcome, fit, budget or approval process.
- Proposal: a specific scope and fee have been sent for review.
- Decision pending: the proposal is under review and there is an agreed next step or date.
- Won: the client has agreed to proceed; record contract and payment actions separately.
- Lost or paused: the opportunity is closed for now, with a reason or a future review date if known.
The essential fields for a freelance lead tracker
Start with the smallest record that allows you to act. The next action and its date matter more than filling every optional field. If you use a spreadsheet, use one row per opportunity and keep the column headings consistent. The example here is a planning layout, not an import-ready CSV.
- Client or company, contact name and contact channel.
- Service requested and a short description of the desired outcome.
- Stage and source, such as referral or website inquiry.
- Proposed fee and currency, kept separate from money actually received.
- Last contact date, next action and next contact date.
- Proposal reference and decision notes, including missing information.
Worked example: a landing-page design inquiry
This fictional example shows how the next action changes while the opportunity moves through the pipeline. The fee is illustrative and is not a pricing recommendation. Notice that “proposal sent” does not mean “money received”.
Client: Example Studio Service: Landing-page design Proposed fee: USD 800 (illustrative) Source: Referral Monday — New inquiry Next action: Ask who approves the design and confirm the desired launch date. Wednesday — Discovery Next action: Confirm deliverables and revision limits before preparing the proposal. Friday — Proposal Next action: Send the reviewed proposal and agree on a decision date. Following Wednesday — Decision pending Next action: Answer the client's scope question and confirm the review date. After approval — Won Next action: Complete the separate contract, payment and kickoff steps.
Run a short review before adding more fields
Review your open opportunities on a regular day that fits your workload. Start with overdue next actions, then proposals waiting for a decision and inquiries missing basic information. Give each active record a concrete next step. If there is no reason to contact the client again, close or pause the opportunity instead of leaving it permanently in an open stage.
- Check whether the stage still matches the latest conversation.
- Replace vague actions such as “follow up” with the actual question to ask.
- Check overdue dates against the client's agreed timeline.
- Keep declined work out of the active forecast.
- Review currencies separately and avoid treating estimated fees as cash.
When to keep a spreadsheet and when to use a CRM
A spreadsheet can be enough when you have a small number of inquiries, one person maintains it and review dates are reliable. Consider a CRM when you repeatedly search for proposal versions, lose conversation context or need dated tasks beside each client. More software is not automatically better: first check whether the current process has a next-action habit.
Set up the workflow in LeadPilot
Try the sample pipeline first. In your own workspace, add or import reviewed contacts, choose the pipeline stages available in your plan and set next contact dates. Add a proposal when the scope is clear. Free includes one pipeline, 25 active deals and one workspace user; see current pricing before relying on more capacity. Send messages through your own communication tools and keep a full backup as well as any contact CSV.
Compare the manual tracker with LeadPilot's sales pipeline and deal tracking, or review the Free CRM plan for freelancers before importing contacts.
Does every lead need an estimated value?
No. An inquiry may be too early to price. Record what is known, clarify the scope and add a fee when it is meaningful. A large number entered without evidence makes the board look busy without helping you decide what to do. The most useful early field is often the next question you need answered.
Download a working tracker or a LeadPilot import sample
The planning tracker is a CSV you can open in a spreadsheet app. Its USD 1,200 design proposal is a separate fictional sample from the USD 800 inquiry above; neither fee is a pricing recommendation. It has three clearly marked fictional opportunities, proposed fees, next actions and proposal references. Dates are blank so you can set a schedule that reflects a real agreement. Replace or remove the sample rows before using it for your own work. A blank proposed fee means not yet estimated, not a free project.
- Planning tracker: use one row per opportunity; fill in the next action and next contact date during your review.
- Import sample: a separate CSV uses the exact LeadPilot field names. The planning tracker itself is not an import file.
- All names, projects and example.com addresses are fictional. Neither download sends messages or creates records by itself.
- These are CSV files, not full workbooks: they contain no formulas, formatting, automatic reminders or external connections.
Preview the sample import before saving anything
First try the import-compatible file in the public demo, whose changes reset on reload. Open Clients, choose Import and inspect the three SAMPLE records before confirming. For real work, copy the file, replace the sample details and keep your original spreadsheet. Review the status, budget, currency and notes in the import preview; then confirm only the intended records.
- The sample uses New, Qualified and Proposal sent, with Low or Medium priority and USD example budgets. Match stages to the pipeline you use.
- follow_up is blank. Add a real YYYY-MM-DD date only when you have chosen the next contact date.
- A blank budget imports as 0 in LeadPilot; it is a placeholder, not an agreed quote. The sample notes explicitly mark the unknown amount.
- The contact CSV does not import a proposal document, its acceptance, or a payment. LP-EXAMPLE-01 in notes is only a reference to the separate PDF example.
- Repeat imports may skip matching company, email and service records. Review the preview instead of importing again to repair an unexplained difference.