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
Richard Golian

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 · 4 321 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.

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 findings, personal stories, and what I learn from the people I meet.

Join the Library · €29.99 per year How a small business, creator or politician can be… What should I study in the age of AI?… I Left My Job for Several Months to Read… How I Fell in Love With Her, at First… How do you stop depending on social media? Can… How to Start With AI in a Company: Automating…
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. Independent comparisons suggest consent banners can cut measured traffic by roughly 20% to 60%, with the widest gaps on privacy-conscious, tech-savvy audiences. 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.
How do you build your own web analytics?
You describe what you want to measure, then let an AI assistant write the code while you guide and test it. On my blog I started with four things: daily traffic, traffic sources, premium purchases, and a split of visitor types. The hard part is not the charts. It is the plumbing behind them: fast database queries, honest attribution without tracking individuals, and a way to separate real people from bots. I built the whole thing as someone who is not a professional developer.
What is a good free Google Analytics alternative?
The most honest answer is that the best alternative for me was not another product, but a small tool I built myself. Google Analytics gave me inaccurate numbers, needed a cookie banner, and left me unsure about privacy. A self-built, cookie-free tool gave me clean data I actually trust, with no banner and nothing to hide. It is more work up front, but you own the data and the logic.
Is self-hosted analytics worth it?
For me, yes. Self-hosted means the analytics run on my own infrastructure, so no third party sees my visitors and no data leaves my control. The trade-off is that you maintain it yourself. With AI helping me write and fix the code, that maintenance became manageable even for an eternal beginner, and in return I get unfiltered data and full privacy.
Is Google Analytics GDPR compliant?
It can be configured towards compliance, but it still relies on cookies and consent, which is exactly what I wanted to avoid. The tool I built is GDPR-compliant by design: it anonymises everything, stores no personal information, and needs no cookie banner at all. I do not need to know that a specific named person read an article, only how many real humans visited and what they did.
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

How a small business, creator or politician can be independent of big platforms in the AI age

Are you a content creator playing by the rules of YouTube, Instagram or Google? Are you a small business owner whose business model depends on how often Amazon recommends you, how expensive Facebook ad impressions will be or how expensive Google Ads clicks will be? If all or most of your contact with your audience or customers depends on a big platform showing you to them, you are not in a strong position.

11 October 2026·724 reads
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 672 reads
How to tell human-made content from AI-generated content online

It cannot be done with 100% certainty. When I wrote about the dead internet theory, I wrote that we will no longer have certainty online and that for every verification tool there will be a tool that fools it. This is still true.

15 October 2026·261 reads

More articles

What should I study in the age of AI? What should I major in? Does a degree still make sense?

The development of artificial intelligence changes how we look at which paths in life make sense. Which studies and which profession to choose.

4 October 2026·462 reads
I Left My Job for Several Months to Read Philosophy

It was Thursday, 31 March 2022, when I handed over the last of my responsibilities to my colleagues, closed my laptop and went to the library. I left my job for several months and immersed myself in philosophy. And I am immensely grateful for it. Today I am, like most people, on a merry-go-round, and it is hard for me to stop and think about the fundamental questions of my own life.

28 September 2026·794 reads
How I Fell in Love With Her, at First Sight

It was September 2023. My life, my work, everything was completely different from now. It was simpler. I owned almost nothing. I needed to film an advert, I went up to a floor inside the company where the product I needed for that advert was, and there I noticed her for the first time. She laughs at me when I describe it like this, but at that moment the universe told me, that is her.

20 September 2026·784 reads
How to stop depending on social media, and what the IndieWeb is

How and why I am gradually leaving social media and the big platforms. When I read that Meta is testing a new way to charge for organic posts that link outside its platform, it confirms how right I was to become steadily less dependent on the big platforms and on social media. It does not mean I have left them completely. It means that whether or not I stay in touch with my readers depends on them less and less, and today almost not at all.

9 September 2026·856 reads
How to Start With AI in a Company

One of my family members described a firm that has its data in several different tools, and its employees still join it by hand, in spreadsheets. That is the ordinary state of firms. When somebody tells such people not to do it by hand and to use AI, they will not understand. Most firms do not even have the basic connectors between the tools they use. These firms need help with AI transformation.

12 August 2026·953 reads
Fable 5 vs Opus: the cheaper model won

The same task, two models. Fable 5 against Opus 4.8. On paper Fable is the better model, with a larger context and stronger specs. And still it lost. Opus handled the task with a single round of checking for 721,000 tokens, while Fable needed nine rounds and burnt through 2.78 million tokens. The difference was not in the model, but in how I set the task. And I know it, because I measured it.

22 July 2026·1 245 reads
I Ran Object Detection on My Laptop, and Saw Everything Is Possible

A few weeks ago I installed a small local AI model on my laptop that watches a live camera feed. I turned the webcam on in the dark, and in near total darkness it recognised me and the objects in the room. That such things exist, I have known for a long time. What opened my eyes was the accessibility. I installed it in one prompt, free, and it runs entirely on my machine, sending data nowhere.

15 July 2026·875 reads
My blog is full of bots and AI agents

I once wrote about building my own privacy-friendly analytics tool. It had bot detection from the first version, yet it was not enough. Direct visits took a strangely high share of my traffic. When someone claims that 20% of their visits are bots and 80% are humans, I used to think the same. Today I would say the opposite ratio is closer to the truth. This is how I got there.

6 July 2026·2 557 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·1 558 reads
Everything with AI agents, or fully offline.

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·1 862 reads
NEWSLETTER
What I write about, what I am working on, what I learned.
Sent the first Sunday of the month. Unsubscribe anytime.