📎Amplitude 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 Amplitude to Crunch —

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 — Import Historical Data.

2. Select ‘Amplitude’ from the top switcher.

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

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

   2. Go to the Organisation 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 Amplitude 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 ‘API Key’ and ‘Amplitude Secret Key’ as you copied from Amplitude.

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

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

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

8. Typically, it takes around 3-4 Hours to get one year's 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 Amplitude.

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

   1. Switch to the project in Amplitude 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 Amplitude 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 Amplitude.

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

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

7. At the end, simply click on Import data and the data migration from Amplitude 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 —

Event Properties

Raw Name

server_received_time

app

device_carrier

city

user_id

uuid

event _time

platform

os_version

amplitude_id

processed_time

version_name

ip_address

paying

dma

group_properties

user_properties

client_upload_time

$insert_id

event_type

library

amplitude_attribution_ids

device_type

start_version

location_lng

server_upload_time

event_id

location_lat

os_name

groups

event_properties

data

device_id

language

country

region

session_id

device_family

sample_rate

client_event_time

What 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