Connect with us

SEO

Programmatic SEO, Explained for Beginners

Published

on

Programmatic SEO, Explained for Beginners

Programmatic SEO refers to the creation of keyword-targeted pages in an automatic (or near automatic) way.

It provides a way for companies to create thousands of website pages targeted at thousands of keywords—without having to design, write, and publish pages manually. Companies like Zapier, Zillow, and G2 use programmatic SEO to generate millions of pageviews each year.

Programmatic pages are usually created from data in a database, like product prices, weather, or location information. To create programmatic content at a large scale, it helps to be a web developer, but there are less technical ways to learn some of the core principles.

We’ll show you how.

Advertisement

Examples of programmatic SEO

Programmatic SEO is a new term for an old idea. If you’ve ever visited Amazon, Yelp, or TripAdvisor, you’ve visited a programmatic page. In fact, if a company offers thousands of products, or provides services in thousands of locations, a programmatic approach to content creation is virtually necessary.

But you don’t have to be an ecommerce giant to find programmatic content useful.

Nomadlist’s location pages

URL: https://nomadlist.com/chiang-mai

Estimated pages: 25,873

Estimated monthly organic traffic: 41,200

Advertisement

Nomadlist helps aspiring digital nomads work out which countries and cities to visit. The website has thousands of programmatic pages sharing the same core information—like internet speeds, average temperatures, and common languages—for towns and cities across the world. 

Zapier’s app directory

URL: https://zapier.com/apps 

Estimated pages: 800,632

Estimated monthly organic traffic: 306,000

Zapier is a workflow automation tool that connects different software products together (allowing you to automatically save new emails into a Google Sheet, for example). The company has programmatically created landing pages for each of the thousands of products they integrate with, showing the tools they connect to, and the workflows that can be triggered.

zapier app directory pagezapier app directory page

Webflow’s website templates

URL: https://webflow.com/made-in-webflow/website  

Estimated pages: 31,516

Advertisement

Estimated monthly organic traffic: 27,600

Webflow is a no-code website builder. They’ve used programmatic SEO to build unique landing pages for thousands of website templates created by their users. Their strategy generates a good amount of traffic, but also makes it easy for visitors to clone the templates and become a Webflow user. 

webflow websitewebflow website

Wise’s currency conversion pages

URL: https://wise.com/us/currency-converter/ 

Estimated pages: 14,888

Estimated monthly organic traffic: 4,667,719

Wise offer international banking services, including currency conversion. They generate millions of monthly pageviews by programmatically creating landing pages to help users convert between different currencies—from US Dollars to Indian Rupees, from Indian Rupees to Mexican Pesos, and so on. Virtually every currency pair has its own unique page.

Wise’s currency conversion pageWise’s currency conversion page

Programmatic… or spam?

Advertisement

Before you get too excited about the prospect of publishing thousands of pages, it’s worth considering the words of Google’s John Mueller: “Programmatic SEO is often a fancy banner for spam.

Any company that publishes a huge number of very similar pages runs the risk of creating thin content: content that offers little to no value to the end user. Like any other page, programmatic content needs to satisfy user intent (and not violate Google’s spam policies).

If you’re wondering what sets “good” programmatic content apart from bad, the answer often boils down to data and relevancy.

Sites like Wise and Zapier can generate millions of pageviews from programmatic content largely because they offer good, product-relevant data in a format that’s useful to the reader:

  • Wise’s currency conversion pages also include historical conversion rate data, rate comparisons with other banks, and the ability to actually send money using Wise.
  • Zapier’s app pages are more than basic lists of tools: they show dozens of useful workflows and allow the reader to actually set them up for themselves.

Today, it’s technically possible to generate huge numbers of website pages with little more than a ChatGPT subscription, a Google Sheet, and a simple script (which ChatGPT can even help you to write). But just because you can, theoretically, put content creation on autopilot, it doesn’t mean that good results will follow.

