Using the CRM Migration Tool

CRM migrations require good data preparation to ensure success. It is crucial that the data to import is in the proper format for the migration to be completed in a timely manner.

Poor formatting could lead to failed imports, conflicting data and additional efforts correcting data.

This is the responsibility of the customer and can take hours of work.

Constant Contact's Lead Gen & CRM Migration Tool relies on a step-by-step process for importing each of the five possible areas. This allows you to add data in and ensure that all of the data relationships are correctly maintained.

This article will detail how to use the CRM Migration Tool.

---

Article Contents

• Preparing to Migrate
• Migration Process: Introduction
• Migration Process: Accounts
• Migration Process: Contacts
• Migration Process: Opportunities
• Migration Process: Campaigns
• Migration Process: Campaigns and Contacts
• Migration Process: Campaigns and Opportunities
• Migration Process: Notes
• Migration Process: Notes and Opportunities
• Migration Process: Notes and Contacts

Available With:

Trial	✓
Essential	✓
Advanced	✓
Ultimate	✓

Toolbar:

Contacts

Users:

Administrators	✓
Company Managers
Marketing Managers
Sales Managers
Salespersons
Jr. Salespersons

Preparing to Migrate

The CRM Migration Tool has strict data integrity standards that may prevent incomplete data from being imported. Make sure to upload all available leads, contacts, accounts, opportunities, and the like. 

To set up the process for a CRM migration, Prepare the necessary .CSV files for migration and do the following:

1. Click Contacts in the left toolbar.
2. Click    Options > Import Contacts.
   
   

   Click to enlarge.

3. Click CRM Migration Tool on the Import Contacts page.
   
   

   Click to enlarge.

4. Click each of the six sections to complete the multi-step migration process:
   • Introduction
     
   • Accounts
   • Contacts
   • Opportunities
     
   • Campaigns
     
   • Notes
   
   

   Click to enlarge.

Before uploading files to the Migration Tool, ensure the .CSV files have proper relationship mappings.

If an opportunity or other type of record is mapped to a lead or contact that does not exist in Lead Gen & CRM, the record will not be imported.

Important: Read both this article and Understanding CRM Migration Tools prior to beginning the migration process to help ensure a smooth migration.

Note: Click Skip Section to skip any optional sections that do not apply to your CRM migration. Click Reset Section to clear mappings and upload a new .CSV file to a section.

Migration Process: Introduction

To fulfill the requirements for the Introduction section, do the following:

1. Carefully read the information and instructions listed.
   
   

   Click to enlarge.

2. For Salesforce migrations, click the Is this a Salesforce migration? checkbox.
3. Select the appropriate delimiter from the Select delimiter drop-down menu.
4. Select the appropriate date format from the Select date format drop-down menu.
5. Select the appropriate time format from the Select time format drop-down menu.
6. Click Complete Section only after reading the information and instructions.
   
   

   Click to enlarge.

Note: Select the Is this a Salesforce migration? checkbox for Salesforce migrations to validate that the CRM IDs in your .CSV files are in the required 18-character format during the import process.

Migration Process: Accounts

To fulfill the requirements for the Accounts section, do the following:

1. Ensure your Accounts .CSV file has following fields:
   • Account Name
   • Account CRM ID
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File and select your Accounts .CSV file.
   
   

   Click to enlarge.

6. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
7. Click Complete Section.
   
   

   Click to enlarge.

Note: You can also click the Make Custom Field box to import the column as a custom field.

Migration Process: Contacts

To fulfill the requirements for the Contacts section, do the following:

1. Ensure your Contacts .CSV file contains the following required fields:
   • Account Name or Account CRM ID
     
   • Contact CRM ID
     
   • Email Address
     
   • First Name
     
   • Last Name
     
   • Is Unsubscribed
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Contacts .CSV file.
7. Select the appropriate option from the drop-down menu in the How Should We Handle Duplicates? section.
   
   

   Click to enlarge.

8. In the field text boxes, select the appropriate fields to map to. Repeat as necessary for all applicable fields.
   
   

   Click to enlarge.

9. Click Complete Section.

Accounts referenced in the Contacts .CSV file must already exist in Lead Gen & CRM or in the Accounts .CSV file.

Note: You can also click the Make Custom Field box to import the column as a custom field. When syncing with Salesforce, only map the fields to store for each contact. Do not map every custom field within your .CSV file.

Migration Process: Opportunities

To fulfill the requirements for the Opportunities section, do the following:

1. Ensure your Opportunities .CSV file contains the following required fields:
   • Account Name or Account CRM ID
   • Amount
   • Close Date 
   • Closed 
   • Opportunity CRM ID
   • Opportunity Name
   • Owner Email Address
   • Primary Contact Email Address/Contact CRM ID 
   • Probability 
   • Stage 
   • Won
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Opportunities .CSV file.
7. Select the appropriate lead owner from the drop-down menu in the Default Owner section.
8. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
   
   

   Click to enlarge.

