We explore the data compliance, security and governance capabilities offered in Microsoft Purview.
We would like to discuss the Customer Insights export feature, focusing in this blog on Audience Insights with Individual Consumers.
We demonstrated in a previous blog how to integrate Dynamics 365 Contact and Opportunity records to Customer Insights and viewed them in a profile page. We are going to demonstrate how to export the Dynamics 365 contacts in Customer Insights to Dynamics 365 Sales app. The steps are as follows:
Records are exported from Customer Insights as a segment. A segment is a list of customers queried with a given condition. The customer could be a contact in a consumer scenario or a business entity in commercial scenario. In this case we will create a list of contacts with won opportunities using a consumer scenario.
We click on Segments in the left navigation and click + New button. We give it a name as “Customers with Won Opportunity” and select a field that filters the opportunity records with status, “Won” [Dataverse.statecode = 1]. We click on Run button and create a segment.
Once refresh completes, we have a list (segment) with 5 Dynamics 365 Contacts. Image below is refreshed over a few days so that it shows some trends.
Let’s click on Exports in Data in the left navigation. We click on + Add export and create a connection and then export the segment created in the previous step. The wizard walks us through completing the process. First, we select “Dynamics 365 Sales (Marketing Lists)” as destination of the export.
Secondly, we give a name to the connection, “Dynamics 365 Sales.” We enter URL of the Dynamics 365 tenant and log in with admin user. Click I agree and the Save button.
Lastly, we give a name to the export as “Won Opportunity Customers” and map contact unique id in Customer Insights to the contact unique id in Dynamics 365 (Dataverse). We select a segment that we like to export, “CustomerwithWonOpportunity.” Click Save.
We click the Run button and initiate the export. Once the export completes, Status changes to Successful.
Let’s go to Dynamics 365 Sales app and check if the segment is exported. We click on “Marketing Lists” in Marketing in the left navigation. We can see “CustomerswithWonOpportunity” in the Active Marketing Lists view.
We can see the list of 5 contacts in the Members tab. They are the same list of contacts exported from Customer Insights.
The list of contacts in the segment in Customer Insights is below for comparison.
In other examples, we can export a segment such as High Lifetime Value Customers from Customer Insights to Dynamics 365 Marketing app. The segment could be used for Customer Journeys in Outbound and Realtime marketing. We can also export any segments from Customer Insights to Azure Data Lake and Azure Synapse Analytics and even create a Power BI report with the segment as datasets. We can further export to Facebook Ads Manager and other external applications for marketing activities.
Happy Customer Insights’ing!