Does programmatic SEO work? YES!
Does it work like it did a few years ago? NO! And it shouldn't. I believe
@Grozdjica_
is trying to convey the same.
But many people misunderstand the core concept, so let me clarify:
Programmatic SEO is simply a publishing method for templated
Is programmatic SEO really a new trend of the last few years?
Come on, folks. In 99% of cases, it's pure spam. I've been doing it for over 10+ years already.
The truth about programmatic SEO is that it doesn't work anymore since Google's Helpful Content Update (HCU) started
You can use Canva's Bulk Create feature to create images in bulk for your programmatic SEO projects.
1. Create a template
2. Select bulk create
3. Upload the CSV data
4. Map the relevant fields
5. Click Generate and you're done
Here's a quick video showing the same 👇
Get backlinks by pursuing unlinked mentions. Google this 👇
intext:"Untalked SEO" -untalkedseo.com -facebook.com -twitter.com
This Google search shows a list of webpages that mention your brand name.
If they haven't added a link to your site, reach out and request to link.
A friend asked how he can write the entire blog post using ChatGPT, so I came up with a prompt after a bit of experimentation.
See if you can get something from here for your use case, here's the PROMPT:
I am writing a blog post titled '{{blog topic}}'. I want you to write the
Improve your existing posts by using Google Search Console:
1/ Go to the PAGES tab and select the URL of the post which you want to improve
2/ Now, come to the QUERIES tab and note down the interesting sub-topics that you can include in that existing post
See screenshots... 👇
I've written a custom script that integrates OpenAI directly into Airtable, no 3rd party tools needed! Works on free Airtable account as well.
All you require is the OpenAI API, select your preferred model, and you're good to go.
Perfect for programmatic SEO!
Script below 👇
Do you see any similarities between the two infographics below?
The first one was created by me for UntalkedSEO more than 1.5 years ago, and the second one got published by SEMrush TODAY. 😅
I guess, any resemblance here is purely coincidental.
I started using Cloudflare "Automatic Platform Optimization for WordPress", and now 97% of URLs are passing the Core Web Vital scores.
Earlier it was around 60%.
It costs $5 per month, and I am using it for around a month.
I think, I will keep using it.
WordPress folks, if you're using Yoast or RankMath, make sure these settings look like the screenshots below...
If the settings are otherwise, attachment pages get unnecessarily indexed in Google.
Introducing Programmatic SEO OS!
A comprehensive operating system for your programmatic SEO projects that helps you master the craft & save 100+ hours.
It has:
— Frameworks
— Resources
— Templates
— Tools & more
Along with detailed written guides, there are videos as well. 🎥
So, this is my attempt to make a video on using Google Sheets + 11ty for programmatic SEO!
It's 40 mins long! 🤯
You'll need some basic technical knowledge to understand this, though, as I could have been more thorough in the video.
This pSEO KW Generator will help you combine the head terms with the modifiers.
1. Copy all the modifiers in the modifier column
2. Add the head terms and adjust the formula if required
3. Copy all the keywords from the Final Keywords column
A video in the next tweet 👇
I am thinking of doing a detailed case study on a failed programmatic SEO project. It will give you an idea about how NOT to do pSEO.
Anyone interested?
2022 Aug: 2000+ clicks/day
2023 Jun: 9000+ clicks/day
I started this blog in 2018 and published ~150 manually written blog posts till Aug 2022. After Aug 2022, I started using the techniques of programmatic SEO on the site, and you see the results.
For some topics, I have taken
If you're linking your Twitter profile on your website, use this link:
https://twitter
.com/intent/user?screen_name=[YOUR_TWITTER_USERNAME]
If clicked, it shows a Follow popup which you can see in the screenshot below.
🎉 Give me a niche and I will find interesting programmatic SEO ideas in the niche.
Here's a short video showing the research that I have done for the sample tennis-focused website.
Links below 👇
2022 Aug: 2,000+ clicks/day
2023 Jun: 9,000+ clicks/day
2023 Aug: 19,000+ clicks/day
2023 Sep: 29,000+ clicks/day
I'm consistently adding new posts and also updating outdated ones. No compromise with the quality.
And here's the graph of the last 16 months! 👇
2022 Aug: 2,000+ clicks/day
2023 Jun: 9,000+ clicks/day
2023 Aug: 19,000+ clicks/day
As of now, the site has ~2200 pages generated by the techniques of programmatic SEO.
I created a list of 80+ sites that have been hit by Google's manual penalties recently. 🛑
Earlier, these sites were getting at least over 5,000 monthly traffic (as per SEMrush), but now there are ZERO indexed pages in Google. 👀
You can access the list for free below 👇
Site age → 4–5 years
Before Aug 2022 → 150 posts
Now → 500 posts
All the new posts are programmatically created, but the data has been prepared manually. Yes, I manually filled the Google Sheets with 60+ columns and 500+ rows.
Been using WordPress for almost a decade, but haven't ever used it to create a listing site.
But now, I am exploring and learning about Custom Post Types and Custom Fields; and how they can be used to create good-looking programmatic pages.
As of now, I'm just consuming lots of
The more I'm experimenting with programmatic SEO, the more I'm learning about outstanding tips-tricks about Google Sheets.
Almost every week, I get blown away by something new that Google Sheets Apps Script can do. 🤯
Are you interested in learning about these?
2022 Aug: 2,000+ clicks/day
2023 Jun: 9,000+ clicks/day
2023 Aug: 19,000+ clicks/day
As of now, the site has ~2200 pages generated by the techniques of programmatic SEO.
2022 Aug: 2000+ clicks/day
2023 Jun: 9000+ clicks/day
I started this blog in 2018 and published ~150 manually written blog posts till Aug 2022. After Aug 2022, I started using the techniques of programmatic SEO on the site, and you see the results.
For some topics, I have taken
Programmatic SEO folks, I am working on 2 things as of now:
#1
– pSEO Examples List
I am making a list of cool pSEO examples with important data points for each. Currently, 140+ examples are on the list and will be adding more as I keep finding out.
👇
Programmatic SEO is a broad term—different ways and methods to do it.
I have tried my best to make this simple pSEO checklist by generalizing all those different methods.
Does this look useful to you in any way?
Had to take screenshots of 100s of sites for a programmatic SEO project, so I used ScreenshotOne's API to do that.
Really cool tool!
And the best thing? I got everything working right inside Google Sheets. Within minutes, I had all the screenshots.
See how 👇
🎉 The programmatic SEO tools list is now ready!
Currently, the database has over 80 tools, and I've put a small price of $5 to access it. I will keep adding more tools to the list as I discover new ones.
Each tool has 4-5 data points & everything is manually curated.
Link 👇
Introducing "Programmatic SEO OS"!
📅 Launching on Jan 5, 2023.
This is the current draft, but will be adding more info and categorizing it better.
Anything specific that you want me to cover?
📹 Recorded a 1-hour video for the programmatic SEO OS.
And will be recording 4-5 more videos showing everything from scratch for WordPress as well as for other platforms.
Everything is coming out to be good so far.
Been using WordPress·com's hosting for a site that gets 400k+ monthly pageviews for more than a month now.
One word, flawless!
I'm on the Business plan, which costs just ~$7-8/month. And they offer unlimited bandwidth for all plans.
And the best thing is their 24x7 support.
I did an experiment:
Can WordPress handle 50,000 pages?
I installed WordPress on a $6/month DigitalOcean server and tried publishing 50,000 pages by using the techniques of pSEO (WP All Import + Google Sheets).
Results below 👇
Anthropic launches Claude for Sheets that you can use to connect the Claude API to Google Sheets. 🎉
Earlier, I had created a Google Sheets script that let people do the same; but you don't need something like that anymore.
For the last few months, I have been using Google Trends to find trending topics and writing about them.
And it has helped me a ton! 🔥
A few posts even appeared in Google Discover and brought tens of thousands of additional traffic.
I'm sure a lot of you're already using
SEOs, see what manual action looks like 👇
Remember the site that everyone was talking about a few days ago?
It scraped hundreds of thousands of Google PAA questions with answers.
Well, now it's completely removed from Google.
📌 site:lisbdnet .com → 0 results
Remember the simple OpenAI Pricing Calculator that I created a few weeks ago?
It recently got to 22 clicks/day from Google. 😅
These kinds of quick projects are always fun to do.
After spending 3 full days, I've finally figured out to pull data from Airtable & publish them as 100s of pages by using the 11ty static site generator.
Great for programmatic SEO!
Hopefully, will be recording a detailed tutorial in a week or two.
Here's an infographic that I created last year to illustrate what programmatic SEO is!
Programmatic SEO is NOT a "type" of SEO, it's just a publishing method. To do good, you still need to properly understand the basics of SEO.
Into programmatic SEO?
This pSEO research for the tennis niche will give you ideas for doing the research in your niche.
You can get it from the link in the below tweet 👇
Interlinking 2 different pSEO Clusters right inside Google Sheets:
• Use the IMPORTRANGE function to import a range of cells from another spreadsheet
• Use VLOOKUP to match imported terms with terms inside the current sheet
If it matches, create a hyperlink!
See example 👇
Open any one of the pages, and it will seem like a manually written blog post. But all the pages listed here are created using Programmatic SEO.
I am making a detailed video showing the complete setup (the database and the page template).
More details 👇
In Aug, I published 60 new pages on an existing blog; by using the techniques of programmatic SEO.
See the results for yourself (the screenshot shows data of only the new pSEO pages, not the whole site).
This is how I did it 👇
IDEA: AI-powered infographics generator.
I just provide all the information like text, colors, design, etc. and it shows me a few variations of infographics to choose from.
I'd pay for that!
I just moved away all non-programmatic SEO content from & will be only putting content related to pSEO!
Still setting up the website.
A lot more pSEO content incoming! And hopefully, I will be covering all the less-talked topics of pSEO, soon. 🤞
Google Search Console is experimenting with Content Ideas! Based on the topics you write about, it provides you related topics in different categories. 🤯
It will be interesting to see.
1000s of people search for "{place} mortgage calculator" every month. And NerdWallet is killing it with programmatic pages targeting those keywords.
Here's an example:
@iannuttall
I've written a guide on Programmatic SEO (), but I'd really like to know what's the best way to do it — code or nocode.
And what are the best platforms/tech stacks for it.
I just used the new Canvas feature in Obsidian for creating a diagram for a blog post that I am writing.
And I am never using any other software for this again.
😍
The all-new and updated curriculum for Programmatic SEO OS — added a few new sections and reorganized the existing ones.
The most interesting new addition is the pSEO Tweet Wall. 🐦
Anything that I'm missing?
Recorded another video showing how you can use AI to prepare the data for your programmatic SEO project.
I'll recommend setting up the video speed at 1.25x, as it's a bit slow.
Hope you get something meaningful from here:
Was using this 10,000+ pSEO keyword ideas database for the last 2 months for my projects.
Now, making it available for you 🫵
It had only 4 data points then, but now, I have added 12 more data points for each topic.
KW ideas are from 1,000+ different niches.
Link below 👇
How to use WordPress Gutenberg blocks inside WP All Import for programmatic SEO:
➭ Create a new page and design it however you want by using Gutenberg blocks
➭ After designing, open the Code editor to see the code version of the design (as shown below)
Continued... 👇
Yesterday, I secretly launched a simple script to connect Google Sheets with OpenAI API on ProductHunt, it's at
#4
.
🔗
Someone asked if it works for multiple columns of prompts, and the answer is YES. Just specify multiple columns separated by commas.
I'm starting a new blog on SEO from zero, it's called
@UntalkedSEO
.
Will be sharing the whole process, progress, and learnings here on Twitter (don't forget to follow me).
Aiming to hit 10,000 monthly traffic by the end of Dec 2022.
Possible? Let's see!
Connect Google Sheets with OpenAI API 🎉
Most existing scripts like this work only when your Google Sheets is open, but this one keeps working in the background.
Generating output for 5,000+ rows? Just set everything up, and let it run.
Open after a few days and it's done! 🔥
Even if you're not getting any views on your blog posts, keep publishing. 📉
One day, those posts would be the reason for something bigger and greater. 📈
Programmatically generated pages are of low quality as compared to manually written blog posts.
So, when selecting keywords for programmatic SEO, make sure you're choosing long-tail keywords with LOW competition.
You can modify keywords to lower competition.
For example👇
Most blogs don't need a fancy design!
My new WordPress setup fully loads in 0.3 seconds!
It uses the WordPress Twenty Twenty-Three theme, is hosted on the DigitalOcean LiteSpeed server, and plain text design.
And for the niche, I think, the site is perfect!
What say?
So the Programmatic SEO Examples list I was talking about a few weeks ago is finally done!!
It's organized in Notion, with ~10 important data points for each. We'll keep adding new examples as we discover, and also keep updating existing ones.
Below is a sneak peek 👀
2022 Aug: 2000+ clicks/day
2023 Jun: 9000+ clicks/day
I started this blog in 2018 and published ~150 manually written blog posts till Aug 2022. After Aug 2022, I started using the techniques of programmatic SEO on the site, and you see the results.
For some topics, I have taken
It's great to see
@sengineland
putting together a guide on programmatic SEO!
People are still very confused about the term, we need more and more content around programmatic SEO.
Started working on this new programmatic SEO project back in Oct 2022. On it, programmatically created around 700 high-quality pages, they all got indexed but didn't see much traction at the time.
Made a target of acquiring only 2 backlinks every month through manual outreach.
=LOWER(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(TRIM(A2),"[^a-zA-Z0-9]+","-"), "-{2,}", "-"), "^-+|-+$", ""))
The best formula to easily convert texts to slugs in Google Sheets. It can be extremely useful for pSEO.
Best thing? It takes care of special characters as well.
Clicking on Anchor Links on a WordPress site was directly jumping to that area.
And I didn't know until today that adding this simple CSS would solve the sudden jump issue.
Cool! 🥳
The new ChatGPT will be excellent for pSEO and other data analysis tasks.
As an experiment, I uploaded an 89 MB CSV file to ChatGPT with 150k+ rows and asked to analyze and remove all duplicates.
And GPT-4 was able to do that within a minute. 🤯
This is what the writing process looks like for me...
- A Google Docs document for writing
- A Notion doc with already researched information
- A Brave browser window with several opened tabs
It's a screenshot of both my screens.
What does your writing look like?
2 days ago, we sent the 2nd edition of the UntalkedSEO Newsletter, decoding another successful programmatic SEO strategy.
It'll now be sent biweekly, and below is the last one that we sent 👇
Make sure you're on the list to not miss the next one!
For this pSEO project, no content is being duplicated on all the generated pages. I am preparing everything directly inside Google Sheets.
Using GPT-4 for writing introductions and descriptions.
Probably the simplest page template I had to create 👇
Used Google's new Gemini Pro API, and it's almost identical to the OpenAI's API that I was earlier using inside Google Sheets.
So wrote a new Google Sheets Apps Script that allows you to connect the Gemini Pro API with your Sheets and generate content in bulk.
Link below 👇
One of my pSEO sites is getting 1200–1400 clicks a day from translated results.
The site is originally in English, but Google itself translates the content into 10+ different languages, and you see the results below 👇
Had to take screenshots of 10,000+ URLs, and all screenshot APIs seemed costly for those many pages.
So spent 5–6 hours building a custom solution that does this for free (just the minor server cost). And it can be integrated into Google Sheets as well.
More details below 👇
Y'all searching for the best programmatic SEO solution, while “Wix Content Manager” is hiding in plain sight.
Wix allows you to upload your CSV file with thousands of rows of data and then create multiple pages based on a template.
Works like a charm and is affordable too! 😲
I think I have figured out a way to programmatically generate 1000s of pages and publish them using any static site generator.
Still experimenting with it.
Just checked that NONE of the 170 programmatic SEO example sites (a list that I maintain) have been hit by a manual penalty.
They all still have all their pages indexed... so no need to panic and worry.
Will also soon check if traffic has fallen significantly for any site.
I have an education blog with the following stats:
— 72k pageviews/mo
— 90% views from organic search
— 90% visitors from India
— Most visitors about to get into high schools
It's running for around 4 years, unmonetized.
What options do I have to monetize, besides ads?
Okay, I am making the "Auto URL Screenshots" thing FREE. 🎉
By the way, it takes a list of URLs in a CSV file format, screenshots of all URLs, uploads them to Cloudinary and returns a CSV file with all the screenshot URLs.
You can access it from the below link 👇
So this is how the screenshot thing (have named it SnapCloud) works 🎉
Took around 4.5 minutes to take screenshots of ~50 URLs when the batch size was set to 5.
It's now ready to be used, and you can learn more about it from below 👇
Haven't done it since the launch, so here it is:
🎉 Offering a massive 60% discount on the Programmatic SEO OS course.
So if you want to master the art of pSEO and still haven't got the course, now is the chance.
Here's the complete curriculum 👇