Case Study

How Automated Keyword-Driven Content Updates Increased Organic Traffic by 187% in 6 Months

A B2B services firm connected to SerpAPI via our automated AI CMS — lifting organic traffic 187%, ranking keywords from 23 to 91 in the top 10, and reducing content update labour from 16 hours/month to zero.

SEOAI CMSSerpAPINext.js SSR

+187%

Organic traffic vs prior year

23 → 91

Keywords ranking top 10

0 hrs

Manual update time / month

The challenge

Organic traffic down 34% — and the team had no time to fix it

The client had a well-designed website with comprehensive service pages, but their organic traffic had declined by 34% over 18 months as their content aged and competitors published fresher, more keyword-relevant material.

They were updating content manually on an ad hoc basis — perhaps once per quarter — which was insufficient to keep pace with evolving search trends. They had no process for identifying which keywords were gaining traction, and the team had no time to research and update content regularly.

How it works

Inside the build

  1. 01

    Connect SerpAPI

    Wired the client's website to the SerpAPI API to pull live SERP and keyword data on demand.

  2. 02

    Schedule a monthly run

    A Supabase background function runs on the first Monday of each month, pulling top trending keywords for every service area.

  3. 03

    Auto-update meta + body

    The system updates meta titles, meta descriptions, page introductions and key body sections with naturally integrated keyword-optimised copy.

  4. 04

    Ship via SSR for instant indexing

    Because the site runs on Next.js + Vercel with true SSR, Google crawls and indexes every update within 24–72 hours of each monthly run.

Benefits

What the business actually gains

+187% organic traffic

Compared to the same period the previous year — reversing an 18-month decline.

23 → 91 keywords in top 10

A near 4× increase in keywords ranking on page one of Google.

0 → 7 featured snippets

Seven featured snippet positions captured from a starting point of zero.

Avg. position 34.2 → 11.8

Average ranking position for target keywords improved from 34.2 to 11.8.

16 hrs → 0 hrs / month

Content update labour dropped from 16 hours/month to zero — fully automated.

3 → 19 leads / month

Organic leads grew from 3 per month to 19 per month over the six-month window.

Features

Everything the platform delivers

  • Live monthly SerpAPI keyword pull per service area
  • Automated rewrite of meta titles, descriptions and intros
  • True SSR ensures Google reads fresh HTML on next crawl
  • Supabase scheduled function — no server to babysit
  • Per-update audit trail and rollback capability
  • Editorial guardrails to keep tone-of-voice on brand

Technology

Built on a modern stack

Next.js (SSR)VercelSupabase Scheduled FunctionsSerpAPI APIOpenAI

Why it matters

This is what bespoke automation looks like

Three lessons worth carrying into any SEO automation build.

1. SSR is the unlock. Without true server-side rendering, every monthly content update would be invisible to Google for weeks. Next.js + Vercel made the cycle work.

2. Cadence beats volume. One careful monthly update on the right pages outperformed quarterly bulk rewrites across the whole site.

3. Guardrails matter. The system never publishes off-brand or thin content because the prompts and templates are tightly scoped per page. We'd recommend the same shape for any client.

"We tripled our organic leads without adding a single person to the marketing team. The site genuinely keeps itself up to date now."

Marketing Director, UK B2B Services Firm (anonymised)

Services used

Want the same on your site?

FAQ

Frequently asked questions

Will Google penalise automatically updated content?

No — provided it's genuinely useful and well written. The system uses tight templates and editorial guardrails so updates read naturally, not as keyword-stuffed filler.

Why monthly and not daily?

Monthly gives Google time to crawl, index and reward each update before the next one. Faster cadences are possible for very competitive niches but rarely necessary.

Does this work without true SSR?

It works far less well. Without SSR, Google often can't see updates for weeks. We strongly recommend a Next.js + Vercel (or equivalent SSR) site as part of the build.

How long until results show up?

First ranking movements typically appear within 4–8 weeks; meaningful traffic gains compound over 3–6 months as more pages refresh.

Ready to automate your business?

This is just one example of what's possible. If you have a repetitive process costing you time, we can build a custom tool to handle it.

Book a free call

More case studies

How We Eliminated 40 Hours of Weekly Admin for a UK E-Commerce Business

A custom AI workflow automation system that cut a £2.5M UK retailer's manual admin from 40 hours to 3 hours per week — saving roughly £26,000 per year and eliminating data entry errors entirely.

How a Custom Shopify-ERP Integration Eliminated Stock Discrepancies for a UK Retailer

A real-time bidirectional sync between Shopify and a legacy warehouse ERP — eliminating 12 monthly oversells, lifting inventory accuracy to 99.8% and cutting order processing from 4 hours to 40 minutes.

How a Custom Integration API Replaced a Failing Zapier Stack for a UK B2B SaaS

A bespoke event-driven API layer connecting a UK B2B SaaS to HubSpot, Xero and Slack — lifting event delivery from 94% to 100%, saving £18,400 a year in Zapier fees and reconciliation, and paying back in the second month.

Automating E-Commerce Product Data Collection for UK Businesses

A bespoke web application built by Streamline Digital that scrapes, enriches, and exports product data from 15+ e-commerce platforms — saving businesses up to 30 hours of manual work every week.

How a Custom Quotation Platform Cut Bournemouth Removal Quotes from Hours to Minutes

Inside the bespoke quotation system powering manandvanbournemouth.uk — an instant online quote form, AI Smart Intake, live PDF builder and itemised pricing that delivers a transparent, branded quote within minutes of any enquiry.

How We Built Our Own Growth Engine: The Streamline Digital Internal Platform

A single integrated platform — CMS, blog generation, backlink manager, LinkedIn automation, SERP and keyword intelligence, competitor analysis and lead capture — that runs this entire website with about fifteen minutes of human attention a week.

Inside the Admin Console We Built to Run Our Own Agency

Streamline Digital built a bespoke internal admin console that consolidates lead capture, CRM, SEO monitoring, blog automation, LinkedIn scheduling, and backlink outreach into one platform. It replaced approximately eight separate SaaS subscriptions and now runs the agency's entire marketing operation with minimal human oversight.

Hand-picked next steps from across our guides and services.