This startup did programmatic SEO with NoCode on $50/mo stack!

You can get thousands of visitors using Programming + SEO. But, what if I told you that you could buildd a programmatic SEO website without writing a single line of code. Here's how!

20th October 2022
5 min read

In a nutshell

Breweriesnearby.com is a programmatic SEO website built by Ian Ruta.

Ian is really passionate about breweries.

So, considering the high SEO potential of brewery keywords, he decided to buildd a directory for craft breweries using NoCode tools.

Programmatic SEO is a way to create 1000s of pages based on an underlying database.

Here are the different parts of Breweriesnearby that together make a programmatic SEO website:
a) Content
b) SEO potential
c) Database
d) Automated Pages

But, why go the NoCode way?

Problem:
- Generating SEO traffic is NOT straightforward
- It requires rapid experimentation
- Time and cost of hiring a dev team made the project risky ➝ in-front cost
- Plus there was bound to be recurring dev cost ➝ multiple iterations

Solution:
- With NoCode, Ian built the MVP and version 1 at fraction of the cost and time
- The project was built with less complexity - as there was no need to communicate and align with a team.
- Plus he could experiment and iterate quickly based on user feedback

NoCode Tech Stack

1. Webflow ⇒ pages are automatically created from Webflow's CMS data and templates. It has in-built technical SEO capabilities and provides design flexibility
2. Airtable ⇒ is the main database that stores all the content we discussed earlier.
3. Whalesync ⇒ syncs data from Airtable to Webflow's CMS. This is a faster more user-friendly syncing alternative to Zapier.

4. Jetboost ⇒ NoCode Webflow tool that adds features like search, pagination, and filtering to your website.
5. Octoparse ⇒ Octoparse is a free scraper tool that gathers data from brewery directories and structures them into spreadsheets that are pasted into the Airtable database.
6. SEMRush ⇒ SEO tool that helps identify low-competition, high-volume long-tail keywords surrounding breweries.

Final impact

A) Cost
- Webflow + Airtable + WhaleSync + Octoparse + SEMRush ⇒ $50/month
- Opposed to the $3k for a dev team

B) Time
- MVP ➝ 1 week
- Version 1 ➝ 3 more weeks

C) Metrics
- 30,000 organic impressions
- 1000 organic clicks
- 1000 pages live
The site was launched in July 2022, so their numbers are steadily increasing.

But, regardless, you cannot discount the fact that Ian was able to buildd a complex product affordably in just one month with NoCode.

💡 Lessons:

1) Learn NoCode by doing
2) When stuck, visit online NoCode communities
3) Learn the scope and limitations of the tools you use before you start building

4) It’s important to still maintain lean principles as well, even if NoCode is already a lean approach.
5) And, as and when you buildd the product, try to validate as much of it as possible at different stages before committing too much of your time.


Programming and SEO are both extremely powerful tools. But, when combined — SEO + Programming ⇒ Programmatic SEO — their impact becomes 10-fold!

Just look at products like Canva and Zapier. They get millions of visitors every month through their programmatic SEO efforts.

But, what if I told you that you could buildd a programmatic SEO website

  • on a $50 tech stack
  • in just ONE month
  • without writing a single line of code!

Well, today, let's learn how Ian Ruta built a full-fledged programmatic SEO website called Breweriesnearby using NoCode tools, Webflow and Airtable. And, how you can buildd one too!

The inspiration behind Breweriesnearby!

Breweriesnearby.com is a programmatic SEO website built by Canadian product manager, Ian Ruta.

Ian absolutely loves going to craft breweries. He occasionally came across other brewery fanatics complaining on the internet that there were no brewery directory apps that were up to date.

A couple of months ago, Ian had come across a breakdown of how another programmatic SEO website was created using the same framework that Nomadlist functions on. This website was generating anywhere from 50-100k organic visits per month.

Considering

  • his passion for breweries,
  • the outdated brewery apps problem
  • and, the strong SEO potential for targeting long-tail keywords

Ian felt that there was a great opportunity to create a crowdsourced web directory, that he could monetize by finding advertisers and paid brewery partners in this niche domain.

But, what is even programmatic SEO?

Well, programmatic SEO is basically a way to create 100s or even thousands of pages based on specific filters using an underlying dataset.

So, it essentially uses the ability of code to create scalable pages and applies basic SEO principles to drive traffic to these pages.

