Data Cleaning for Political Campaign Voter Files, Donor Databases, Volunteer Contact Lists, PAC Supporter Records and Advocacy Organization Membership Databases
On this page
The Most Complicated Databases in Any Industry
Political campaign databases are arguably the most complex contact databases maintained by any type of organization. A corporate CRM tracks customers and prospects. A nonprofit CRM tracks donors and volunteers. A campaign database tracks all of these and more: registered voters (millions of records from the state voter file), donors (from multiple fundraising platforms and direct mail programs), volunteers (from sign-up forms, events, and phone banks), event attendees, petition signers, survey respondents, endorsers, and social media supporters. Each of these data sources has different fields, different formats, different levels of accuracy, and different update frequencies.
The complexity is compounded by the time pressure that campaigns operate under. A commercial business can spend months cleaning its database because the ROI materializes over years. A campaign has weeks or months before Election Day, and every day spent cleaning data is a day not spent contacting voters. This tension between data quality and operational urgency means that campaign databases are often used in a partially cleaned state, with known data quality issues accepted as the cost of moving fast.
Despite this pressure, the campaigns that invest in data cleaning outperform those that do not. A clean voter contact list means more doors knocked per shift (canvassers are not wasting time on wrong addresses), more live contacts per phone bank session (callers are not dialing disconnected numbers), more emails delivered to inboxes (not bouncing from invalid addresses), and more accurate targeting (the right message reaches the right voter based on accurate issue interest and turnout propensity data).
Voter File Email Matching
State voter files -- the official lists of registered voters maintained by each state's secretary of state or board of elections -- are the foundation of campaign contact databases. These files contain each voter's name, address, date of birth, party registration (in states with party registration), voting history (which elections they participated in, not how they voted), and sometimes phone numbers. What voter files almost never contain is email addresses.
This gap has created an industry of voter file email appending, where third-party data vendors match email addresses from their databases to voter file records using name and address matching. The accuracy of these appends varies widely -- from 30% to 70% match rates, with match accuracy (whether the appended email actually belongs to the voter) ranging from 60% to 90% depending on the vendor and the matching methodology.
The result is that campaign email databases built from voter file appends contain a significant number of incorrect matches: emails that belong to a different person with the same name, emails that belonged to the voter at a previous address but are no longer their primary address, and emails from outdated vendor databases that are no longer valid.
Export the appended voter file from your campaign data platform (NGP VAN, L2, TargetSmart, Aristotle, i360, or a custom system). Upload to Email Extractor to extract and deduplicate the email addresses. Common deduplication issues include the same voter appearing with multiple appended emails from different append vendors (each vendor found a different email for the same person), the same email address appearing under multiple voter records (a shared family email appended to multiple household members), and voters who appear in both the voter file append and the campaign's own organically collected email list with different addresses.
Donor Record Consolidation
Campaign donor databases are fragmented across multiple fundraising platforms. A campaign may receive donations through ActBlue or WinRed (online fundraising platforms), direct mail (check donations with return envelopes), event fundraising (in-person donations at fundraisers), text-to-donate platforms, and the campaign's own website donation page. Each platform creates its own donor record, and the same donor who gives through multiple channels appears as multiple separate donors in the campaign's database.
The consolidation challenge is that donor records from different platforms use different name formats (Robert Smith on ActBlue, Bob Smith on a check, R. Smith on a direct mail response card), different addresses (home address on one, work address on another), and different email addresses (personal email on the online platform, work email on a direct donation). A campaign that does not consolidate these records underestimates the total giving of multi-channel donors, sends redundant fundraising appeals (the same person receives the same ask three times through three channels), and cannot accurately identify their most generous supporters for high-touch cultivation.
Export donor records from each platform as CSV files. Upload all files together to Email Extractor to extract and deduplicate email addresses across platforms. After email deduplication, use the deduplicated emails as a key for consolidating the full donor records: donors who share an email address across platforms are almost certainly the same person, and their giving history can be merged into a single consolidated donor profile.
Volunteer Database Merges
Campaign volunteer databases undergo a particularly disruptive form of data quality degradation during campaign transitions. When a primary campaign ends and the candidate's operation merges with the state party for the general election, two separate volunteer databases must be consolidated. The primary campaign has its own volunteer list with contact information, availability, skills, and activity history. The party has its own volunteer list accumulated over multiple election cycles. Many volunteers appear in both databases with different information.
Export both volunteer databases and upload to Email Extractor to identify overlapping records. Volunteers who appear in both databases need their records merged rather than duplicated. The merged record should retain the most recent contact information (whichever database has the more recently verified email and phone), the complete activity history from both databases (so the volunteer's total contribution is visible), and skill and availability information from both sources.
After the merge, segment the consolidated volunteer database by availability (days and times each volunteer can work), by skill (phone banking, canvassing, data entry, event setup, social media, translation), by geography (which precincts or turfs they can cover), and by engagement level (highly active volunteers who work every weekend vs. occasional volunteers who help at events). This segmented database enables targeted volunteer mobilization: when the campaign needs 50 canvassers for a Saturday door-knock in District 7, the volunteer coordinator can pull exactly the right list.
