logo
BigQuery - easier way to calculate median - using UDF function

Median in BigQuery is a joke

  • 28 June 2024
  • Google BigQuery / SQL & Data Studio

How to easily calculate median in BigQuery? There is solution better than percentile_cont and much better than approx_quantiles!

Read more...
Moving from Google Analytics to GA4

Transition from Google Analytics to GA4

  • 25 February 2023
  • Google Analytics 4

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.

Read more...
Reporting in companies - how to

Proper reporting in Data-Driven company

  • 25 February 2023
  • Google Analytics 4

Reporting is crucial thing to go in set direction. How to handle it?

Read more...
Time range comparing in Data Studio

Date range comparison report in Data Studio

  • 25 August 2021
  • Google BigQuery / SQL & Data Studio

Data range comparison is not possible in Data Studio? No! It is possible. Let’s find out how to do it.

Read more...
issue with Single Page Application measurement Google Analytics

Single page application – Proper PageView Measurement (solving issue with google and referrer traffic)

  • 11 June 2021
  • Performance (e-commerce) marketing

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.

Read more...
Free Data Visulalisation Tool - Data Studio with BigQuery

BigQuery and Data Studio – Free solution for reporting

  • 19 March 2021
  • Google BigQuery / SQL & Data Studio

Business results easily accessible for all company members? With DataStudio you can create such “dashboard” for free!

Read more...
Cross device - how to match users between browsers and offline

Cross-Device and Online-Offline Links – How to approach it?

  • 16 March 2021
  • Performance (e-commerce) marketing

Putting user in center is a challenge in multiple-devices world. What are the technical possibilities to match a user? Let’s find out!

Read more...
Facebook ads impact on business - incementally

Incremental Facebook ROI / ROAS – Measurement options

  • 9 March 2021
  • Performance (e-commerce) marketing

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

Read more...
SQL & BigQuery & Google Analytics 4

SQL in BigQuery – First steps in Raw Data Google Analytics 4

  • 5 March 2021
  • Google BigQuery / SQL & Data Studio

Handling Raw Data with SQL (via Google BigQuery) is not (so) hard. Let’s make first reports (queries).

Read more...
GA4 Set Up with Raw Data on Google Cloud

Raw Data from GA4 in Google Cloud / BigQuery – First Steps

  • 3 March 2021
  • Google Analytics 4

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.

Read more...
  • 1
  • 2
  • >>
Richard Kozlowski

Hi!
My name is Richard and I would like to help you with digital marketing. Especially page tagging, as in my opinion it is crucial aspect of all online marketing.

I belive that:
(Properly) measured statistics improve over time.

email dronsom

Don't hesitate to contact me at:
rkozlowski@dronsom.com

Measurement issues solved:

KFC logo
KFC logo
G2A logo

Find me on social media:

Richard Kozlowski LinkedIn profile
Richard Kozlowski Twitter profile
Richard Kozlowski Facebook profile

Dronsom

Let's bring your online marketing to the next level.

Dronsom - Copyright © 2025
  • E-commerce Blog
  • Credentials
  • Audits
  • Privacy Policy