Frank Yao: How One Vancouver Consultant Builds AI Systems That Run While You Sleep

I'm Frank Yao, an AI Automation Architect based in Vancouver, BC, with 15+ years in SEO. I design, build, and deploy AI systems for owner-led businesses: systems that handle your content publishing, lead follow-up, SEO monitoring, and reporting while you sleep.

TL;DR

• I build AI systems for owner-led businesses: automated content publishing, lead follow-up, SEO monitoring and reporting.
• AI adoption is growing fast in Canada: 12.2% of businesses used AI to produce goods or deliver services in Q2 2025, up from 6.1% a year earlier (Statistics Canada).
• A real example below: a tree care company's SEO and website rebuild, with 190+ pages migrated, 12 service pages and 10 location pages.
• Before hiring any AI consultant, ask to see the actual system, the KPIs, who owns your data, and the exit policy.

Quick Overview

Here's what this article covers:

• Where automated AI systems save time for small business owners
• The five-phase SEO process I use on client sites
• A real client example, with the figures published in my portfolio
• Local Vancouver SEO specifics: Geographic targeting, neighborhood strategy, citation consistency
• How to evaluate any AI consultant before hiring (5 key questions)

---

At 2:47 AM on a Tuesday, while you're resting, my system can publish an approved blog post targeting a keyword your Surrey-area customers will search at 7:15 AM. Your Google Business Profile updates automatically, a prospect who filled out your contact form six minutes ago receives a personalized response, and your dashboard shows which pages moved in the overnight rankings. That's the kind of system I build.

I've spent 15+ years in SEO and the last 2+ years building AI systems from first principles: writing the code, testing the integrations, debugging the failures. I work out of Vancouver and focus on owner-led businesses with the ambition to grow but without Fortune 500 budgets.

When I started this work, I noticed that many agencies sell tools or monthly retainers with little accountability. I decided to build the opposite: systems with measurable KPIs (organic traffic, leads, revenue) where you own the infrastructure and can walk away anytime with your data intact.

The AI Adoption Gap in BC (And Why It Matters)

Here's why this matters now: according to Statistics Canada's Canadian Survey on Business Conditions, 12.2% of Canadian businesses used AI to produce goods or deliver services in the second quarter of 2025, up from 6.1% a year earlier. Adoption doubled in a year, and most businesses still haven't started. In British Columbia, which had 187,741 small employer businesses as of December 2022 (Innovation, Science and Economic Development Canada), that gap is an opening for the owners who move first.

I don't sell AI tools. I build AI systems.

There's a critical difference. A tool is something you buy, log into, use for three weeks, and forget. A system is integrated, end-to-end, and produces real business outcomes from real inputs. Right now, my clients have:

• Automated SEO monitoring: Daily technical audits checking indexation, broken links, sitemap health, and ranking changes. Alerts fire to my dashboard when attention is needed.
• Automated lead follow-up: Prospects who submit forms receive personalized responses within minutes, not hours—based on their specific service request and location.
• Automated reporting: Monthly scorecards pulled directly from GA4, GSC, GBP metrics, and social platforms. No manual spreadsheet assembly.

This runs continuously, 24/7. The human-powered consultancy model—where an SEO strategist manually checks rankings and writes recommendations—doesn't scale and burns out fast. My system doesn't get tired. It doesn't miss a Tuesday. It operates with consistency most humans can't sustain.

How Much Time Does This Actually Save?

Nobody can promise a fixed number of hours; it depends on how much of the work you do by hand today. For a small business owner personally handling marketing, even a few recovered hours a week is the difference between working until 9 PM and actually being home for dinner.

The time usually comes back from these tasks:

• Blog content creation: drafting moves from a blank page to a review step
• Social media posting: scheduled automatically
• Lead follow-up emails: sent automatically
• SEO monitoring and reporting: a dashboard check instead of manual data pulls

The real win isn't just time—it's predictability. Every Monday, the report is ready. Every Thursday, social posts are live. Every keyword move is logged. No backlog, no "I forgot to check rankings."

Real Example: A Greater Vancouver Tree Care Company's SEO and Website Rebuild

Here's a real engagement from my portfolio (client name withheld).

An established arborist and tree care company that has served Greater Vancouver for two decades had a slow, dated WordPress site. Its most valuable commercial keyword sat on page two, most of its service pages weren't indexed at all, and broken redirects from an earlier migration were leaking link equity into 404 pages.

