Skip to content

SEO performance portfolio

Prepared June 2026

Organic search growth

PortfolioSEO performance

A review of client campaigns where organic search grew the most

Johan Cilliers

Search Console verified data

Section

Overview


This is the search engine optimization section of my portfolio. It covers the client accounts where organic search grew the most over the past year, measured directly in Google Search Console.

Every number here is real. Clicks and average position compare the most recent quarter, March to May 2026, against the same quarter a year earlier. Sites grouped under “new to search” had no measurable organic presence in the prior year, so their figures show what they reached from a standing start rather than a percentage. The charts plot monthly organic clicks across the full period, so you can see the whole trajectory and not just the endpoints.

The work described under each client summarizes the campaign that produced the result: technical fixes, content built around real search demand, local optimization, and the structural changes that let those gains hold.

Results at a glance

Year-over-year organic search results for 19 client accounts
ClientClicks (before → now)GrowthAvg. position
Healthy Start Florida2,794 → 47,442+1,598%25.4 → 6.1
Hillsborough County Tax Collector62,439 → 317,696+409%24.7 → 7.8
Tampa Mattress6,497 → 28,554+339%15.9 → 5.1
Continuum Wellness95 → 1,100+1,058%18.1 → 8.4
Desert Dental Smiles250 → 771+208%39 → 9.5
Dr Pav Khaira245 → 839+242%41.4 → 11.9
Peddicord Family Dentistry633 → 1,381+118%25.8 → 10.1
Acton Implants294 → 690+135%34.1 → 17.6
Murphy Dental & Implant Center394 → 738+87%34.3 → 10.7
Kayton Dentistry562 → 847+51%39.9 → 10.6
Neal & Solevilla Law629 → 1,173+86%46.1 → 17.7
XO Dental1,943 → 3,535+82%29.6 → 19.7
Coastal CT Dentistry908 → 1,590+75%20.7 → 18.2
Creative Smiles2,778 → 3,600+30%41.3 → 18.6
Dental Aesthetica513 → 715+39%37.6 → 15.4
Trapline Pest Solutions606 → 800+32%27.1 → 7.7
Orange County Electionsnew → 14,593New to search→ 6.6
Williams, Daily & Frazier Dentalnew → 7,399New to search→ 9.3
Stages of Life Medical Institutenew → 1,332New to search→ 14.3

Average position is the sitewide mean across all ranking queries; lower is better. A move from the mid-20s to single digits means the site shifted from page three to the top of page one on average.

Section

Headline results

The campaigns with the largest year-over-year jump in organic search traffic.

SEO performance portfolio

Maternal health nonprofit, Florida

Healthy Start Florida


Clicks before
2,794
Clicks now
47,442
Year over year
+1,598%
Avg. position
25.4 → 6.1
Monthly organic clicks
05k10k15k20k25k30k25-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Healthy Start Florida
Search termGoogle pos.Monthly clicks
pregnancy calculator6.018,661
pregnancy week calculator6.26,123
pregnancy calendar5.6799
pregnancy calculator week by week5.0798

What we delivered

The biggest lever here was a pregnancy due-date calculator and a week-by-week pregnancy guide. We rebuilt both as fast, mobile-first tools, marked them up with structured data, and wired internal links from the tools into the program and service pages so the ranking strength carried through the site.

The pregnancy calculator cluster sat on page three a year ago. It now holds the top of page one across dozens of variations, and the site went from roughly 2,800 organic clicks a quarter to over 47,000. Average position improved from 25 to 6.

Government services, Hillsborough County, Florida

Hillsborough County Tax Collector


Clicks before
62,439
Clicks now
317,696
Year over year
+409%
Avg. position
24.7 → 7.8
Monthly organic clicks
025k50k75k100k125k150k25-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Hillsborough County Tax Collector
Search termGoogle pos.Monthly clicks
hillsborough county tax collector1.035,093
hillsborough county property tax1.25,951
tax collector5.55,390
dmv2.85,089

What we delivered

