To determine if a contact is an existing contact, DonorDock uses one of the following fields. If none of these four scenarios are met, a new contact is created.

⭐ Donor ID

⭐ Account Number

⭐ First Name, Last Name and Email

⭐ First Name, Last Name, and First line of Address

When adding new contacts in an import, at least 1 of the following fields is required:

⭐ Account Number

⭐ Company/Household Name

⭐ First Name

⭐ Last Name

If all 4 of these fields are blank on the document you are importing, the import process will skip the row in question with the incomplete data and move on to the next row in your document. When an import has been completed, you may scroll all the way over the to the right and click on errors to see any rows that might have been skipped due to incomplete data.

When creating new gifts in an import, the following fields are required:

⭐ Gift Date

⭐ Gift Amount

⭐ Minimum identifying information as to the contact the gift is from

DonorDock Data Field Name	Description	Our Values	Required
Donor ID ⭐	A unique ID for the donor. If importing from an external system, this can be the external ID. If re-importing contacts from DonorDock with bulk edits, this can be the DonorDock Donor Id.	Alphanumeric	Contact Required Field ⭐
Account Number ⭐	The account number for a contact. If the account number exists in DonorDock this can be used to import updates to existing contact records. Account number can be used for integration to accounting systems, or as a friendly ID. Account Numbers can be set to be automatically assigned in your organization settings.	Alphanumeric	Contact Required Field ⭐
Contact Status	Indicates the status of the contact being imported	Active, Inactive, Archived	Optional
Contact Type	The type of the contact	Individual, Organization, Household	Optional
Company/Household Name ⭐	The name of a business, organization, or household that you are importing. If this value is filled, the imported donor will be marked as an organization, not an individual contact.	Alphanumeric	Contact Required Field ⭐
First Name ⭐	Contact's First Name	Alphanumeric	Contact Required Field ⭐
Middle Name	Contact's Middle Name	Alphanumeric	Optional
Last Name ⭐	Contact's Last Name	Alphanumeric	Contact Required Field ⭐
Email	Contact's Email Address	Valid Email Address	Optional
Main Phone	Contact's Main Phone Number	Valid Phone Number	Optional
Address Line 1	Contact's First Line of Address	Alphanumeric	Optional
Address Line 2	Contact's Second Line of Address	Alphanumeric	Optional
Address Line 3	Contact's Third line of Address	Alphanumeric	Optional
City	Contact's City for Address	Alphanumeric	Optional
State or Province	Contact's State or Province for Address	Alphanumeric	Optional
Postal Code	Contact's Postal Code for Address	Alphanumeric	Optional
County	Contact's County for Address	Alphanumeric	Optional
Secondary City	Contact's City for Address	Alphanumeric	Optional
Secondary State or Province	Contact's State or Province for Address	Alphanumeric	Optional
Secondary Postal Code	Contact's Postal Code for Address	Alphanumeric	Optional
Secondary County	Contact's County for Address	Alphanumeric	Optional
Secondary Country	Contact's Country for Address	Alphanumeric	Optional
Business Phone	Contact's Business Phone Number	Valid Phone Number	Optional
Mobile Phone	Contact's Mobile Phone Number	Valid Phone Number	Optional
Fax	Contact's Fax Number	Valid Phone Number	Optional
Website	Contact's Website	Valid URL	Optional
Spouse First Name	First Name of Contact's Spouse	Alphanumeric	Optional
Spouse Last Name	Last Name of Contact's Spouse	Alphanumeric	Optional
Spouse Email Address	Email Address of Contact's Spouse	Valid Email Address	Optional
Spouse Buisness Phone	Business Phone number of Contact's Spouse	Valid Phone Number	Optional
Spouse Mobile Phone	Spouse Mobile Phone	Valid Phone Number	Optional
Number of Children	Number of Children Contact has with Spouse	Alphanumeric	Optional
Do Not Solicit	Indicates if a contact does not want to be solicited.	X, 1, True, Y, False	Optional
Bad Address	Indicates if a contact's address is incorrect.	X, 1, True, Y, False	Optional
Deceased	Indicates if a contact is deceased	X, 1, True, Y, False	Optional
Unsubscribed	Indicates if the contact has unsubscribed. This will remove them from receiving marketing lists.	X, 1, True, Y, False	Optional
Description	A general description of the contact.	Limit 1500 characters - Alphanumeric	Optional
Affiliation	Any affiliation the contact may have.	Alphanumeric	Optional
Badges	A comma-separated list of badges for this contact	Comma separated list - Alphanumeric	Optional
Marketing Lists	A comma-separated list of marketing lists for this contact.	Comma separated list - Alphanumeric	Optional
Household	The household the contact belongs to. If a matching household is found, the contact will be added to the existing household. If no match is found, a new household will be created.	Alphanumeric	Optional
Household Role	The contact's role in the household.	Alphanumeric	Optional
Job Title	Job Title of the Contact	Alphanumeric	Optional
Employer	The employer the contact works for. If a matching employer is found, the contact will be added to the existing employer. If no match is found, a new employer will be created.	Alphanumeric	Optional
Special Circumstances	Any unique circumstance or exception for a contact. This can also be used to provide your team instructions on how to engage a contact.	Limit 1500 Characters - Alphanumeric	Optional
Gift ID	A unique ID for the gift. Can be an ID from an external system.	Alphanumeric	Optional
Gift Date ⭐	The Date the Gift was Received	Valid Date Format MM/DD/YYYY	Gift Required ⭐
Campaign	The name of the campaign that the gift is associated to. The import uses an exact name match to find an existing campaign. If no match is found, a new campaign is created.	Alphanumeric	Optional
Appeal	The name of the appeal that the gift is associated to. The import uses an exact name match to find an existing appeal. If no match is found, a new appeal is created.	Alphanumeric	Optional
Fund	The name of the fund that the gift is associated to. The import uses an exact name match to find an existing fund. If no match is found, a new fund is created.	Alphanumeric	Optional
Gift Type	Type of Gift	Donation, Membership, Event Ticket	Optional
Payment Type	The type of payment that is being imported.	Cash, Credit Card, Check, In Kind, Stock, ACH, PayPal, Payroll, Other	Optional
Soft Credit Amount	Amount of Soft Credit	Valid decimal value that is greater than or equal to 0 or left blank	Optional
Country	Contact's Country for Address	Alphanumeric	Optional
Owner	The email address of the DonorDock user you would like to assign this contact to.	Valid Email Address	Optional
Title	The honorific or job title of the donor you are importing.	Alphanumeric	Optional
Addressee	The addressee is the format of the name in the address block on the letter. This would likely be used in mail merge applications.	Alphanumeric	Optional
Salutation	The format of the name you want to use in greetings of your correspondence.	Alphanumeric	Optional
Suffix	Follows the name and provides additional information about the person. Examples would be Jr., Sr., PHD	Alphanumeric	Optional
Nickname	Nickname that the contact prefers to be called	Alphanumeric	Optional
Former Name	Name contact previously held	Alphanumeric	Optional
Birthday	Birth date of contact	Valid Date Format MM/DD/YYYY	Optional
Secondary Email	Secondary Email Address for user	Valid Email Address	Optional
Secondary Address Line 1	Contact's First Line of Address	Alphanumeric	Optional
Secondary Address Line 2	Contact's Second Line of Address	Alphanumeric	Optional
Secondary Address Line 3	Contact's Third line of Address	Alphanumeric	Optional
Former Name	Name contact previously held	Alphanumeric	Optional
Birthday	Birth date of contact	Valid Date Format MM/DD/YYYY	Optional
Secondary Email	Secondary Email Address for user	Valid Email Address	Optional

Setup Essentials Checklist

Setup Essentials Checklist