The connector syncs email campaign statistics from Marketing to Microsoft Dynamics. Each email campaign has a synchronisation level that controls how much data syncs:
Basic
Totals for the campaign, such as the number sent, total opens, and total clicks. Email campaigns sent directly from Marketing use this level by default.Detailed (Basic plus individual tracking)
The basic totals, plus the opens and clicks of each contact who received the campaign. Detailed data appears in the campaign report and on a contact's Engagement timeline.
Detailed campaign data can take up a lot of storage in Dynamics. To control how much syncs, set a detailed sync limit on the campaign.
Detailed data and Dataverse storage
In Dynamics 365, detailed campaign data is stored in Microsoft Dataverse and counts towards your Dataverse storage capacity. Contact-level engagement data, such as sends, opens, and clicks, grows quickly, especially for campaigns that keep sending, such as triggered campaigns.
By default, Detailed synchronisation syncs all of a campaign's engagement data, however old it is. To sync only recent data, set a detailed sync limit on the campaign. The limit is a number of days. For example, a limit of 90 syncs engagement data from the last 90 days.
Exceeding your Dataverse storage capacity
If you go over your Dataverse storage capacity, Microsoft can charge you for the extra storage or restrict your environment, depending on your licensing. Deleting data afterwards doesn't always avoid the charge, so limit how much detailed data syncs from the start.
Learn more about Dataverse storage in Dataverse capacity-based storage details (Microsoft documentation).
Choose a detailed sync limit
Base your limit on how far back your Dynamics users need to see each contact's engagement. For example, a sales rep checking a contact's Engagement timeline to plan their next action may only need the last 30 or 90 days.
A shorter limit uses less Dataverse storage. Engagement data from before the limit doesn't sync, but the campaign's basic totals and statistics still sync in full.
The limit only affects campaigns with the synchronisation level set to Detailed. If you leave it blank, all engagement data syncs.
Apply Detailed synchronisation
In Microsoft Dynamics, go to Marketing > Email Campaigns. In the Classic Interface, go to Marketing > Email Campaigns in the ribbon.
Select the name of the email campaign.
Select the More options (three dots) icon, then select Administration. In the Classic Interface, select Administration at the bottom of the page.
Under Email Campaign Options, expand the Synchronisation Level drop-down menu and choose Detailed (Basic plus individual tracking).
In Detailed Sync Limit (Days), enter the number of days of engagement data to sync. Enter a whole number, such as 90. To sync all engagement data, leave this blank.
Select Save.
To apply Detailed synchronisation to several email campaigns at once:
In Microsoft Dynamics, go to Marketing > Email Campaigns.
Select the checkboxes next to the email campaigns you want to change.
Select Edit.
In the Change multiple records window, select Administration.
Expand the Synchronisation Level drop-down menu and choose Detailed (Basic plus individual tracking).
Select Change.
Set Detailed sync level for all campaigns
A Workflow can be set up to allow the level of synchronisation to be altered to Detailed. If you're not familiar with Workflows, reach out to your CRM Administrator.
Remove older detailed data from Dataverse
Setting or lowering a detailed sync limit doesn't delete any data that's already in Dataverse. It stops older engagement data syncing from then on.
To remove detailed data you no longer need, your CRM administrator can set up a workflow in Dynamics that deletes older records. As long as the workflow only deletes data older than the campaign's limit, that data doesn't sync back to Dynamics.
