Forecasting Next Month Sales From Your Lead Pipeline

The general manager asks a simple question on the 28th: how many used units will we retail next month? The used car manager looks at the lot, thinks about last month, and says a number that is really a mood. Meanwhile the CRM is full of "hot" leads that have not been touched in nine days, Marketplace threads that never became appointments, and a written deal that is still sitting on a lender stipulation. Forecasting next month sales from your lead pipeline is the practice of replacing that mood with a staged count you can defend.

This is not a national conversion rate and not a software vendor's benchmark. Those numbers do not belong in your forecast. You use your own history, conservative stage definitions, and a rule that dead leads are dead. The output is a range, not a slogan.

If your store cannot yet name how many appointments are actually on the calendar for next month, start there. A pipeline forecast built on junk statuses will be precise and wrong.

What Forecasting Next Month Sales From the Pipeline May Claim

A forecast is a statement about deals that already exist in some form, plus a cautious allowance for walk-in and yet-to-be-created demand. It is not a goal. If you need a goal, write a goal. Do not dress a goal up as a forecast.

Three buckets, kept separate

• Booked. Appointments on the calendar, written deals not delivered, and sold-not-funded units you still have to complete.
• Workable. Leads with a recent, real conversation and a vehicle still in stock (or a defined alternative).
• Uncreated. Next month's fresh traffic: walk-ins, new Marketplace messages, phone-ups. This bucket is the most dangerous. Cap it with last month's actual creates, not hope.

Add them only after each bucket has its own haircut. A single blended "we convert 20 percent of leads" number is how small dealers talk themselves into a 40-unit month on a 12-appointment calendar.

What you refuse to count

• Leads with no contact in your chosen inactivity window.
• Duplicate records of the same buyer.
• Inquiries on units that are sold, wholesale, or in recon with no date back.
• Statuses your team uses as junk drawers ("follow-up," "internet," "working it").

If the CRM cannot filter those out, the forecast happens on a spreadsheet you clean by hand until the CRM can. Honesty beats automation here.

Define Stages Before You Multiply Anything

Conversion math is useless if Stage 2 means something different to the BDC and the floor. Write definitions on one page and make the monthly review use them. A related hygiene piece is lead status definitions that keep your pipeline honest.

A workable stage list for a small used department

1. New inquiry. Contact captured, no meaningful conversation yet.
2. In conversation. Two-way contact, vehicle or budget discussed.
3. Appointment set. Date and time on a calendar the store recognizes.
4. Shown. Buyer arrived.
5. Written. Deal structured, not yet delivered.
6. Delivered. Unit gone, deal complete enough that you would not put it back in retail inventory.
7. Lost / dead. Reason code required.

Do not add eight more stages because a CRM template offered them. Extra stages become hiding places.

Required fields that make the forecast possible

• Source (Marketplace, website, phone, walk-in, repeat — as clean as you can keep it).
• Stock number of the primary unit of interest.
• Next appointment date, or an explicit "no appointment."
• Last meaningful contact date.
• Disposition when lost.

Missing stock number is how you forecast sales on cars you do not have.

Haircut Each Stage With Your Own History

You need a few months of your own counts before the math is worth a GM meeting. If you do not have that history yet, forecast only the booked bucket this month and start logging the rest. Do not borrow a rate from another store.

Illustrative math (run it on your numbers)

Consider a lot that, over recent months, has seen roughly this pattern in its own log (illustrative, not a target): a minority of new inquiries become appointments; a majority of shown appointments write; some writes fail to deliver. Whatever your actual fractions are, apply them only to the matching stage.

Example shape, using placeholders you must replace:

• Appointments already set for next month: count them, then multiply by your own show rate, then by your own write rate, then by your own delivery rate.
• In-conversation leads with a contact in the last few days and a live unit: multiply by your own appointment-set rate from that stage, then continue down the chain.
• Fresh-demand allowance: last month's delivered units that did not exist as leads at the start of that month, not a round number you wish were true.

Write the forecast as a range. The low end is booked work after haircuts. The high end adds a capped uncreated bucket. If the GM wants a single number, give the low end and say so.

Do not double-count the month-end push

Month-end pipeline pushes move deals across a calendar line. If you count a written-not-delivered unit in this month's actuals and again in next month's forecast, you will overstate. Delivered is the only unit that belongs in last month. Everything still alive belongs in next month's booked bucket.

