Microsoft Dynamics Integration Guide

  • Updated

Act-On’s integration with Microsoft Dynamics (MS Dynamics) allows you to share information and use your MS Dynamics database for intelligence gathering. The integration will also allow MS Dynamics users to see any marketing activities a lead or contact has participated in so that when the individual is contacted, the MS Dynamics user has insight into their interests.

A bi-directional relationship with Dynamics allows you as the marketer to push and then pull data between the two systems that will synchronize your two databases. When using the Dynamics Integration you may use not only the Dynamics Standard Fields for marketing and segmentation but custom fields associated with the Lead and Contact entities.

When importing from Dynamics you can pull your full list of Leads and/or Contacts, any Static Marketing List, and Dynamic Marketing Lists into Act-On. Importing any of these will create segments within Act-On that contain all of the individuals associated with that group so that you can send email campaigns to them, create sub-segments, and manipulate the data or add newly qualified leads into your MS Dynamics account.

Read on to learn how to integrate Act-On with Microsoft Dynamics.

Supported Versions

As of January 1, 2023, Act-On no longer supports the following Microsoft Dynamics integrations:

  • 2011 v5
  • 2013 v6
  • 2015 v7
  • 2016 v8.0
  • 2016 v8.1

If you use any of these versions and cannot upgrade to Dynamics 2016 v8.2 or 365, Act-On will no longer provide support for any issues with the integration and you will not be able to use Act-On’s contact data management features.

Act-On does not support Multi-Factor Authentication (MFA) for MS Dynamics integrations. Accounts can connect using an App Password. For more information, click here.

Connect to MS Dynamics

Set Up Your Connection

Before integrating, the accounts must be connected. Follow our guide for setting up your connection between Act-On and your version of MS Dynamics.

How to Connect to Dynamics (All versions except 365 Cloud)

How to Connect to MS Dynamics with Oauth (365 Only)

Understand Your Data Options

There are several data options available when setting up your connection. These options will impact your data flow between MS Dynamics and Act-On. Make sure you understand each of these options so that you are managing your CRM data in Act-On effectively.

Microsoft Dynamics Connector Options

Set Up the Act-On Package in MS Dynamics

Install the Package and Register Users

The Act-On package in MS Dynamics will allow your users to utilize Act-On features directly from MS Dynamics.

You will need to work in conjunction with your MS Dynamics System Administrator to install this tool.

Install Act-On for Microsoft Dynamics and Register Users

Request Installation Files

Act-On Marketing Platform for Microsoft Dynamics - Troubleshooting Guide

Uninstall or Upgrade Your Package

Follow these instructions to upgrade or remove the package from your MS Dynamics account.

How to Check your Microsoft Dynamics Package Version

How to Upgrade or Uninstall Act-On for MS Dynamics

Synchronize MS Dynamics Data with Act-On

Now that you are connected, there are several steps to complete so that you can synchronize data fields, import marketing lists, generate reports based on CRM data, and send personalized emails on behalf of your sales team.

Data Management

The Data Management panel is a management tool for pulling the schema from MS Dynamics, which details the MS Dynamics objects (such as Leads and Contacts) and associated data fields.

A recurring synchronization is required for the following features:

This setup may be completed by an Act-On administrator or marketing user:

Data Management Setup

Act-On Contacts

Sync your lead and contact data to the All Contacts list and push updates to MS Dynamics using the Act-On Contacts data sync. This is the preferred method.

Synchronizing Microsoft Dynamics Data to Act-On Contacts

If you are syncing via Act-On Contacts, you can skip the steps outlined below in Marketing Lists.

Marketing Lists

If you are not using Act-On Contacts for your contact data management, you can set up a sync using Marketing Lists. 

Configuring Standard Field Names in Act-On to match your MS Dynamics fields will prevent data management issues.

Act-On marketing and administrative users can complete this step.

Set up Standard Field Names

You can now import your Leads and Contacts from MS Dynamics. This will create new marketing lists of Act-On contacts from which you can create segments & send emails. This article also applies to importing MS Dynamics Marketing Lists and Reports.

Act-On marketing and administrative users can import lists.

Import and Sync MS Dynamics lists

These data fields need specific setup to synchronize with MS Dynamics:

Sync Opt-Outs with MS Dynamics

Sync your Act-On Behavior Score with MS Dynamics

Reporting

Hot Prospects Setup

The Hot Prospects dashboard identifies the most active leads and contacts based on scoring rules defined in Act-On. Sales users will see their personal Top 20 Hot Prospects in the Act-On Tab in MS Dynamics.

Set up Hot Prospects

Account Report Setup

You can also give your sales users access to the Account Report to easily view account-level data from Act-On from MS Dynamics. See the CRM Customization Toolkit Guide for setup instructions.

 

Additional Reports

Act-On has other reports available using CRM data. Follow these guides to set them up.

Marketing Funnel Reports

Revenue Attribution Report

Revenue Impact Report

Was this article helpful?

Have more questions? Submit a request