This type of thin content isn’t likely to generate meaningful traffic for a sustained period of time. Relevant, unique data is usually what makes the difference between helpful content and spam.

Advertisement

How to get started with programmatic SEO

True programmatic content creation can get very complicated, very quickly. Thousands (even millions) of data points need to be sourced, synced, and updated. Thousands of URLs need to be indexed, and thousands of internal links need to be built. To create something like Wise or Zapier have built, you need developers.

But not every programmatic project has to be quite so complicated. You can attract plenty of traffic with just a few hundred or a few thousand pages.

Here’s a simple no-code process to get started with programmatic SEO. It will help you identify great keywords for programmatic SEO, automatically build prototype pages, and even communicate more effectively with the developers who’ll bring your vision to life.

1. Find keywords that scale

Programmatic content works by targeting thousands of similar keywords with one basic page template. So to get started, you need to find relevant keywords that have hundreds (or even thousands) of similar variations.

Advertisement

Start by entering your seed keywords into Ahrefs’ Keywords Explorer. For a personal finance website, you might use terms like debt management, cost of living and expense tracking. Then expand your list of possible keywords by selecting the Matching Terms report:

Ahrefs’ Keywords ExplorerAhrefs’ Keywords Explorer

If you’re not confident in your ability to rank for high-competition keywords, it can be useful to filter your results by setting the Keyword Difficulty to <20 and the DR of top-ranking sites to <30. This will show keywords that most websites could rank for—even those without lots of backlinks:

high-competition keyword filterhigh-competition keyword filter

Browse through the keyword list and look for patterns in the keywords. In this case, many of the “cost of living” keywords reference a particular location:

keyword list on Ahrefskeyword list on Ahrefs

To home in on just these types of keywords, we can use the Include filter to show all keywords that include “cost of living in”:

keywords that include “cost of living in”:keywords that include “cost of living in”:

Looking at this example, we’ve found 1,143 keywords with a combined monthly search volume of 122,000. Successfully ranking for even a few dozen of these terms could generate substantial traffic for your website.

These keywords are perfect for programmatic SEO. The type of content that would best help someone searching for “cost of living in arizona” is likely to be very similar to the type of content that would help someone searching for “cost of living in california.”

The data on each page would need to be different, but the structure and main ideas would be the same.

2. Check search intent

Next, you need to work out what type of content would help people searching for these keywords. If you look at the SERP for a few of your “cost of living” keywords, many of the search results contain the same types of information:

  • A cost of living score on a 0–100 scale
  • Comparisons with nearby states
  • Typical costs for major expenses like property, food, and healthcare
Article about the cost of living in South CarolinaArticle about the cost of living in South Carolina

These data points give us an idea of the type of information required to meet the searcher’s intent. Searchers want a way to quickly compare cost of living between states, and beyond that, to see how those costs break out across core categories.

For your programmatic content, you should probably include these data points on every page.

3. Find relevant data

Next, you need to source that data. There are three types of data you have at our disposal:

Advertisement
  • Proprietary data: original data that is unique to you, your company, or your product. This is the most desirable data type: you can provide information no one else has.
  • Public data: publicly available data that is licensed for commercial use. This is usually the easiest data to find, but that means that other companies may be using it in a similar context.
  • Scraped data: data extracted from websites using web scraping tools. This can be useful but may introduce issues with copyright.

Looking at the search results for these keywords, many of the top-ranking articles contain data from the same public data source: the Cost of Living Index published by the Council for Community and Economic Research. It’s likely that you’ll be able to use this same data in your programmatic content.

article published by the Council for Community and Economic Researcharticle published by the Council for Community and Economic Research

If you want to go a step further, you could consider adding new data that other top-ranking articles don’t have. Sites like Kaggle provide data sets for use in training AI and machine learning models, but they can also provide extra data points for your content.

Run a quick search for “cost of living” on Kaggle, and several useful data sets appear. You can order by age to find new data that other companies are unlikely to be using:

search results on Kagglesearch results on Kaggle

