CASE FILE 09CLIENT GENERALISEDALL DATA MOCKED

Local SEO tied to real cases.

A law firm with five offices had its data spread across four Google tools. This project brought it together and connected search rankings to actual phone calls and case inquiries.

CLIENTLAW FIRM NETWORK
MODELLOCAL SEO → CASE INQUIRIES
STACKGSC · GBP · GA4 · ADS · LOOKER
ENGAGEMENT5 PHASES · FULL SYSTEM
STATUSLIVE · AUTOMATED
THE BOARD — OVERVIEWAI-BUILT · LIVE HTML
EXHIBIT A
1

The map shows demand around each office — the ringed dots are the offices.

2

The list ranks important keywords with their current Google position.

3

The bottom strip shows reviews, calls and directions for the month.

The Brief

Four tools, five cities, no clear picture.

Search Console said one thing, the Business Profiles said another, and the website analytics said a third — for every city. Nobody could connect a ranking change to a phone that rang.

We brought all four data sources together, office by office, and connected them to contact forms and calls. SEO work is now judged by inquiries, not impressions.

THE GOAL: one report that answers “which office, which keyword, which case?”

✗ THE PROBLEMS

  • ✗ Rankings tracked, phone calls untracked
  • ✗ GBP interactions siloed per location
  • ✗ Reviews grew but impact unmeasured
  • ✗ Branded traffic inflating SEO reports
  • ✗ PPC assist invisible next to organic
The System

How the system works.

Search Console, Business Profile, website and ads data are combined for each office. The dashboard shows rankings, calls, reviews and inquiries per city, with alerts for ranking drops.

GSC + Rankings

Branded vs non-branded, positions by city.

Google Business Profiles

Calls, directions, messages — per office.

→

GA4 + Google Ads

Site behaviour + PPC assist.

→

Models

Office-level demand, review impact, lead source joins.

→

Looker Studio

Map + rankings + reputation, then per-office deep dives.

→

Action Layer

Ranking-drop and review-velocity alerts.

The Process

The process, step by step.

01

Audit

  • Split branded harvest from real organic growth
  • Benchmarked GBP actions per office vs market
02

Measurement Plan

  • Case-type taxonomy for lead classification
  • Position bands (top-3 / page-1) as shared language
03

Implementation

  • GSC + GBP + GA4 + Ads unified per office
  • Lead-source joins to contacts
04

Dashboard Build

  • Demand map + ranked-query list as the hero
  • Reputation strip wired to contact volume
05

Automate & Optimise

  • Ranking-drop alerts by city
  • Monthly per-office scorecards, auto-built
The Build

Each office, in detail.

Two more pages: the office scorecard and the alerts page. Built in HTML with sample data.

PAGE 02 / 06 — OFFICESLIVE HTML · MOCK DATA
EXHIBIT B
Office Scorecards

Five offices, same five columns.

  • ■ Every office shows visitors, calls, contacts and average ranking in the same format.
  • ■ Review counts sit next to ranking changes, city by city.
  • ■ The keyword list shows the next move for each target: push, write content, or build links.
PAGE 06 / 06 — ALERTS + AILIVE HTML · MOCK DATA
EXHIBIT C
Automation Layer

Ranking drops trigger action.

  • ■ Rules watch each city’s rankings and reviews daily.
  • ■ Every drop arrives with a drafted plan, not just a red arrow.
  • ■ Wins are tied to calls, so progress is measured in inquiries.
Deliverables

What was delivered.

The Results

The results.

EVERY CITY, SCORED.

Each office has its own clear numbers, easy to compare side by side.

KEYWORDS → CASES.

Keywords are judged by the inquiries they bring, not the impressions they collect.

REVIEWS COUNT.

Review growth is tracked against calls, so its impact is visible.

NOTE: CLIENT DETAILS GENERALISED · ALL NUMBERS ARE SAMPLE DATA · DASHBOARDS ARE HTML RECREATIONS

Next Steps

Want this for your business?

If your locations live in four different tools, this report brings them together.

★ Book a call →View live dashboard ↗Next case →← All cases