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] Pittsburgh!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_limit_value": "60", "quota_unit": "1/min/{project}/{user}", "quota_metric": "sheets.googleapis.com/read_requests", "consumer": "projects/990896517898", "quota_limit": "ReadRequestsPerMinutePerUser", "quota_location": "global", "service": "sheets.googleapis.com" } }, { "@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] Pittsburgh!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": { "consumer": "projects/990896517898", "quota_limit": "ReadRequestsPerMinutePerUser", "quota_unit": "1/min/{project}/{user}", "quota_metric": "sheets.googleapis.com/read_requests", "quota_location": "global", "quota_limit_value": "60", "service": "sheets.googleapis.com" } }, { "@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 — Pittsburgh

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

Ad Spend

$1,816.34new

Total Leads

Cost Per Lead

—

Spend ÷ (forms + calls)

Click → Lead

0.0%

Leads ÷ Clicks

Avg CPC

$1.97

Year to Date — Pittsburgh

Spend YTD

$2,242.32

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)

94%

29/31 from CallRail

Avg Call Duration

2m 14s

CallRail (all channels)

Clicks

923

2.65% 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

Pittsburgh · daily budget from Google Ads

Daily

$20

Weekly

$140

Monthly

$600

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

Ahead of pace (overspending) · +203%

$1,816 actual$600 expected

Week to date

$0 actual$80 expected

Month to date

$1,816 actual$600 expected

Search Campaign Health

Search Impression Share

12.9%

% of available impressions captured

Lost IS — Budget

7.7%

Demand missed due to underspend

Lost IS — Rank

79.5%

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

124

Answered

89%

110/124

Missed / Abandoned

3 calls

Voicemail

9% of calls

First-time Callers

64%

79 unique

LSA Calls

Google Guaranteed

Calls by Channel

From CallRail source_name

Year-to-Date & Trend — Pittsburgh

YTD: 2026-01-01 → today

YTD Spend

$2,242.32

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
Pittsburgh	PA	57	81%
Washington	PA	6	100%
Syracuse	NY	4	100%
Greensburg	PA	3	100%
Carnegie	PA	3	67%
Willoughby	OH	3	100%
Liverpool	NY	2	100%
Penn Hills	PA	2	100%
Erie	PA	2	100%
Richmond	VA	2	100%
Coraopolis	PA	2	100%
Bridgeville	PA	2	100%
Leechburg	PA	2	100%
Lorain	OH	2	50%
Slippery Rock	PA	1	100%

Lead Mix

Calls vs form submissions

No data.

Project Type

From form submissions