The ingredients of creating a programmatic SEO website are quite simple:

  1. The database — this essentially hosts all the information that is displayed on different pages of the website. The database, of course, consists of different categories and attributes assigned to each main item
  2. The content — the database is populated with relevant content. The content can be sourced from direct users, and other websites on the internet or can be manually added.
  3. Long tail keywords — the automatically generated pages are designed in such a way that each page targets a specific long tail keyword that has a sizeable search volume.
  4. Automated Pages — an underlying logic uses user-entered filters and different attributes in the database to create thousands of different automated pages.

Different parts of Breweriesnearby

A) Content - Brewery details

Breweriesnearby's website design is quite simple. All the different breweries are displayed as different cards with the following content:

  1. Brewery image
  2. Brewery name
  3. Location
  4. User rating
  5. Review
buildd a programmatic SEO website with nocode

When you click on the individual cards, the website takes you to a dedicated page for that brewery.

That page contains information like:

  1. About section
  2. Full address & contact details
  3. Website link
  4. and, crowdsourced info like
    • Experience — outdoor patio, serves food, live music
    • Services — delivery, flights, refills
    • Allowed — dog-friendly, kid-friendly, large groups
buildd a programmatic SEO website with nocode buildd a programmatic SEO website with nocode

This forms the content part of the website. The actual brewery names are picked from the internet. But, the specific details like experience, services, and reviews are crowd-sourced.

B) SEO-potential

It targets:

  1. broad keywords of the types — [brewery-name]. Example: "citizen brewery", "marda loop brewery", etc.
  2. Long-tail keywords of the type — [dog friendly breweries in x location], [breweries with live music in x location], and more. Example: "dog friendly breweries in Raleigh"

The overall SEO potential of brewery-related keywords is also quite good!

buildd a programmatic SEO website with nocode

With the content at hand and the target keywords ready, the website would automatically update the content and create unique pages based on the data received from users.

In order to achieve that, they needed a database that would sync two ways to the frontend and the backend logic that calculates certain parameters. For example, showing each brewery's average rating to the user.

All of these features together create the final product.

But, why go the NoCode way?

Now, when you think of programmatic SEO, you'd possibly think that the only way to create such a website would be through writing code.

But can you create this kind of website using NoCode? And, more importantly, why even use NoCode?

Problem

Building a project that essentially aims to get SEO traffic and win the favour of the Google gods is in no way straightforward. Even though the basics seem obvious, you never know what will work or what won't.

Every iteration is based on a number of assumptions which need to be validated. So, considering these points, Ian needed to experiment and try a lot of iterations, FAST!

The time and cost of hiring a team of developers to buildd version 1 made pursuing this project very risky for Ian. Especially, since the product needed different iterations and that would mean recurring developer costs.

Solution

NoCode allowed Ian to buildd an MVP and then version 1 at the fraction of the cost of hiring developers. This was incredibly valuable as it solved the main problem of cost and significantly de-risked the entire project.

bulb

Unless it solves a business bottleneck, DON'T buildd it.

On top of this, the entire project was built with less complexity. Ian was able to bring his ideas to life without needing to communicate with a team regarding user stories, mockups, workflows, etc.

He could easily iterate and experiment as soon as he received any user feedback!

The NoCode Tech Stack!

1) Webflow

Use case ⇒ The use of Webflow CMS to create automatically generated pages from the cms data and the templates.

The main reason for choosing Webflow over other tools is because of its built-in technical SEO capabilities and design flexibility. This essentially makes Webflow an ideal tool for creating a programmatic SEO website!

Each long-tail keyword has a dedicated CMS page template on Webflow that auto-generates and updates the page content as users provide data.

So, for example, every time a user marks a Vancouver-based brewery as "dog-friendly", the brewery automatically gets added to the page ⇒ breweriesnearby.com/dog-friendly-breweries/vancouver-bc.

Alternatives ⇒ Softr, Bubble

buildd a programmatic SEO website with nocode buildd a programmatic SEO website with nocode

2) Airtable

Use case ⇒ Airtable is used as the main database that stores all the content we discussed earlier. To get past some of Airtable's missing relational database capabilities, they use automation.

buildd a programmatic SEO website with nocode

3) Whalesync

Use case ⇒ Whalesync syncs data from Airtable to Webflow's CMS. This is a faster more user-friendly syncing alternative to Zapier.

Alternatives ⇒ Zapier, Make

buildd a programmatic SEO website with nocode buildd a programmatic SEO website with nocode

