Solved

Import Data from Big Query (Firebase app)


Badge

Hello! I’d like to start using Mixpanel to power my data analysis. However, I already have a record of more than a year of event data using Firebase Google Analytics. (~5k MAU)

These events are synced with Big Query, so I was wondering if there was any easy way to bring them into a mixpanel project? Losing all my events wuld be a pain, especially because I’d liek to start exploring the cohorts feature of mixpanel

Thanks in advance!

icon

Best answer by Muffaddal Qutbuddin 16 May 2021, 12:46

There are two ways to import the data to Mixpanel.

1st by sending the every dataa as an events. Since you have firebase analytics dataset, it is already structures into events and user profiles. You only have to batch send firebase events to Mixpanel api. 

see here for more details: https://help.mixpanel.com/hc/en-us/articles/115004734463-Importing-Data

2nd using mixpanel’ cloud import feature. You will have to prepare the file in ndjson format for this to work.

here is detail guide: https://developer.mixpanel.com/docs/cloud-import-data-preparation-guide  

View original

5 replies

Userlevel 3
Badge +2

There are two ways to import the data to Mixpanel.

1st by sending the every dataa as an events. Since you have firebase analytics dataset, it is already structures into events and user profiles. You only have to batch send firebase events to Mixpanel api. 

see here for more details: https://help.mixpanel.com/hc/en-us/articles/115004734463-Importing-Data

2nd using mixpanel’ cloud import feature. You will have to prepare the file in ndjson format for this to work.

here is detail guide: https://developer.mixpanel.com/docs/cloud-import-data-preparation-guide  

Badge

Hello @Muffaddal Qutbuddin !

I was able to add some events through the batch api (in the browser) but it does not seem to work for events that occurred prior to 5 days. As I said I have data collected for over a year already.

Import single event API is not working. I put the correct project and secret key in place and can’t make it work through the browser (even after receiving the same success message as I got in the batch).

Userlevel 3
Badge +2

@app_analytics_rocks why are you using browser to send the events? you need to set up a server that will read firebase data from Bigquery and send it to Mixpanel using one of the API. Cloud function/run can come handy here as well. 

 

Try the server side implementation to see if you are able to send more than 5 days data. 

Badge

@Muffaddal Qutbuddin the browser was just meant for testing the API :) Meanwhile the problem was found and solved (had to due with EU API). Thanks!

Userlevel 3
Badge +2

@app_analytics_rocks  good to know it worked. 
cheers

Reply


Mixpanel