alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
About
Courses
#
Metrics
Sunday
Feb 22, 2026
How an Analyst Loses Control of Metrics — Even Knowing SQL
Sunday
Feb 22, 2026
How Bad Event Timing Breaks Every Product Conclusion?
Sunday
Feb 22, 2026
How Can One Window Function Break Your Metrics?
Sunday
Feb 22, 2026
Why GA4 and BigQuery Don’t Always Agree on Daily Metrics
Sunday
Feb 22, 2026
Why Do Metrics Start Contradicting Each Other — Even From the Same Source?
Sunday
Feb 22, 2026
Why Does Decision-Making Get Harder When All Data is Available?
Sunday
Feb 22, 2026
Why Does “agreeing on data” Often Create Even More Distrust?
Sunday
Feb 22, 2026
Why Does Analytics Increase Tension Between Marketing, Product, and Finance?
Sunday
Feb 22, 2026
Why Does a CMO Feel Responsible For Numbers He Doesn’t Actually Control?
Sunday
Feb 22, 2026
How to Calculate Retention with SQL Window Functions (Without Mixing Everything Together)
Sunday
Feb 22, 2026
Why Does Having More Data Make Uncertainty More Visible Instead of Reducing It?
Sunday
Feb 22, 2026
Why Do Numbers Stop Helping Teams Agree — And Start Defending Positions?
Sunday
Feb 22, 2026
Why Do Metrics Stop “holding together” Once a Company Grows Beyond One Channel?
Sunday
Feb 22, 2026
How to Shift Attribution from Last Click to First Click in SQL
Sunday
Feb 22, 2026
Why Does Adding More Reports Increase Blindness Instead of Transparency?
Sunday
Feb 22, 2026
How Does Blurred Ownership Of Metrics Turn Analytics Into a Source of Anxiety?
Sunday
Feb 22, 2026
Why Does a CMO Trust Numbers More Than the Team — And Still Doubt Both?
Sunday
Feb 22, 2026
Why Do Metrics Stop Reflecting Reality When the Business Becomes More Complex?
Sunday
Feb 22, 2026
Why Meta Often Claims Credit for Conversions Finalized Through Email
Sunday
Feb 22, 2026
Why Does Automation Increase CMO Frustration Instead of Reducing It?
Sunday
Feb 22, 2026
What Breaks When One Team Owns Growth and Another Owns Accuracy?
Sunday
Feb 22, 2026
Why Does Adding More Metrics Reduce Confidence Instead of Improving Control?
Sunday
Feb 22, 2026
Why Do CMOs Doubt Data Most When Everything Looks “too perfect”?
Sunday
Feb 22, 2026
Why Do Different Teams Read The Same Report — And Make Opposite Decisions?
Sunday
Feb 22, 2026
How Do Deduplication Errors End Up Affecting Careers — Not Just Metrics?
Sunday
Feb 22, 2026
Why Does a CMO Stop Trusting Data During Growth — Not During a Crisis?
Sunday
Feb 22, 2026
How Do Metrics Change Their Meaning When Marketing Scales Faster Than the Analytics Model?
Sunday
Feb 22, 2026
What Happens to Attribution When Marketing and Product Speak Different Event Languages?
Sunday
Feb 22, 2026
Why can two analysts honestly read the same data — and disagree completely?
Sunday
Feb 22, 2026
Why do executive dashboards hide problems more often than they reveal them?
Sunday
Feb 22, 2026
Why do analytics reports look correct — but still lead to bad business decisions?
Sunday
Feb 22, 2026
What Happens to Analytics After the Only Analyst Leaves? How does it usually look?
Sunday
Feb 22, 2026
How to Calculate CLV (Customer Lifetime Value) With SQL Window Functions?
Sunday
Feb 22, 2026
Why Does Analytics Collapse When You Split With an Agency — And How to Avoid It?
Sunday
Feb 22, 2026
Why Do We Collect Dozens of Metrics No One Uses?
Saturday
Feb 21, 2026
How to Attribute Conversions to the First Click (Instead of Last) in SQL?
Saturday
Feb 21, 2026
How to Correctly Calculate Retention Rate with SQL Window Functions?
Tuesday
Dec 2, 2025
Why does Meta Ads attribute to itself customers who bought via email?
Tuesday
Dec 2, 2025
How is CPA defined in Ads Manager and CRM - do they match?
Monday
Dec 1, 2025
How does Meta Ads count view-through conversions and why is it dangerous?
Sunday
Nov 30, 2025
Which Of The Three Conversion Metrics in GA4 Are You Using — And Do You Know the Difference?
Sunday
Nov 30, 2025
Does SEO Really Drive 60% of Sales? Or Do All Roads Just Lead to Organic?
Sunday
Nov 30, 2025
How to Properly Handle Offline Conversions in Meta
Friday
Aug 1, 2025
Why Meta Might Be Burning Your Budget — and How to Stop It
Thursday
Jul 31, 2025
What to Do When Meta Claims Credit for Conversions It Didn’t Earn
Wednesday
Jul 30, 2025
How to Avoid Wasting Money on Meta Campaign Tracking — and Get Accurate Data
Wednesday
Jul 30, 2025
How to Track Creatives in Meta Ads at Scale?
Wednesday
Jul 30, 2025
How Server-Side Tracking Can Save Your Meta Campaign
Wednesday
Jul 30, 2025
5 Myths About Consent Mode That Are Costing You Money — Let’s Break Them Down
Wednesday
Jul 30, 2025
Server-Side Tracking For Meta: Does It Actually Change Anything?
Wednesday
Jul 30, 2025
Why Meta’s 7-Day Attribution Window Is a Real Problem
Wednesday
Jul 30, 2025
So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)
Wednesday
Jul 30, 2025
How Native Facebook Pixel Integrations Quietly Kill Your Optimization
Wednesday
Jul 30, 2025
How To Survive Multiple Attribution Models And Keep Your Sanity (And Budget)
Wednesday
Jul 30, 2025
Tracking Purchases On The “Thank You” Page? And Where’s The Money?
Wednesday
Jul 30, 2025
48MB of Pain: How Excel Kills Your Marketing Analytics
Wednesday
Jul 30, 2025
META AND YANDEX EXPOSED: Privacy on Android is a Myth
Wednesday
Jul 30, 2025
Why Meta Doesn’t See Your Conversions (And What To Do About It)
Wednesday
Jul 30, 2025
Last Click Out Of The Box? That’s a Trap.
Wednesday
Jul 30, 2025
How Do You Train Meta Campaigns When Your Sales Cycle Is Longer Than a Netflix Miniseries?
Wednesday
Jul 30, 2025
Low CPA, No Money. Amazing, Right?
Monday
Apr 21, 2025
Stop A/B Testing!
Monday
Apr 21, 2025
How to Stop UTM Parameters from Disappearing (and Keep You Happy)
Sunday
Apr 20, 2025
Safari vs. UTM: Do We Really Need to Panic?
Sunday
Apr 20, 2025
Advanced CRO Calculator for FREE
Tuesday
Dec 10, 2024
Google trends in BigQuery with bigfunctions. Whaaat?
Tuesday
Dec 10, 2024
Post-View Attribution: Everything You Didn't Know but Were Afraid to Ask
Tuesday
Dec 10, 2024
Common Mistakes in ROI Calculations Due to Attribution Model Specifics
Saturday
Nov 9, 2024
Attribution Models Cheat Sheet
Saturday
Nov 9, 2024
What is the Difference between ROI, ROMI and ROAS?
Friday
Nov 8, 2024
Leading and Lagging Metrics - What's the Difference in a Nutshell?
Friday
Nov 8, 2024
What is the Top Score Attribution?
Friday
Nov 8, 2024
Why Can't You Rely on Facebook Ads Analytics?
Friday
Nov 8, 2024
Behavioral Modeling for Consent Mode v2 - It's Not What You Might Think!
Friday
Nov 8, 2024
ARPU, ARPPU, and LTV: Differences, Misconceptions, and Importance for Business
Friday
Nov 8, 2024
Core Web Vitals - What Are They and How to Work with Them?
Friday
Nov 8, 2024
Tips for Optimizing Conversion Rates
Friday
Nov 8, 2024
Custom Parameters in Yandex Metrica
Friday
Nov 8, 2024
What's Available for Marketing Attribution in 2024 Besides GA?
Friday
Nov 8, 2024
Where to Find Ideas for A/B Tests?
Friday
Nov 8, 2024
Tea-tasting package for A/B-testing in Python
Friday
Nov 8, 2024
Market Map of Product Analytics
Friday
Nov 8, 2024
How to Run an Experiment FOR FREE?
Wednesday
May 29, 2024
Product Benchmark Metrics by Amplitude
Wednesday
Apr 17, 2024
Subscriptions Mobile Apps: RevenueCat 2024 report
Subscriptions Mobile Apps: RevenueCat 2024 report by Alex Ignatenko
Friday
Nov 4, 2022
How I Chose an A/B Testing Service
2024
analytics@add-2-cart.online
