alexignatenko
Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?
#
GA4
Monday
21 Apr

Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?

Starred post
Latest Post
Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?
#
GA4
Monday
21 Apr

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!
#
BigQuery
Monday
21 Apr

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

Starred post

Automatic Setup of First-party Mode for GTM Using Cloudflare
#
GTM
Monday
21 Apr

Automatic Setup of First-party Mode for GTM Using Cloudflare

Starred post

Which Python Package to Use for Attribution Calculation?
#
BigQuery
Monday
21 Apr

Which Python Package to Use for Attribution Calculation?

Starred post

Understanding User ID in GA4: Everything You Should Know
#
GA4
Monday
21 Apr

Understanding User ID in GA4: Everything You Should Know

Starred post

The Most Useless Feature in Analytics Tools
#
GA4
Monday
21 Apr

The Most Useless Feature in Analytics Tools

Starred post

"Still Running" Tags in Google Tag Manager: Why It Happens and How to Fix It
#
GTM
Monday
21 Apr

"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?
#
GA4
Monday
21 Apr

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
#
GA4
Monday
21 Apr

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?
#
GA4
Monday
21 Apr

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?
#
GA4
Monday
21 Apr

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

Starred post

DataLayer: Everything You Didn't Know But Were Afraid to Ask
#
GTM
Monday
21 Apr

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
#
BigQuery
Monday
21 Apr

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

Starred post

Stop A/B Testing!
#
Metrics
Monday
21 Apr

Stop A/B Testing!

Starred post

LOGICAL_OR and LOGICAL_AND in BigQuery: segment your data without losing your mind
#
BigQuery
Monday
21 Apr

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?
#
BigQuery
Monday
21 Apr

How to Transfer Data from MySQL or PostgreSQL to BigQuery?

Starred post

Choosing the Right GA4 Integration Method for Your Shopify Store
#
GA4
Monday
21 Apr

Choosing the Right GA4 Integration Method for Your Shopify Store

Starred post

How to Stop UTM Parameters from Disappearing (and Keep You Happy)
#
Metrics
Monday
21 Apr

How to Stop UTM Parameters from Disappearing (and Keep You Happy)

Starred post

Safari vs. UTM: Do We Really Need to Panic?
#
Metrics
Sunday
20 Apr

Safari vs. UTM: Do We Really Need to Panic?

Starred post

Custom Pixel in Shopify: What It Is and Why You Need It
#
GTM
Sunday
20 Apr

Custom Pixel in Shopify: What It Is and Why You Need It

Starred post

How to Debug Checkout Events in Shopify
#
GTM
Sunday
20 Apr

How to Debug Checkout Events in Shopify

Starred post

Accessing Cookies in Shopify Checkout with Server-Side GTM
#
GTM
Sunday
20 Apr

Accessing Cookies in Shopify Checkout with Server-Side GTM

Starred post

What is the Signals Gateway by Meta?
#
BigQuery
Sunday
20 Apr

What is the Signals Gateway by Meta?

Starred post

Yandex Metrica Tag in GTM - Now Official!
#
GTM
Sunday
20 Apr

Yandex Metrica Tag in GTM - Now Official!

Starred post

Deduplicate This Immediately!
#
BigQuery
Sunday
20 Apr

Deduplicate This Immediately!

Starred post

NEW YOUTUBE VIDEO!
#
Books & Videos
Sunday
20 Apr

NEW YOUTUBE VIDEO!

Starred post

When Conversions Don't Match Sales
#
GA4
Sunday
20 Apr

When Conversions Don't Match Sales

Starred post

How to Evaluate Ad Campaigns in Google Analytics (Without Losing Your Mind)
#
GA4
Sunday
20 Apr

How to Evaluate Ad Campaigns in Google Analytics (Without Losing Your Mind)

Starred post

How I Got into Google Analytics (For Real)
#
GA4
Sunday
20 Apr

How I Got into Google Analytics (For Real)

Starred post

