ClickDimensions Import Tool

Access the Import Wizard

There are three different ways you can access the Import Wizard to get started.

1. Access the Import Wizard from the toolbar in Audience > Marketing Lists or the toolbar in a Marketing List record.
   
   
   
   
2. Access the Import Wizard from the toolbar in Web and Events > Events or the toolbar in an Event record.
   
   
   
   
3. Or navigate to Settings & Support > ClickDimensions Settings > ClickDimensions Imports, create a new Import record, and click ClickDimensions Import within that record.
   

Click ClickDimensions Import to start the wizard.

NOTE: You may not see this button if your CRM security role does not include the Create Privilege for the ClickDimensions Import record.

Upload Your Data

When the wizard loads, you will see the following screen:

Import Template

To begin, first download our import template. Click Download Excel Template, save the file, and fill it out on your computer.

Note: It is important not to edit the default column headers of the import template. Editing these headers in any way can result in the import attempt failing.

The columns on the Import Template show the fields that can be updated via an Import. As of version 10.7, it is now possible to include custom text fields from Contacts/Leads within the Import Template. Version 12.1 added the ability to include Lookup and Option set fields within the Import Template as well. In order to do this, you will need to add new columns to the import template file based on the schema name of the text field that you are trying to map to. This can be obtained by checking the field properties for this field and a CRM admin or CRM partner may needed to help find this schema name.

To find the schema name navigate to Settings Icon on Ribbon Menu > Advanced Settings > Customizations > Customize the System > Entities > Lead or Contact Entity > Fields.

For example:

Once you have the schema name, it can be added as an additional column like this:

Note: For out of the box fields where schema names are not applicable you should use the display name. For new fields it should use the schema name.

Handling Specific Fields

1. Email (or Email 1) is required. Imported records without this primary email field will fail so you need to include this piece of data in order to successfully import the other fields. 
2. Company Name is a lookup field in CRM. The value you import to this field will need to match the name of an existing Account exactly in order for the field to map properly.
3. The Owner field requires the full name and may require additional permissions. You should type the full name of the desired Owner record as it appears in CRM. This user will also be set as the Owner of any created Event Participation records when using the Create Event Participation Records option, so you will need to ensure that these users have the ClickDimensions User security role or another security role that grants Create privileges for the Event Participation entity.
4. The Lead Source field will automatically pull in the default and custom values from the Lead Source field. This is based off of the Lead Source field (schema name: leadsourcecode) in CRM. You will not be able to add any new values within the Excel import template itself. If there are any missing options, then please try publishing metadata and then re-download the import template to see if this adds the options.

Note: Please make sure that you remove any hyperlinks from the email addresses in the Email column. Failing to remove these may cause the import to fail due to the formatting caused by the links. To do this, you can highlight your emails in Excel, right-click, and then use the Remove Hyperlink option:

Opt-In Subscription Management

When importing in an Opt-In environment, three additional fields are required for your import to be successful—Subscription - Method of Submission, Subscription Preference, and Subscription - Submitted On (MM/DD/YYYY).

Once your data is ready, upload your completed template and click Next. If the spreadsheet that you selected is empty, upon clicking Next, the import wizard will display an error message to alert you of the issue.

Choose How to Map Your Data

The import tool will check each email address listed in spreadsheet against existing Leads and Contacts in the system through a validation that checks the email address field in CRM. If the email address already exists in your system, you can choose whether to pull over the other information listed for that person and overwrite the data already in the Lead or Contact record.

Overwrite fields in CRM

This will overwrite all data in the Lead or Contact with the data in the uploaded file.

Only fill in blank fields

If data already exists in the Lead or Contact record, the system will leave it, but will fill in any blank fields with corresponding data from the uploaded file.

Do not map anything

Don't push any data from the uploaded file into Leads or Contacts.

New Records

Choose Lead or Contact as the record type for any new records to be created. New records will be created when there are email addresses that don't match any existing records.

Backup Owner

While you can specify an Owner in your uploaded file, it's necessary to specify a backup Owner record just in case we can't find a match between the listed value and your CRM in the import.

Choose Actions

These actions will be applied to everyone on the uploaded file, regardless of whether they existed in the CRM previously or not.

Create Event Participation Records

Choose an Event in the system and we'll automatically generate an Event Participation record associated to your Event for each person on your uploaded file. You can select multiple Events here.

Add all to Marketing List

Everyone on the uploaded file will be added to these Marketing Lists in CRM. We recommend specifying two Marketing Lists here, one for Leads and one for Contacts. Please note that these Marketing Lists will need to be Static. You can select multiple Lead or Contact Marketing Lists as well.

Remove all from Marketing List

Everyone on your list will be removed from the following Marketing Lists in CRM. Again, it's best to supply both a Lead and Contact list and only Static Marketing Lists can be supplied here. You can also choose multiple Lead or Contact lists.

Create/Update Current Subscriptions

NOTE: The Create/Update Current Subscriptions option is only available to customers who are are utilizing the Opt-In Subscription Management Method.

Create Posted Preference records for a Subscription List for each member of the Import. Once you check Create/Update Current Subscriptions, you will be prompted to specify the Subscription List for which preferences will be created. Only one Subscription List can be specified per Import, so if you need to upload preferences for multiple Subscription Lists, a separate Import will need to be run for each list.

Any Posted Preferences created via the ClickDimensions Import Tool will also be recorded in the cloud to manage opt-in and opt-out preferences. This is discussed in more detail here.

Review and Import

Click Next to review all your settings and make sure they're correct. If anything needs to be corrected you can click Previous to go back and fix it.

If you are trying to add or remove members from a Marketing List, but the list is locked, the following error will display to let you know that the list must be unlocked:

For assistance on locked marketing lists, see this help article.

Finally, input an email address so the import can send you a message to let you know if the process finished correctly or if it ran into any errors.

Click Finish when you're ready to proceed and you'll see a confirmation screen. Your import has started and you'll get an email to the specified address once it's been completed.