A large government site with thousands of pages and a tangle of indexation and duplicate-URL problems. We restructured the site around the tasks people actually search for: property tax, driver licenses, vehicle registration, and DMV appointments. Then we cleaned up canonicals and crawl waste and added FAQ markup to the task pages.

Brand and high-intent service terms moved to position one. Quarterly clicks went from about 62,000 to over 317,000, with average position climbing from 25 to under 8.

Mattress and bedding retail, Tampa, Florida

Tampa Mattress


Clicks before
6,497
Clicks now
28,554
Year over year
+339%
Avg. position
15.9 → 5.1
Monthly organic clicks
05k10k15k20k25-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Tampa Mattress
Search termGoogle pos.Monthly clicks
bed sizes4.61,462
mattress sizes3.8480
bed sizes chart2.5388
mattress size chart2.0210

What we delivered

A small retailer competing against national chains. We built a bed and mattress size guide around the high-volume sizing searches, with clear comparison tables and a visual size chart, then linked it through to the relevant category and product pages.

That one hub now ranks top five for the whole sizing cluster and feeds qualified traffic into the store. Clicks rose from roughly 6,500 to over 28,500 a quarter, and average position more than halved.

Supplements and wellness, direct-to-consumer

Continuum Wellness


Clicks before
95
Clicks now
1,100
Year over year
+1,058%
Avg. position
18.1 → 8.4
Monthly organic clicks
010020030040050060025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Continuum Wellness
Search termGoogle pos.Monthly clicks
continuum wellness2.7190
continuum vitamins2.671
continuum supplements2.459
continuum probiotic2.527

What we delivered

The brand was barely indexed when we picked it up. We established proper brand and product pages, added Organization and Product schema, built category pages for vitamins, supplements, and probiotics, and cleared the technical issues holding the site back.

Brand and product terms now sit in the top three. A near-invisible site went from under 100 clicks a quarter to 1,100.

Section

Local & practice growth

Service businesses and clinics that climbed from page three to page one in their markets.

SEO performance portfolio

Dental practice, Hermiston, Oregon

Desert Dental Smiles


Clicks before
250
Clicks now
771
Year over year
+208%
Avg. position
39 → 9.5
Monthly organic clicks
010020030040025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Desert Dental Smiles
Search termGoogle pos.Monthly clicks
desert dental hermiston1.652
dentist hermiston5.221
dentist in hermiston oregon5.48
hermiston dentist10.58

What we delivered

Classic local build-out for a single-location practice. We optimized the Google Business Profile, rewrote the location and service pages, cleaned up the name, address, and phone data across directories, and set up a steady review flow.

Local searches for a dentist in Hermiston moved from page four to page one, and clicks tripled.

Ceramic and zirconia dental implants, United Kingdom

Dr Pav Khaira


Clicks before
245
Clicks now
839
Year over year
+242%
Avg. position
41.4 → 11.9
Monthly organic clicks
010020030040025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Dr Pav Khaira
Search termGoogle pos.Monthly clicks
pav khaira1.340
zirconia implants5.826
ceramic implants8.57
reasons not to get dental implants uk3.87

What we delivered

A specialist with a genuine niche in metal-free implants. We positioned the site as a ceramic and zirconia implant authority, building educational content around those treatments and the questions patients actually ask before committing.

Niche implant terms moved onto page one and clicks more than tripled, with average position improving from 41 to 12.

Family dental practice, Ankeny, Iowa

Peddicord Family Dentistry


Clicks before
633
Clicks now
1,381
Year over year
+118%
Avg. position
25.8 → 10.1
Monthly organic clicks
015030045060075025-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Peddicord Family Dentistry
Search termGoogle pos.Monthly clicks
peddicord family dentistry1.632
peddicord dentistry1.819
diy denture cleaner7.310
cleaning dentures with baking soda6.39

What we delivered

We rebuilt the site around the Peddicord brand after a practice name change, making sure the brand secured the top spot and the old equity carried over. Alongside that we published a denture-care content series that picked up a steady stream of informational searches.