How to Get Simple, Clear Reports in Google Analytics?
#
GA4
Sunday
20 Apr

How to Get Simple, Clear Reports in Google Analytics?

Starred post

Are You Really Sure You Understand Google Analytics?
#
GA4
Sunday
20 Apr

Are You Really Sure You Understand Google Analytics?

Starred post

How to Set Up Google Ads Analytics Without Messing Things Up
#
GA4
Sunday
20 Apr

How to Set Up Google Ads Analytics Without Messing Things Up

Starred post

Advanced CRO Calculator for FREE
#
Metrics
Sunday
20 Apr

Advanced CRO Calculator for FREE

Starred post

Why "Free" Analytics Is a Myth
#
GA4
Sunday
20 Apr

Why "Free" Analytics Is a Myth

Starred post

How to Choose a Google Ads Agency Without Regretting It Later
#
GA4
Sunday
20 Apr

How to Choose a Google Ads Agency Without Regretting It Later

Starred post

Google Tag Manager Has a JavaScript Problem (and a Sneaky Fix!)
#
GA4
Sunday
20 Apr

Google Tag Manager Has a JavaScript Problem (and a Sneaky Fix!)

Starred post

How I Use Google Analytics Every Day
#
GA4
Sunday
20 Apr

How I Use Google Analytics Every Day

Starred post

Debugging sGTM used to be a pain - until I found this
#
GA4
Saturday
19 Apr

Debugging sGTM used to be a pain - until I found this

Starred post

Consent Mode in GA4 – What It Is and Why It Might Melt Your Brain a Little
#
GA4
Saturday
19 Apr

Consent Mode in GA4 – What It Is and Why It Might Melt Your Brain a Little

Starred post

Why Your GA4 Numbers Don't Match
#
GA4
Saturday
19 Apr

Why Your GA4 Numbers Don't Match

Starred post

New video! From first click to repeat purchase - reporting for eCommerce that actually makes sense
#
Books & Videos
Saturday
19 Apr

New video! From first click to repeat purchase - reporting for eCommerce that actually makes sense

Starred post

When the GA4 community builds the features Google forgot
#
GA4
Saturday
19 Apr

When the GA4 community builds the features Google forgot

Starred post

The GCLID Issue in BigQuery and How to Solve It
#
BigQuery
Tuesday
10 Dec

The GCLID Issue in BigQuery and How to Solve It

Starred post

How to Quickly Obtain Percentile Values in BigQuery?
#
BigQuery
Tuesday
10 Dec

How to Quickly Obtain Percentile Values in BigQuery?

Starred post

Google trends in BigQuery with bigfunctions. Whaaat?
#
Metrics
Tuesday
10 Dec

Google trends in BigQuery with bigfunctions. Whaaat?

Starred post

A Fresh Guide to Duplicating GTM Containers by Simo Ahava
#
GTM
Tuesday
10 Dec

A Fresh Guide to Duplicating GTM Containers by Simo Ahava

Starred post

Issue with Sending Events via Measurement Protocol with user_id
#
GA4
Tuesday
10 Dec

Issue with Sending Events via Measurement Protocol with user_id

Starred post

Conversion Linker Now Supports Local Storage
#
GTM
Tuesday
10 Dec

Conversion Linker Now Supports Local Storage

Starred post

Why is update=true Important in Google Tag Settings for SPAs?
#
GTM
Tuesday
10 Dec

Why is update=true Important in Google Tag Settings for SPAs?

Starred post

Gemini + BigQuery: A New Era of Analytics with AI or Money Down the Drain?
#
BigQuery
Tuesday
10 Dec

Gemini + BigQuery: A New Era of Analytics with AI or Money Down the Drain?

Starred post

Post-View Attribution: Everything You Didn't Know but Were Afraid to Ask
#
Metrics
Tuesday
10 Dec

Post-View Attribution: Everything You Didn't Know but Were Afraid to Ask

Starred post

Detecting Anomalies in GA4 Data with BigQuery and Dataform
#
GA4
Tuesday
10 Dec

