alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
Other
About
Courses
tag:
product-analytics
Wednesday
May 27, 2026
What do you do when your marketing dashboard doesn't tell you what to do? And can AI actually help?
Wednesday
May 27, 2026
What do you do when you have more marketing data, smarter AI, and still no results?
Tuesday
May 19, 2026
Does your dashboard need an AI chat?
Wednesday
May 13, 2026
To the folks now doing "AI transformation" – I get it.
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 to Compare A/B Test Conversion in BigQuery - and What Statistical Mistakes Kill Your Conclusions?
Wednesday
Apr 29, 2026
Developers Are a Scarce Resource
Wednesday
Apr 29, 2026
Does Your Content Actually Work?
Wednesday
Apr 29, 2026
A Client Came In With a Classic Issue
Wednesday
Apr 29, 2026
Startups’ favorite mantra: “We’re B2B SaaS — so monetization = subscription”
Friday
Apr 17, 2026
Antifragility: how one idea changed my approach to life, business, and planning
#
Metrics
Sunday
22 Feb
How an Analyst Loses Control of Metrics — Even Knowing SQL
#
GA4
Sunday
22 Feb
Can You Rely on GA4’s Attribution Models for Budget Decisions?
#
Metrics
Sunday
22 Feb
Why Do Metrics Start Contradicting Each Other — Even From the Same Source?
#
Metrics
Sunday
22 Feb
Why Does Decision-Making Get Harder When All Data is Available?
#
Metrics
Sunday
22 Feb
Why Does “agreeing on data” Often Create Even More Distrust?
#
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 Does Having More Data Make Uncertainty More Visible Instead of Reducing It?
#
Metrics
Sunday
22 Feb
Why Do Numbers Stop Helping Teams Agree — And Start Defending Positions?
#
Metrics
Sunday
22 Feb
Why Do Metrics Stop “holding together” Once a Company Grows Beyond One Channel?
#
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
How Does Blurred Ownership Of Metrics Turn Analytics Into a Source of Anxiety?
#
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
Why Does Automation Increase CMO Frustration Instead of Reducing It?
#
BigQuery
Sunday
22 Feb
Building a Custom Attribution Model in SQL: A More Realistic Way to Assign Credit
#
Metrics
Sunday
22 Feb
What Breaks When One Team Owns Growth and Another Owns Accuracy?
#
Metrics
Sunday
22 Feb
Why Does Adding More Metrics Reduce Confidence Instead of Improving Control?
#
Metrics
Sunday
22 Feb
Why Do CMOs Doubt Data Most When Everything Looks “too perfect”?
#
Metrics
Sunday
22 Feb
Why Do Different Teams Read The Same Report — And Make Opposite Decisions?
#
BigQuery
Sunday
22 Feb
Rethinking Conversion Rate in BigQuery: A Practical Approach
#
Metrics
Sunday
22 Feb
How Do Deduplication Errors End Up Affecting Careers — Not Just Metrics?
#
GA4
Sunday
22 Feb
Why GA4 Often Shows Fewer Transactions Than Your Payment Gateway
#
Metrics
Sunday
22 Feb
What Happens to Attribution When Marketing and Product Speak Different Event Languages?
#
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?
#
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?
#
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
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 Calculate ARPU (Average Revenue Per User) in BigQuery?
#
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?
#
GA4
Sunday
22 Feb
Why Track Dozens of GA4 Events If the Business Only Needs Five?
#
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?
#
Metrics
Sunday
22 Feb
What Happens to Analytics After the Only Analyst Leaves? How does it usually look?
#
Metrics
Sunday
22 Feb
How to Calculate CLV (Customer Lifetime Value) With SQL Window Functions?
#
GA4
Sunday
22 Feb
Can You Trust GA4 When Data Updates Lag by 48 Hours? Why does this matter?
#
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?
#
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
#
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
Tuesday
2 Dec
How to Build a Custom Attribution Model in SQL (Without Crying)
#
Metrics
Tuesday
2 Dec
Why does Meta Ads attribute to itself customers who bought via email?
#
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?
#
BigQuery
Tuesday
2 Dec
Why do GA4 and BigQuery reports differ for the same day?
#
Metrics
Tuesday
2 Dec
How is CPA defined in Ads Manager and CRM - do they match?
#
GA4
Monday
1 Dec
How much do 70% cookie banner refusals affect GA4 data?
#
Metrics
Monday
1 Dec
How does Meta Ads count view-through conversions and why is it dangerous?
#
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
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
What Happens To Tracking When the User Is On iOS - Are You Counting That?
#
BigQuery
Monday
1 Dec
How to Query Multiple GA4 events_ Tables with _TABLE_SUFFIX in BigQuery
#
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
How Long Does a User Session Actually Last — And Does It Affect How You Measure Performance?
#
GA4
Sunday
30 Nov
Why You Shouldn’t Use event_name = 'first_visit' to Count New Users
#
GA4
Sunday
30 Nov
Where Does Your Money Go With Black-Box Attribution in GA4 — And How Does It Affect Your Budget?
#
BigQuery
Sunday
30 Nov
How to Calculate Average Order Value (AOV) in BigQuery — Without Fooling Yourself
#
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
Did You Know GA4 Uses HLL++ — And You’re Not Seeing Exact Numbers?
#
BigQuery
Sunday
30 Nov
Why Do Custom Dimensions Sometimes Not Show Up in BigQuery?
#
GA4
Sunday
30 Nov
Are You Sure Your GA4 is Set Up Correctly — Without Server-Side Tracking?
#
GA4
Sunday
30 Nov
How to Work with item_id in GA4 BigQuery (Without Losing Your Mind)
#
Metrics
Sunday
30 Nov
Does SEO Really Drive 60% of Sales? Or Do All Roads Just Lead to Organic?
#
BigQuery
Sunday
30 Nov
How to Calculate Conversion Rate in BigQuery
#
Metrics
Sunday
30 Nov
How to Properly Handle Offline Conversions in Meta
#
Metrics
Friday
1 Aug
Why Meta Might Be Burning Your Budget — and How to Stop It
#
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
5 Myths About Consent Mode That Are Costing You Money — Let’s Break Them Down
#
Metrics
Wednesday
30 Jul
Server-Side Tracking For Meta: Does It Actually Change Anything?
#
Metrics
Wednesday
30 Jul
Why Meta’s 7-Day Attribution Window Is a Real Problem
#
GA4
Wednesday
30 Jul
Launched a Facebook Campaign — And GA4 Suddenly Shows a Spike In Direct Traffic? Weird, Right?
#
Metrics
Wednesday
30 Jul
Tracking Purchases On The “Thank You” Page? And Where’s The Money?
#
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)
#
Metrics
Wednesday
30 Jul
Last Click Out Of The Box? That’s a Trap.
#
Metrics
Wednesday
30 Jul
How Do You Train Meta Campaigns When Your Sales Cycle Is Longer Than a Netflix Miniseries?
#
BigQuery
Wednesday
30 Jul
The Aggregated Report Looks Great. The Decisions? Not So Much.
#
Metrics
Wednesday
30 Jul
Low CPA, No Money. Amazing, Right?
#
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?
#
GTM
Monday
21 Apr
Automatic Setup of First-party Mode for GTM Using Cloudflare
#
GA4
Monday
21 Apr
Understanding User ID in GA4: Everything You Should Know
#
GA4
Monday
21 Apr
The Most Useless Feature in Analytics Tools
#
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?
#
GTM
Monday
21 Apr
DataLayer: Everything You Didn't Know But Were Afraid to Ask
#
BigQuery
Monday
21 Apr
How to Transfer Data from MySQL or PostgreSQL to BigQuery?
#
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)
#
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
#
BigQuery
Sunday
20 Apr
What is the Signals Gateway by Meta?
#
GTM
Sunday
20 Apr
Yandex Metrica Tag in GTM - Now Official!
#
BigQuery
Sunday
20 Apr
Deduplicate This Immediately!
#
GA4
Sunday
20 Apr
When Conversions Don't Match Sales
#
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?
#
Metrics
Sunday
20 Apr
Advanced CRO Calculator for FREE
#
GA4
Sunday
20 Apr
Why "Free" Analytics Is a Myth
#
GA4
Sunday
20 Apr
Google Tag Manager Has a JavaScript Problem (and a Sneaky Fix!)
#
GA4
Saturday
19 Apr
Debugging sGTM used to be a pain - until I found this
#
GA4
Saturday
19 Apr
Why Your GA4 Numbers Don't Match
#
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
#
Metrics
Tuesday
10 Dec
Google trends in BigQuery with bigfunctions. Whaaat?
#
GTM
Tuesday
10 Dec
A Fresh Guide to Duplicating GTM Containers by Simo Ahava
#
GTM
Tuesday
10 Dec
Why is update=true Important in Google Tag Settings for SPAs?
#
BigQuery
Tuesday
10 Dec
Gemini + BigQuery: A New Era of Analytics with AI or Money Down the Drain?
#
Metrics
Tuesday
10 Dec
Post-View Attribution: Everything You Didn't Know but Were Afraid to Ask
#
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
#
Metrics
Saturday
9 Nov
Attribution Models Cheat Sheet
#
Metrics
Saturday
9 Nov
What is the Difference between ROI, ROMI and ROAS?
#
BigQuery
Saturday
9 Nov
What are BigQuery Materialized Views?
#
BigQuery
Saturday
9 Nov
How to Retrieve a List of Queries to Looker Reports in BigQuery?
#
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?
#
GA4
Friday
8 Nov
GA4 and Google Sheets Integration
#
BigQuery
Friday
8 Nov
Using DML DELETE to Delete Partitions
#
Metrics
Friday
8 Nov
ARPU, ARPPU, and LTV: Differences, Misconceptions, and Importance for Business
#
Metrics
Friday
8 Nov
Core Web Vitals - What Are They and How to Work with Them?
#
GA4
Friday
8 Nov
Conversion Rate in GA4
#
Metrics
Friday
8 Nov
Tips for Optimizing Conversion Rates
#
Metrics
Friday
8 Nov
Custom Parameters in Yandex Metrica
#
Metrics
Friday
8 Nov
What's Available for Marketing Attribution in 2024 Besides GA?
#
Books & Videos
Friday
8 Nov
First Party Mode from Google
#
Metrics
Friday
8 Nov
Where to Find Ideas for A/B Tests?
#
Metrics
Friday
8 Nov
Market Map of Product Analytics
#
BigQuery
Tuesday
5 Nov
BigQuery now has Workflows!
#
BigQuery
Tuesday
5 Nov
Best Practices for Partitioning in BigQuery
#
BigQuery
Tuesday
5 Nov
Airflow DAGs in BigQuery
#
Friday
21 Jun
Web Analytics Space In Amplitude
#
Books & Videos
Tuesday
21 May
Bayesian Statistics: Star Wars, LEGO, Rubber Ducks, and More
bigquery
ga4
metrics
gtm
server-side
attribution
education
abtest
web-analytics
product-analytics
2024
analytics@add-2-cart.online