Clicks more than doubled and average position improved from 26 to 10, with a new content-led traffic stream on top of the local visibility.

Dental implant practice, Acton, Massachusetts

Acton Implants


Clicks before
294
Clicks now
690
Year over year
+135%
Avg. position
34.1 → 17.6
Monthly organic clicks
05010015020025030025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Acton Implants
Search termGoogle pos.Monthly clicks
acton implants3.028
can you eat nuts with dental implants2.220
acton dentistry6.75
acton dental7.54

What we delivered

Implant-focused service pages paired with practical patient FAQ content covering aftercare and diet. We optimized the local presence for Acton and the surrounding towns.

Practice terms and aftercare questions both climbed toward page one, and clicks more than doubled.

Dental practice, Murphy, Texas

Murphy Dental & Implant Center


Clicks before
394
Clicks now
738
Year over year
+87%
Avg. position
34.3 → 10.7
Monthly organic clicks
05010015020025030025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Murphy Dental & Implant Center
Search termGoogle pos.Monthly clicks
murphy dental and implant center1.2285
murphy dental11.349
murphy implant center1.018
dentist murphy tx13.76

What we delivered

Brand consolidation plus geo-targeted service pages for the Murphy area, backed by Google Business Profile work and citation cleanup.

The brand owns position one and the broader Murphy geo terms are climbing. Average position improved from 34 to 11.

Dental practice, Charlottesville, Virginia

Kayton Dentistry


Clicks before
562
Clicks now
847
Year over year
+51%
Avg. position
39.9 → 10.6
Monthly organic clicks
010020030040025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Kayton Dentistry
Search termGoogle pos.Monthly clicks
jack kayton dds4.226
jack kayton1.223
dr kayton2.218

What we delivered

We rebuilt the practitioner and brand pages with proper bios and trust signals, then added local service pages. A round of technical fixes cleared what was dragging the site down.

Average position moved from page four to page one, and clicks grew by half.

Personal injury law firm, Florida

Neal & Solevilla Law


Clicks before
629
Clicks now
1,173
Year over year
+86%
Avg. position
46.1 → 17.7
Monthly organic clicks
02004006008001k25-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Neal & Solevilla Law
Search termGoogle pos.Monthly clicks
neal and solevilla2.186
neal & solevilla personal injury lawyers1.517
melissa solevilla3.516

What we delivered

Practice-area pages for the firm’s personal injury work, attorney bios with real credibility signals, local optimization, and structured data across the site.

Brand and practice terms moved up sharply and the sitewide average position nearly halved, from 46 to 18.

Cosmetic dental practice, Preston, United Kingdom

XO Dental


Clicks before
1,943
Clicks now
3,535
Year over year
+82%
Avg. position
29.6 → 19.7
Monthly organic clicks
02505007501k1.25k1.5k25-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for XO Dental
Search termGoogle pos.Monthly clicks
xo dental1.61,226
teeth whitening preston17.461
xo dental reviews1.542
dentist preston6.840

What we delivered

Cosmetic service pages for whitening and aligners, with geo-targeting for Preston. A round of technical and content improvements ran alongside.

The brand is dominant and the cosmetic geo terms are climbing the rankings. Clicks rose from roughly 1,900 to 3,500 a quarter.

Dental practice, Waterford, Connecticut

Coastal CT Dentistry


Clicks before
908
Clicks now
1,590
Year over year
+75%
Avg. position
20.7 → 18.2
Monthly organic clicks
010020030040050060025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Coastal CT Dentistry
Search termGoogle pos.Monthly clicks
coastal ct dentistry1.8239
coastal connecticut dentistry1.5113
coastal dental waterford ct1.058

What we delivered

Brand and local geo pages for the Waterford area, backed by citation building and a review push.

Local Waterford terms sit at the top of page one and clicks grew by three quarters.

Cosmetic dental practice, Belfast, Northern Ireland

Creative Smiles