9. Click Complete Section.

Special Considerations

When importing, be aware of the following:

• The system will check your instance for a deal stage with the same name. If no such deal stage exists, it will be created.
• If you will be importing stages for multiple pipelines, you should create these pipelines in Lead Gen & CRM prior to import. This will ensure the deal stages are added to the correct pipeline.

Note:

• Required fields must have a value and cannot be blank. Be aware that custom fields you set as required will need to be included in your .CSV file.
• The Close Date field is a Date Time field that contains both the date and time in the following formats:
  • Date Format:
    01/13/2018
  • Time Format:
    12:30:00 PM
• The Closed and Won field values can be either
  1 (True) or 0 (False).
• Do not include the following:
  • Commas (,) in dollar value fields.
  • Monetary symbols ($) for opportunity amounts.
  • Percentage symbols (%) for probabilities.

    Including these will cause an error on import.

• Click the Make Custom Field box to import the column as a custom field.

Migration Process: Campaigns

Following opportunity importing, campaigns can also be introduced into Lead Gen & CRM and successfully attached to the Contacts or Opportunities to which they relate. However, this process is more complex and will require three separate .CSV files. The three .CSV files are Campaigns, Campaigns and Contacts, and Campaigns and Opportunities.

To begin fulfilling the requirements for the Campaigns section, do the following:

1. Ensure that the Campaigns .CSV file has the following required fields:
   • Campaign CRM ID
   • Campaign Name
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Campaigns .CSV file.
7. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
   
   

   Click to enlarge.

Migration Process: Campaigns and Contacts

Once the Campaigns file has been chosen, do the following:

1. Ensure that the Campaigns and Contacts .CSV file has the following required fields:
   • Campaign CRM ID
   • Contact CRM ID
   • Member First Association Date
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Campaigns and Contacts .CSV file.
7. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
   
   

   Click to enlarge.

Important: While a Campaign CRM ID and a Contact CRM ID can be the same across two separate columns of a .CSV file, the migration will not work if the same CRM ID is repeated in a single .CSV column.

Migration Process: Campaigns and Opportunities

Once the Campaigns and Campaigns and Contacts files have been chosen, do the following:

1. Ensure that the Campaigns and Opportunities .CSV file has the following required fields:
   • Campaign CRM ID
   • Opportunity CRM ID
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Campaigns and Opportunities .CSV file.
7. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
8. Click Complete Section.
   
   

   Click to enlarge.

Migration Process: Notes

The final step of the migration process is optional. If you do not want to add notes, click Skip and Import.

To begin fulfilling requirements for the Notes section, do the following:

1. Ensure your Accounts .CSV file has following fields:
   • Account CRM ID
   • Create Date
   • Note Description
   • Owner Email Address
     
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Accounts .CSV file.
7. Select the appropriate lead owner from the drop-down menu in the Default Owner section.
8. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
   
   

   Click to enlarge.

Note: The Create Date field has the following formats:

• Date Format:
  01/01/2018
• Time Format:
  12:30:00 PM

Two notes for the same opportunity or account cannot have the same date and time. This will cause a conflict and will only import the last note.

Migration Process: Notes and Opportunities

Once the Accounts Notes file has been chosen, do the following:

1. Ensure your Opportunities .CSV file has following fields:
   • Create Date
   • Note Description
   • Opportunity CRM ID
   • Owner Email Address
     
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Opportunities .CSV file.
7. Select the appropriate lead owner from the drop-down menu in the Default Owner section.
8. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
   
   

   Click to enlarge.

Note: The Create Date field has the following formats:

• Date Format:
  01/01/2018
• Time Format:
  12:30:00 PM

Migration Process: Notes and Contacts

Once the Accounts Notes and Opportunities Notes files have been chosen, do the following:

1. Ensure your Contacts .CSV file has following fields:
   • Contact CRM ID
   • Create Date
   • Note Description
   • Owner Email Address
     
2. Select the appropriate delimiter from the Select delimiter drop-down menu.
3. Select the appropriate date format from the Select date format drop-down menu.
4. Select the appropriate time format from the Select time format drop-down menu.
5. Click Choose a File.
   
   

   Click to enlarge.

6. Select your Contacts .CSV file.
7. Select the appropriate lead owner from the drop-down menu in the Default Owner section.
8. Select the appropriate fields to map to in the field text boxes. Repeat as necessary for all applicable fields.
9. Click Import.
   
   

   Click to enlarge.

Note: The Create Date field has the following formats:

• Date Format:
  01/01/2018
• Time Format:
  12:30:00 PM