Alex Ignatenko - The Best 2025 Linkedin Posts FOR FREE
Almost every day I share a post on LinkedIn about marketing analytics, BigQuery, GA4, GTM, and other aspects of working with data. To ensure it doesn't get lost, I've compiled the top of posts from the current year into one document, complete with links to them. Below, you can quickly find the post you're looking for, read it, or save it. As always, I'm grateful for any reposts, comments, or any other reactions.
Have a question about analytics? Feel free to schedule a short meeting.
Download Have a question about analytics? Feel free to schedule a short meeting.
Top 2025 Picks
- Stop Using session_start as Your Primary Session Counter in GA4 BigQuery
- How to Find Abandoned Carts in GA4 BigQuery - Without Abandoning Your Sanity
- How to Calculate CLV (Customer Lifetime Value) With SQL Window Functions?
- Why do GA4 reports show fewer transactions than the payment gateway?
- How to Calculate Churn Rate in SQL Using GA4 Export Data?
- How to Build a Custom Attribution Model in SQL (Without Crying)
- Why does Meta Ads attribute to itself customers who bought via email?
- How to Attribute Conversions to the First Click (Instead of Last) in SQL?
- How to Quickly Build a Session Table in GA4 + BigQuery (Without Questioning Reality)
- How to Correctly Calculate Retention Rate with SQL Window Functions?
- Can You Trust GA4’s Attribution?
- How to Calculate Conversion Rate by Landing Page in BigQuery?
- How to Calculate Time-to-Purchase in BigQuery Without Losing Accuracy?
- Why do GA4 and BigQuery reports differ for the same day?
- Why client_id isn’t enough to link offline events to GA4?
- How not to blow up on BigQuery bills?
- How can server-side GTM make your data worse — even if it was set up “by the book”?
- Identifying Abandoned Carts in GA4 BigQuery Without Overcomplicating the Logic
- How much do 70% cookie banner refusals affect GA4 data?
- How does GA4 conversion rate mislead us?
- Where Does the gclid Go When Landing Pages and Redirects Get Involved?
- All About Traffic Source Parameters in GA4 Export to BigQuery
- Why Does the Same Channel Show Different Revenue in GA4 vs. BI?
- What Happens To Tracking When the User Is On iOS - Are You Counting That?
- How do Safari and ITP affect attribution in GA4 and CRM?
- What’s Left of Analytics If You Lose Access to the GTM Container?
- How GA4's default session timeout can cost your business millions?
- Can You Trust Google Ads Data? What really happens to your clicks?
- Why does the same user become three different people in GA4, BigQuery, and your CRM?
- Can GA4 multi-channel attribution be trusted?
Fill Out The Form and Get Top 2025 Picks
Author
Alex Ignatenko
Founder, Analytics Leader @ add-2-cart.online
With over ten years of experience in product and marketing analytics, Alex help ecommerce companies earn more from each attracted user through a deep approach to traffic analysis and redistribution of the marketing budget. His mission is to enable data-driven decision making and effective experimentation for online businesses
Join my Workshop Series "Marketing Attribution in BigQuery"
Master marketing attribution in BigQuery -
from the basics to advanced models.
Join from the basics to advanced models.
- RecordingWatch the session anytime for a refresher
- InteractionKey takeaways and structured step-by-step instructions
- PracticeGet homework assignments to check your understanding
-
ApplicationYou’ll have the chance to apply what you’ve learned directly to your projects. -
Live WalkthroughWe’ll cover 15 online lessons packed with theory and practical examples. -
Questions
Get expert insights on your specific challenges
How to Get in Touch