Clicks before
2,778
Clicks now
3,600
Year over year
+30%
Avg. position
41.3 → 18.6
Monthly organic clicks
02505007501k1.25k25-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Creative Smiles
Search termGoogle pos.Monthly clicks
creative smiles3.0486
creative smiles dunmurry1.4135
teeth whitening belfast10.655
composite bonding belfast16.229

What we delivered

A cosmetic service hub covering whitening and composite bonding, with Belfast and Dunmurry geo-targeting and a technical cleanup.

Average position more than halved, from 41 to 19, with the cosmetic geo terms now within striking distance of page one.

Cosmetic dental practice, Altrincham, United Kingdom

Dental Aesthetica


Clicks before
513
Clicks now
715
Year over year
+39%
Avg. position
37.6 → 15.4
Monthly organic clicks
05010015020025030025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Dental Aesthetica
Search termGoogle pos.Monthly clicks
dental aesthetica5.076
teeth whitening altrincham5.115
dentist altrincham4.914

What we delivered

Local cosmetic dentistry pages built around Altrincham search terms, plus a review programme.

Average position improved from page four into page two, with the core local terms already on page one.

Pest control, Florida

Trapline Pest Solutions


Clicks before
606
Clicks now
800
Year over year
+32%
Avg. position
27.1 → 7.7
Monthly organic clicks
05010015020025030025-0225-0325-0425-0525-0625-0725-0825-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Trapline Pest Solutions
Search termGoogle pos.Monthly clicks
termites vs ants1.584
trapline pest solutions2.067
ant vs termite1.340
plaster bagworm2.729

What we delivered

We built pest identification content around the things homeowners search before they call, like telling termites from ants and dealing with plaster bagworms, then connected it to the service and location pages.

Those educational terms hit position one, and the sitewide average position jumped from 27 to under 8 as the topical authority took hold.

Section

New sites taken to market

Brand-new properties that went from no search presence to thousands of monthly clicks.

SEO performance portfolio

Government elections office, Orange County, Florida

Orange County Elections


Clicks before
New
Clicks now
14,593
Year over year
New to search
Avg. position
→ 6.6
Monthly organic clicks
010k20k30k40k50k25-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Orange County Elections
Search termGoogle pos.Monthly clicks
apopka election results3.4723
orange county supervisor of elections1.5248
orange county voter registration lookup3.1224
apopka election results 20262.0146

What we delivered

A new search presence built around what voters actually need: live results pages and a voter registration lookup, plus event-driven content engineered to index fast ahead of each cycle.

The site captured high-intent election and voter terms quickly, reaching nearly 14,600 clicks a quarter from a standing start with an average position under 7.

Dental practice, United States

Williams, Daily & Frazier Dental


Clicks before
New
Clicks now
7,399
Year over year
New to search
Avg. position
→ 9.3
Monthly organic clicks
05001k1.5k2k2.5k3k25-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Williams, Daily & Frazier Dental
Search termGoogle pos.Monthly clicks
williams daily & frazier dental1.0184
extra wisdom teeth1.595
supernumerary wisdom teeth1.765
williams and daily dental1.447

What we delivered

A brand-new site taken to market. Alongside the brand and service pages we ran a clinical content series on supernumerary and extra wisdom teeth that earned strong informational rankings well beyond the local area.

From zero search presence to over 7,300 clicks a quarter within a few months of launch.

Medical practice, Longwood, Florida

Stages of Life Medical Institute


Clicks before
New
Clicks now
1,332
Year over year
New to search
Avg. position
→ 14.3
Monthly organic clicks
015030045060075025-0925-1025-1125-1226-0126-0226-0326-0426-05

Top ranked search terms

Top ranked search terms for Stages of Life Medical Institute
Search termGoogle pos.Monthly clicks
stages of life medical institute1.2178
stages of life longwood1.555
stages of life patient portal1.916

What we delivered

Established the practice in search from scratch. Brand and location pages went in first, then the patient portal page, all indexed and ranking top two for brand terms within weeks.

A new property that went from no visibility to over 1,300 clicks a quarter.

Portfolio part two

Tools & AI

