Within the Settings area of Microsoft Dynamics CRM, you are able to set up the dotmailer email accounts that are to be used for sending emails, control the timings of automatic synchronisations between dotmailer and Microsoft Dynamics CRM and create custom data labels. These are administrative functions and should only be accessed and edited by the Email Campaign Manager.
Data labels can also be referred to as data fields; the two terms are interchangeable. In both Microsoft Dynamics CRM and dotmailer you are able to create any data labels you wish according to the information you want to hold about your contacts. This enables you to capture and retain additional information about your contacts which you can then use to search across your data and to create targeted campaigns. You can create as many custom fields as you wish and when created the custom data field is added to all the address books in your dotmailer account. Data labels created are not personal to the user who created them; they are available to any user accessing the account.
To access this functionality, select Settings from the menu bar, and then select Email Accounts.
Email Accounts screen
This screen displays the dotmailer email accounts that have been set up for use with Email Campaigns. You can create as many email accounts as you wish which can have multiple campaigns linked to them. However an Email Campaign is only ever linked to a single email account.
Creating a new email account
Step 1: Click New on the Email Accounts screen. A blank Email Accounts Information screen is displayed.
Step 2: Complete the fields on the General tab, selecting an appropriate and recognisable name for the account.
Step 3: Complete the fields on the Administration tab. The Owner field will default to the currently logged in user but is editable. Information for the Connector Key field is obtained from dotmailer during system set-up.
Step 4: No action is required on the CRM Fields (Global) tab. This tab displays all CRM fields for each of the entity types in the CRM system. The CRM fields displayed can be used for mapping to dotmailer data labels.(this is covered elsewhere in this document)
Step 5: Click Save and Close. The Email Accounts screen is displayed and the new record appears in the table.
Step 6: Click on a record to display the Email Account Information screen.
Email Accounts Information screen
To access this screen, click Settings in the menu bar, then Emails Accounts to display the Email Accounts screen. Click on the record you wish to view.
The screen is divided into a number of tabs. The main toolbar at the top of the screen contains an Email Settings button which is used to control the timings of automatic synchronisations. The menu can be used to view further information about the email account. Clicking an option in the menu bar refreshes the main body of the screen.
The main toolbar also contains two buttons that allow the setting up of the User mapping for the Automation Studio and also a test button for the Automation Studio.
Tabs on the Email Accounts Information screen
This tab displays the email Account Name and Description.
Displays the email account Owner and Connector licence key.
CRM Fields (Global) Tab
Displays all CRM fields for each of the entity types in the CRM system. The displayed data can be filtered by entity type or searched upon. Clicking on a record displays the CRM Field information screen.
The CRM fields displayed can be used for mapping to dotmailer data labels.
Menu Bar Options for the Email Accounts Information screen
Displays the main screen with General, Administration and CRM Fields (Global) tabs.
Displays all marketing lists which use the selected email account.
Displays all Email Campaigns which use this email account.
Displays all email send batches that have been sent using this email account.
Email Send Summaries
Displays a list of all targets that have been mailed from the selected email account.
Displays all email clicks across any campaigns which use this email account.
Email Data Labels
This section displays all dotmailer data labels that appear in your associated dotmailer account. Click on a row to display the Email Data Label Information screen. New data labels can be created from this screen by clicking the New Email Data Label button.
When the next synchronisation with dotmailer takes place, your new data labels will be created in dotmailer. You can also create new labels in dotmailer and the synchronisation process will bring them across to Microsoft® Dynamics CRM. The Synchronise Data Labels button can be used to perform an immediate synchronisation with dotmailer.
For more information about data labels and how they are created and used, see the Data Labels and Data Mapping section.
Email Data Mappings
This section displays mappings between CRM data and dotmailer data labels. You will need to create all required mappings upon initial system set-up.
Click on a record to display the Email Data Mapping Information screen.
For more information about data mapping and how they are created and used, see the Data Labels and Data Mapping section.
Email List Unsubscribers
Displays targets who have unsubscribed from a specific marketing list associated with this email account.
Displays email addresses that are being suppressed for various reasons such as bounced, global unsubscribe, a complaint to an ISP etc.
Email Message Queues
This functionality is reserved for future use.
Toolbar Options for the Email Accounts Information screen
This button is used to control the timings of automatic synchronisations. You must have the Information screen displayed to see this button; it will not appear if are viewing the Data Labels screen for example. There are various tabs on this screen:
This displays a table of synchronisation types and the synchronisation schedule for each, together with the Last and Next Synchronisation. Clicking on a field displays a pop-up window allowing the synchronisation schedule for this type to be edited. Immediate Synchronisation is also possible.
CampaignStatistics - Refreshing of behavioural data from dotmailer to Email campaign.
MarkeingListDataOut - Synchronisation of CRM Marketing list data to dotmailer address books, (this will also include datain when mapped).
MarketingListDataIn - Synchronisation of dotmailer address book data to CRM Marketing list data when mapped
DataLabels - Update the dotmailer Email Data Labels in cache.
SupressionList - Initially synchronisation of the CRM suppressed contacts to dotmailer followed by dotmailer suppressed contacts to CRM UnSubscribers Remove from the marketing list and create a list of suppression records against the person and marketing list.
CrmMetadata - Update the CRM fields in system cache and the data structures.
Forms - Refreshing Forms data from dotmailer to Email campaign.
WebInsight - Refreshing WebInsight data from dotmailer to Email campaign.
Email Service Settings
The information required for this tab will be provided to you by dotmailer as part of your set-up procedure. The Test Connection button is used to test connectivity to the dotmailer API. Use the Save button after any alterations.
This tab allows the certain administrative tasks to be undertaken, this includes the disabling the current Email Account.
The option to “Update the Do not Bulk Email” is used to control if this field is updated from dotmailer during synchronisation (Default is On).
The option to “Add to the CRM suppression list” is used to control if email addresses are added to this internal Dynamics list (Default is On).
This tab controls how any Automation Programs that are present in the Connected Email Account can be used.
The left hand panel shows all the active and inactive programs, only active programs can be selected, these then appear in the right hand panel and will be selectable from the contact/lead record.
When only mapped users are to be allowed to use the Automation program feature, the “Mapped Users Only” option should be checked.
When no programs have been selected the interface from the Contact/Lead records will show the following message.
This button is used to map the dotmailer users to Dynamics users for each connected account. If no users have been mapped and select the Automation Studio, this screen will be displayed.
The initial screen shows all the dotmailer account users on the left hand side, the main account user is highlighted.
From the dropdown list, select the Dynamics user to be mapped.
All users that require single sign on access to dotmailer from Dynamics.
This option enables any mapped user to directly enter dotmailer from within Dynamics. This then allows the user to create campaigns, automation programs, manage contacts and use all of the dotmailer functionality, without ever having to leave Dynamics CRM.
The first time you try to use the Automation Studio, you should be presented with a login screen as shown below. Enter your user name and password.
The access provided by this window will be exactly the same as if you had logged in directly.
You may be required to verify your location.
If the following screen is displayed, you will need to contact your CRM manager to resolve the issue.
One of the most powerful features of the integration between dotmailer and Microsoft Dynamics CRM is the ability to map pieces of information between CRM attributes and dotmailer data labels.
This ensures that as information changes within CRM that information is available for use within your Email Campaigns to personalise your message, such as salutation, an accounts manager’s contacts details, etc. and also to drive any dynamics contents your message may contain, such as hiding or showing email content based upon gender or a known product preference.
Custom data fields can be added to address books to capture and/or contain additional information about your contacts. The more useful data you can collect on your contacts, the more you can segment, target and personalise your campaigns and generate better response rates.
For an Enterprise account you can have up to 394 custom data fields that you can create and when you create a custom data field it is available throughout your dotmailer account.
Email Data Labels screen
To access Email Data Labels, select Settings from the menu bar, and then select Email Accounts. Choose the account you wish to work with and click it. Select Email Data Labels from the menu bar.
Creating a new data label
Step 1: Click on the Add New Email Data Label button on the Email Data Labels screen. A blank Email Data Label Information screen is displayed.
Step 2: Complete the fields on the screen, giving the new data label an appropriate and unique name.
i) ‘Is Private’ - New labels are always created as ‘Private’ in Microsoft® Dynamics CRM – you can change this to ‘Public’ if you wish using dotmailer.
ii) ‘Default value’ - You can enter a default value for the data field in the event that it is not populated as a result of the uploading of your data. For example, if this was a Salutation data label where the First Name would usually be entered you might default the value to “Customer”. If some of your records do not have first names held, “Customer” will then be automatically entered rather than leaving a blank field.
iii) ‘Description/Purpose’ - If you wish, add some notes to the Description/Purpose field to explain the intended usage of the data label.
iv) ‘Email Account’ - The Email Account field will show the email account that you originally navigated from but can be edited.
Step 3: Click Save and Close. The Email Data Labels screen is displayed and the new label appears in the table.
Email Data Labels Information screen
To access the Email Data Labels Information screen, select Settings from the menu bar, and then select Email Accounts.
Choose the account you wish to work with and click it. Select Email Data Labels from the menu bar. Click on a record.
Tabs on the Email Data Labels Information screen
This tab displays basic details for the data label. The ‘Is Synchronised’ radio button indicates whether the data label has been synchronised with dotmailer.
Menu Bar Options for the Email Data Labels Information screen
Displays the General tab. See screenshot above.
Displays the mappings for the selected data label and allows new mappings to be added. Click a record in the table to view the Email Data Mapping Information screen.
To add a new data mapping, click the Add New Email Data Label Mapping button.
Email Data Mapping screen
To access Email Data Mapping, select Settings from the menu bar, and then select Email Accounts. Choose the account you wish to work with and click it. Select Email Data Mappings from the menu bar.
Creating a new mapping
To avoid creating duplicate mappings, you should always create a mapping from a Data Label Information screen rather than the screen displayed above. This allows you to check existing mappings for a specific data label and confirm that the mapping you require is not already in place.
Step 1: From the Email Account Information screen, select Email Data Labels from the menu bar.
Step 2: Select the data label you wish to work with from the table.
Step 3: From the Email Data Label Information screen now displayed, select Data Mappings in the menu bar. The screen will display any existing mappings for the data label.
Step 4: Click on the New Email Data Mapping button. A blank Email Data Mapping Information screen is displayed. The Email Data Label and Email Account fields will have default values already entered.
Step 5: Complete the Mapping Direction.
Step 6: Complete the Mapped Entity field. When this has been selected, the Primary CRM field becomes active. Similarly, when the Primary CRM field is completed the Linked CRM field shall become active if appropriate.
Please note: When using a Linked CRM field, it will remain locked unless the Primary CRM field is a lookup field to the object that is being linked to.
Step 7: Click Save and Close. The Email Data Mappings screen is displayed and the new mapping appears in the table.
Email Data Mappings Information screen
To access Email Data Mapping, select Settings from the menu bar, and then select Email Accounts. Choose the account you wish to work with and double click it. Select Email Data Mappings from the menu bar. Click on a record.
Tabs on the Email Data Mappings Information screen
Displays basic details for the data mapping.
Menu Bar Options for the Email Data Mappings screen
This section displays the General tab.