Detecting Anomalies in GA4 Data with BigQuery and Dataform

Starred post

How to Send Data from sGTM to Google Sheets with Stape
#
GTM
Tuesday
10 Dec

How to Send Data from sGTM to Google Sheets with Stape

Starred post

Quickly Analyzing Revenue Distribution by Customer with GA4 and BigQuery
#
BigQuery
Tuesday
10 Dec

Quickly Analyzing Revenue Distribution by Customer with GA4 and BigQuery

Starred post

How to Recover a Deleted Table in BigQuery?
#
BigQuery
Tuesday
10 Dec

How to Recover a Deleted Table in BigQuery?

Starred post

Google Explains the Difference Between Daily Export and Fresh Daily Export in BigQuery
#
BigQuery
Tuesday
10 Dec

Google Explains the Difference Between Daily Export and Fresh Daily Export in BigQuery

Starred post

Common Mistakes in ROI Calculations Due to Attribution Model Specifics
#
Metrics
Tuesday
10 Dec

Common Mistakes in ROI Calculations Due to Attribution Model Specifics

Starred post

Traffic Attribution in Single Page Applications
#
GTM
Saturday
9 Nov

Traffic Attribution in Single Page Applications

Starred post

All Methods to Track Conversions in GA4
#
GA4
Saturday
9 Nov

All Methods to Track Conversions in GA4

Starred post

Attribution Models Cheat Sheet
#
Metrics
Saturday
9 Nov

Attribution Models Cheat Sheet

Starred post

What is the Difference between ROI, ROMI and ROAS?
#
Metrics
Saturday
9 Nov

What is the Difference between ROI, ROMI and ROAS?

Starred post

Consent Mode Settings and Measurement Protocol
#
GA4
Saturday
9 Nov

Consent Mode Settings and Measurement Protocol

Starred post

Custom Channels Groupping in BigQuery
#
BigQuery
Saturday
9 Nov

Custom Channels Groupping in BigQuery

Starred post

What are BigQuery Materialized Views?
#
BigQuery
Saturday
9 Nov

What are BigQuery Materialized Views?

Starred post

Extensions for Displaying the Percentage of the Total in GA4
#
GA4
Saturday
9 Nov

Extensions for Displaying the Percentage of the Total in GA4

Starred post

How to Parse URLs in BigQuery?
#
BigQuery
Saturday
9 Nov

How to Parse URLs in BigQuery?

Starred post

How to Monitor GTM Server Side?
#
GTM
Saturday
9 Nov

How to Monitor GTM Server Side?

Starred post

Tracking Single Page Applications (SPA) - Official Google Documentation
#
GTM
Saturday
9 Nov

Tracking Single Page Applications (SPA) - Official Google Documentation

Starred post

How to Debug Measurement Protocol Requests in GA4?
#
GA4
Saturday
9 Nov

How to Debug Measurement Protocol Requests in GA4?

Starred post

How to Retrieve a List of Queries to Looker Reports in BigQuery?
#
BigQuery
Saturday
9 Nov

How to Retrieve a List of Queries to Looker Reports in BigQuery?

Starred post

Why Use Custom Channel Groups in GA4?
#
GA4
Saturday
9 Nov

Why Use Custom Channel Groups in GA4?

Starred post

Leading and Lagging Metrics - What's the Difference in a Nutshell?
#
Metrics
Friday
8 Nov

Leading and Lagging Metrics - What's the Difference in a Nutshell?

Starred post

What is the Top Score Attribution?
#
Metrics
Friday
8 Nov

What is the Top Score Attribution?

Starred post

GA4 and Google Sheets Integration
#
GA4
Friday
8 Nov

GA4 and Google Sheets Integration

Starred post

Using DML DELETE to Delete Partitions
#
BigQuery
Friday
8 Nov

Using DML DELETE to Delete Partitions

Starred post

Grouping by All in BigQuery! Finally!
#
BigQuery
Friday
8 Nov

