How much do 70% cookie banner refusals affect GA4 data?

How much do 70% cookie banner refusals affect GA4 data?

Starred post

How much do 70% cookie banner refusals affect GA4 data?

How much do 70% cookie banner refusals affect GA4 data?

Starred post

How does Meta Ads count view-through conversions and why is it dangerous?

How does Meta Ads count view-through conversions and why is it dangerous?

Starred post

How to Calculate Conversion Rate by Landing Page in BigQuery?

How to Calculate Conversion Rate by Landing Page in BigQuery?

Starred post

How GA4's default session timeout can cost your business millions?

How GA4's default session timeout can cost your business millions?

Starred post

How to Find Abandoned Carts in GA4 BigQuery - Without Abandoning Your Sanity

How to Find Abandoned Carts in GA4 BigQuery - Without Abandoning Your Sanity

Starred post

Who Actually Benefits From GA4 Inaccuracies - You, the Agency, or the Platform?

Who Actually Benefits From GA4 Inaccuracies - You, the Agency, or the Platform?

Starred post

How to Quickly Build a Session Table in GA4 + BigQuery (Without Questioning Reality)

How to Quickly Build a Session Table in GA4 + BigQuery (Without Questioning Reality)

Starred post

Have You Checked If Purchases Are Being Lost Without Server-Side Tracking?

Have You Checked If Purchases Are Being Lost Without Server-Side Tracking?

Starred post

How to Handle String, Integer, and Float Parameter Values in GA4 BigQuery

How to Handle String, Integer, and Float Parameter Values in GA4 BigQuery

Starred post

What Happens To Tracking When the User Is On iOS - Are You Counting That?

What Happens To Tracking When the User Is On iOS - Are You Counting That?

Starred post

How Many Purchases Are Lost Due To Browser-Based Tracking — And How Does That Show Up In GA4?

How Many Purchases Are Lost Due To Browser-Based Tracking — And How Does That Show Up In GA4?

Starred post

NEW VIDEO! "How can marketers finally get CLARITY from dashboards?"

NEW VIDEO! "How can marketers finally get CLARITY from dashboards?"

Starred post

How to Query Multiple GA4 events_ Tables with _TABLE_SUFFIX in BigQuery

How to Query Multiple GA4 events_ Tables with _TABLE_SUFFIX in BigQuery

Starred post

How Do You Know Platforms Aren’t Getting Distorted Data Without GTM Server-Side?

How Do You Know Platforms Aren’t Getting Distorted Data Without GTM Server-Side?

Starred post

How to Build Accurate Channel Grouping in GA4 BigQuery (Without Losing Your Mind Over source/medium)?

How to Build Accurate Channel Grouping in GA4 BigQuery (Without Losing Your Mind Over source/medium)?

Starred post

Can You Trust the Conversion Rate in GA4 - And How Is It Actually Calculated?

Can You Trust the Conversion Rate in GA4 - And How Is It Actually Calculated?

Starred post

Why a Scroll Event in GA4 Doesn’t Mean Someone Actually Read Your Content

Why a Scroll Event in GA4 Doesn’t Mean Someone Actually Read Your Content

Starred post

NEW VIDEO! “Why do CONVERSIONS never match across platforms?”

NEW VIDEO! “Why do CONVERSIONS never match across platforms?”

Starred post

How to Use IFNULL and SAFE_CAST to Clean Custom Parameters in BigQuery

How to Use IFNULL and SAFE_CAST to Clean Custom Parameters in BigQuery

Starred post

How to Use ARRAY_AGG in BigQuery to Reconstruct User Journeys (Without Losing Your Mind)

How to Use ARRAY_AGG in BigQuery to Reconstruct User Journeys (Without Losing Your Mind)

Starred post

What’s Really Behind the “Traffic Source” in GA4 — And Why Does It Show Up Differently Everywhere?

What’s Really Behind the “Traffic Source” in GA4 — And Why Does It Show Up Differently Everywhere?

Starred post

Which Of The Three Conversion Metrics in GA4 Are You Using — And Do You Know the Difference?

Which Of The Three Conversion Metrics in GA4 Are You Using — And Do You Know the Difference?

Starred post

Why You Shouldn't Use session_start to Count Sessions in GA4 BigQuery

Why You Shouldn't Use session_start to Count Sessions in GA4 BigQuery

