Import Prospects in Bulk

1. Navigate to the Nonprofit Management > Prospective Nonprofit Administrators area.

2. Click on the Import Prospects tool.

3. In the Import Outreach screen, click on the Download template button in Step 1: Download.

   

The template for the Outreach Import File automatically downloads as a CSV file named ImportOutreachTemplate.csv.

1. Enter the information for each prospect in the CSV file, including:

   • YC Charity ID - This is required.

   • Admin First Name

   • Admin Last Name

   • Admin Email - This is required.

   • Admin Department ID - This is optional. Click on the Download Admin Departments link in the Import Outreach screen to download a key.

   • Prospect Source ID - This is optional. Click on the Download Prospect Sources link in the Import Outreach screen to download a key.

   • Outreach Reason ID - This is required. Click on the Download Outreach Reasons link in the Import Outreach screen to download a key.

1. Return to the Import Outreach screen and take the following actions.
   

   1. Click on the Select file button to find and upload the completed file. The file will be automatically validated for proper formatting and required fields upon upload.

   2. Correct any errors that appear. Errors will be listed on the screen and can be downloaded by clicking on the Download errors button.

   3. If any changes were made, reupload the corrected file and verify the information before importing the data.

2. Click on the Import data button to finalize the import and invite the prospective administrators.

Upon import, an invitation email will be automatically sent to all individuals in the file. For more information about the emails sent based on the specific outreach reason, see Preview Outreach Emails.

Tip: If there are any errors discovered in the import file, you will receive an email message with details of each prospect record that has an issue. All prospect records with no issues will be imported and processed. Any with an error will need to be corrected and imported again.

The Admin Department ID indicates the department in which the individual works at their organization.

Tip: This ID can be included in the Outreach Import File when importing prospects in bulk. You can find them by clicking on the Download Admin Departments link in the Import Outreach screen. Likewise, it can be selected in the New Prospect screen when adding prospects individually.

The Outreach Reason ID specifies the purpose of contacting the individual and their organization. This is required as it determines the type of outreach email that's sent.

Tip: This ID must be included in the Outreach Import File when importing prospects in bulk. You can find them by clicking on the Download Outreach Reasons link in the Import Outreach screen. Likewise, it must be selected in the New Prospect screen when adding prospects individually.

The Prospect Source ID denotes where the individual's contact information originated from. This is optional.

Tip: This ID can be included in the Outreach Import File when importing prospects in bulk. You can find them by clicking on the Download Prospect Sources link in the Import Outreach screen. Likewise, it can be selected in the New Prospect screen when adding prospects individually.