alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
About
Courses
tag:
bigquery
Thursday
Apr 30, 2026
How to Use TABLESAMPLE in BigQuery for Prototyping — and Why It Saves Real Money on Large GA4 Data?
Thursday
Apr 30, 2026
How to Use APPROX_COUNT_DISTINCT in BigQuery — and When to Trade Accuracy for Query Cost?
Thursday
Apr 30, 2026
How to Use MERGE in BigQuery to Update Marketing Data Warehouses Without Full Recalculation?
Wednesday
Apr 29, 2026
How to Measure New User Share by Channel Correctly?
Wednesday
Apr 29, 2026
How to Compare A/B Test Conversion in BigQuery - and What Statistical Mistakes Kill Your Conclusions?
Wednesday
Apr 29, 2026
How GA4 Records Offline Events — and Why Their Timestamp Breaks Your Session Timeline?
Wednesday
Apr 29, 2026
How to Calculate LTV:CAC by Channel in BigQuery — and Why It Shows Where Budget Leaks Fastest?
Wednesday
Apr 29, 2026
Why Average Campaign ROAS Lies to You — and How to Calculate It by Cohort?
Wednesday
Apr 29, 2026
How to Correctly Identify the Last User Activity Before Purchase
Wednesday
Apr 29, 2026
How to Identify a User’s First Session
Wednesday
Apr 29, 2026
How to Calculate Bounce Rate in BigQuery
Wednesday
Apr 29, 2026
How to Correctly Calculate Average Sessions Before Purchase
Wednesday
Apr 29, 2026
How to Calculate Weekly Retention When Users Don’t Come Back Every Day
Wednesday
Apr 29, 2026
How to Calculate Median Order Value in BigQuery — and Why It’s More Honest Than Average
Wednesday
Apr 29, 2026
Sessions Without page_view: Where Do They Come From and What Should You Do With Them?
Wednesday
Apr 29, 2026
Cumulative Session Metrics: A Trap With a Twist
Wednesday
Apr 29, 2026
Average Order Value by Country: How to Calculate It in BigQuery
Wednesday
Apr 29, 2026
How to Incrementally Update Tables in BigQuery
Wednesday
Apr 29, 2026
How to Calculate Linear Attribution Without Losing Your Mind
Wednesday
Apr 29, 2026
Confidence Interval for Conversion Rate: Is This Even Possible?
Wednesday
Apr 29, 2026
How to Find Top Exit Pages Without Losing Your Mind
#
GA4
Sunday
22 Feb
When Does Analytics Stop Measuring and Start Interpreting?
#
GA4
Sunday
22 Feb
How to Build Reliable Channel Grouping in GA4 BigQuery Without Fighting source/medium Forever
#
BigQuery
Sunday
22 Feb
Why Your BigQuery Numbers Don’t Match “Reality” (Or GA4)?
#
Metrics
Sunday
22 Feb
How an Analyst Loses Control of Metrics — Even Knowing SQL
#
Metrics
Sunday
22 Feb
How Bad Event Timing Breaks Every Product Conclusion?
#
BigQuery
Sunday
22 Feb
Why it's challenging to compare MoM in BiQuery?
#
GA4
Sunday
22 Feb
Which GA4 Fields Should Never Be Used for Business Decisions?
#
GA4
Sunday
22 Feb
How Do You Explain GA4 Number Mismatches to a CEO?
#
Metrics
Sunday
22 Feb
How Can One Window Function Break Your Metrics?
#
BigQuery
Sunday
22 Feb
How to Measure Time-to-Purchase in BigQuery Without Distorting the Customer Journey
#
GA4
Sunday
22 Feb
Can You Rely on GA4’s Attribution Models for Budget Decisions?
#
Metrics
Sunday
22 Feb
Why GA4 and BigQuery Don’t Always Agree on Daily Metrics
#
BigQuery
Sunday
22 Feb
How to Measure Conversion Rate by Landing Page in BigQuery
#
GA4
Sunday
22 Feb
How to Rebuild Sessions in GA4 + BigQuery Without Relying on session_start
#
GA4
Sunday
22 Feb
How Confident Are You That GA4 Preserves Your UTM Parameters?
#
BigQuery
Sunday
22 Feb
Building a Custom Attribution Model in SQL: A More Realistic Way to Assign Credit
#
BigQuery
Sunday
22 Feb
Using ARRAY_AGG in BigQuery to Rebuild User Paths from Raw Events
#
BigQuery
Sunday
22 Feb
Rethinking Conversion Rate in BigQuery: A Practical Approach
#
Metrics
Sunday
22 Feb
How Do Metrics Change Their Meaning When Marketing Scales Faster Than the Analytics Model?
#
GA4
Sunday
22 Feb
Why GA4 Often Shows Fewer Transactions Than Your Payment Gateway
#
GA4
Sunday
22 Feb
Calculating CLV With SQL: Why Window Functions Change the Entire Approach
#
GA4
Sunday
22 Feb
What happens when you trust GA4 modeling - but never look at raw events?
#
GA4
Sunday
22 Feb
Counting New Users in GA4 BigQuery? Avoid the first_visit Trap
#
GA4
Sunday
22 Feb
Why does the same user become three different people in GA4, BigQuery, and your CRM?
#
Metrics
Sunday
22 Feb
Why do analytics reports look correct — but still lead to bad business decisions?
#
BigQuery
Sunday
22 Feb
How to Track N-Day Retention With SQL Window Functions in BigQuery?
#
BigQuery
Sunday
22 Feb
How to Calculate ARPU (Average Revenue Per User) in BigQuery?
#
BigQuery
Sunday
22 Feb
How to Track Trial-to-Paid Conversion in BigQuery for SaaS?
#
BigQuery
Sunday
22 Feb
How to Calculate Net Revenue (After Refunds) in BigQuery?
#
GA4
Sunday
22 Feb
Why Does the Funnel in GA4 Never Match Reality?
#
BigQuery
Sunday
22 Feb
How to Calculate Time-to-Purchase in BigQuery Without Losing Accuracy?
#
GA4
Sunday
22 Feb
Where Does the gclid Go When Landing Pages and Redirects Get Involved?
#
BigQuery
Sunday
22 Feb
How to Calculate Payback Period on Marketing Spend in BigQuery?
#
BigQuery
Saturday
21 Feb
How to Correctly Calculate AOV (Average Order Value) in BigQuery?
#
GA4
Saturday
21 Feb
How do Safari and ITP affect attribution in GA4 and CRM?
#
GA4
Saturday
21 Feb
Why client_id isn’t enough to link offline events to GA4?
#
GA4
Tuesday
2 Dec
How to understand traffic sources in GA4 without losing your mind?
#
GA4
Tuesday
2 Dec
What’s the Right Way to Join GA4 Events and CRM Orders in BigQuery?
#
BigQuery
Tuesday
2 Dec
How not to blow up on BigQuery bills?
#
BigQuery
Tuesday
2 Dec
Top Three Ways to Reduce Your BigQuery Query Costs
#
BigQuery
Tuesday
2 Dec
Why do GA4 to BigQuery reports lag by a day?
#
BigQuery
Tuesday
2 Dec
Why do GA4 and BigQuery reports differ for the same day?
#
BigQuery
Tuesday
2 Dec
What Is Partitioning and How Does It Work in GA4 Export to BigQuery?
#
BigQuery
Tuesday
2 Dec
All About Traffic Source Parameters in GA4 Export to BigQuery
#
BigQuery
Tuesday
2 Dec
How does wrong user_id setup break analytics?
#
Metrics
Monday
1 Dec
How does Meta Ads count view-through conversions and why is it dangerous?
#
BigQuery
Monday
1 Dec
How to Calculate Conversion Rate by Landing Page in BigQuery?
#
GA4
Monday
1 Dec
How to Find Abandoned Carts in GA4 BigQuery - Without Abandoning Your Sanity
#
GA4
Monday
1 Dec
How to Quickly Build a Session Table in GA4 + BigQuery (Without Questioning Reality)
#
GA4
Monday
1 Dec
Have You Checked If Purchases Are Being Lost Without Server-Side Tracking?
#
GA4
Monday
1 Dec
How to Handle String, Integer, and Float Parameter Values in GA4 BigQuery
#
BigQuery
Monday
1 Dec
How to Query Multiple GA4 events_ Tables with _TABLE_SUFFIX in BigQuery
#
GA4
Monday
1 Dec
How to Build Accurate Channel Grouping in GA4 BigQuery (Without Losing Your Mind Over source/medium)?
#
Books & Videos
Sunday
30 Nov
NEW VIDEO! “Why do CONVERSIONS never match across platforms?”
#
BigQuery
Sunday
30 Nov
How to Use IFNULL and SAFE_CAST to Clean Custom Parameters in BigQuery
#
BigQuery
Sunday
30 Nov
How to Use ARRAY_AGG in BigQuery to Reconstruct User Journeys (Without Losing Your Mind)
#
BigQuery
Sunday
30 Nov
Why You Shouldn't Use session_start to Count Sessions in GA4 BigQuery
#
BigQuery
Sunday
30 Nov
How to Calculate Conversion Rate in BigQuery
#
GA4
Sunday
30 Nov
How Long Does a User Session Actually Last — And Does It Affect How You Measure Performance?
#
GA4
Sunday
30 Nov
Are You Sure GA4 is Handling Your UTM Tags Correctly?
#
GA4
Sunday
30 Nov
Do You Compare Two Periods in GA4 — And Do You Know It Might Be Misleading?
#
GA4
Sunday
30 Nov
How to Use GA4 + BigQuery to Measure CAC — Without Burning Your Entire Marketing Budget
#
GA4
Sunday
30 Nov
Why GA4 Data Is Delayed — And Why You're Making Budget Decisions Today
#
GA4
Sunday
30 Nov
Where Does Your Money Go With Black-Box Attribution in GA4 — And How Does It Affect Your Budget?
#
BigQuery
Sunday
30 Nov
How to Calculate Average Order Value (AOV) in BigQuery — Without Fooling Yourself
#
GA4
Sunday
30 Nov
How to Decode Custom Parameters in GA4 BigQuery (Without Losing Your Mind)
#
GA4
Sunday
30 Nov
Did You Know GA4 Uses HLL++ — And You’re Not Seeing Exact Numbers?
#
BigQuery
Sunday
30 Nov
Why Do Custom Dimensions Sometimes Not Show Up in BigQuery?
#
GA4
Sunday
30 Nov
Why Don’t GA4 And BigQuery Data Match — And Which One Should You Trust?
#
BigQuery
Sunday
30 Nov
How to Calculate New vs. Repeat Purchases in BigQuery (Without Losing Faith in Humanity)
#
GA4
Sunday
30 Nov
Are You Sure Your GA4 is Set Up Correctly — Without Server-Side Tracking?
#
GA4
Sunday
30 Nov
How Custom Parameters in GA4 Can Quietly Break Your Reports — Have You Checked Yours?
#
GA4
Sunday
30 Nov
How to Work with item_id in GA4 BigQuery (Without Losing Your Mind)
#
BigQuery
Sunday
30 Nov
How to Measure User Churn in BigQuery Using GA4 Data
#
GA4
Sunday
30 Nov
Are You Losing Purchase Events in GA4 — And How Does That Impact Your Profit Calculations?
#
BigQuery
Sunday
30 Nov
How to Calculate Conversion Rate in BigQuery
#
BigQuery
Sunday
30 Nov
What Counts as an Engaged Session in GA4 — According to BigQuery?
#
GTM
Sunday
30 Nov
How to Set Up GTM for Meta Without Losing Data
#
GA4
Thursday
31 Jul
What Is event_bundle_sequence_id in GA4?
#
Metrics
Thursday
31 Jul
What to Do When Meta Claims Credit for Conversions It Didn’t Earn
#
BigQuery
Wednesday
30 Jul
Why Does BigQuery Show More Users Than the GA4 Interface — and Who’s Telling the Truth?
#
Metrics
Wednesday
30 Jul
How to Avoid Wasting Money on Meta Campaign Tracking — and Get Accurate Data
#
Metrics
Wednesday
30 Jul
How to Track Creatives in Meta Ads at Scale?
#
Metrics
Wednesday
30 Jul
How Server-Side Tracking Can Save Your Meta Campaign
#
Metrics
Wednesday
30 Jul
5 Myths About Consent Mode That Are Costing You Money — Let’s Break Them Down
#
Metrics
Wednesday
30 Jul
So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)
#
Metrics
Wednesday
30 Jul
How To Survive Multiple Attribution Models And Keep Your Sanity (And Budget)
#
GTM
Wednesday
30 Jul
How Measurement Protocol Quietly Destroys Your GTM Server-Side Data (And Ad Budgets)
#
Metrics
Wednesday
30 Jul
Tracking Purchases On The “Thank You” Page? And Where’s The Money?
#
GA4
Wednesday
30 Jul
How Automatic GA4 Events Quietly Ruin Your Server-Side Tracking
#
Metrics
Wednesday
30 Jul
48MB of Pain: How Excel Kills Your Marketing Analytics
#
Metrics
Wednesday
30 Jul
Why Meta Doesn’t See Your Conversions (And What To Do About It)
#
GA4
Wednesday
30 Jul
Consent Mode Is On — But Your Data’s Gone? Here’s a 5-Minute Sanity Check.
#
BigQuery
Wednesday
30 Jul
The Aggregated Report Looks Great. The Decisions? Not So Much.
#
GA4
Wednesday
30 Jul
Google Renamed a Cookie. Again. Not a Disaster — Just Mildly Annoying
#
GA4
Wednesday
30 Jul
Consent Mode Is On. So Where’s The Data?
#
GA4
Monday
21 Apr
Why collected_traffic_sourse ≠ session_traffic_sourse_last_click in GA4-BigQuery?
#
BigQuery
Monday
21 Apr
Unlock the Power of Google Cloud with the VS Code Extension!
#
BigQuery
Monday
21 Apr
Which Python Package to Use for Attribution Calculation?
#
BigQuery
Monday
21 Apr
How to Send Data to BigQuery with SGTM: Easy and Stress-Free
#
BigQuery
Monday
21 Apr
LOGICAL_OR and LOGICAL_AND in BigQuery: segment your data without losing your mind
#
BigQuery
Monday
21 Apr
How to Transfer Data from MySQL or PostgreSQL to BigQuery?
#
BigQuery
Sunday
20 Apr
What is the Signals Gateway by Meta?
#
BigQuery
Sunday
20 Apr
Deduplicate This Immediately!
#
GA4
Saturday
19 Apr
Why Your GA4 Numbers Don't Match
#
BigQuery
Tuesday
10 Dec
The GCLID Issue in BigQuery and How to Solve It
#
BigQuery
Tuesday
10 Dec
How to Quickly Obtain Percentile Values in BigQuery?
#
Metrics
Tuesday
10 Dec
Google trends in BigQuery with bigfunctions. Whaaat?
#
BigQuery
Tuesday
10 Dec
Gemini + BigQuery: A New Era of Analytics with AI or Money Down the Drain?
#
GA4
Tuesday
10 Dec
Detecting Anomalies in GA4 Data with BigQuery and Dataform
#
BigQuery
Tuesday
10 Dec
Quickly Analyzing Revenue Distribution by Customer with GA4 and BigQuery
#
BigQuery
Tuesday
10 Dec
How to Recover a Deleted Table in BigQuery?
#
BigQuery
Tuesday
10 Dec
Google Explains the Difference Between Daily Export and Fresh Daily Export in BigQuery
#
BigQuery
Saturday
9 Nov
Custom Channels Groupping in BigQuery
#
BigQuery
Saturday
9 Nov
What are BigQuery Materialized Views?
#
BigQuery
Saturday
9 Nov
How to Parse URLs in BigQuery?
#
BigQuery
Saturday
9 Nov
How to Retrieve a List of Queries to Looker Reports in BigQuery?
#
BigQuery
Friday
8 Nov
Using DML DELETE to Delete Partitions
#
BigQuery
Friday
8 Nov
Grouping by All in BigQuery! Finally!
#
BigQuery
Friday
8 Nov
Google Increased the Maximum Number of Partitions for BigQuery
#
GA4
Friday
8 Nov
New traffic_source parameter in BigQuery
#
GA4
Friday
8 Nov
No More Custom event_timestamp in BigQuery?
#
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
#
BigQuery
Friday
8 Nov
What's the Deal with STRUCTS and ARRAYS in BigQuery?
#
BigQuery
Tuesday
5 Nov
BigQuery now has Workflows!
#
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?
#
BigQuery
Sunday
1 Sep
Why You Should Use QUALIFY in BigQuery
#
BigQuery
Friday
21 Jun
GA4-BigQuery Cheat Sheet
#
BigQuery
Tuesday
21 May
How Can UDF Simplify Complex Queries In BigQuery?
#
BigQuery
Tuesday
20 Feb
You are losing money on your BigQuery bills
#
BigQuery
Tuesday
20 Feb
Event_timestamp in BigQuery - it's not what you think
#
BigQuery
Tuesday
20 Feb
How to calculate session attribution in BigQuery?
#
GTM
Tuesday
20 Feb
What parameters do I send with each event?
#
BigQuery
Wednesday
10 Jan
How to bridge the gap between GA4 and BigQuery export
bigquery
ga4
metrics
gtm
server-side
attribution
education
abtest
web-analytics
product-analytics
2024
analytics@add-2-cart.online
-p-800.jpg)
