How to Query and Analyze Google Analytics Data with BigQuery

BigQuery is an extremely powerful tool for analyzing massive sets of data. It’s serverless, highly scalable and integrates seamlessly with most popular BI and data visualization tools like Data Studio, Tableau and Looker.

Working with Google Analytics data in BigQuery has mostly been a privilege of those having a 360 version of Google Analytics. Its hefty price tag, though, has made that list quite short.

Read more »

Unsampled Hit-Level Google Analytics Data Without 360

Google Analytics is a really good tool for marketing-focused digital analytics. And by far the most popular one in this segment. With some custom setup, you can also use Google Analytics for tracking SaaS and other web apps & products.

Two of the most common shortcomings of Google Analytics that most of the more advanced users experience, though, are the lack of hit-level granularity and sampling. In this article, we are taking a look at some of the ways you can overcome these shortcomings without spending a fortune on Google Analytics 360.

Read more »

Working with Google Analytics Data Using Python and Jupyter Notebooks

Python is a programming language with virtually limitless functionalities and one of the best languages for working with data. Jupyter Notebooks, on the other hand, is the most popular tool for running and sharing both your Python code and data analysis.

Putting Python and Notebooks together with Google Analytics, the most popular and a really powerful tool for tracking websites, gives you almost like a superpower for doing your analysis.

Read more »

Data You Should Be Tracking Using Google Analytics Custom Events

Out of the box, Google Analytics already tracks a bunch of really useful data points. What the default setup lacks, though, is context and events that are specific to your website and business.

Custom Events provide a perfect solution for adding context and tracking more specific user actions. In this article, we are giving you a good amount of ideas for custom events you should implement on your own and/or your clients’ websites.

Read more »

Using Google Analytics for Tracking SaaS

While it was originally built for tracking general marketing and ecommerce websites, Google Analytics can be configured to track your SaaS app as well. After building tracking setups for 11 different SaaS tools, I can say that Google Analytics excels in tracking SaaS. In this article, I’m giving you a bunch of practical guidelines for doing the same with your own (or your client’s) SaaS app.

Read more »