what is the best approach to import statistical absolute numbers like the number of assets in a system per customer or the number of paid users in a customer contract on a regular basis into mixpanel for further use in reports?
Hi Tobias, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To import statistical absolute numbers like the number of assets in a system per customer or the number of paid users in a customer contract on a regular basis into Mixpanel, the best approach would be to use Mixpanel's User Profiles feature along with one of the following methods: 1. Data Warehouse Connectors: If you store this data in a data warehouse, the most efficient method would be to use Mixpanel's Data Warehouse Connectors. This allows you to set up recurring syncs from your data warehouse to Mixpanel, ensuring that your data is always up-to-date.Mixpanel Docs: Migrating from Amplitude mentions: "You can set up the Mixpanel Warehouse Connector to set your implementation to Mixpanel. You can learn more about event mappings here and about user mappings here."2. Reverse ETL (RETL): If you use a reverse ETL tool like Census or Hightouch, you can set up Mixpanel as a destination and sync your data regularly.Mixpanel Docs: Migrating from Amplitude states: "If you already send data to Amplitude with your data warehouse as the source of truth using reverse ETL, sending data to Mixpanel requires adding a new destination and syncing the same models you have been syncing to Amplitude."3. Import API: If you have a custom data pipeline, you can use Mixpanel's Import API to send user profile updates regularly.Mixpanel Docs: Increment Numerical Property explains: "Takes a JSON object containing keys and numerical values. $add will increment the value of a user profile property. When processed, the property values are added to the existing values of the properties on the profile. If the property is not present on the profile, the value will be added to 0."This method is particularly useful for updating numerical values like the number of assets or paid users.Whichever method you choose, ensure that you're updating User Profiles rather than sending these as events. This will allow you to use these absolute numbers in your reports and segmentation without needing to recalculate them each time.Remember to set up a regular sync schedule that aligns with how often this data changes in your system. This will ensure that your Mixpanel reports always reflect the most up-to-date information.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
Based on the information provided in the knowledge sources, the best way to create and maintain customer profiles with statistical data from an external source like a product database is to use Mixpanel's User Profiles feature along with a hub-and-spoke data infrastructure model and operational analytics. Here's a breakdown of the recommended approach: 1. Use a hub-and-spoke data model: Set up your cloud data warehouse as the central hub for all your data, including your product database. This allows you to centralize and standardize your data from various sources.Building complete and accurate user profiles explains: "A hub-and-spoke model for data infrastructure—where your cloud data warehouse is a central 'hub' and data sources are 'spokes'—makes managing user data from many different sources easier on your data team."2. Model and clean the data: Use a tool like dbt to model and clean your data within the data warehouse. This step ensures that your customer profile data is properly formatted and ready for use in Mixpanel.3. Use operational analytics for syncing: Implement an operational analytics tool like Census to automatically sync the modeled data from your data warehouse to Mixpanel. This approach allows for regular, automated updates to your customer profiles.Building complete and accurate user profiles states: "Census uses a process called reverse ETL (extract, transform, load) to connect to your cloud data warehouse, validate modeled data, and, with a few lines of SQL, place it directly into Mixpanel."4. Update User Profiles in Mixpanel: Use the synced data to update User Profiles in Mixpanel. This can be done through the Mixpanel API or through integrations with tools like Census.Mixpanel Docs: User Profile mentions: "You can create or update User Profiles in similar ways you track events: from our SDKs, via our HTTP Engage API, Warehouse Connectors, or via our integrations partners."5. Set up regular syncs: Establish a schedule for regular syncs to ensure your Mixpanel User Profiles are always up-to-date with the latest data from your product database.By following this approach, you can efficiently create and maintain customer profiles in Mixpanel with statistical data from your product database, ensuring that your analytics are based on the most current and accurate information.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
