Case Study: A Sales-Pipeline-Health Workbook on Live NetSuite Data

About This Case Study: Client name, people, referral partner, and the client's internally-named forecast metric have been withheld. All claims trace to engagement records. No invented outcomes appear in this article; one ratio is marked as the client's own working number.

The Client

Client: A North American industrial services company — roughly 80% field services, 20% light manufacturing — running NetSuite as its ERP. The business is highly seasonal, and the pipeline only gives real visibility three to four months out. A traditional annual budget never fit; what leadership actually needed was a rolling read on pipeline health.

Who used it: The CEO and the sales/operations lead, in a weekly working cadence — on a live, read-only connection to their production NetSuite account, with access scoped by role (full financials for the CEO, sales-level data for the sales lead).

The Problem

The raw material was all in NetSuite — opportunities, quotes, sales orders, customer history — but it didn't answer the questions leadership kept asking:

• Which open opportunities are urgent, and which are long-term parking?
• Which "big rocks" have to close for the next quarter to work?
• What does the backlog of open sales orders say about resource needs six months out?
• We quote far more than we win — their own working number was on the order of 30 quotes to 3 sales — so where are we losing, and why? (That ratio is the client's internal estimate, not a measured output of the system.)
• Which accounts have gone quiet? Their CRM held roughly 2,000 potential customers with no active opportunity attached.

What Was Built

A sales-pipeline-health workbook — a set of linked dashboards built conversationally against their NetSuite data:

Open-opportunity views

Split by urgency and time horizon.

A "big rocks" forecast view

The deals that need to close for the quarter to work.

Backlog and open-sales-order views

For resource planning six months out.

Conversion-rate analysis

To start answering the quote-to-win question.

A custom rolling revenue metric

(Their internal name for it is withheld.) Blending weighted pipeline and backlog with seasonality, overhead, and working-capital factors — built for a business with three-to-four-month visibility, not a twelve-month budget fiction.

Monday-morning stale-account digests

An automated email to the sales leads listing accounts with no contact in three-plus months, prioritized by account value, using email activity synced into NetSuite.

The Unglamorous Part That Made It Work

The most valuable sessions weren't about charts — they were about pipeline definitions. Dashboards on top of messy pipeline data just make the mess prettier. Working with the CEO and sales lead, the engagement locked rules the dashboards could trust:

• Opportunities, not quotes, are the pipeline. Multiple quotes per opportunity are normal; the latest quote carries the opportunity's current value.
• Placeholder pricing is filtered, not counted. Early-stage opportunities carry a $1 placeholder; the pipeline views exclude sub-$10 values so placeholders never inflate the number.
• The shadow pipeline is named. Sales orders that appear without an upstream opportunity (common for add-on work) go straight to revenue — they don't get to be called "pipeline."
• Hygiene is scheduled. Opportunities auto-close when sales orders are created, with a monthly audit to catch stragglers.

Why Definitions Beat Dashboards: This is the part a BI tool can't do for you and a one-off consulting deck doesn't survive: the definitions live next to the dashboards, on the live data, and the views update as the rules are refined in conversation.

Where It Stands

The workbook is in active use and iteration on the production NetSuite connection, with the customer-scoring layer (revenue history, win rates, sales-cycle length, days since last touch per account) moving into the same views, and the pipeline dashboard being rebuilt on the platform's new dashboard substrate. The honest claim: a seasonal services company turned its NetSuite opportunity data into a governed, role-scoped pipeline-health workbook its CEO actually reviews weekly — without hiring a BI team.

Names withheld. All claims trace to engagement records; no invented outcomes — one ratio is the client's own working number, as noted above.