alex
ignatenko
BigQuery
Books & Videos
GA4
GTM
Metrics
Other
About
Courses
tag:
attribution
Wednesday
May 27, 2026
What do you do when your marketing dashboard doesn't tell you what to do? And can AI actually help?
Wednesday
May 27, 2026
What do you do when you have more marketing data, smarter AI, and still no results?
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 Calculate Linear Attribution Without Losing Your Mind
Wednesday
Apr 29, 2026
Startups’ favorite mantra: “We’re B2B SaaS — so monetization = subscription”
#
GA4
Sunday
22 Feb
When Does Analytics Stop Measuring and Start Interpreting?
#
GA4
Sunday
22 Feb
What Does Session Duration in GA4 Actually Measure – and Should You Trust It?
#
GA4
Sunday
22 Feb
Which GA4 Fields Should Never Be Used for Business Decisions?
#
GA4
Sunday
22 Feb
Are You Measuring Retention — or Just Recounting Sessions?
#
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 Do Metrics Start Contradicting Each Other — Even From the Same Source?
#
Metrics
Sunday
22 Feb
Why Does Decision-Making Get Harder When All Data is Available?
#
Metrics
Sunday
22 Feb
Why Does Analytics Increase Tension Between Marketing, Product, and Finance?
#
Metrics
Sunday
22 Feb
Why Does a CMO Feel Responsible For Numbers He Doesn’t Actually Control?
#
Metrics
Sunday
22 Feb
How to Calculate Retention with SQL Window Functions (Without Mixing Everything Together)
#
Metrics
Sunday
22 Feb
Why Does Having More Data Make Uncertainty More Visible Instead of Reducing It?
#
Metrics
Sunday
22 Feb
Why Do Numbers Stop Helping Teams Agree — And Start Defending Positions?
#
Metrics
Sunday
22 Feb
Why Do Metrics Stop “holding together” Once a Company Grows Beyond One Channel?
#
Metrics
Sunday
22 Feb
How to Shift Attribution from Last Click to First Click in SQL
#
GA4
Sunday
22 Feb
How Confident Are You That GA4 Preserves Your UTM Parameters?
#
Metrics
Sunday
22 Feb
How Does Blurred Ownership Of Metrics Turn Analytics Into a Source of Anxiety?
#
Metrics
Sunday
22 Feb
Why Do Metrics Stop Reflecting Reality When the Business Becomes More Complex?
#
Metrics
Sunday
22 Feb
Why Does Automation Increase CMO Frustration Instead of Reducing It?
#
BigQuery
Sunday
22 Feb
Building a Custom Attribution Model in SQL: A More Realistic Way to Assign Credit
#
Metrics
Sunday
22 Feb
What Breaks When One Team Owns Growth and Another Owns Accuracy?
#
Metrics
Sunday
22 Feb
Why Does Adding More Metrics Reduce Confidence Instead of Improving Control?
#
Metrics
Sunday
22 Feb
Why Do CMOs Doubt Data Most When Everything Looks “too perfect”?
#
BigQuery
Sunday
22 Feb
Using ARRAY_AGG in BigQuery to Rebuild User Paths from Raw Events
#
Metrics
Sunday
22 Feb
Why Do Different Teams Read The Same Report — And Make Opposite Decisions?
#
Metrics
Sunday
22 Feb
How Do Deduplication Errors End Up Affecting Careers — Not Just Metrics?
#
Metrics
Sunday
22 Feb
Why Does a CMO Stop Trusting Data During Growth — Not During a Crisis?
#
GA4
Sunday
22 Feb
How to Calculate Net Dollar Retention (NDR) With SQL Window Functions?
#
GA4
Sunday
22 Feb
How to Track Subscription Renewals in GA4 Export Data?
#
GA4
Sunday
22 Feb
Can You Really Trust Average Session Duration in GA4?
#
BigQuery
Sunday
22 Feb
How to Track Trial-to-Paid Conversion in BigQuery for SaaS?
#
GA4
Sunday
22 Feb
Where Does the gclid Go When Landing Pages and Redirects Get Involved?
#
GA4
Sunday
22 Feb
Why 20 CSV Files Will Never Give You Good Analytics
#
Metrics
Saturday
21 Feb
How to Attribute Conversions to the First Click (Instead of Last) in SQL?
#
GA4
Saturday
21 Feb
Why client_id isn’t enough to link offline events to GA4?
#
Metrics
Saturday
21 Feb
How to Correctly Calculate Retention Rate with SQL Window Functions?
#
BigQuery
Tuesday
2 Dec
How not to blow up on BigQuery bills?
#
GA4
Tuesday
2 Dec
How does GA4 conversion rate mislead us?
#
GA4
Tuesday
2 Dec
Can GA4 multi-channel attribution be trusted?
#
GA4
Tuesday
2 Dec
How to Build a Custom Attribution Model in SQL (Without Crying)
#
Metrics
Tuesday
2 Dec
Why does Meta Ads attribute to itself customers who bought via email?
#
GA4
Tuesday
2 Dec
Why do GA4 reports show fewer transactions than the payment gateway?
#
Metrics
Tuesday
2 Dec
How is CPA defined in Ads Manager and CRM - do they match?
#
BigQuery
Tuesday
2 Dec
How does wrong user_id setup break analytics?
#
GA4
Monday
1 Dec
How Many Purchases Are Lost Due To Browser-Based Tracking — And How Does That Show Up In GA4?
#
Metrics
Sunday
30 Nov
Which Of The Three Conversion Metrics in GA4 Are You Using — And Do You Know the Difference?
#
BigQuery
Sunday
30 Nov
Why You Shouldn't Use session_start to Count Sessions in GA4 BigQuery
#
GA4
Sunday
30 Nov
What Does An “engaged session” in GA4 Really Mean — And What Does It Have To Do With Actual Engagement?
#
BigQuery
Sunday
30 Nov
How to Calculate Conversion Rate in BigQuery
#
BigQuery
Sunday
30 Nov
How to Calculate Average Order Value (AOV) in BigQuery — Without Fooling Yourself
#
GA4
Sunday
30 Nov
Why Is Some Of Your Traffic Ending Up in (direct)/(none) — And How Much Is That Costing Your Marketing?
#
Metrics
Sunday
30 Nov
Does SEO Really Drive 60% of Sales? Or Do All Roads Just Lead to Organic?
#
Metrics
Sunday
30 Nov
How to Properly Handle Offline Conversions in Meta
#
BigQuery
Sunday
30 Nov
What Counts as an Engaged Session in GA4 — According to BigQuery?
#
Metrics
Friday
1 Aug
Why Meta Might Be Burning Your Budget — and How to Stop It
#
BigQuery
Wednesday
30 Jul
Why Does BigQuery Show More Users Than the GA4 Interface — and Who’s Telling the Truth?
#
Metrics
Wednesday
30 Jul
Why Meta’s 7-Day Attribution Window Is a Real Problem
#
Metrics
Wednesday
30 Jul
So... Do You Really Need Raw Data To Get Attribution Right? (Yes, You Do)
#
GA4
Wednesday
30 Jul
Launched a Facebook Campaign — And GA4 Suddenly Shows a Spike In Direct Traffic? Weird, Right?
#
Metrics
Wednesday
30 Jul
How To Survive Multiple Attribution Models And Keep Your Sanity (And Budget)
#
Metrics
Wednesday
30 Jul
META AND YANDEX EXPOSED: Privacy on Android is a Myth
#
Metrics
Wednesday
30 Jul
Last Click Out Of The Box? That’s a Trap.
#
Metrics
Wednesday
30 Jul
How Do You Train Meta Campaigns When Your Sales Cycle Is Longer Than a Netflix Miniseries?
#
BigQuery
Wednesday
30 Jul
The Aggregated Report Looks Great. The Decisions? Not So Much.
#
Metrics
Wednesday
30 Jul
Low CPA, No Money. Amazing, Right?
#
GA4
Wednesday
30 Jul
Meta Says 170 Conversions. Google Ads Shows 85. GA4 Lands at 110. So... Who’s Telling The Truth?
#
GA4
Wednesday
30 Jul
“Our Attribution is Very Complex” — Why That’s Often Just an Excuse
#
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
#
Metrics
Monday
21 Apr
Stop A/B Testing!
#
BigQuery
Monday
21 Apr
LOGICAL_OR and LOGICAL_AND in BigQuery: segment your data without losing your mind
#
BigQuery
Sunday
20 Apr
Deduplicate This Immediately!
#
Books & Videos
Sunday
20 Apr
NEW YOUTUBE VIDEO!
#
GA4
Sunday
20 Apr
When Conversions Don't Match Sales
#
GA4
Sunday
20 Apr
How to Evaluate Ad Campaigns in Google Analytics (Without Losing Your Mind)
#
GA4
Saturday
19 Apr
Debugging sGTM used to be a pain - until I found this
#
GA4
Saturday
19 Apr
Consent Mode in GA4 – What It Is and Why It Might Melt Your Brain a Little
#
Books & Videos
Saturday
19 Apr
New video! From first click to repeat purchase - reporting for eCommerce that actually makes sense
#
GA4
Saturday
19 Apr
When the GA4 community builds the features Google forgot
#
BigQuery
Tuesday
10 Dec
The GCLID Issue in BigQuery and How to Solve It
#
GTM
Tuesday
10 Dec
Why is update=true Important in Google Tag Settings for SPAs?
#
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?
#
Metrics
Tuesday
10 Dec
Common Mistakes in ROI Calculations Due to Attribution Model Specifics
#
GTM
Saturday
9 Nov
Traffic Attribution in Single Page Applications
#
Metrics
Saturday
9 Nov
Attribution Models Cheat Sheet
#
BigQuery
Saturday
9 Nov
Custom Channels Groupping in BigQuery
#
GA4
Saturday
9 Nov
How to Debug Measurement Protocol Requests in GA4?
#
GA4
Saturday
9 Nov
Why Use Custom Channel Groups in GA4?
#
Metrics
Friday
8 Nov
Leading and Lagging Metrics - What's the Difference in a Nutshell?
#
Metrics
Friday
8 Nov
What is the Top Score Attribution?
#
GA4
Friday
8 Nov
GA4 and Google Sheets Integration
#
Metrics
Friday
8 Nov
Why Can't You Rely on Facebook Ads Analytics?
#
GA4
Friday
8 Nov
How to Fix "(no set)" in Google Analytics 4 Reports?
#
GA4
Friday
8 Nov
User Data Import without Website Visits
#
Metrics
Friday
8 Nov
What's Available for Marketing Attribution in 2024 Besides GA?
#
GA4
Friday
8 Nov
New traffic_source parameter in BigQuery
#
Metrics
Friday
8 Nov
Where to Find Ideas for A/B Tests?
#
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
BigQuery now has Workflows!
#
GA4
Tuesday
5 Nov
Data Export Limits in GA4 Have Increased!
#
BigQuery
Tuesday
5 Nov
New Traffic Fields in BigQuery: Enhanced Channel Analysis
#
BigQuery
Tuesday
5 Nov
How to Create a Sequential eCommerce Funnel in BigQuery
#
GA4
Thursday
13 Jun
Custom Event Data Import in GA4
#
BigQuery
Tuesday
20 Feb
How to calculate session attribution in BigQuery?
bigquery
ga4
metrics
gtm
server-side
attribution
education
abtest
web-analytics
product-analytics
2024
analytics@add-2-cart.online