Starred post

What Does An “engaged session” in GA4 Really Mean — And What Does It Have To Do With Actual Engagement?

What Does An “engaged session” in GA4 Really Mean — And What Does It Have To Do With Actual Engagement?

Starred post

How to Calculate Conversion Rate in BigQuery

How to Calculate Conversion Rate in BigQuery

Starred post

How Long Does a User Session Actually Last — And Does It Affect How You Measure Performance?

How Long Does a User Session Actually Last — And Does It Affect How You Measure Performance?

Starred post

Are You Sure GA4 is Handling Your UTM Tags Correctly?

Are You Sure GA4 is Handling Your UTM Tags Correctly?

Starred post

Why You Shouldn’t Use event_name = 'first_visit' to Count New Users

Why You Shouldn’t Use event_name = 'first_visit' to Count New Users

Starred post

Do You Compare Two Periods in GA4 — And Do You Know It Might Be Misleading?

Do You Compare Two Periods in GA4 — And Do You Know It Might Be Misleading?

Starred post

How to Use GA4 + BigQuery to Measure CAC — Without Burning Your Entire Marketing Budget

How to Use GA4 + BigQuery to Measure CAC — Without Burning Your Entire Marketing Budget

Starred post

Why GA4 Data Is Delayed — And Why You're Making Budget Decisions Today

Why GA4 Data Is Delayed — And Why You're Making Budget Decisions Today

Starred post

Where Does Your Money Go With Black-Box Attribution in GA4 — And How Does It Affect Your Budget?

Where Does Your Money Go With Black-Box Attribution in GA4 — And How Does It Affect Your Budget?

Starred post

How to Calculate Average Order Value (AOV) in BigQuery — Without Fooling Yourself

How to Calculate Average Order Value (AOV) in BigQuery — Without Fooling Yourself

Starred post

What Do You Actually See in a GA4 Funnel — And How Much Does It Reflect Real User Behavior?

What Do You Actually See in a GA4 Funnel — And How Much Does It Reflect Real User Behavior?

Starred post

How to Decode Custom Parameters in GA4 BigQuery (Without Losing Your Mind)

How to Decode Custom Parameters in GA4 BigQuery (Without Losing Your Mind)

Starred post

Did You Know GA4 Uses HLL++ — And You’re Not Seeing Exact Numbers?

Did You Know GA4 Uses HLL++ — And You’re Not Seeing Exact Numbers?

Starred post

GA4 Shows You “users” — But Are You Sure They’re Real People?

GA4 Shows You “users” — But Are You Sure They’re Real People?

Starred post

Why Do Custom Dimensions Sometimes Not Show Up in BigQuery?

Why Do Custom Dimensions Sometimes Not Show Up in BigQuery?

Starred post

Why Don’t GA4 And BigQuery Data Match — And Which One Should You Trust?

Why Don’t GA4 And BigQuery Data Match — And Which One Should You Trust?

Starred post

How to Calculate New vs. Repeat Purchases in BigQuery (Without Losing Faith in Humanity)

How to Calculate New vs. Repeat Purchases in BigQuery (Without Losing Faith in Humanity)

Starred post

Are You Sure Your GA4 is Set Up Correctly — Without Server-Side Tracking?

Are You Sure Your GA4 is Set Up Correctly — Without Server-Side Tracking?

Starred post

How Custom Parameters in GA4 Can Quietly Break Your Reports — Have You Checked Yours?

How Custom Parameters in GA4 Can Quietly Break Your Reports — Have You Checked Yours?

Starred post

How to Work with item_id in GA4 BigQuery (Without Losing Your Mind)

How to Work with item_id in GA4 BigQuery (Without Losing Your Mind)

Starred post

Why Is Some Of Your Traffic Ending Up in (direct)/(none) — And How Much Is That Costing Your Marketing?

Why Is Some Of Your Traffic Ending Up in (direct)/(none) — And How Much Is That Costing Your Marketing?

Starred post

How to Measure User Churn in BigQuery Using GA4 Data

How to Measure User Churn in BigQuery Using GA4 Data

Starred post

Are You Losing Purchase Events in GA4 — And How Does That Impact Your Profit Calculations?

Are You Losing Purchase Events in GA4 — And How Does That Impact Your Profit Calculations?

Starred post

