📪MixPanel Data Import

To ensure that your experience of utilising Crunch is seamless, you can import your data from all the major product analytics platforms such as MixPanel or Amplitude. If you use some other platform at the moment you can request for the integration of your platform to Crunch over our support mail [e-mail].

Here is how you can bring the data from the MixPanel to Crunch —

Mix Panel Integration

If you have already created a workspace on Crunch, you can proceed with the following steps, else first proceed with Workspace creation.

Importing while setting up a New Project —

1. Once you have entered the name of the project and installed Crunch to your project, you would be taken to the third step of Project creation — Data Migration.

2. Select ‘MixPanel’ from the top switcher.

   
3. Go to your account in MixPanel in a new browser tab and obtain your Project Token and API Secret using the following steps —

   1. Switch to the project in Mixpanel which you wish to import to Crunch.

   1. Go to the Project settings through the gear icon at the top.

      
   2. Ensure that you are in the ‘Overview’ tab. In there look for — “Project Token” and “API Secret”. These codes help Crunch communicate with your MixPanel project to retrieve data for you.

      
   3. If you are not able to view these sections probably you don’t have the relevant permissions for your project. Reach out to your account admin to help you with these codes.

   
4. Now, come back to Crunch tab and paste ‘Project Token’ and ‘API secret’ as you copied from MixPanel.

   
5. Lastly, select the data range for which you wish to get the data from MixPanel.

6. Note that MixPanel doesn’t allow data beyond one year to be migrated.

7. At the end, simply click on Import data and the data migration from MixPanel to Crunch will start.

8. Typically, it takes around 3-4 Hours to get one year long data of a large enterprise. You would be informed over the email once the data has been migrated.

Importing while in project Settings —

1. Go to project settings in Crunch through the dropdown menu on the your profile picture.

   
2. Open the integrations tab from the left pane and switch to MixPanel.

   
3. Go to your account in MixPanel in a new browser tab and obtain your Project Token and API Secret using the following steps —

   1. Switch to the project in Mixpanel which you wish to import to Crunch.

      
   2. Go to the Project settings through the gear icon at the top.

      
   3. Ensure that you are in the ‘Overview’ tab. In there look for — “Project Token” and “API Secret”. These codes help Crunch communicate with your MixPanel project to retrieve data for you.

      
   4. If you are not able to view these sections probably you don’t have the relevant permissions for your project. Reach out to your account admin to help you with these codes.

4. Now, come back to Crunch tab and paste ‘Project Token’ and ‘API secret’ as you copied from MixPanel.

   
5. Lastly, select the data range for which you wish to get the data from MixPanel.

6. Note that MixPanel doesn’t allow data beyond one year to be migrated.

7. At the end, simply click on Import data and the data migration from MixPanel to Crunch will start.

8. Typically, it takes around 3-4 Hours to get one year long data of a large enterprise. You would be informed over the email once the data has been migrated.

How to access imported data?

You can access and operate your historical imported data within Crunch by asking any questions from the data or plotting widgets for the same. It is to ensure that you still are able to access the information which you had in the previous tool. Once you have successfully imported your data from previous tracking tools, here is how you can access that —

1. Go to project settings in Crunch through the dropdown menu on the your profile picture.

   
2. Open the integrations tab from the left pane and switch to the tool from where you have imported the data.

   
3. You would see the indication that the data has been successfully imported from your tools. Click on the button ‘Ask Anything’ button next to the details of your data import.

4. In the Magic Search you can ask any questions from your historical data to get relevant information through widgets.

5. You would also soon be able to plot widgets based on the information by selecting properties such as Events, Filters, Breakdown by yourself and creating a custom widget.

6. Note, Crunch doesn’t support creating of dashboard from your historical data directly from user interface. You can raise us a request over our support mail [e-mail] to help you setup a dashboard for your past data.

---

What all data would be imported?

For the time range you would specify in the import setup, Crunch would broadly import the Different Event and User Properties, details are mentioned below —

Web

Event Properties

