Filed under CRM basics · Part of the political campaign software guide

One Voter Record Across Petitions, Doors and Texts

A campaign voter database works best when each person has exactly one record. Everything your campaign learns about that person, such as the petition they signed, the visit to their door and their reply to a text, should be added to that record in date order. When those facts are kept in three separate spreadsheets instead, you lose track of who supports you, who asked you to stop, and who is actually in charge of the list.

A laptop, a clipboard with lined paper and a notebook on a desk

Most local campaigns in Illinois end up with three lists by default. Correcting this requires early decisions rather than technical staff. The campaign should decide that there is one record per voter, that consent (a voter's permission to receive texts) is written down with a date, and that the campaign, not any one volunteer, owns the data.

The problem of three spreadsheets

Typically, petition season begins and someone types up the names from the signed sheets so the campaign can see who signed. When the canvass begins, the door-knocking app or a volunteer keeps a second list of who was home, who was friendly and who wants a yard sign. When texting begins, the texting service builds a third list of who replied.

Each list is useful on its own, but together they cause several problems:

  • Duplicates. The same voter appears as "Bob Miller" on the petition list, "Robert Miller" in the door results and a bare phone number in the texting service. No one can easily tell that these entries are the same person.
  • Contradictions. One list says a voter is a strong supporter; another says they asked not to be contacted. Whoever prepares the next list may not see the second note.
  • Wasted effort. Volunteers knock on doors that were already marked moved or deceased in a different file, or text people who already told a canvasser they had voted early.
  • No history. When a voter calls the candidate, nobody can quickly see what the campaign has already said to them.

These problems usually become costly late in the race, when time is shortest. A single, accurate record allows a small team to act on what it already knows. A CRM is a shared contact database that keeps each person's details and history in one place, and our guide to a political campaign CRM covers the broader case for this approach.

What one record per voter looks like

Dana Whitfield

Precinct 12 · Tags: volunteer, yard sign

  1. CoreCNXMoved to stage: VolunteerToday
  2. CampaignCNX+SMS replyYesterday
  3. CoreCNXOpened email: Volunteer orientation on Thursday3 days ago
  4. AlmaSubmitted info via chatbot: name, email, phone1 week ago
  5. BeaconDoor knocked, Contacted2 weeks ago
  6. CoreCNXNote: Asked about a yard sign. Prefers texts to calls.2 weeks ago
A sample record. The person and the events are made up, and each line uses the wording the timeline gives that kind of event.

A single voter record has two parts: the facts that rarely change, and a timeline, which is a dated history of everything that happened.

The stable facts

  • Name, address, precinct and ward or township.
  • Phone and email, if you have them, and where each came from.
  • Party primary history, if your campaign has access to it.
  • Tags, which are labels you choose, such as supporter, volunteer, yard sign, petition circulator or election judge recruit.

The timeline

Each event goes on the record with a date and a source:

  • Petitions. That they signed, which sheet, and who circulated it. Remember that Illinois candidate petitions are signed in ink on the official form with a notarized circulator statement; the record notes the paper petition but does not replace it.
  • Doors. Door results (contacted, not home, refused, moved, deceased, inaccessible, come back later, left literature), appointments and contact status.
  • Texts. Each message sent, each reply, and any opt-out (a request to stop receiving texts).
  • Everything else. An event they attended, an email they answered, a question they asked on your website.

When all of that is kept on one timeline, a volunteer can look up a voter before knocking and see the last three things that happened. This is the main purpose of keeping a single record.

Consent tracking belongs on the record

A combined record matters most for texting, because the rules are strict and a mistake can put your phone number and your reputation at risk.

A petition signature is not texting consent

Signing a nominating petition is not, by itself, permission to receive texts. A petition sheet or sign-in sheet counts as consent to receive texts only if the sheet says so plainly and the date is recorded. If your sheets did not include that language, do not treat the signers as a texting list. You can still knock on their doors and thank them in person.

Record the source and the date

For every phone number, note where it came from and when consent was given: a sign-up form with clear texting language, a sign-in sheet that said so, or a reply in which the voter asked to hear from you. That detail should be kept on the voter's record rather than in a separate file that someone might not check.

Opt-outs must apply everywhere

Before you text someone who signed a sheet

  1. Check the wordingThe sheet must say plainly that the person agrees to receive texts. A petition signature alone is not consent.
  2. Record the date and sourceNote on the person's record when they agreed, and on which sheet or form.
  3. Text only those who agreedReach the other signers at the door instead.
  4. Honor every opt-outA STOP reply or an unsubscribe applies to the person, wherever you send from.
Consent belongs to the person, not to one list.

When someone replies STOP, that request must apply to the person and not only to one list. CampaignCNX+ handles STOP replies automatically inside the texting service. Keeping one record also prevents that person from appearing again on a new list built from an old spreadsheet. If a voter told a canvasser at the door that they do not want texts, that note belongs on the same record as well.

Verification for political texting

If your campaign sends texts from registered business numbers, Campaign Verify, a verification service for political texting, applies to candidates, parties, PACs and committees registered with the FEC or a state or local election authority. It costs $95 per two-year cycle and requires an EIN (an Employer Identification Number from the IRS) and a published election-authority filing. Candidates with no committee are not eligible, which is one more reason to set up your committee early.

Data ownership: decide it on day one

Voter records often stay with the volunteer who built the spreadsheet. A precinct list is stored in someone's personal Google Drive, the texting account is on a staffer's credit card, and the door results are stored in an app that a friend set up. When that person moves on, the campaign loses that history.

A few decisions prevent this:

  • The committee owns the account. Set up your CRM, canvassing and texting accounts under the campaign committee, with at least two people who can sign in as administrators.
  • Volunteers get access, not ownership. Give volunteers the access they need for their turf (the area assigned to them) and their tasks, and remove it when they leave.
  • Know what happens after election day. Decide whether the list will carry forward to the next race, pass to a successor, or be closed out, and who makes that call.
  • Respect what voters told you. Opt-outs and "do not contact" notes should stay with the record wherever it is used.

None of these steps is complicated, but they are much easier to set up before the first petition sheet comes back than to correct in October.

How CoreCNX keeps the record together

A woman typing a message on a pink smartphone

CoreCNX is the CRM in the CNX suite. It gives you one contact record per person, and each record's timeline collects text replies and chatbot sign-ups, and door-visit results and email activity. Instead of comparing three files, you can look up one person and see their history in order.

The suite is designed so that the tools you use in the field add to that record:

  • Beacon (beaconcnx.com) is the canvassing app. It guides volunteers from door to door and records door results, ratings, notes and survey answers. It also works without an internet connection and updates the shared records when the device reconnects. During petition season, a survey question can record "signed: yes/no" at the door, so the canvass records and the petition records agree.
  • CampaignCNX+ (campaigncnx.com) handles two-way texting. It processes STOP replies automatically, schedules messages around quiet hours (the times when texts should not be sent), and files the required carrier registration for you. Carriers are the phone companies, such as AT&T, Verizon and T-Mobile. Replies appear on the same voter record as events, and door results join them.

The result is a single place to answer the questions that matter late in a race, such as who signed, who supports you, who asked you to stop and who has not yet been reached.

If you work closely with precinct committeepersons, our post on how CoreCNX supports precinct committeepersons shows how the same record approach helps them keep a precinct's history from one election to the next. For campaigns specifically, see our political campaigns page.

A simple setup checklist

  1. Create the campaign's CRM account under the committee, with two administrators.
  2. Import, or load, your most complete existing list first, and combine duplicate records before adding the next one.
  3. Add petition signers as notes on records, with the sheet and circulator, and do not mark them as texting consent unless the sheet said so and was dated.
  4. Run your canvass and texting from tools that share one contact record, so door results and replies are added to the same people's records.
  5. Write down who owns the list after election day.