B2B data and enrichment
How to enrich a CSV of leads, step by step
Most lead lists start life as a spreadsheet: an event export, a list from a partner, a sheet a rep kept. This guide walks through enriching one in GTM Scoop, from preparing the file to sending the finished rows where your team works.
By GTM Scoop · Published · 2 min read
Part of What is data enrichment? A guide for GTM teams
1. Prepare the file
- One row per person or company, with a header row.
- Give every row a phone number or an email, plus a street address and ZIP: for company data a match needs both.
- Matching tries phone number, then email, then address and ZIP, so the more of these each row has, the more rows match.
- Keep your own ID column (a CRM ID or a row number) so you can join the results back.
- Save it as a CSV file.
2. Upload it and map the columns
In Connect Data, upload the file. GTM Scoop suggests which of your columns holds the phone number, email, address and ZIP; check each suggestion and fix any that are wrong. The mapping is what makes the match: an email column mapped as a name will not match anything.
3. Check the coverage before you spend
You see how many rows can be matched before you commit, and each matched row keeps the signal it matched on: phone, email or address. When coverage is low, the usual cause is a missing or mis-mapped phone, email or address column, so fix the mapping before enriching.
4. Enrich
Start the enrichment. Each matched row is filled in with firmographics, contacts and decision makers, and one enrichment credit enriches one account. Enrichment needs a Starter plan (200 credits a month) or Growth (500). Large files run as a job, and the results appear when it completes.
5. Review the results
- Check which signal each row matched on, and spot-check a sample before outreach.
- Rows that did not match usually lack a phone number, an email or a full address with ZIP. Add what is missing and run them again.
- Download the results as a CSV, or keep them in GTM Scoop as a saved list.
6. Send the enriched records on
Send the rows to Salesforce, HubSpot or Zoho CRM as leads or contacts (up to 500 per send), to Apollo, Instantly or Clay for outreach (up to 200 per send), or into a Snowflake or ClickHouse table. Records get a Domain column when they have a website or a work email to take it from. See every integration.
Next: find more accounts like these
If the file is a list of your customers, GTM Scoop Analysis can learn what they have in common and find lookalike accounts. See how to find lookalike companies.
Doing it from code
The same flow runs over the REST API: create an upload, start a run, enrich it and read the results. The Uploads, Enrichment and Results references have every request.
Try it in GTM Scoop
Upload a CSV