Internal software, MCP servers, trading bots and the tools that run the agency.

SEO performance portfolio

Part two

Tools & AI


The other half of the work is building the software. Over the past year I designed and shipped around forty projects: MCP servers that plug live data straight into Claude, trading bots with real risk controls, client dashboards, onboarding portals, and a stack of SEO and audit tools.

What follows is a selection of the strongest, each with a look at its interface and what it does. The Google Hub MCP is a good place to start, because it’s the server that pulled every figure in the SEO section above. A wider index of the rest sits at the end.

MCP & connectors

Google Hub MCP

One MCP gateway to every GA4 and Search Console account


A remote MCP server that gives Claude a single endpoint into Google Analytics and Search Console across every connected account. It keeps AES-256 encrypted OAuth refresh tokens per account and refreshes them on demand, proxying Google’s APIs as native tool calls.

This is the server that powered the entire SEO section of this portfolio: 130+ properties, queried from one place.

Highlights

  • Encrypted per-account OAuth token vault in Supabase
  • Tools for list_clients, ga4_report, gsc_query and joined GA4 + GSC pulls
  • On-demand token refresh and quota tracking
  • Streamable HTTP MCP with OAuth for Claude Desktop, Code and Cowork

Built withTypeScript · Node · Hono · MCP SDK · Supabase · Google APIs · OAuth 2.0 · Vercel

MCP & connectors

MCP Connector Suite

Ahrefs, SEMrush, Screaming Frog and GBP as native Claude tools


A family of self-hosted Model Context Protocol servers that wrap the tools an SEO team lives in, so Claude can call them directly from chat. Each one installs in a single command and authenticates with a token instead of fragile email-matching OAuth.

Highlights

  • Ahrefs connector: 28 tools across backlinks, keywords, SERP and batch analysis
  • SEMrush MCP: 21 domain analytics, keyword and backlink tools
  • Screaming Frog MCP: drive crawls, sitemaps and scheduled audits
  • GBP and Google-account connectors for Business Profile and multi-account data

Built withTypeScript · Node · MCP SDK · Ahrefs v3 · SEMrush API · Screaming Frog CLI

Trading bots

AI Trading Bots

Gold, crypto, forex and equities engines with hard risk controls


A fleet of algorithmic trading bots. The flagship Gold Trader pairs a standalone Node engine with a live dashboard, streaming ticks and signals over WebSocket and using Claude for market commentary. Alongside it sit a 24/7 Binance crypto bot and a forex bot with a pure risk engine, plus an equities tracker that watches insider filings.

Highlights

  • Gold Trader: triple-EMA FSM strategy, broker-adapter pattern, paper and live modes
  • Crypto bot: Binance + VALR, multiple strategies, Telegram /panic kill-switch
  • Forex bot: pure RiskEngine, SQLite trade journal, structured logging
  • SmartMoney: SEC Form 4 monitoring with Alpaca paper trades

Built withNext.js · Node engine · Python · ccxt · Supabase · WebSocket · Anthropic API

Audit & analytics

Search Insights Hub

Automated client SEO reporting from GA4, GSC and PageSpeed


A reporting platform that pulls Analytics, Search Console and PageSpeed into one place and turns them into automated, shareable client reports. It handles multiple Google accounts, compares date ranges, scores recommendations by impact, and produces secure client-facing report links.

Highlights

  • Multi-account Google OAuth with property selection
  • Interactive dashboards with week, month and year comparisons
  • AI-generated, priority-scored recommendations
  • Secure shareable report links and a client portal

Built withNext.js · TypeScript · Prisma · Postgres · GA4 / GSC / PageSpeed APIs · Vercel

Audit & analytics

Luminari

Track brand visibility across AI search engines


A Generative Engine Optimization platform that measures how ChatGPT, Claude, Gemini and Perplexity cite and recommend a brand versus its competitors. Tracking is organized through monitors and prompts, with a visibility score and citation logging, plus content generation to close the gaps.

