alexignatenko
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
Latest 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

Everything Old is New Again
#
GA4
Friday
8 Nov

Everything Old is New Again

Starred post

What's the Deal with STRUCTS and ARRAYS in BigQuery?
#
BigQuery
Friday
8 Nov

What's the Deal with STRUCTS and ARRAYS in BigQuery?

Starred post

BigQuery now has Workflows!
#
BigQuery
Tuesday
5 Nov

BigQuery now has Workflows!

Starred post

Data Export Limits in GA4 Have Increased!
#
GA4
Tuesday
5 Nov

Data Export Limits in GA4 Have Increased!

Starred post

How to Do a Rolling Count Distinct in BigQuery?
#
BigQuery
Tuesday
5 Nov

How to Do a Rolling Count Distinct in BigQuery?

Starred post

New Traffic Fields in BigQuery: Enhanced Channel Analysis
#
BigQuery
Tuesday
5 Nov

New Traffic Fields in BigQuery: Enhanced Channel Analysis

Starred post

How to Get the Landing Page in BigQuery
#
BigQuery
Tuesday
5 Nov

How to Get the Landing Page in BigQuery

Starred post

How to Create a Sequential eCommerce Funnel in BigQuery
#
BigQuery
Tuesday
5 Nov

How to Create a Sequential eCommerce Funnel in BigQuery

Starred post

Best Practices for Partitioning in BigQuery
#
BigQuery
Tuesday
5 Nov

Best Practices for Partitioning in BigQuery

Starred post

Airflow DAGs in BigQuery
#
BigQuery
Tuesday
5 Nov

Airflow DAGs in BigQuery

Starred post

How to Calculate LTV by Cohorts in BigQuery?
#
BigQuery
Tuesday
5 Nov

How to Calculate LTV by Cohorts in BigQuery?

Starred post

How to Create a Session Table with the session_traffic_source_last_click Field in BigQuery?
#
BigQuery
Tuesday
5 Nov

How to Create a Session Table with the session_traffic_source_last_click Field in BigQuery?

Starred post

Why You Should Use QUALIFY in BigQuery
#
BigQuery
Sunday
1 Sep

Why You Should Use QUALIFY in BigQuery

Starred post

Review of Simo Ahava's Course "Chrome DevTools For Digital Marketers"
#
GA4
Friday
16 Aug

Review of Simo Ahava's Course "Chrome DevTools For Digital Marketers"

Starred post

GA4 For Notion Pages
#
GA4
Wednesday
26 Jun

GA4 For Notion Pages

Starred post

Web Analytics Space In Amplitude
#
Friday
21 Jun

Web Analytics Space In Amplitude

Starred post

GA4-BigQuery Cheat Sheet
#
BigQuery
Friday
21 Jun

GA4-BigQuery Cheat Sheet

Starred post

How long did it take for Google Chrome to conquer the market?
#
Books & Videos
Tuesday
18 Jun

How long did it take for Google Chrome to conquer the market?

Starred post

Custom Event Data Import in GA4
#
GA4
Thursday
13 Jun

Custom Event Data Import in GA4

Starred post

Tips For Form Optimization
#
GTM
Wednesday
29 May

Tips For Form Optimization

Starred post

Product Benchmark Metrics by Amplitude
#
Metrics
Wednesday
29 May

Product Benchmark Metrics by Amplitude

Starred post

Google Analytics Query Explorer
#
GA4
Tuesday
21 May

Google Analytics Query Explorer

Starred post

How Can UDF Simplify Complex Queries In BigQuery?
#
BigQuery
Tuesday
21 May

How Can UDF Simplify Complex Queries In BigQuery?

Starred post

Bayesian Statistics: Star Wars, LEGO, Rubber Ducks, and More
#
Books & Videos
Tuesday
21 May

Bayesian Statistics: Star Wars, LEGO, Rubber Ducks, and More

Starred post

How do Google tags operate with different consent mode settings?
#
GA4
Monday
13 May

How do Google tags operate with different consent mode settings?

Starred post

Consent Mode v2: A Comprehensive Guide
#
GA4
Tuesday
7 May

Consent Mode v2: A Comprehensive Guide

Starred post

The easiest way to create a funnel in Looker Studio
#
GA4
Thursday
18 Apr

The easiest way to create a funnel in Looker Studio

Starred post

Looking to build a funnel in Looker Studio? It's as simple as can be!

Subscriptions Mobile Apps: RevenueCat 2024 report
#
Metrics
Wednesday
17 Apr

Subscriptions Mobile Apps: RevenueCat 2024 report

Starred post

Subscriptions Mobile Apps: RevenueCat 2024 report by Alex Ignatenko

You are losing money on your BigQuery bills
#
BigQuery
Tuesday
20 Feb

You are losing money on your BigQuery bills

Starred post

Event_timestamp in BigQuery - it's not what you think
#
BigQuery
Tuesday
20 Feb

Event_timestamp in BigQuery - it's not what you think

Starred post

How to calculate session attribution in BigQuery?
#
BigQuery
Tuesday
20 Feb

How to calculate session attribution in BigQuery?

Starred post

What parameters do I send with each event?
#
GTM
Tuesday
20 Feb

What parameters do I send with each event?

Starred post

8 Questions from a Marketer That GA4 Can’t Answer
#
Monday
22 Jan

8 Questions from a Marketer That GA4 Can’t Answer

Starred post

How to bridge the gap between GA4 and BigQuery export
#
BigQuery
Wednesday
10 Jan

How to bridge the gap between GA4 and BigQuery export

Starred post

7 deadly sins of GA4
#
GA4
Friday
4 Nov

7 deadly sins of GA4

Starred post

How I Chose an A/B Testing Service
#
Metrics
Friday
4 Nov

How I Chose an A/B Testing Service

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