Richard Golian

1995-born. Charles University alum. Head of Performance at Mixit. 10+ years in marketing and data.

Castellano Français Slovenčina

Manage subscription Choose a plan

RSS
Newsletter
New articles to your inbox

Article

What Is Vibe Coding? How I Built a Google Analytics Alternative With AI After a Decade Away From Coding

How to build an app with AI when you are not a developer, my vibe coding story
Richard Golian
Richard Golian · 3 642 reads
Hi, I am Richard. On this blog, I share thoughts, personal stories, findings and what I am working on. I hope this article brings you some value.
Listen to this article
0:00 / 0:00

Not long ago, I realised I wanted a better understanding of my blog’s traffic.

I like clean and accurate data. But traditional analytics tools like Google Analytics come with serious downsides: inaccurate numbers (due to blocked consent requests and various tracking blockers), the need for a cookie banner, and questionable transparency around privacy.

That is why I decided to build my own analytics, with pure, unfiltered data and full respect for the privacy of my visitors. And since we are living in 2025, I built it with the help of generative AI.

When it comes to programming, I have always considered myself an eternal beginner, ever since I started with web development at the age of 12. But AI has opened up skills and opportunities for me that I never imagined I would have. I have already written here on my blog about how AI helps me improve my coding skills, explaining its steps and decisions along the way. Thanks to that, my horizons have expanded far beyond what I thought possible. One of the results is my own custom-built analytics tool.

There is a name for this way of working with AI: vibe coding. What is vibe coding? It means building software by describing what you want to an AI assistant in plain language and letting the model write the actual code, while you guide, test and correct it. The term was coined by Andrej Karpathy in February 2025. I am not a professional developer, yet this is exactly how my own analytics tool came to exist.

How vibe coding actually works: defining the goals and first prompts

When building a project like this today, you really need to have a clear idea of what you want it to do and why. Just saying "I want my own analytics" is not enough.

So we started by defining exactly what I wanted to measure: daily traffic, traffic sources, purchases of my premium articles, and a deeper analysis of visitor types (humans vs. suspicious activity vs. bots).

Richard Golian analytics
An analytics tool powered by artificial intelligence

At first, creating the initial tables and charts seemed easy. But it did not take long before the first real challenges emerged.

The issues I had to solve

The first SQL queries we used were slow and inefficient. They dragged the whole website down. We gradually tuned them, replaced wasteful LIKE comparisons with exact matches, and optimised the logic to only process the data we really needed, and suddenly, it started to fly.

Continue

Join the Library

Full access to my thoughts, personal stories, findings, and what I learn from the people I meet.

Join the Library · €29.99 per year
Read only this one · €2,99

Get the full article by email and feel free to reply if you want to discuss it further.

Visa Mastercard Apple Pay Google Pay

Summary

Google Analytics was showing inaccurate numbers. Blocked consent, tracking blockers. So I built my own cookie-free, GDPR-compliant analytics system using AI. Daily traffic, sources, premium purchases, bot detection. AI expanded what an eternal beginner like me can build.

Common questions on this article's topic

What is vibe coding?
Vibe coding is the practice of building software by describing what you want to an AI model in natural language and iterating on the code it generates, rather than writing every line yourself. The term was coined by Andrej Karpathy in February 2025. In this article I describe using this approach to build a real, production analytics tool despite not being a professional developer: I defined the goals, wrote the prompts, tested the output, and fixed what the AI got wrong.
Why is Google Analytics inaccurate?
Google Analytics relies on JavaScript tracking that can be blocked by ad blockers, privacy extensions, and consent banners. Research shows that sites with consent banners miss approximately 20% of visitor data, and on tech-savvy audiences the figure can reach nearly 60%. In the article, these accuracy problems, combined with the need for cookie banners and concerns about privacy, motivated building a custom solution from scratch.
Is it possible to build web analytics without cookies?
Yes. Cookie-free analytics works by collecting aggregated data without tracking individual users. Tools like Plausible, Fathom, and Umami demonstrate this approach commercially. In the article, a custom cookie-free system was built that tracks daily traffic, sources, and premium purchases without storing personal data, making it naturally GDPR-compliant with no cookie banner required.
What percentage of web traffic comes from bots?
By 2024, bot traffic exceeded human traffic for the first time in a decade, accounting for approximately 51% of all web traffic. Bad bots specifically represented about 37% of global web traffic. In the article, distinguishing real human visitors from bots and suspicious activity was a key challenge, solved by flagging suspicious visits and tracking confirmed bot behaviour separately.
Can someone with limited programming experience build custom analytics using AI?
In the article, this is exactly what happened. Starting as a self-described eternal beginner in programming, the custom analytics system was built entirely with AI assistance. AI did not just generate code. It explained each step, guided through problems, and taught better approaches along the way. Research shows that developers using AI coding assistants can be up to 55% more productive, making complex projects feasible for non-specialists.
How does privacy-first analytics work without tracking individuals?
In the article, the approach is straightforward: all traffic data is anonymised and contains no personal information. There is no need to know that a specific person from a specific city read a specific article. What matters is how many real humans visited, how many chose to buy premium content, and what the main traffic sources were. Sensitive calculations and database logic are kept in a protected area that no regular visitor can access.
What were the biggest technical challenges in building custom analytics?
In the article, three main challenges are described. First, initial SQL queries were slow and dragged the website down, solved by replacing inefficient comparisons with exact matches and optimising query logic. Second, attribution without individual tracking required a temporary anonymous session identifier. Third, separating real visitors from bots and suspicious traffic required a classification system with clear definitions and separate tracking.
Richard Golian