Armed with your data sources, you can combine all of your desired data points together in a single place.

4. Build your pages

Next, you need to map your data sources to relevant parts of your page. At this point, it would be helpful to enlist a web developer—but we’ll show a simplified example using Google Sheets as a basic database.

In the first tab of the spreadsheet, we have our keyword data, which you can use to build page titles and URLs. In the next tab, we have our cost of living data.

Ahrefs Programmatic Content ExampleAhrefs Programmatic Content Example

Based on our intent analysis, we want each page to include three “buckets” of information:

  • Cost of living score
  • Comparison with other US states
  • Breakdown of costs across key categories

So in the third tab, we’ve created a formula that pulls relevant data from our different sheets into a simple page template.

page formulapage formula

Sidenote.

If you aren’t very familiar with Google Sheets formulas, in the fourth tab we’ve included a ChatGPT prompt that can do this for you.

This body copy correctly references data from the cost of living sheet, showing the cost of living score, ranking it relative to the other 49 states, determining whether a state is cheap, mid-priced, or expensive, and sharing cost indices across six major categories.

If you add additional states to the list by dragging down the formula in column A, new URLs, page titles, and body copy are automatically generated. By combining your data sources with a single page template, you can create 50 different pages with the drag of a mouse.

Advertisement
List of statesList of states

Crucially, the content we’ve generated here is the definition of “thin”, containing lots of duplicated text and non-original data. But if you were to add unique data, create helpful data visualizations, and provide unique written context, then these pages might stand a fighting chance at helping readers and ranking for their target keywords.

5. Publish content to your website

The final step is to publish your newly created content to your website. Depending on the content management system you use, there are a few no-code tools that can help with this process:

  • If you already use WordPress for your website, try WP All Import.
  • If you use Webflow CMS, set up a Zapier integration to connect to your spreadsheet.
  • If you want to build a website straight from your spreadsheet, try Softr.

Once configured, each of these tools will automatically publish a new website page whenever a new row of data is added to your spreadsheet.

Final thoughts

Programmatic SEO is not money for nothing. Managing data and pages at large scales is deceptively complicated. In order for your content to rank—and actually help people—you’ll need relevant, interesting data to share. (And it helps to be a web developer.)

But the combination of “scalable” keywords and great data is a force to be reckoned with. With a little know-how, it’s possible to generate thousands (even millions) of pageviews from a single page template. Pretty cool.



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

SEO

Big Update To Google’s Ranking Drop Documentation

Published

on

By

Google updates documentation for diagnosing ranking drops

Google updated their guidance with five changes on how to debug ranking drops. The new version contains over 400 more words that address small and large ranking drops. There’s room to quibble about some of the changes but overall the revised version is a step up from what it replaced.

Change# 1: Downplays Fixing Traffic Drops

The opening sentence was changed so that it offers less hope for bouncing back from an algorithmic traffic drop. Google also joined two sentences into one sentence in the revised version of the documentation.

The documentation previously said that most traffic drops can be reversed and that identifying the reasons for a drop aren’t straightforward. The part about most of them can be reversed was completely removed.

Here is the original two sentences:

“A drop in organic Search traffic can happen for several reasons, and most of them can be reversed. It may not be straightforward to understand what exactly happened to your site”

Now there’s no hope offered for “most of them can be reversed” and more emphasis on understanding what happened is not straightforward.

Advertisement

This is the new guidance

“A drop in organic Search traffic can happen for several reasons, and it may not be straightforward to understand what exactly happened to your site.”

Change #2 Security Or Spam Issues

Google updated the traffic graph illustrations so that they precisely align with the causes for each kind of traffic decline.

The previous version of the graph was labeled:

“Site-level technical issue (Manual Action, strong algorithmic changes)”

The problem with the previous label is that manual actions and strong algorithmic changes are not technical issues and the new version fixes that issue.

The updated version now reads:

“Large drop from an algorithmic update, site-wide security or spam issue”

Change #3 Technical Issues

