Median in BigQuery is a joke
How to easily calculate median in BigQuery? There is solution better than percentile_cont and much better than approx_quantiles!
Transition from Google Analytics to GA4
How to create GA reports from GA4 RawData in BigQuery? It is a challenge which lot’s of companies (data analysts) will face, soon, really soon.
Proper reporting in Data-Driven company
Reporting is crucial thing to go in set direction. How to handle it?
Date range comparison report in Data Studio
Data range comparison is not possible in Data Studio? No! It is possible. Let’s find out how to do it.
Single page application – Proper PageView Measurement (solving issue with google and referrer traffic)
Source / medium parameters being lost for some sessions with Single Page Application? It’s known issue with referrer. Read more to find out the solution.
BigQuery and Data Studio – Free solution for reporting
Business results easily accessible for all company members? With DataStudio you can create such “dashboard” for free!
Cross-Device and Online-Offline Links – How to approach it?
Putting user in center is a challenge in multiple-devices world. What are the technical possibilities to match a user? Let’s find out!
Incremental Facebook ROI / ROAS – Measurement options
Facebook panel shows, that the results of ads are sooo great! Is it believable? Let’s find out how to measure INCREMENTAL impact on business
SQL in BigQuery – First steps in Raw Data Google Analytics 4
Handling Raw Data with SQL (via Google BigQuery) is not (so) hard. Let’s make first reports (queries).
Raw Data from GA4 in Google Cloud / BigQuery – First Steps
Would like to set up Raw Data of your page traffic in Google Cloud? Let’s go through it step by step with Google Analytics 4 and BigQuery.