Raw Name	Display Name	Description
$city	City	The city of the event sender parsed from the IP property or the Latitude and Longitude properties.
$region	Region	The region (state or province) of the event sender parsed from the IP property or the Latitude and Longitude properties.
mp_country_code	Country	The country of the event sender parsed from the IP property or the Latitude and Longitude properties.
$browser	Browser	Name of the browser.
$browser_version	Browser Version	Version of the browser.
$device	Device	Name of the event sender’s device, if they’re on mobile web.
$device_id	Device ID	Autogenerated ID that is local to the device. Calling reset() resets this.
$user_id	User ID	The identified ID of the user. Calling identify() sets this.
$current_url	Current URL	The URL of the page on which the event was tracked.
$initial_referrer	Initial Referrer	Referring URL when the user first arrived on your site. Defaults to "$direct" if the user is not referred.
$initial_referring_domain	Initial Referring Domain	Referring domain at first arrival. Defaults to "$direct" if the user is not referred.
$os	Operating System	OS of the event sender.
mp_lib	Mixpanel Library	The Mixpanel library that sent the event.
$referrer	Referrer	Referring URL including your own domain. Might not be present if document.referrer does not return a value. As opposed to $initial_referrer and $initial_referring_domain, this property will be omitted if the user lands directly or the referring website adds the rel="noreferrer" parameter.
$referring_domain	Referring Domain	Referring domain including your own domain. Might not be present if document.referrer does not return a value. As opposed to $initial_referrer and $initial_referring_domain, this property will be omitted if the user lands directly or the referring website adds the rel="noreferrer" parameter.
$screen_height	Screen Height	The height of the device screen in pixels.
$screen_width	Screen Width	The width of the device screen in pixels.
$search_engine	Search Engine	The search engine that the customer used when they arrived at your domain.
mp_keyword	Search Keyword	Search keywords detected on the referrer from a search engine to your domain. This property is only collected when search keywords are included in a URL.
utm_source, utm_medium, etc.	UTM Parameters	UTM tags derived from the URL a customer clicked to arrive at your domain. Each utm will be collected under its own property.
mp_processing_time_ms	Processing Time	UTC timestamp of when the event was processed by our servers.
$mp_api_timestamp_ms	API Timestamp	Time at which the event was received by our API.
$insert_id	Insert ID	A unique identifier for the event, used to deduplicate events that are accidentally sent multiple times.

User Properties

Raw Name	Display Name	Description
$city	City	The city of the event sender parsed from the IP property or the Latitude and Longitude properties.
$region	Region	The region (state or province) of the event sender parsed from the IP property or the Latitude and Longitude properties.
mp_country_code	Country	The country of the event sender parsed from the IP property or the Latitude and Longitude properties.
$geo_source	Geo Source	This defines the method used to establish the location properties on that same entity. Location properties include Country, Region, and City.
$timezone	BrowserTimezone	Timezone of the event sender, parsed from IP.
$browser	Browser	Name of the browser.
$browser_version	Browser Version	Version of the browser.
$initial_referrer	Initial Referrer	Referring URL when the user first arrived on your site. Defaults to "$direct" if the user is not referred.
$initial_referring_domain	Initial Referring Domain	Referring domain at first arrival. Defaults to "$direct" if the user is not referred.
$os	Operating System	OS of the event sender.
$mp_api_timestamp_ms	API Timestamp	Time at which the event was received by our API.
$last_seen	Updated at	The last time a user profile property was set or updated (this should not be set manually).

iOS

Event Properties

Raw Name	Display Name	Description
$city	City	The city of the event sender parsed from the IP property or the Latitude and Longitude properties.
$region	Region	The region (state or province) of the event sender parsed from the IP property or the Latitude and Longitude properties.
mp_country_code	Country	The country of the event sender parsed from the IP property or the Latitude and Longitude properties.
$device_id	Device ID	Autogenerated ID that is local to the device. Calling reset() resets this.
$user_id	User ID	The identified ID of the user. Calling identify() sets this.
mp_lib	Mixpanel Library	The Mixpanel library that sent the event.
$app_build_number	App Build Number	General build of the app.
$app_version_string	App Version	Current app version.
$carrier	Carrier	Wireless carrier of the device owner.
$ios_version	iOS Version	Current version of iOS on the device.
$lib_version	Lib Version	Mixpanel library version.
mp_lib	Mixpanel Library	Mixpanel Library that sent the event.
$model	Model	Device model ID, in format "iPad 3,4".
$os	Operating System	OS of the event sender.
$radio	Radio	Current https://www.objc.io/issues/5-ios7/iOS7-hidden-gems-and-workarounds/#know-your-radio (opens in a new tab) (3G, 4G, LTE, etc.).
$screen_height	Screen Height	Height, in points, of the device screen.
$screen_width	Screen Width	Width, in points, of the device screen.
$wifi	Wifi	Set to true if the user’s device has an active, available Wifi connection, false if not.
mp_processing_time_ms	Processing Time	UTC timestamp of when the event was processed by our servers.
$mp_api_timestamp_ms	API Timestamp	Time at which the event was received by our API.
$insert_id	Insert ID	A unique identifier for the event, used to deduplicate events that are accidentally sent multiple times.

User Properties

