alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
About
Courses
tag:
web-analytics
Thursday
Apr 30, 2026
How to Use TABLESAMPLE in BigQuery for Prototyping — and Why It Saves Real Money on Large GA4 Data?
Thursday
Apr 30, 2026
How to Use APPROX_COUNT_DISTINCT in BigQuery — and When to Trade Accuracy for Query Cost?
Thursday
Apr 30, 2026
How to Use MERGE in BigQuery to Update Marketing Data Warehouses Without Full Recalculation?
Thursday
Apr 30, 2026
Principles over Tactics
Thursday
Apr 30, 2026
Metrics aren't about measurement. They're about substitution.
Wednesday
Apr 29, 2026
How GA4 Records Offline Events — and Why Their Timestamp Breaks Your Session Timeline?
Wednesday
Apr 29, 2026
Proxy on proxy: how the SaaS industry lost itself in its own metrics
Wednesday
Apr 29, 2026
How to Calculate Bounce Rate in BigQuery
Wednesday
Apr 29, 2026
How to Calculate Median Order Value in BigQuery — and Why It’s More Honest Than Average
Wednesday
Apr 29, 2026
Why Are Clicks Higher Than Sessions Again?
#
GA4
Sunday
22 Feb
How to Build Reliable Channel Grouping in GA4 BigQuery Without Fighting source/medium Forever
#
BigQuery
Sunday
22 Feb
Why Your BigQuery Numbers Don’t Match “Reality” (Or GA4)?
#
Metrics
Sunday
22 Feb
How Bad Event Timing Breaks Every Product Conclusion?
#
BigQuery
Sunday
22 Feb
Why it's challenging to compare MoM in BiQuery?
#
GA4
Sunday
22 Feb
How Do You Explain GA4 Number Mismatches to a CEO?
#
GA4
Sunday
22 Feb
Are You Measuring Retention — or Just Recounting Sessions?
#
Metrics
Sunday
22 Feb
Why Do Metrics Start Contradicting Each Other — Even From the Same Source?
#
Metrics
Sunday
22 Feb
Why Does Analytics Increase Tension Between Marketing, Product, and Finance?
#
Metrics
Sunday
22 Feb
Why Does a CMO Feel Responsible For Numbers He Doesn’t Actually Control?
#
Metrics
Sunday
22 Feb
How to Calculate Retention with SQL Window Functions (Without Mixing Everything Together)
#
Metrics
Sunday
22 Feb
Why Do Numbers Stop Helping Teams Agree — And Start Defending Positions?
#
Metrics
Sunday
22 Feb
How to Shift Attribution from Last Click to First Click in SQL
#
Metrics
Sunday
22 Feb
Why Does Adding More Reports Increase Blindness Instead of Transparency?
#
Metrics
Sunday
22 Feb
Why Does a CMO Trust Numbers More Than the Team — And Still Doubt Both?
#
Metrics
Sunday
22 Feb
Why Do Metrics Stop Reflecting Reality When the Business Becomes More Complex?
#
Metrics
Sunday
22 Feb
Why Meta Often Claims Credit for Conversions Finalized Through Email
#
Metrics
Sunday
22 Feb
How Do Metrics Change Their Meaning When Marketing Scales Faster Than the Analytics Model?
#
Metrics
Sunday
22 Feb
What Happens to Attribution When Marketing and Product Speak Different Event Languages?
#
Metrics
Sunday
22 Feb
Why can two analysts honestly read the same data — and disagree completely?
#
GA4
Sunday
22 Feb
How do time zones, attribution windows, and aggregation rules quietly break reports?
#
GA4
Sunday
22 Feb
Identifying Abandoned Carts in GA4 BigQuery Without Overcomplicating the Logic
#
Metrics
Sunday
22 Feb
Why do analytics reports look correct — but still lead to bad business decisions?
#
BigQuery
Sunday
22 Feb
How to Track N-Day Retention With SQL Window Functions in BigQuery?
#
BigQuery
Sunday
22 Feb
How to Calculate Net Revenue (After Refunds) in BigQuery?
#
GA4
Sunday
22 Feb
Why Does GA4’s Geography Report Not Match CRM Data?
#
GA4
Sunday
22 Feb
Why Does the Funnel in GA4 Never Match Reality?
#
Metrics
Sunday
22 Feb
What Happens to Analytics After the Only Analyst Leaves? How does it usually look?
#
BigQuery
Sunday
22 Feb
How to Calculate Payback Period on Marketing Spend in BigQuery?
#
GA4
Sunday
22 Feb
Why 20 CSV Files Will Never Give You Good Analytics
#
Metrics
Saturday
21 Feb
How to Attribute Conversions to the First Click (Instead of Last) in SQL?
#
GA4
Tuesday
2 Dec
How to understand traffic sources in GA4 without losing your mind?
#
GA4
Tuesday
2 Dec
How does GA4 conversion rate mislead us?
#
GA4
Tuesday
2 Dec
Can GA4 multi-channel attribution be trusted?
#
BigQuery
Tuesday
2 Dec
What Is Partitioning and How Does It Work in GA4 Export to BigQuery?
#
BigQuery
Monday
1 Dec
How to Calculate Conversion Rate by Landing Page in BigQuery?
#
GA4
Monday
1 Dec
What Happens To Tracking When the User Is On iOS - Are You Counting That?
#
GA4
Monday
1 Dec
How Many Purchases Are Lost Due To Browser-Based Tracking — And How Does That Show Up In GA4?
#
BigQuery
Monday
1 Dec
How to Query Multiple GA4 events_ Tables with _TABLE_SUFFIX in BigQuery
#
GA4
Sunday
30 Nov
What Does An “engaged session” in GA4 Really Mean — And What Does It Have To Do With Actual Engagement?
#
BigQuery
Sunday
30 Nov
How to Calculate Conversion Rate in BigQuery
#
GA4
Sunday
30 Nov
How Long Does a User Session Actually Last — And Does It Affect How You Measure Performance?
#
GA4
Sunday
30 Nov
Are You Sure GA4 is Handling Your UTM Tags Correctly?
#
GA4
Sunday
30 Nov
Why You Shouldn’t Use event_name = 'first_visit' to Count New Users
#
GA4
Sunday
30 Nov
Why GA4 Data Is Delayed — And Why You're Making Budget Decisions Today
#
GA4
Sunday
30 Nov
How to Decode Custom Parameters in GA4 BigQuery (Without Losing Your Mind)
#
GA4
Sunday
30 Nov
GA4 Shows You “users” — But Are You Sure They’re Real People?
#
BigQuery
Sunday
30 Nov
How to Calculate New vs. Repeat Purchases in BigQuery (Without Losing Faith in Humanity)
#
GA4
Sunday
30 Nov
How Custom Parameters in GA4 Can Quietly Break Your Reports — Have You Checked Yours?
#
BigQuery
Sunday
30 Nov
How to Measure User Churn in BigQuery Using GA4 Data
#
GTM
Sunday
30 Nov
How to Set Up GTM for Meta Without Losing Data
#
GA4
Thursday
31 Jul
What Is event_bundle_sequence_id in GA4?
#
Metrics
Wednesday
30 Jul
So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)
#
Metrics
Wednesday
30 Jul
How Native Facebook Pixel Integrations Quietly Kill Your Optimization
#
Metrics
Wednesday
30 Jul
META AND YANDEX EXPOSED: Privacy on Android is a Myth
#
GA4
Wednesday
30 Jul
Consent Mode Is On — But Your Data’s Gone? Here’s a 5-Minute Sanity Check.
#
GA4
Wednesday
30 Jul
Google Renamed a Cookie. Again. Not a Disaster — Just Mildly Annoying
#
GA4
Wednesday
30 Jul
Consent Mode Is On. So Where’s The Data?
#
GA4
Wednesday
30 Jul
One Tiny GA4 Setting That Could Be Costing You Tens Of Thousands in Ad Spend
#
GA4
Monday
21 Apr
Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?
#
BigQuery
Monday
21 Apr
Unlock the Power of Google Cloud with the VS Code Extension!
#
BigQuery
Monday
21 Apr
Which Python Package to Use for Attribution Calculation?
#
GA4
Monday
21 Apr
The Most Useless Feature in Analytics Tools
#
GTM
Monday
21 Apr
"Still Running" Tags in Google Tag Manager: Why It Happens and How to Fix It
#
GA4
Monday
21 Apr
How to Find Out How Much Data You're Losing Due to Consent Mode in GA4?
#
GA4
Monday
21 Apr
3 Simple Ways to Enable DebugView in Google Analytics 4
#
GA4
Monday
21 Apr
Experimented with Consent Mode v2 and noticed a sudden drop in traffic in GA4?
#
BigQuery
Monday
21 Apr
How to Send Data to BigQuery with SGTM: Easy and Stress-Free
#
Metrics
Monday
21 Apr
Stop A/B Testing!
#
BigQuery
Monday
21 Apr
How to Transfer Data from MySQL or PostgreSQL to BigQuery?
#
Metrics
Monday
21 Apr
How to Stop UTM Parameters from Disappearing (and Keep You Happy)
#
Metrics
Sunday
20 Apr
Safari vs. UTM: Do We Really Need to Panic?
#
GTM
Sunday
20 Apr
Custom Pixel in Shopify: What It Is and Why You Need It
#
GTM
Sunday
20 Apr
How to Debug Checkout Events in Shopify
#
BigQuery
Sunday
20 Apr
Deduplicate This Immediately!
#
Books & Videos
Sunday
20 Apr
NEW YOUTUBE VIDEO!
#
GA4
Sunday
20 Apr
When Conversions Don't Match Sales
#
GA4
Sunday
20 Apr
How to Evaluate Ad Campaigns in Google Analytics (Without Losing Your Mind)
#
GA4
Sunday
20 Apr
How I Got into Google Analytics (For Real)
#
GA4
Sunday
20 Apr
Are You Really Sure You Understand Google Analytics?
#
GA4
Sunday
20 Apr
How to Set Up Google Ads Analytics Without Messing Things Up
#
Metrics
Sunday
20 Apr
Advanced CRO Calculator for FREE
#
GA4
Sunday
20 Apr
Why "Free" Analytics Is a Myth
#
BigQuery
Tuesday
10 Dec
How to Quickly Obtain Percentile Values in BigQuery?
#
GTM
Tuesday
10 Dec
A Fresh Guide to Duplicating GTM Containers by Simo Ahava
#
GTM
Tuesday
10 Dec
Conversion Linker Now Supports Local Storage
#
Metrics
Tuesday
10 Dec
Post-View Attribution: Everything You Didn't Know but Were Afraid to Ask
#
GA4
Tuesday
10 Dec
Detecting Anomalies in GA4 Data with BigQuery and Dataform
#
GTM
Tuesday
10 Dec
How to Send Data from sGTM to Google Sheets with Stape
#
BigQuery
Tuesday
10 Dec
How to Recover a Deleted Table in BigQuery?
#
BigQuery
Tuesday
10 Dec
Google Explains the Difference Between Daily Export and Fresh Daily Export in BigQuery
#
Metrics
Tuesday
10 Dec
Common Mistakes in ROI Calculations Due to Attribution Model Specifics
#
GA4
Saturday
9 Nov
All Methods to Track Conversions in GA4
#
Metrics
Saturday
9 Nov
What is the Difference between ROI, ROMI and ROAS?
#
GA4
Saturday
9 Nov
Consent Mode Settings and Measurement Protocol
#
GA4
Saturday
9 Nov
Extensions for Displaying the Percentage of the Total in GA4
#
GTM
Saturday
9 Nov
How to Monitor GTM Server Side?
#
GTM
Saturday
9 Nov
Tracking Single Page Applications (SPA) - Official Google Documentation
#
Metrics
Friday
8 Nov
Leading and Lagging Metrics - What's the Difference in a Nutshell?
#
Metrics
Friday
8 Nov
What is the Top Score Attribution?
#
BigQuery
Friday
8 Nov
Grouping by All in BigQuery! Finally!
#
Metrics
Friday
8 Nov
Why Can't You Rely on Facebook Ads Analytics?
#
Metrics
Friday
8 Nov
Behavioral Modeling for Consent Mode v2 - It's Not What You Might Think!
#
GA4
Friday
8 Nov
Update on User-Provided Data in GA4
#
GA4
Friday
8 Nov
What's Important to Know About Conversions and Key Events in GA4
#
Metrics
Friday
8 Nov
Core Web Vitals - What Are They and How to Work with Them?
#
GTM
Friday
8 Nov
Do You Want Your Own Hub for Offline Conversions?
#
Metrics
Friday
8 Nov
Tips for Optimizing Conversion Rates
#
BigQuery
Friday
8 Nov
Google Increased the Maximum Number of Partitions for BigQuery
#
Metrics
Friday
8 Nov
Custom Parameters in Yandex Metrica
#
Books & Videos
Friday
8 Nov
First Party Mode from Google
#
Metrics
Friday
8 Nov
Tea-tasting package for A/B-testing in Python
#
Metrics
Friday
8 Nov
Market Map of Product Analytics
#
BigQuery
Friday
8 Nov
How to Calculate Cumulative WAU and MAU in BigQuery?
#
BigQuery
Friday
8 Nov
The Ultimate Guide to the UNNEST in BigQuery
#
GA4
Friday
8 Nov
Everything Old is New Again
#
BigQuery
Friday
8 Nov
What's the Deal with STRUCTS and ARRAYS in BigQuery?
#
BigQuery
Tuesday
5 Nov
BigQuery now has Workflows!
#
GA4
Tuesday
5 Nov
Data Export Limits in GA4 Have Increased!
#
BigQuery
Tuesday
5 Nov
How to Do a Rolling Count Distinct in BigQuery?
#
BigQuery
Tuesday
5 Nov
New Traffic Fields in BigQuery: Enhanced Channel Analysis
#
BigQuery
Tuesday
5 Nov
Best Practices for Partitioning in BigQuery
#
BigQuery
Tuesday
5 Nov
How to Calculate LTV by Cohorts in BigQuery?
#
BigQuery
Sunday
1 Sep
Why You Should Use QUALIFY in BigQuery
#
Friday
21 Jun
Web Analytics Space In Amplitude
#
Books & Videos
Tuesday
18 Jun
How long did it take for Google Chrome to conquer the market?
#
GTM
Wednesday
29 May
Tips For Form Optimization
#
GA4
Tuesday
21 May
Google Analytics Query Explorer
#
GA4
Thursday
18 Apr
The easiest way to create a funnel in Looker Studio
Looking to build a funnel in Looker Studio? It's as simple as can be!
bigquery
ga4
metrics
gtm
server-side
attribution
education
abtest
web-analytics
product-analytics
2024
analytics@add-2-cart.online
-p-800.jpg)
