Brightwood Collision Center
Marketing Performance Dashboard
★ The Big Picture — Everything We're Driving
$2.49
Cost per Conversion · June
192 conversions in June at $2.49 each — 61.94% conversion rate (up 6.3 pts from May's 55.6%).
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.
310
Ad Clicks · June
From $1,000 in June ad spend: 310 clicks, 29 phone calls (100% pickup), 192 conversions.
📅 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 $1,984 across May + June to drive 381 conversions (May 193 · June 188) at a blended $5.21 cost/conv. June alone hit a 60.65% conversion rate at $2.57 per conv — up from May's 55.6%. Liberty Mutual is bleeding — its June conv rate crashed to 2.7% (from 9.4% in May), only 1 conversion on $138 spend; recommend pausing or reworking that creative.
Sales lifetime ROI is the headline: $117,914 in closed revenue across 33 jobs traceable to ad-driven leads — the June CSI customer list was reconciled against the full CallRail history and picked up 7 matches ($50,596), including three State Farm claims that closed at $27,522 combined (biggest carrier by revenue) and a Nov 2025 ad call from Nina Tang that finally converted in June ($13,524 on a 2023 Tesla).
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
$1,000.41
—
💵
Avg CPC
—
Spend ÷ Clicks
🖱️
Clicks
310
—
📊
CTR
—
Clicks ÷ Impressions
👁️
Impressions
9,815
—
📞
Phone Calls
29
—
🎯
Conversions
192
—
★ Top Insight · Final June Numbers
$2.49 per conversion in June (down from $2.62 in May) — Brightwood's ads now convert at 61.94%, up 6.3 points month-over-month. DS General Campaign is the workhorse at $5.05 cost/conv and 72.93% conv rate. Insurance Carrier Focus scaled cost/conv down to $3.80 (from $3.72 in May · attribution recomputed) while lifting conv rate to 66.40%. Liberty Mutual conversion rate collapsed from 9.4% → 2.7% — only 1 conversion on $138 spend. That budget belongs elsewhere until the Liberty creative is refreshed.
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 CURRENT MONTH SNAPSHOT
Campaigns below reflect June 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 - General Campaign - Calls | Search | 149 | 2,924 | 5.10% | $3.68 | $548.80 | 108.66 | $5.05 | 72.93% |
| DS - Insurance Carrier Focus | P-Max | 124 | 4,217 | 2.94% | $2.53 | $313.23 | 82.34 | $3.80 | 66.40% |
| Liberty Mutual Campaign | Search | 37 | 2,674 | 1.38% | $3.74 | $138.38 | 1 | $138.38 | 2.70% |
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
29 calls from ads in June · 0 missed (100% pickup rate)
29
Received
0
Missed
Daily Calls Activity
Calls Per Day · Jun 1 – 30
Heaviest days: Jun 17 (4 calls) · Jun 3 · Jun 18 · Jun 22 · Jun 25 · Jun 26 (3 calls each) — the pickup rate held at 100% all month
Recent Calls
| Date / Time | Campaign | Status | Duration | Caller |
|---|---|---|---|---|
| Jun 30 · 11:00 AM | Liberty Mutual | Received | 30s | +1 205-400-0649 |
| Jun 26 · 11:00 AM | General | Received | 7m 5s | +1 602 · — |
| Jun 26 · 9:00 AM | General | Received | 17s | +1 623-217-6252 |
| Jun 26 · 8:00 AM | Insurance | Received | 2m 5s | +1 480-772-5674 |
| Jun 25 · 12:00 PM | General | Received | 1m 58s | +1 714-851-7828 |
| Jun 25 · 11:00 AM | General | Received | 17s | +1 714-851-7828 |
| Jun 25 · 8:00 AM | Insurance | Received | 4m 33s | +1 480-399-0712 |
| Jun 24 · 4:00 PM | Insurance | Received | 49s | +1 714-851-7828 |
| Jun 23 · 3:00 PM | Insurance | Received | 3m 48s | +1 480-531-3153 |
| Jun 23 · 1:00 PM | General | Received | 54s | +1 623-217-6252 |
| Jun 22 · 4:00 PM | Insurance | Received | 2m 17s | +1 480 · — |
| Jun 22 · 3:00 PM | Insurance | Received | 34s | +1 602-904-3110 |
| Jun 22 · 2:00 PM | Insurance | Received | 41s | +1 608-574-8761 |
| Jun 18 · 9:00 AM | General | Received | 2m 44s | +1 602-384-0323 |
| Jun 18 · 9:00 AM | General | Received | 1m 34s | +1 480-249-4346 |
| Jun 18 · 8:00 AM | General | Received | 7s | — |
| Jun 17 · 1:00 PM | General | Received | 7m 9s | +1 909-728-2201 |
| Jun 17 · 1:00 PM | General | Received | 23s | +1 608-214-4413 |
| Jun 17 · 10:00 AM | General | Received | 1m 5s | +1 602-632-6805 |
| Jun 17 · 10:00 AM | General | Received | 54s | +1 602-699-2453 |
| Jun 10 · 12:00 PM | General | Received | 3m 21s | +1 602-620-6870 |
| Jun 9 · 11:00 AM | General | Received | 56s | +1 480-475-7831 |
| Jun 8 · 8:00 AM | General | Received | 4m 12s | +1 602-561-4233 |
| Jun 4 · 12:00 PM | General | Received | 1m 2s | +1 480-249-0220 |
| Jun 3 · 1:00 PM | General | Received | 1m 42s | +1 781-408-1779 |
| Jun 3 · 1:00 PM | General | Received | 0s | — |
| Jun 3 · 11:00 AM | General | Received | 2m 55s | +1 781-408-1779 |
| Jun 2 · 2:00 PM | Liberty Mutual | Received | 11m 56s | +1 480-290-3566 |
| Jun 1 · 8:00 AM | Insurance | Received | 5m 17s | +1 781-408-1779 |
💵 Sales — Results by Date Range
—
💵 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… | |||
📅 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.
★ Organic Social · Facebook · Instagram · LinkedIn
Organic social builds the compounding brand layer around the paid + local program — Facebook + Instagram to nurture the community with before/after cars, POV shop content, and Tesla-certification proof; LinkedIn to build the B2B / insurance-partner side of the business. Facebook + Instagram data are both live below — 28-day / 30-day snapshots (Jun 6 – Jul 5, 2026). Cross-posting is working: the same reels are pulling 406 views on FB + 358 views on IG = 764 combined with essentially zero incremental effort. LinkedIn scaffold ready when Brightwood is ready to activate.
👁️
Combined Views
764
FB 406 · IG 358 · 28–30 days
🎬
Reels % of Views
100%
FB 99% · IG 100% · Reels dominate
🔥
Non-Follower Reach
96%+
FB 93.8% · IG 100.0% · new eyes
📱
IG Accounts Reached
337
unique · 2 profile visits · 2 interactions
⏱️
FB Watch Time
22m 37s
+100% vs prior 28 days
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
—
👥
Organic Users
255 +0%
vs previous 28 days
🔄
Sessions
338 +6%
Engaged: 139 (41%)
🔍
GSC Clicks
28 -30%
4K impr · 0.7% CTR · pos 30.9
⭐
Authority Score
9
SEMrush rank: low
🗝️
Organic Keywords
137 +25%
Est. organic traffic: 312
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.