Raw Name	Display Name	Description
$city	City	The city of the event sender parsed from the IP property or the Latitude and Longitude properties.
$region	Region	The region (state or province) of the event sender parsed from the IP property or the Latitude and Longitude properties.
mp_country_code	Country	The country of the event sender parsed from the IP property or the Latitude and Longitude properties.
$geo_source	Geo Source	This defines the method used to establish the location properties on that same entity. Location properties include Country, Region, and City.
$timezone	BrowserTimezone	Timezone of the event sender, parsed from IP.
$os	Operating System	OS of the event sender.
$mp_api_timestamp_ms	API Timestamp	Time at which the event was received by our API.
$ios_app_release	iOS App Release	General build of this app
$ios_app_version	iOS App Version	Full detail of this app build.
$ios_device_model	iOS Device Model	Device model ID, in format "iPad 3,4"
$last_seen	Updated at	The last time a user profile property was set or updated (this cannot be set manually).
Total App Sessions	Total App Sessions	The total number of “App Session” events that the user has sent.
Total App Session Length	Total App Session Length	The total number of seconds that a user has spent using the app. This is calculated by adding the "Duration" property attached to the "App Session" event.
First App Open Date	First App Open Date	The date the app was first opened on a user’s device.

Android

Event Properties

Raw Name	Display Name	Description
$city	City	The city of the event sender parsed from the IP property or the Latitude and Longitude properties.
$region	Region	The region (state or province) of the event sender parsed from the IP property or the Latitude and Longitude properties.
mp_country_code	Country	The country of the event sender parsed from the IP property or the Latitude and Longitude properties.
$device_id	Device ID	Autogenerated ID that is local to the device. Calling reset() resets this.
$user_id	User ID	The identified ID of the user. Calling identify() sets this.
mp_lib	Mixpanel Library	The Mixpanel library that sent the event.
$app_build_number	App Build Number	General build of this app.
$app_version_string	App Version	Current app version.
$bluetooth_enabled	Bluetooth	True if bluetooth is enabled.
$bluetooth_version	Bluetooth Version	"none", "ble", or "classic".
$brand	Brand	Device brand.
$carrier	Carrier	Wireless carrier of the device owner.
$google_play_services	Google Play Services	True if Google Play Services is installed and enabled on the device.
$has_nfc	Has NFC	True if device has NFC functionality.
$has_telephone	Has Telephone	True if device has telephone functionality.
$ios_version	iOS Version	Current version of iOS on the device.
$lib_version	Lib Version	Mixpanel library version.
mp_lib	Mixpanel Library	Mixpanel Library that sent the event.
$manufacturer	Manufacturer	Device manufacturer.
$model	Model	Device model ID, in format "iPad 3,4".
$os	Operating System	OS of the event sender.
$radio	Radio	Current https://www.objc.io/issues/5-ios7/iOS7-hidden-gems-and-workarounds/#know-your-radio (opens in a new tab) (3G, 4G, LTE, etc.).
$screen_dpi	Screen DPI	Pixel density of the screen.
$screen_height	Screen Height	Height, in pixels, of the device screen.
$screen_width	Screen Width	Width, in pixels, of the device screen.
$wifi	Wifi	Set to true if user’s device has an active, available Wifi connection, false if not.
mp_processing_time_ms	Processing Time	UTC timestamp of when the event was processed by our servers.
$mp_api_timestamp_ms	API Timestamp	Time at which the event was received by our API.
$insert_id	Insert ID	A unique identifier for the event, used to deduplicate events that are accidentally sent multiple times.

User Properties

Raw Name	Display Name	Description
$city	City	The city of the event sender parsed from the IP property or the Latitude and Longitude properties.
$region	Region	The region (state or province) of the event sender parsed from the IP property or the Latitude and Longitude properties.
mp_country_code	Country	The country of the event sender parsed from the IP property or the Latitude and Longitude properties.
$geo_source	Geo Source	This defines the method used to establish the location properties on that same entity. Location properties include Country, Region, and City.
$timezone	BrowserTimezone	Timezone of the event sender, parsed from IP.
$android_app_version_code	Android App Version Code	Current app version.
$android_app_version	Android App Version	Current app version.
$android_lib_version	Android Lib Version	Version of Mixpanel library.
$android_os_version	Android OS Version	Current Android version for this device.
$android_brand	Android Brand	Device brand.
$android_model	Android Model	Device model.
$android_manufacturer	Android Manufacturer	Device model.
$last_seen	Updated at	The last time a user profile property was set or updated (this cannot be set manually).

---

What all data is NOT imported?

There are some entities which Crunch is not able to import from the tracking tools because of their API limitations —

1. Your Dashboards created in those tools.

2. Your Cohorts and their details

3. Individual widgets or Insights created in the tools

So consider the import to siphon your collected data but not the operations you have done to visualise the data.