How to measure the ROI of a trade show or conference
Almost nobody calculates the ROI of a trade show, not because it's hard, but because the numbers live in different places by the time anyone thinks to ask. The budget is in one file, the actual invoices arrived over three months from four people, and whatever the event produced — leads, signed deals, a training outcome — was never written down next to the cost. The formula below isn't complicated. The discipline of putting the numbers next to each other is the actual work.
The three numbers you need
Total actual cost. Registration, travel, accommodation, stand or sponsorship, materials — everything that was actually spent, not what was planned.
What the event produced. Leads that turned into pipeline, deals that closed, or — for internal events — a measurable training or team outcome. This is the number most companies skip, because it means going back weeks or months later to check.
Who actually attended. Not who was invited. A no-show still costs the ticket and, often, the hotel — counting them as if they attended understates the real cost per outcome.
The formula, with a worked example
ROI = (value produced − total cost) / total cost, usually read as a percentage.
Take a five-person trade show trip: registration, travel and hotel for five people comes to €11,000. One of the five didn't travel — a non-refundable ticket, so the cost stands. The trip produces two deals that close within the quarter, worth €18,000 in the first year. ROI = (18,000 − 11,000) / 11,000 = 64%.
Run the same event with the same cost but only one deal at €9,000, and the ROI drops to −18% — a loss, even though the event "went fine." The formula doesn't change the number. It just makes the number visible, which is usually enough to change the decision the following year.
The mistakes that make the number wrong
Counting cost in one currency when the trip wasn't. A stand paid in EUR, flights paid in USD, and a hotel paid in the local currency — converted by hand once, usually at whatever rate someone remembers, understates or overstates the total by more than the ROI swing itself.
Leaving out travel and accommodation. Registration is the easy number to find. Travel and hotel, spread across separate expense reports, are the ones that get forgotten — and they're often the larger half of the cost.
Not distinguishing invited from attended. An ROI calculated against the invited list instead of the attended one is measuring the wrong denominator, and it's the single most common error in this calculation.
Not ready for software? Take the spreadsheet.
The Trade Show Budget & Attendance Tracker is the file we would build if we had to do this in Excel: budget vs actual per event, an attendee list, a pre-show checklist and a cost-per-attendee calculation. It is free, it works, and it is yours whether or not you ever open Convenio.
Free trade show budget template and conference attendance tracker, downloadable as an Excel spreadsheet. Track expected versus actual event budget, attendee lists and no-shows, and cost per attendee for any trade show or conference.
Where this data actually has to live
None of this works if the three numbers are scattered across a budget file, an expense system and someone's memory of who showed up. The Trade Show Budget & Attendance Tracker keeps planned and actual cost next to attendance in the same file, which is the minimum needed to run this formula without a week of reconciliation. The next problem — reading that gap across many events, not just one — is budget vs actual over time, and it's where a single spreadsheet per event stops being enough.
Not ready for software? Take the spreadsheet.
The Trade Show Budget & Attendance Tracker is the file we would build if we had to do this in Excel: budget vs actual per event, an attendee list, a pre-show checklist and a cost-per-attendee calculation. It is free, it works, and it is yours whether or not you ever open Convenio.
Free trade show budget template and conference attendance tracker, downloadable as an Excel spreadsheet. Track expected versus actual event budget, attendee lists and no-shows, and cost per attendee for any trade show or conference.