Does SEO Really Drive 60% of Sales? Or Do All Roads Just Lead to Organic?

Does SEO Really Drive 60% of Sales? Or Do All Roads Just Lead to Organic?

Starred post

How to Calculate Conversion Rate in BigQuery

How to Calculate Conversion Rate in BigQuery

Starred post

How to Properly Handle Offline Conversions in Meta

How to Properly Handle Offline Conversions in Meta

Starred post

What Counts as an Engaged Session in GA4 — According to BigQuery?

What Counts as an Engaged Session in GA4 — According to BigQuery?

Starred post

How to Set Up GTM for Meta Without Losing Data

How to Set Up GTM for Meta Without Losing Data

Starred post

Why Meta Might Be Burning Your Budget — and How to Stop It

Why Meta Might Be Burning Your Budget — and How to Stop It

Starred post

What Is event_bundle_sequence_id in GA4?

What Is event_bundle_sequence_id in GA4?

Starred post

What to Do When Meta Claims Credit for Conversions It Didn’t Earn

What to Do When Meta Claims Credit for Conversions It Didn’t Earn

Starred post

Why Does BigQuery Show More Users Than the GA4 Interface — and Who’s Telling the Truth?

Why Does BigQuery Show More Users Than the GA4 Interface — and Who’s Telling the Truth?

Starred post

How to Avoid Wasting Money on Meta Campaign Tracking — and Get Accurate Data

How to Avoid Wasting Money on Meta Campaign Tracking — and Get Accurate Data

Starred post

How to Track Creatives in Meta Ads at Scale?

How to Track Creatives in Meta Ads at Scale?

Starred post

How Server-Side Tracking Can Save Your Meta Campaign

How Server-Side Tracking Can Save Your Meta Campaign

Starred post

5 Myths About Consent Mode That Are Costing You Money — Let’s Break Them Down

5 Myths About Consent Mode That Are Costing You Money — Let’s Break Them Down

Starred post

Server-Side Tracking For Meta: Does It Actually Change Anything?

Server-Side Tracking For Meta: Does It Actually Change Anything?

Starred post

Why Meta’s 7-Day Attribution Window Is a Real Problem

Why Meta’s 7-Day Attribution Window Is a Real Problem

Starred post

So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)

So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)

Starred post

Launched a Facebook Campaign — And GA4 Suddenly Shows a Spike In Direct Traffic? Weird, Right?

Launched a Facebook Campaign — And GA4 Suddenly Shows a Spike In Direct Traffic? Weird, Right?

Starred post

How Native Facebook Pixel Integrations Quietly Kill Your Optimization

How Native Facebook Pixel Integrations Quietly Kill Your Optimization

Starred post

How To Survive Multiple Attribution Models And Keep Your Sanity (And Budget)

How To Survive Multiple Attribution Models And Keep Your Sanity (And Budget)

Starred post

How Measurement Protocol Quietly Destroys Your GTM Server-Side Data (And Ad Budgets)

How Measurement Protocol Quietly Destroys Your GTM Server-Side Data (And Ad Budgets)

Starred post

Tracking Purchases On The “Thank You” Page? And Where’s The Money?

Tracking Purchases On The “Thank You” Page? And Where’s The Money?

Starred post

How Automatic GA4 Events Quietly Ruin Your Server-Side Tracking

How Automatic GA4 Events Quietly Ruin Your Server-Side Tracking

Starred post

48MB of Pain: How Excel Kills Your Marketing Analytics

48MB of Pain: How Excel Kills Your Marketing Analytics

Starred post

META AND YANDEX EXPOSED: Privacy on Android is a Myth

META AND YANDEX EXPOSED: Privacy on Android is a Myth

Starred post

Why Meta Doesn’t See Your Conversions (And What To Do About It)

Why Meta Doesn’t See Your Conversions (And What To Do About It)

Starred post

Last Click Out Of The Box? That’s a Trap.

Last Click Out Of The Box? That’s a Trap.

Starred post

How Do You Train Meta Campaigns When Your Sales Cycle Is Longer Than a Netflix Miniseries?

How Do You Train Meta Campaigns When Your Sales Cycle Is Longer Than a Netflix Miniseries?

Starred post

Consent Mode Is On — But Your Data’s Gone? Here’s a 5-Minute Sanity Check.

