📎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