Pipeline Hygiene That Makes Next Month's Number Real

Most bad forecasts are hygiene problems, not math problems.

Kill zombies on a schedule

Once a week, anything past your inactivity window with no appointment moves to dead or to a long-term nurture bucket that is not in the sales forecast. Nurture is allowed. Pretending nurture is next month's volume is not. Keep nurture in a bucket that is not in the sales forecast.

One buyer, one primary record

A shopper who messaged three listings is not three deals. Merge or link them before you forecast. If you cannot merge, count unique people in the workable bucket, not unique threads.

Inventory must match the conversation

A lead on a sold truck is not a next-month sale unless you have a named alternative and the buyer agreed to see it. Otherwise it is a lost-with-reason or a new inquiry on a different unit. Forecasting against ghost inventory is how you staff for traffic that will arrive angry.

Appointments need a vehicle readiness check

An appointment on a car that is in recon, unpaid, or missing keys is not a forecast unit. It is a show-rate problem waiting to happen. Verify availability when you set the time, and again the morning of.

A Cadence for Forecasting Next Month Sales From the Pipeline

Do this on a fixed day, not "when we get a minute."

Day 1 of the month (or the first business day)

1. Freeze last month's delivered count.
2. Export appointments dated this month.
3. Export written-not-delivered.
4. Export in-conversation leads with recent contact.
5. Strip sold-unit inquiries, duplicates, and zombies.
6. Apply your trailing haircuts.
7. Write low / high and the three risks (people out, aged mix, lender delays).

Mid-month checkpoint

Do not rebuild the model. Ask only: are we converting booked work, and did uncreated demand show up in line with the cap? If booked work is stalling, the problem is desk, inventory, or response time — not the forecast formula. If you need a related operating metric, appointment set rate from social leads is covered in improving appointment set rate from social Marketplace leads.

What to tell the GM

• Low-end unit count and what would have to be true to beat it.
• How much of the number is already on the calendar.
• The single biggest leak (no-shows, writes that unwind, or no appointments at all).

If the leak is "we do not know," that is the action. Stop forecasting with more decimal places.

How PostToMarket Automates This

A pipeline forecast falls apart when Marketplace conversations never become records, when sold cars stay advertised and keep generating junk inquiries, and when nobody can see which units were even live. PostToMarket does not replace your CRM, and it does not invent conversion rates. It feeds the forecast with cleaner listing and inquiry operations.

Fewer ghost inquiries in the workable bucket

• Mark as sold and archive from inventory or the queue so next month's messages are less likely to be about cars you already delivered.
• Inventory statuses so reps stop promising units that are still draft, failed, or in posting limbo.
• AI-generated titles and descriptions from each vehicle's specs, editable before posting, which cuts the mismatched-ad conversations that never should have entered the pipeline.

A leads picture managers can actually sit with

• A leads inbox for managers, so overnight Marketplace interest is not trapped on one rep's phone when you build the Day-1 forecast.
• Team analytics by rep and source, which is how you stop treating "internet" as one blob in the uncreated-demand cap.
• Per-rep queues and a team queue view so the units in the forecast still have owners on the lot.

Exposure that matches the inventory you are forecasting against

• Chrome extension posting one vehicle at a time with human-like delays and server-enforced daily limits.
• Bulk CSV and Excel import with a row-level error log, so the book you forecast against is the book you actually have.

PostToMarket is not affiliated with, endorsed by, or sponsored by Meta. No tool can guarantee that Facebook will distribute listings or that a lead will show. The forecast still needs your stage definitions. The product removes the operational fog that makes those definitions impossible to apply.

Forecast Next Month From Stages You Can Count

Forecasting next month sales from your lead pipeline is a haircut applied to booked work, plus a capped guess at uncreated demand. If the calendar is thin, the forecast is thin. Saying so in the first week is cheaper than staffing and buying as if the CRM's "hot" folder were a promise.

PostToMarket keeps the inventory truthful, archives sold units, and gives managers a leads inbox and posting analytics they can drop next to the CRM export. Starter is $59 per month for a solo seller with one login. Dealership is $299 per month for up to 13 logins when the used car manager and the internet person cannot share a thread and still forecast.

Start your 10-day free trial through secure Stripe checkout. Connect the book, clean the sold list, and build next month's range from live units and real inquiries. Cancel anytime.