Step 1: Data first, design second. We pulled 28 days of live search query data (every query, impression, click and position) and cross-referenced it with analytics to see which pages people actually engaged with. Then we ran a Compact Keywords audit, which checks whether each bottom-of-funnel page has its target keyword in six places: URL, page title, meta description, H1, first sentence and first image alt text. Most service pages failed on three or more.

Step 2: The rebuild. On a modern headless stack, we:

1. Migrated 190 blog posts into a cleaner content structure
2. Built 12 dedicated service pages with keyword-first titles (for example, "Tree Removal Vancouver" instead of "Our Tree Removal Services")
3. Created 10 location pages for Greater Vancouver cities
4. Fixed five legacy redirects that pointed at slugs that no longer existed
5. Added schema markup: LocalBusiness with AggregateRating, service schema on every service page, breadcrumbs, and FAQ schema on high-intent pages

Where it landed:

• 190+ pages migrated
• 12 service pages and 10 location pages, each an individual, indexable route with keyword-optimized metadata
• Service pages Google previously couldn't find (removal, stump grinding, hedge trimming, tree cutting, arborist reports) now indexed with correct canonical URLs and structured data
• Stale sitemaps removed from Search Console and the correct sitemap submitted

The SEO work isn't finished; it never is. But the foundation is no longer the bottleneck, and the site now has the architecture to rank, which is the part most rebuilds skip.

Here's the part that often gets skipped: I test every article for quality before it publishes. E-E-A-T compliance, originality scanning, fact-checking, proper internal linking. Generic AI content hurts SEO. Quality AI content compounds.

Local Search in Vancouver: The Data

British Columbia had 187,741 small employer businesses as of December 2022 (Innovation, Science and Economic Development Canada, Key Small Business Statistics). Many of them compete for local customers, and those customers look for businesses on Google:

• 87% of consumers used Google to evaluate local businesses in 2022, up from 81% in 2021 (BrightLocal Local Consumer Review Survey 2023)

These aren't vanity metrics. They're foot traffic, phone calls, and revenue.

My approach to local SEO:

• GBP optimization: regular photo uploads (original client photos, not stock), posts that answer real customer questions, and thoughtful review responses
• Geo-targeted content: Blog posts and location pages targeting neighborhoods across the Lower Mainland (Vancouver, Burnaby, Surrey, Coquitlam, Richmond, Kitsilano, North Vancouver, Langley, Maple Ridge)
• Citation consistency: business name, address and phone identical across directories (Google Business Profile, Yelp, Apple Maps, and the directories that matter in each industry)
• Schema markup: structured data (LocalBusiness, Service, FAQPage) that tells Google what you do and where you serve
• Entity building: press releases, authoritative citations (industry associations, licensing boards), brand consistency across all platforms

Every action maps to a five-phase SEO process, adapted for Vancouver market realities.

What's It Costing You NOT To Have This?

Inverted perspective: what's it costing you right now to not have this system running?

Cost 1: Silent lead loss. Most website visitors leave without contacting you. Run your own numbers: if 500 people visit a month and 2% get in touch, that's 10 leads. Lift that to 5% with faster, automated follow-up and it's 25 leads from the same traffic. Your real rates will differ; the point is that follow-up speed changes the math.

Cost 2: Invisible content. If you're not publishing fresh, keyword-targeted content, Google has fewer reasons to send you new traffic, and competitors who publish consistently gain ground page by page.

Cost 3: Wasted ad spend. Paid traffic sent to a slow website with no clear call to action leaks money, and when the ads stop, the leads stop. SEO builds an asset that keeps producing leads long after the initial investment.

Cost 4: Owner burnout. You're writing blog posts at 10 PM, responding to leads on your lunch break, manually checking rankings on Saturday morning. That's not running a business. That's being trapped in one. The hours automation gives back are time with your family, time on strategy, and time on actual revenue growth.

How The System Actually Works (Behind The Scenes)

I'm transparent about infrastructure because I think it matters. Here's the real architecture:

Data layer: each client's system connects to Google Search Console, GA4 and the website's CMS. Fresh data is pulled daily: keyword positions, CTR, impressions, site errors and traffic patterns.

Intelligence Layer: Purpose-built SEO analysis (not just ChatGPT) examines incoming data and makes decisions. Which keywords are in strike distance? Which pages have declining CTR? What content gaps exist? What internal link opportunities are missing? This is domain-specific decision logic that generic AI doesn't have.

