Back in the booth: three repair reels a week, starting now.
Brightwood's reels already proved they reach new people β 94% of views came from non-followers and two reels drove 92% of June's reach. The paint-match transformation (252 views) and the Tesla-certified POV reel are the templates. Q4 restarts posting at 3 reels a week using phone clips from the shop, and builds out Tesla/EV and insurance-made-easy content.
Strategy built Sep 29, 2026 from this dashboard's social analytics (through Sep 28) and what's winning across Damaris accounts. Cadence is tentative β McKinley adjusts month to month off the numbers. Next full review: early January 2027.
π Month to Date
Nov 1 β Nov 21 Β· compared with the same days last month Β· updated daily
63 visits from google search on your website, up 31% on the same days last month
Google Ads Leads
98
Cost / Lead
$6.12
Website Visits
230
β² 19%
Website Leads & Calls
17
β² 6%
Google Search Clicks
19
Ad Clicks
184
Full breakdown for each channel is in its tab above.
I absolutely love Brightwood Collision Center due to speedy service, knowledgeable employees, friendly environment, reliable and warranty satisfaction! I would give this location 20/10 in a scale from 1 being least likely to recommend to 10 extremely likely toβ¦
PT4 months ago
β β β β β
Very happy with the work the team did. They kept me informed throughout the repair process, answered all of my questions, and professionally detailed the vehicle before pickup. The car looks fantastic and honestly feels like it just rolled off the factory flooβ¦
J.D. L.4 months ago
β β β β β
I was looking for a body shop and came across Brightwood Collision Center off Kyrene in Tempe , just based upon reading there reviews I felt this was the place to be . No regrets, upon arrival Anna up front and Nicole my advisor were so welcoming and very infβ¦
Updated automatically by Damaris Solutions Β· 2026-11-22
β The Big Picture β Everything We're Driving
$4.07
Cost per Conversion Β· August
268.49 conversions in August at $4.07 each β a record month with a 61.44% conversion rate.
4,300
Local Interactions Β· 11 mo
4,300 Google Business Profile actions at $0 ad cost. October set a new record: 517 interactions, +57.6% YoY.
470
Ad Clicks Β· October
470 clicks and 57 phone calls from ads in October β both all-time highs, with 288 leads at $5.85 each.
π SEO β 137 keywords, up 25% Β· 255 organic usersDetail β
π Advertising β Results by Date Range
β
π°
Total Spend
$1,092.21
In selected month
π΅
Avg CPC
$2.51
Held near Jul ($2.46)
π±οΈ
Clicks
436
Aug Β· +45% vs Jul (301) Β· all-time high
π
CTR
2.65%
436 Γ· 16,460
ποΈ
Impressions
16,460
+44% vs Jul (11,400)
π
Phone Calls
33
Aug Β· 32 received + 1 missed
π―
Conversions
268.49
$4.07 cost/conv Β· 61.44% rate
β Current Status Β· October 2026 Β· Record month for calls and clicks
October was the biggest month the account has ever run.57 phone calls — up from 28 in September and well past the previous record of 33 — plus 231 direction requests, for 288 leads at $5.85 each. Clicks hit an all-time high of 470 on 15,871 impressions, and 56 of 57 calls were answered, averaging over two minutes each.
The recovery after the September site fix held all month. Calls averaged nearly two a day across October, the pace the account reached in the last week of September. DS - General carried the volume with 160 conversions at $4.75 each, and the Insurance Carrier Focus campaign added 89 conversions at $5.12.
November is on pace:Nov 1–15 delivered 20 calls, 70 direction requests and 157 clicks on $576.93.
β September 2026 Β· Website outage, then recovery
An SSL registration fault held the first half of September down.This was not an expired certificate — and that is exactly why it ran for days before anyone caught it. The certificate was in date but never registered correctly against the domain, so every routine check reported it healthy while real visitors and Google’s crawler were being turned away. Nothing in the ad account signals a fault like this either: budget keeps spending, impressions keep serving, and the traffic simply lands nowhere. It was re-registered on Sep 13. Through that window the campaigns kept serving but the traffic had nowhere safe to land — eight straight days, Sep 8 to 15, produced no inbound phone calls at all, the longest silent stretch of the month. Only 5 of the month’s 28 calls came in across the first fifteen days.
Calls restarted on Sep 16, three days after the certificate was reissued — and the account has not had a gap like it since. The fifteen days after the fix (Sep 16–30) delivered 23 calls, 82% of the month in half the time, a 4.6× jump in daily call rate. The final nine days averaged 2.0 calls a day against August’s 1.06 — an 88% better rate on 38% less spend. On that recovered run rate, the outage cost roughly 15–20 calls.
The full month with all three campaigns live:$682.35 spend, 8,870 impressions, 246 clicks, 107.99 conversions and 28 calls.
October is off to a fast start:Oct 1–13 has already delivered 186 clicks, 24 calls and 77 direction requests on $730.50 spend.
Click quality improved on both search campaigns.DS - General lifted CTR from 4.14% to 5.29% and carried the month with 67.99 conversions at $4.59 each and a 70.83% conversion rate. Liberty Mutual more than doubled its click-through rate, 1.13% → 2.64%, after the Responsive Search Ad rebuild. “Windshield repair” was the workhorse term — 50 clicks and 12 conversions on $141.93.
Why cost per lead is higher right now: it went $4.07 → $6.32, but the price of a click barely moved — $2.51 → $2.77, up 10%. What fell is how many clicks became leads: 61.6% → 43.9%. For eight days the budget kept buying clicks that landed on a site turning people away — those clicks were paid for, the leads never happened. The second factor is Liberty Mutual, which took 26% of September’s budget for 4% of the leads, at $44.28 each against $4.59 on DS - General. Strip that one campaign out and September’s cost per conversion is $4.86. The site is fixed; the Liberty Mutual budget is the next lever.
β Top Insight Β· August 2026 Final Numbers
August was the biggest month the account has ever run β 436 clicks, 16,460 impressions and 268.49 conversions, every one a campaign-lifetime record, at a 61.44% conv rate. Efficiency held: CPC $2.46 β $2.51, cost/conv $3.97 β $4.07. Spend came in at $1,092.21. DS - General Campaign carried August β 163.66 conversions at an 80.23% conv rate, up from 70.99% in July β but it also absorbed $667 of the $1,092, at a $3.27 CPC. P-Max slipped: conv rate 61.89% β 49.43% and cost/conv $3.03 β $3.87, even as it took the impression share (9,143). Liberty Mutual gave back July's recovery β 3 conversions, 11.11% conv rate, $10.20 cost/conv on 2,392 impressions and a 1.13% CTR; the Responsive Search Ad rebuild is now overdue. β Store-visit tracking is still offline (0 recorded store visits in August, 14 view-through only) β unresolved since Jul 15.
π€ 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: 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.
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 SEPTEMBER 2026 Β· FULL MONTH
Campaigns below reflect the full month of September (Sep 1–30, 2026) β all three campaigns enabled and delivering. 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 - General Campaign - Calls v1
Search
96
1,815
5.29%
$3.25
$312.19
67.99
$4.59
70.83%
DS - Insurance Carrier Focus
P-Max
77
4,287
1.80%
$2.51
$193.04
36.00
$5.36
46.75%
Liberty Mutual Campaign
Search
73
2,768
2.64%
$2.43
$177.13
4.00
$44.28
5.48%
Total Β· Full September (Sep 1–30)
β
246
8,870
2.77%
$2.77
$682.35
107.99
$6.32
43.90%
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
33 calls from ads in August Β· 32 received + 1 missed (97.0% pickup) Β· 70.6 min total talk time
32
Received
1
Missed
Daily Calls Activity
Calls Per Day Β· Aug 1 β 31
Front-loaded month β 28 of 33 calls landed in the first 19 days, peaking at 6 on Aug 6. Zero ad calls after Aug 26, and a five-day gap Aug 20β23, even though spend kept running β worth checking against the budget pacing. 1 missed on Aug 17 at 3 PM (General campaign).
Recent Calls
Date / Time
Campaign
Status
Duration
Caller
Aug 26 Β· 12:00 PM
General
Received
11s
β
Aug 25 Β· 1:00 PM
General
Received
3m 18s
+1 480-309-6778
Aug 24 Β· 3:00 PM
General
Received
2m 34s
β
Aug 19 Β· 7:00 AM
Liberty Mutual
Received
4m 55s
+1 602-309-4698
Aug 18 Β· 4:00 PM
Insurance
Received
2m 34s
+1 970-630-2300
Aug 18 Β· 9:00 AM
General
Received
2m 40s
+1 786-969-0746
Aug 18 Β· 9:00 AM
General
Received
31s
+1 602-338-0942
Aug 17 Β· 3:00 PM
General
Missed
0s
β
Aug 17 Β· 11:00 AM
General
Received
2m 25s
+1 602-570-5375
Aug 17 Β· 11:00 AM
General
Received
1m 6s
+1 928-301-6787
Aug 14 Β· 2:00 PM
Liberty Mutual
Received
1m 22s
+1 928-301-6787
Aug 13 Β· 9:00 AM
General
Received
26s
+1 602-292-1213
Aug 12 Β· 9:00 AM
General
Received
6s
β
Aug 12 Β· 8:00 AM
General
Received
1m 10s
+1 602-486-4510
Aug 11 Β· 9:00 AM β CSI match
General
Received
11m 47s
+1 909-728-2201
Aug 11 Β· 8:00 AM
General
Received
1m 59s
+1 602-486-4510
Aug 10 Β· 4:00 PM
Insurance
Received
1m 19s
+1 928-301-6787
Aug 10 Β· 2:00 PM
Insurance
Received
4m 10s
β
Aug 7 Β· 12:00 PM
Liberty Mutual
Received
2m 21s
+1 760-505-6465
Aug 7 Β· 10:00 AM
Liberty Mutual
Received
41s
+1 760-505-6465
Aug 7 Β· 10:00 AM
General
Received
19s
+1 623-698-9120
Aug 6 Β· 1:00 PM
Liberty Mutual
Received
18s
+1 304-698-8717
Aug 6 Β· 11:00 AM
General
Received
4s
β
Aug 6 Β· 10:00 AM
General
Received
1m 2s
+1 909-900-1333
Aug 6 Β· 9:00 AM
Insurance
Received
13s
β
Aug 6 Β· 8:00 AM
Insurance
Received
1m 8s
+1 720-445-1169
Aug 6 Β· 8:00 AM
Insurance
Received
40s
+1 689-257-0453
Aug 5 Β· 9:00 AM
Insurance
Received
8s
β
Aug 5 Β· 8:00 AM
Insurance
Received
3m 13s
+1 323-416-8791
Aug 3 Β· 8:00 AM
Insurance
Received
12m 59s
+1 323-416-8791
Aug 3 Β· 8:00 AM
Insurance
Received
2m 35s
+1 480-278-5275
Aug 3 Β· 8:00 AM
General
Received
2m 19s
+1 480-791-3419
Aug 3 Β· 8:00 AM
Insurance
Received
1s
β
π 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.
Full Campaign View: $362,784 across 84 jobs Β· 10.57Γ loaded ROAS β big-carrier work included. August added no new non-DRP jobs, so the Brightwood View is flat for a third month while lifetime invest keeps climbing.
π― 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 still closed June 12, 2026 β the $12,046 Tesla Insurance job, the single biggest job in this pool. Every attributed job since then (5 of them, Jun 15 β Aug 24) has been State Farm, GEICO, or GEICO Marine. That is now a three-month drought in the conservative view.
That does not mean non-DRP work dried up at the shop β July had 26 ad-addressable ROs worth $70,613 and August had 18 worth $55,447. 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. Closing that gap is the highest-value fix available right now β it is the difference between a 2.36Γ story and whatever the real number is.
β 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.
π August 2026 Β· CSI Snapshot FULL MONTH Β· ALL CHANNELS
Every closed RO in the August 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.
π°
August Revenue Β· Total
$426,728
96 closed ROs Β· $4,445 avg (Jul: $3,690)
π‘οΈ
Big-Carrier DRP
$371,281
78 ROs Β· 87.0% Β· NOT ad-attributable
π―
Ad-Addressable Pool
$55,447
18 ROs Β· 13.0% Β· down from 17.2% in July
π
New August Intakes
60 / 96
$211,413 revenue Β· vs. 36 carry-over ($215,315)
Attribution Split β Where Does the Client Say Leads Come From?
π‘οΈ Big-Carrier DRP Β· Not Ad-Attributable
$371,281 Β· 87.0%
Insurance Direct-of-Repair network referrals β comes from State Farm, GEICO, USAA apps + adjusters, not marketing
Carrier
ROs
Revenue
State Farm
39
$186,872
GEICO Secure
8
$33,262
United Services / USAA
4
$32,235
GEICO Casualty
6
$26,093
USAA Casualty
3
$19,816
GEICO (base)
3
$15,468
Garrison / USAA subsidiary
2
$15,020
GEICO Choice
3
$13,926
GEICO Advantage
5
$11,636
GEICO General
2
$6,084
USAA General Indemnity
2
$5,805
GEICO Marine
1
$5,066
Total Big-Carrier DRP
78
$371,281
π― Ad-Addressable Pool Β· $55,447 / 13.0%
18 ROs
Non-DRP carriers + Customer Pay + walk-ins β the revenue pool where ads, GMB, and organic could plausibly be driving demand
Source
ROs
Revenue
Progressive
5
$23,884
Economy Premier Assurance
1
$10,312
Customer Pay
3
$9,141
Lemonade, Inc.
1
$3,714
Esurance P&C
1
$1,478
Infinity Insurance
1
$1,465
Walk-in / no carrier listed
6
$5,452
Total Ad-Addressable
18
$55,447
At $1,092 August ad spend, the single $10,312 Economy Premier job or any one of the five Progressive claims (avg $4,777) pays for the month of ads several times over. But the pool shrank β $70,613 / 26 ROs in July down to $55,447 / 18 ROs in August, so there was less non-DRP work available to win even as ad volume hit record highs.
New This Month vs Carry-Over From July & Earlier
Splits every RO by the Vehicle-In date. Vehicles that drove into the shop in August are "new August intakes." Vehicles with a July (or earlier) drop-off that closed in August are carry-over jobs β revenue lands in August but the acquisition happened earlier. August leaned harder on carry-over than July did: 50.5% of revenue came from vehicles that arrived before August 1, vs 42.3% a month ago.
π New August Intakes
60 vehicles Β· $211,413
Vehicles that came in during August Β· 49.5% of the August book
Big-DRP
50 Β· $192,042
Insurance-network pushed
Non-DRP
10 Β· $19,370
π― Highest-signal ad-attribution pool
π Carry-Over From July & Earlier
36 vehicles Β· $215,315
Vehicles that came in before August Β· 50.5% of the August book
Big-DRP
28 Β· $179,239
Jul-or-earlier DRP jobs
Non-DRP
8 Β· $36,076
Progressive + Economy Premier lead this pool
π― Ad-Attributed Matches from August's Call Log
Cross-referencing all 33 August ad calls against the 96 August ROs, 1 exact phone match β and it happens to be the single largest repair order of the month:
π Aug 11 Β· General Campaign Β· 11m 47s
Ryan Mehas π Carry-Over
State Farm claim Β· RO 15063 $21,169.86 revenue Β· in Jun 11, out Aug 24 Β· big-DRP carrier
β Treat this match as soft. The vehicle had already been in the shop for two months when the call came in, so an 11-minute call on Aug 11 is far more likely a repair status check from an existing customer than an ad-driven acquisition. It is counted below only to stay consistent with the rule applied to July's two matches. If you'd rather exclude it, lifetime attributed revenue stays at $129,867 / 35 jobs and lifetime loaded ROAS drops from 4.40Γ to 3.78Γ.
Zero of the 18 ad-addressable August ROs phone-matched an August ad call β the second month in a row with no clean non-DRP match. Nine of the 33 August calls came through with no caller ID recorded, which caps how much matching is even possible; the rest points at demand arriving through GMB, organic, or web forms that bypass the tracked number. Recommended next step: add call tracking to the website form and a distinct tracked number on the GMB listing, so the attribution gap stops being guesswork.
π Value Trend Β· 15-Month CAC + ROAS JUN 2025 β AUG 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 36 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 15 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 15 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,226
Loaded ROAS
2.36Γ
FULL CAMPAIGN VIEW Β· REFERENCE
All ad-attributed sales Β· Sales Report tab
$362,784
Every FIRST-marked sale from the Sales Report tab β 84 attributed jobs (28 non-DRP + 56 big-carrier). Adds $232,917 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
$281,799
Loaded CAC
$409
Loaded ROAS
10.57Γ
Either lens works. Even the conservative Brightwood View (which discounts $282K of big-carrier work) shows every $1 invested comes back as $2.36 β with 28 non-DRP jobs to point at. The Full Campaign View, counting every FIRST sale in the Sales Report tab, is $10.57 per $1 invested across 84 attributed jobs. Both ratios slipped this month β not because revenue fell, but because August added $2,592 of invest and no new non-DRP work.
π CSI-Reconciled Subset Β· The Detail Behind Both Views
Every KPI, chart, and job in the sections below is drawn from the 36 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
$34,315
$11,815 ads + $22,500 Damaris retainer (15 mo Γ $1,500)
π΅
CSI-Reconciled Revenue
$151,037
36 CSI-matched jobs Β· $4,195 avg ticket
π
Reconciled Loaded ROAS
4.40Γ
Ad-only ROAS: 12.78Γ Β· 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 during the FebβMar 2026 attribution gap (zero CSI matches those months) Β· sits at $953 after August, up from $906 β one match on a bigger spend month nudges loaded CAC back 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.16Γ), Aug 2026 (8.17Γ), 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Γ and closed August at 4.40Γ.
Month-by-Month CAC Table
Month
Ad Spend
+ Retainer
Total Invest
Attr. Jobs
Attr. Revenue
Ad-only CAC
Loaded CAC
Monthly ROAS
Cum. ROAS
Aug 2026
$1,092
$1,500
$2,592
1
$21,170
$1,092
$2,592
8.17Γ
4.40Γ
Jul 2026
$740
$1,500
$2,240
2
$11,953
$370
$1,120
5.34Γ
4.09Γ
Jun 2026
$1,000
$1,500
$2,500
2
$9,407
$500
$1,250
3.76Γ
4.00Γ
May 2026
$984
$1,500
$2,484
2
$17,262
$492
$1,242
6.95Γ
4.02Γ
Apr 2026
$1,014
$1,500
$2,514
4
$12,472
$253
$628
4.96Γ
3.72Γ
Mar 2026
$731
$1,500
$2,231
0
gap
β
β
0Γ
3.58Γ
Feb 2026
$727
$1,500
$2,227
0
gap
β
β
0Γ
3.99Γ
Jan 2026
$825
$1,500
$2,325
2
$1,704
$413
$1,163
0.73Γ
4.49Γ
Dec 2025
$801
$1,500
$2,301
2
$1,948
$401
$1,151
0.85Γ
5.07Γ
Nov 2025
$448
$1,500
$1,948
3
$14,946
$149
$649
7.67Γ
5.82Γ
Oct 2025
$827
$1,500
$2,327
3
$7,904
$276
$776
3.40Γ
5.49Γ
Sep 2025
$570
$1,500
$2,070
6
$27,227
$95
$345
13.16Γ
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 Β· 15 MO
$11,815
$22,500
$34,315
36
$151,037
$328
$953
4.40Γ
4.40Γ
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.40Γ β ~4.92Γ.
π΅ 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β¦
π― Channel Mix β Where the Pipeline Comes From
Google Ads spent $2,833 across JuneβAugust to drive 646.99 conversions (June 192 Β· July 186.50 Β· August 268.49) at a blended $4.38 cost/conv. August was the biggest volume month of the campaign's life β 436 clicks, 16,460 impressions and 268.49 conversions, all records β at a CPC that barely moved ($2.46 β $2.51). The catch is budget: spend hit $1,092.21, roughly $342 over the $750/mo cap agreed with the Google rep in July, and cost/conv drifted $3.97 β $4.07. The General search campaign carried the month (163.66 conv at an 80.23% conv rate) while P-Max conv rate slipped 61.89% β 49.43%. Liberty Mutual gave back July's recovery β 3 conversions at 11.11% and a $10.20 cost/conv β so the Responsive Search Ad rebuild is now the overdue lever there.
Sales lifetime ROI is the headline: $151,037 in closed revenue across 36 jobs traceable to ad-driven leads. The August CSI list produced 1 phone match ($21,169.86) β Ryan Mehas (State Farm Β· RO 15063), the single largest RO of the month, off an 11m 47s Aug 11 call on the General campaign. Read that one with care: the vehicle had been in the shop since June 11, so the call was almost certainly a repair status check rather than an ad-driven acquisition β it is counted here only to stay consistent with July's matching rule. On the broader August book (ad-attributed or not), Brightwood closed 96 ROs for $426,728 β up 4.2% on July's $409,547 from 15 fewer ROs, with average ticket jumping $3,690 β $4,445. State Farm alone was 39 claims and $186,872 (43.8% of revenue).
Local Search generates 4,300 GMB interactions at $0 across 9 months, with direction requests dominating (2,424) β most local searchers want to drive over, not call. August was the best month on record (+49.4% YoY overall, calls +88.0%).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.
I absolutely love Brightwood Collision Center due to speedy service, knowledgeable employees, friendly environment, reliable and warranty satisfaction! I would give this location 20/10 in a scale from 1 being least likely to recommend to 10 extremely likely toβ¦
PT4 months ago
β β β β β
Very happy with the work the team did. They kept me informed throughout the repair process, answered all of my questions, and professionally detailed the vehicle before pickup. The car looks fantastic and honestly feels like it just rolled off the factory flooβ¦
J.D. L.4 months ago
β β β β β
I was looking for a body shop and came across Brightwood Collision Center off Kyrene in Tempe , just based upon reading there reviews I felt this was the place to be . No regrets, upon arrival Anna up front and Nicole my advisor were so welcoming and very infβ¦
Caitlin B.5 months ago
β β β β β
I had a great experience with this collision center from start to finish. They worked directly with my insurance, which made the whole process smooth and stress-free. The quality of the repairs was excellent. My truck looked even better (inside and out) than iβ¦
Abe M.9 months ago
β β β β β
Brightwood Collison repair shop did an outstanding job on my wife's ride after a hit and run. Car looks like new and it's not an exaggeration. Dudes got us squared after a few day even during the holidays. They kept me informed about the progress and updating β¦
π Local Search β Results by Date Range
β
β
Total Interactions
4,300
Dec 2025 β Nov 15, 2026 Β· 11 months Β· Jul missing
π
Calls from Profile
1,384
Oct: 165 (+68.4% YoY) Β· Nov 1β15: 74
π
Direction Requests
2,424
Oct: 298 (+49.7% YoY) Β· Nov 1β15: 109
π
Website Clicks
492
Oct: 54 (+74.2% YoY) Β· Nov 1β15: 25
π August vs Last August YEAR OVER YEAR
Google reports every Business Profile metric against the same month last year. August 2026 beat August 2025 on all four β and the phone, the metric that actually fills the shop, grew fastest.
Calls from the profile
+88.0%
83 → 156 calls. Nearly double last August β the biggest year-over-year move of any metric on the profile.
Total interactions
+49.4%
312 → 466 actions. Half again as much activity on the profile as the same month a year ago, at $0 in ad cost.
Direction requests
+34.9%
189 → 255. A new monthly record, and 255 people who pulled up directions to drive to the shop.
Website clicks
+37.5%
40 → 55. Back to the January high and up more than a third on last August.
β October 2026 Β· The best month the profile has ever had
October 2026 set a new all-time record — 517 total interactions, +57.6% against October 2025, beating August’s previous best of 466. Calls were up 68.4% (165), direction requests up 49.7% to 298 — a new monthly record — and website clicks up 74.2% (54). November is tracking right alongside it: 208 interactions in the first half of the month — 74 calls, 109 direction requests, 25 website clicks. Over 11 months the Business Profile has driven 2,424 direction requests + 1,384 calls = 3,808 high-intent actions at $0 ad cost. Note: Jul 2026 was never exported, so the trend line breaks between June and August.
7-Month Performance Trend
Profile Interactions Over Time
Dec 2025 β Nov 2026 Β· All interaction types Β· Jul not exported
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
1,384
Total Calls
175
Peak Month (Mar)
October delivered 165 calls, up 68.4% YoY β the second-highest month on record behind Mar 2026's 175, and 74 more landed in the first half of November.
π Direction Requests
Foot/drive traffic intent
2,424
Total Directions
298
Peak Month (Oct)
October: 298 direction requests (+49.7% YoY) β a new monthly record, past August’s 255. 2,424 lifetime direction requests = 2,424 people who chose to drive to the shop.
π Website Clicks
Lower volume, high intent
492
Total Clicks
59
Peak Month (Sep)
October: 54 clicks (+74.2% YoY) β the biggest year-over-year jump of the three, just behind September’s record 59.
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.
Reels are the whole story β 99% of views. Algo is pushing to non-followers (93.8%) β good top-of-funnel signal.
πΈ Instagram
@brightwoodcollision
Live
358
views Β· 30 days
Reels
100%
of all views
Reach
337
accounts (unique)
Posts
3
reels Β· 30 days
100% non-follower reach β every view is a net-new eyeball. 2 interactions + 2 profile visits so far Β· CTAs in captions could convert more of that reach into follows.
πΌ LinkedIn
Brightwood Β· Company
Awaiting
β
followers
Impr.
β
this month
ER
β
engagement rate
Posts
β
this month
B2B + insurance-partner surface Β· adjuster relationships, State Farm / Liberty Mutual certified-shop posts, hiring content.
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
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.
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.
π SEO β Results by Date Range
β
β September 2026 Β· Same traffic, more than double the conversions
The site converted better in September than in any month GA4 has tracked. On 389 sessions and 319 users — essentially flat against August’s 402 sessions and 327 users — the site produced 40 key events against 18 in August. Of the 58 key events recorded across the whole Jul–Sep quarter, 40 landed in September.
The home page does the heavy lifting: 252 of 389 sessions (64.8%) and 32 of the 40 key events, at a 4.76% conversion rate. /contact took 86 sessions and 6 key events. The standout for quality is /collision-repair — only 7 sessions, but 1m 07s average engagement and a 14.29% key event rate, more than three times the site average. That page is worth more traffic.
Where the people came from (new users, last 28 days): Direct 130, Organic Search 71, Paid Search 51, Referral 35, AI Assistant 4. Across the full quarter that is 421 direct, 235 organic, 122 paid, 116 referral. ChatGPT sent 19 sessions this quarter — small, but a channel that did not exist on this account a year ago.
π
Sessions Β· September
389
319 users Β· 313 new Β· Sep 1–30
π―
Key Events
40 +122%
vs 18 in August
π
Key Event Rate
3.98%
up from 1.84% (Jul 21–Aug 18)
π
Best Converting Page
14.3%
/collision-repair Β· 1m07s engaged
πͺ Landing Pages SEP 1β30, 2026
Landing page
Sessions
New users
Avg. engaged
Key events
Key event rate
/home
252 (66.8%)
209
30s
32
4.76%
/contact
86 (22.8%)
74
23s
6
2.33%
(not set)
15
0
0s
0
0%
/tesla-approved-body-shop
10
9
11s
0
0%
/collision-repair
7
7
1m 07s
2
14.29%
/faqs
4
3
28s
0
0%
Total Β· September
389
313
27s
40
3.98%
β First Conversions Ever Tracked Β· Jul 21 β Aug 18 window
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.
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
google
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.