Highlights

  • Brand Visibility Score from mention rate, citations and sentiment
  • Multi-model querying across OpenAI, Anthropic and Google
  • Citation tracking with dashboard charts
  • Content generation and xlsx / PDF export

Built withNext.js · TypeScript · Supabase · TanStack Query · Recharts · multi-LLM SDKs

AI search

Answer Engine Optimizer

Close the gap between brand truth and how LLMs describe you


A multi-tenant AI Engine Optimization platform that audits how language models describe a firm against its own Brand Truth, scoring each claim red, yellow or green. It tracks visibility and citations across models and watches competitor and Reddit sentiment. Fixes route through a remediation queue.

Highlights

  • Trust Alignment Audit scoring narratives vs a Brand Truth source
  • Visibility and citation tracking across OpenAI, Anthropic, Google and Perplexity
  • Legacy content suppression and structured-signal alignment
  • Client portal with rolled-up scores and a remediation queue

Built withNext.js · FastAPI · LangGraph · Playwright · Pinecone · Postgres · Turborepo

Audit & analytics

Website Audit Tool

Visual CRO and SEO audits as a polished PDF report


A tool that runs a full CRO, SEO and performance audit of any site and outputs a branded PDF report. It captures device-emulated screenshots, scores the page across three dimensions, runs Lighthouse, and writes prioritized recommendations with Claude generating the narrative.

Highlights

  • Strategic desktop, mobile and tablet screenshots
  • SEO checks across meta, headings, schema and Open Graph
  • CRO review of hero, CTAs, trust signals and forms
  • Lighthouse scoring and a prioritized, branded PDF report

Built withNext.js · Puppeteer · Firecrawl · Lighthouse · Sharp · Anthropic SDK · Vercel

SEO & crawling

Site Crawler

Crawl a site, extract its contact and tracking footprint


A crawler that renders a site with a real browser and pulls structured business intelligence from it: emails, phone numbers, address, social profiles and the analytics and tracking vendors running on each page, with on-page evidence for every detection.

Highlights

  • JS-rendered crawling via Playwright with robots.txt parsing
  • Extracts emails, region-aware phones, address and socials
  • Detects tracking vendors and their IDs with evidence
  • Per-page status and concurrency-limited crawling

Built withNext.js · TypeScript · Playwright · Cheerio · libphonenumber-js

Client dashboards

Agency Operations Hub

One control panel for clients, MRR and agency operations


A central operations dashboard that consolidates clients, projects, MRR, team, SOPs and reporting into one app. It syncs a live Google ops sheet into Supabase through an immutable identity model and renders the KPIs the agency runs on.

Highlights

  • Client, project, team and SOP management
  • Google Sheets ops-sync into Supabase with write-back
  • MRR and KPI dashboards
  • Token-gated sync API and enforced SSR auth

Built withNext.js · React · Supabase SSR · Google Sheets API · Recharts · Resend

Onboarding & workflow

Client Onboarding

Token-linked client intake from request to signed brief


A branded onboarding system that turns scattered kickoff emails into one repeatable flow. The agency spins up a session and sends the client a private tokenized link. Structured intake comes back through a guided wizard, and the completed brief exports to Word. Built in two variants for different agencies.

Highlights

  • Admin dashboard to create and track onboarding sessions
  • Tokenized per-client onboarding links
  • Multi-step intake wizard with validation
  • Word document export of the completed intake

Built withNext.js · React · Supabase · React Hook Form · Zod · docx

Fintech

statement2xlsx

Bank statement PDFs into validated Excel workbooks


A converter that turns bank statement PDFs into clean, structured Excel workbooks with real validation. It uses coordinate-based extraction with an OCR fallback for scanned statements and auto-detects the bank. Before a workbook ships, the tool checks its own output against the totals printed in the PDF.

Highlights

  • Bank auto-detection with coordinate-based extraction
  • Tesseract OCR fallback for scanned statements
  • Validation against PDF metadata for totals and counts
  • Multi-sheet Excel output plus a CLI and FastAPI web app

