alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
About
Courses
tag:
product-analytics
#
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
