alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
About
Courses
tag:
ga4
#
GA4
Sunday
22 Feb
When Does Analytics Stop Measuring and Start Interpreting?
#
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)?
#
GA4
Sunday
22 Feb
What Does Session Duration in GA4 Actually Measure – and Should You Trust It?
#
Metrics
Sunday
22 Feb
How an Analyst Loses Control of Metrics — Even Knowing SQL
#
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
Which GA4 Fields Should Never Be Used for Business Decisions?
#
GA4
Sunday
22 Feb
How Do You Explain GA4 Number Mismatches to a CEO?
#
Metrics
Sunday
22 Feb
How Can One Window Function Break Your Metrics?
#
GA4
Sunday
22 Feb
Are You Measuring Retention — or Just Recounting Sessions?
#
GA4
Sunday
22 Feb
Can You Rely on GA4’s Attribution Models for Budget Decisions?
#
Metrics
Sunday
22 Feb
Why GA4 and BigQuery Don’t Always Agree on Daily Metrics
#
BigQuery
Sunday
22 Feb
How to Measure Conversion Rate by Landing Page in BigQuery
#
GA4
Sunday
22 Feb
How to Rebuild Sessions in GA4 + BigQuery Without Relying on session_start
#
GA4
Sunday
22 Feb
How Confident Are You That GA4 Preserves Your UTM Parameters?
#
BigQuery
Sunday
22 Feb
Building a Custom Attribution Model in SQL: A More Realistic Way to Assign Credit
#
BigQuery
Sunday
22 Feb
Using ARRAY_AGG in BigQuery to Rebuild User Paths from Raw Events
#
BigQuery
Sunday
22 Feb
Rethinking Conversion Rate in BigQuery: A Practical Approach
#
Metrics
Sunday
22 Feb
How Do Metrics Change Their Meaning When Marketing Scales Faster Than the Analytics Model?
#
GA4
Sunday
22 Feb
Why GA4 Often Shows Fewer Transactions Than Your Payment Gateway
#
GA4
Sunday
22 Feb
Calculating CLV With SQL: Why Window Functions Change the Entire Approach
#
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?
#
GTM
Sunday
22 Feb
Why does “properly configured” tracking still feel unreliable?
#
GA4
Sunday
22 Feb
Identifying Abandoned Carts in GA4 BigQuery Without Overcomplicating the Logic
#
GA4
Sunday
22 Feb
What happens when you trust GA4 modeling - but never look at raw events?
#
GA4
Sunday
22 Feb
Counting New Users in GA4 BigQuery? Avoid the first_visit Trap
#
GA4
Sunday
22 Feb
Why does the same user become three different people in GA4, BigQuery, and your CRM?
#
GTM
Sunday
22 Feb
How can server-side GTM make your data worse — even if it was set up “by the book”?
#
GA4
Sunday
22 Feb
Stop Using session_start as Your Primary Session Counter in GA4 BigQuery
#
Metrics
Sunday
22 Feb
Why do analytics reports look correct — but still lead to bad business decisions?
#
GA4
Sunday
22 Feb
How to Calculate Net Dollar Retention (NDR) With SQL Window Functions?
#
GA4
Sunday
22 Feb
How does Consent Mode quietly rewrite your reports - and why don’t you see the real scale of loss?
#
BigQuery
Sunday
22 Feb
How to Track N-Day Retention With SQL Window Functions in BigQuery?
#
BigQuery
Sunday
22 Feb
How to Calculate ARPU (Average Revenue Per User) in BigQuery?
#
GA4
Sunday
22 Feb
How to Track Subscription Renewals in GA4 Export Data?
#
GA4
Sunday
22 Feb
How to Calculate Churn Rate in SQL Using GA4 Export Data?
#
GTM
Sunday
22 Feb
What’s Left of Analytics If You Lose Access to the GTM Container?
#
GA4
Sunday
22 Feb
Can You Really Trust Average Session Duration in GA4?
#
BigQuery
Sunday
22 Feb
How to Track Trial-to-Paid Conversion in BigQuery for SaaS?
#
GA4
Sunday
22 Feb
Why Track Dozens of GA4 Events If the Business Only Needs Five?
#
BigQuery
Sunday
22 Feb
How to Calculate Net Revenue (After Refunds) in BigQuery?
#
GA4
Sunday
22 Feb
Why Does the Same Channel Show Different Revenue in GA4 vs. BI?
#
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
How to Calculate CLV (Customer Lifetime Value) With SQL Window Functions?
#
GA4
Sunday
22 Feb
Why Does Retention Look Different in Product Analytics vs. GA4?
#
GA4
Sunday
22 Feb
Can You Trust GA4 When Data Updates Lag by 48 Hours? Why does this matter?
#
GA4
Sunday
22 Feb
Where Does the gclid Go When Landing Pages and Redirects Get Involved?
#
GA4
Sunday
22 Feb
How to Build a True First Organic Click Attribution Model in SQL?
#
Metrics
Sunday
22 Feb
Why Does Analytics Collapse When You Split With an Agency — And How to Avoid It?
#
BigQuery
Sunday
22 Feb
How to Calculate Payback Period on Marketing Spend in BigQuery?
#
GA4
Sunday
22 Feb
How Excel and Google Sheets Turn You Into a Reporting Slave
#
GA4
Sunday
22 Feb
Why 20 CSV Files Will Never Give You Good Analytics
#
Metrics
Sunday
22 Feb
Why Do We Collect Dozens of Metrics No One Uses?
#
BigQuery
Saturday
21 Feb
How to Correctly Calculate AOV (Average Order Value) in BigQuery?
#
GA4
Saturday
21 Feb
Can You Trust Google Ads Data? What really happens to your clicks?
#
GA4
Saturday
21 Feb
Can You Trust GA4’s Attribution?
#
GA4
Saturday
21 Feb
How do Safari and ITP affect attribution in GA4 and CRM?
#
GA4
Saturday
21 Feb
Why client_id isn’t enough to link offline events to GA4?
#
Metrics
Saturday
21 Feb
How to Correctly Calculate Retention Rate with SQL Window Functions?
#
GA4
Tuesday
2 Dec
How to understand traffic sources in GA4 without losing your mind?
#
GA4
Tuesday
2 Dec
What’s the Right Way to Join GA4 Events and CRM Orders in BigQuery?
#
GA4
Tuesday
2 Dec
How does GA4 conversion rate mislead us?
#
GA4
Tuesday
2 Dec
Can GA4 multi-channel attribution be trusted?
#
GA4
Tuesday
2 Dec
How to Build a Custom Attribution Model in SQL (Without Crying)
#
BigQuery
Tuesday
2 Dec
Top Three Ways to Reduce Your BigQuery Query Costs
#
BigQuery
Tuesday
2 Dec
Why do GA4 to BigQuery reports lag by a day?
#
GA4
Tuesday
2 Dec
Why do GA4 reports show fewer transactions than the payment gateway?
#
BigQuery
Tuesday
2 Dec
Why do GA4 and BigQuery reports differ for the same day?
#
BigQuery
Tuesday
2 Dec
What Is Partitioning and How Does It Work in GA4 Export to BigQuery?
#
Metrics
Tuesday
2 Dec
How is CPA defined in Ads Manager and CRM - do they match?
#
BigQuery
Tuesday
2 Dec
All About Traffic Source Parameters in GA4 Export to BigQuery
#
BigQuery
Tuesday
2 Dec
How does wrong user_id setup break analytics?
#
GA4
Monday
1 Dec
How much do 70% cookie banner refusals affect GA4 data?
#
BigQuery
Monday
1 Dec
How to Calculate Conversion Rate by Landing Page in BigQuery?
#
GA4
Monday
1 Dec
How GA4's default session timeout can cost your business millions?
#
GA4
Monday
1 Dec
How to Find Abandoned Carts in GA4 BigQuery - Without Abandoning Your Sanity
#
GA4
Monday
1 Dec
Who Actually Benefits From GA4 Inaccuracies - You, the Agency, or the Platform?
#
GA4
Monday
1 Dec
How to Quickly Build a Session Table in GA4 + BigQuery (Without Questioning Reality)
#
GA4
Monday
1 Dec
Have You Checked If Purchases Are Being Lost Without Server-Side Tracking?
#
GA4
Monday
1 Dec
How to Handle String, Integer, and Float Parameter Values in GA4 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
#
GTM
Monday
1 Dec
How Do You Know Platforms Aren’t Getting Distorted Data Without GTM Server-Side?
#
GA4
Monday
1 Dec
How to Build Accurate Channel Grouping in GA4 BigQuery (Without Losing Your Mind Over source/medium)?
#
GA4
Monday
1 Dec
Can You Trust the Conversion Rate in GA4 - And How Is It Actually Calculated?
#
GA4
Sunday
30 Nov
Why a Scroll Event in GA4 Doesn’t Mean Someone Actually Read Your Content
#
Books & Videos
Sunday
30 Nov
NEW VIDEO! “Why do CONVERSIONS never match across platforms?”
#
BigQuery
Sunday
30 Nov
How to Use IFNULL and SAFE_CAST to Clean Custom Parameters in BigQuery
#
BigQuery
Sunday
30 Nov
How to Use ARRAY_AGG in BigQuery to Reconstruct User Journeys (Without Losing Your Mind)
#
GA4
Sunday
30 Nov
What’s Really Behind the “Traffic Source” in GA4 — And Why Does It Show Up Differently Everywhere?
#
Metrics
Sunday
30 Nov
Which Of The Three Conversion Metrics in GA4 Are You Using — And Do You Know the Difference?
#
BigQuery
Sunday
30 Nov
Why You Shouldn't Use session_start to Count Sessions in GA4 BigQuery
#
GA4
Sunday
30 Nov
What Does An “engaged session” in GA4 Really Mean — And What Does It Have To Do With Actual Engagement?
#
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
Do You Compare Two Periods in GA4 — And Do You Know It Might Be Misleading?
#
GA4
Sunday
30 Nov
How to Use GA4 + BigQuery to Measure CAC — Without Burning Your Entire Marketing Budget
#
GA4
Sunday
30 Nov
Why GA4 Data Is Delayed — And Why You're Making Budget Decisions Today
#
GA4
Sunday
30 Nov
Where Does Your Money Go With Black-Box Attribution in GA4 — And How Does It Affect Your Budget?
#
GA4
Sunday
30 Nov
What Do You Actually See in a GA4 Funnel — And How Much Does It Reflect Real User Behavior?
#
GA4
Sunday
30 Nov
How to Decode Custom Parameters in GA4 BigQuery (Without Losing Your Mind)
#
GA4
Sunday
30 Nov
Did You Know GA4 Uses HLL++ — And You’re Not Seeing Exact Numbers?
#
GA4
Sunday
30 Nov
GA4 Shows You “users” — But Are You Sure They’re Real People?
#
BigQuery
Sunday
30 Nov
Why Do Custom Dimensions Sometimes Not Show Up in BigQuery?
#
GA4
Sunday
30 Nov
Why Don’t GA4 And BigQuery Data Match — And Which One Should You Trust?
#
BigQuery
Sunday
30 Nov
How to Calculate New vs. Repeat Purchases in BigQuery (Without Losing Faith in Humanity)
#
GA4
Sunday
30 Nov
Are You Sure Your GA4 is Set Up Correctly — Without Server-Side Tracking?
#
GA4
Sunday
30 Nov
How Custom Parameters in GA4 Can Quietly Break Your Reports — Have You Checked Yours?
#
GA4
Sunday
30 Nov
How to Work with item_id in GA4 BigQuery (Without Losing Your Mind)
#
GA4
Sunday
30 Nov
Why Is Some Of Your Traffic Ending Up in (direct)/(none) — And How Much Is That Costing Your Marketing?
#
BigQuery
Sunday
30 Nov
How to Measure User Churn in BigQuery Using GA4 Data
#
GA4
Sunday
30 Nov
Are You Losing Purchase Events in GA4 — And How Does That Impact Your Profit Calculations?
#
BigQuery
Sunday
30 Nov
How to Calculate Conversion Rate in BigQuery
#
Metrics
Sunday
30 Nov
How to Properly Handle Offline Conversions in Meta
#
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
Thursday
31 Jul
What to Do When Meta Claims Credit for Conversions It Didn’t Earn
#
BigQuery
Wednesday
30 Jul
Why Does BigQuery Show More Users Than the GA4 Interface — and Who’s Telling the Truth?
#
Metrics
Wednesday
30 Jul
How to Avoid Wasting Money on Meta Campaign Tracking — and Get Accurate Data
#
Metrics
Wednesday
30 Jul
How to Track Creatives in Meta Ads at Scale?
#
Metrics
Wednesday
30 Jul
How Server-Side Tracking Can Save Your Meta Campaign
#
Metrics
Wednesday
30 Jul
5 Myths About Consent Mode That Are Costing You Money — Let’s Break Them Down
#
Metrics
Wednesday
30 Jul
So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)
#
GA4
Wednesday
30 Jul
Launched a Facebook Campaign — And GA4 Suddenly Shows a Spike In Direct Traffic? Weird, Right?
#
Metrics
Wednesday
30 Jul
How To Survive Multiple Attribution Models And Keep Your Sanity (And Budget)
#
Metrics
Wednesday
30 Jul
Tracking Purchases On The “Thank You” Page? And Where’s The Money?
#
GA4
Wednesday
30 Jul
How Automatic GA4 Events Quietly Ruin Your Server-Side Tracking
#
Metrics
Wednesday
30 Jul
48MB of Pain: How Excel Kills Your Marketing Analytics
#
Metrics
Wednesday
30 Jul
Why Meta Doesn’t See Your Conversions (And What To Do About It)
#
GA4
Wednesday
30 Jul
Consent Mode Is On — But Your Data’s Gone? Here’s a 5-Minute Sanity Check.
#
BigQuery
Wednesday
30 Jul
The Aggregated Report Looks Great. The Decisions? Not So Much.
#
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
Meta Says 170 Conversions. Google Ads Shows 85. GA4 Lands at 110. So... Who’s Telling The Truth?
#
GTM
Wednesday
30 Jul
Basic Consent Mode – For Those Who Enjoy a Bit Of Pain (On Purpose)
#
GA4
Wednesday
30 Jul
One Tiny GA4 Setting That Could Be Costing You Tens Of Thousands in Ad Spend
#
GA4
Wednesday
30 Jul
“Our Attribution is Very Complex” — Why That’s Often Just an Excuse
#
GA4
Wednesday
30 Jul
Can You Trust Modeled Data in GA4?
#
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!
#
GTM
Monday
21 Apr
Automatic Setup of First-party Mode for GTM Using Cloudflare
#
BigQuery
Monday
21 Apr
Which Python Package to Use for Attribution Calculation?
#
GA4
Monday
21 Apr
Understanding User ID in GA4: Everything You Should Know
#
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?
#
GA4
Monday
21 Apr
First-Party Mode vs. Server-Side Tracking: What's the Difference?
#
BigQuery
Monday
21 Apr
LOGICAL_OR and LOGICAL_AND in BigQuery: segment your data without losing your mind
#
GA4
Monday
21 Apr
Choosing the Right GA4 Integration Method for Your Shopify Store
#
Metrics
Monday
21 Apr
How to Stop UTM Parameters from Disappearing (and Keep You Happy)
#
GTM
Sunday
20 Apr
Accessing Cookies in Shopify Checkout with Server-Side GTM
#
BigQuery
Sunday
20 Apr
What is the Signals Gateway by Meta?
#
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
How to Get Simple, Clear Reports in Google Analytics?
#
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
#
GA4
Sunday
20 Apr
Why "Free" Analytics Is a Myth
#
GA4
Sunday
20 Apr
How to Choose a Google Ads Agency Without Regretting It Later
#
GA4
Sunday
20 Apr
Google Tag Manager Has a JavaScript Problem (and a Sneaky Fix!)
#
GA4
Sunday
20 Apr
How I Use Google Analytics Every Day
#
GA4
Saturday
19 Apr
Debugging sGTM used to be a pain - until I found this
#
GA4
Saturday
19 Apr
Consent Mode in GA4 – What It Is and Why It Might Melt Your Brain a Little
#
GA4
Saturday
19 Apr
Why Your GA4 Numbers Don't Match
#
Books & Videos
Saturday
19 Apr
New video! From first click to repeat purchase - reporting for eCommerce that actually makes sense
#
GA4
Saturday
19 Apr
When the GA4 community builds the features Google forgot
#
BigQuery
Tuesday
10 Dec
The GCLID Issue in BigQuery and How to Solve It
#
GA4
Tuesday
10 Dec
Issue with Sending Events via Measurement Protocol with user_id
#
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
Quickly Analyzing Revenue Distribution by Customer with GA4 and BigQuery
#
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
#
GTM
Saturday
9 Nov
Traffic Attribution in Single Page Applications
#
GA4
Saturday
9 Nov
All Methods to Track Conversions in GA4
#
GA4
Saturday
9 Nov
Consent Mode Settings and Measurement Protocol
#
BigQuery
Saturday
9 Nov
Custom Channels Groupping in BigQuery
#
BigQuery
Saturday
9 Nov
What are BigQuery Materialized Views?
#
GA4
Saturday
9 Nov
Extensions for Displaying the Percentage of the Total in GA4
#
BigQuery
Saturday
9 Nov
How to Parse URLs in BigQuery?
#
GA4
Saturday
9 Nov
How to Debug Measurement Protocol Requests in GA4?
#
GA4
Saturday
9 Nov
Why Use Custom Channel Groups in GA4?
#
GA4
Friday
8 Nov
GA4 and Google Sheets Integration
#
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
#
GA4
Friday
8 Nov
How to Fix "(no set)" in Google Analytics 4 Reports?
#
GTM
Friday
8 Nov
Do You Want Your Own Hub for Offline Conversions?
#
GA4
Friday
8 Nov
User Data Import without Website Visits
#
GA4
Friday
8 Nov
Conversion Rate in GA4
#
Metrics
Friday
8 Nov
What's Available for Marketing Attribution in 2024 Besides GA?
#
GA4
Friday
8 Nov
New traffic_source parameter in BigQuery
#
GA4
Friday
8 Nov
No More Custom event_timestamp in BigQuery?
#
Friday
8 Nov
Excel Connector for Looker Studio
#
BigQuery
Friday
8 Nov
The Ultimate Guide to the UNNEST in BigQuery
#
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
How to Get the Landing Page in BigQuery
#
BigQuery
Tuesday
5 Nov
How to Create a Sequential eCommerce Funnel in BigQuery
#
BigQuery
Tuesday
5 Nov
How to Create a Session Table with the session_traffic_source_last_click Field in BigQuery?
#
BigQuery
Sunday
1 Sep
Why You Should Use QUALIFY in BigQuery
#
GA4
Friday
16 Aug
Review of Simo Ahava's Course "Chrome DevTools For Digital Marketers"
#
GA4
Wednesday
26 Jun
GA4 For Notion Pages
#
BigQuery
Friday
21 Jun
GA4-BigQuery Cheat Sheet
#
GA4
Tuesday
21 May
Google Analytics Query Explorer
#
GA4
Monday
13 May
How do Google tags operate with different consent mode settings?
#
GA4
Tuesday
7 May
Consent Mode v2: A Comprehensive Guide
#
BigQuery
Tuesday
20 Feb
You are losing money on your BigQuery bills
#
BigQuery
Tuesday
20 Feb
How to calculate session attribution in BigQuery?
#
GTM
Tuesday
20 Feb
What parameters do I send with each event?
#
Monday
22 Jan
8 Questions from a Marketer That GA4 Can’t Answer
#
BigQuery
Wednesday
10 Jan
How to bridge the gap between GA4 and BigQuery export
#
GA4
Friday
4 Nov
7 deadly sins of GA4
#
Metrics
Friday
4 Nov
How I Chose an A/B Testing Service
bigquery
ga4
metrics
gtm
server-side
attribution
education
abtest
web-analytics
product-analytics
2024
analytics@add-2-cart.online
-p-800.jpg)