Built withPython · pdfplumber · Tesseract · openpyxl · FastAPI · Docker

Platform & infra

License Control

Ed25519-signed activation-on-payment for shipped apps


A centralized licensing system that enforces activation-on-payment across client projects as a disclosed mechanism. Protected apps call a check endpoint and get back an Ed25519-signed envelope whose config only exists while active, so removing the client-side check still disables the app, with an offline grace window before lock.

Highlights

  • Ed25519-signed, nonce-protected license envelopes
  • Config payload present only while active
  • Offline grace window anchored to signed server time
  • Drop-in TypeScript SDK and an admin dashboard

Built withNext.js · TypeScript · Supabase · Ed25519 · Vercel

Content & media

YouTube Transcriber

Bulk video transcription with captions and ASR fallback


A production-grade transcription system that handles single videos, whole channels and playlists, and local files in bulk. It prefers existing captions and falls back across several ASR engines, chunks multi-hour videos with voice-activity detection, and exports to five formats.

Highlights

  • YouTube videos, channels, playlists and local files
  • Caption-first with faster-whisper, Deepgram and AssemblyAI fallback
  • VAD chunking for multi-hour video
  • Exports to SRT, VTT, TXT, JSON and Markdown

Built withPython · faster-whisper · FFmpeg · Deepgram / AssemblyAI · Docker

Content & media

RankWriter.AI

Token-based AI content built for SEO and AI search


A content-generation SaaS for agencies that produces publication-ready writing tuned for both traditional search and AI engines like ChatGPT and Perplexity. It runs a deep brand analysis first so output stays on-voice, then exports straight to Word, billed on a token model.

Highlights

  • Content tuned for SEO and AI-search visibility
  • Brand analysis to hold a consistent voice
  • Token-based usage for agencies
  • Word document export

Built withFastAPI · Anthropic · Next.js · Pydantic · python-docx · Vercel + Railway

Also in the toolkit


A condensed index of the remaining builds.

Website Quality Audit Generator
Merges crawl, GA4, GSC and backlink CSVs into a per-URL Excel audit with an action on every page.
SEO + AI Content Optimizer
Document-in, document-out DOCX rewriting that highlights only genuinely new content in green.
SEO Build Audit
Runs an 80-check technical SEO SOP against any site and grades each issue by severity.
Conversion Tagging Scanner
Crawls a site for GTM and GA4 tagging opportunities with a CSS selector and snippet behind every finding.
Client Alignment Checker
Stores per-client rules and brand guidelines, then AI-checks deliverables against them before they ship.
Newsletter-to-Video Reels
Turns newsletter text into narrated social video using Claude scripting and ElevenLabs voiceover.
LinkedIn Blog Reposter
Watches blogs by RSS and sitemap and auto-drafts on-brand LinkedIn posts for review and scheduling.
Sales Rep Knowledge Leaderboard
Gamified weekly product-knowledge quizzes with a public, tiered leaderboard to drive training.
Web Page Content Extractor
Pulls meta tags and the full H1 to H4 heading structure from any URL for content audits and briefs.
Budget Planner
Multi-currency personal budgeting with live FX rates and trend charts, and recommendations graded by severity.
SnapDoc
WhatsApp-driven doctor referral and booking with automated 24-hour and 2-hour appointment reminders.
SA Tax & Estate Planning Bot
A Claude-driven assistant that ingests financial documents and maintains a structured tax and estate knowledge base.
Marketing Studio Website
A full marketing site with a built-in Gemini image-generation pipeline and IndexNow submission.
Claude Account Switcher
A utility for switching between multiple Claude accounts and configurations from one place.
Internet Throttle & RAM Monitor
Local system utilities for simulating constrained networks and watching memory in real time.
Tool File Allocator
A helper that organizes and routes generated files into the right project locations for Claude workflows.

Let’s work together

Thank
you

Every figure on this page is pulled from live Google Search Console data. Happy to walk through any client in detail, or show how the same playbook applies to yours.

Contact

Johan Cilliers

johanlcilliers@gmail.com