Analyst and Developer

Sushi One Raleigh — Full Stack Digital Growth

Aug 2024 — Dec 2025

SEOAutomationLocal BusinessWeb

Visual Work

food_01.jpg
food_02.jpg
food_03.jpg
food_04.jpg
food_05.jpg
food_06.jpg

Drop food photos into /public/sushi-one/ and video into /public/sushi-one/hero.mp4

Challenge

THEVHOUSE LLC needed a full digital presence built from zero: no website, no search visibility, no review management system. The engagement covered web design, SEO infrastructure, and operational automation across 16 months.

Methodology

Phase 1 — Web Foundation Built a 29-page Wix/Velo (React) site with LocalBusiness JSON-LD schema, mobile-first architecture (80% of traffic is mobile), and structured navigation for both human visitors and search engine crawlers.

Phase 2 — SEO Infrastructure Implemented keyword targeting across local intent queries, optimized Google Business Profile, and built a citation strategy for local pack visibility. Tracked performance through GA4 and Google Search Console with monthly Looker Studio reporting.

Phase 3 — Automation Layer Deployed n8n workflows to reduce manual review response time by 85%. Owner freed from daily repetitive tasks that previously consumed 45 minutes per morning.

Key Findings

| Finding | Business Logic | Actionable Implication | |---|---|---| | Position 18.5 to 10.5 average | Crossing position 10 threshold increases click probability by 3x | Top 10 ranking for core queries is the single highest-leverage SEO milestone for local businesses | | 80% mobile traffic | Restaurant searches happen on phones in the moment of intent | Mobile Core Web Vitals directly determine whether the site appears in local pack results | | 85% review response time reduction | Google's algorithm weights review response recency | Automation converts a manual burden into a ranking signal without owner time investment |

Results and Impact

  • 340,166 total organic impressions over 16 months (verified GA4)
  • 12,696 organic clicks generated
  • Average search position improved from 18.5 to 10.5
  • 85% reduction in review response time via n8n automation
  • 15% revenue growth opportunity identified through Qualtrics pricing survey (50+ menu items, SPSS modeling)

Tools Used

Wix/Velo (React), GA4, Google Search Console, Looker Studio, n8n, Qualtrics, SPSS

What I Would Do Differently

Deploy a dedicated catering landing page earlier. The catering query ranked at position 56 throughout the engagement — a targeted page with local intent copy could have moved that into top 10 within 90 days and opened a higher-margin revenue channel.