Streaming Analytics affect both tracking and analytics!

Streaming Analytics will change the way you should think about both tracking and analytics in digital analytics. How? Tracking: Since tracking has been focused on decision making, it has mainly captured performance metrics rather than signals that can be used to personalize the user experience. That has to shift with the advent of streaming analytics. Analytics: In batch analytics you let the query run over your data, but in streaming analytics you let your data run over your query....

July 29, 2021 · 2 min · Robert Sahlin

Get all unique Firebase Analytics events in BigQuery

As I mentioned in my earlier post about the drawbacks with the entity-attribute-value data model used in Firebase Analytics and Google Analytics app plus web, it is hard to know what events and associated attributes and data types are logged without proper documentation. Another way to get an overview is to actually query the table. Below you find an example of how to do it. SELECT event_name, ARRAY_AGG(struct(name, value)) as attribute FROM( SELECT event_name, param....

September 3, 2019 · 2 min · Robert Sahlin

Why Google Analytics App + Web BigQuery Export Rocks and Sucks

Google recently released Google Analytics App + Web which essentially is something like Firebase Analytics for web (or Google Analytics version 2 if you want to). This is exciting for many reasons, two of them are: Google is finally moving away from a user-session-pageview based model to one built on users and events It supports BigQuery export also for standard users That is awesome. These two are actually two of the primary reasons why I built datahem....

September 2, 2019 · 2 min · Robert Sahlin

Configure Firebase Analytics and Google Analytics app + web Bigquery export to EU region

January 2019 when I tried to set up BigQuery export on our Firebase Analytics projects I found out that I couldn’t chose region for the export and that it defaults to US. Since my employer is an European comapny I prefer to store the data in EU. This is the exact same issue that I had previously with GA360 BigQuery Export and I thought I would try to solve it in a similar manner (that has become part of the the GA360 BigQuery Export documentation for how to geolocate your data in EU)....

August 14, 2019 · 2 min · Robert Sahlin

Google Analytics Campaign Timeout Settings

Pretty much every Google Analytics configuration I’ve seen have left the default Campaign Timeout Settings untouched. Also, it came to my knowledge that the tutor/s at the biggest digital analytics post-secondary education in Sweden instruct the students to keep the default settings. Hence, I feel obliged to write a post to clarify why you shouldn’t. Keeping default campaign settings is just plain wrong and will mess up your traffic data in all reports except attribution model comparison tool!...

March 5, 2019 · 3 min · Robert Sahlin