Consent Mode Is On — But Your Data’s Gone? Here’s a 5-Minute Sanity Check.

Starred post

The Aggregated Report Looks Great. The Decisions? Not So Much.

The Aggregated Report Looks Great. The Decisions? Not So Much.

Starred post

Google Renamed a Cookie. Again. Not a Disaster — Just Mildly Annoying

Google Renamed a Cookie. Again. Not a Disaster — Just Mildly Annoying

Starred post

Consent Mode Is On. So Where’s The Data?

Consent Mode Is On. So Where’s The Data?

Starred post

Low CPA, No Money. Amazing, Right?

Low CPA, No Money. Amazing, Right?

Starred post

Meta Says 170 Conversions. Google Ads Shows 85. GA4 Lands at 110. So... Who’s Telling The Truth?

Meta Says 170 Conversions. Google Ads Shows 85. GA4 Lands at 110. So... Who’s Telling The Truth?

Starred post

Basic Consent Mode – For Those Who Enjoy a Bit Of Pain (On Purpose)

Basic Consent Mode – For Those Who Enjoy a Bit Of Pain (On Purpose)

Starred post

One Tiny GA4 Setting That Could Be Costing You Tens Of Thousands in Ad Spend

One Tiny GA4 Setting That Could Be Costing You Tens Of Thousands in Ad Spend

Starred post

“Our Attribution is Very Complex” — Why That’s Often Just an Excuse

“Our Attribution is Very Complex” — Why That’s Often Just an Excuse

Starred post

Can You Trust Modeled Data in GA4?

Can You Trust Modeled Data in GA4?

Starred post

Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?

Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?

Starred post

Unlock the Power of Google Cloud with the VS Code Extension!

Unlock the Power of Google Cloud with the VS Code Extension!

Starred post

Automatic Setup of First-party Mode for GTM Using Cloudflare

Automatic Setup of First-party Mode for GTM Using Cloudflare

Starred post

Which Python Package to Use for Attribution Calculation?

Which Python Package to Use for Attribution Calculation?

Starred post

Understanding User ID in GA4: Everything You Should Know

Understanding User ID in GA4: Everything You Should Know

Starred post

The Most Useless Feature in Analytics Tools

The Most Useless Feature in Analytics Tools

Starred post

"Still Running" Tags in Google Tag Manager: Why It Happens and How to Fix It

"Still Running" Tags in Google Tag Manager: Why It Happens and How to Fix It

Starred post

How to Find Out How Much Data You're Losing Due to Consent Mode in GA4?

How to Find Out How Much Data You're Losing Due to Consent Mode in GA4?

Starred post

3 Simple Ways to Enable DebugView in Google Analytics 4

3 Simple Ways to Enable DebugView in Google Analytics 4

Starred post

Experimented with Consent Mode v2 and noticed a sudden drop in traffic in GA4?

Experimented with Consent Mode v2 and noticed a sudden drop in traffic in GA4?

Starred post

First-Party Mode vs. Server-Side Tracking: What's the Difference?

First-Party Mode vs. Server-Side Tracking: What's the Difference?

Starred post

DataLayer: Everything You Didn't Know But Were Afraid to Ask

DataLayer: Everything You Didn't Know But Were Afraid to Ask

Starred post

How to Send Data to BigQuery with SGTM: Easy and Stress-Free

How to Send Data to BigQuery with SGTM: Easy and Stress-Free

Starred post

Stop A/B Testing!

Stop A/B Testing!

Starred post

LOGICAL_OR and LOGICAL_AND in BigQuery: segment your data without losing your mind

LOGICAL_OR and LOGICAL_AND in BigQuery: segment your data without losing your mind

Starred post

How to Transfer Data from MySQL or PostgreSQL to BigQuery?

How to Transfer Data from MySQL or PostgreSQL to BigQuery?

Starred post

Choosing the Right GA4 Integration Method for Your Shopify Store

Choosing the Right GA4 Integration Method for Your Shopify Store

Starred post

author

Alex Ignatenko

Message

Email Linkedin Twitter YouTube

With over ten years of experience in product and marketing analytics, I help ecommerce companies earn more from each attracted user through a deep approach to traffic analysis and redistribution of the marketing budget. My mission is to enable data-driven decision making and effective experimentation for online businesses.

Thank you!
Your submission has been received!

Oops! Something went wrong while submitting the form.