4) Jetboost

Use case ⇒ Jetboost is a NoCode Webflow tool that adds features like search, pagination, and filtering to your website. So, the main search and filtering feature is added using Jetboost.

buildd a programmatic SEO website with nocode buildd a programmatic SEO website with nocode

5) Octoparse

Use case ⇒ Octaparse helps scale the website's content. It's a free scraper tool that gathers a large set of data from brewery directories and structures them into spreadsheets that can be pasted into the Airtable database. So, all the new breweries are sourced using this tool.

buildd a programmatic SEO website with nocode

6) SEMRush

Use case ⇒ SEMRush is an SEO tool that helps identify low-competition, high-volume long-tail keywords surrounding breweries.

Alternatives ⇒ Ahrefs

buildd a programmatic SEO website with nocode

Shortcomings of using NoCode tools

The basic fact is that you cannot do everything with code.

  1. Tool limitations — There are a number of limitations to any tool you use. So, at times you need to Google hard to find workarounds for a limitation.

    For example, Airtable does not have the functionality for joining a table like an SQL database, which was a major requirement for this project.

    After trying many different ways, Ian discovered an obscure Airtable automation that allowed him to join tables.

  2. Exceeding plan limits — Breweriesnearby is a completely data-based site, and the goal is to create as many automatically generated pages as possible. So eventually, Ian will exceed his current Airtabel and Webflow plans.
    • When they exceed Airtable's 50K limit, Ian is planning to move to another NoCode database like Noloco or Xano that's specifically used for large datasets.
    • When they exceed Webflow's CMS item limit of 10K (since there are 15k+ breweries worldwide), he is planning to set up a proxy to create multiple Webflow projects under the same domain.

What was the final impact?

Now, it has been only a few months since the website went live in Jule of 2022. So, breweriesnearby is still in the early stages. But, you cannot discount the fact that Ian was able to buildd a complex product affordably in very little time!

  1. Cost — Webflow, Airtable, WhaleSync, Octoparse and SEMRush, cost around $50/month as opposed to the $3000 he was quoted.

    This does not include JetBoost, which costs another $29 because you can achieve similar functionality with a tool like F'innsweets library.

    Since Ian first built the tool, the cost of WhaleSync also increased from $29 to $49. So, his overall cost of running the website has slightly increased from when he built version 1!

  2. Time — The MVP was built in just a week with Webflow. And, version 1 took 3 more additional weeks with the database, first crowdsourced forms and data synced via Whalesync.
  3. Metrics — Today, Breweriesnearby has reached
    • 30,000 organic impressions,
    • 1000 organic clicks,
    • 1000 pages live

Now, getting SEO results is no easy task and all these metrics are steadily increasing. The product will obviously have to go through many trials and errors to finally get that sweet SEO traffic. But, the possibility of rapid solo experimentation and iteration possible with NoCode definitely helped!

NoCode Lessons!

Here are some major lessons from Ian's journey!

  1. First, you'll have to familiarize yourself with these NoCode tools. The best way to learn NoCode is through doing.
  2. There will be times when you get stuck, but there are many supportive online communities of no-coders that can guide you through any problem you encounter.
  3. It's also best to know the scope of the tool you are using before you start building your platform.
  4. It’s important to still maintain lean principles as well, even if NoCode is already a lean approach.
  5. And, as and when you buildd the product, try to validate as much of it as possible at different stages before committing too much of your time.
2
Comments
You'll love these articles too!
A marketer scales his startup to $50k MRR on a $500 NoCode stack!
A marketer scales his startup to $50k MRR on a $500 NoCode stack!
How Maggi won 60% market share and turned Indians into Maggiholics!?
How Maggi won 60% market share and turned Indians into Maggiholics!?
SEO explained to you like you are a 5-year old 🕵🏻
SEO explained to you like you are a 5-year old 🕵🏻

A marketer scales his startup to $50k MRR on a $500 NoCode stack!

Erman Küplü worked as a digital marketer for 15+ years created Analyzify, a data analytics tool for Shopify apps.

The platform essentially connects you with 3rd party tools and simplifies the process of data collecting, tracking and reporting — a valuable offering, especially for e-commerce store owners.

Version 1 of Analyzify was completely built on Ruby on Rails. But, Erman could only code a little in PHP & HTML.

He wanted to make many front-end, UI/UX improvements. But, for changing a simple feature or altering a line of code, he'd have to call up the developer.

