# How to Run a Weekly Pipeline Review in 15 Minutes: Quiet Deals, Next Steps and Forecast (Real Run With Claude)

Source: https://lotscrm.com/blog/how-to-run-a-weekly-pipeline-review-in-15-minutes-quiet-deals-next-steps-and-forecast-real-run-with-claude
Published: 2026-11-06T00:30:26.428129+00:00

A weekly pipeline review takes 15 minutes when you ask three questions in order: which deals have gone quiet, what is the next step on each, and what does the pipeline add up to. Your AI agent can pull the facts in under a minute, so the 15 minutes are for the decisions. I built LotsCRM, and this is how I run that review from Claude, with the real tool output from a run I did on 5 November 2026 in a test workspace with made-up deals.

## The 15-minute agenda

| Minutes | Question | What you ask the agent for |
|---|---|---|
| 0 to 3 | Where does the pipeline stand? | The CRM briefing and the pipeline summary |
| 3 to 8 | Which deals are quiet or have no next step? | Stale deals, deals without a next step, overdue follow-ups |
| 8 to 12 | What happens next on each? | Deal context for the ones that matter, then follow-ups you can act on |
| 12 to 15 | What will close, and when? | A forecast from stage and value, and a date check on every close date |

Keep the order. Looking at the forecast first makes you defend numbers. Looking at the quiet deals first makes you fix the numbers.

## What I ran, and what I did not

