4 posts in total

GA360 Raw Data

Posts tagged

Weather-Transaction Correlation

Weather can have a significant impact on user behavior. Many businesses think about the impact a hot summer day can have on their conversion rates. But overlapping effects from seasonality and weather require us to provide exact, session-based weather data. One approach is to ext ...

Google Analytics Timings

Google Analytics' standard reporting features for custom timing or duration is minimal. In SQL on raw data, however, this is pretty easy and flexible. In this post, we take a look at how to work more flexibly with the session date, calculate exact timestamps of hits, and analyze ...

Custom Dimensions And Metrics

Having a strong concept for custom dimensions is what differentiates an okay Google Analytics setup from a good one. With GA360, we can specify up to 200 custom dimensions and 200 custom metrics. With all that space, we should generally overuse them instead of being too scarce wi ...

Funnels and Flows

Let's take a look at two approaches for creating a funnel or flow analysis: The typical window navigation query and a simple subquery example. Both approaches only create funnels within one user session how to get around that we review in the end. Window navigation A straightforw ...