Case Study
From invisible to 54 pages of competitive SEO strategy in one afternoon
A Pittsburgh bookkeeping firm was losing its own market to national competitors who've never set foot in Allegheny County. In under 3 hours, we mapped the market, found the gaps, shipped a production page, and built a 90-day plan for 54 more.
3 hrs
start to shipped page
54
pages mapped
1
page live day one
< $3
total API cost
800–2,500
projected monthly visitors
15–40
projected monthly leads
The problem
Jordan owns Peacock Bookkeeping Services. It's a firm in Cranberry Township, 20 minutes north of Pittsburgh. Owner-operated businesses across the metro need bookkeeping. The phone should be ringing.
It wasn't.
When you Googled "bookkeeping services near me" in Pittsburgh, the first page looked like this: Bench. Pilot. 1-800Accountant. Companies headquartered in San Francisco and New York, written by marketing teams that have never heard of Keystone Collections. Then Yelp, Clutch, and other directories with no real answers. Below that, CPA firms that do tax returns, not ongoing bookkeeping.
Zero Pittsburgh bookkeepers in the top 10. Jordan's own firm included.
Peacock already had the foundation: 60 pages indexed, 8 industry pages, 7 area pages, a pricing calculator, 17 blog posts. The site wasn't broken. Nobody had done the work of mapping what Pittsburgh buyers actually search for, what the top 10 is saying, and where the gaps are.
That's the work.
Step 1
What Pittsburgh business owners actually search for
Pulled real Google search data on the bookkeeping market. Not opinions about what might convert. Actual queries with actual monthly volumes.
The first pass returned garbage. The tool hooked onto the word "services" and dragged in unrelated results: "better business bureau," "comcast business," "business proposal." Useless.
The second pass used a tighter seed and returned 150 real bookkeeping queries. Filtered out the 60 percent that are non-commercial noise. What's left: 15 high-intent commercial keywords Peacock can actually win.
The headline finding: the term "bookkeeping" does 74,000 searches per month at $20.94 cost per click with competition of 0.31. A legitimately winnable local head term.
Cost of this step: about 20 cents.
Step 2
Finding the gaps in the current top 10
Every ranking page for "bookkeeping services near me" was audited for what it doesn't have. The gaps stacked up. Each gap became a page.
No transparent pricing
Every top result hides pricing behind "contact us." Zero calculators. Zero worked examples.
No industry-specific content
Nobody ranks for "bookkeeping for restaurants," "bookkeeping for contractors," "bookkeeping for dentists." The space is empty.
No original research
One firm in Illinois publishes annual benchmarks and gets cited by ChatGPT and Perplexity. Zero Pennsylvania firms have done it.
No local tax detail
National services don't know the 7% Allegheny County surcharge on prepared food exists. Peacock does.
No answers to buyer objections
"I don't have time." "I don't have budget." "How do you take over without losing data?" None of the top results answer any of these directly.
Cost of this step: about 5 cents.
Step 3
A 54-page plan, priced and sequenced
Not "write more blog posts." An actual plan with six tiers.
5 core money pages
Homepage, services, pricing, about, contact. Upgraded for the gaps.
10 location pages
Cranberry, Pittsburgh, Wexford, Butler, North Hills, South Hills, Mars, Allegheny County, Butler County, Warrendale.
7 industry pages
Restaurants, contractors, dentists, law firms, real estate, ecommerce, nonprofits.
20 location × industry combos
Bookkeeping for Pittsburgh restaurants. Bookkeeping for Butler County contractors. On and on.
8 depth pages
Onboarding timeline, security, Peacock vs national firms, chart of accounts template, Pittsburgh Bookkeeping Benchmarks 2026.
4 software handoff pages
QuickBooks, Xero, Wave, FreshBooks.
90-day rollout. Projected 800 to 2,500 monthly organic visitors at steady state. At a 2 to 4 percent conversion rate on commercial-intent traffic, that's 15 to 40 qualified leads per month from organic channels alone. Most of that traffic is worthless to national competitors because it's geo-locked. Most of it is invisible to local competitors because they haven't done the work.
Step 4
One page shipped to production the same day
The demo target: "Bookkeeping for Pittsburgh Restaurants" at a brand new nested URL on Peacock's site. What's on the page:
Built. Pushed. Merged to main. Auto-deployed on Vercel. HTTP 200 in 60 seconds. Sitemap updated. Submitted to Google Search Console.
Why this actually works
Real data, not opinions.
Every decision ties back to actual search volume, actual competitor content, actual buyer intent.
Local specificity is a moat.
National competitors can't write about the 7 percent Allegheny County surcharge because they don't know it exists. Peacock does. One sentence like that is worth more than 500 words of generic filler.
Ship pages, don't write reports.
Most SEO projects end with a Google Doc full of recommendations that sit in Drive forever. This one ended with a live page indexed by Google. Recommendations get filed away. Live pages get found.
For context, a typical SEO agency quotes $2,500 to $5,000 per month for work of this scope and takes 3 to 6 months to produce it. Boring Marketing charges $2,997 per month for a 30-day sprint. Jordan shipped comparable strategy plus a live page in one afternoon.
The same approach works for your business
This wasn't special to bookkeeping. It's the same workflow that works for a plumber, a real estate agency, an event organizer, a restaurant, a dental practice, or any local business getting beaten by national competitors in their own market.
The four steps don't change:
- Find out what people actually search for.
- Find what's missing from the current top 10.
- Build a plan that fills the gaps with content competitors can't write.
- Ship pages, not reports.
If your business isn't showing up when customers Google what you do, it isn't because you need more ads or more social media posts. It's because nobody has done the work of mapping the market, finding the gaps, and building pages that win.
Free visibility check
Not ready for a call?
Tell me a little about your business and I'll check how you show up on Google. No call required. I'll send you what I find.
Questions
Before you decide
Most projects go live in 2 to 4 weeks. Not months. The Draft Guide was 20 pages and ranked on Google in 3 days.
That's fine. If it's not showing up on Google, it's not doing its job. I'll look at what you have and tell you exactly what's missing.
Show up for a 15-minute call. Tell me about your business. That's it. Everything else is handled.
Every project is different, so there's no one-size-fits-all price. The call is free. I'll give you an honest assessment and you can decide from there. No pressure.
Most web designers build sites that look nice but nobody finds. I build sites that rank on Google and bring in real customers. The proof is in the results: top 2 ranking for 'bookkeepers Pittsburgh,' 1,099 sessions in week one for the Draft Guide.
Ready to be found?
Book a free 15-minute call. I'll show you exactly where you stand on Google and what it would take to get found.
Book your free callWhat to expect
You talk, I listen
Tell me about your business in your own words.
I show you where you stand
Live Google search. You'll see exactly what your customers see.
Honest assessment, no pitch
If I can help, I'll tell you how. If I can't, I'll tell you that too.
No pitch. No pressure. Just an honest look at where you stand online.