alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
AI
About
Courses
tag:
education
Friday
Jul 10, 2026
For years I answered every data question I was asked. That's exactly why I was stuck.
Friday
Jul 10, 2026
I thought being the best at SQL would make me successful. It almost kept me stuck.
Friday
Jul 10, 2026
How to turn a messy CSV export into a board-ready report in Claude?
Friday
Jul 10, 2026
Three years ago, I almost quit analytics. Here's what made me stay.
Friday
Jul 10, 2026
6 ways marketers can stop wasting Claude tokens
Friday
Jul 10, 2026
"I love marketing. But I hate my marketing job"
Friday
Jul 10, 2026
Why do contractor reports look so confident right up until the first “how is this calculated?” question?
Friday
Jul 10, 2026
Why does a CMO so often have to defend the numbers instead of making decisions based on them?
Friday
Jul 10, 2026
Why does the CMO have to defend the numbers instead of making decisions with them?
Friday
Jul 10, 2026
How do you brief an AI agent so it doesn’t confidently produce nonsense?
Tuesday
May 19, 2026
Does your dashboard need an AI chat?
Thursday
Apr 30, 2026
Principles over Tactics
#
Metrics
Sunday
22 Feb
How Does Blurred Ownership Of Metrics Turn Analytics Into a Source of Anxiety?
#
GTM
Sunday
22 Feb
Why does “properly configured” tracking still feel unreliable?
#
Metrics
Sunday
22 Feb
Why do executive dashboards hide problems more often than they reveal them?
#
Metrics
Sunday
22 Feb
Why do analytics reports look correct — but still lead to bad business decisions?
#
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 Track N-Day Retention With SQL Window Functions in BigQuery?
#
GA4
Sunday
22 Feb
How to Calculate Churn Rate in SQL Using GA4 Export Data?
#
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?
#
BigQuery
Sunday
22 Feb
How to Calculate Time-to-Purchase in BigQuery Without Losing Accuracy?
#
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
Why Does Retention Look Different in Product Analytics vs. GA4?
#
Metrics
Sunday
22 Feb
Why Does Analytics Collapse When You Split With an Agency — And How to Avoid It?
#
Metrics
Sunday
22 Feb
Why Do We Collect Dozens of Metrics No One Uses?
#
GA4
Saturday
21 Feb
Can You Trust Google Ads Data? What really happens to your clicks?
#
Metrics
Saturday
21 Feb
How to Attribute Conversions to the First Click (Instead of Last) in SQL?
#
GA4
Tuesday
2 Dec
What’s the Right Way to Join GA4 Events and CRM Orders in BigQuery?
#
BigQuery
Tuesday
2 Dec
Why do GA4 to BigQuery reports lag by a day?
#
GA4
Monday
1 Dec
How Many Purchases Are Lost Due To Browser-Based Tracking — And How Does That Show Up In GA4?
#
Books & Videos
Monday
1 Dec
NEW VIDEO! "How can marketers finally get CLARITY from dashboards?"
#
GA4
Sunday
30 Nov
Why You Shouldn’t Use event_name = 'first_visit' to Count New Users
#
BigQuery
Sunday
30 Nov
What Counts as an Engaged Session in GA4 — According to BigQuery?
#
Metrics
Wednesday
30 Jul
META AND YANDEX EXPOSED: Privacy on Android is a Myth
#
Books & Videos
Sunday
20 Apr
NEW YOUTUBE VIDEO!
#
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
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
How to Choose a Google Ads Agency Without Regretting It Later
#
Books & Videos
Saturday
19 Apr
New video! From first click to repeat purchase - reporting for eCommerce that actually makes sense
#
BigQuery
Tuesday
10 Dec
The GCLID Issue in BigQuery and How to Solve It
#
GA4
Tuesday
10 Dec
Detecting Anomalies in GA4 Data with BigQuery and Dataform
#
BigQuery
Tuesday
10 Dec
How to Recover a Deleted Table in BigQuery?
#
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
#
BigQuery
Saturday
9 Nov
What are BigQuery Materialized Views?
#
GA4
Saturday
9 Nov
Extensions for Displaying the Percentage of the Total in GA4
#
GTM
Saturday
9 Nov
Tracking Single Page Applications (SPA) - Official Google Documentation
#
GA4
Saturday
9 Nov
How to Debug Measurement Protocol Requests in GA4?
#
BigQuery
Saturday
9 Nov
How to Retrieve a List of Queries to Looker Reports in BigQuery?
#
GA4
Saturday
9 Nov
Why Use Custom Channel Groups in GA4?
#
BigQuery
Friday
8 Nov
Using DML DELETE to Delete Partitions
#
BigQuery
Friday
8 Nov
Grouping by All in BigQuery! Finally!
#
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
#
GA4
Friday
8 Nov
How to Fix "(no set)" in Google Analytics 4 Reports?
#
Metrics
Friday
8 Nov
ARPU, ARPPU, and LTV: Differences, Misconceptions, and Importance for Business
#
GA4
Friday
8 Nov
No More Custom event_timestamp in BigQuery?
#
Metrics
Friday
8 Nov
How to Run an Experiment FOR FREE?
#
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
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
How to Get the Landing Page in BigQuery
#
BigQuery
Tuesday
5 Nov
How to Create a Sequential eCommerce Funnel in BigQuery
#
BigQuery
Tuesday
5 Nov
Best Practices for Partitioning in BigQuery
#
BigQuery
Tuesday
5 Nov
Airflow DAGs in BigQuery
#
BigQuery
Tuesday
5 Nov
How to Calculate LTV by Cohorts in BigQuery?
#
BigQuery
Tuesday
5 Nov
How to Create a Session Table with the session_traffic_source_last_click Field in BigQuery?
#
GA4
Friday
16 Aug
Review of Simo Ahava's Course "Chrome DevTools For Digital Marketers"
#
GA4
Wednesday
26 Jun
GA4 For Notion Pages
#
Books & Videos
Tuesday
18 Jun
How long did it take for Google Chrome to conquer the market?
#
Metrics
Wednesday
29 May
Product Benchmark Metrics by 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
