If you are planning to migrate your company’s GoldMine® data into a CRM system, there are a number of questions that you can ask yourself as you start to plan a data migration. Coming up with answers to these questions can make your GoldMine data conversion a much easier experience.
Here’s a list of the more common questions that might be asked when an organization is planning to convert data.
- Approximately how many Contact records do we have in GoldMine?
- Do we have one record per company and are using Secondary Contacts in GoldMine, or do we have a separate record for each contact at a company — or a combination of both?
- Do we need History migrated? If so, approximately how many History records do we have in our GoldMine database?
- Do we want to migrate all History records will we have a cutoff date? (it often makes sense to exclude History records that are more than a few years old)
- Do we want our normal e-mail correspondence on the History tab migrated?
- Do we want to filter out specific types of History records during conversion, such as mail merges or mass emails?
- Do we need Notes migrated?
- Do we need Calendar Activities (from the Pending tab) migrated? (unless there are a large number of scheduled activities, it’s often not worth the time and effort to migrate these)
- Do we need user-defined and/or custom fields migrated? If so, approximately how many user-defined and/or custom fields do we have in our GoldMine database?
- Are there any fields that we aren’t using and that therefore should not be migrated?
- Do we have any large Lookup lists that should be changed into a link to a related table in a CRM system? (it often makes sense to change a large Lookup list into a lookup on a related table or object in a CRM system)
- Do we need any data normalized from a series of flat, duplicated fields into a Related List in a CRM system? (a major benefit to a CRM system is that it has a relational structure)
- Do we want to redefine the way in which we use any of the existing fields? (are there free form text fields that should become pick lists or lookups?)
- Do we need forecasted sales or opportunities migrated?
- Do we need Attachments migrated? If so, are all of our attachments in a single, shared folder — or are they in a variety of local and network folders?
- Do we need to replicate any integration with other systems in the new CRM system?
- How many active users do we have in GoldMine?
- Will all these users be licensed users in CRM?
- How many inactive users do we have in GoldMine for which we want to preserve Contact and/or History association in a CRM system?
Considering questions like these — up front — can help your organization get on a path toward a successful GoldMine data conversion.