Data Cleaning for Trade Show Leads: Badge Scans, Business Card Stacks, Booth Sign-Up Sheets and Post-Show CRM Imports
On this page
The Trade Show Data Problem
Your team just spent $15,000-$50,000 on a trade show booth: booth space, travel, hotel, setup, giveaways, and three days of standing on concrete. You came home with a pile of leads. Badge scan exports, business cards rubber-banded together, a sign-up sheet with handwriting that ranges from legible to hieroglyphic, a raffle entry bowl, a stack of demo request forms filled out on tablets, and notes scrawled on the backs of your own business cards by sales reps who had conversations they want to remember.
This pile represents thousands of dollars of investment and dozens of potential customers. And in most organizations, it sits untouched for a week after the show while everyone catches up on the work that piled up while they were gone. By the time someone gets around to processing the leads, the urgency has faded, the contacts have forgotten who you are, and half the value of the trade show investment has evaporated.
The companies that get ROI from trade shows are the ones that have a data cleaning and follow-up process ready before the show starts, so the leads are cleaned, scored, and in the CRM within 48 hours of the show ending.
Collecting Data from Multiple Sources
Trade show leads come in from multiple collection methods, each with different data quality and different levels of qualification.
Badge scan exports are the cleanest data source. The show organizer provides attendee information tied to each badge, typically including name, title, company, email, phone, and sometimes company size and industry. Badge scans are exported as CSV files from the scanner app or the show's lead retrieval system. The data is pre-formatted and standardized because it comes from the registration database. However, badge scans are undifferentiated: they include everyone who walked by and paused long enough to be scanned, from highly qualified prospects to people who stopped for free candy.
Business card scans (using apps like CamCard, ABBYY Business Card Reader, or HubSpot's card scanner) produce structured data from card images, but OCR accuracy varies. Names with unusual spellings, small-font email addresses, and creative card layouts all introduce errors. Review scanned card data for accuracy before importing.
Booth sign-up sheets (paper or tablet-based) contain self-reported data with the usual problems: illegible handwriting on paper sheets, misspelled email addresses, incomplete entries, and fake information from people who wanted the giveaway but not the follow-up. Tablet-based sign-ups are cleaner but still contain typos and intentionally fake entries.
Raffle and giveaway entries are the lowest-quality leads. Many entries are from people who have zero interest in your product and entered solely for the prize. These leads should be segregated and treated differently from engaged leads.
Sales rep notes are the highest-quality data but the least structured. A rep who had a 15-minute conversation with a VP of Operations knows more about that lead than any badge scan or form fill can capture. But those notes are often on paper, in a phone note app, or in the rep's memory -- none of which integrates with the CRM automatically.
The 48-Hour Cleaning Process
The goal is to have all trade show leads cleaned, deduplicated, scored, and in the CRM within 48 hours of the show's last day. Here is the process.
Day 1 (evening of the last show day or the travel day): Export badge scan data from the lead retrieval system (CSV). Collect all business cards and scan them with a card scanning app (export as CSV). Photograph paper sign-up sheets for backup, then enter them into a spreadsheet. Export tablet sign-up data as CSV. Collect all sales rep notes (have each rep send their notes via email or enter them into a shared document).
Day 2 (first business day after the show): Upload all CSV files, spreadsheets, and any scanned documents to Email Extractor to extract every email address across all sources and deduplicate. A prospect who was badge-scanned, also left a business card, and also signed up for a demo should be one record, not three. Download results as CSV with sources so you can see which collection methods captured each contact.
Review the deduplicated list and score each lead based on engagement level. High priority: requested a demo, had a substantive conversation with a sales rep (notes exist), or specifically asked for follow-up. Medium priority: visited the booth and engaged with the product (badge scan + sign-up sheet, or badge scan + business card). Low priority: badge scan only (walked by), raffle entry only, or sign-up with no engagement notes.
Day 2-3: Import scored leads into your CRM with source attribution (show name, collection method, engagement level). Assign high-priority leads to sales reps for immediate follow-up. Queue medium-priority leads for a personalized but less urgent follow-up sequence. Add low-priority leads to a nurture campaign.
Post-Show Follow-Up by Lead Quality
The follow-up approach should match the lead quality.
High-priority leads (demo requests, substantive conversations): Personal email from the sales rep who spoke with them, within 48 hours of the show ending. "Hi [Name], it was great meeting you at [Show Name]. I enjoyed our conversation about [specific topic discussed]. As we discussed, here is [the resource, case study, pricing, or information they requested]. I would love to continue the conversation -- do you have 20 minutes this week for a call? Here are some times that work: [suggest 2-3 specific times]."
Medium-priority leads (engaged visitors): Semi-personalized email from the company, within 72 hours. "Hi [Name], thanks for stopping by the [Company Name] booth at [Show Name]. Based on your interest in [product/topic], I thought you might find this helpful: [relevant resource, case study, or product overview]. If you would like to see how [product] works for [their industry/use case], I would be happy to set up a quick demo. Just reply to this email or book a time here: [scheduling link]."
Low-priority leads (badge scans only, raffle entries): Automated nurture email, within one week. "Hi [Name], thanks for visiting [Show Name]. Here is a roundup of what we showcased at the event: [brief product overview or recap]. If anything catches your eye, reply and we will set up a personalized conversation."
Consolidating with Existing CRM Data
Trade show leads often overlap with contacts already in your CRM. A badge scan might capture someone your sales team has been prospecting for months, or a business card might be from a current customer's colleague. Before importing trade show leads, export your current CRM contacts and upload alongside the trade show data to Email Extractor. This cross-reference prevents creating duplicate CRM records and, importantly, flags existing relationships that should be handled differently from cold leads.
A trade show lead who is already a prospect in your pipeline should not receive the standard post-show follow-up. Instead, their sales rep should get a notification: "[Contact Name] from [Company] visited our booth at [Show Name]. They are in your pipeline -- follow up with a personal note."
