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