AI Agent Analytics with Vercel & MotherDuck ·
Track AI agent traffic that bypasses your web analytics. Stream Vercel Log Drains into MotherDuck to see how ChatGPT, Claude, and other agents browse your site.
Analytics
-
-
DuckDB is my new Excel ·
I'll admit it: as a data engineer I still use Excel. But DuckDB has become my secret weapon for ad-hoc data exploration. No more struggling with CSV imports, no more manual column matching across files, no more giving up on JSON. This guide shows you how to query remote CSVs, handle schema drift across multiple files, unnest nested data, and flatten JSON APIs—all with SQL you can remember if you can remember Excel formulas.
-
Turn Thousands of Messy JSON Files into One Parquet: DuckDB for Fast Data Warehouse Ingestion ·
If you've inherited a bucket full of thousands of tiny JSON files—one per API call, one per event, one per log minute—you know the pain: slow scans, schema anxiety, and rising warehouse bills. This guide shows you how to consolidate them into clean Parquet with DuckDB: handling schema drift, maintaining lineage, optimizing performance, and integrating with dbt. Touch your raw files once, then model against something stable.
-
Data Observability is not a tool: understanding data quality at the source, in transformations and in governance ·
Data observability tools promise to fix your data quality, but buying a tool won't solve problems you don't understand. This post breaks down where data quality actually breaks: in source systems (completeness, consistency, reliability), during transformations (integrity, accuracy), and in governance (documentation, ownership). Understand the root causes before you reach for a solution.
-
Why web analytics is still a mess in 2023 ·
Web analytics still feels 'messy' in 2023. Why is it so hard to solve the problem of web analytics? Let's dive into some of the misconceptions that fuel the mess, like the ideas that websites are easy, are visited by people, that web analytics is about tracking poeple, that we have all the tools we need, and that web analytics is actually important.
-
The 5 essential steps of a (web) analytics pipeline: collection, routing, ingestion, storage and visualisation ·
When we think of analytics we think of tools like Google Analytics, Mixpanel or even Tableau or PowerBI. But analytics is not just a tool. When we understand the mechanisms behind these tools we are ready to see what each of them brings to the table and how they might solve the problems for the unique snowflakes that we are.
-
Real Time Analytics Monitoring with Google Sheets ·
Whether it's because you don't want your business to lose money or because you just like to watch videos on YouTube, automating your analytics monitoring can help you sit back and relax knowing that everything's under control. This time we'll look at how a simple Google Sheet can help you check your analytics on the fly with the Google Analytics Real Time Reporting API.
-
Analytics and tag testing with Cypress ·
One thing that's often overlooked in setting up your analytics is making sure it keeps working. When you add new tags or your developers deploy new versions it's easy to forget about your site tracking until the revenue in your ecommerce reports drops to zero. That's usually the point where accusations fly back and forth past the office chairs and the boardroom starts asking uncomfortable questions. So let's set up some tests for your analytics and tag management.
-
Why you should stop using Google Analytics (as we know it) ·
Google Analytics has grown to be the most common means of tracking web behaviour since its launch in 2005. However, the tool itself hasn’t really been updated since the launch of its ‘Universal Analytics’ in 2012. That’s almost eight years ago, and eight years is a long time in the online world. Now might just be the right time to ditch the good, old Analytics and start using, yes, Google Analytics.
-
8 ways to optimise Google Tag Manager (GTM) for speed and performance ·
Google Tag Manager makes it incredibly easy to add marketing tags to your site. From registering ads conversions and transactions to sophisticated tags that segment users based on the weather in their current location, you can go crazy without having to go back to your development team every time. But that doesn't mean you should do it all. While your dev and SEO teams are working hard to reach their pagespeed goals all the marketeers are having a proverbial party in their yard. Here you'll find a few tips to keep your GTM container lean and fast.