20

I'm trying to figure out if it's possible to export all the Firebase Analytics data to an excel spreadsheet, similar to how you can do it with Google Analytics. From what I can find the only way to go about doing it is to link with BigQuery then do some SQL statements to build a table and export.

Unfortunately for us this is not going to work (due to client budget and capabilities). Is there any other way to export this data that I'm missing?

random
  • 8,568
  • 12
  • 50
  • 85

4 Answers4

24

Update: You can now export the analytics reports as CSV from the Firebase console by clicking the Download CSV option from the ⠇ overflow menu.

In the meantime, you really should give BigQuery another look. The pricing is very reasonable and there is a free query tier of 1 TB/mo.

Steve Ganem

Product Manager, Firebase Analytics

Frank van Puffelen
  • 565,676
  • 79
  • 828
  • 807
Steve Ganem
  • 10,591
  • 2
  • 39
  • 32
  • 1
    Is there an easy way to export all the data from BigQuery? i.e. if I'm a user that is in marketing or PR will I be able to figure it out? Our biggest concern is that once we turn this over to the client they will not be able to figure out how to use BigQuery without using some expensive 3rd part front end. – random Jun 08 '16 at 13:59
  • 4
    Google Data Studio is a great front end for building and sharing charts and graphs easily. It has a connector for BigQuery. They just announced a free tier, too. – Steve Ganem Jun 08 '16 at 14:19
  • 1
    @SteveGanem How can I export user's data like location details to bigquery and how I will be able to see the geographic location (area/city/state) of each user through firebase console ? – Araju Oct 25 '17 at 12:13
  • 12
    Is there any way to get the csv via api? – Aarian P. Aleahmad Nov 03 '18 at 17:44
  • 4
    This does not answer the question. The question is about exporting data, not reports. I'm particularly interested in an API for doing this. So far, that doesn't appear to exist. – dpurrington Aug 10 '20 at 15:34
  • We need **raw event export**. What event was triggered by what user. I can do this so easily with Mixpanel the competitor it has even a built in JQL board for this. It is very useful when you are tracking down reported glitches for a particular user. Or when you need to understand one particular journey. Seems like analytics was never really tested with real users... – atoth Jan 19 '21 at 10:51
4

As our company uses AWS for it's projects, BigQuery is not an option for now so I have moved on to scrape the data from Firebase.

You can use Selenium and Beautifulsoup in python to scrape the data from Firebase.

DisappointedByUnaccountableMod
  • 6,656
  • 4
  • 18
  • 22
Soham Sil
  • 93
  • 6
2

You could easily select and copy UI blocks on the Analytics web page in Firebase, and then just paste the copied data into an Excel sheet. You'll see fancy tables.

There is a YouTube video that explains and demonstrates the procedure here:
Copy Your Analytics Data to a Spreadsheet with this One WEIRD Trick! - Firecasts

Cody Gray - on strike
  • 239,200
  • 50
  • 490
  • 574
Alex_297
  • 249
  • 1
  • 8
  • 5
    Not working for me today at June 2019, maybe they changed it. – Alberto Jun 17 '19 at 12:27
  • This does not work anymore. Instead, there's a download button on the page itself which you can use to download said data on each event – vepzfe Jul 13 '21 at 09:10
0

For all those who use AWS and want an automated pipeline, BigQuery allows you to export CSV if you have no arrays and JSON if you do. You can then automate exports to google cloud storage. Finally, you can use Airflow with AWS or an EC2 with a CRON or some other orchestration or scheduling system to schedule the merging of the google data to your AWS pipeline.

smoosh911
  • 516
  • 7
  • 8