Docs
Other Bits
Tutorials
Migration Guides
Migrating from Amplitude

Migrating to Mixpanel from Amplitude

If you’re reading this, congrats on considering making the switch from Amplitude to Mixpanel 🎊  This guide is intended to outline how the migration works, what to expect, and how to mitigate the risks and switching costs of a migration whilst accelerate time to value.

What a migration will solve ✅

  • Cut-over sending live data to Mixpanel and stop sending to Amplitude
  • Historical backfill of existing data
  • Integrates easily with existing event data collection methods - SDKs, CDPs, DWH, RETL
  • Migrates all existing/new data in entirety - full access to all events and properties you had in Amplitude

What a migration won’t solve ⛔

  • Existing issues with data trust/quality or data governance → As part of the migration, we recommend a data audit (opens in a new tab) as the first step to only transfer your valuable data and clean up trust/quality issues
  • Reporting, Dashboards, and Saved Entities → As part of the migration, we can review your top used reports and dashboards then sit down with each team (opens in a new tab) to re-build them in Mixpanel

What level of effort does the migration take? ⚖️

A migration primarily consists of 3 phases:

  1. Technical migration of data → Data audit, Live data cutover, Historical data import
  2. Change management migration of end users → Champion identification, User interviews, Team by team specific trainings, Ensuring adoption for each team
  3. Ongoing success planning → Improving data governance, Optimizing analysis, Building a product analytics practice

From a technical perspective, the migration process is relatively straightforward. If you have an engineer with access to your data and the ability to write code/transforms to send data to new destinations, this can be done in a single sprint (1-2 weeks).

From an end user perspective, Mixpanel is simpler and easier to learn than Amplitude but there of course will be a learning curve. The largest hurdle is copying over key saved reports, dashboards, etc. which the team is familiar with in Amplitude and teaching them how to rebuild these in Mixpanel. We recommend doing this process in detail for each team, showing them how to recreate key analyses side-by-side in Mixpanel. You can then leverage your team champions to force multiply your adoption efforts.

When going through this migration, there is no better time to audit your own data and reports to only migrate what matters. Most data and reporting is stale after some time anyways, prioritize the data and reports your team uses every day for their Top 10 key questions. These can be easily copied over and Mixpanel also provides Customer Success resources during Onboarding to assist with this.

Getting started: Identify your implementation method 🚦

Mixpanel accepts event data from a variety of different sources. Choose your implementation method first and then you can follow the below steps for sending data to Mixpanel.

We support the following data collection mechanisms:

Differences in the data models ☯️

Both Mixpanel and Amplitude are product analytics tools which collect event-based behavioral data about your users. Events (opens in a new tab) are commonly expressed as JSON which represent the name of the user action, the ID of the user, the time at which the action took place, and all associated metadata. Events are immutable, and represent data at the time of which an action takes place.

{
	"event": "Signup",
	"properties":
	{
		"time": 1618716477000,
		"distinct_id": "91304156-cafc-4673-a237-623d1129c801",
		"$insert_id": "29fc2962-6d9c-455d-95ad-95b84f09b9e4",
		"Referred by": "Friend",
		"URL": "mixpanel.com/signup"
	}
}

In addition to events, Mixpanel supports an additional type of data that Amplitude does not. This data is known as user profiles (opens in a new tab), which represents dimensional data that is always updated to the most recent value for a user. User data allows you to segment your reporting by both historical point-in-time data as well as real-time dimensional data about your users.

{
	"$distinct_id": "13793",
	"$set":
	{
		"name": "Robert"
	}
}

We also support additional data for extending your use cases with Mixpanel:

  • Group profiles (opens in a new tab): Used with our Group Analytics product add-on to allow you to pivot quickly between users and other entities in your analysis. A common use case is for a B2B company to pivot between analyzing users and analyzing accounts.
  • Lookup tables (opens in a new tab): For event data which was already sent, you can use these to extend the data already sent into Mixpanel. A common use case is taking an identifier like a transaction ID, item ID, etc. and using lookup tables to enrich the data with additional information like the amount, category, etc. from your data warehouse.

Data audit: Cleaning up the mess 🧹

We’ve found from experience that <20% of the data in a product analytics tool is used for 80%+ of the queries. This is especially true the longer you have been using a tool - over time teams add more and more tracking for new events and properties, and without strong data governance practices, you will inevitably have some messy data in Amplitude.

In the spirit of making sense of the mess, it is not recommended that you bring all historical data in from Amplitude. A common practice is to leverage Amplitude’s Data (opens in a new tab) Product to first understand which events and properties are queried by your users. No queries in the past 30 days? These events and properties have probably gone stale - there is low value and high effort in brining them to Mixpanel, so cut them from your import and do not migrate the existing tracking.

After you’ve gotten rid of the obvious (the events and properties no one uses), you can fine tune this approach by doing user interviews with your top users/champions. These users can help you explicitly define the data they need brought along to Mixpanel (mapped to their key questions and KPIs) so you can focus on what matters. Because these users are the ones building reporting others use, capturing their use cases and making them change agents can be highly beneficial to your migration.

This data audit step is optional, but highly recommended - It is a larger upfront investment to avoid higher maintenance costs in the future.

Loading historical data 📊

We recommend loading a year’s worth (or less) of historical data during your migration. This will allow your team to review year-over-year trends easily and do historical analysis as needed.

To backfill data, we recommend:

  • If you have a data warehouse with Amplitude data: Leverage the Import API or a Reverse ETL tool to import to Mixpanel
  • If you have a data warehouse without Amplitude data: Export your data to the data warehouse so you have a record, and then Import API or Reverse ETL
  • If you do not have a data warehouse: Since there is no historical record of data, for this method you will need to export your data from Amplitude and move it into Mixpanel - we provide an easy to use helper function for this here (opens in a new tab)

It is also recommended you load the data into a test project with a limited subset (for ex, a single day or data or a sample of the entire dataset) to get started. This will help you identify any errors in the end to end process before you do a full historical data load.

Change management: Moving the users 👥

It is recommended your Mixpanel champion or owner first set up your Organization settings (opens in a new tab) and Project settings (opens in a new tab). This will ensure the right access level for your team and enable you to prepare the workspace for ingestion. This can be done later but doing it up front will allow for you to set key settings for data ingestion (US vs EU servers, project timezone, etc.).

Once data is live, we shift our focus to change management and migrating the existing users. We mitigate risk here by:

  • Going team by team to assess current Amplitude reports, and bringing over only what really matters
  • Running targeted trainings where we re-build Amplitude reports side-by-side in Mixpanel to teach users to fish
  • Building a product with awesome UI/UX that will make up for the up-front costs in simpler, more powerful analysis down the line

Our goal is to focus on each team individually, and we can process multiple in parallel. A team is the perfect unit to focus on as they have shared context and goals, so their needs as far as metrics and analysis will be similar. We can then help each team to the point they can self-serve answers from Mixpanel to answer their questions.

Ongoing Success 🎡

After the migration, we often focus on longer term goals like:

  • Improving Data Governance → Creating scaleable processes and strategies for managing data at scale
  • Optimizing Analysis → Helping end users analyze data for more use cases, faster
  • Building a Product Analytics Practice → Cultural change to be a self-serve, data democratized organization

Mixpanel Customer Success will work with you to define your ongoing needs and build a plan specific to the outcomes you need to drive. You can read more about how we do this here (opens in a new tab).