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