Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : lYb9d1/238CWRUxPGzlK/3
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Data Enrichment
Customer experience | Sales, Customer Insights,...
Suggested answer

Data Enrichment

Like (3) ShareShare
ReportReport
Posted on 14 Mar 2025 09:04:14 by SA-14030858-0 6

I need to integrate user behavior data into MS Dynamics Customer Insights to effectively target users. For example, I want to track when a user clicks on a specific brand, product, or category in our app and store/enrich that data into the user profile

My goal is to create user segments based on interests, such as users who engage with Keto food or interact with Brand A or Brand B. This would allow me to send them tailored offers and promo codes to drive purchases.

Currently, I use Mixpanel to track user behavior and Segment.io for data routing. However, Segment.io does not have a direct integration with MS Dynamics Customer Insights.
What would be the best way to achieve this integration?








 
Categories:
Dynamics 365 Customer Insights - Data
  • Suggested answer
    Daivat Vartak (v-9davar) Profile Picture
    Daivat Vartak (v-9d... 2,319 Super User 2025 Season 1 on 16 Mar 2025 at 14:45:21
    Data Enrichment
    Hello SA-14030858-0,
     

    You're aiming to create a robust customer segmentation and targeting system by integrating user behavior data from your app (tracked via Mixpanel) into Microsoft Dynamics 365 Customer Insights. This is a common and valuable use case for personalized marketing.

    Here's a breakdown of the best approaches, considering your current setup with Mixpanel and Segment.io:

    Understanding the Challenge:

    • Segment.io Lack of Direct Integration: As you pointed out, Segment.io doesn't have a direct, out-of-the-box connector for Dynamics 365 Customer Insights.
    • Real-time Data: You likely need near real-time data integration to effectively target users based on their immediate behavior.
    • Data Enrichment: You want to enrich user profiles in Customer Insights with the behavioral data.

     

    Best Approaches:

    1. Azure Event Hubs + Power Automate or Azure Functions:

       

      • Mixpanel to Segment.io to Azure Event Hubs:

        • Configure Segment.io to stream your Mixpanel data to Azure Event Hubs. This is a common pattern for real-time data ingestion. 

      • Azure Event Hubs to Power Automate/Azure Functions:

        • Power Automate: Use the Azure Event Hubs trigger in Power Automate to listen for incoming events. Then, use the Dynamics 365 Customer Insights connector to update customer profiles.
        • Azure Functions: For more complex data transformations or high-volume processing, use Azure Functions. Write code to consume events from Event Hubs and update Customer Insights profiles using the Customer Insights API.

      • Advantages:

        • Real-time or near real-time data integration.
        • Scalable and reliable.
        • Flexibility to handle complex data transformations. 

      • Considerations:

        • Requires Azure Event Hubs setup.
        • Power Automate or Azure Functions development skills.
        • Cost of Azure Services.  

    2. Azure Data Lake Storage + Azure Data Factory or Azure Synapse Analytics:

       

      • Mixpanel to Segment.io to Azure Data Lake Storage:

        • Configure Segment.io to load your Mixpanel data into Azure Data Lake Storage. This is suitable for batch processing of historical data. 

      • Azure Data Lake Storage to Azure Data Factory/Azure Synapse Analytics:

        • Use Azure Data Factory or Azure Synapse Analytics to transform and load the data from Data Lake Storage into Dynamics 365 Customer Insights. 

      • Advantages:

        • Suitable for batch processing of large datasets.
        • Powerful data transformation capabilities. 

      • Considerations:

        • Batch processing, not real-time.
        • Requires Azure Data Lake Storage, Data Factory, or Synapse Analytics setup.
        • Requires data engineering skills.  

    3. Custom API Integration:

      • Develop a Custom API: Create a custom API that receives data from Segment.io and then calls the Dynamics 365 Customer Insights API to update profiles.
      • Segment.io Webhooks: Configure Segment.io to send data to your custom API using webhooks.

      • Advantages:

        • Maximum flexibility and control. 

      • Considerations:

        • Requires significant development effort.
        • Requires hosting infrastructure. 
          

      4.  

    Key Steps:

    1. Data Mapping:

      • Define a clear mapping between your Mixpanel/Segment.io data and the customer profile attributes in Dynamics 365 Customer Insights. 

    2. Data Transformation:

      • Implement data transformation logic to ensure that the data is in the correct format for Customer Insights. 

    3. Authentication and Authorization:

      • Handle authentication and authorization for the Customer Insights API. 

    4. Error Handling:

      • Implement robust error handling to ensure data integrity.

      5.  

    Recommendations:

    • For near real-time integration, Azure Event Hubs + Power Automate/Azure Functions is the best option.
    • For batch processing of historical data, Azure Data Lake Storage + Azure Data Factory/Azure Synapse Analytics is suitable.
    • Custom API integration provides maximum flexibility but requires significant development effort.

      •  

    By implementing one of these solutions, you can effectively integrate your user behavior data into Dynamics 365 Customer Insights and create highly targeted customer segments.

     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.
     
    My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.
     
    Regards,
    Daivat Vartak

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,886 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,768 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans