Dynamics Community Forum Thread Details

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

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:

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.

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.

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.

Key Steps:

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

Data Transformation:
- Implement data transformation logic to ensure that the data is in the correct format for Customer Insights.

Authentication and Authorization:
- Handle authentication and authorization for the Customer Insights API.

Error Handling:
- Implement robust error handling to ensure data integrity.

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

Community site session details

Data Enrichment

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates