The following information assumes that you have completed each of the pre-requisite steps on the previous page, here. If you do not complete these steps then the integration will not function correctly and/or some steps cannot be completed.

At the time of writing these instructions are correct but over time these may change, if in doubt refer to dotmailer help pages for the latest dotMailer guides. The following links can be clicked to take you to the relevant section within the guide:

• Creating a dotmailer API User
• Setting up dotmailer within Workbooks
• Configuring Custom Field Mappings
• Synchronising Workbooks Marketing Campaigns to dotmailer
• Reporting on the Campaign Results in dotmailer
• Viewing Workbooks Campaign Summary
• Synchronising dotmailer Results into Workbooks
• Maintaining the dotmailer Processes

Step 1: Create a dotmailer API user

Login to your dotMailer account, under the dropdown menu where it says Hi XXXX, click Manage Users. From here, click API and then Add User.

An email address will be automatically generated by dotmailer which cannot be changed to ensure that this is unique. We advise that you enter in a description so that the Workbooks/dotmailer integration can easily be identified at a later date.

Ensure that you enter a memorable password

Also ensure that the Enabled tick-box is checked.

Back to top

Step 2: Setting up dotmailer within Workbooks

Navigate to Start > Configuration > Email & Integration > dotmailer. Enter the dotmailer API user email address that was generated in Step 1. If you haven't created it already you can click on the link provided from within Workbooks which will take you to the page where an API user can be created.

Ensure that you enter in the credentials exactly as they are displayed in dotmailer otherwise you will not be able to login. If successful, you will see the following screen:

The above screen displays information on the account credentials used, the number of API calls in the last hour and how many you have remaining.

From here you can configure additional mappings for custom fields, delete the integration completely if you wish to link Workbooks to another dotmailer account or click Re-synchronise with dotmailer to synchronise all Marketing Campaigns (see Synchronising Workbooks Marketing Campaign Members to dotmailer for more information on this).

Back to top

Step 3: Configuring Custom Field Mappings

The Workbooks/dotmailer integration wizard creates a total of 16 mappings automatically for the most common fields when you setup the integration for the first time. The mappings created include mainly fields that you need to send out a campaign such as a person name, email address and employer.

At a later date, you can change these mappings easily from Start -> Configuration -> Email & Integration -> dotmailer -> dotMailer Attribute Mappings. Under the Attribute Mappings tab, click Add which will show the following screen:

The Workbooks Field Name field provides a picklist for fields available on the Person and Sales Lead records in Workbooks. Notice that if a field is only available for either a Person record or a Sales Lead record this is shown in brackets after the field name.

Fields that are common to both Sales Leads and People are not followed by anything in brackets. Choose the Workbooks field and then enter in the corresponding dotmailer field name. As this field is free text, you will need to ensure the name is entered exactly as it appears in dotmailer to avoid any data synchronisation issues between the two systems.

It's simple enough to create new custom fields in both systems so that additional data can be captured in Workbooks and used in your dotmailer campaigns. For more information on creating Workbooks Custom Fields, see here. For information on how to create dotmailer custom fields, see here.

Back to top

Step 4: Synchronising Workbooks Marketing Campaign Members to dotmailer

You now need to create a Marketing Campaign in Workbooks and add some members. For more information on doing this, click here. To integrate this individual Campaign with dotmailer, click dotmailer Integration.

On the first screen of the wizard, simply click Next.

The second screen allows you to set a campaign subject, who the campaign will appear to come from and also the reply to email address. The subject will become the subject line of the emails that are send out from this Campaign when successfully synchronised. This information can be changed later.

You will also be able to set the email content based on a template from your 'My Templates' folder in dotmailer, or based on a previous Campaign. You can select the available options from the dropdowns or leave as 'No Template'/'No Campaign' to keep the content blank. Note that Free Templates will not be available in the Template dropdown list. Click Next when you are happy with the entries.

Within dotMailer, this can be configured under Campaigns -> Advanced Features -> From addresses:

If there is already an Address Book in dotMailer with the same name as the one that you try to create, you will see a warning message as shown below and you will be unable to progress further until you change the name or delete the duplicate manually from dotmailer:

The third and final screen simply confirms that an Address Book in dotmailer will be created for this campaign and the Marketing Campaign Members will also be synced across.

If you add additional Members later on, you will need to wait for the Dotmailer People Leads to Dotmailer process to run or start it manually. This process acts as an update to an existing campaign in dotmailer. For more information about manually running a process, see Step 6.

Once you see the above screen, you can click the information text which will ask you to sign in to dotmailer. You can then add content such as images, links and text to your Campaign using the dotmailer Wizard. Within Workbooks, simply click Complete.

When you are happy with the look and feel of your Campaign in dotmailer, click Save & Continue. You then have the option to send out a test email. Click Continue to skip this if you wish but our recommendation is always to test first to ensure you are happy with the results.

Next, add some contacts from an existing Address Book or select all contacts. You should only ideally select the Address Book with the same name as the campaign that you are sending out to avoid discrepancies in figures against your Workbooks Marketing Campaign record.

On the same screen, you can also choose to schedule the campaign or send it immediately. You can also use a dotmailer function of Triggers to set up a Campaign workflow. Click Save & Continue.

You'll then see a confirmation screen where you can make final changes to the campaign subject, reply email address and also the HTML/Plain Text content before choosing to send.

Back to top

Step 5a: Reporting on the Campaign Results in dotmailer

Once the Campaign is active, dotMailer will collect the resulting data which is then in turn pushed back into Workbooks, see Step 6 for more information. Within dotmailer, you can see results of your campaign by clicking Reporting -> My reports.

Back to top

Step 5b: Viewing Workbooks Campaign Summary

Once a campaign has started to collect data in dotmailer and this synchronises over to Workbooks, you can view the information collected for each individual campaign within Workbooks. Open up the Marketing Campaign and expand the dotmailer section, to reveal the data that has been synced:

In the screenshot above, you can see that the figures are all showing 0. This is because the script that runs to pull information back into Workbooks has not yet run.

It's also possible to see the summary for each individual target by opening the Members tab. When first opened, the view shows basic information about the member. However you can configure the grid to display columns showing details such as Email Opens, Email Clicks, Emails Soft Bounced and so on:

Back to top

Step 6: Synchronising dotMailer Results into Workbooks

Data that is captured in dotmailer such as the number of emails opens, number of emails that have bounced and the number of people that have clicked on the links within your emails is automatically synced back to Workbooks as part of the integration so that all of your information is in one central location.

The frequency of this process is defaulted to run every 4 hours but this can be changed to meet your requirements as necessary. To do this navigate to Start -> Configuration -> Automation -> Processes and open a process called a dotmailer activity to Workbooks.

Change the Run picklist to either Hourly, Frequently, Daily or Monthly. For the first two options, you'll need to enter a value into the Recur every field whereas for Daily or Monthly you simply need to choose a time from the picklist. From within this window, you can manually run a synchronisation from dotmailer to Workbooks by clicking the Run Now button.

Remember to click Save & Close when you are happy with the settings.

Back to top

Maintaining the dotMailer processes

As mentioned on this page, there are 4 processes which make up the dotmailer Integration with Workbooks. There is also information with regards to managing these processes, here, which details how to handle users that have left the company, changing the frequency of the Scheduled Process and so on.

Back to top