Execution layer: when an opportunity is identified (for example, a keyword ranking at position 12 with 400 monthly searches and no dedicated page), the system triggers content generation. Research comes from a keyword data API: real search volume, People-Also-Ask questions, competitor content gaps. Structure follows my content protocol. Quality gates filter out generic AI language before anything publishes.

Quality control: automated checks for word count, readability, originality, internal linking, FAQ inclusion and E-E-A-T compliance. Failures are flagged for manual review, and a person approves content before it goes live.

Distribution: after publishing, the system triggers social posts, Google Business Profile updates and internal link updates. Everything feeds back into the keyword strategy for the next cycle.

This is what I mean by a system, not a campaign.

Five Questions to Ask Before Hiring Me (Or Anyone)

1. "Can you show me the actual system, not a pitch deck?" If they can't walk you through the technical infrastructure, data flow, failure modes, and quality gates, they don't have a system. They have a service offering.

2. "What KPIs will you report on, and how often?" Vague answers ('improve your online presence') are red flags. You want specifics: organic traffic growth %, ranking changes by keyword, lead volume, cost-per-acquisition, revenue attribution. Monthly minimum. If they can't quantify it, you can't manage it.

3. "What happens to my content and data if I stop working with you?" You should own everything—your website, content, analytics access, CMS, keyword rankings, reports, your entire data history. If a consultant holds data hostage or locks you into a proprietary platform, walk away.

4. "How do you quality-control AI-generated content?" Anyone can generate 50 blog posts in a day. The question is whether they rank, stay accurate, and add genuine value. Ask about their quality gates. Ask to see a sample article and the gates it passed.

5. "What's your exit policy?" Legitimate consultants aren't afraid of this question. Lock-in contracts with no guarantees are relics of the old agency model. You should be able to stop working together anytime, transfer your systems, and keep all your assets.

I built my practice around answering these questions upfront.

Will AI Replace Human Expertise in SEO?

No. AI replaces tasks, not thinking. With the right system, a first draft that used to take most of a day becomes a review job. That freed time? I spend it on strategy: deciding which keyword to target, what angle to take, how the article connects to revenue pages, whether the data is accurate, and what internal link structure will build authority over time.

Many AI automation shops skip strategy. Without real SEO experience, it's easy to miss the connection between keyword selection, content structure, internal linking and conversions, and to throw content at the wall hoping Google ranks it.

AI tools work best with human oversight and domain expertise behind them. That's the model I operate.

Who Do I Work With?

Owner-led small and medium-sized businesses.

Industries I've worked in:

• Home building and renovation
• Tree care
• Pediatric therapy and dental practices
• Short-term rental co-hosting
• Wine, manufacturing, marketing and compliance-driven businesses

The SEO fundamentals don't change, but keywords, competitors, and content angles do.

If you run a service business in Vancouver, the Fraser Valley, or BC and want to understand what an AI-powered SEO system could look like for your vertical, the next step is a conversation.

You can reach me at FrankYao.com/contact. No obligation. No hard sell. Just a direct conversation about where you are now, where you want to be, and whether this system is the right fit.

---

Frequently Asked Questions

Does Frank Yao only work with Vancouver businesses? No. I'm based in Vancouver, and AI automation and SEO are delivered remotely, so geography doesn't limit the system. What matters is that your business serves a defined market and has a website we can optimize.

How long before I see results? It depends on your market, your site's starting point and how competitive your keywords are. Local and long-tail pages usually move before competitive head terms. SEO is a compounding investment: the longer the system runs, the more valuable it becomes, and unlike paid ads, organic traffic doesn't disappear when you stop paying.

What's the difference between FrankYao.com and Zealous Digital? FrankYao.com is my personal consulting brand for strategy, audits and AI implementation work with business owners. ZealousSEO.com is Zealous Digital, the full-service SEO operation I built. Think of FrankYao.com as the strategist and Zealous as the execution team.

How much does it cost? Every engagement is scoped to your situation. A strategy session and audit is different from a full build with ongoing management. Start with a conversation: I'll look at where you are, identify the highest-impact opportunities, and show you what an engagement would involve before you commit to anything.

Related: For more on this, see Can Small Businesses With Limited Budgets Use AI Automation Effectively?.