That's when he came across a post about building Shopify apps using a NoCode tool called Bubble. With Bubble, we could easily edit their Shopify app through a simple graphic interface.

That was a game changer and they quickly went on improving the product and adding cool backend workflows!

Analyzify's NoCode Tech Stack

1. Bubble ⇒ manages all frontend and 90% of their workflow
2. Tallyforms ⇒ created customer-facing forms for different support requests
3. Contentful ⇒ is their headless CMS. Manages their in-app content, website content, FAQs and much more.

4. Coda ⇒ is their internal database. Most of their data is sent from Bubble to Coda
5. Zapier ⇒ integrates all their apps
6. Zendesk ⇒ they use Zendesk's support ticketing system to attend to customer support requests.

Well, Analyzify immediately took off!

1. Version 2 was built only in 5 months using Bubble with less than part-time effort.
2. In just 1.5 years, Analyzify went from ZERO to 1500+ clients. And they expanded to 3 more products.

3. They passed an MRR of $50K+ and their team grew to 20+ people!
4. As for their cost — their entire tech stack only costs them $500 per month.

But, eventually, Erman shifted from a NoCode to LowCode solution. Reasons:

a. To add custom server-side logic
b. To handle data from multiple apps in a single place

How Maggi won 60% market share and turned Indians into Maggiholics!?

Maggi's history spans 2 countries and dates back to ~150 years ago! The company was founded by Swiss entrepreneur Julius Maggi, who created a precooked soup and sauce brand, specifically targeting working women in the factories.

In 1947, this company was acquired by Nestle and they made it an instant noodle brand. Nestle brought Maggi to India in 1983. And, like their Swiss counterpart, they started targeting working women.

But, unfortunately, that strategy didn't work. You see, in the 1990s, women in India were fairly accustomed to their traditional diet of roti and sabzi (vegetable stew). So, changing their taste palette to a Southeast Asian, noodle-based diet, was near impossible.

Instead, they sold Maggi as an after-school, quick and easy snack for school-going kids. Maggi created the "2-min Maggi" brand, which means you can make Maggi in just 2 mins. So, mothers became the customers (who buy Maggi) and school-going children became their end consumers (who consume Maggi).

This positioning was the winning recipe that quickly:
a) carved out a whole new market for instant noodles in India
b) and, naturally won Maggi a 90% market share, which persisted for 25 years!

So, all their marketing was aligned towards this messaging. Here are some of their strategies:
A) Giving free hampers and taste samples 
B) Lower pricing to reach low-income households
C) On-point advertising
D) Double-down on distribution

But, it was not all easy sailing for Maggi. After having a spectacular 30-year run, in 2015, the company hit rock bottom when their product was tested to have more than permissible amounts of lead.

What followed was a full-fledged ban on all Maggi products. Which caused their market share to go from 80% to ZERO almost overnight!
We'll be covering their recovery journey and more in a follow-up article. So, stay tuned! 😉

SEO explained to you like you are a 5-year old 🕵🏻

SEO explained to you like you are a 5-year old:

1. The characters involved
👩‍🦰 Librarian = Google
📚 Books = All websites
🧔Person searching for a book = Your potential customer
I'll connect it all in the end!

2. Potential customer searches Google
This is equivalent to the 🧔person coming to the 👩‍🦰librarian and asking her to suggest the most relevant 📘book on say "Photosynthesis" ('cause I'm a nerd :P).

3. Google has to show search results
The 👩‍🦰librarian now has to decide which 📚Books to recommend from a sea of books.
So, she does this by setting certain parameters to rank the various books.
Which parameters?

4. Google ranks results using a first set of parameters
The first set of parameters helps the 👩‍🦰librarian understand if a book is relevant to the topic being searched. She'll evaluate
- Does "photosynthesis" appear in the title of the 📘book?
- Does it appear in the 📄chapter titles?
- How many times is it mentioned across the content 🔢?

5. Google shares final results using a final set of parameters The final set of parameters help the 👩‍🦰librarian gauge the reputation of a book.
- How many other 📚books cited this 📘book as reference?
- Did any of those 📚books also recommend this 📘book?
- How credible are those other 📚books?

6. Google finally shows the results
Attaching various weights to these parameters, the 👩‍🦰librarian shares a list of 10 📚books that the 🧔person should consider.
She has a longer list, but the person doesn't care about the books beyond the top 10!