Download - The CRM Data Migration Process
![Page 1: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/1.jpg)
![Page 2: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/2.jpg)
Let’s talk about your data
![Page 3: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/3.jpg)
There are many sources of data...
![Page 4: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/4.jpg)
And many types of data to import.
Client Data
Agent Data
Policy Data
Carrier Data
Documents
![Page 5: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/5.jpg)
Are there gaps in your data?
Client Data● Names, phone numbers, addresses, SSN’s, email & client type● Lead sources & dates
Policy Data● Policy numbers● Effective, renewal, & term dates● Policy types● Premium amount
![Page 6: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/6.jpg)
Are there gaps in your data?
Agent Data● Names, phone numbers, addresses, SSN’s, email & client type● Contracts, licenses & E&O information
Carrier Data● Contact information● Forms, products, website information
![Page 7: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/7.jpg)
There are a few things to think about...
![Page 8: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/8.jpg)
Will your data “fit” in the new system?
Fields you’re currently tracking might not be available in the new system
Are custom fields available?
![Page 9: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/9.jpg)
Will there be formatting issues?
Dates not in “date” format
Numbers not in “numeric” format
![Page 10: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/10.jpg)
Garbage In, Garbage Out (GIGO)
“Garbage in, garbage out (GIGO) in the field of computer science or information and communications technology refers to the fact that computers, since they operate by logical processes, will unquestioningly process unintended, even nonsensical, input data ("garbage in") and produce undesired, often nonsensical, output ("garbage out").” - Wikipedia
In other words, you get out what you put in. Clean, organized data will result in clean, organized
output.
![Page 11: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/11.jpg)
So, how should you clean your data?
![Page 12: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/12.jpg)
Reorganize & Delete
Staging database○ De-Dup○ Reformat: dates, SSN’s, names
Delete unnecessary data○ Old entries○ “Garbage” data
Clean book-of-business = better customer support = happy customers!
![Page 13: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/13.jpg)
This process won’t be flawless
A “quick-and-dirty” approach to data migration will result in an unorganized CRM system.
Not all legacy data will make it to the new system - and that’s OK!
A strategic approach is recommended:○ Choose what gets left out○ Cut down on errors
![Page 14: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/14.jpg)
Change is unavoidable
![Page 15: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/15.jpg)
During migration...
![Page 16: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/16.jpg)
Test & Retest
Perform a trial run with the final spreadsheet
Involve actual users in testing the trial run - have them look at the data to be sure everything looks O.K.
![Page 17: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/17.jpg)
Things to consider...
![Page 18: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/18.jpg)
Ask Vendors
Cost for imports ○ Would it be easier to have vendor do it for you for a charge?
Timing ○ How long will it take for your data to be imported?
Format ○ What type of file does the vendor need?
Templates ○ Can the vendor provide you with what a “final” file should look like?
![Page 19: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/19.jpg)
Sample Data Format
![Page 20: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/20.jpg)
So, how does it work?
![Page 21: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/21.jpg)
“We know our software. You know your data.”
1. Stop making changes in your old systems while the data is imported to the new system
2. Clean up your data as much as possible - we can help!3. After import, check the AMS to be sure everything looks as it
should - we can also help with errors!
![Page 22: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/22.jpg)
Have any questions or want to know more?
![Page 23: The CRM Data Migration Process](https://reader033.vdocuments.us/reader033/viewer/2022051109/547eb47d5806b5b85e8b46b6/html5/thumbnails/23.jpg)
www.agencybloc.com
866-338-7075
Contact Us