Unique identifiers (IDs) are profile fields that may not occur in more than one profile within a nation. Unique IDs are used to merge information from imports with records already existing in the nation and for deduping records in your nation.
A person's profile in NationBuilder has several options for unique IDs:
- email address
The best unique ID on an import is an email address. If you do not have an email address for a specific person, you may use one or more of the other unique IDs. However, the other unique IDs must have a first name and last name mapped during the import in order for the signup record to be imported into the nation.
Once the import has finished newly imported people in the nation will have a nationbuilder_ID assigned to them.
There will be times when there isn't anything the importer recognizes as unique on import. In this case, you can create a unique ID for each record.
- Open the CSV file in Excel
- Insert a new column to the left of the existing columns
- Name that column "NationBuilder_ID"
- Leave the rest of the column blank
- Save the CSV file
- Import your file mapping the new column to "nationbuilder_ID" (for one time and voter imports) or "signup_nationbuilder_ID" (for donation imports)
If an attempt is made to import a person whose unique ID(s) already exist in the nation, NationBuilder will update the existing profile with the information from the import file instead of creating a new profile.
Voters in your nation may have one or more of these unique IDs:
- DW_ID (also known as Catalyst ID)
Donations have their own unique ID (donation_nationbuilder_id) along with one of the unique ID so NationBuilder knows who the donation belongs to. Donation imports connect the donor to the donation via the same fields used for a one time import. However, here is a slight difference for donations: each of these fields begins with "signup_".