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