There’s one more change to a graph label, also to make it more accurate.

Advertisement

This is how the previous graph was labeled:

“Page-level technical issue (algorithmic changes, market disruption)”

The updated graph is now labeled:

“Technical issue across your site, changing interests”

Now the graph and label are more specific as a sitewide change and “changing interests” is more general and covers a wider range of changes than market disruption. Changing interests includes market disruption (where a new product makes a previous one obsolete or less desirable) but it also includes products that go out of style or loses their trendiness.

Graph titled

Change #4 Google Adds New Guidance For Algorithmic Changes

The biggest change by far is their brand new section for algorithmic changes which replaces two smaller sections, one about policy violations and manual actions and a second one about algorithm changes.

The old version of this one section had 108 words. The updated version contains 443 words.

A section that’s particularly helpful is where the guidance splits algorithmic update damage into two categories.

Advertisement

Two New Categories:

  • Small drop in position? For example, dropping from position 2 to 4.
  • Large drop in position? For example, dropping from position 4 to 29.

The two new categories are perfect and align with what I’ve seen in the search results for sites that have lost rankings. The reasons for dropping up and down within the top ten are different from the reasons why a site drops completely out of the top ten.

I don’t agree with the guidance for large drops. They recommend reviewing your site for large drops, which is good advice for some sites that have lost rankings. But in other cases there’s nothing wrong with the site and this is where less experienced SEOs tend to be unable to fix the problems because there’s nothing wrong with the site. Recommendations for improving EEAT, adding author bios or filing link disavows do not solve what’s going on because there’s nothing wrong with the site. The problem is something else in some of the cases.

Here is the new guidance for debugging search position drops:

Algorithmic update
Google is always improving how it assesses content and updating its search ranking and serving algorithms accordingly; core updates and other smaller updates may change how some pages perform in Google Search results. We post about notable improvements to our systems on our list of ranking updates page; check it to see if there’s anything that’s applicable to your site.

If you suspect a drop in traffic is due to an algorithmic update, it’s important to understand that there might not be anything fundamentally wrong with your content. To determine whether you need to make a change, review your top pages in Search Console and assess how they were ranking:

Small drop in position? For example, dropping from position 2 to 4.
Large drop in position? For example, dropping from position 4 to 29.

Keep in mind that positions aren’t static or fixed in place. Google’s search results are dynamic in nature because the open web itself is constantly changing with new and updated content. This constant change can cause both gains and drops in organic Search traffic.

Small drop in position
A small drop in position is when there’s a small shift in position in the top results (for example, dropping from position 2 to 4 for a search query). In Search Console, you might see a noticeable drop in traffic without a big change in impressions.

Advertisement

Small fluctuations in position can happen at any time (including moving back up in position, without you needing to do anything). In fact, we recommend avoiding making radical changes if your page is already performing well.

Large drop in position
A large drop in position is when you see a notable drop out of the top results for a wide range of terms (for example, dropping from the top 10 results to position 29).

In cases like this, self-assess your whole website overall (not just individual pages) to make sure it’s helpful, reliable and people-first. If you’ve made changes to your site, it may take time to see an effect: some changes can take effect in a few days, while others could take several months. For example, it may take months before our systems determine that a site is now producing helpful content in the long term. In general, you’ll likely want to wait a few weeks to analyze your site in Search Console again to see if your efforts had a beneficial effect on ranking position.

Keep in mind that there’s no guarantee that changes you make to your website will result in noticeable impact in search results. If there’s more deserving content, it will continue to rank well with our systems.”

Change #5 Trivial Changes

The rest of the changes are relatively trivial but nonetheless makes the documentation more precise.

For example, one of the headings was changed from this:

Advertisement

You recently moved your site

To this new heading:

Site moves and migrations

Google’s Updated Ranking Drops Documentation

