Central Window Cleaning · KPI Dashboard

Date Range

Last 7 days Last 30 days Last 90 days

→

Markets

All Locations Cleveland (All)Pittsburgh Columbus Cincinnati Toledo (Suburban)Indianapolis Akron Dayton

Drill-downs:Cleveland Central Cleveland East Cleveland South Cleveland West Fort Wayne

Some data sources failed:

Call leads sheet: Sheets read failed [429] Columbus!A2:G: { "error": { "code": 429, "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:990896517898'.", "status": "RESOURCE_EXHAUSTED", "details": [ { "@type": "type.googleapis.com/google.rpc.ErrorInfo", "reason": "RATE_LIMIT_EXCEEDED", "domain": "googleapis.com", "metadata": { "quota_location": "global", "quota_limit_value": "60", "quota_unit": "1/min/{project}/{user}", "quota_metric": "sheets.googleapis.com/read_requests", "quota_limit": "ReadRequestsPerMinutePerUser", "service": "sheets.googleapis.com", "consumer": "projects/990896517898" } }, { "@type": "type.googleapis.com/google.rpc.Help", "links": [ { "description": "Request a higher quota limit.", "url": "https://cloud.google.com/docs/quotas/help/request_increase" } ] } ] } }
Form leads sheet: Sheets read failed [429] Columbus!A2:Q: { "error": { "code": 429, "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:990896517898'.", "status": "RESOURCE_EXHAUSTED", "details": [ { "@type": "type.googleapis.com/google.rpc.ErrorInfo", "reason": "RATE_LIMIT_EXCEEDED", "domain": "googleapis.com", "metadata": { "quota_unit": "1/min/{project}/{user}", "quota_limit": "ReadRequestsPerMinutePerUser", "consumer": "projects/990896517898", "quota_location": "global", "quota_metric": "sheets.googleapis.com/read_requests", "service": "sheets.googleapis.com", "quota_limit_value": "60" } }, { "@type": "type.googleapis.com/google.rpc.Help", "links": [ { "description": "Request a higher quota limit.", "url": "https://cloud.google.com/docs/quotas/help/request_increase" } ] } ] } }

PPC Performance Summary — Columbus

vs. 2026 ago: same 2026-04-01 → 2026-04-30 window prior year

Ad Spend

$1,577.47new

Total Leads

Cost Per Lead

—

Spend ÷ (forms + calls)

Click → Lead

0.0%

Leads ÷ Clicks

Avg CPC

$2.36

Year to Date — Columbus

Spend YTD

$1,829.41

Jan 1 → 2026-04-30

Leads YTD

Calls + form submissions

CPL YTD

—

Spend ÷ leads · year to date

Lead Quality

Form Submissions

Phone Calls

Calls Answered (Ads+LSA)

100%

26/26 from CallRail

Avg Call Duration

2m 21s

CallRail (all channels)

Clicks

668

8.55% CTR

Recent Form Leads

No form leads in this period.

Recent Call Leads

No call leads in this period.

Ad Spend Over Time

2026-04-01 → 2026-04-30

Cost Per Lead Over Time

Lower is better

No CPL data in this period.

Leads Over Time

Calls + form submissions

No leads in this period.

YoY Monthly Comparison

Last 6 months · this year vs prior year

Orange = current year · Black = prior year

Spend vs. Budget Pacing

Columbus · daily budget from Google Ads

Daily

$25

Weekly

$175

Monthly

$750

Selected period · 2026-04-01 → 2026-04-30

Ahead of pace (overspending) · +110%

$1,577 actual$750 expected

Week to date

$0 actual$100 expected

Month to date

$1,577 actual$750 expected

Search Campaign Health

Search Impression Share

11.6%

% of available impressions captured

Lost IS — Budget

17.7%

Demand missed due to underspend

Lost IS — Rank

71.0%

Demand missed due to ad rank

Quality Score Distribution

Keywords by QS 1–10

Quality Score data not available.

Spend by Match Type

Broad / Phrase / Exact

CallRail Health — Live (Winsor)

Sheets remain the source of truth for CPL · CallRail powers call quality + LSA

Total Calls

Answered

94%

76/81

Missed / Abandoned

1 calls

Voicemail

5% of calls

First-time Callers

67%

54 unique

LSA Calls

Google Guaranteed

Calls by Channel

From CallRail source_name

Year-to-Date & Trend — Columbus

YTD: 2026-01-01 → today

YTD Spend

$1,829.41

YTD Leads

—

Calls + Forms

YTD CPL

—

YTD Spend ÷ YTD Leads

6-Month CPL Trend

Bars = leads · Line = CPL

Not enough data — switch to a single market to populate.

Call Volume Heatmap

Day-of-week × hour · CallRail (current view)

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Less

MoreTimes shown in UTC

Top Caller Cities

From CallRail customer location

City	State	Calls	Answered
Columbus	OH	33	85%
Cincinnati	OH	6	100%
Willoughby	OH	5	100%
Dublin	OH	3	100%
Barker	TX	3	100%
Dayton	OH	2	100%
Lancaster	OH	2	100%
Coshocton	OH	2	100%
Fond Du Lac	WI	1	100%
Canal Winchester	OH	1	100%
Plain City	OH	1	100%
Covington	GA	1	100%
Kent	OH	1	100%
Tinley Park	IL	1	100%
Tampa	FL	1	100%

Lead Mix

Calls vs form submissions

No data.

Project Type

From form submissions