Grouping by All in BigQuery! Finally!

Starred post

Why Can't You Rely on Facebook Ads Analytics?
#
Metrics
Friday
8 Nov

Why Can't You Rely on Facebook Ads Analytics?

Starred post

Behavioral Modeling for Consent Mode v2 - It's Not What You Might Think!
#
Metrics
Friday
8 Nov

Behavioral Modeling for Consent Mode v2 - It's Not What You Might Think!

Starred post

Update on User-Provided Data in GA4
#
GA4
Friday
8 Nov

Update on User-Provided Data in GA4

Starred post

What's Important to Know About Conversions and Key Events in GA4
#
GA4
Friday
8 Nov

What's Important to Know About Conversions and Key Events in GA4

Starred post

How to Fix "(no set)" in Google Analytics 4 Reports?
#
GA4
Friday
8 Nov

How to Fix "(no set)" in Google Analytics 4 Reports?

Starred post

ARPU, ARPPU, and LTV: Differences, Misconceptions, and Importance for Business
#
Metrics
Friday
8 Nov

ARPU, ARPPU, and LTV: Differences, Misconceptions, and Importance for Business

Starred post

Core Web Vitals - What Are They and How to Work with Them?
#
Metrics
Friday
8 Nov

Core Web Vitals - What Are They and How to Work with Them?

Starred post

Do You Want Your Own Hub for Offline Conversions?
#
GTM
Friday
8 Nov

Do You Want Your Own Hub for Offline Conversions?

Starred post

User Data Import without Website Visits
#
GA4
Friday
8 Nov

User Data Import without Website Visits

Starred post

Conversion Rate in GA4
#
GA4
Friday
8 Nov

Conversion Rate in GA4

Starred post

Tips for Optimizing Conversion Rates
#
Metrics
Friday
8 Nov

Tips for Optimizing Conversion Rates

Starred post

Google Increased the Maximum Number of Partitions for BigQuery
#
BigQuery
Friday
8 Nov

Google Increased the Maximum Number of Partitions for BigQuery

Starred post

Custom Parameters in Yandex Metrica
#
Metrics
Friday
8 Nov

Custom Parameters in Yandex Metrica

Starred post

What's Available for Marketing Attribution in 2024 Besides GA?
#
Metrics
Friday
8 Nov

What's Available for Marketing Attribution in 2024 Besides GA?

Starred post

First Party Mode from Google
#
Books & Videos
Friday
8 Nov

First Party Mode from Google

Starred post

New traffic_source parameter in BigQuery
#
GA4
Friday
8 Nov

New traffic_source parameter in BigQuery

Starred post

No More Custom event_timestamp in BigQuery?
#
GA4
Friday
8 Nov

No More Custom event_timestamp in BigQuery?

Starred post

Where to Find Ideas for A/B Tests?
#
Metrics
Friday
8 Nov

Where to Find Ideas for A/B Tests?

Starred post

Tea-tasting package for A/B-testing in Python
#
Metrics
Friday
8 Nov

Tea-tasting package for A/B-testing in Python

Starred post

Market Map of Product Analytics
#
Metrics
Friday
8 Nov

Market Map of Product Analytics

Starred post

How to Run an Experiment FOR FREE?
#
Metrics
Friday
8 Nov

How to Run an Experiment FOR FREE?

Starred post

Excel Connector for Looker Studio
#
Friday
8 Nov

Excel Connector for Looker Studio

Starred post

How to Calculate Cumulative WAU and MAU in BigQuery?
#
BigQuery
Friday
8 Nov

How to Calculate Cumulative WAU and MAU in BigQuery?

Starred post

The Ultimate Guide to the UNNEST in BigQuery
#
BigQuery
Friday
8 Nov

The Ultimate Guide to the UNNEST in BigQuery

Starred post

author

Alex Ignatenko

Message
EmailLinkedinTwitterYouTube

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.
2024
analytics@add-2-cart.online