Google’s updated documentation is a well thought out but I think that the recommendations for large algorithmic drops are helpful for some cases and not helpful for other cases. I have 25 years of SEO experience and have experienced every single Google algorithm update. There are certain updates where the problem is not solved by trying to fix things and Google’s guidance used to be that sometimes there’s nothing to fix. The documentation is better but in my opinion it can be improved even further.

Read the new documentation here:

Debugging drops in Google Search traffic

Review the previous documentation:

Internet Archive Wayback Machine: Debugging drops in Google Search traffic

Advertisement

Featured Image by Shutterstock/Tomacco

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

SEO

Google March 2024 Core Update Officially Completed A Week Ago

Published

on

By

Graphic depicting the Google logo with colorful segments on a blue circuit board background, accompanied by the text "Google March 2024 Core Update.

Google has officially completed its March 2024 Core Update, ending over a month of ranking volatility across the web.

However, Google didn’t confirm the rollout’s conclusion on its data anomaly page until April 26—a whole week after the update was completed on April 19.

Many in the SEO community had been speculating for days about whether the turbulent update had wrapped up.

The delayed transparency exemplifies Google’s communication issues with publishers and the need for clarity during core updates

Google March 2024 Core Update Timeline & Status

First announced on March 5, the core algorithm update is complete as of April 19. It took 45 days to complete.

Advertisement

Unlike more routine core refreshes, Google warned this one was more complex.

Google’s documentation reads:

“As this is a complex update, the rollout may take up to a month. It’s likely there will be more fluctuations in rankings than with a regular core update, as different systems get fully updated and reinforce each other.”

The aftershocks were tangible, with some websites reporting losses of over 60% of their organic search traffic, according to data from industry observers.

The ripple effects also led to the deindexing of hundreds of sites that were allegedly violating Google’s guidelines.

Addressing Manipulation Attempts

In its official guidance, Google highlighted the criteria it looks for when targeting link spam and manipulation attempts:

  • Creating “low-value content” purely to garner manipulative links and inflate rankings.
  • Links intended to boost sites’ rankings artificially, including manipulative outgoing links.
  • The “repurposing” of expired domains with radically different content to game search visibility.

The updated guidelines warn:

“Any links that are intended to manipulate rankings in Google Search results may be considered link spam. This includes any behavior that manipulates links to your site or outgoing links from your site.”

John Mueller, a Search Advocate at Google, responded to the turbulence by advising publishers not to make rash changes while the core update was ongoing.

Advertisement

However, he suggested sites could proactively fix issues like unnatural paid links.

Mueller stated on Reddit:

“If you have noticed things that are worth improving on your site, I’d go ahead and get things done. The idea is not to make changes just for search engines, right? Your users will be happy if you can make things better even if search engines haven’t updated their view of your site yet.”

Emphasizing Quality Over Links

The core update made notable changes to how Google ranks websites.

Most significantly, Google reduced the importance of links in determining a website’s ranking.

In contrast to the description of links as “an important factor in determining relevancy,” Google’s updated spam policies stripped away the “important” designation, simply calling links “a factor.”

This change aligns with Google’s Gary Illyes’ statements that links aren’t among the top three most influential ranking signals.

Advertisement

Instead, Google is giving more weight to quality, credibility, and substantive content.

Consequently, long-running campaigns favoring low-quality link acquisition and keyword optimizations have been demoted.

With the update complete, SEOs and publishers are left to audit their strategies and websites to ensure alignment with Google’s new perspective on ranking.

Core Update Feedback

Google has opened a ranking feedback form related to this core update.

You can use this form until May 31 to provide feedback to Google’s Search team about any issues noticed after the core update.

While the feedback provided won’t be used to make changes for specific queries or websites, Google says it may help inform general improvements to its search ranking systems for future updates.

Advertisement

Google also updated its help documentation on “Debugging drops in Google Search traffic” to help people understand ranking changes after a core update.


Featured Image: Rohit-Tripathi/Shutterstock

FAQ

After the update, what steps should websites take to align with Google’s new ranking criteria?

