This post was updated on June 1, 2021.
Stop! Before you go any further, let’s make one thing clear: we can do the entire mapping portion of the Wizard Migration for you.
In fact, we can do the ENTIRE Wizard Migration for you from start to finish. So, before you read a full article on how to map objects and fields, think about whether or not you want to spend time doing so. If you do, please keep reading. If not, use our Guided Service to keep your hands clean and let us do the dirty work for you. Download our free Guided Service Migration Handbook to learn what to expect.
If you’re still reading this, we’re excited to help you understand the mapping process for your CRM data migration. You’ve probably visited our Wizard tool to perform a migration on your own, so let’s clear the air on the mapping process.
Fields Mapping and the Migration Wizard
Our Wizard serves any level of technical knowledge. It’s an easy way to get data migrated from point A to B. No complexities, no customization, just a simple method of transferring data at a fair price and with a quick turnaround.
The process of using the Wizard tool is easy and automated. The mapping process is typically where people get stuck, either because they don’t know how to match their objects and related fields or intimidated by the migration process.
Luckily, automation is included in the mapping portion. Our system will map your fields by linking the fields based on the closest name match. However, if the auto-mapping isn’t sufficient, you’ll have to remap them on your own. We’re here to teach you how.
Elements of Customized Mapping
(We include this in the interface to allow you to make informed decisions about the mappings. For example, you probably don’t want to map a String field to a Date field, as these would likely be incompatible.)
- String: Text field/drop-down field (there are restricted and unrestricted drop-down fields inside CRM)
- Number: A field with an integer value
- Decimal: A field with a formatted number
- Date: A field with a date value
- Datetime: A field with the date and time value
- Time: A field with a time value
- Native: default/standard fields in the CRM
- Custom: Fields that CRM users added
On the left corner of the mapping page, you will see the drop-down menu with different filters. You can filter records according to these filter types:
- Mapped: The source CRM fields that were successfully mapped
- Unmapped: The source CRM fields that are still unmapped
- Custom: All custom fields that CRM members added
- Native: All native fields that existed in source CRM from scratch
Read more about how to use filters here.
Drop-down field mapping allows you to map dropdown fields between the source and target CRM. You will have to match the dropdown values/ picklist options to populate dropdowns in the target CRM with the correct values. If there is no matching value in the target CRM dropdown field, you can create one or select the most appropriate existing one.
This mode allows you to:
- Find out the types of fields in your source and target CRMs that correspond.
- Check if the field is native or custom by hovering over the ‘i’ icon (also available in Simple Mode)
- Check field visibility in CRM UI, meaning see if the field is displayed to the users in the source and/or target CRM.
- Check the field usage in your source CRM.
- Match dropdown fields values (you can do this with Simple Mode as well)
- Perform advanced mapping for complex fields (similar fields of the same type, like work phone, home phone, mobile phone, etc.)
In the mapping platform, a complex field is defined as a block containing a mapping of multiple fields with a similar context. For example, the “phone number” complex field may include multiple fields such as home phone number, work phone number, and mobile phone number, each mapped to one or several phone number fields.
Sometimes, the source and target CRMs function differently. The field in the source CRM may have multiple values, while the target CRM field can have only one value.
The purpose of complex fields is to let you map similar fields most efficiently. That way, you don’t have to add as many corresponding fields in the target CRM.
To map complex fields in the object mapping stage, you have to match the fields inside of each complex field. See how a matched complex field appears on the mapping page within our tool, along with each field type here.
Field usage shows the number and percentage of usage of each field within the CRMs. This allows you to make informed decisions about which fields to map across so that you don’t map fields that aren’t used.
This is also useful when matching fields inside of a complex field. In CRMs where the field can contain multiple values, there is often a situation where you may not know whether the field was used widely or not. Based on this, you could better decide how to match fields to capture the most data. Here’s an example of how to map fields inside of the ‘Phone’ complex field:
In this example, an Office phone can have up to 7 fields, and you can see how widely these fields are used. Office phone 1 is used in 90% of records, and office phone 2 is used in 9% of records, and so on. This will help you decide to map the Office phone twice or create a new order to get its data captured as much as possible:
To find a specific field quickly, use the search bar under record names. You can reset mapping to have your data fields auto-mapped using the most common logic. But your mapping from chosen objects will be dropped to its original state without the possibility of recovery. You can also refresh mapping to the current objects. Remember to save mapping to save your changes and proceed with the next steps.
For some CRMs, you can easily create custom data fields using our mapping system. (Yes, you can create your own!)
Steps to Create your Own Custom Fields
1. On the mapping page, click Unmapped Fields.
2. A window will open where you can map fields that weren’t automated. On the target CRM side, click Add Custom Field.
3. Choose a field type for your target CRM from the dropdown list. The custom field will appear in the list on the right-hand side so you can match it. **Please note that this option is available only for Accounts, Contacts, Opportunities, and Cases.**
4. Set the desired field name and description and click Add Custom Field.
Mapping is a crucial part of CRM data migration. At its core, it is the very foundation of the import and transfer of data. A map takes objects and fields where they need to go. A proper road for each field is paramount to find its corresponding location.
If you find that the mapping process isn’t for you, but you need it customized and tailored to your business structure, we can do the entire mapping process for you (re the rude awakening at the start of this article).
To understand more about how our Guided Service works, download our free guide. Just because it says “Self-Service” doesn’t mean you’re on your own.