Why does linear attribution feel so fair?
Linear attribution sounds like a compromise everyone can live with. Every touchpoint gets a share, no favorites, no drama. I’ve used it many times when the business was tired of fighting over “last click”.
Why does it become painful in GA4?
GA4, touchpoints are scattered across events and sessions.
- One user, many sessions
- Many channels
- One conversion at the end
Trying to do everything in one SQL query usually ends in something unreadable — and unmaintainable.
What BigQuery forces you to do?
- Collect all touchpoints per user
- Order them by time
- Count how many steps led to the conversion
Only after that does attribution become manageable.
How I approach it now
I split the task into stages:
- Build the path
- Count steps
- Divide conversion value evenly
Slower to write, much faster to trust.
Want all my best GA4-BQ queries in one place? I turned them into a Chrome extension — top SQL queries you can search and copy in seconds.
Go here to install it for FREE.
Prefer the web version? It's here.
