Brightwood Collision Center
Marketing Performance Dashboard
★ The Big Picture — Everything We're Driving
$3.97
Cost per Conversion · July
186.50 conversions in July at $3.97 each — 61.96% conversion rate · held clean under the Google rep's $750 budget cap ($740.16 actual).
2,785
Local Interactions · 7 mo
Google Business Profile drove 2,785 actions (Dec 2025 – Jun 2026) — including 1,604 direction requests — at $0 ad cost. June +33.9% YoY. July GMB pull pending.
301
Ad Clicks · July
From $740 in July ad spend: 301 clicks, 30 phone calls (96.7% pickup), 186.50 conversions. CPC dropped $3.23 → $2.46 after Google-rep optimizations.
📅 All Channels — Results by Date Range
—
★ Across All Channels — High-Level Performance
Snapshot of every channel at a glance. Click any "View detail" link to jump to that tab.
🎯 Channel Mix — Where the Pipeline Comes From
Google Ads spent $2,724 across May–July to drive 571.50 conversions (May 193 · June 192 · July 186.50) at a blended $4.77 cost/conv. July was the cleanest month yet on efficiency — $740 spend under the Google-rep budget cap, CPC down $3.23 → $2.46, and P-Max cost/conv dropped from $3.80 → $3.03 after the audience-signal + video-asset work with the rep. Liberty Mutual recovered from June's collapse (1 conv at 2.7%) back to 5.01 conversions at 18.54% — a Responsive Search Ad rebuild is the next lever before the call-asset deprecation lands.
Sales lifetime ROI is the headline: $129,867 in closed revenue across 35 jobs traceable to ad-driven leads — the July CSI customer list was reconciled against the July CallRail log and picked up 2 fresh matches ($11,952.85): Guadalupe Castro (2022 Honda · GEICO Marine · $7,778.51) from a Jul 7 Insurance-focus call, and Nicholas Kreckler (2013 Toyota · State Farm · $4,174.34) from a Jul 23 Liberty Mutual call. On the broader July book of business (whether or not ad-attributed), Brightwood closed 111 ROs for $409,547 in July — Tesla is 41% of revenue ($168,521 across 31 vehicles), and State Farm remains the top carrier ($96,696 across 33 claims).
Local Search generates 2,785 GMB interactions at $0 across 7 months, with direction requests dominating (1,604) — most local searchers want to drive over, not call. June came back strong (+33.9% YoY overall, +45.5% direction requests).
SEO is still in the build phase (Authority Score 9, 255 organic users) but keyword count is up 25%, signaling expanding footprint.
Combined, the brand is running a high-efficiency funnel: paid ads + GMB capture local intent, sales conversion ratios are exceptional, and organic is starting to compound.
📅 Advertising — Results by Date Range
—
💰
Total Spend
$740.16
Jul · under $750 rep cap
💵
Avg CPC
$2.46
Down from $3.23 in Jun
🖱️
Clicks
301
Jul · essentially flat vs Jun (310)
📊
CTR
2.64%
301 ÷ 11,400
👁️
Impressions
11,400
+16% vs Jun (9,815)
📞
Phone Calls
30
Jul · 29 received + 1 missed
🎯
Conversions
186.50
$3.97 cost/conv · 61.96% rate
★ Top Insight · July 2026 Final Numbers
$3.97 per conversion in July on $740.16 spend — held cleanly under the rep-agreed $750 cap while delivering 186.50 conversions at a 61.96% conv rate. DS - Insurance Carrier Focus (P-Max) is now the star at $3.03 cost/conv, 61.89% conv rate — the audience-signal + video-asset uploads with the Google rep clearly worked (+16% impressions on lower CPC). DS - General Campaign held steady at $4.71 cost/conv / 70.99% conv rate. Liberty Mutual recovered from Jun's collapse (1 conv / 2.70%) to 5.01 conversions at 18.54% — still weak vs the others, but heading the right direction while we wait on the Responsive Search Ad rebuild for the call-asset deprecation. ⚠ Store visit tracking has been offline since Jul 15 — Google rep flagged this as the top data-integrity issue for August.
🤝 Google Rep Collaboration 2 STRATEGY CALLS · JUL 2026
We've been running weekly optimization sessions with our assigned Google Ads rep throughout July — pushing on Performance Max compliance, keyword hygiene, and locking in strict budget guardrails so nothing runs away.
📞 Call 1 · Campaign Updates & Decisions
Mid-July
Setup work · budget guardrails · learning-phase freeze
- Performance Max audience signals: configured a new "broad audience" segment using local competitor websites as signal — early lift already showing in the +16% Jul impressions vs Jun.
- Ad assets + policy: uploaded video assets (horizontal, vertical, square) and updated the display URL to resolve ad-strength issues. Confirmed the "Brightwood Collision Center" policy notice is a template issue — no delivery impact.
- Keyword hygiene: removed redundant keywords that were creating internal auction conflicts while keeping the original targeting parameters intact.
- Budget guardrails locked in: maintained the strict $750/mo cap, dismissed spending recommendations, and turned OFF auto-apply for anything that would add new keywords or raise limits. Auto-apply remains ON for CPA-improving changes.
- Store visit goal: enabled account-level store visit tracking for a 14-day evaluation window (measuring foot traffic without disrupting call tracking).
- 14-day learning phase freeze: paused further manual campaign changes for 14 days to let the Google Ads algorithm complete its learning phase cleanly.
- Google Analytics 4: refreshed admin settings + created a new "contact" key event to track form submissions alongside phone calls.
- Account linking: initiated GA4 ↔ Google Ads link — pending account-owner approval.
📞 Call 2 · Strategy & Ad Relevance
Late July
Q1/Q3 seasonal peak · P-Max compliance · conversion-tracking recovery
Executive summary from the rep: primary objective remains store visits + high-intent phone calls, working around the Q1/Q3 seasonal demand peak. Focus this session was on ad relevance, resolving Performance Max compliance issues, and a plan to fix store visit metrics that have been offline since Jul 15.
- Insurance lead filtering: we discussed unwanted leads from big carriers (State Farm, Progressive). Broad negative-keyword exclusions would hurt impression share too much — recommendation is to filter at the website copy level instead, letting users self-select.
- Ad Strength & technical optimizations: applied dynamic keyword insertion across the active ad groups to lift headline relevance and pull CPC trends downward (visible in July: CPC dropped from $3.23 → $2.46).
- 14-day optimization freeze: agreed to a 14-day stabilization period with no manual campaign adjustments so the algorithm can properly evaluate the changes from Call 1.
📋 Action items for Jordyn (open)
- Backend site access: reach the owner to confirm full backend / tag-manager access so we can resolve store visit + contact form tracking.
- Site links: add descriptions to existing site links (e.g. "Free Estimate") · maintain ≥6 active site links per campaign.
- Liberty Mutual RSA rebuild: new Responsive Search Ad with keyword insertion + updated headlines + site links, in prep for the upcoming call-asset deprecation.
- Performance Max fixes: resolve business-name policy violation · upload square / vertical / horizontal video assets to lift asset-group strength.
Efficiency Trends — Are Ads Getting More or Less Efficient Over Time?
Healthy trend: CTR / Conv Rate rising while CPC / CPL stay flat or fall — you're paying less per result.
Warning trend: CPC / CPL climbing while CTR / Conv Rate fall — auction is getting more expensive and audience quality is dropping.
CTR vs Avg CPC
—
Click-through rate (left axis, %) vs cost per click (right axis, $) by month
—
Conversion Rate vs CPL
—
Conversion rate (left axis, %) vs cost per lead (right axis, $) by month
—
Campaign Performance JULY 2026 SNAPSHOT
Campaigns below reflect July 2026. Per-month campaign splits will populate this section automatically once the master sheet tracks them historically.
Spend by Campaign
Where your budget is going
Conversions by Campaign
Which campaign delivers leads
Campaign Snapshot
| Campaign | Type | Clicks | Impr. | CTR | CPC | Spend | Conv. | Cost/Conv | Conv Rate |
|---|---|---|---|---|---|---|---|---|---|
| DS - Insurance Carrier Focus | P-Max | 143 | 6,442 | 2.22% | $1.88 | $268.47 | 88.50 | $3.03 | 61.89% |
| DS - General Campaign - Calls v1 | Search | 131 | 3,322 | 3.94% | $3.34 | $438.01 | 92.99 | $4.71 | 70.99% |
| Liberty Mutual Campaign | Search | 27 | 1,636 | 1.65% | $1.25 | $33.68 | 5.01 | $6.73 | 18.54% |
Search Keyword Insights
Top Search Terms · —
Aggregated across the selected date range · Top 10 of the union
| Keyword | Clicks | Impr. | Spend | Conv. | Cost / Conv. |
|---|---|---|---|---|---|
| Adjust the date range above to load keywords. | |||||
Conversion Actions & Call Activity
Conversions by Action Type
How customers connect with you
Phone Call Activity
30 calls from ads in July · 29 received + 1 missed (96.7% pickup)
29
Received
1
Missed
Daily Calls Activity
Calls Per Day · Jul 1 – 31
Steady 2-call cadence — 12 different days each landed 2 calls (Jul 3 · 8 · 10 · 13 · 14 · 20 · 22 · 23 · 27 · 28 · 30 · 31). 1 missed on Jul 31 at 11 AM — the first missed ad call of the campaign lifetime.
Recent Calls
| Date / Time | Campaign | Status | Duration | Caller |
|---|---|---|---|---|
| Jul 31 · 1:00 PM | Insurance | Received | 51s | +1 480-278-5275 |
| Jul 31 · 11:00 AM | Insurance | Missed | 0s | — |
| Jul 30 · 1:00 PM | General | Received | 1m 14s | +1 480-710-5484 |
| Jul 30 · 12:00 PM | Insurance | Received | 2m 40s | +1 602-820-9196 |
| Jul 28 · 8:00 AM | General | Received | 1m 36s | +1 623-250-8434 |
| Jul 28 · 7:00 AM | Insurance | Received | 2m 52s | +1 480-682-7942 |
| Jul 27 · 9:00 AM | Insurance | Received | 5m 17s | +1 323-416-8791 |
| Jul 27 · 9:00 AM | Liberty Mutual | Received | 4m 2s | +1 480-215-9232 |
| Jul 26 · 2:00 PM | Insurance | Received | 19s | +1 615 · — |
| Jul 23 · 1:00 PM | Liberty Mutual | Received | 2m 22s | +1 480-313-6335 |
| Jul 23 · 11:00 AM | Insurance | Received | 3m 55s | +1 323-416-8791 |
| Jul 22 · 2:00 PM | Insurance | Received | 5m 28s | +1 480-682-7942 |
| Jul 22 · 11:00 AM | General | Received | 1m 1s | +1 510 · — |
| Jul 20 · 3:00 PM | General | Received | 2m 10s | +1 602-245-2259 |
| Jul 20 · 1:00 PM | General | Received | 4m 23s | +1 602-245-2259 |
| Jul 17 · 7:00 AM | Insurance | Received | 4s | — |
| Jul 15 · 2:00 PM | General | Received | 28s | +1 480-600-8255 |
| Jul 14 · 2:00 PM | Liberty Mutual | Received | 3m 50s | +1 480-682-7942 |
| Jul 14 · 11:00 AM | Insurance | Received | 1m 40s | +1 360 · — |
| Jul 13 · 2:00 PM | Liberty Mutual | Received | 3m 42s | +1 602 · — |
| Jul 13 · 9:00 AM | General | Received | 2m 33s | +1 360-590-0973 |
| Jul 10 · 1:00 PM | General | Received | 2m 11s | +1 714-851-7828 |
| Jul 10 · 12:00 PM | General | Received | 2m 12s | +1 714-851-7828 |
| Jul 9 · 4:00 PM | Liberty Mutual | Received | 1m 4s | +1 602-684-1688 |
| Jul 8 · 12:00 PM | Insurance | Received | 2m 13s | +1 480 · — |
| Jul 8 · 9:00 AM | General | Received | 1m 5s | +1 206-293-0387 |
| Jul 7 · 9:00 AM | Insurance | Received | 45s | +1 480-925-4041 |
| Jul 3 · 2:00 PM | General | Received | 7s | — |
| Jul 3 · 2:00 PM | General | Received | 5s | — |
| Jul 2 · 4:00 PM | Insurance | Received | 3m 44s | +1 360-590-0973 |
💵 Sales — Results by Date Range
—
🎯 Most Recent Sales — Excluding State Farm / GEICO / USAA THE ADS-CREDIT POOL
The ad-attributed jobs Brightwood credits to marketing rather than DRP steering — newest first, big-carrier work stripped out. This is the list to look at when asking "what has marketing actually brought in lately?"
⏱ Read This First · 67-Day Gap
The most recent non-DRP ad-attributed sale closed June 12, 2026 — the $12,046 Tesla Insurance job, still the single biggest job in this pool. Every attributed job since then (4 of them, Jun 15 → Jul 31) has been State Farm or GEICO.
That does not mean non-DRP work dried up at the shop — July alone had 26 ad-addressable ROs worth $70,613. None of them phone-matched a tracked ad call, which points at an attribution gap rather than a demand gap: those customers likely came through GMB, organic, or word of mouth, or submitted a web form that bypasses the tracked number.
That does not mean non-DRP work dried up at the shop — July alone had 26 ad-addressable ROs worth $70,613. None of them phone-matched a tracked ad call, which points at an attribution gap rather than a demand gap: those customers likely came through GMB, organic, or word of mouth, or submitted a web form that bypasses the tracked number.
✅ Non-DRP Ad-Attributed · Newest First
28 jobs · $80,985 lifetime
Tesla Insurance, Root, Customer Pay, and other non-DRP carriers
| Service Date | Carrier | Revenue | Days Ago |
|---|---|---|---|
| Jun 12, 2026 lead May 22 |
Tesla Insurance | $12,045.64 | 67 |
| Apr 27, 2026 lead Apr 16 | Unknown | $323.00 | 113 |
| Apr 22, 2026 lead Apr 20 | Customer Pay | $4,159.89 | 118 |
| Apr 13, 2026 lead Apr 10 | Unknown | $456.43 | 127 |
| Apr 7, 2026 lead Apr 7 · same day | Root Insurance | $7,533.11 | 133 |
| Feb 4, 2026 lead Jan 7 | Unknown | $100.00 | 195 |
| Jan 26, 2026 lead Jan 20 | Customer Pay | $1,603.77 | 204 |
| Jan 12, 2026 lead Aug 12 · 5-mo cycle | Customer Pay | $3,277.34 | 218 |
Showing the 8 most recent of 28. Full list in the All Ad-Attributed Sales table below — use the Hide Big-Carrier toggle there to filter it the same way.
🛡️ What Came In Instead · Big-Carrier
7 jobs · $48,882
Every attributed job since Jun 12 has landed here
| Service Date | Carrier | Revenue | Days Ago |
|---|---|---|---|
| Jul 31, 2026 | State Farm | $4,174.34 | 18 |
| Jul 14, 2026 | GEICO Marine | $7,778.51 | 35 |
| Jun 23, 2026 | State Farm | $13,523.70 | 56 |
| Jun 15, 2026 | GEICO | $6,446.59 | 64 |
| Jun 12, 2026 | ← last non-DRP | $12,045.64 | 67 |
| Jun 9, 2026 | State Farm | $8,781.29 | 70 |
| Jun 9, 2026 | GEICO | $2,960.81 | 70 |
The dashed line marks where the non-DRP pool stops. Not necessarily bad news — big-carrier jobs still came through the tracked ad line — but it's why the conservative Brightwood View has been flat since June.
📅 July 2026 · CSI Snapshot FULL MONTH · ALL CHANNELS
Every closed RO in the July CSI export — split by where the client believes the lead actually came from. Big-carrier DRP networks (State Farm, GEICO variants, USAA variants) push work directly to Brightwood via their referral systems and don't count as ad-attributable per your feedback. Non-DRP carriers, Customer Pay, and no-carrier ROs are the pool where ads, GMB, and organic could plausibly be driving demand.
💰
July Revenue · Total
$409,547
111 closed ROs · $3,690 avg
🛡️
Big-Carrier DRP
$338,934
85 ROs · 82.8% · NOT ad-attributable
🎯
Ad-Addressable Pool
$70,613
26 ROs · 17.2% · non-DRP + Customer Pay + walk-in
🆕
New July Intakes
85 / 111
$236,156 revenue · vs. 26 carry-over ($173,392)
Attribution Split — Where Does the Client Say Leads Come From?
🛡️ Big-Carrier DRP · Not Ad-Attributable
$338,934 · 82.8%
Insurance Direct-of-Repair network referrals — comes from State Farm, GEICO, USAA apps + adjusters, not marketing
| Carrier | ROs | Revenue |
|---|---|---|
| State Farm | 33 | $96,696 |
| GEICO Advantage | 6 | $45,903 |
| GEICO Secure | 11 | $42,587 |
| GEICO Casualty | 9 | $41,068 |
| GEICO (base) | 5 | $32,152 |
| USAA Casualty | 6 | $21,576 |
| Garrison / USAA subsidiary | 5 | $17,339 |
| USAA General Indemnity | 2 | $14,474 |
| GEICO Marine | 2 | $8,117 |
| United Services / USAA | 2 | $7,496 |
| Other GEICO variants | 4 | $11,527 |
| Total Big-Carrier DRP | 85 | $338,934 |
🎯 Ad-Addressable Pool · $70,613 / 17.2%
26 ROs
Non-DRP carriers + Customer Pay + walk-ins — the revenue pool where ads, GMB, and organic could plausibly be driving demand
| Source | ROs | Revenue |
|---|---|---|
| The Doan Group | 1 | $21,588 |
| Progressive | 4 | $18,142 |
| MAPFRE Insurance | 1 | $5,662 |
| American Economy | 1 | $3,600 |
| Hartford Ins. of the SE | 1 | $1,750 |
| Customer Pay | 6 | $12,222 |
| Walk-in / no carrier listed | 12 | $7,649 |
| Total Ad-Addressable | 26 | $70,613 |
At $740 July ad spend, capturing even one Doan Group or Progressive-sized job pays for the whole month of ads several times over.
New This Month vs Carry-Over From June
Splits every RO by the Vehicle-In date. Vehicles that drove into the shop in July are "new July intakes." Vehicles with a June (or earlier) drop-off that closed in July are carry-over jobs — revenue lands in July but the acquisition happened in June.
🆕 New July Intakes
85 vehicles · $236,156
Vehicles that came in during July · 57.7% of the July book
Big-DRP
65 · $211,317
Insurance-network pushed
Non-DRP
20 · $24,838
🎯 Highest-signal ad-attribution pool
🔄 Carry-Over From June
26 vehicles · $173,392
Vehicles that came in before July · 42.3% of the July book
Big-DRP
20 · $127,617
June-booked DRP jobs
Non-DRP
6 · $45,775
Doan Group (Delta Diversified etc.)
🎯 Ad-Attributed Matches from July's Call Log
Cross-referencing all 30 July ad calls against the 111 July ROs, 2 exact phone matches — both landed on big-carrier DRP claims, so per your read they'd credit the carrier's network, not the ads:
📞 Jul 7 · Insurance Focus (P-Max)
Guadalupe Castro 🔄 Carry-Over
2022 Honda · GEICO Marine · RO 15165
$7,778.51 revenue · in Jun 30, out Jul 14 · big-DRP carrier
$7,778.51 revenue · in Jun 30, out Jul 14 · big-DRP carrier
📞 Jul 23 · Liberty Mutual
Nicholas Kreckler 🆕 New Intake
2013 Toyota · State Farm claim · RO 15264
$4,174.34 revenue · in Jul 21, out Jul 31 · big-DRP carrier
$4,174.34 revenue · in Jul 21, out Jul 31 · big-DRP carrier
Both matches added to the Lifetime Sales list below · lifetime ad-attributed revenue climbs from $117,914 → $129,867 across 35 jobs. Zero of the 26 ad-addressable July ROs had a phone match to a July ad call — worth flagging: either those buyers found Brightwood via GMB / organic / word-of-mouth, or the call tracking isn't capturing every touchpoint (some website-form submissions bypass the call-tracked number).
💎 Value Trend · 14-Month CAC + ROAS JUN 2025 → JUL 2026
What Brightwood invests every month ($1,500 Damaris retainer + Google ad spend) vs. the revenue that traces back to ad-driven leads. Includes both the full-attribution view (all 35 CSI-matched jobs) and a conservative view that strips big-carrier DRP wins (State Farm, GEICO variants, USAA variants) — the same lens the client uses.
🎯 Two Ways to Read the Same 14 Months
Same campaign, same date range — two different attribution rules. Brightwood View (left) counts only work Brightwood credits to ads. Full Campaign View (right) is what the shared Sales Report tab actually totals when every ad-attributed sale is included, big-carrier DRP work and all. Both are honest — they're just different rulers.
BRIGHTWOOD VIEW · PRIMARY
Non-DRP ad-attributed revenue
$80,985
28 jobs across 14 months. Excludes State Farm, GEICO, and USAA work (the shop credits those to DRP steering, not ads). Tesla Insurance is kept — it's a carrier Damaris actively targets ($12,046 from one May 2026 lead).
Avg Sale
$2,892
Loaded CAC
$1,133
Loaded ROAS
2.55×
FULL CAMPAIGN VIEW · REFERENCE
All ad-attributed sales · Sales Report tab
$341,614
Every FIRST-marked sale from the Sales Report tab — 83 attributed jobs (28 non-DRP + 55 big-carrier). Adds $211,747 of State Farm / GEICO / USAA work that came through the ad-tracked call line but that Brightwood attributes to its DRP relationships.
Big-DRP $ Added
$260,629
Loaded CAC
$382
Loaded ROAS
10.77×
Either lens works. Even the conservative Brightwood View (which discounts $260K of big-carrier work) shows every $1 invested comes back as $2.55 — with 28 non-DRP jobs to point at. The Full Campaign View, counting every FIRST sale in the Sales Report tab, is $10.77 per $1 invested across 83 attributed jobs.
📊 CSI-Reconciled Subset · The Detail Behind Both Views
Every KPI, chart, and job in the sections below is drawn from the 35 individual jobs Damaris reconciled from the CSI Customer List against ad-driven leads. This is the granular data source — the two lenses above are just different filters over it (plus the sheet's own additional tracking for the Full View).
📈
Lifetime Invested
$31,722
$10,722 ads + $21,000 Damaris retainer (14 mo × $1,500)
💵
CSI-Reconciled Revenue
$129,867
35 CSI-matched jobs · $3,710 avg ticket
🚀
Reconciled Loaded ROAS
4.09×
Ad-only ROAS: 12.11× · sits between the two lenses above
Cumulative Loaded CAC · Compounding Story
Trending toward efficiency
Loaded CAC = (all ad spend + all retainer) ÷ all attributed jobs, running total. Falls as revenue compounds faster than costs.
Started at $676 in Jun 2025 (first month) · lifted temporarily to $919 during the Feb–Mar 2026 attribution gap (zero CSI matches those months) · settled at $906 as Q2 sales caught up.
Monthly ROAS · Loaded Basis
Volatility is normal
Monthly attributed revenue ÷ that month's total invest ($1,500 retainer + ad spend). Individual months wobble; the trend line is what matters.
Best months: Sep 2025 (13.15×), Nov 2025 (7.67×), May 2026 (6.95×). Weak months: Dec 2025 (0.85×), Jan 2026 (0.73×), Feb/Mar (attribution gap · 0×). Even including the weak stretch, cumulative ROAS held ≥ 3.4×.
Month-by-Month CAC Table
| Month | Ad Spend | + Retainer | Total Invest | Attr. Jobs | Attr. Revenue | Ad-only CAC | Loaded CAC | Monthly ROAS | Cum. ROAS |
|---|---|---|---|---|---|---|---|---|---|
| Jul 2026 | $740 | $1,500 | $2,240 | 2 | $11,953 | $370 | $1,120 | 5.34× | 3.91× |
| Jun 2026 | $1,000 | $1,500 | $2,500 | 2 | $9,407 | $500 | $1,250 | 3.76× | 3.75× |
| May 2026 | $984 | $1,500 | $2,484 | 2 | $17,262 | $492 | $1,242 | 6.95× | 3.74× |
| Apr 2026 | $1,014 | $1,500 | $2,514 | 4 | $12,472 | $253 | $628 | 4.96× | 3.44× |
| Mar 2026 | $731 | $1,500 | $2,231 | 0 | gap | — | — | 0× | 3.43× |
| Feb 2026 | $727 | $1,500 | $2,227 | 0 | gap | — | — | 0× | 3.89× |
| Jan 2026 | $825 | $1,500 | $2,325 | 2 | $1,704 | $413 | $1,163 | 0.73× | 4.37× |
| Dec 2025 | $801 | $1,500 | $2,301 | 2 | $1,948 | $401 | $1,151 | 0.85× | 4.76× |
| Nov 2025 | $448 | $1,500 | $1,948 | 3 | $14,946 | $149 | $649 | 7.67× | 5.61× |
| Oct 2025 | $827 | $1,500 | $2,327 | 3 | $7,905 | $276 | $776 | 3.40× | 5.26× |
| Sep 2025 | $570 | $1,500 | $2,070 | 6 | $27,227 | $95 | $345 | 13.15× | 6.06× |
| Aug 2025 | $764 | $1,500 | $2,264 | 2 | $4,858 | $382 | $1,132 | 2.15× | 3.82× |
| Jul 2025 | $765 | $1,500 | $2,265 | 4 | $9,705 | $191 | $566 | 4.28× | 4.70× |
| Jun 2025 | $527 | $1,500 | $2,027 | 3 | $10,480 | $176 | $676 | 5.17× | 5.17× |
| LIFETIME · 14 MO | $10,722 | $21,000 | $31,722 | 35 | $129,867 | $306 | $906 | 4.09× | 4.09× |
Attribution gaps (Feb + Mar 2026): zero CSI-matched sales those months while ad spend continued at ~$729/mo each. This is almost certainly a tracking gap, not a real zero — those months likely had 2–4 ad-attributed jobs each that never got reconciled against the CSI. If we assumed 3 jobs each at the running $3,000 avg ticket, lifetime ROAS would jump from 4.09× → ~4.66×.
💵 Lifetime Sales REVENUE FROM ADS
Every sale below traced back to a lead from a Google Ads campaign. Toggle the chart below between when the job was completed (Service Month) and when the ad-attributed lead came in (Lead Month).
💵
Lifetime Revenue
—
From ad-attributed sales
🧾
Total Sales
—
Closed jobs
📈
Avg Sale Value
—
Per closed job
🛡️
Top Carrier (Revenue)
—
—
Revenue in Selected Range
💰
Revenue in Range
—
—
🧾
Sales in Range
—
—
🚀
ROAS
—
Revenue ÷ Ad Spend
📅
Period
—
—
Revenue by Service Month
Revenue lands the month the job was completed · in-range months pop, greyed bars sit outside the selected range
Revenue by Insurance Carrier
Where the cash came from — sorted by lifetime revenue
All Ad-Attributed Sales · —
Lifetime list — newest jobs at the top. Scroll for older entries.
| Service Date | Lead Date | Revenue | Carrier |
|---|---|---|---|
| Loading… | |||
Secondary Attributed Sales FULL CAMPAIGN VIEW ONLY
Every FIRST-marked sale from the Sales Report tab that Brightwood attributes to big-carrier DRP steering rather than ads — 48 jobs · $211,747. These sit outside the Brightwood View above but are included in the Full Campaign View's $341,614 total.
Big-carrier FIRST sales — State Farm, GEICO, USAA / Garrison / United Services. Sorted newest first.
| Sale Date | Revenue | Carrier |
|---|---|---|
| Loading… | ||
📅 Local Search — Results by Date Range
—
⭐
Total Interactions
2,785
Dec 2025 – Jun 2026 · 7 months
📞
Calls from Profile
882
Jun: 133 (+34.3% YoY)
📍
Direction Requests
1,604
Jun: 227 (+45.5% YoY)
🌐
Website Clicks
299
Jun: 39 (-9.3% YoY)
★ June bounced back strong · double-digit YoY gains
June 2026 hit 399 total interactions (+33.9% YoY), with calls up 34.3% and direction requests up 45.5% vs June 2025. That's a strong rebound from May's dip (386 interactions, only 61 calls). Only soft spot: website clicks slipped 9.3% YoY — worth a look at how the profile's website CTA is set up. Over 7 months, the Business Profile has driven 1,604 direction requests + 882 calls = 2,486 high-intent actions at $0 ad cost.
7-Month Performance Trend
Profile Interactions Over Time
Dec 2025 – Jun 2026 · All interaction types
Interaction Breakdown
Interactions by Type
Calls · Directions · Website clicks
Monthly Activity Mix
Stacked monthly view by interaction type
Headline Numbers
📞 Calls
From your Business Profile
882
Total Calls
175
Peak Month (Mar)
June bounced back to 133 calls (+34.3% YoY) after May's dip to 61. Mar 2026 still the peak. Spring accident season + June rebound suggests seasonal cadence is working.
📍 Direction Requests
Foot/drive traffic intent
1,604
Total Directions
248
Peak Month (Jan)
June: 227 direction requests (+45.5% YoY) — the standout metric this month. 1,604 lifetime direction requests = 1,604 people who chose to drive to the shop.
🌐 Website Clicks
Lower volume, high intent
299
Total Clicks
55
Peak Month (Jan)
June: 39 clicks (-9.3% YoY) — only interaction type down. Worth checking the website-link CTA setup on the profile · smaller sample so YoY volatility is expected.
Why this Matters for Ads
GMB Drives Ad Conversions Too
Of 189 ad conversions, 162 (86%) were direction requests — same action GMB drives organically
Local search and Google Ads work together. Each ad dollar spent increases impressions for your Business Profile too — and most of those convert as direction requests, not just calls or web clicks.
⚠ Publishing Stopped — And the Numbers Show It
The last post went up June 15. Over the full 90-day window (May 20 – Aug 17) the content did well: 418 views, 23m 33s watch time, 94% of it reaching non-followers. But every one of those views is front-loaded into early June. Look at the trailing 60 days (Jun 19 – Aug 17) and it's 13 views, down 97%, with watch time down 95% and "not enough data" to even populate a recent-posts panel. Nothing is wrong with the content — there simply hasn't been any. Two reels from June are still carrying the entire quarter.
👁️
Views · 90 Days
418 +100%
May 20 – Aug 17 · reels 98.5%
📉
Views · Last 60 Days
13 -97%
Jun 19 – Aug 17 · no new posts
🔥
Non-Follower Reach
94%
6% followers · pure discovery
⏱️
Watch Time
23m 33s
99 three-second views · 0 one-min
💬
Engagement · 90 Days
2
2 reactions · 0 comments · 0 shares
The 90-Day Story · May 20 – Aug 17, 2026
Top Performing Reels
All published Jun 9–15 · still carrying the quarter
| Post | Views | Engagement |
|---|---|---|
| Mon Jun 15, 9:20am · repair detail | 255 | 2 |
| Tue Jun 9, 10:05pm · POV Tesla-certified | 129 | 0 |
| Mon Jun 15, 8:35am · repair detail | 26 | 0 |
| Tue Jun 9, 9:32pm · storefront photo | 6 | 0 |
Two reels produced 92% of all views. The Jun 15 repair-detail reel alone pulled 255 — proof the format works when it ships. The storefront photo pulled 6, confirming what we already knew: reels travel, photos don't.
Content Mix & Reach Quality
Where the views actually came from
98.5%
Views from Reels
1.4%
Views from Photos
94%
Non-Follower Reach
99
3-Second Views
94% non-follower reach is genuinely strong — the algorithm is pushing this content to new people, not recycling it to existing fans. But 0 one-minute views and only 2 total reactions say viewers watch briefly and scroll on. The fix is hooks in the first two seconds and a spoken or on-screen CTA — not more production value.
→ The Recommendation
The data makes the case on its own: four posts in June generated 418 views and 23 minutes of watch time; zero posts since then generated 13. Getting back to a consistent 3–4 reels per week is the single highest-leverage move available on this channel — and at 94% non-follower reach, every post is buying net-new local awareness that costs nothing in ad spend. Recommended cadence: two repair-detail reels, one POV shop clip, one before/after per week.
Platform Detail · Prior Snapshot (Jun 6 – Jul 5)
Platform Snapshot · Last 28 Days
Views by Content Type · Facebook
Content Mix (Views)
Reels vs Photos · 28 days
99% Reels — near-total dominance. Photos got 0.9% of views. If IG rolls out, the same reels can be cross-posted for essentially zero incremental work.
Follower vs Non-Follower Reach
Who is actually seeing the content · 28 days
93.8% non-followers — the algorithm is pushing content beyond the existing follower base. Great top-of-funnel. Converting viewers into follows is the next lever (CTAs in reel captions).
Top Posts · Last 28–30 Days · FB + IG combined
Ranked by views · cross-posted reels appear on both platforms
| # | Posted | Platform · Format | Post | Views |
|---|---|---|---|---|
| 1 | Jun 15 · 9:20 AM | 📘 FB Reel | Car-detail transformation reel (fresh paint, factory-matched) | 252 |
| 2 | Jun 9 · 10:05 PM | 📘 FB Reel | POV: "you finally found a collision center with premium service and Tesla collision certification" 😍 | 128 |
| 3 | ~Jun 15 | 📸 IG Reel | "Fresh paint, factory-matched col..." (cross-post of the #1 FB transformation reel) | 126 |
| 4 | ~Jun 15 | 📸 IG Reel | 🎯 "POV: you finally found a collisi..." (cross-post of the #2 FB Tesla-cert reel) | 120 |
| 5 | ~Jun 22 | 📸 IG Reel | "POV: you almost forgot what your..." (side-swipe damage · IG only) | 112 |
| 6 | Jun 15 · 8:35 AM | 📘 FB Reel | Car-detail reel (companion to Jun 15 morning post) | 24 |
| 7 | Jun 9 · 9:32 PM | 📘 FB Photo | Brightwood Collision shop exterior | 4 |
Cross-posting is working: the Jun 15 transformation reel pulled 252 FB + 126 IG = 378 combined views. The Tesla-cert POV reel pulled 128 FB + 120 IG = 248 combined. Same content, doubled reach for essentially zero incremental effort. IG-only reel ("POV: you almost forgot what your…") pulled 112 views on its own — worth cross-posting to FB too.
Format signal (still): the shop-exterior photo (4 views) sits at 60× less reach than the top transformation reel. Reels are the whole ballgame.
Format signal (still): the shop-exterior photo (4 views) sits at 60× less reach than the top transformation reel. Reels are the whole ballgame.
Content Direction · Recommended Cadence
Facebook (2–3 reels/week): before/after collision transformations, POV shop content ("what happens when you drop your Tesla off"), Tesla-certification proof, community shots. The Jun 15 transformation reel just proved the format at 252 views with 93.8% non-follower reach — scale that.
Instagram (mirror + extend): cross-post the FB reels day-of, plus IG-native content (Stories with quick before/afters, adjuster reviews, day-in-the-life). IG's algorithm rewards Reels similarly — same content, additional reach.
LinkedIn (1–2/week): B2B + partner content — State Farm / Liberty Mutual certified-shop posts, adjuster shout-outs, hiring, sustainability angle (proper paint disposal, EV specialization). Different audience, different tone.
Cross-channel signal: Reels are working on FB. Cross-posting to IG is essentially free reach. Investing in IG + LinkedIn cadence unlocks the compounding organic layer around the (already strong) paid + local program.
Instagram (mirror + extend): cross-post the FB reels day-of, plus IG-native content (Stories with quick before/afters, adjuster reviews, day-in-the-life). IG's algorithm rewards Reels similarly — same content, additional reach.
LinkedIn (1–2/week): B2B + partner content — State Farm / Liberty Mutual certified-shop posts, adjuster shout-outs, hiring, sustainability angle (proper paint disposal, EV specialization). Different audience, different tone.
Cross-channel signal: Reels are working on FB. Cross-posting to IG is essentially free reach. Investing in IG + LinkedIn cadence unlocks the compounding organic layer around the (already strong) paid + local program.
📅 SEO — Results by Date Range
—
★ First Conversions Ever Tracked
14 key events landed between Jul 21 and Aug 18 — the first conversions GA4 has ever recorded on the site. Direct drove 8 (57.1%) and Organic Search 6 (42.9%); paid and referral produced none. Site-wide key event rate is 1.84% of sessions / 2.33% of users. Traffic also grew for a third straight window: 175 → 288 → 303 users across the last three 28-day periods, +73% since May.
👥
Total Users
303 +5%
290 new · 28 returning · Jul 21–Aug 18
🔄
Sessions
381 +12%
Engaged: 154 (40.4%)
🎯
Key Events
14 new
1.84% of sessions · first ever
📊
Events / Session
4.52
1,724 total events · 21s avg
🤖
AI Assistant Users
8 +300%
was 2 in May · ChatGPT referrals
Traffic by Channel · Jul 21 – Aug 18, 2026
Sessions by Channel
381 sessions · 40.42% engagement rate · 14 key events
| Channel | Sessions | Engaged | Eng. Rate | Key Events |
|---|---|---|---|---|
| Direct | 149 (39.1%) | 62 | 41.61% | 8 |
| Organic Search | 133 (34.9%) | 73 | 54.89% | 6 |
| Referral | 44 (11.6%) | 4 | 9.09% | 0 |
| Paid Search | 37 (9.7%) | 12 | 32.43% | 0 |
| AI Assistant | 9 (2.4%) | 3 | 33.33% | 0 |
| Unassigned | 8 | 0 | 0% | 0 |
| Cross-network | 3 | 0 | 0% | 0 |
| Organic Social | 1 | 0 | 0% | 0 |
Organic Search is the quality channel — highest engagement rate (54.89%), longest sessions (30s), and 6 of the 14 key events. Referral is the problem: 44 sessions at 9.09% engagement and 3s average — almost entirely bot-like traffic from the OLB subdomain.
Three-Window Trend
Rolling ~28-day GA4 windows · users & new users
| Window | Users | New | Events | Key Ev. |
|---|---|---|---|---|
| May 21 – Jun 21 | 175 | 167 | 1,094 | 0 |
| Jun 21 – Jul 21 | 288 | 277 | 1,630 | 0 |
| Jul 21 – Aug 18 | 303 | 290 | 1,724 | 14 |
+73%
User growth since May
95.7%
New users (low repeat)
Growth is steady and compounding. The weak spot is retention — only 28 returning users. Organic Search returns best (15 of 28), which tracks: those visitors found what they needed and came back.
Where Visitors Come From
Top Cities · Active Users
Jul 21 – Aug 17 · local vs. noise
| City | Active Users | Read |
|---|---|---|
| Phoenix | 50 | Core market |
| Boardman | 21 | Data-center / bot |
| Tempe | 18 | Core market |
| Los Angeles | 12 | Out of area |
| Mesa | 10 | Core market |
| Ashburn | 9 | Data-center / bot |
| Chandler | 9 | Core market |
Phoenix metro (Phoenix + Tempe + Mesa + Chandler) = 87 active users, the highest local concentration we've measured. Boardman and Ashburn are AWS/data-center regions — filter them out when judging true local reach.
Sessions by Source
Jul 21 – Aug 17 · manual source
| Source | Sessions | Prior 28d |
|---|---|---|
| 147 | 146 | |
| olb.tracysautobody.com | 20 | 10 |
| tracysautobody.com | 16 | 26 |
| bing | 12 | 6 |
| chatgpt.com | 9 | 6 |
| ads.google.com | 3 | — |
| duckduckgo | 3 | 2 |
ChatGPT referrals grew 6 → 9 sessions and AI Assistant users tripled from 2 to 8 since May. People are asking AI for body shop recommendations and Brightwood is being named — worth building content deliberately for.
Legacy Snapshot · May 2026
Traffic & Engagement
Google Analytics — Daily Traffic
Apr 29 – May 28 · Users vs Sessions
Engagement Snapshot
How visitors interact with the site
41.12%
Engagement Rate
00:23
Avg. Eng. Time
139
Engaged Sessions
0.55
Engaged / User
Engagement is steady but time on page is short (23 sec avg). The /collision-repair/ page is your engagement champion at 96.55% — model other pages after it.
Top Pages & Search Queries
Top Pages by Pageviews
Where visitors land and engage
| Page | Views | Users | Time | Engage |
|---|---|---|---|---|
| / | 276 | 254 | 0:12 | 48.43% |
| /contact/ | 146 | 95 | 0:17 | 62.50% |
| /taste-approved-body-shop/ | 35 | 23 | 0:00 | 72.73% |
| /collision-repair/ | 31 | 27 | 0:24 | 96.55% |
| /faqs/ | 29 | 22 | 0:32 | 76.92% |
Top Search Queries (GSC)
What Google sends you traffic for
| Query | Clicks | Impr. | CTR | Pos. |
|---|---|---|---|---|
| brightwood collision | 8 | 178 | 3.41% | 1.1 |
| brightwood collision center | 8 | 187 | 3.21% | 1.2 |
| body shop near tempe az | 1 | 39 | 2.56% | 19.8 |
| bronwood auto repair | 1 | 1 | 100% | 2.0 |
Branded traffic dominates. Almost all GSC clicks are people searching "brightwood collision" directly. Non-branded terms like "body shop near tempe az" rank at position 19.8 — opportunity to push it into the top 10.
Audience & Acquisition
New User Channels
How 230 new users found the site (last 28 days)
Top Cities — Active Users
Where your audience lives
Sessions by Source
Top traffic referrers
Google sends ~75% of organic sessions (127 of 177). Bing contributes 9. The "tracysautobody.com" subdomain referrals (41 sessions) appear to be referral spam or competitor scraping — worth investigating.
User Retention (Weekly Cohort)
% returning after first visit
3.6% return after Week 1, 0.9% by Week 2. Typical for one-time-service businesses — the goal isn't retention, it's capturing customers in their moment of need.
👥 User Mix
28-day cohort breakdown
230
New Users
30
Returning
88% new users — strong top-of-funnel performance. Awareness is working.
📍 Geographic Reach
Top market: Phoenix metro
109
Phoenix Metro
234
Total Active
Phoenix + Tempe = 47% of active users. Out-of-state traffic (LA, Denver, Aspen) suggests good organic reach.
🎯 Lead Conversion
From GA4 lead tracking
0
Qualified Leads
0
Converted
Lead tracking events aren't firing in GA4. Action item: configure key events so we can attribute conversions to channels.
Tracked Keywords & Backlinks
Tracked Local Keywords
Arizona market · 0% visibility currently
| Keyword | Position | Visibility |
|---|---|---|
| auto body shop | — | 0% |
| auto car repair service | — | 0% |
| auto center near me | — | 0% |
| auto mechanic near me | — | 0% |
| auto mechanic shop | — | 0% |
| auto near me | — | 0% |
None of these high-intent local keywords are ranking. Major opportunity for content + local SEO push.
Backlink Authority Distribution
108 referring domains · mostly low authority
97% of backlinks are 0-20 authority. Adding even a few quality 40+ links (industry directories, local press, partner shops) would meaningfully boost domain authority.