Update October 7, 2020: BigQuery Export can now be configured via Site Settings in Google Analytics: App + Web, so you don’t need to follow the steps in this article. See Charles Farina’s guide to learn how to do this.
Here is another article inspired by the relatively recent version of Google Analytics: App + Web Properties. This new property type brings out the capabilities of Firebase analytics for websites as well, when before it was only mobile apps (check out my guides for iOS and Android).
While the Google Analytics for Firebase feature set is still somewhat bare in the UI, here’s a feature that might push you over the edge and give the new measurement model a shot.
BigQuery export is available at no additional cost!
Well, there is one caveat: of course you will need to pay to use BigQuery and you will need to upgrade to the Firebase Blaze plan. But you won’t have to deduct about $150,000 per year to access the raw data, and the free tiers of Google Cloud are until far away Generous, so you may end up not having to pay at all for such great storage!
Noticeable! There is no telling that this is the permanent situation. Once Google Analytics: App + Web is out of beta, it’s possible to offer some sort of tiered pricing. But let’s enjoy this while we can!
The steps you will need to take to enable the export are described in this article. Remember to review the Firebase BigQuery Export schema so you know how the data in the BigQuery table will be aligned.
Simmer . Newsletter
Subscribe to the Simmer newsletter to get the latest news and content from Simo Ahava right in your inbox!
Step 1: Check Google Analytics: App + Website
The first step is obvious – you need a file Google Analytics: App + Website To be able to export data from it to Firebase.
If you haven’t created one yet, follow these steps to do so.
To check that it’s up and running and integrated into Firebase, go to the Firebase console and open your project and go to Project Settings.
click to integrals. You should see Google Analytics in a file Maybe country, but click Manages to check.
Here you must make sure that all the details look correct. At this point, make a note of a file Property ID In case you want to decide In any geographic location (eg US, EU) where you want to create a BigQuery dataset.
Now, back to Firebase the summery of project dashboard.
Step 2: Create a fake app
This is kind of silly, but for the export to work you need to create a file Application in the project. The app doesn’t have to do anything, you don’t have to check or validate it, it just needs to exist.
The reason for this is that the BigQuery export was created before a file web stream The concept was introduced with Google Analytics: App + Web, and in its current state, just having a web stream would not enable the export.
I’m sure this will change at some point in the future.
On the dashboard, tap iOS A button to create a new iOS app.
Give the app some bundle id – it can be anything you want. i used
com.example.dummyapp. click Application registration.
Now you can ignore all instructions and click on File the following button until you reach the last step. Here, click on File Skip this step Link to create the application.
Congratulations, you’ve made a (hard) iOS app.
Step 3: Upgrade to the Blaze plan
To be able to export data to BigQuery, you’ll need to upgrade your Firebase account to use a file fire Plan (Pay As You Go).
tap on Development At the bottom of the Firebase navigation.
Next, tap Choose a plan In Blaze’s column.
Now, you will need to choose a file billing account Configured for Google Cloud Organization/Login. If you don’t have one yet, you will be asked to create one. You will need your credit card for this!
click Complete And Purchase To confirm that you will use the specified billing account for any fees incurred using Firebase and BigQuery.
Step 4: (Optional) Create a BigQuery dataset
If you want to store your BigQuery data somewhere other than the US, you can actually create a BigQuery dataset in advance, and choose where to store the data that way.
If that’s what you want to do, you’ll need to visit the BigQuery console for your project, so open the console in your browser.
First, make sure you choose the correct project from your project selector. The project must match the Firebase project name (
www-simoahava-com In my case).
In the BigQuery project navigator, you should find your project as well. A BigQuery project will have the same name as the Firebase project ID (
Click on the project to open its datasets (there should not be any).
Now, click Create a data set The right side of the dataset explorer.
In the overlay that opens, you need to write a file Dataset ID. Dataset ID should be called In the following format:
analytics_<GA property ID>
This is where the property ID from step 1 comes into play, as you’ll need to name the dataset accordingly.
If you don’t name the dataset correctly, then the data will Not You flow in it, and another dataset (one correctly named) will be automatically created for you in the US.
Now you can also set the location to your liking.
click Create a dataset At the bottom of the overlay when done.
This is what you should see in the dataset explorer view:
Step 5: Prepare the export
Finally, you can set up the export itself.
In the Firebase console, head to Project Settings and click integrals repeatedly. This time, in the BigQuery box, click connection.
Make sure you read lowercase in the first step, then tap the following upon sufficient enlightenment.
In the next step, you will have an overview of what is included in the export. If you want to include Ad IDs in the export, be sure to check the box. It seemed outrageous to me so I chose not to.
click Link to BigQuery When you are ready.
The next view shows you that the link is now done. make sure that Toggle the running dummy app In the Analytics Card. This allows data to be exported from the web stream to BigQuery.
And that’s it! The day after you create this association, you should see a new table in the dataset prefixed with
events_, which will contain all the data for each day of the export, and you can start running these awesome queries on your raw data in no time!
It’s great that we have this “free” BigQuery export for Firebase Analytics projects. I really, really hope it doesn’t get snatched from us. Start.
In its current state, the UI and reporting capabilities of Google Analytics: App + Web leave much to be desired, but the BigQuery export largely compensates for the limitations of the UI. Ability to work with data at the class level leaked, because, for example, it gives us access to event parameters that exceed 50 each project is allocated by default.
Have fun playing with BigQuery, and let me know if you’re having trouble setting up the export!