Dev.to WebDev 🛠 Dev 👁 0 📖 1 min read

Modelling a quote pipeline: one next action per lead, and why 'overdue' must be computed, not stored

Lead & Quote Recovery Desk — PAID $19 one-time, FREE demo: https://gettidycents.com/product/lead-quote-recovery-desk Most lost sales are not "no". They are quotes nobody followed up. The data model that fixes this is sm

Lead & Quote Recovery Desk — PAID $19 one-time, FREE demo: https://gettidycents.com/product/lead-quote-recovery-desk

Most lost sales are not "no". They are quotes nobody followed up. The data model that fixes this is small.

One record per enquiry, one next action

const lead = {
  id: 'L-104',
  source: 'referral',            // where it came from
  stage: 'quoted',               // new | qualified | quoted | won | lost
  quotes: [{ v: 1, totalCents: 480000, sentOn: '2026-11-03' },
           { v: 2, totalCents: 452000, sentOn: '2026-11-10' }],
  nextAction: { what: 'call to confirm scope', due: '2026-11-14' },
  outcome: null                  // { result: 'won'|'lost', reason, on }
};

Rule: a lead that is not won or lost must have a next action. A lead with no next action is the leak.

Overdue is derived, never stored

function status(lead, today) {
  if (lead.outcome) return lead.outcome.result;
  if (!lead.nextAction) return 'NO NEXT STEP';
  return lead.nextAction.due < today ? 'OVERDUE' : 'ON TRACK';
}

Storing an overdue: true flag goes stale the next morning. Computing it from the due date (ISO strings compare correctly) keeps the list honest every time it opens.

Which sources actually close

Win rate per source = won ÷ (won + lost), counting closed leads only. Open leads in the denominator make new channels look worse than they are.

The desk adds proposal versions, seasonal follow-ups and source results on top of this. Tidy Cents makes tools for running your business: 170+ tools, 30+ of them free. No AI guesses: every result shows its working.

📰 Read the original article on Dev.to WebDev

Originally published by Dev.to WebDev. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.