I ran this through the [LotsCRM connector](https://lotscrm.com/mcp) with Claude. The data was fictional and seeded the same day: a test workspace with made-up deals. It had 8 companies and 8 contacts at example.com addresses, and 8 open deals across the New, Qualified, Proposal and Negotiation stages, worth $82,500 in total. I recorded 4 activities (a call, an email, a meeting and a note) and 3 follow-ups, two of them already overdue. I sent nothing, and LotsCRM never sends email or messages anyway.

One limit matters for the rest of this article. You cannot backdate records, so none of my deals was old enough to count as quiet. I will show you what the tools returned, say exactly where that left a gap, and not pretend otherwise. If you have not connected an agent yet, [Claude CRM Integration](https://lotscrm.com/blog/claude-crm-integration) covers the setup.

## Step 1: Ask for the briefing and the pipeline summary (minutes 0 to 3)

The prompt I use:

> Run my weekly pipeline review. Start with the CRM briefing and the pipeline summary. Then list overdue follow-ups, deals closing in the next 14 days and deals with no next step.

The briefing came back with one set of counts: 8 open deals, 2 overdue follow-ups, 3 deals closing within 14 days, 5 deals without a next step, and 0 stale deals. The pipeline summary gave the stage totals:

| Stage | Deals | Value | Weighted value |
|---|---|---|---|
| New | 2 | $7,800 | $780 |
| Qualified | 3 | $33,500 | $10,050 |
| Proposal | 2 | $19,200 | $11,520 |
| Negotiation | 1 | $22,000 | $17,600 |

Currencies are reported separately, so a pipeline with two currencies does not get silently added together. Mine was USD only.

## Step 2: Find the quiet deals and the deals with no next step (minutes 3 to 8)

This is the step the whole review exists for, and it is where my test data ran out.

**How quiet is defined.** LotsCRM has a workspace setting called stale_after_days, which defaulted to 7 in my workspace. The briefing and the sales brief also accept a different number for a single call, so you can ask "what has been quiet for 3 days?" without changing the setting. I tried it with 1 day, and the briefing echoed the rule back as 1. It still listed 0 stale deals, because every deal in my workspace had been created minutes earlier.

**What I could not show.** I never saw a stale deal in the output, so I cannot show you what one looks like. I would rather tell you that than invent one. On your real pipeline, the stale deals list is the first thing to read.

**What the tools did show.** Two other lists did real work on fresh data:

- **Deals without a next step.** The briefing listed 5 of my 8 deals. A deal counts as having a next step when it has an open follow-up. One of the five, a deal in Proposal, already had a note on it saying the owner was waiting on his partner. It was still listed, because a note is not a scheduled next step.
- **Overdue follow-ups.** Two came back, with their due dates: one high-priority follow-up on a proposal, due 3 November, and one to book a demo, due 4 November. The tool accepted past due dates, so I could seed them.

The briefing also lists the deals closing soon. Mine had three: $18,000 in Qualified due to close on 10 November, $22,000 in Negotiation on 12 November, and $14,000 in Proposal on 14 November. The first one had no activity and no follow-up on it at all, which is exactly the kind of deal a weekly review should catch.

## Step 3: Get the context, then draft the follow-ups (minutes 8 to 12)

For the two deals that mattered most, I asked for follow-up preparation with an email objective. The tool returns context, not a finished message: the deal, the contact, recent activity, open follow-ups, whether the person can be contacted, and an instruction to return a draft only. For the Proposal deal it returned the proposal email I had logged and the overdue follow-up. Both calls said the contact could be reached, and both said the agent could not make business claims, because this workspace had no business context connected. That is the product telling the agent to stay with what the CRM history supports.

The prompt:

> For each deal closing in the next 14 days, get the deal context and write me a short follow-up email. Use only what is in the CRM history. Do not send anything.

You read the draft, change what you want and send it from your own email. LotsCRM does not send it for you. In my run I fetched the context for two deals and sent nothing.

## Step 4: Record the next steps and fix what is wrong (still minutes 8 to 12)

Reviewing a deal and leaving it without a next step is how the same list comes back next Monday. I had Claude do three things:

1. **Create follow-ups.** Three new ones: one for the $18,000 deal (due 6 November, high priority), one for the Proposal deal waiting on a partner (due 12 November, when the partner is back) and one for a $6,000 retainer in Qualified (due 9 November).
2. **Correct a close date that nothing supported.** The $18,000 deal said it would close on 10 November, yet it had no recorded contact. I moved the date to 25 November and noted why. Updates carry the version number you read, so an agent cannot overwrite a newer edit made in the dashboard.
3. **Move no deal.** I did not move anything between stages, because nothing in the history justified it. A review that moves deals to look busy is worse than none.

I then asked for the sales brief again. Deals without a next step dropped from 5 to 2, which are the two New deals I left as leads. Deals closing within 14 days dropped from 3 to 2, because the corrected date left the window. The 2 overdue follow-ups stayed overdue: nobody had done the work yet. The review does not do the follow-ups for you; it makes the list impossible to ignore.

## Step 5: Compute the forecast (minutes 12 to 15)

The pipeline summary already gives raw and weighted value per stage. Weighted value is the stage amount times the stage's win probability. My workspace used the defaults, 10 percent for New, 30 for Qualified, 60 for Proposal and 80 for Negotiation, because none of my deals had its own probability set.

- **Raw open pipeline:** $7,800 + $33,500 + $19,200 + $22,000 = $82,500.
- **Weighted forecast:** $780 + $10,050 + $11,520 + $17,600 = $39,950.

I also split the weighted number by expected close date, using the same stage probabilities. That split is my own arithmetic on the returned figures, not a tool output. Deals due to close in November came to $37,370, the December deal to $1,800, and the two deals with no close date to $780. The three numbers add back to $39,950. A forecast with a $780 undated tail is a hint that every deal needs a close date; the briefing's "closing soon" list can only see deals that have one.

A stage probability is a guess made once for the whole stage. For a worked example with your own percentages, see [Weighted Pipeline Forecast for a Small Business](https://lotscrm.com/blog/weighted-pipeline-forecast-small-business).

## How long did it take?

From the first briefing call to the last check, the agent's whole run took about 46 seconds on the clock. That is machine time only. I did not time a person reading the output and deciding, and 15 minutes is my budget for that part, not a measurement.

## What it cost

An extra workspace on a plan that has room costs nothing more: billing showed my plan covering it with no additional charge. Without a plan, a workspace is $5 a month on pay as you go, with free credits and no card to start. Starter is $12 a month for 3 workspaces, Pro $29 for 10 and Business $79 for 30, with unlimited contacts, deals and teammates (checked on 5 November 2026 at [lotscrm.com/pricing](https://lotscrm.com/pricing)). [LotsCRM Pricing Explained](https://lotscrm.com/blog/lotscrm-pricing-explained) has the details.

I archived the test workspace when I finished. Archiving is recoverable for 30 days and deletes nothing.

## Make it a habit

Pick a fixed slot, say Monday morning, and paste the same prompt each week. Before each call, [prepare for it in five minutes](https://lotscrm.com/blog/prepare-for-a-sales-call-in-5-minutes) from the same notes you just reviewed. The follow-ups you create are tasks on your own list, so the review is only as good as the list you open afterwards, which [How to Never Miss a Follow-Up](https://lotscrm.com/blog/never-miss-a-follow-up) covers.

The full prompt in one piece:

> Run my weekly pipeline review for this workspace. 1) Give me the CRM briefing and the pipeline summary. 2) List stale deals, deals with no next step, overdue follow-ups and deals closing in the next 14 days. 3) For the five deals that matter most, get the deal context and draft a follow-up from the CRM history only; do not send anything. 4) Create a follow-up for every deal without a next step, and tell me any close date the history does not support. 5) Finish with raw and weighted pipeline by stage.

## Frequently asked questions

### How long should a weekly pipeline review take?

Fifteen minutes is a good budget for the human part. In my run the agent's whole pass took about 46 seconds. Reading the output, choosing which deals deserve a message and deciding what to change is the rest. I did not time a person doing that, so treat 15 minutes as a target and not a measurement.

### What counts as a quiet deal in LotsCRM?

The workspace setting stale_after_days defines it, and it defaulted to 7 in my workspace. The briefing and the sales brief take a different number for a single call. My test data was seeded the same day, so the stale list was empty and I cannot show you one. Separately, a deal without a next step is an open deal with no open follow-up.

### Can Claude send the follow-up emails for me?

No. LotsCRM never sends email or messages to your contacts. The follow-up preparation tool returns the CRM context and tells the agent to produce a draft only; it blocks opted-out and do-not-contact people. You read the draft and send it yourself.

### How do I forecast from the pipeline summary?

Take each stage's raw value and multiply it by the stage win probability. The summary returns both numbers per stage and per currency. In my run, $82,500 of open deals became a weighted $39,950 using stage probabilities of 10, 30, 60 and 80 percent.

### Will the review change my data?

Only in the ways you ask. In my run it created three follow-ups, one note and one deal update, and moved no deals. Deal updates carry the version the agent read, so it cannot overwrite a newer change. Nothing was deleted, and the workspace was archived at the end.

### How much does it cost to run this review?

New accounts get free credits, no card. After that, a workspace is $5 a month on pay as you go, or Starter at $12 a month for 3 workspaces, with unlimited contacts, deals and teammates (checked on 5 November 2026 at [lotscrm.com/pricing](https://lotscrm.com/pricing)).