The Chart That Made a Stalled Pipeline Look Healthy

Written on
The Chart That Made a Stalled Pipeline Look Healthy

A software company's revenue operations analyst brought a single chart to the quarterly board meeting. Sales pipeline was up 40 percent over the prior quarter, shown as a tall, satisfying bar beside a shorter one. The board approved four new sales hires that afternoon.

Two quarters later, revenue had barely moved. A closer look found most of the pipeline growth came from deals that had sat untouched for more than 120 days. Reps kept them open because closing them as lost hurt their numbers. The chart showed the total. It never showed age.

A Chart Is the Last Step of a Long Pipeline

A Chart Is the Last Step of a Long Pipeline

People judge a chart by how it looks. Its accuracy gets decided much earlier, in the data transformations that feed it.

Before that pipeline bar existed, someone had to decide which deals counted, what stage qualified as "pipeline," how to handle deals with no close date, and whether renewals belonged in the same total as new business. Each decision lived in a query somewhere. Nobody in the boardroom could see any of them.

That's where clear graphics actually start. If you can't explain how a number was built, a better chart design only makes a questionable number more convincing.

Making the Numbers Traceable

Data teams increasingly build those transformations in tools that keep the logic visible. Prophecy is one example. Analysts and engineers design pipelines visually, the platform generates code into version control, and lineage shows which source tables and filters feed each output.

For the revenue team, that meant a board member's question, "does this include renewals?", could be answered in a minute by tracing the pipeline rather than by asking the analyst to dig through old queries. When the definition of qualified pipeline later changed to exclude deals inactive for 90 days, the change was reviewed, versioned, and dated, so charts before and after could be compared honestly.

Tooling won't settle the definitions themselves. Sales leadership and finance still need to agree on what counts, in writing, before anyone builds anything. Prophecy and similar platforms make the agreed logic easier to inspect. They don't make the agreement.

Which Sales Numbers Deserve a Chart

Which Sales Numbers Deserve a Chart

Measuring sales efficiency comes down to a small set of ratios, and each one reads better as a trend than as a single number.

Net new annual revenue divided by the previous quarter's sales and marketing spend shows how much growth each dollar buys. Customer acquisition cost payback, in months, shows how long a new customer takes to cover what it cost to win them. Win rate by stage reveals where deals stall. Average sales cycle length shows whether deals are getting harder to close. Pipeline coverage, meaning qualified pipeline as a multiple of the quarter's target, works too, as long as the qualification rules are honest.

Measuring sales efficiency through these ratios, plotted over six to eight quarters, tells a board far more than any single impressive total.

Design Choices That Mislead

Most misleading business charts aren't deliberate. They come from defaults.

A bar chart whose vertical axis starts at 80 instead of zero makes a 5 percent change look like a doubling. Charts with two vertical axes invite viewers to see relationships between lines that may not exist. Pie charts with nine slices force people to compare angles, which almost nobody does accurately. Cumulative charts always go up, hiding a bad quarter inside a rising line.

Add context the data can't carry alone. Mark the month a pricing change took effect or a new sales team started. Show the age breakdown of pipeline as a stacked bar, so stale deals become visible at a glance. Put the definition of each metric in small text beneath the chart. Boards read footnotes more often than analysts expect.

One Question Per Graphic

One Question Per Graphic

The strongest charts answer a single question, stated in the title. "Pipeline older than 90 days has tripled since March" tells a reader what to see. "Q3 Pipeline Overview" leaves them to work it out, and they'll often take away the wrong thing.

Four Hires, Two Quarters Later

The company's board deck now shows pipeline split by age, with the definition printed underneath. The first version was uncomfortable to present. It also led to a cleanup of 200 stale deals and a hiring plan based on deals that could actually close.

Until next time, Be creative! - Pix'sTory

Easy-to-Use
Photo & Animation Maker

Register - It's free
Have an account? Login