Your Show Made Money. Can You Prove It Next Year?

Three weeks after a show closes, a sales exec asks: "What did the 9-square stand in Hall B deliver for exhibitors last year?" You know the footfall was good. You think the leads were up. But the actual numbers are in a spreadsheet the ops manager built the weekend before the event, cross-referenced with a badge scan export that lives in someone's Downloads folder, minus the catering cost that was tracked separately in Xero.\n\nThat answer takes half a day to reconstruct. And it's never quite the same number twice.\n\nThis is the quiet problem sitting behind most exhibition renewals in the UK and Australia. Not that organisers lack data — they usually have too much of it, scattered across registration platforms, floor plan tools, post-show surveys, badge scanners and finance systems that don't talk to each other. The problem is that none of it is structured to answer the question an exhibitor actually asks before they re-sign: "Was it worth it?"\n\n## Why the Spreadsheet Breaks at Scale\n\nFor a single annual event, a spreadsheet ROI tracker is manageable. You build it once, populate it in the weeks after the show, and use it in the next renewal conversation. Painful, but survivable.\n\nAt two shows a year it gets messy. At five or more — or when you have a portfolio of regional events with shared exhibitors — it collapses. The spreadsheet that worked for Show A doesn't match the column headings someone used for Show B. Footfall figures come from different sources depending on who was on-site that day. Lead data from badge scanners has to be manually matched against the exhibitor list. Every show is its own archaeology project.\n\nThe result is that your renewal conversation is driven by memory and relationship, not evidence. Which is fine when an exhibitor had a great experience and wants to come back anyway. It's a problem when they're on the fence, or when they want to upgrade their stand and need a business case for their marketing director.\n\nIf you're already wondering whether your ops have hit that wall, the post Five Signs Your Show Ops Have Outgrown Spreadsheets is worth ten minutes of your time.\n\n## What "ROI Tracking" Actually Means for an Organiser\n\nThe phrase gets used loosely. Let's be specific about what you're actually trying to track, because it's not one number — it's four.\n\nFootfall quality, not just volume. Total visitor count is a vanity metric. What exhibitors care about is how many of those visitors matched their target buyer profile, and ideally, how many came through their stand. If your registration process captures job title and company size, you can slice this. If it doesn't, you're reporting headcount and hoping they infer the rest.\n\nLead volume and source per exhibitor. If you run badge scanning or a lead capture app, you have data on how many contacts each exhibitor collected. Most platforms export this as a flat CSV that never gets used again. A tracking system routes that data into a per-exhibitor record that persists across shows.\n\nCost-per-outcome for the organiser. This is what What Does Your Show Actually Cost Per Visitor? covers in detail — the organiser's own P&L broken down by floor, by day, by category. You need this not just for internal reporting but to defend your floor pricing when a large exhibitor pushes back at renewal.\n\nYear-on-year movement per exhibitor. This is the one almost nobody tracks systematically. Did Exhibitor X collect more leads this year than last? Did their stand traffic improve when they moved from Hall C to Hall A? Without a system that carries exhibitor records across multiple events, this comparison requires someone to manually dig out last year's export and match it by company name.\n\n## Where Organisers Usually Are When They Come to Us\n\nThe pattern we see most often: a show ops team has built something workable for their flagship event, but the moment they acquire a second event or win a new venue contract, the whole thing has to be rebuilt from scratch. There's no shared exhibitor record that says "Acme Ltd has been with us across three shows, here's what they've paid, here's their average lead count, here's when they typically re-sign."\n\nThat's not a spreadsheet problem. It's an architecture problem. The data exists — it just lives in at least five places that were never designed to connect.\n\nThe fix isn't always a full custom build. Sometimes it's a configured CRM with a smart import workflow. Sometimes it's a lightweight internal tool that pulls from your existing registration and badge scan exports and structures them into a consistent per-exhibitor view. The right answer depends on your portfolio size and how much commercial weight you put on renewal conversations. The post on how to choose an exhibition software development partner gives you a framework for working out what kind of help you actually need.\n\n## What a Purpose-Built System Does Differently\n\nA proper exhibition ROI tracking system does three things a spreadsheet cannot.\n\nIt has a persistent exhibitor record. Every show an exhibitor participates in appends to their record — stand size, location, cost, footfall attributed to their zone, leads collected, post-show survey score if you run one. When your sales exec sits down for a renewal call, they open one screen, not three files.\n\nIt normalises data across events. Different shows, different badge scan providers, different registration platforms — the system has import mappings that translate all of it into a consistent schema. You're not manually reconciling column headers at 11pm the week after a show.\n\nIt produces a replicable exhibitor report. Not a bespoke slide deck someone builds in PowerPoint, but a templated output — PDF or portal view — that every exhibitor gets within a set number of days after the show. Consistent format, consistent metrics, every time. That consistency is what makes it credible. If your numbers look different every year, exhibitors start to wonder which version to believe.\n\nFor the ROI model on the organiser's own side, the Organiser Exhibition ROI Planner gives you a starting point for building your show P&L by day — useful both for internal reporting and for sanity-checking floor pricing before renewals.\n\n## The Data You Need to Collect (and When)\n\nThe mistake is trying to build the ROI report after the show using whatever data survived. The data you need has to be collected deliberately during registration and on the floor.\n\nAt registration: capture job title, company size and industry sector. These fields turn footfall into audience quality data. If your current registration form doesn't include them, or includes them as optional fields that 40% of visitors skip, your ROI report will always be incomplete.\n\nOn the floor: badge scanning at the entrance to each hall (not just the venue entrance) gives you zone-level footfall that you can map to exhibitor locations. If you don't have zone scanning, you can approximate this with dwell-time data from a mobile app check-in — not as precise, but better than nothing.\n\nPost-show: a short exhibitor survey, sent within 48 hours while the show is still fresh, gives you a satisfaction score and a qualitative read on whether your footfall numbers matched their experience on the stand. If your data says 800 visitors came through Hall B and an exhibitor in the middle of Hall B says it felt quiet all day, you have a calibration problem worth investigating.\n\nThe Exhibition CRM for Organisers guide covers how exhibitor records fit into a broader CRM workflow — worth reading alongside this if you're thinking about how the tracking system connects to your sales process.\n\n## Build vs Configure vs Commission\n\nIf your portfolio is one or two shows a year and you have a competent ops manager who's willing to build and maintain a structured workbook, a well-designed spreadsheet system with a strict data dictionary and a fixed import workflow can get you 70% of the way there. It won't scale, but it doesn't need to yet.\n\nIf you're running three or more events a year, have shared exhibitors across shows, or are starting to lose renewal conversations you should be winning, you've outgrown that approach. At that point you need either a configurable CRM that someone has actually set up for exhibition use (not just a generic Salesforce instance with an "Exhibitor" tag), or a lightweight custom tool built around your specific data model.\n\nThe custom route sounds expensive, but the scoping is usually simpler than people expect — because the core job is narrow: one persistent exhibitor record, consistent data imports from your existing tools, and a templated report output. That's a well-defined problem. AI-assisted development approaches mean a focused build like this can move from scoping to working prototype faster than a traditional dev cycle — without that meaning you're getting something half-finished.\n\nIf you're not sure which threshold you've crossed, count the hours your team spends reconstructing ROI data after your last three shows. If it's more than two days of work per event, a system will pay for itself in the first renewal cycle where it saves you a single large rebook.\n