This comprehensive guide details the process of importing intake opportunity data into your CRM system. Efficiently integrating new data is crucial for maintaining accurate records, optimizing your admissions pipeline, and ensuring a holistic view of potential clients. This procedure allows for bulk data entry, reducing manual effort and potential errors, while providing options for handling duplicate records to preserve data integrity.
1. Navigate to Intake Opportunities or Client Records: Begin by navigating to the "Intake Opportunities" section, typically found under the "Admissions" module. Alternatively, you may access this function via a specific "Client's Name" entry within the same module, depending on your CRM's customized configuration.
2. Initiate the Import Process: Once in the correct section, locate and click the "Import" button to commence the data import wizard.
3. Select Your Data File: Click on the "Select From My Computer" field. This action will open a file browser, allowing you to locate and select the data file (e.g., CSV, Excel) you wish to import.
4. Proceed to Next Step: After selecting your file, click "Next" to advance to the data handling options.
5. Choose Duplicate Record Handling (Dropdown Menu):
From the provided dropdown menu, you will be presented with critical options for managing potential duplicate records:
"Skip": Records in your import file that match existing records in the CRM will be ignored.
"Overwrite": Existing CRM records will be updated with data from matching records in your import file.
"Merge": Data from matching records in your import file will be combined with existing CRM records, typically updating empty fields or specific designated fields.
6. Select Appropriate Handling Option: Carefully review your specific import scenario and select the duplicate record handling option that best aligns with your data management strategy. Exercise caution during this step, as the chosen option directly impacts your existing data.
7. Define Data Filtering Fields: In the "available fields" section, select the categories or fields that your CRM system will use to identify and filter existing records during the import process. These fields act as the criteria for "scrubbing" or matching your incoming data against the current records.
8. Adjust Field Inclusion/Exclusion: Utilize the right-left arrow icon (often a double-arrow or similar indicator) to either add desired fields from the "Available Fields" list to the "Selected Fields" list or remove them, precisely defining your filtering criteria.
9. Proceed to Mapping: Click "Next" to move to the crucial data mapping stage.
10. Map Data Headers Accordingly: This is a critical step. You must accurately map the headers from your imported file to the corresponding fields required for "Intake Opportunity" or "Account" within your CRM. The exact field names and requirements may vary based on your CRM's configuration and client-specific settings; always verify these mappings.
11. Refine Field Mappings (Dropdown Menus): Use the dropdown menus provided for each field to select the most appropriate and accurate CRM field that corresponds to each column header from your imported data file.
12. Execute the Import: Once all headers are correctly mapped, click "Import" to initiate the data transfer process.
13. Finalize the Import: Upon completion of the import, click "Finish" to close the wizard and review the import results.