← All Field Notes
2026-10-09 · 6 min read

The Spreadsheet That Bought Year Three: How I Measure Trade Show ROI

Going into our second year at RSA Conference, Arxan's leadership asked me to prove the booth produced revenue. The ROI guides cover the formula, the costs and the CRM tags. They all measure one show at a time, and I think a big annual show deserves three years before anyone calls it.

Somebody always asks for the number.

For me it was Arxan’s leadership, going into our second year at RSA Conference, and the ask was blunt: could I prove the booth produced revenue? We had spent Year One wedged between Palo Alto Networks and CrowdStrike on a floor of forty thousand people, and I knew the booth had worked, because I’d watched people stop. Watching people stop is not a line item. If I couldn’t answer with a spreadsheet, the budget was in danger, and so was Year Two.

The guides that rank for measuring trade show ROI will walk you through the same ground, and I agree with nearly all of it. Set goals before the show. Use the formula, revenue minus investment divided by investment. Count every cost, including the drayage and the booth internet nobody remembers budgeting for. Tag leads in your CRM, follow up fast, and be patient, because B2B deals take months to close. All correct! The trouble is the unit. Every one of those guides measures a single show, as if the question were whether this one booth paid for itself by June, and in my experience that is the question that gets good trade show programs cancelled.

Pick Your Comparison Before You Pick Your Booth

An ROI percentage on its own persuades almost nobody in a budget meeting. Your CFO hears “the booth returned X” and immediately wonders what the same money would have done somewhere else, and they’re right to wonder.

So the number I built at Arxan was a comparison. By the end of Q2 we could point to specific RSA-sourced opportunities, their dollar value, and their conversion rates next to our other lead sources. That last part did the persuading. I won’t print the figures here, because they belong to Arxan, but I can tell you the shape of the argument: here is what a lead from the booth turned into, here is what a lead from everywhere else turned into, and here is the difference. Decide which sources you’ll compare against before the show, while marketing ops still has time to make sure every source is tagged the same way.

Tag It on the Floor

Every badge we scanned at the booth got tagged in the CRM with RSA-source attribution. Every one. You can rebuild a cost sheet in March from invoices and expense reports, but you cannot go back and work out which of that month’s new contacts came from the booth and which came from a webinar. The tag is the one piece of the whole measurement exercise that has to happen in real time.

The tag tells you where a lead came from. It tells you nothing about what the person said, and that’s why I make the booth team type one sentence into the notes field after every real conversation. A pipeline report full of RSA-tagged leads with empty notes is a list of names. It will not survive a skeptical VP of Sales asking which of them were real.

Twenty-Four Hours, Then Every Single Week

Every lead went to a rep within 24 hours of the scan. That part shows up in every guide, and it’s easy to agree with in a planning meeting and surprisingly hard to pull off on the Thursday of a show week, when the reps are still on the floor and their inboxes are on fire.

The part I’d underline twice is what came after. Every rep had a 30-60-90 day follow-up cadence, and we tracked it every week. Weekly matters because leads rarely die loudly. They go quiet around day forty, after a second email nobody answered, and unless someone is looking at the list every week, a quiet lead looks exactly like a slow one until the quarter is over and it is simply gone.

Year One Is the Wrong Unit

This is the opinion I’ll defend in any budget meeting, and it’s the one missing from every ROI guide I’ve read.

I ran Arxan’s presence at RSA for three consecutive years. Pipeline contribution grew every year, and Year Three was the highest of the three, with a booth we had barely changed. The buyers walking that floor were mostly the same CISOs and security architects every year. By the third year they had seen us in the same neighborhood, with roughly the same message, twice already, and we had started to register as a fixture: a company that was clearly going to be there and clearly investing in the relationship. Some of the deals that showed up in Year Three almost certainly started with a conversation in Year One that went nowhere at the time.

Measure a single show and you will be tempted to cut it at exactly the moment it starts compounding. I’d judge a big annual trade show on a three-year arc, and I’d tell leadership that up front, before the first deposit. Year One you arrive. Year Two you prove the math, which is the job of the spreadsheet. Year Three you get to be the company people expect to see, which is worth more than any new activation, and which no single-year ROI formula will ever give you credit for.

The January conversation gets shorter, too. You report on where you are in a plan everyone already signed, and nobody reopens whether to go back at all.

When to Look

I’ve said in another Field Note that the best interview question for an event marketer is when they last looked at the pipeline number, and who handed it to them. For RSA, my answer was the end of Q2. That was long enough for the 90-day cadence to run its course and early enough to have real numbers on the table before anybody started arguing about next year. Look too early and you are reporting badge counts with a straight face. Look too late and somebody has already decided for you.

The Dinner Problem

Somewhere in every CRM there is a deal tagged as an outbound win that really jumped a stage at a customer dinner during conference week, over the bread, and no attribution model on earth will hand the booth credit for it.

The Takeaway

Measuring trade show ROI is mostly bookkeeping you agree to before the show: a source tag that goes on every scan, a 24-hour handoff, a weekly look at the follow-up list, a comparison against your other lead sources, and a date in Q2 when you open the spreadsheet and read it out loud. The formula is the easy part. The harder part is convincing leadership that the show deserves three years before anyone calls it, and the spreadsheet from Year Two is how you buy Year Three. It’s how I bought ours.

If your team has a big show on the calendar and a budget meeting you’re already dreading, let’s talk. I’ll bring the tagging plan, and I’ll want to know which lead sources we’re comparing against before anyone orders carpet.

Frequently Asked Questions

How do you measure trade show ROI?

Agree on the bookkeeping before the show. Tag every badge scan in the CRM with the show as its source, get every lead to a rep within 24 hours, track a 30-60-90 day follow-up cadence every week, and compare the show's leads against your other lead sources. At Arxan that let us point to specific RSA-sourced opportunities, their dollar value and their conversion rates by the end of Q2.

What should you compare trade show leads against?

Your other lead sources. An ROI percentage on its own persuades almost nobody in a budget meeting, because the CFO immediately wonders what the same money would have done somewhere else. Showing what a booth lead turned into next to what a lead from everywhere else turned into is the part that does the persuading.

How many years should you give a trade show before judging its ROI?

I'd judge a big annual trade show on a three-year arc and tell leadership that before the first deposit. At RSA, Arxan's pipeline contribution grew every year and Year Three was the highest of the three, with a booth we had barely changed. Measure a single show and you'll be tempted to cut it right when it starts compounding.

When should you report trade show ROI?

For RSA, I looked at the end of Q2. That was long enough for the 90-day follow-up cadence to run its course and early enough to have real numbers on the table before anybody started arguing about next year's budget.