![BigQuery - easier way to calculate median - using UDF function](https://dronsom.com/wp-content/uploads/2024/06/Calculating_median_with_ease_using_udf_function.png)
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!
![Moving from Google Analytics to GA4](https://dronsom.com/wp-content/uploads/2023/02/Transition-Google-Analytics-to-Google-Analytics-4.png)
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.
![Reporting in companies - how to](https://dronsom.com/wp-content/uploads/2023/02/Reporting-for-data-driven-organization.png)
Proper reporting in Data-Driven company
Reporting is crucial thing to go in set direction. How to handle it?
![Time range comparing in Data Studio](https://dronsom.com/wp-content/uploads/2021/08/Date-range-comparison-reporting-in-Data-Studio.png)
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.
![issue with Single Page Application measurement Google Analytics](https://dronsom.com/wp-content/uploads/2021/06/source-medium-lost-in-traffic-for-Single-Page-Application.png)
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.
![Free Data Visulalisation Tool - Data Studio with BigQuery](https://dronsom.com/wp-content/uploads/2021/03/Data-Studio-with-BigQuery-Robust-data-visualisation-tool.png)
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 - how to match users between browsers and offline](https://dronsom.com/wp-content/uploads/2021/03/Cross-device-with-offline-and-online-ROPO-User-Centered-1.png)
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!
![Facebook ads impact on business - incementally](https://dronsom.com/wp-content/uploads/2021/03/Proper-measurement-of-facebook-ads-1.png)
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 & BigQuery & Google Analytics 4](https://dronsom.com/wp-content/uploads/2021/03/First-steps-in-BigQuery-with-Raw-Data-from-Google-Analytics-4-1.png)
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).
![GA4 Set Up with Raw Data on Google Cloud](https://dronsom.com/wp-content/uploads/2021/03/GA4-Raw-Data-in-BigQuery-Google-Cloud-SetUp-First-Steps.png)
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.