After Google’s March 2024 Core Update, websites should:

  • Improve the quality, trustworthiness, and depth of their website content.
  • Stop heavily focusing on getting as many links as possible and prioritize relevant, high-quality links instead.
  • Fix any shady or spam-like SEO tactics on their sites.
  • Carefully review their SEO strategies to ensure they follow Google’s new guidelines.

Source link

Advertisement
Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

SEO

Google Declares It The “Gemini Era” As Revenue Grows 15%

Published

on

By

A person holding a smartphone displaying the Google Gemini Era logo, with a blurred background of stock market charts.

Alphabet Inc., Google’s parent company, announced its first quarter 2024 financial results today.

While Google reported double-digit growth in key revenue areas, the focus was on its AI developments, dubbed the “Gemini era” by CEO Sundar Pichai.

The Numbers: 15% Revenue Growth, Operating Margins Expand

Alphabet reported Q1 revenues of $80.5 billion, a 15% increase year-over-year, exceeding Wall Street’s projections.

Net income was $23.7 billion, with diluted earnings per share of $1.89. Operating margins expanded to 32%, up from 25% in the prior year.

Ruth Porat, Alphabet’s President and CFO, stated:

Advertisement

“Our strong financial results reflect revenue strength across the company and ongoing efforts to durably reengineer our cost base.”

Google’s core advertising units, such as Search and YouTube, drove growth. Google advertising revenues hit $61.7 billion for the quarter.

The Cloud division also maintained momentum, with revenues of $9.6 billion, up 28% year-over-year.

Pichai highlighted that YouTube and Cloud are expected to exit 2024 at a combined $100 billion annual revenue run rate.

Generative AI Integration in Search

Google experimented with AI-powered features in Search Labs before recently introducing AI overviews into the main search results page.

Regarding the gradual rollout, Pichai states:

“We are being measured in how we do this, focusing on areas where gen AI can improve the Search experience, while also prioritizing traffic to websites and merchants.”

Pichai reports that Google’s generative AI features have answered over a billion queries already:

Advertisement

“We’ve already served billions of queries with our generative AI features. It’s enabling people to access new information, to ask questions in new ways, and to ask more complex questions.”

Google reports increased Search usage and user satisfaction among those interacting with the new AI overview results.

The company also highlighted its “Circle to Search” feature on Android, which allows users to circle objects on their screen or in videos to get instant AI-powered answers via Google Lens.

Reorganizing For The “Gemini Era”

As part of the AI roadmap, Alphabet is consolidating all teams building AI models under the Google DeepMind umbrella.

Pichai revealed that, through hardware and software improvements, the company has reduced machine costs associated with its generative AI search results by 80% over the past year.

He states:

“Our data centers are some of the most high-performing, secure, reliable and efficient in the world. We’ve developed new AI models and algorithms that are more than one hundred times more efficient than they were 18 months ago.

How Will Google Make Money With AI?

Alphabet sees opportunities to monetize AI through its advertising products, Cloud offerings, and subscription services.

Advertisement

Google is integrating Gemini into ad products like Performance Max. The company’s Cloud division is bringing “the best of Google AI” to enterprise customers worldwide.

Google One, the company’s subscription service, surpassed 100 million paid subscribers in Q1 and introduced a new premium plan featuring advanced generative AI capabilities powered by Gemini models.

Future Outlook

Pichai outlined six key advantages positioning Alphabet to lead the “next wave of AI innovation”:

  1. Research leadership in AI breakthroughs like the multimodal Gemini model
  2. Robust AI infrastructure and custom TPU chips
  3. Integrating generative AI into Search to enhance the user experience
  4. A global product footprint reaching billions
  5. Streamlined teams and improved execution velocity
  6. Multiple revenue streams to monetize AI through advertising and cloud

With upcoming events like Google I/O and Google Marketing Live, the company is expected to share further updates on its AI initiatives and product roadmap.


Featured Image: Sergei Elagin/Shutterstock

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending

Follow by Email
RSS