Building a funnel report on one page that people will read

4 days ago
3 min read

Introduction

Reports fail by being thorough. Twelve pages of charts covering every available metric gets circulated once, skimmed by two people, and never referred to again. The information was all there and none of it was used, which is indistinguishable from not having collected it.

A single page behaves differently. It gets looked at in meetings, printed and stuck on a wall, and compared against last quarter's page without anybody having to open anything. The constraint does the editorial work that nobody would otherwise do.

The difficulty is entirely in deciding what to leave out, and that decision is easier when the page size makes it for you.

1. Building a funnel report on one page starts with five rows

The core content.

Enquiries, quotes, jobs won, average value, days to decision. Those five, with a column per period. Everything else is optional. If a sixth row is essential, remove one of the five rather than adding to them.

2. Use columns for time, not for categories

The layout rule.

Twelve monthly columns across the page shows trend at a glance, which is what people actually want. Adding a column each period keeps the format stable. Nobody has to rebuild anything. After two years, drop the oldest column rather than shrinking the type.

3. Put the source table underneath

The second block.

Four columns — source, enquiries, jobs, revenue — is enough to guide spending. Sorted by revenue. It fits in a third of the page. Group the small sources into one line to keep it short.

4. Numbers before charts

The presentation preference.

A grid of figures is more precise, more compact and easier to compare across periods than any chart. Use a chart only where a shape is genuinely the point. One chart maximum. A seasonal pattern is the usual case that earns one.

5. Add two lines of commentary

The interpretation.

What changed and why, in the reporter's own words, at the top or bottom. This is often the most valuable content on the page. It also captures context that the numbers lose. Write it before the meeting rather than during it.

6. Note what is not measured

The honesty block.

One line listing what the report cannot see — offline recommendation, long-cycle enquiries, anything paused. This prevents literal readings a year later. It takes a sentence. It also protects the channels that never appear in the table.

7. Keep the definitions on the reverse

The durability.

Five sentences saying what each number counts, so a new reader is not guessing. It also makes definition drift visible. Update it with a date whenever it changes.

8. Same page, same order, every time

The comparability rule.

Redesigning the report each quarter destroys the ability to compare, which was the reason for making it. Resist improvements to the layout. Improve the content within the existing structure.

9. Present it in ten minutes

The test.

If it takes longer than that to walk through, it is too long. The page should support a conversation about one or two decisions. That is what a funnel report is for. Anything longer becomes a presentation instead of a discussion.

Be careful about the page becoming a substitute for looking at individual cases. The summary tells you where to look; tracing one enquiry tells you what is actually happening, and the report is not a replacement for that.

Conclusion

Fit the whole funnel onto one page and add a column each period rather than redesigning it.

Use five rows for enquiries, quotes, wins, average value and days to decision, put a four-column source table underneath, prefer a grid of numbers to charts, write two lines saying what changed and why, list explicitly what the report cannot see, keep the definitions on the reverse, hold the layout stable so periods stay comparable, and make sure it can be walked through in ten minutes.