If you have any thoughts, questions, or feedback, feel free to drop me a message at mail@richardgolian.com.

NEWSLETTER
What I write about, what I am working on, what I learned.
Sent the first Sunday of the month. Unsubscribe anytime.

Related articles

Shadow AI: The Data Privacy Risk of Sharing Sensitive Information with AI

This is a serious issue, and it is high time we start acting responsibly.

1 February 2025·2 280 reads
Dependent on AI: Are We Still Masters, or Slaves?

I have Heidegger and my notebook beside me. I am asking where all of this is heading, where artificial intelligence is taking us.

21 June 2026·440 reads
Workslop: no one reads what AI writes

Sixteen of twenty-seven sources did not check out. They did not exist, led to dead links, or claimed something that was not in them. The report came from one of the largest consulting firms in the world. It was meant to be about cybersecurity. They pulled it.

12 June 2026·497 reads

More articles

Which Work Will AI Not Replace?

Seventy per cent. That is where the first AI output begins, even when you give it the full company context and the best examples from the past. We are talking about the kind of output that cannot be defined programmatically. It is more complex. Often it is creative work. On one repeated type of output I reached eighty per cent within a week. Every further percentage point is harder than the one before.

10 June 2026·437 reads
What is the dead internet theory? Will we return offline?

For a long time we treated the internet as the main road. The place where work and relationships happen. Yet most of what we see on it today is, or soon will be, AI-generated: text, images, profiles and comments. The internet is turning into an online game full of bots, where you cannot be sure that a human is on the other side of anything. So I ask: was the online world the main road, or only a temporary detour that part of us will return from, back offline?

7 June 2026·486 reads
The Gap Between Professionals in the AI Era

A few days ago I interviewed a senior marketer. An experienced man, years of practice. I asked him about AI. He said he barely uses it. He had one bad experience with the output and decided he was too senior for it to add value when it is not perfect. I know the other side too: professionals who automate everything that can be automated.

6 June 2026·549 reads
Europe Is Not Ready for Drone Warfare

Europe does not have the capacity to face a full-scale, mass drone war of the kind we see in Ukraine. Three dependencies weaken it: China supplies the physical material for defence systems, the United States supplies capabilities Europe does not have, and twenty-seven states cannot agree how fast, or who pays. Rearmament plans exist, but they are being carried out slowly.

31 May 2026·501 reads
Can AI Replace Human Judgement?

AI produces the graphic, the newsletter and the product page faster than a person. What is left for the one who used to do it is the judgement, knowing whether the output is good. But most people have worse judgement than AI. And whoever cannot judge quality cannot delegate either. How do you tell whether yours is the judgement a company relies on, or the kind it can replace?

30 May 2026·507 reads
What Determines a Stock Price?

In April, in the first part of this series, I wrote about an AI prediction system I had started building on my own machine. At the time the software was a few hours old and the prediction record was empty. The record since then has shown one thing: the system does not yet understand the market it is being asked to forecast. It can pull macro context, book value, earnings. But it cannot put those together into something that helps it understand the price.

23 May 2026·569 reads
Where the Money Goes When AI Takes the Work: Mapping the AI Economy

Prague, 13 May 2026. On my way to work I started thinking about something that stayed with me for days. If most routine work on a computer disappears in the next ten years, and a large share of repetitive manual work disappears with it, what happens to the flow of money? Who pays whom for what? Which economic layers will exist, how large will they be, and what relationships will run between them? This is the six-layer map I sketched as an answer.

15 May 2026·1 191 reads
Can AI Predict the Stock Market? Building a Calibrated System

I am building an AI system to predict the S&P 500. It runs on my own machine, uses free public data (yfinance, FRED, the Shiller dataset), and grades every forecast against reality. This series documents the build itself: the decisions, the methodology, the mistakes. What I will eventually share from the running system is a separate question, and an honest one.

26 April 2026·1 494 reads
AI sales forecast: 9 traps so far

Yesterday I could not tear myself away from the computer. When I lifted my head, it was half past eight in the evening. I had been sitting alone upstairs for about three hours.

25 April 2026·1 032 reads
All in on AI agents, or an analogue life.

Four days in Catalonia. No computer, no AI, almost no social media. I bought this notebook so that I could write down what I would think about, and what I would come across and learn on the trip.

10.5.2026·944 reads
NEWSLETTER
What I write about, what I am working on, what I learned.
Sent the first Sunday of the month. Unsubscribe anytime.