Date range
Rolling 30: Oct 10 – Nov 8, 2026 · vs prior 30 days Sep 10 – Oct 9, 2026
Last 30 days at a glance · New
Last 30 days · New department: 124 retail workable opportunities (169 unique after de-dupe; Bad excluded); retail close 16.1% (20 retail sold); internet is 55.6% of retail workable; internet CRM contact 100.0%; internet median response 2 min.
Rolling 30: Oct 10 – Nov 8, 2026 · compared with prior 30 days Sep 10 – Oct 9, 2026
Funnel stages are tabs — click through Traffic → Inventory → Demand shape → Leads → Handling → People. Print still shows every stage.
Stage 1 · Top of funnel
Website traffic
People visiting audibatonrouge.com (and related store sites) before any CRM lead is created.
Total website traffic picture
Google Analytics · last ~30 days in cache dated 2026-11-06 · align with CRM window Oct 10 – Nov 8, 2026 where possible
What this means
This is the top of the sales funnel: how much store-site demand you are generating.
Traffic alone is not leads — next is what the store has to sell (active inventory), then how demand becomes CRM opportunities
(website forms, 3rd-party portals, then phone and walk-in).
Visits (sessions)
24,428
One visit = one trip to the site
People (users)
21,917
Unique visitors
Page views
38,050
1.6 pages per visit
Avg time on site
2m 10s
Average visit length (GA4 session duration)
Engagement rate
36.5%
Visits with meaningful activity
Bounce rate
63.5%
Left after one page — lower is usually better
Mobile share
58.7%
Visits from phones/tablets
Where site traffic came from (top sources)
Source / medium · avg time on site · on-site next steps · GA4 2026-09-16 → 2026-10-15
How to read this
Traffic = visits + people. Avg time = average visit length.
Next steps stacks vehicle-page views, main button clicks, forms, and phone taps — still not VinSolutions leads.
Rows are mix indicators and are not required to sum to total site sessions above.
Board is built to fit the page — scroll vertically inside the frame; no sideways swipe needed.
| Source / medium | Traffic | Avg time | Next steps |
|---|---|---|---|
| (direct) / (none) | Visits6,473People5,689 | 1m 39s | Vehicle pages6,169Main CTAs318Forms start25Forms done25Phone taps47 |
| google / cpc | Visits4,045People2,972 | 2m 48s | Vehicle pages1,679Main CTAs325Forms start53Forms done25Phone taps53 |
| google / organic | Visits2,947People1,630 | 5m 10s | Vehicle pages2,153Main CTAs872Forms start42Forms done22Phone taps47 |
| WAFB / GDM 360 Display | Visits973People896 | 18s | Vehicle pages0Main CTAs1Forms start0Forms done0Phone taps0 |
| WAFB / GDM 360 Streaming | Visits947People941 | 2s | Vehicle pages0Main CTAs0Forms start0Forms done0Phone taps0 |
| fb / paid | Visits721People663 | 55s | Vehicle pages89Main CTAs124Forms start2Forms done0Phone taps0 |
| (not set) / (not set) | Visits709People710 | 20s | Vehicle pages15Main CTAs19Forms start0Forms done0Phone taps2 |
| cdn.flashtalking.com / referral | Visits706People683 | 20s | Vehicle pages13Main CTAs28Forms start0Forms done0Phone taps1 |
| ig / paid | Visits679People623 | 46s | Vehicle pages28Main CTAs103Forms start0Forms done0Phone taps0 |
| newsletter / email | Visits481People400 | 2m 10s | Vehicle pages48Main CTAs3Forms start2Forms done0Phone taps0 |
| autotrader.com / social | Visits463People346 | 1m 11s | Vehicle pages50Main CTAs146Forms start0Forms done0Phone taps0 |
| bing / organic | Visits372People212 | 5m 24s | Vehicle pages402Main CTAs84Forms start6Forms done5Phone taps2 |
| imasdk.googleapis.com / referral | Visits298People298 | 0s | Vehicle pages0Main CTAs0Forms start0Forms done0Phone taps0 |
| Pinterest / PaidSocial | Visits269People257 | 31s | Vehicle pages12Main CTAs24Forms start0Forms done0Phone taps0 |
| audiusa.com / referral | Visits224People144 | 7m 01s | Vehicle pages0Main CTAs0Forms start0Forms done0Phone taps0 |
| tpc.googlesyndication.com / referral | Visits173People173 | 5s | Vehicle pages0Main CTAs2Forms start0Forms done0Phone taps0 |
| facebook / paid | Visits147People145 | 52s | Vehicle pages15Main CTAs15Forms start0Forms done0Phone taps0 |
| yahoo / organic | Visits84People39 | 4m 11s | Vehicle pages53Main CTAs40Forms start1Forms done1Phone taps1 |
| facebook.com / referral | Visits54People52 | 1m 25s | Vehicle pages23Main CTAs6Forms start1Forms done0Phone taps0 |
| cargurus.com / referral | Visits49People37 | 3m 05s | Vehicle pages38Main CTAs15Forms start0Forms done0Phone taps0 |
Top 15 sources — visual mix
Same GA4 window · GA4 2026-09-16 → 2026-10-15 · four separate charts (not a spider)
How to read this
One chart per metric so nothing overlaps.
Red = visits ·
Green = avg time ·
Purple = CTAs total
(main buttons + forms + phone) ·
Blue = vehicle pages.
Long green/blue/purple on a short red bar = smaller volume but stronger engagement.
Website traffic mix only — not the same labels as CRM lead sources. No source total row (avoids a sum that can exceed site sessions).
Gray Media OTT — streaming / TV
Gray Media vendor dashboard (WAFB / streaming) · not Google Analytics totals · not VinSolutions
What this means
Streaming/TV delivery from the Gray buy. Impressions and completed views are vendor delivery — not website sessions.
Clicks could become site visits if tagged. Do not add these numbers into the total website traffic picture above.
Impressions
166,070
Vendor dashboard
Completed video views
106.94K
As reported by Gray
Clicks
753
Could become site visits
Vendor window: September 16 – October 16, 2026 · pulled 2026-10-16 · not added into GA4 session totals above.
Impressions by device
How to read this
Where the streaming/TV buy actually played. Connected TV is the living-room screen. Not website sessions.
| Device | Impressions | Share |
|---|---|---|
| Connected TV | 85,757 | 51.6% |
| Mobile | 47,934 | 28.9% |
| Desktop / Laptop | 24,497 | 14.8% |
| Tablet | 5,767 | 3.5% |
| Homeassistant | 1,330 | 0.8% |
| Other | 784 | 0.5% |
| Total | 166,069 | 100% |
Top publishers
How to read this
Gray only lists publishers with at least 25 impressions per day. Top 15 shown. Device mix is complete. Not added into website traffic above.
| Publisher | Impressions |
|---|---|
| WAFB 9News | 21,040 |
| The Roku Channel | 9,922 |
| Yahoo | 9,282 |
| Spotify | 8,700 |
| Local Station / News | 7,420 |
| Tubi | 3,923 |
| MSN | 3,547 |
| Vizio | 3,438 |
| Watchfree+ | 2,536 |
| MetroZone | 2,506 |
| rayfiretv.wafb | 2,298 |
| oakever.meowdoku | 1,949 |
| wafb | 1,862 |
| Fox Networks | 1,774 |
| Fox News | 1,565 |
| Top listed | 81,762 |
Site visits after ad exposure
How to read this
Gray pixel: visits within 30 days of seeing an ad. Page-path hits can exceed unique visits. Not the same clock as GA4 WAFB sessions. Dead URLs listed as Gray counted them.
Site visits
766
Within 30 days of the ad
Unique users
445
Gray pixel
Avg days to visit
29.7
Monthly figure — not a daily clock
| Where they landed | Site visits |
|---|---|
| Homepage | 539 |
| Inventory | 510 |
| Other | 244 |
| Specials | 19 |
| Service | 16 |
Dead page paths Gray still counted
How to read this
These URLs 404 on audibatonrouge.com. Gray still counted visits against them.
| URL path | Site visits | Live check |
|---|---|---|
| /en/inventory/new | 80 | 404 |
| /en | 10 | 404 |
| /all-new-2027-q7 | 4 | 404 |
| /schedule-service.htm | 3 | 404 |
| /en/service/service-scheduling | 2 | 404 |
| /en/contact-us | 1 | 404 |
| /en/inventory/used | 1 | 404 |
| /en/inventory/vehicle | 1 | 404 |
Creative in market · 7
How to read this
Units Gray Media is running. Click a thumbnail to enlarge.
Named Gray / WAFB in Google Analytics
| Source or campaign | Visits | People | Avg time |
|---|---|---|---|
| WAFB / GDM 360 Display | 973 | 896 | 18s |
| WAFB / GDM 360 Streaming | 947 | 941 | 2s |
| WAFB / GDM 360 Audio | 4 | 4 | 16s |
| (not set) · WAFB/GDM 360 Display | 897 | — | 19s |
| (referral) · WAFB/GDM 360 Streaming | 892 | — | 0s |
| (not set) · WAFB/GDM 360 Streaming | 54 | — | 29s |
| (referral) · WAFB/GDM 360 Display | 41 | — | 0s |
| · WAFB/GDM 360 Display | 33 | — | 1s |
| (not set) · WAFB/GDM 360 Audio | 4 | — | 16s |
| (organic) · WAFB/GDM 360 Display | 2 | — | 0s |
| · WAFB/GDM 360 Streaming | 1 | — | 0s |
| (direct) · WAFB/GDM 360 Display | 1 | — | 2m 09s |
Google paid search — store campaigns
Store search ads only · 2026-09-16 – 2026-10-15 · YouTube / programmatic mixed into Google paid is excluded
What this means
People who clicked Audi Baton Rouge Google search ads and landed on the store website.
Traffic here is not yet a VinSolutions lead. Next question is whether they reached inventory lists and vehicle pages.
Paid search visits
1,420
1,121 engaged
Inventory list views
1,510
697 inventory-list events
Vehicle page views
692
694 vehicle-page events
On-site next steps
278
Main-button clicks · 47 phone taps · 1 completed forms
Google Ads reported 1,621 search clicks in the same window. The site recorded 1,420 visits from named store search campaigns. Ads counted 229 “calls from ads” as the main conversion — not vehicle-page or form activity.
Where paid search landed
How to read this
First page of the visit. Offers should hit specials. Model ads should hit inventory lists. Almost nobody lands on a single vehicle — they click through after.
| First page type | Visits | Engaged |
|---|---|---|
| Specials pages | 154 | 121 |
| Inventory lists | 550 | 441 |
| Vehicle pages | 22 | 16 |
| Homepage | 486 | 421 |
| Service pages | 67 | 59 |
| Finance / trade | 5 | 3 |
| Contact / hours | 2 | 2 |
| Other | 135 | 59 |
Paid search by campaign
| Campaign | Visits | Engaged | Bounce |
|---|---|---|---|
| Brand | 541 | 442 | 18.3% |
| Sales Offers | 158 | 109 | 31.0% |
| Sales Offers - Conquest | 144 | 114 | 20.8% |
| Q7 | 102 | 85 | 16.7% |
| Pre-Owned Q5 | 70 | 58 | 17.1% |
| All-New 2027 Q9 | 69 | 51 | 26.1% |
| Service | 67 | 63 | 6.0% |
| Q8 | 63 | 47 | 25.4% |
| Q5 | 62 | 57 | 8.1% |
| Service Offers | 54 | 29 | 46.3% |
| Secondary Models | 38 | 30 | 21.1% |
| Q3 | 26 | 16 | 38.5% |
| Locations | 25 | 19 | 24.0% |
| Luxury Sedan | 1 | 1 | 0.0% |
Website mix only — not the same labels as CRM lead sources.
Stage 1b · Supply next to demand
Inventory health (active lot)
What the store has to sell right now — after website traffic, before CRM leads. Not lead handling.
Store inventory on the ground
VinSolutions live-lot units · snapshot file abr-inventory-latest.csv · as of Nov 09, 2026 7:01 AM · lead window for context Oct 10 – Nov 8, 2026
What this means
Live lot composition and aging. Traffic and 3rd-party demand only convert if the metal matches what shoppers want.
File rows: 4,260 → lot units shown: 90.
This is not contact rate or response speed — those start at Stage 4 (Handling).
Active total
90
Units in Active status
New
90
100.0% of active lot
Used
0
Retail used (excl. Certified)
Certified
0
CPO subset of the lot
Median age
63 d
Days in inventory (Active)
No photo
8
8.9% of active units
Age of active inventory
| Age bucket | Units | Share |
|---|---|---|
| 0–30 days | 22 | 24.4% |
| 31–60 days | 23 | 25.6% |
| 61–90 days | 16 | 17.8% |
| 91–180 days | 19 | 21.1% |
| 180+ days | 10 | 11.1% |
| Total aged units | 90 | 100% |
Aging by New / Used / Certified
| Type | Units | Median age | >60d | >90d | >180d |
|---|---|---|---|---|---|
| New | 90 | 63 d | 45 | 29 | 10 |
| All active | 90 | 63 d | 45 | 29 | 10 |
New — top models
| Unit | Count | Share of active lot |
|---|---|---|
| Q5 | 28 | 31.1% |
| Q8 | 16 | 17.8% |
| Q7 | 8 | 8.9% |
| A5 | 7 | 7.8% |
| A6 Sedan | 6 | 6.7% |
| SQ5 | 5 | 5.6% |
| Q3 | 3 | 3.3% |
| S5 | 2 | 2.2% |
| SQ8 | 2 | 2.2% |
| RS Q8 | 2 | 2.2% |
| Top listed | 79 | 87.8% |
Used + Certified — top make / model
| Unit | Count | Share of active lot |
|---|---|---|
| No used/CPO units | ||
Photo gap: 8 active units (8.9%) marked without a photo — website and marketplace presentation risk, separate from lead handling.
Source: VinSolutions inventory export (live lot). Website search counts can differ — this panel is the ops lot from the CRM file, not a scrape of the public inventory grid.
Stage 2 · Demand shape
How demand shows up
Vehicles of interest and trades — demand pressure next to traffic and inventory. Attempt methods (phone / email / text) live on Handling.
What cars people asked about
Workable opportunities · Oct 10 – Nov 8, 2026
What this means
Vehicle of interest on the lead when CRM has it. Helps with stocking and coaching — not a sold report.
| New / used / CPO interest | Opps | Share |
|---|---|---|
| New | 98 | 79.0% |
| Unknown | 21 | 16.9% |
| Used | 5 | 4.0% |
| Total | 124 | 100.0% |
Top vehicles of interest Oct 10 – Nov 8, 2026
| Year / make / model | Opps | Share |
|---|---|---|
| 2026 Audi Q5 | 16 | 15.8% |
| 2026 Audi Q3 | 12 | 11.9% |
| 2026 Audi Q7 | 10 | 9.9% |
| 2026 Audi Q8 | 7 | 6.9% |
| 2026 Audi A5 | 5 | 5.0% |
| 2026 Audi SQ5 | 5 | 5.0% |
| 2027 Audi Q5 | 5 | 5.0% |
| 2026 Audi A6 Sedan | 4 | 4.0% |
| 2027 Audi Q7 | 4 | 4.0% |
| 2027 Audi SQ7 | 3 | 3.0% |
| Total | 71 | 100.0% |
Trade-ins mentioned
Workable opportunities · Oct 10 – Nov 8, 2026
What this means
33.9% of workable opportunities included a trade vehicle.
Higher trade rates often signal more serious shoppers.
| Trade year / make / model | Opps | Share of trades |
|---|---|---|
| 2024 Audi Q3 | 5 | 11.9% |
| 2020 Audi Q5 | 2 | 4.8% |
| 2023 Audi A5 | 1 | 2.4% |
| 2024 Porsche Cayenne Coupe | 1 | 2.4% |
| 2026 Lexus GX 550 | 1 | 2.4% |
| 2017 Mercedes-Benz GLC 300 | 1 | 2.4% |
| 2024 Audi Q5 | 1 | 2.4% |
| 2021 Audi A6 | 1 | 2.4% |
| Total | 13 | 100.0% |
Stage 3 · Demand becomes leads
CRM opportunities from website + 3rd parties
Unique sales opportunities (de-duped) created in VinSolutions for Oct 10 – Nov 8, 2026. Website and marketplace demand show up as internet forms, then also as phone and walk-in — including full source detail on this tab.
Lead volume entering the funnel
Unique opportunities · Oct 10 – Nov 8, 2026 · de-duped · retail workable = excl. Bad + excl. acquisition
What this means
CRM sales opportunities after de-dupe. Same shopper is not counted three times as internet + phone + walk-in.
Retail workable drops Bad junk and acquisition leads (cash/trade value requests — not a retail buy).
Unique after de-dupe
169
From 211 raw CRM rows · 42 repeats collapsed
Retail workable
124
Excl. Bad (45) · excl. acquisition (0)
Retail sold
20
VinSolutions retail sold · close 16.1% of 124 retail workable
DMS deals file through Aug 07, 2026 does not cover this window (Oct 10 – Nov 8, 2026) — close from VinSolutions leads email
DMS deals file through Aug 07, 2026 does not cover this window (Oct 10 – Nov 8, 2026) — close from VinSolutions leads email
Delivered
20
CRM status Delivered · of retail sold
On Order
0
CRM status On Order · sold, not delivered yet
Wholesale / auction sold
0
DMS outlets · separate from retail close · total sold 20
A) Where digital retail demand is sourced
Funnel read
Owned website + on-site tools (Motive, store forms/chat, Carcode) vs 3rd-party portals (Autotrader/KBB, CarGurus, Carfax…) vs OEM partner feeds. These sources create internet opportunities — and often later phone/walk-in on the same shopper.
| Digital source family | Workable opps | Share of internet | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Dealer website & on-site | 27 | 39.1% | 100.0% | 7 min 80.0% ≤15 min · n=15 |
15 | 55.6% |
| Autotrader / KBB ATKBB | 3 | 4.3% | 100.0% | 13 min 33.3% ≤15 min · n=3 |
0 | 0.0% |
| Other 3rd-party marketplaces | 13 | 18.8% | 100.0% | 8 min 69.2% ≤15 min · n=13 |
0 | 0.0% |
| Audi Partner (OEM partner) | 17 | 24.6% | 100.0% | 12 min 35.3% ≤15 min · n=17 · avg on 16 |
0 | 0.0% |
| OEM / brand digital | 6 | 8.7% | 100.0% | 6 min 83.3% ≤15 min · n=6 * |
0 | 0.0% |
| Total / avg (families above) | 66 | — | — | — | 15 | 22.7% |
Digital families above total 66 workable internet-side rows shown in those buckets; internet CRM channel is 69. Gap is other internet sources (campaigns, uncategorized, etc.) detailed under Source detail. Response = VinSolutions average adjusted response minutes (excludes responses over 4 hours) (+ % ≤15). Internet is the reliable speed signal.
Big-vendor demand by channel (CRM)
How to read this
VinSolutions opportunities from major portals, split Internet / Phone / Walk-in.
Portal website referrals live on Traffic — this is CRM-attributed demand.
| Vendor | Internet | Phone | Walk-in | Total opps | Sold |
|---|---|---|---|---|---|
| Autotrader / KBB | 3 | 0 | 0 | 3 | 0 |
| CarGurus | 3 | 0 | 0 | 3 | 0 |
| TrueCar | 6 | 0 | 0 | 6 | 0 |
| Edmunds | 1 | 0 | 0 | 1 | 0 |
Thin Phone often means portal call-ins were logged as generic Phone Up without the vendor source.
B) How opportunities show up in the CRM (channel)
Funnel read
Website and 3rd-party activity turns into internet form leads, phone calls, and walk-ins (plus Other CRM types).
Close = retail sold ÷ retail workable on the hero grade; per-row close uses that channel’s workable opps.
Contacted = real work attempt on that channel.
Response uses adjusted minutes when present — Phone/Walk-in often log 0 min (* = half or more timed at 0; treat as weak signal).
| CRM channel | Workable opps | Share | Contacted | Avg response | Sold | Close | Plain English |
|---|---|---|---|---|---|---|---|
| Internet (web forms / digital) | 69 | 55.6% | 100.0% | 9 min 63.2% ≤15 min · n=57 · avg on 56 |
15 | 21.7% | Forms, portals, chat, partner feeds |
| Phone | 27 | 21.8% | 100.0% | — | 2 | 7.4% | Phone-ups / tracked calls |
| Walk-in | 28 | 22.6% | 100.0% | — | 3 | 10.7% | In-store / drive-by |
| Other | — | — | — | — | — | — | Referral, repeat, DMS, other CRM types |
| Total / avg | 124 | 100.0% | 100.0% | — | 20 | 16.1% |
Source detail
Unique workable opportunities · Oct 10 – Nov 8, 2026 · de-duped · same funnel window · Close = sold ÷ opps · Response = average adjusted minutes (over 4 hours dropped from average)
What this means
Drill-down on where demand came from — owned website vs Autotrader/KBB vs other portals vs OEM partner, then phone and walk-in. High volume + low close often means a source quality issue. Whether the team worked those leads fast belongs on the Handling tab. Dealer website includes Motive, store-domain forms/chat, and Carcode. Autotrader/KBB is one 3rd party with many of their own channels.
Response sits next to close so you can see whether slow first touch lines up with weak conversion. * on response = half or more timed values are 0 (common on phone/walk-in — weak signal).
1) Channel mix
| Channel | Opps | Share | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Internet | 69 | 55.6% | 100.0% | 9 min 63.2% ≤15 min · n=57 · avg on 56 | 15 | 21.7% |
| Phone | 27 | 21.8% | 100.0% | — | 2 | 7.4% |
| Walk-in | 28 | 22.6% | 100.0% | — | 3 | 10.7% |
| Total / avg | 124 | 100.0% | 100.0% | 9 min 100.0% ≤15 min · n=57 | 20 | 16.1% |
2) Internet broken down
Families inside internet · Oct 10 – Nov 8, 2026
Audi Partner leads — watch list 17 opps · close 0.0% · contact 100.0% · avg 12 min
Why this is split out
Audi Partner is an OEM partner feed. High volume can distort website and marketplace quality if mixed in.
Keep it separate. Grade on unique opportunities, contact, response speed, and close — not volume alone.
| Sub-type | Opps | Share | Contacted | Avg response | Sold | Close rate | Bad |
|---|---|---|---|---|---|---|---|
| Audi Partner — New / main | 17 | 100.0% | 100.0% | 12 min 35.3% ≤15 min · n=17 · avg on 16 | 0 | 0.0% | 3 |
| Total / avg | 17 | 100.0% | 100.0% | 12 min 100.0% ≤15 min · n=17 | 0 | 0.0% | 3 |
What’s on the lead VinSolutions only has two Partner source names (Used/CPO vs New/main). Extra detail is the vehicle of interest on the opportunity — not a finer OEM sub-source.
| Inventory type on the lead | Opps | Share |
|---|---|---|
| New | 15 | 88.2% |
| Used | 2 | 11.8% |
| Vehicle of interest | Opps | Share |
|---|---|---|
| 2027 Audi Q5 | 5 | 29.4% |
| 2027 Audi A5 | 2 | 11.8% |
| 2026 Audi Q5 | 2 | 11.8% |
| 2026 Audi Q7 | 1 | 5.9% |
| 2016 Audi S4 | 1 | 5.9% |
| 2025 Audi Q5 | 1 | 5.9% |
| 2026 Audi SQ5 | 1 | 5.9% |
| 2027 Audi Q8 | 1 | 5.9% |
| 2026 Audi RS 7 | 1 | 5.9% |
| 2027 Audi Q7 | 1 | 5.9% |
| 2026 Audi Q3 | 1 | 5.9% |
Dealer website & on-site 27 · 39.1% of internet · close 55.6% · avg 7 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Routeone Llc | 12 | 44.4% | 100.0% | — | 8 | 66.7% |
| Motive — Website | 7 | 25.9% | 100.0% | 3 min 100.0% ≤15 min · n=7 | 5 | 71.4% |
| Motive Test Drive | 2 | 7.4% | 100.0% | 10 min 50.0% ≤15 min · n=2 * | 1 | 50.0% |
| Motive — Credit | 1 | 3.7% | 100.0% | 12 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Motive — Qualify | 1 | 3.7% | 100.0% | 13 min 100.0% ≤15 min · n=1 | 1 | 100.0% |
| Motive — Trade | 1 | 3.7% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| 700credit - Quickqualify | 1 | 3.7% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| 700credit.Com | 1 | 3.7% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Dealer.Com - Get Eprice | 1 | 3.7% | 100.0% | 19 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Website chat — Edmunds Carcode | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 27 | 100.0% | 100.0% | 7 min 86.7% ≤15 min · n=15 | 15 | 55.6% |
OEM / brand digital 6 · 8.7% of internet · close 0.0% · avg 6 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Oadd - Vdp Vehicle Inquiry - I Want This One | 2 | 33.3% | 100.0% | 0 min 100.0% ≤15 min · n=2 * | 0 | 0.0% |
| Audiusa - Configure Your Vehicle - | 2 | 33.3% | 100.0% | 10 min 50.0% ≤15 min · n=2 * | 0 | 0.0% |
| Car And Driver - Audiusa Trade In | 1 | 16.7% | 100.0% | 14 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - Contact Dealer | 1 | 16.7% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Total / avg | 6 | 100.0% | 100.0% | 6 min 100.0% ≤15 min · n=6 * | 0 | 0.0% |
ATKBBAutotrader / KBB (one 3rd party · their channels) 3 · 4.3% of internet · close 0.0% · avg 13 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| ATAutotrader — Internet lead | 3 | 100.0% | 100.0% | 13 min 33.3% ≤15 min · n=3 | 0 | 0.0% |
| Total / avg | 3 | 100.0% | 100.0% | 13 min 100.0% ≤15 min · n=3 | 0 | 0.0% |
Third-party marketplaces (grouped by brand · product feeds indented) 13 · 18.8% of internet · close 0.0% · avg 8 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| TrueCar 6 product feeds | 6 | 46.2% | 100.0% | 9 min 66.7% ≤15 min · n=6 * | 0 | 0.0% |
| Benefithub | 1 | 16.7% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Consumer Reports | 1 | 16.7% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Credit Karma | 1 | 16.7% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Lifecare | 1 | 16.7% | 100.0% | 22 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Marketplace | 1 | 16.7% | 100.0% | 11 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Penfed | 1 | 16.7% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| CarGurus | 3 | 23.1% | 100.0% | 7 min 100.0% ≤15 min · n=3 | 0 | 0.0% |
| Costco Auto Program | 3 | 23.1% | 100.0% | 11 min 100.0% ≤15 min · n=3 | 0 | 0.0% |
| Edmunds | 1 | 7.7% | 100.0% | 2 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Total / avg | 13 | 100.0% | 100.0% | 8 min 100.0% ≤15 min · n=13 | 0 | 0.0% |
Campaigns & conquest 0 · 0.0% of internet · close — · avg —
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Afs - Off Lease In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Lease In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 0 | 100.0% | — | — | 0 | — |
Other internet 3 · 4.3% of internet · close 0.0% · avg 0 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Regional Event - Inter Miami Cf | 3 | 100.0% | 100.0% | 0 min 100.0% ≤15 min · n=3 * | 0 | 0.0% |
| Total / avg | 3 | 100.0% | 100.0% | 0 min 100.0% ≤15 min · n=3 * | 0 | 0.0% |
3) Phone and walk-in detail
Phone 27 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Phone Up | 14 | 51.9% | 100.0% | — | 1 | 7.1% |
| Repeat Customer | 5 | 18.5% | 100.0% | — | 1 | 20.0% |
| Mining (Sales) | 2 | 7.4% | 100.0% | — | 0 | 0.0% |
| Service Dept | 2 | 7.4% | 100.0% | — | 0 | 0.0% |
| Walk In | 2 | 7.4% | 100.0% | — | 0 | 0.0% |
| Mastermind | 1 | 3.7% | 100.0% | — | 0 | 0.0% |
| Referral | 1 | 3.7% | 100.0% | — | 0 | 0.0% |
| Total / avg | 27 | 100.0% | 100.0% | — | 2 | 7.4% |
Walk-in 28 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Walk In | 23 | 82.1% | 100.0% | — | 2 | 8.7% |
| Service Dept | 5 | 17.9% | 100.0% | — | 1 | 20.0% |
| Total / avg | 28 | 100.0% | 100.0% | — | 3 | 10.7% |
Stage 4 · Lead handling quality
How well are we taking care of the leads?
Speed and contact coverage when the CRM export includes them; how the team tries to reach customers (phone / email / text); retail close and open pipeline. Source mix lives on the Leads tab.
Pertinent handling numbers
Date range: Oct 10 – Nov 8, 2026 (vs prior 30 days Sep 10 – Oct 9, 2026)
What this section is
Handling grades for rolling 30 on unique opportunities after de-dupe.
Bad CRM leads are excluded. Contact and speed grades appear only when the CRM export includes attempt fields.
Handling color legend
GoodKPI is in the healthy band for that metric
WatchKPI is middling — keep an eye on it
ProblemKPI is below the store target band
Per-card rulesInternet contact ≥90% good / <75% problem · response goal ≤15 min (after 15 = not good; ≥25% over 30 = problem even if median looks ok) · retail close ≥8% good / <5% problem · untouched 0 good
1) Internet contact rate
Internet leads only · workable unique opportunities · Oct 10 – Nov 8, 2026
Good
100.0%
same as prior 30 days · Prior (Sep 10 – Oct 9, 2026): 100.0%
Internet workable (excl. Bad): 69 · worked 69
All-channel contact (for context): 100.0% on 124 workable opps
Unique after de-dupe: 169 · CRM rows before de-dupe: 211 · collapsed 42 repeats
Internet workable (excl. Bad): 69 · worked 69
All-channel contact (for context): 100.0% on 124 workable opps
Unique after de-dupe: 169 · CRM rows before de-dupe: 211 · collapsed 42 repeats
What this means
Of internet unique opportunities (de-duped, excluding Bad), how many show a real work attempt —
first contact attempt, phone/email/text, customer contact, or CRM contacted flag?
Phone-ups and walk-ins are not in this grade — those are almost always “contacted” by nature and inflate the number.
Higher is better. About 90%+ is good. Under 75% is a problem.
2) Internet response time (median)
Internet leads only · CRM adjusted response time · Oct 10 – Nov 8, 2026
Good
2 min
faster by 3 min vs prior 30 days · Prior (Sep 10 – Oct 9, 2026): 5 min
Based on 57 timed internet leads (of 69 internet workable opps)
Based on 57 timed internet leads (of 69 internet workable opps)
Store goal: first internet response in ≤15 minutes. After 15 min = not good. Over 30 min = missed goal.
≤15 min · on goal36 (63.2%)
16–30 min · late (after 15)20 (35.1%)
Over 30 min · missed goal1 (1.8%)
No timed response12
After the 15-min goal: 21 timed internet leads (36.8%) were slower than 15 minutes (20 in 16–30 · 1 over 30). Any first response after 15 min is not good.
What this means
Internet only, using VinSolutions adjusted response time when the export includes it.
Phone-ups and walk-ins are not mixed in — they often show as 0 minutes and fake a fast store.
Goal is ≤15 minutes. Any first response after 15 min is not good.
The red over 30 min bucket is the problem list — read it even when the median looks okay.
Bands: ≤15 on goal · 16–30 late · over 30 missed goal.
3) Retail close rate
VinSolutions retail sold ÷ retail workable · wholesale separate · Oct 10 – Nov 8, 2026 · DMS deals file not used this window
Good
16.1%
↑ 1.7 pts vs prior 30 days · Prior (Sep 10 – Oct 9, 2026): 14.4%
Retail sold (VinSolutions): 20 of 124 retail workable · Delivered 20 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Oct 10 – Nov 8, 2026) — close from VinSolutions leads email
Retail sold (VinSolutions): 20 of 124 retail workable · Delivered 20 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Oct 10 – Nov 8, 2026) — close from VinSolutions leads email
What this means
Headline close uses VinSolutions lead export retail sold ÷ retail workable (Motosnap leads email). DMS deals are optional — used only when that file covers this window.
Retail close only — acquisition and wholesale/auction solds stay on the Leads tab and out of this grade.
On Order is still a retail sold (customer has a car ordered) — counted in close, broken out from Delivered.
DMS deals file through Aug 07, 2026 does not cover this window (Oct 10 – Nov 8, 2026) — close from VinSolutions leads email
Rough store-level bands used here: ≥8% good · 5–8% watch · under 5% problem.
4) Untouched over 24 hours
Workable opps still with no attempt · as of Nov 09, 2026
Good
0
From opportunities in Oct 10 – Nov 8, 2026
What this means
Workable leads still sitting with zero attempt after a full day. Ideal is 0. This is the same-day coaching list.
How the team is trying to reach customers
Workable opportunities · Oct 10 – Nov 8, 2026
What this means
Share of opportunities where phone, email, or text attempts were logged. Multi-channel = two or more methods on the same opportunity. This is handling effort mix — not demand shape.
| Method | Share of workable opps | Plain English |
|---|---|---|
| Phone attempt | 64.5% | Someone tried calling |
| Email attempt | 71.0% | Someone sent an email |
| Text attempt | 65.3% | Someone sent a text |
| Multi-channel | 69.4% | Used 2+ methods on the same opp |
| Customer contact logged | 76.6% | CRM shows an actual customer connect, not only outbound |
Needs attention
Based on unique opportunities in Oct 10 – Nov 8, 2026
What this means
Handling problems to bring into the next sales meeting — slow or no-attempt work, untouched leads, named coaching flags.
Source mix and close-by-origin live on the Leads tab.
- Audi Partner: 17 opportunities, close rate 0.0% — keep separate from website quality.
Stage 5 · People + execution
Salesperson effectiveness
Who owns volume and retail close — and where coaching should start — by team group.
Sales team scoreboard
Workable unique opportunities · Oct 10 – Nov 8, 2026 · split by VinSolutions team · most sold first inside each group
New New Sales 121 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| Jak Langston | 42 opps9 sold21.4% close | 9 min 65.0% ≤15 · n=20 | 24 opps6 sold25.0% close | 16 opps2 sold12.5% close | 2 opps1 sold50.0% close | ——— | 100.0% | 0 |
| David Marcantel | 31 opps5 sold16.1% close | 11 min 50.0% ≤15 · n=12 · drop 1 >4h | 15 opps3 sold20.0% close | 3 opps0 sold0.0% close | 13 opps2 sold15.4% close | ——— | 100.0% | 0 |
| Randon Kimery | 24 opps3 sold12.5% close | 4 min 85.7% ≤15 · n=14 | 15 opps3 sold20.0% close | 6 opps0 sold0.0% close | 3 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Steven Montgomery | 22 opps2 sold9.1% close | 12 min 40.0% ≤15 · n=10 | 12 opps2 sold16.7% close | 1 opps0 sold0.0% close | 9 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Don Harry | 2 opps1 sold50.0% close | — | 2 opps1 sold50.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Total / avg | 121 opps20 sold16.5% close | 8 min 62.5% ≤15 · n=56 · drop 1 >4h | 68 opps15 sold22.1% close | 26 opps2 sold7.7% close | 27 opps3 sold11.1% close | ——— | 100.0% | 0 |
Orphan 3 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| Your Friends at Audi Baton Rouge | 1 opps0 sold0.0% close | — | ——— | ——— | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Your Internet Friends At Audi Baton Rouge | 1 opps0 sold0.0% close | 14 min 100.0% ≤15 · n=1 | 1 opps0 sold0.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Your Service Dept at Audi Baton Rouge | 1 opps0 sold0.0% close | — | ——— | 1 opps0 sold0.0% close | ——— | ——— | 100.0% | 0 |
| Total / avg | 3 opps0 sold0.0% close | 14 min 100.0% ≤15 · n=1 | 1 opps0 sold0.0% close | 1 opps0 sold0.0% close | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
Scoreboard legend
Green rowOverall close rate 14% or higher
Red rowOverall close rate under 14%
Gray rowFewer than 3 workable leads, or system / unassigned
Sort orderMost units sold at the top inside each team group (New Sales first, then Used)
Avg responseInternet timed leads only · average drops responses over 4 hours (overnight/slow-tail outliers) · % ≤15 still uses all timed
How to read this
New Sales first, then Used Sales on the Store view. Channel columns = opps · sold · close %.
On Order solds show under Total as N on order.
Avg response = internet timed only; average drops responses over 4 hours.
Opps — workable unique opportunities assigned to them.
Total / channel columns — opps · sold · close % (sold ÷ that channel’s opps).
Internet contact — % of their internet leads with a real work attempt.
Avg response — internet timed only; average drops responses over 4 hours; shows % ≤15.
Date ranges on this page
Rolling 30: Oct 10 – Nov 8, 2026.
Prior 30 days: Sep 10 – Oct 9, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-10-07 → 2026-11-05): 24,428 visits · 21,917 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Rolling 30: Oct 10 – Nov 8, 2026.
Prior 30 days: Sep 10 – Oct 9, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-10-07 → 2026-11-05): 24,428 visits · 21,917 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Data coverage — Prior window: Lead export only covers Aug 11 – Nov 09, 2026. This window is partial (effective Aug 11 – Sep 9, 2026). Closed-deal (DMS) history may still be complete.
Last 60 days at a glance · New
Last 60 days · New department: 235 retail workable opportunities (323 unique after de-dupe; Bad excluded); retail close 15.3% (36 retail sold); internet is 58.3% of retail workable; internet CRM contact 100.0%; internet median response 4 min; Audi Partner is 42 opps at 2.4% close — watch list.
Rolling 60: Sep 10 – Nov 8, 2026 · compared with prior 60 days Jul 12 – Sep 9, 2026
Funnel stages are tabs — click through Traffic → Inventory → Demand shape → Leads → Handling → People. Print still shows every stage.
Stage 1 · Top of funnel
Website traffic
People visiting audibatonrouge.com (and related store sites) before any CRM lead is created.
Total website traffic picture
Google Analytics · last ~30 days in cache dated 2026-11-06 · align with CRM window Sep 10 – Nov 8, 2026 where possible
What this means
This is the top of the sales funnel: how much store-site demand you are generating.
Traffic alone is not leads — next is what the store has to sell (active inventory), then how demand becomes CRM opportunities
(website forms, 3rd-party portals, then phone and walk-in).
Visits (sessions)
45,633
One visit = one trip to the site
People (users)
40,947
Unique visitors
Page views
74,343
1.7 pages per visit
Avg time on site
2m 12s
Average visit length (GA4 session duration)
Engagement rate
35.9%
Visits with meaningful activity
Bounce rate
64.1%
Left after one page — lower is usually better
Mobile share
56.2%
Visits from phones/tablets
Where site traffic came from (top sources)
How to read this
Top source families (Facebook hosts rolled up, IG together, etc.). Mix indicators — not required to sum to total site sessions above.
Marketplace referrals (Autotrader, KBB, CarGurus…) are site visits from those portals — different labels from VinSolutions lead sources.
| Source / medium | Visits | People | Avg time | Bounce |
|---|---|---|---|---|
| Direct | 19,071 | 16,123 | — | — |
| Google paid | 11,002 | 7,965 | — | — |
| Google organic | 9,339 | 4,649 | — | — |
| Facebook WAFB / GDM 360 Streaming, WAFB / GDM 360 Display | 3,508 | 3,378 | — | — |
| cdn.flashtalking.com (referral) cdn.flashtalking.com referral | 3,019 | 2,913 | — | — |
| Facebook paid fb / paid, facebook / paid | 2,629 | 2,424 | — | — |
| Instagram paid ig / paid | 2,437 | 2,247 | — | — |
| Unassigned / not set Not set Most likely a measurement gap — quick bounces or tag/consent timing on the Porsche site so GA4 never got source/medium (often Google/direct under the hood). Not a real marketing channel to coach against. A few visits may also be Google “data not available” privacy/cross-network rows. | 2,128 | 2,125 | — | — |
| imasdk.googleapis.com (referral) imasdk.googleapis.com referral | 1,589 | 1,585 | — | — |
| Autotrader autotrader.com / social | 1,440 | 1,105 | — | — |
| Bing organic | 1,084 | 569 | — | — |
| audiusa.com (referral) audiusa.com referral | 719 | 464 | — | — |
| Pinterest / PaidSocial | 538 | 506 | — | — |
| newsletter / email | 522 | 408 | — | — |
| trafficheap.cc (referral) trafficheap.cc referral | 494 | 494 | — | — |
| VinURL VinURL referral | 450 | 304 | — | — |
| Ad tech / other tpc.googlesyndication.com referral Ad-tech / safeframe noise — usually not a vendor you can work as a lead source. | 424 | 419 | — | — |
| Yahoo organic | 220 | 113 | — | — |
Marketplace referrals into the website
How to read this
Shoppers who landed on the store site from big inventory portals.
Still website traffic — not CRM leads. A portal shopper can bounce here and still show up later as Phone Up.
| Portal referral | Visits | People | Avg time | Bounce |
|---|---|---|---|---|
| No marketplace referral traffic in top sources this window (Autotrader / KBB / CarGurus / Cars.com / etc.). | ||||
Where on the site (sales · service · parts · specials)
How to read this
Sessions on page groups: inventory/VDPs (sales), service, parts, specials/offers, finance/trade, store info.
Porsche sites often put service booking on a separate host — if Service is thin here, check service-booking host traffic separately.
| Site section | Visits | People | Page views |
|---|---|---|---|
| Page-section breakdown not in GA4 cache yet for this store. | |||
Website traffic mix only — not the same labels as CRM lead sources. No source total row (avoids a sum that can exceed site sessions).
Stage 1b · Supply next to demand
Inventory health (active lot)
What the store has to sell right now — after website traffic, before CRM leads. Not lead handling.
Store inventory on the ground
VinSolutions live-lot units · snapshot file abr-inventory-latest.csv · as of Nov 09, 2026 7:01 AM · lead window for context Sep 10 – Nov 8, 2026
What this means
Live lot composition and aging. Traffic and 3rd-party demand only convert if the metal matches what shoppers want.
File rows: 4,260 → lot units shown: 90.
This is not contact rate or response speed — those start at Stage 4 (Handling).
Active total
90
Units in Active status
New
90
100.0% of active lot
Used
0
Retail used (excl. Certified)
Certified
0
CPO subset of the lot
Median age
63 d
Days in inventory (Active)
No photo
8
8.9% of active units
Age of active inventory
| Age bucket | Units | Share |
|---|---|---|
| 0–30 days | 22 | 24.4% |
| 31–60 days | 23 | 25.6% |
| 61–90 days | 16 | 17.8% |
| 91–180 days | 19 | 21.1% |
| 180+ days | 10 | 11.1% |
| Total aged units | 90 | 100% |
Aging by New / Used / Certified
| Type | Units | Median age | >60d | >90d | >180d |
|---|---|---|---|---|---|
| New | 90 | 63 d | 45 | 29 | 10 |
| All active | 90 | 63 d | 45 | 29 | 10 |
New — top models
| Unit | Count | Share of active lot |
|---|---|---|
| Q5 | 28 | 31.1% |
| Q8 | 16 | 17.8% |
| Q7 | 8 | 8.9% |
| A5 | 7 | 7.8% |
| A6 Sedan | 6 | 6.7% |
| SQ5 | 5 | 5.6% |
| Q3 | 3 | 3.3% |
| S5 | 2 | 2.2% |
| SQ8 | 2 | 2.2% |
| RS Q8 | 2 | 2.2% |
| Top listed | 79 | 87.8% |
Used + Certified — top make / model
| Unit | Count | Share of active lot |
|---|---|---|
| No used/CPO units | ||
Photo gap: 8 active units (8.9%) marked without a photo — website and marketplace presentation risk, separate from lead handling.
Source: VinSolutions inventory export (live lot). Website search counts can differ — this panel is the ops lot from the CRM file, not a scrape of the public inventory grid.
Stage 2 · Demand shape
How demand shows up
Vehicles of interest and trades — demand pressure next to traffic and inventory. Attempt methods (phone / email / text) live on Handling.
What cars people asked about
Workable opportunities · Sep 10 – Nov 8, 2026
What this means
Vehicle of interest on the lead when CRM has it. Helps with stocking and coaching — not a sold report.
| New / used / CPO interest | Opps | Share |
|---|---|---|
| New | 188 | 80.0% |
| Unknown | 34 | 14.5% |
| Used | 11 | 4.7% |
| Certified | 2 | 0.9% |
| Total | 235 | 100.0% |
Top vehicles of interest Sep 10 – Nov 8, 2026
| Year / make / model | Opps | Share |
|---|---|---|
| 2026 Audi Q5 | 33 | 17.2% |
| 2026 Audi Q7 | 22 | 11.5% |
| 2026 Audi Q3 | 21 | 10.9% |
| 2026 Audi Q8 | 12 | 6.2% |
| 2026 Audi A5 | 9 | 4.7% |
| 2026 Audi A3 | 6 | 3.1% |
| 2027 Audi Q5 | 6 | 3.1% |
| 2026 Audi SQ5 | 6 | 3.1% |
| 2027 Audi Q3 | 5 | 2.6% |
| 2027 Audi Q7 | 5 | 2.6% |
| Total | 125 | 100.0% |
Trade-ins mentioned
Workable opportunities · Sep 10 – Nov 8, 2026
What this means
30.2% of workable opportunities included a trade vehicle.
Higher trade rates often signal more serious shoppers.
| Trade year / make / model | Opps | Share of trades |
|---|---|---|
| 2024 Audi Q3 | 7 | 9.9% |
| 2023 Audi Q5 | 5 | 7.0% |
| 2024 Chevrolet Silverado 1500 | 2 | 2.8% |
| 2023 Audi A5 | 2 | 2.8% |
| 2024 Audi Q5 | 2 | 2.8% |
| 2020 Audi Q5 | 2 | 2.8% |
| 2025 Audi Q7 | 1 | 1.4% |
| 2025 BMW iX | 1 | 1.4% |
| Total | 22 | 100.0% |
Stage 3 · Demand becomes leads
CRM opportunities from website + 3rd parties
Unique sales opportunities (de-duped) created in VinSolutions for Sep 10 – Nov 8, 2026. Website and marketplace demand show up as internet forms, then also as phone and walk-in — including full source detail on this tab.
Lead volume entering the funnel
Unique opportunities · Sep 10 – Nov 8, 2026 · de-duped · retail workable = excl. Bad + excl. acquisition
What this means
CRM sales opportunities after de-dupe. Same shopper is not counted three times as internet + phone + walk-in.
Retail workable drops Bad junk and acquisition leads (cash/trade value requests — not a retail buy).
Unique after de-dupe
323
From 392 raw CRM rows · 69 repeats collapsed
Retail workable
235
Excl. Bad (88) · excl. acquisition (0)
Retail sold
36
VinSolutions retail sold · close 15.3% of 235 retail workable
DMS deals file through Aug 07, 2026 does not cover this window (Sep 10 – Nov 8, 2026) — close from VinSolutions leads email
DMS deals file through Aug 07, 2026 does not cover this window (Sep 10 – Nov 8, 2026) — close from VinSolutions leads email
Delivered
36
CRM status Delivered · of retail sold
On Order
0
CRM status On Order · sold, not delivered yet
Wholesale / auction sold
0
DMS outlets · separate from retail close · total sold 36
A) Where digital retail demand is sourced
Funnel read
Owned website + on-site tools (Motive, store forms/chat, Carcode) vs 3rd-party portals (Autotrader/KBB, CarGurus, Carfax…) vs OEM partner feeds. These sources create internet opportunities — and often later phone/walk-in on the same shopper.
| Digital source family | Workable opps | Share of internet | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Dealer website & on-site | 47 | 34.3% | 100.0% | 7 min 80.0% ≤15 min · n=30 |
23 | 48.9% |
| Autotrader / KBB ATKBB | 5 | 3.6% | 100.0% | 54 min 20.0% ≤15 min · n=5 |
0 | 0.0% |
| Other 3rd-party marketplaces | 28 | 20.4% | 100.0% | 10 min 71.4% ≤15 min · n=28 · avg on 26 |
0 | 0.0% |
| Audi Partner (OEM partner) | 42 | 30.7% | 100.0% | 17 min 57.1% ≤15 min · n=42 · avg on 41 |
1 | 2.4% |
| OEM / brand digital | 11 | 8.0% | 100.0% | 7 min 72.7% ≤15 min · n=11 |
0 | 0.0% |
| Total / avg (families above) | 133 | — | — | — | 24 | 18.0% |
Digital families above total 133 workable internet-side rows shown in those buckets; internet CRM channel is 137. Gap is other internet sources (campaigns, uncategorized, etc.) detailed under Source detail. Response = VinSolutions average adjusted response minutes (excludes responses over 4 hours) (+ % ≤15). Internet is the reliable speed signal.
Big-vendor demand by channel (CRM)
How to read this
VinSolutions opportunities from major portals, split Internet / Phone / Walk-in.
Portal website referrals live on Traffic — this is CRM-attributed demand.
| Vendor | Internet | Phone | Walk-in | Total opps | Sold |
|---|---|---|---|---|---|
| Autotrader / KBB | 5 | 0 | 0 | 5 | 0 |
| CarGurus | 10 | 0 | 0 | 10 | 0 |
| TrueCar | 12 | 0 | 0 | 12 | 0 |
| Edmunds | 6 | 0 | 0 | 6 | 0 |
Thin Phone often means portal call-ins were logged as generic Phone Up without the vendor source.
B) How opportunities show up in the CRM (channel)
Funnel read
Website and 3rd-party activity turns into internet form leads, phone calls, and walk-ins (plus Other CRM types).
Close = retail sold ÷ retail workable on the hero grade; per-row close uses that channel’s workable opps.
Contacted = real work attempt on that channel.
Response uses adjusted minutes when present — Phone/Walk-in often log 0 min (* = half or more timed at 0; treat as weak signal).
| CRM channel | Workable opps | Share | Contacted | Avg response | Sold | Close | Plain English |
|---|---|---|---|---|---|---|---|
| Internet (web forms / digital) | 137 | 58.3% | 100.0% | 13 min 67.5% ≤15 min · n=120 · avg on 117 |
24 | 17.5% | Forms, portals, chat, partner feeds |
| Phone | 52 | 22.1% | 100.0% | — | 6 | 11.5% | Phone-ups / tracked calls |
| Walk-in | 46 | 19.6% | 100.0% | — | 6 | 13.0% | In-store / drive-by |
| Other | — | — | — | — | — | — | Referral, repeat, DMS, other CRM types |
| Total / avg | 235 | 100.0% | 100.0% | — | 36 | 15.3% |
Source detail
Unique workable opportunities · Sep 10 – Nov 8, 2026 · de-duped · same funnel window · Close = sold ÷ opps · Response = average adjusted minutes (over 4 hours dropped from average)
What this means
Drill-down on where demand came from — owned website vs Autotrader/KBB vs other portals vs OEM partner, then phone and walk-in. High volume + low close often means a source quality issue. Whether the team worked those leads fast belongs on the Handling tab. Dealer website includes Motive, store-domain forms/chat, and Carcode. Autotrader/KBB is one 3rd party with many of their own channels.
Response sits next to close so you can see whether slow first touch lines up with weak conversion. * on response = half or more timed values are 0 (common on phone/walk-in — weak signal).
1) Channel mix
| Channel | Opps | Share | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Internet | 137 | 58.3% | 100.0% | 13 min 67.5% ≤15 min · n=120 · avg on 117 | 24 | 17.5% |
| Phone | 52 | 22.1% | 100.0% | — | 6 | 11.5% |
| Walk-in | 46 | 19.6% | 100.0% | — | 6 | 13.0% |
| Total / avg | 235 | 100.0% | 100.0% | 13 min 100.0% ≤15 min · n=120 | 36 | 15.3% |
2) Internet broken down
Families inside internet · Sep 10 – Nov 8, 2026
Audi Partner leads — watch list 42 opps · close 2.4% · contact 100.0% · avg 17 min
Why this is split out
Audi Partner is an OEM partner feed. High volume can distort website and marketplace quality if mixed in.
Keep it separate. Grade on unique opportunities, contact, response speed, and close — not volume alone.
| Sub-type | Opps | Share | Contacted | Avg response | Sold | Close rate | Bad |
|---|---|---|---|---|---|---|---|
| Audi Partner — New / main | 41 | 97.6% | 100.0% | 18 min 56.1% ≤15 min · n=41 · avg on 40 | 1 | 2.4% | 12 |
| Audi Partner — Used/CPO | 1 | 2.4% | 100.0% | 2 min 100.0% ≤15 min · n=1 | 0 | 0.0% | 0 |
| Total / avg | 42 | 100.0% | 100.0% | 17 min 2.4% ≤15 min · n=42 | 1 | 2.4% | 12 |
What’s on the lead VinSolutions only has two Partner source names (Used/CPO vs New/main). Extra detail is the vehicle of interest on the opportunity — not a finer OEM sub-source.
| Inventory type on the lead | Opps | Share |
|---|---|---|
| New | 39 | 92.9% |
| Used | 2 | 4.8% |
| Certified | 1 | 2.4% |
| Vehicle of interest | Opps | Share |
|---|---|---|
| 2027 Audi Q5 | 6 | 14.3% |
| 2027 Audi Q3 | 4 | 9.5% |
| 2026 Audi Q3 | 3 | 7.1% |
| 2026 Audi Q5 | 3 | 7.1% |
| 2026 Audi A6 allroad | 2 | 4.8% |
| 2026 Audi Q4 Sportback e-tron | 2 | 4.8% |
| 2026 Audi A5 | 2 | 4.8% |
| 2027 Audi Q7 | 2 | 4.8% |
| 2027 Audi A5 | 2 | 4.8% |
| 2026 Audi Q4 e-tron | 1 | 2.4% |
| 2027 Audi Q6 e-tron | 1 | 2.4% |
| 2027 Audi SQ5 | 1 | 2.4% |
| 2027 Audi Q6 Sportback e-tron | 1 | 2.4% |
| 2025 Audi Q8 | 1 | 2.4% |
| 2027 Audi A8 | 1 | 2.4% |
| 2027 Audi A6 | 1 | 2.4% |
| 2026 Audi A3 | 1 | 2.4% |
| 2027 Audi A3 | 1 | 2.4% |
Dealer website & on-site 47 · 34.3% of internet · close 48.9% · avg 7 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Routeone Llc | 17 | 36.2% | 100.0% | — | 12 | 70.6% |
| Motive — Website | 13 | 27.7% | 100.0% | 5 min 92.3% ≤15 min · n=13 | 6 | 46.2% |
| Motive — Credit | 5 | 10.6% | 100.0% | 8 min 80.0% ≤15 min · n=5 | 2 | 40.0% |
| Motive — Qualify | 3 | 6.4% | 100.0% | 5 min 100.0% ≤15 min · n=3 | 2 | 66.7% |
| Website chat — Edmunds Carcode | 3 | 6.4% | 100.0% | 8 min 66.7% ≤15 min · n=3 | 0 | 0.0% |
| Motive Test Drive | 2 | 4.3% | 100.0% | 10 min 50.0% ≤15 min · n=2 * | 1 | 50.0% |
| Motive — Trade | 1 | 2.1% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| 700credit - Quickqualify | 1 | 2.1% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| 700credit.Com | 1 | 2.1% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Dealer.Com - Get Eprice | 1 | 2.1% | 100.0% | 19 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Total / avg | 47 | 100.0% | 100.0% | 7 min 93.3% ≤15 min · n=30 | 23 | 48.9% |
OEM / brand digital 11 · 8.0% of internet · close 0.0% · avg 7 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Oadd - Vdp Vehicle Inquiry - I Want This One | 3 | 27.3% | 100.0% | 0 min 100.0% ≤15 min · n=3 * | 0 | 0.0% |
| Audiusa - Configure Your Vehicle - | 3 | 27.3% | 100.0% | 7 min 66.7% ≤15 min · n=3 * | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - Tell Me More | 2 | 18.2% | 100.0% | 12 min 50.0% ≤15 min · n=2 | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - | 1 | 9.1% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Car And Driver - Audiusa Trade In | 1 | 9.1% | 100.0% | 14 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - Contact Dealer | 1 | 9.1% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Total / avg | 11 | 100.0% | 100.0% | 7 min 90.9% ≤15 min · n=11 | 0 | 0.0% |
ATKBBAutotrader / KBB (one 3rd party · their channels) 5 · 3.6% of internet · close 0.0% · avg 54 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| ATAutotrader — Internet lead | 4 | 80.0% | 100.0% | 47 min 25.0% ≤15 min · n=4 | 0 | 0.0% |
| ATAutotrader — Market extension | 1 | 20.0% | 100.0% | 1h 21m 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Total / avg | 5 | 100.0% | 100.0% | 54 min 0.0% ≤15 min · n=5 | 0 | 0.0% |
Third-party marketplaces (grouped by brand · product feeds indented) 28 · 20.4% of internet · close 0.0% · avg 10 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| TrueCar 7 product feeds | 12 | 42.9% | 100.0% | 15 min 58.3% ≤15 min · n=12 | 0 | 0.0% |
| Credit Karma | 3 | 25.0% | 100.0% | 0 min 100.0% ≤15 min · n=3 * | 0 | 0.0% |
| Marketplace | 3 | 25.0% | 100.0% | 42 min 66.7% ≤15 min · n=3 | 0 | 0.0% |
| Perkspot | 2 | 16.7% | 100.0% | 7 min 100.0% ≤15 min · n=2 * | 0 | 0.0% |
| Benefithub | 1 | 8.3% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Consumer Reports | 1 | 8.3% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Lifecare | 1 | 8.3% | 100.0% | 22 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Penfed | 1 | 8.3% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| CarGurus 2 product feeds | 10 | 35.7% | 100.0% | 6 min 100.0% ≤15 min · n=10 | 0 | 0.0% |
| Marketplace | 8 | 80.0% | 100.0% | 6 min 50.0% ≤15 min · n=8 · avg on 6 | 0 | 0.0% |
| Area Boost | 2 | 20.0% | 100.0% | 4 min 100.0% ≤15 min · n=2 | 0 | 0.0% |
| Costco Auto Program | 3 | 10.7% | 100.0% | 11 min 100.0% ≤15 min · n=3 | 0 | 0.0% |
| Edmunds | 3 | 10.7% | 100.0% | 2 min 100.0% ≤15 min · n=3 | 0 | 0.0% |
| Total / avg | 28 | 100.0% | 100.0% | 10 min 57.1% ≤15 min · n=28 | 0 | 0.0% |
Campaigns & conquest 0 · 0.0% of internet · close — · avg —
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Afs - Off Lease In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Lease In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 0 | 100.0% | — | — | 0 | — |
Other internet 4 · 2.9% of internet · close 0.0% · avg 2 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Regional Event - Inter Miami Cf | 3 | 75.0% | 100.0% | 0 min 100.0% ≤15 min · n=3 * | 0 | 0.0% |
| Acquire Service | 1 | 25.0% | 100.0% | 6 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Q9-Order-Info | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 4 | 100.0% | 100.0% | 2 min 100.0% ≤15 min · n=4 * | 0 | 0.0% |
3) Phone and walk-in detail
Phone 52 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Phone Up | 23 | 44.2% | 100.0% | — | 2 | 8.7% |
| Repeat Customer | 12 | 23.1% | 100.0% | — | 1 | 8.3% |
| Service Dept | 6 | 11.5% | 100.0% | — | 0 | 0.0% |
| Referral | 4 | 7.7% | 100.0% | — | 2 | 50.0% |
| Mining (Sales) | 3 | 5.8% | 100.0% | — | 1 | 33.3% |
| Walk In | 3 | 5.8% | 100.0% | — | 0 | 0.0% |
| Mastermind | 1 | 1.9% | 100.0% | — | 0 | 0.0% |
| Total / avg | 52 | 100.0% | 100.0% | — | 6 | 11.5% |
Walk-in 46 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Walk In | 36 | 78.3% | 100.0% | — | 4 | 11.1% |
| Service Dept | 7 | 15.2% | 100.0% | — | 1 | 14.3% |
| Repeat Customer | 2 | 4.3% | 100.0% | — | 1 | 50.0% |
| Phone Up | 1 | 2.2% | 100.0% | — | 0 | 0.0% |
| Total / avg | 46 | 100.0% | 100.0% | — | 6 | 13.0% |
Stage 4 · Lead handling quality
How well are we taking care of the leads?
Speed and contact coverage when the CRM export includes them; how the team tries to reach customers (phone / email / text); retail close and open pipeline. Source mix lives on the Leads tab.
Pertinent handling numbers
Date range: Sep 10 – Nov 8, 2026 (vs prior 60 days Jul 12 – Sep 9, 2026)
What this section is
Handling grades for rolling 60 on unique opportunities after de-dupe.
Bad CRM leads are excluded. Contact and speed grades appear only when the CRM export includes attempt fields.
Handling color legend
GoodKPI is in the healthy band for that metric
WatchKPI is middling — keep an eye on it
ProblemKPI is below the store target band
Per-card rulesInternet contact ≥90% good / <75% problem · response goal ≤15 min (after 15 = not good; ≥25% over 30 = problem even if median looks ok) · retail close ≥8% good / <5% problem · untouched 0 good
1) Internet contact rate
Internet leads only · workable unique opportunities · Sep 10 – Nov 8, 2026
Good
100.0%
same as prior 60 days · Prior (Jul 12 – Sep 9, 2026): 100.0%
Internet workable (excl. Bad): 137 · worked 137
All-channel contact (for context): 100.0% on 235 workable opps
Unique after de-dupe: 323 · CRM rows before de-dupe: 392 · collapsed 69 repeats
Internet workable (excl. Bad): 137 · worked 137
All-channel contact (for context): 100.0% on 235 workable opps
Unique after de-dupe: 323 · CRM rows before de-dupe: 392 · collapsed 69 repeats
What this means
Of internet unique opportunities (de-duped, excluding Bad), how many show a real work attempt —
first contact attempt, phone/email/text, customer contact, or CRM contacted flag?
Phone-ups and walk-ins are not in this grade — those are almost always “contacted” by nature and inflate the number.
Higher is better. About 90%+ is good. Under 75% is a problem.
2) Internet response time (median)
Internet leads only · CRM adjusted response time · Sep 10 – Nov 8, 2026
Good
4 min
faster by 16 min vs prior 60 days · Prior (Jul 12 – Sep 9, 2026): 21 min
Based on 120 timed internet leads (of 137 internet workable opps)
Based on 120 timed internet leads (of 137 internet workable opps)
Store goal: first internet response in ≤15 minutes. After 15 min = not good. Over 30 min = missed goal.
≤15 min · on goal81 (67.5%)
16–30 min · late (after 15)29 (24.2%)
Over 30 min · missed goal10 (8.3%)
No timed response17
What this means
Internet only, using VinSolutions adjusted response time when the export includes it.
Phone-ups and walk-ins are not mixed in — they often show as 0 minutes and fake a fast store.
Goal is ≤15 minutes. Any first response after 15 min is not good.
The red over 30 min bucket is the problem list — read it even when the median looks okay.
Bands: ≤15 on goal · 16–30 late · over 30 missed goal.
3) Retail close rate
VinSolutions retail sold ÷ retail workable · wholesale separate · Sep 10 – Nov 8, 2026 · DMS deals file not used this window
Good
15.3%
↑ 2.7 pts vs prior 60 days · Prior (Jul 12 – Sep 9, 2026): 12.6%
Retail sold (VinSolutions): 36 of 235 retail workable · Delivered 36 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Sep 10 – Nov 8, 2026) — close from VinSolutions leads email
Retail sold (VinSolutions): 36 of 235 retail workable · Delivered 36 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Sep 10 – Nov 8, 2026) — close from VinSolutions leads email
What this means
Headline close uses VinSolutions lead export retail sold ÷ retail workable (Motosnap leads email). DMS deals are optional — used only when that file covers this window.
Retail close only — acquisition and wholesale/auction solds stay on the Leads tab and out of this grade.
On Order is still a retail sold (customer has a car ordered) — counted in close, broken out from Delivered.
DMS deals file through Aug 07, 2026 does not cover this window (Sep 10 – Nov 8, 2026) — close from VinSolutions leads email
Rough store-level bands used here: ≥8% good · 5–8% watch · under 5% problem.
4) Untouched over 24 hours
Workable opps still with no attempt · as of Nov 09, 2026
Good
0
From opportunities in Sep 10 – Nov 8, 2026
What this means
Workable leads still sitting with zero attempt after a full day. Ideal is 0. This is the same-day coaching list.
How the team is trying to reach customers
Workable opportunities · Sep 10 – Nov 8, 2026
What this means
Share of opportunities where phone, email, or text attempts were logged. Multi-channel = two or more methods on the same opportunity. This is handling effort mix — not demand shape.
| Method | Share of workable opps | Plain English |
|---|---|---|
| Phone attempt | 71.9% | Someone tried calling |
| Email attempt | 70.6% | Someone sent an email |
| Text attempt | 68.1% | Someone sent a text |
| Multi-channel | 73.6% | Used 2+ methods on the same opp |
| Customer contact logged | 75.7% | CRM shows an actual customer connect, not only outbound |
Needs attention
Based on unique opportunities in Sep 10 – Nov 8, 2026
What this means
Handling problems to bring into the next sales meeting — slow or no-attempt work, untouched leads, named coaching flags.
Source mix and close-by-origin live on the Leads tab.
- Audi Partner: 42 opportunities, close rate 2.4% — keep separate from website quality.
Stage 5 · People + execution
Salesperson effectiveness
Who owns volume and retail close — and where coaching should start — by team group.
Sales team scoreboard
Workable unique opportunities · Sep 10 – Nov 8, 2026 · split by VinSolutions team · most sold first inside each group
New New Sales 231 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| Jak Langston | 105 opps18 sold17.1% close | 14 min 73.2% ≤15 · n=56 | 65 opps12 sold18.5% close | 35 opps5 sold14.3% close | 5 opps1 sold20.0% close | ——— | 100.0% | 0 |
| Randon Kimery | 51 opps7 sold13.7% close | 11 min 73.3% ≤15 · n=30 · drop 2 >4h | 31 opps5 sold16.1% close | 9 opps0 sold0.0% close | 11 opps2 sold18.2% close | ——— | 100.0% | 0 |
| David Marcantel | 41 opps6 sold14.6% close | 18 min 55.6% ≤15 · n=18 · drop 1 >4h | 21 opps3 sold14.3% close | 3 opps0 sold0.0% close | 17 opps3 sold17.6% close | ——— | 100.0% | 0 |
| Steven Montgomery | 32 opps4 sold12.5% close | 10 min 46.7% ≤15 · n=15 | 17 opps3 sold17.6% close | 3 opps1 sold33.3% close | 12 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Don Harry | 2 opps1 sold50.0% close | — | 2 opps1 sold50.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Total / avg | 231 opps36 sold15.6% close | 13 min 67.2% ≤15 · n=119 · drop 3 >4h | 136 opps24 sold17.6% close | 50 opps6 sold12.0% close | 45 opps6 sold13.3% close | ——— | 100.0% | 0 |
Orphan 4 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| Your Friends at Audi Baton Rouge | 1 opps0 sold0.0% close | — | ——— | ——— | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Your Internet Friends At Audi Baton Rouge | 1 opps0 sold0.0% close | 14 min 100.0% ≤15 · n=1 | 1 opps0 sold0.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Your Service Dept at Audi Baton Rouge | 2 opps0 sold0.0% close | — | ——— | 2 opps0 sold0.0% close | ——— | ——— | 100.0% | 0 |
| Total / avg | 4 opps0 sold0.0% close | 14 min 100.0% ≤15 · n=1 | 1 opps0 sold0.0% close | 2 opps0 sold0.0% close | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
Scoreboard legend
Green rowOverall close rate 14% or higher
Red rowOverall close rate under 14%
Gray rowFewer than 3 workable leads, or system / unassigned
Sort orderMost units sold at the top inside each team group (New Sales first, then Used)
Avg responseInternet timed leads only · average drops responses over 4 hours (overnight/slow-tail outliers) · % ≤15 still uses all timed
How to read this
New Sales first, then Used Sales on the Store view. Channel columns = opps · sold · close %.
On Order solds show under Total as N on order.
Avg response = internet timed only; average drops responses over 4 hours.
Opps — workable unique opportunities assigned to them.
Total / channel columns — opps · sold · close % (sold ÷ that channel’s opps).
Internet contact — % of their internet leads with a real work attempt.
Avg response — internet timed only; average drops responses over 4 hours; shows % ≤15.
Date ranges on this page
Rolling 60: Sep 10 – Nov 8, 2026.
Prior 60 days: Jul 12 – Sep 9, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-09-07 → 2026-11-05): 45,633 visits · 40,947 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Rolling 60: Sep 10 – Nov 8, 2026.
Prior 60 days: Jul 12 – Sep 9, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-09-07 → 2026-11-05): 45,633 visits · 40,947 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Data coverage — Prior window: Lead export has no rows in this range (export Aug 11 – Nov 09, 2026).
Last 90 days at a glance · New
Last 90 days · New department: 344 retail workable opportunities (472 unique after de-dupe; Bad excluded); retail close 14.2% (49 retail sold); internet is 59.3% of retail workable; internet CRM contact 100.0%; internet median response 11 min; 19.4% of timed internet leads over 30 min (missed goal); Audi Partner is 68 opps at 1.5% close — watch list.
Rolling 90: Aug 11 – Nov 8, 2026 · compared with prior 90 days May 13 – Aug 10, 2026
Funnel stages are tabs — click through Traffic → Inventory → Demand shape → Leads → Handling → People. Print still shows every stage.
Stage 1 · Top of funnel
Website traffic
People visiting audibatonrouge.com (and related store sites) before any CRM lead is created.
Total website traffic picture
Google Analytics · last ~30 days in cache dated 2026-11-06 · align with CRM window Aug 11 – Nov 8, 2026 where possible
What this means
This is the top of the sales funnel: how much store-site demand you are generating.
Traffic alone is not leads — next is what the store has to sell (active inventory), then how demand becomes CRM opportunities
(website forms, 3rd-party portals, then phone and walk-in).
Visits (sessions)
63,488
One visit = one trip to the site
People (users)
56,804
Unique visitors
Page views
107,447
1.8 pages per visit
Avg time on site
2m 20s
Average visit length (GA4 session duration)
Engagement rate
36.4%
Visits with meaningful activity
Bounce rate
63.6%
Left after one page — lower is usually better
Mobile share
56.9%
Visits from phones/tablets
Where site traffic came from (top sources)
How to read this
Top source families (Facebook hosts rolled up, IG together, etc.). Mix indicators — not required to sum to total site sessions above.
Marketplace referrals (Autotrader, KBB, CarGurus…) are site visits from those portals — different labels from VinSolutions lead sources.
| Source / medium | Visits | People | Avg time | Bounce |
|---|---|---|---|---|
| Direct | 19,071 | 16,123 | — | — |
| Google paid | 11,002 | 7,965 | — | — |
| Google organic | 9,339 | 4,649 | — | — |
| Facebook WAFB / GDM 360 Streaming, WAFB / GDM 360 Display | 3,508 | 3,378 | — | — |
| cdn.flashtalking.com (referral) cdn.flashtalking.com referral | 3,019 | 2,913 | — | — |
| Facebook paid fb / paid, facebook / paid | 2,629 | 2,424 | — | — |
| Instagram paid ig / paid | 2,437 | 2,247 | — | — |
| Unassigned / not set Not set Most likely a measurement gap — quick bounces or tag/consent timing on the Porsche site so GA4 never got source/medium (often Google/direct under the hood). Not a real marketing channel to coach against. A few visits may also be Google “data not available” privacy/cross-network rows. | 2,128 | 2,125 | — | — |
| imasdk.googleapis.com (referral) imasdk.googleapis.com referral | 1,589 | 1,585 | — | — |
| Autotrader autotrader.com / social | 1,440 | 1,105 | — | — |
| Bing organic | 1,084 | 569 | — | — |
| audiusa.com (referral) audiusa.com referral | 719 | 464 | — | — |
| Pinterest / PaidSocial | 538 | 506 | — | — |
| newsletter / email | 522 | 408 | — | — |
| trafficheap.cc (referral) trafficheap.cc referral | 494 | 494 | — | — |
| VinURL VinURL referral | 450 | 304 | — | — |
| Ad tech / other tpc.googlesyndication.com referral Ad-tech / safeframe noise — usually not a vendor you can work as a lead source. | 424 | 419 | — | — |
| Yahoo organic | 220 | 113 | — | — |
Marketplace referrals into the website
How to read this
Shoppers who landed on the store site from big inventory portals.
Still website traffic — not CRM leads. A portal shopper can bounce here and still show up later as Phone Up.
| Portal referral | Visits | People | Avg time | Bounce |
|---|---|---|---|---|
| No marketplace referral traffic in top sources this window (Autotrader / KBB / CarGurus / Cars.com / etc.). | ||||
Where on the site (sales · service · parts · specials)
How to read this
Sessions on page groups: inventory/VDPs (sales), service, parts, specials/offers, finance/trade, store info.
Porsche sites often put service booking on a separate host — if Service is thin here, check service-booking host traffic separately.
| Site section | Visits | People | Page views |
|---|---|---|---|
| Page-section breakdown not in GA4 cache yet for this store. | |||
Website traffic mix only — not the same labels as CRM lead sources. No source total row (avoids a sum that can exceed site sessions).
Stage 1b · Supply next to demand
Inventory health (active lot)
What the store has to sell right now — after website traffic, before CRM leads. Not lead handling.
Store inventory on the ground
VinSolutions live-lot units · snapshot file abr-inventory-latest.csv · as of Nov 09, 2026 7:01 AM · lead window for context Aug 11 – Nov 8, 2026
What this means
Live lot composition and aging. Traffic and 3rd-party demand only convert if the metal matches what shoppers want.
File rows: 4,260 → lot units shown: 90.
This is not contact rate or response speed — those start at Stage 4 (Handling).
Active total
90
Units in Active status
New
90
100.0% of active lot
Used
0
Retail used (excl. Certified)
Certified
0
CPO subset of the lot
Median age
63 d
Days in inventory (Active)
No photo
8
8.9% of active units
Age of active inventory
| Age bucket | Units | Share |
|---|---|---|
| 0–30 days | 22 | 24.4% |
| 31–60 days | 23 | 25.6% |
| 61–90 days | 16 | 17.8% |
| 91–180 days | 19 | 21.1% |
| 180+ days | 10 | 11.1% |
| Total aged units | 90 | 100% |
Aging by New / Used / Certified
| Type | Units | Median age | >60d | >90d | >180d |
|---|---|---|---|---|---|
| New | 90 | 63 d | 45 | 29 | 10 |
| All active | 90 | 63 d | 45 | 29 | 10 |
New — top models
| Unit | Count | Share of active lot |
|---|---|---|
| Q5 | 28 | 31.1% |
| Q8 | 16 | 17.8% |
| Q7 | 8 | 8.9% |
| A5 | 7 | 7.8% |
| A6 Sedan | 6 | 6.7% |
| SQ5 | 5 | 5.6% |
| Q3 | 3 | 3.3% |
| S5 | 2 | 2.2% |
| SQ8 | 2 | 2.2% |
| RS Q8 | 2 | 2.2% |
| Top listed | 79 | 87.8% |
Used + Certified — top make / model
| Unit | Count | Share of active lot |
|---|---|---|
| No used/CPO units | ||
Photo gap: 8 active units (8.9%) marked without a photo — website and marketplace presentation risk, separate from lead handling.
Source: VinSolutions inventory export (live lot). Website search counts can differ — this panel is the ops lot from the CRM file, not a scrape of the public inventory grid.
Stage 2 · Demand shape
How demand shows up
Vehicles of interest and trades — demand pressure next to traffic and inventory. Attempt methods (phone / email / text) live on Handling.
What cars people asked about
Workable opportunities · Aug 11 – Nov 8, 2026
What this means
Vehicle of interest on the lead when CRM has it. Helps with stocking and coaching — not a sold report.
| New / used / CPO interest | Opps | Share |
|---|---|---|
| New | 270 | 78.5% |
| Unknown | 47 | 13.7% |
| Used | 23 | 6.7% |
| Certified | 4 | 1.2% |
| Total | 344 | 100.0% |
Top vehicles of interest Aug 11 – Nov 8, 2026
| Year / make / model | Opps | Share |
|---|---|---|
| 2026 Audi Q5 | 46 | 16.4% |
| 2026 Audi Q7 | 39 | 13.9% |
| 2026 Audi Q3 | 29 | 10.3% |
| 2026 Audi Q8 | 20 | 7.1% |
| 2026 Audi A5 | 12 | 4.3% |
| 2026 Audi SQ5 | 10 | 3.6% |
| 2026 Audi A3 | 8 | 2.8% |
| 2027 Audi Q3 | 8 | 2.8% |
| 2027 Audi Q5 | 8 | 2.8% |
| 2026 Audi S5 | 7 | 2.5% |
| Total | 187 | 100.0% |
Trade-ins mentioned
Workable opportunities · Aug 11 – Nov 8, 2026
What this means
29.4% of workable opportunities included a trade vehicle.
Higher trade rates often signal more serious shoppers.
| Trade year / make / model | Opps | Share of trades |
|---|---|---|
| 2023 Audi Q5 | 9 | 8.9% |
| 2024 Audi Q3 | 7 | 6.9% |
| 2018 Audi Q7 | 3 | 3.0% |
| 2024 Audi Q5 | 3 | 3.0% |
| 2021 Audi Q3 | 3 | 3.0% |
| 2021 Audi Q7 | 2 | 2.0% |
| 2019 Audi Q8 | 2 | 2.0% |
| 2019 Audi Q7 | 2 | 2.0% |
| Total | 31 | 100.0% |
Stage 3 · Demand becomes leads
CRM opportunities from website + 3rd parties
Unique sales opportunities (de-duped) created in VinSolutions for Aug 11 – Nov 8, 2026. Website and marketplace demand show up as internet forms, then also as phone and walk-in — including full source detail on this tab.
Lead volume entering the funnel
Unique opportunities · Aug 11 – Nov 8, 2026 · de-duped · retail workable = excl. Bad + excl. acquisition
What this means
CRM sales opportunities after de-dupe. Same shopper is not counted three times as internet + phone + walk-in.
Retail workable drops Bad junk and acquisition leads (cash/trade value requests — not a retail buy).
Unique after de-dupe
472
From 575 raw CRM rows · 103 repeats collapsed
Retail workable
344
Excl. Bad (128) · excl. acquisition (0)
Retail sold
49
VinSolutions retail sold · close 14.2% of 344 retail workable
DMS deals file through Aug 07, 2026 does not cover this window (Aug 11 – Nov 8, 2026) — close from VinSolutions leads email
DMS deals file through Aug 07, 2026 does not cover this window (Aug 11 – Nov 8, 2026) — close from VinSolutions leads email
Delivered
49
CRM status Delivered · of retail sold
On Order
0
CRM status On Order · sold, not delivered yet
Wholesale / auction sold
0
DMS outlets · separate from retail close · total sold 49
A) Where digital retail demand is sourced
Funnel read
Owned website + on-site tools (Motive, store forms/chat, Carcode) vs 3rd-party portals (Autotrader/KBB, CarGurus, Carfax…) vs OEM partner feeds. These sources create internet opportunities — and often later phone/walk-in on the same shopper.
| Digital source family | Workable opps | Share of internet | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Dealer website & on-site | 64 | 31.2% | 100.0% | 9 min 65.2% ≤15 min · n=46 · avg on 41 |
25 | 39.1% |
| Autotrader / KBB ATKBB | 7 | 3.4% | 100.0% | 46 min 28.6% ≤15 min · n=7 · avg on 6 |
0 | 0.0% |
| Other 3rd-party marketplaces | 43 | 21.0% | 100.0% | 13 min 62.8% ≤15 min · n=43 · avg on 38 |
3 | 7.0% |
| Audi Partner (OEM partner) | 68 | 33.2% | 100.0% | 25 min 54.4% ≤15 min · n=68 · avg on 63 |
1 | 1.5% |
| OEM / brand digital | 18 | 8.8% | 100.0% | 10 min 61.1% ≤15 min · n=18 · avg on 16 |
0 | 0.0% |
| Total / avg (families above) | 200 | — | — | — | 29 | 14.5% |
Digital families above total 200 workable internet-side rows shown in those buckets; internet CRM channel is 204. Gap is other internet sources (campaigns, uncategorized, etc.) detailed under Source detail. Response = VinSolutions average adjusted response minutes (excludes responses over 4 hours) (+ % ≤15). Internet is the reliable speed signal.
Big-vendor demand by channel (CRM)
How to read this
VinSolutions opportunities from major portals, split Internet / Phone / Walk-in.
Portal website referrals live on Traffic — this is CRM-attributed demand.
| Vendor | Internet | Phone | Walk-in | Total opps | Sold |
|---|---|---|---|---|---|
| Autotrader / KBB | 6 | 1 | 0 | 7 | 0 |
| CarGurus | 13 | 0 | 0 | 13 | 1 |
| TrueCar | 18 | 0 | 0 | 18 | 2 |
| Edmunds | 12 | 0 | 0 | 12 | 0 |
Thin Phone often means portal call-ins were logged as generic Phone Up without the vendor source.
B) How opportunities show up in the CRM (channel)
Funnel read
Website and 3rd-party activity turns into internet form leads, phone calls, and walk-ins (plus Other CRM types).
Close = retail sold ÷ retail workable on the hero grade; per-row close uses that channel’s workable opps.
Contacted = real work attempt on that channel.
Response uses adjusted minutes when present — Phone/Walk-in often log 0 min (* = half or more timed at 0; treat as weak signal).
| CRM channel | Workable opps | Share | Contacted | Avg response | Sold | Close | Plain English |
|---|---|---|---|---|---|---|---|
| Internet (web forms / digital) | 204 | 59.3% | 100.0% | 18 min 59.7% ≤15 min · n=186 · avg on 169 |
29 | 14.2% | Forms, portals, chat, partner feeds |
| Phone | 77 | 22.4% | 100.0% | — | 9 | 11.7% | Phone-ups / tracked calls |
| Walk-in | 63 | 18.3% | 100.0% | — | 11 | 17.5% | In-store / drive-by |
| Other | — | — | — | — | — | — | Referral, repeat, DMS, other CRM types |
| Total / avg | 344 | 100.0% | 100.0% | — | 49 | 14.2% |
Source detail
Unique workable opportunities · Aug 11 – Nov 8, 2026 · de-duped · same funnel window · Close = sold ÷ opps · Response = average adjusted minutes (over 4 hours dropped from average)
What this means
Drill-down on where demand came from — owned website vs Autotrader/KBB vs other portals vs OEM partner, then phone and walk-in. High volume + low close often means a source quality issue. Whether the team worked those leads fast belongs on the Handling tab. Dealer website includes Motive, store-domain forms/chat, and Carcode. Autotrader/KBB is one 3rd party with many of their own channels.
Response sits next to close so you can see whether slow first touch lines up with weak conversion. * on response = half or more timed values are 0 (common on phone/walk-in — weak signal).
1) Channel mix
| Channel | Opps | Share | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Internet | 204 | 59.3% | 100.0% | 18 min 59.7% ≤15 min · n=186 · avg on 169 | 29 | 14.2% |
| Phone | 77 | 22.4% | 100.0% | — | 9 | 11.7% |
| Walk-in | 63 | 18.3% | 100.0% | — | 11 | 17.5% |
| Total / avg | 344 | 100.0% | 100.0% | 18 min 0.0% ≤15 min · n=186 | 49 | 14.2% |
2) Internet broken down
Families inside internet · Aug 11 – Nov 8, 2026
Audi Partner leads — watch list 68 opps · close 1.5% · contact 100.0% · avg 25 min
Why this is split out
Audi Partner is an OEM partner feed. High volume can distort website and marketplace quality if mixed in.
Keep it separate. Grade on unique opportunities, contact, response speed, and close — not volume alone.
| Sub-type | Opps | Share | Contacted | Avg response | Sold | Close rate | Bad |
|---|---|---|---|---|---|---|---|
| Audi Partner — New / main | 66 | 97.1% | 100.0% | 26 min 53.0% ≤15 min · n=66 · avg on 61 | 1 | 1.5% | 21 |
| Audi Partner — Used/CPO | 2 | 2.9% | 100.0% | 1 min 100.0% ≤15 min · n=2 * | 0 | 0.0% | 1 |
| Total / avg | 68 | 100.0% | 100.0% | 25 min 2.9% ≤15 min · n=68 | 1 | 1.5% | 22 |
What’s on the lead VinSolutions only has two Partner source names (Used/CPO vs New/main). Extra detail is the vehicle of interest on the opportunity — not a finer OEM sub-source.
| Inventory type on the lead | Opps | Share |
|---|---|---|
| New | 64 | 94.1% |
| Used | 3 | 4.4% |
| Certified | 1 | 1.5% |
| Vehicle of interest | Opps | Share |
|---|---|---|
| 2027 Audi Q5 | 8 | 11.8% |
| 2027 Audi Q3 | 7 | 10.3% |
| 2026 Audi Q5 | 5 | 7.4% |
| 2026 Audi Q3 | 5 | 7.4% |
| 2026 Audi A5 | 4 | 5.9% |
| 2027 Audi A5 | 3 | 4.4% |
| 2026 Audi A6 allroad | 3 | 4.4% |
| 2026 Audi SQ5 | 3 | 4.4% |
| 2027 Audi Q8 | 2 | 2.9% |
| 2026 Audi A3 | 2 | 2.9% |
| 2026 Audi Q7 | 2 | 2.9% |
| 2026 Audi Q4 e-tron | 2 | 2.9% |
| 2027 Audi Q6 e-tron | 2 | 2.9% |
| 2026 Audi Q4 Sportback e-tron | 2 | 2.9% |
| 2027 Audi Q7 | 2 | 2.9% |
| 2025 Audi Q7 | 1 | 1.5% |
| 2026 Audi A8 | 1 | 1.5% |
| 2026 Audi S5 | 1 | 1.5% |
Dealer website & on-site 64 · 31.2% of internet · close 39.1% · avg 9 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Motive — Website | 20 | 31.2% | 100.0% | 9 min 80.0% ≤15 min · n=20 · avg on 19 | 6 | 30.0% |
| Routeone Llc | 19 | 29.7% | 100.0% | 25 min 0.0% ≤15 min · n=1 | 14 | 73.7% |
| Motive — Credit | 7 | 10.9% | 100.0% | 7 min 71.4% ≤15 min · n=7 · avg on 6 | 2 | 28.6% |
| Website chat — Edmunds Carcode | 7 | 10.9% | 100.0% | 13 min 28.6% ≤15 min · n=7 · avg on 5 | 0 | 0.0% |
| Motive Test Drive | 3 | 4.7% | 100.0% | 11 min 66.7% ≤15 min · n=3 | 1 | 33.3% |
| 700credit - Quickqualify | 2 | 3.1% | 100.0% | 0 min 50.0% ≤15 min · n=2 * · avg on 1 | 0 | 0.0% |
| Motive — Trade | 2 | 3.1% | 100.0% | 10 min 50.0% ≤15 min · n=2 * | 1 | 50.0% |
| Motive — Qualify | 2 | 3.1% | 100.0% | 6 min 100.0% ≤15 min · n=2 * | 1 | 50.0% |
| 700credit.Com | 1 | 1.6% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Dealer.Com - Get Eprice | 1 | 1.6% | 100.0% | 19 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Total / avg | 64 | 100.0% | 100.0% | 9 min 95.7% ≤15 min · n=46 | 25 | 39.1% |
OEM / brand digital 18 · 8.8% of internet · close 0.0% · avg 10 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Car And Driver - Audiusa Trade In | 4 | 22.2% | 100.0% | 18 min 50.0% ≤15 min · n=4 · avg on 3 | 0 | 0.0% |
| Audiusa - Configure Your Vehicle - | 4 | 22.2% | 100.0% | 7 min 75.0% ≤15 min · n=4 * | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - Tell Me More | 3 | 16.7% | 100.0% | 12 min 66.7% ≤15 min · n=3 | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - I Want This One | 3 | 16.7% | 100.0% | 0 min 100.0% ≤15 min · n=3 * | 0 | 0.0% |
| Audiusa - Special Offers - Contact Dealer | 1 | 5.6% | 100.0% | 16 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Oadd - Contact Us - | 1 | 5.6% | 100.0% | — | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - | 1 | 5.6% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - Contact Dealer | 1 | 5.6% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Total / avg | 18 | 100.0% | 100.0% | 10 min 64.7% ≤15 min · n=17 | 0 | 0.0% |
ATKBBAutotrader / KBB (one 3rd party · their channels) 7 · 3.4% of internet · close 0.0% · avg 46 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| ATAutotrader — Internet lead | 5 | 71.4% | 100.0% | 40 min 40.0% ≤15 min · n=5 | 0 | 0.0% |
| ATAutotrader — Call tracking | 1 | 14.3% | 100.0% | — | 0 | 0.0% |
| ATAutotrader — Market extension | 1 | 14.3% | 100.0% | 1h 21m 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Total / avg | 7 | 100.0% | 100.0% | 46 min 0.0% ≤15 min · n=6 | 0 | 0.0% |
Third-party marketplaces (grouped by brand · product feeds indented) 43 · 21.0% of internet · close 7.0% · avg 13 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| TrueCar 10 product feeds | 18 | 41.9% | 100.0% | 15 min 61.1% ≤15 min · n=18 | 2 | 11.1% |
| Credit Karma | 4 | 22.2% | 100.0% | 5 min 75.0% ≤15 min · n=4 * | 0 | 0.0% |
| Marketplace | 4 | 22.2% | 100.0% | 35 min 75.0% ≤15 min · n=4 | 0 | 0.0% |
| Benefithub | 2 | 11.1% | 100.0% | 0 min 100.0% ≤15 min · n=2 * | 0 | 0.0% |
| Perkspot | 2 | 11.1% | 100.0% | 7 min 100.0% ≤15 min · n=2 * | 0 | 0.0% |
| Access Development | 1 | 5.6% | 100.0% | 55 min 0.0% ≤15 min · n=1 | 1 | 100.0% |
| Consumer Reports | 1 | 5.6% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Lifecare | 1 | 5.6% | 100.0% | 22 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Penfed | 1 | 5.6% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Perks at Work | 1 | 5.6% | 100.0% | 1 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| Sam's Club | 1 | 5.6% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 1 | 100.0% |
| CarGurus 2 product feeds | 13 | 30.2% | 100.0% | 7 min 100.0% ≤15 min · n=13 | 1 | 7.7% |
| Marketplace | 9 | 69.2% | 100.0% | 6 min 55.6% ≤15 min · n=9 · avg on 7 | 0 | 0.0% |
| Area Boost | 4 | 30.8% | 100.0% | 10 min 50.0% ≤15 min · n=4 · avg on 3 | 1 | 25.0% |
| Costco Auto Program | 7 | 16.3% | 100.0% | 13 min 100.0% ≤15 min · n=7 | 0 | 0.0% |
| Edmunds | 5 | 11.6% | 100.0% | 17 min 0.0% ≤15 min · n=5 | 0 | 0.0% |
| Total / avg | 43 | 100.0% | 100.0% | 12 min 46.5% ≤15 min · n=43 | 3 | 7.0% |
Campaigns & conquest 0 · 0.0% of internet · close — · avg —
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Afs - Off Lease In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Lease In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 0 | 100.0% | — | — | 0 | — |
Other internet 5 · 2.4% of internet · close 0.0% · avg 35 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Regional Event - Inter Miami Cf | 4 | 80.0% | 100.0% | 42 min 75.0% ≤15 min · n=4 * | 0 | 0.0% |
| Acquire Service | 1 | 20.0% | 100.0% | 6 min 100.0% ≤15 min · n=1 | 0 | 0.0% |
| ACCELERATE | 0 | 0.0% | — | — | 0 | — |
| Q9-Order-Info | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 5 | 100.0% | 100.0% | 35 min 20.0% ≤15 min · n=5 | 0 | 0.0% |
3) Phone and walk-in detail
Phone 76 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Phone Up | 32 | 42.1% | 100.0% | — | 2 | 6.2% |
| Repeat Customer | 22 | 28.9% | 100.0% | — | 3 | 13.6% |
| Service Dept | 9 | 11.8% | 100.0% | — | 1 | 11.1% |
| Referral | 6 | 7.9% | 100.0% | — | 2 | 33.3% |
| Mining (Sales) | 3 | 3.9% | 100.0% | — | 1 | 33.3% |
| Walk In | 3 | 3.9% | 100.0% | — | 0 | 0.0% |
| Mastermind | 1 | 1.3% | 100.0% | — | 0 | 0.0% |
| Total / avg | 76 | 100.0% | 100.0% | — | 9 | 11.8% |
Walk-in 63 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Walk In | 51 | 81.0% | 100.0% | — | 8 | 15.7% |
| Service Dept | 9 | 14.3% | 100.0% | — | 2 | 22.2% |
| Repeat Customer | 2 | 3.2% | 100.0% | — | 1 | 50.0% |
| Phone Up | 1 | 1.6% | 100.0% | — | 0 | 0.0% |
| Total / avg | 63 | 100.0% | 100.0% | — | 11 | 17.5% |
Stage 4 · Lead handling quality
How well are we taking care of the leads?
Speed and contact coverage when the CRM export includes them; how the team tries to reach customers (phone / email / text); retail close and open pipeline. Source mix lives on the Leads tab.
Pertinent handling numbers
Date range: Aug 11 – Nov 8, 2026 (vs prior 90 days May 13 – Aug 10, 2026)
What this section is
Handling grades for rolling 90 on unique opportunities after de-dupe.
Bad CRM leads are excluded. Contact and speed grades appear only when the CRM export includes attempt fields.
Handling color legend
GoodKPI is in the healthy band for that metric
WatchKPI is middling — keep an eye on it
ProblemKPI is below the store target band
Per-card rulesInternet contact ≥90% good / <75% problem · response goal ≤15 min (after 15 = not good; ≥25% over 30 = problem even if median looks ok) · retail close ≥8% good / <5% problem · untouched 0 good
1) Internet contact rate
Internet leads only · workable unique opportunities · Aug 11 – Nov 8, 2026
Good
100.0%
vs prior 90 days: — · Prior (May 13 – Aug 10, 2026): —
Internet workable (excl. Bad): 204 · worked 204
All-channel contact (for context): 100.0% on 344 workable opps
Unique after de-dupe: 472 · CRM rows before de-dupe: 575 · collapsed 103 repeats
Internet workable (excl. Bad): 204 · worked 204
All-channel contact (for context): 100.0% on 344 workable opps
Unique after de-dupe: 472 · CRM rows before de-dupe: 575 · collapsed 103 repeats
What this means
Of internet unique opportunities (de-duped, excluding Bad), how many show a real work attempt —
first contact attempt, phone/email/text, customer contact, or CRM contacted flag?
Phone-ups and walk-ins are not in this grade — those are almost always “contacted” by nature and inflate the number.
Higher is better. About 90%+ is good. Under 75% is a problem.
2) Internet response time (median)
Internet leads only · CRM adjusted response time · Aug 11 – Nov 8, 2026
Watch
11 min
vs prior 90 days: — · Prior (May 13 – Aug 10, 2026): —
Based on 186 timed internet leads (of 204 internet workable opps)
Based on 186 timed internet leads (of 204 internet workable opps)
Store goal: first internet response in ≤15 minutes. After 15 min = not good. Over 30 min = missed goal.
≤15 min · on goal111 (59.7%)
16–30 min · late (after 15)39 (21.0%)
Over 30 min · missed goal36 (19.4%)
No timed response18
Speed problem — missed goal: 36 timed internet leads (19.4%) took over 30 minutes. Store goal is first response in ≤15 minutes. 75 (40.3%) were after 15 min — that is not good. Do not let the median hide this bucket.
What this means
Internet only, using VinSolutions adjusted response time when the export includes it.
Phone-ups and walk-ins are not mixed in — they often show as 0 minutes and fake a fast store.
Goal is ≤15 minutes. Any first response after 15 min is not good.
The red over 30 min bucket is the problem list — read it even when the median looks okay.
Bands: ≤15 on goal · 16–30 late · over 30 missed goal.
3) Retail close rate
VinSolutions retail sold ÷ retail workable · wholesale separate · Aug 11 – Nov 8, 2026 · DMS deals file not used this window
Good
14.2%
vs prior 90 days: — · Prior (May 13 – Aug 10, 2026): —
Retail sold (VinSolutions): 49 of 344 retail workable · Delivered 49 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Aug 11 – Nov 8, 2026) — close from VinSolutions leads email
Retail sold (VinSolutions): 49 of 344 retail workable · Delivered 49 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Aug 11 – Nov 8, 2026) — close from VinSolutions leads email
What this means
Headline close uses VinSolutions lead export retail sold ÷ retail workable (Motosnap leads email). DMS deals are optional — used only when that file covers this window.
Retail close only — acquisition and wholesale/auction solds stay on the Leads tab and out of this grade.
On Order is still a retail sold (customer has a car ordered) — counted in close, broken out from Delivered.
DMS deals file through Aug 07, 2026 does not cover this window (Aug 11 – Nov 8, 2026) — close from VinSolutions leads email
Rough store-level bands used here: ≥8% good · 5–8% watch · under 5% problem.
4) Untouched over 24 hours
Workable opps still with no attempt · as of Nov 09, 2026
Good
0
From opportunities in Aug 11 – Nov 8, 2026
What this means
Workable leads still sitting with zero attempt after a full day. Ideal is 0. This is the same-day coaching list.
How the team is trying to reach customers
Workable opportunities · Aug 11 – Nov 8, 2026
What this means
Share of opportunities where phone, email, or text attempts were logged. Multi-channel = two or more methods on the same opportunity. This is handling effort mix — not demand shape.
| Method | Share of workable opps | Plain English |
|---|---|---|
| Phone attempt | 76.2% | Someone tried calling |
| Email attempt | 71.5% | Someone sent an email |
| Text attempt | 52.3% | Someone sent a text |
| Multi-channel | 71.2% | Used 2+ methods on the same opp |
| Customer contact logged | 73.3% | CRM shows an actual customer connect, not only outbound |
Needs attention
Based on unique opportunities in Aug 11 – Nov 8, 2026
What this means
Handling problems to bring into the next sales meeting — slow or no-attempt work, untouched leads, named coaching flags.
Source mix and close-by-origin live on the Leads tab.
- Audi Partner: 68 opportunities, close rate 1.5% — keep separate from website quality.
- Internet speed: 75 timed leads (40.3%) took longer than 15 minutes. Any first response after 15 min is not good.
Stage 5 · People + execution
Salesperson effectiveness
Who owns volume and retail close — and where coaching should start — by team group.
Sales team scoreboard
Workable unique opportunities · Aug 11 – Nov 8, 2026 · split by VinSolutions team · most sold first inside each group
New New Sales 339 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| Jak Langston | 176 opps26 sold14.8% close | 17 min 62.7% ≤15 · n=102 · drop 9 >4h | 111 opps15 sold13.5% close | 56 opps8 sold14.3% close | 9 opps3 sold33.3% close | ——— | 100.0% | 0 |
| Randon Kimery | 72 opps9 sold12.5% close | 15 min 67.4% ≤15 · n=43 · drop 3 >4h | 44 opps6 sold13.6% close | 11 opps0 sold0.0% close | 17 opps3 sold17.6% close | ——— | 100.0% | 0 |
| David Marcantel | 55 opps8 sold14.5% close | 34 min 40.0% ≤15 · n=25 · drop 5 >4h | 28 opps3 sold10.7% close | 5 opps0 sold0.0% close | 22 opps5 sold22.7% close | ——— | 100.0% | 0 |
| Steven Montgomery | 32 opps4 sold12.5% close | 10 min 46.7% ≤15 · n=15 | 17 opps3 sold17.6% close | 3 opps1 sold33.3% close | 12 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Don Harry | 2 opps1 sold50.0% close | — | 2 opps1 sold50.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Ryan Kinsley | 1 opps1 sold100.0% close | — | 1 opps1 sold100.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Sebastian Melancon | 1 opps0 sold0.0% close | — | ——— | ——— | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Total / avg | 339 opps49 sold14.5% close | 18 min 59.4% ≤15 · n=185 · drop 17 >4h | 203 opps29 sold14.3% close | 75 opps9 sold12.0% close | 61 opps11 sold18.0% close | ——— | 100.0% | 0 |
Orphan 5 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| Your Service Dept at Audi Baton Rouge | 3 opps0 sold0.0% close | — | ——— | 2 opps0 sold0.0% close | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Your Friends at Audi Baton Rouge | 1 opps0 sold0.0% close | — | ——— | ——— | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Your Internet Friends At Audi Baton Rouge | 1 opps0 sold0.0% close | 14 min 100.0% ≤15 · n=1 | 1 opps0 sold0.0% close | ——— | ——— | ——— | 100.0% | 0 |
| Total / avg | 5 opps0 sold0.0% close | 14 min 100.0% ≤15 · n=1 | 1 opps0 sold0.0% close | 2 opps0 sold0.0% close | 2 opps0 sold0.0% close | ——— | 100.0% | 0 |
Scoreboard legend
Green rowOverall close rate 14% or higher
Red rowOverall close rate under 14%
Gray rowFewer than 3 workable leads, or system / unassigned
Sort orderMost units sold at the top inside each team group (New Sales first, then Used)
Avg responseInternet timed leads only · average drops responses over 4 hours (overnight/slow-tail outliers) · % ≤15 still uses all timed
How to read this
New Sales first, then Used Sales on the Store view. Channel columns = opps · sold · close %.
On Order solds show under Total as N on order.
Avg response = internet timed only; average drops responses over 4 hours.
Opps — workable unique opportunities assigned to them.
Total / channel columns — opps · sold · close % (sold ÷ that channel’s opps).
Internet contact — % of their internet leads with a real work attempt.
Avg response — internet timed only; average drops responses over 4 hours; shows % ≤15.
Date ranges on this page
Rolling 90: Aug 11 – Nov 8, 2026.
Prior 90 days: May 13 – Aug 10, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-08-08 → 2026-11-05): 63,488 visits · 56,804 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Rolling 90: Aug 11 – Nov 8, 2026.
Prior 90 days: May 13 – Aug 10, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-08-08 → 2026-11-05): 63,488 visits · 56,804 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Month to date at a glance · New
Month to date · New department: 31 retail workable opportunities (47 unique after de-dupe; Bad excluded); retail close 3.2% (1 retail sold); internet is 54.8% of retail workable; internet CRM contact 100.0%; internet median response 1 min; 40.0% of timed internet leads after the 15-min goal.
Month to date: Nov 1–9, 2026 · compared with same days last month Oct 1–9, 2026
Funnel stages are tabs — click through Traffic → Inventory → Demand shape → Leads → Handling → People. Print still shows every stage.
Stage 1 · Top of funnel
Website traffic
People visiting audibatonrouge.com (and related store sites) before any CRM lead is created.
Total website traffic picture
Google Analytics · last ~30 days in cache dated 2026-11-06 · align with CRM window Nov 1–9, 2026 where possible
What this means
This is the top of the sales funnel: how much store-site demand you are generating.
Traffic alone is not leads — next is what the store has to sell (active inventory), then how demand becomes CRM opportunities
(website forms, 3rd-party portals, then phone and walk-in).
Visits (sessions)
4,332
One visit = one trip to the site
People (users)
3,938
Unique visitors
Page views
6,288
1.4 pages per visit
Avg time on site
1m 40s
Average visit length (GA4 session duration)
Engagement rate
35.0%
Visits with meaningful activity
Bounce rate
65.0%
Left after one page — lower is usually better
Mobile share
65.0%
Visits from phones/tablets
Where site traffic came from (top sources)
How to read this
Top source families (Facebook hosts rolled up, IG together, etc.). Mix indicators — not required to sum to total site sessions above.
Marketplace referrals (Autotrader, KBB, CarGurus…) are site visits from those portals — different labels from VinSolutions lead sources.
| Source / medium | Visits | People | Avg time | Bounce |
|---|---|---|---|---|
| Direct | 19,071 | 16,123 | — | — |
| Google paid | 11,002 | 7,965 | — | — |
| Google organic | 9,339 | 4,649 | — | — |
| Facebook WAFB / GDM 360 Streaming, WAFB / GDM 360 Display | 3,508 | 3,378 | — | — |
| cdn.flashtalking.com (referral) cdn.flashtalking.com referral | 3,019 | 2,913 | — | — |
| Facebook paid fb / paid, facebook / paid | 2,629 | 2,424 | — | — |
| Instagram paid ig / paid | 2,437 | 2,247 | — | — |
| Unassigned / not set Not set Most likely a measurement gap — quick bounces or tag/consent timing on the Porsche site so GA4 never got source/medium (often Google/direct under the hood). Not a real marketing channel to coach against. A few visits may also be Google “data not available” privacy/cross-network rows. | 2,128 | 2,125 | — | — |
| imasdk.googleapis.com (referral) imasdk.googleapis.com referral | 1,589 | 1,585 | — | — |
| Autotrader autotrader.com / social | 1,440 | 1,105 | — | — |
| Bing organic | 1,084 | 569 | — | — |
| audiusa.com (referral) audiusa.com referral | 719 | 464 | — | — |
| Pinterest / PaidSocial | 538 | 506 | — | — |
| newsletter / email | 522 | 408 | — | — |
| trafficheap.cc (referral) trafficheap.cc referral | 494 | 494 | — | — |
| VinURL VinURL referral | 450 | 304 | — | — |
| Ad tech / other tpc.googlesyndication.com referral Ad-tech / safeframe noise — usually not a vendor you can work as a lead source. | 424 | 419 | — | — |
| Yahoo organic | 220 | 113 | — | — |
Marketplace referrals into the website
How to read this
Shoppers who landed on the store site from big inventory portals.
Still website traffic — not CRM leads. A portal shopper can bounce here and still show up later as Phone Up.
| Portal referral | Visits | People | Avg time | Bounce |
|---|---|---|---|---|
| No marketplace referral traffic in top sources this window (Autotrader / KBB / CarGurus / Cars.com / etc.). | ||||
Where on the site (sales · service · parts · specials)
How to read this
Sessions on page groups: inventory/VDPs (sales), service, parts, specials/offers, finance/trade, store info.
Porsche sites often put service booking on a separate host — if Service is thin here, check service-booking host traffic separately.
| Site section | Visits | People | Page views |
|---|---|---|---|
| Page-section breakdown not in GA4 cache yet for this store. | |||
Website traffic mix only — not the same labels as CRM lead sources. No source total row (avoids a sum that can exceed site sessions).
Stage 1b · Supply next to demand
Inventory health (active lot)
What the store has to sell right now — after website traffic, before CRM leads. Not lead handling.
Store inventory on the ground
VinSolutions live-lot units · snapshot file abr-inventory-latest.csv · as of Nov 09, 2026 7:01 AM · lead window for context Nov 1–9, 2026
What this means
Live lot composition and aging. Traffic and 3rd-party demand only convert if the metal matches what shoppers want.
File rows: 4,260 → lot units shown: 90.
This is not contact rate or response speed — those start at Stage 4 (Handling).
Active total
90
Units in Active status
New
90
100.0% of active lot
Used
0
Retail used (excl. Certified)
Certified
0
CPO subset of the lot
Median age
63 d
Days in inventory (Active)
No photo
8
8.9% of active units
Age of active inventory
| Age bucket | Units | Share |
|---|---|---|
| 0–30 days | 22 | 24.4% |
| 31–60 days | 23 | 25.6% |
| 61–90 days | 16 | 17.8% |
| 91–180 days | 19 | 21.1% |
| 180+ days | 10 | 11.1% |
| Total aged units | 90 | 100% |
Aging by New / Used / Certified
| Type | Units | Median age | >60d | >90d | >180d |
|---|---|---|---|---|---|
| New | 90 | 63 d | 45 | 29 | 10 |
| All active | 90 | 63 d | 45 | 29 | 10 |
New — top models
| Unit | Count | Share of active lot |
|---|---|---|
| Q5 | 28 | 31.1% |
| Q8 | 16 | 17.8% |
| Q7 | 8 | 8.9% |
| A5 | 7 | 7.8% |
| A6 Sedan | 6 | 6.7% |
| SQ5 | 5 | 5.6% |
| Q3 | 3 | 3.3% |
| S5 | 2 | 2.2% |
| SQ8 | 2 | 2.2% |
| RS Q8 | 2 | 2.2% |
| Top listed | 79 | 87.8% |
Used + Certified — top make / model
| Unit | Count | Share of active lot |
|---|---|---|
| No used/CPO units | ||
Photo gap: 8 active units (8.9%) marked without a photo — website and marketplace presentation risk, separate from lead handling.
Source: VinSolutions inventory export (live lot). Website search counts can differ — this panel is the ops lot from the CRM file, not a scrape of the public inventory grid.
Stage 2 · Demand shape
How demand shows up
Vehicles of interest and trades — demand pressure next to traffic and inventory. Attempt methods (phone / email / text) live on Handling.
What cars people asked about
Workable opportunities · Nov 1–9, 2026
What this means
Vehicle of interest on the lead when CRM has it. Helps with stocking and coaching — not a sold report.
| New / used / CPO interest | Opps | Share |
|---|---|---|
| New | 23 | 74.2% |
| Unknown | 8 | 25.8% |
| Total | 31 | 100.0% |
Top vehicles of interest Nov 1–9, 2026
| Year / make / model | Opps | Share |
|---|---|---|
| 2026 Audi Q5 | 4 | 17.4% |
| 2027 Audi Q5 | 3 | 13.0% |
| 2026 Audi A5 | 3 | 13.0% |
| 2026 Audi Q3 | 3 | 13.0% |
| 2027 Audi Q7 | 3 | 13.0% |
| 2026 Audi Q7 | 2 | 8.7% |
| 2026 Audi RS 3 | 1 | 4.3% |
| 2027 Audi Q9 | 1 | 4.3% |
| 2026 Audi Q8 | 1 | 4.3% |
| 2026 Audi Full Line | 1 | 4.3% |
| Total | 22 | 100.0% |
Trade-ins mentioned
Workable opportunities · Nov 1–9, 2026
What this means
41.9% of workable opportunities included a trade vehicle.
Higher trade rates often signal more serious shoppers.
| Trade year / make / model | Opps | Share of trades |
|---|---|---|
| 2024 Audi Q3 | 4 | 30.8% |
| 2020 Audi Q5 | 2 | 15.4% |
| 2018 Jeep Grand Cherokee | 1 | 7.7% |
| 2026 Chevrolet Silverado 1500 | 1 | 7.7% |
| 2017 Audi Q7 | 1 | 7.7% |
| 2023 Audi Q7 | 1 | 7.7% |
| 2018 Acura MDX | 1 | 7.7% |
| 2017 INFINITI QX80 | 1 | 7.7% |
| Total | 12 | 100.0% |
Stage 3 · Demand becomes leads
CRM opportunities from website + 3rd parties
Unique sales opportunities (de-duped) created in VinSolutions for Nov 1–9, 2026. Website and marketplace demand show up as internet forms, then also as phone and walk-in — including full source detail on this tab.
Lead volume entering the funnel
Unique opportunities · Nov 1–9, 2026 · de-duped · retail workable = excl. Bad + excl. acquisition
What this means
CRM sales opportunities after de-dupe. Same shopper is not counted three times as internet + phone + walk-in.
Retail workable drops Bad junk and acquisition leads (cash/trade value requests — not a retail buy).
Unique after de-dupe
47
From 57 raw CRM rows · 10 repeats collapsed
Retail workable
31
Excl. Bad (16) · excl. acquisition (0)
Retail sold
1
VinSolutions retail sold · close 3.2% of 31 retail workable
DMS deals file through Aug 07, 2026 does not cover this window (Nov 1–9, 2026) — close from VinSolutions leads email
DMS deals file through Aug 07, 2026 does not cover this window (Nov 1–9, 2026) — close from VinSolutions leads email
Delivered
1
CRM status Delivered · of retail sold
On Order
0
CRM status On Order · sold, not delivered yet
Wholesale / auction sold
0
DMS outlets · separate from retail close · total sold 1
A) Where digital retail demand is sourced
Funnel read
Owned website + on-site tools (Motive, store forms/chat, Carcode) vs 3rd-party portals (Autotrader/KBB, CarGurus, Carfax…) vs OEM partner feeds. These sources create internet opportunities — and often later phone/walk-in on the same shopper.
| Digital source family | Workable opps | Share of internet | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Dealer website & on-site | 4 | 23.5% | 100.0% | 1 min 100.0% ≤15 min · n=2 |
1 | 25.0% |
| Autotrader / KBB ATKBB | 1 | 5.9% | 100.0% | 20 min 0.0% ≤15 min · n=1 |
0 | 0.0% |
| Other 3rd-party marketplaces | 2 | 11.8% | 100.0% | 10 min 50.0% ≤15 min · n=2 * |
0 | 0.0% |
| Audi Partner (OEM partner) | 5 | 29.4% | 100.0% | 12 min 40.0% ≤15 min · n=5 |
0 | 0.0% |
| OEM / brand digital | 3 | 17.6% | 100.0% | 7 min 66.7% ≤15 min · n=3 * |
0 | 0.0% |
| Total / avg (families above) | 15 | — | — | — | 1 | 6.7% |
Digital families above total 15 workable internet-side rows shown in those buckets; internet CRM channel is 17. Gap is other internet sources (campaigns, uncategorized, etc.) detailed under Source detail. Response = VinSolutions average adjusted response minutes (excludes responses over 4 hours) (+ % ≤15). Internet is the reliable speed signal.
Big-vendor demand by channel (CRM)
How to read this
VinSolutions opportunities from major portals, split Internet / Phone / Walk-in.
Portal website referrals live on Traffic — this is CRM-attributed demand.
| Vendor | Internet | Phone | Walk-in | Total opps | Sold |
|---|---|---|---|---|---|
| Autotrader / KBB | 1 | 0 | 0 | 1 | 0 |
| CarGurus | 1 | 0 | 0 | 1 | 0 |
Thin Phone often means portal call-ins were logged as generic Phone Up without the vendor source.
B) How opportunities show up in the CRM (channel)
Funnel read
Website and 3rd-party activity turns into internet form leads, phone calls, and walk-ins (plus Other CRM types).
Close = retail sold ÷ retail workable on the hero grade; per-row close uses that channel’s workable opps.
Contacted = real work attempt on that channel.
Response uses adjusted minutes when present — Phone/Walk-in often log 0 min (* = half or more timed at 0; treat as weak signal).
| CRM channel | Workable opps | Share | Contacted | Avg response | Sold | Close | Plain English |
|---|---|---|---|---|---|---|---|
| Internet (web forms / digital) | 17 | 54.8% | 100.0% | 8 min 60.0% ≤15 min · n=15 |
1 | 5.9% | Forms, portals, chat, partner feeds |
| Phone | 7 | 22.6% | 100.0% | — | 0 | 0.0% | Phone-ups / tracked calls |
| Walk-in | 7 | 22.6% | 100.0% | — | 0 | 0.0% | In-store / drive-by |
| Other | — | — | — | — | — | — | Referral, repeat, DMS, other CRM types |
| Total / avg | 31 | 100.0% | 100.0% | — | 1 | 3.2% |
Source detail
Unique workable opportunities · Nov 1–9, 2026 · de-duped · same funnel window · Close = sold ÷ opps · Response = average adjusted minutes (over 4 hours dropped from average)
What this means
Drill-down on where demand came from — owned website vs Autotrader/KBB vs other portals vs OEM partner, then phone and walk-in. High volume + low close often means a source quality issue. Whether the team worked those leads fast belongs on the Handling tab. Dealer website includes Motive, store-domain forms/chat, and Carcode. Autotrader/KBB is one 3rd party with many of their own channels.
Response sits next to close so you can see whether slow first touch lines up with weak conversion. * on response = half or more timed values are 0 (common on phone/walk-in — weak signal).
1) Channel mix
| Channel | Opps | Share | Contacted | Avg response | Sold | Close |
|---|---|---|---|---|---|---|
| Internet | 17 | 54.8% | 100.0% | 8 min 60.0% ≤15 min · n=15 | 1 | 5.9% |
| Phone | 7 | 22.6% | 100.0% | — | 0 | 0.0% |
| Walk-in | 7 | 22.6% | 100.0% | — | 0 | 0.0% |
| Total / avg | 31 | 100.0% | 100.0% | 8 min 100.0% ≤15 min · n=15 | 1 | 3.2% |
2) Internet broken down
Families inside internet · Nov 1–9, 2026
Audi Partner leads — watch list 5 opps · close 0.0% · contact 100.0% · avg 12 min
Why this is split out
Audi Partner is an OEM partner feed. High volume can distort website and marketplace quality if mixed in.
Keep it separate. Grade on unique opportunities, contact, response speed, and close — not volume alone.
| Sub-type | Opps | Share | Contacted | Avg response | Sold | Close rate | Bad |
|---|---|---|---|---|---|---|---|
| Audi Partner — New / main | 5 | 100.0% | 100.0% | 12 min 40.0% ≤15 min · n=5 | 0 | 0.0% | 2 |
| Total / avg | 5 | 100.0% | 100.0% | 12 min 100.0% ≤15 min · n=5 | 0 | 0.0% | 2 |
What’s on the lead VinSolutions only has two Partner source names (Used/CPO vs New/main). Extra detail is the vehicle of interest on the opportunity — not a finer OEM sub-source.
| Inventory type on the lead | Opps | Share |
|---|---|---|
| New | 5 | 100.0% |
| Vehicle of interest | Opps | Share |
|---|---|---|
| 2027 Audi Q5 | 3 | 60.0% |
| 2026 Audi Q5 | 1 | 20.0% |
| 2026 Audi Q3 | 1 | 20.0% |
Dealer website & on-site 4 · 23.5% of internet · close 25.0% · avg 1 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Routeone Llc | 2 | 50.0% | 100.0% | — | 1 | 50.0% |
| Motive — Website | 2 | 50.0% | 100.0% | 1 min 100.0% ≤15 min · n=2 | 0 | 0.0% |
| Motive — Credit | 0 | 0.0% | — | — | 0 | — |
| Motive — Trade | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 4 | 100.0% | 100.0% | 1 min 100.0% ≤15 min · n=2 | 1 | 25.0% |
OEM / brand digital 3 · 17.6% of internet · close 0.0% · avg 7 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Audiusa - Configure Your Vehicle - | 2 | 66.7% | 100.0% | 10 min 50.0% ≤15 min · n=2 * | 0 | 0.0% |
| Oadd - Vdp Vehicle Inquiry - I Want This One | 1 | 33.3% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Total / avg | 3 | 100.0% | 100.0% | 7 min 100.0% ≤15 min · n=3 | 0 | 0.0% |
ATKBBAutotrader / KBB (one 3rd party · their channels) 1 · 5.9% of internet · close 0.0% · avg 20 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| ATAutotrader — Internet lead | 1 | 100.0% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Total / avg | 1 | 100.0% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
Third-party marketplaces (grouped by brand · product feeds indented) 2 · 11.8% of internet · close 0.0% · avg 10 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| CarGurus | 1 | 50.0% | 100.0% | 20 min 0.0% ≤15 min · n=1 | 0 | 0.0% |
| Costco Auto Program | 1 | 50.0% | 100.0% | 0 min 100.0% ≤15 min · n=1 * | 0 | 0.0% |
| Total / avg | 2 | 100.0% | 100.0% | 10 min 50.0% ≤15 min · n=2 * | 0 | 0.0% |
Campaigns & conquest 0 · 0.0% of internet · close — · avg —
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Afs - Off Lease In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Lease In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 3 Months | 0 | 0.0% | — | — | 0 | — |
| Afs - Off Loan (>=39) In 9 Months | 0 | 0.0% | — | — | 0 | — |
| Total / avg | 0 | 100.0% | — | — | 0 | — |
Other internet 2 · 11.8% of internet · close 0.0% · avg 0 min
| Source detail | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Regional Event - Inter Miami Cf | 2 | 100.0% | 100.0% | 0 min 100.0% ≤15 min · n=2 * | 0 | 0.0% |
| Total / avg | 2 | 100.0% | 100.0% | 0 min 100.0% ≤15 min · n=2 * | 0 | 0.0% |
3) Phone and walk-in detail
Phone 7 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Phone Up | 4 | 57.1% | 100.0% | — | 0 | 0.0% |
| Repeat Customer | 2 | 28.6% | 100.0% | — | 0 | 0.0% |
| Service Dept | 1 | 14.3% | 100.0% | — | 0 | 0.0% |
| Total / avg | 7 | 100.0% | 100.0% | — | 0 | 0.0% |
Walk-in 7 opportunities
| Logged as | Count | Share | Contacted | Avg response | Sold | Close rate |
|---|---|---|---|---|---|---|
| Walk In | 5 | 71.4% | 100.0% | — | 0 | 0.0% |
| Service Dept | 2 | 28.6% | 100.0% | — | 0 | 0.0% |
| Total / avg | 7 | 100.0% | 100.0% | — | 0 | 0.0% |
Stage 4 · Lead handling quality
How well are we taking care of the leads?
Speed and contact coverage when the CRM export includes them; how the team tries to reach customers (phone / email / text); retail close and open pipeline. Source mix lives on the Leads tab.
Pertinent handling numbers
Date range: Nov 1–9, 2026 (vs same days last month Oct 1–9, 2026)
What this section is
Handling grades for month to date on unique opportunities after de-dupe.
Bad CRM leads are excluded. Contact and speed grades appear only when the CRM export includes attempt fields.
Handling color legend
GoodKPI is in the healthy band for that metric
WatchKPI is middling — keep an eye on it
ProblemKPI is below the store target band
Per-card rulesInternet contact ≥90% good / <75% problem · response goal ≤15 min (after 15 = not good; ≥25% over 30 = problem even if median looks ok) · retail close ≥8% good / <5% problem · untouched 0 good
1) Internet contact rate
Internet leads only · workable unique opportunities · Nov 1–9, 2026
Good
100.0%
same as same days last month · Prior (Oct 1–9, 2026): 100.0%
Internet workable (excl. Bad): 17 · worked 17
All-channel contact (for context): 100.0% on 31 workable opps
Unique after de-dupe: 47 · CRM rows before de-dupe: 57 · collapsed 10 repeats
Internet workable (excl. Bad): 17 · worked 17
All-channel contact (for context): 100.0% on 31 workable opps
Unique after de-dupe: 47 · CRM rows before de-dupe: 57 · collapsed 10 repeats
What this means
Of internet unique opportunities (de-duped, excluding Bad), how many show a real work attempt —
first contact attempt, phone/email/text, customer contact, or CRM contacted flag?
Phone-ups and walk-ins are not in this grade — those are almost always “contacted” by nature and inflate the number.
Higher is better. About 90%+ is good. Under 75% is a problem.
2) Internet response time (median)
Internet leads only · CRM adjusted response time · Nov 1–9, 2026
Watch
1 min
faster by 1 min vs same days last month · Prior (Oct 1–9, 2026): 2 min
Based on 15 timed internet leads (of 17 internet workable opps)
Based on 15 timed internet leads (of 17 internet workable opps)
Store goal: first internet response in ≤15 minutes. After 15 min = not good. Over 30 min = missed goal.
≤15 min · on goal9 (60.0%)
16–30 min · late (after 15)6 (40.0%)
Over 30 min · missed goal0 (0.0%)
No timed response2
After the 15-min goal: 6 timed internet leads (40.0%) were slower than 15 minutes (6 in 16–30 · 0 over 30). Any first response after 15 min is not good.
What this means
Internet only, using VinSolutions adjusted response time when the export includes it.
Phone-ups and walk-ins are not mixed in — they often show as 0 minutes and fake a fast store.
Goal is ≤15 minutes. Any first response after 15 min is not good.
The red over 30 min bucket is the problem list — read it even when the median looks okay.
Bands: ≤15 on goal · 16–30 late · over 30 missed goal.
3) Retail close rate
VinSolutions retail sold ÷ retail workable · wholesale separate · Nov 1–9, 2026 · DMS deals file not used this window
Problem
3.2%
↓ 13.0 pts vs same days last month · Prior (Oct 1–9, 2026): 16.2%
Retail sold (VinSolutions): 1 of 31 retail workable · Delivered 1 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Nov 1–9, 2026) — close from VinSolutions leads email
Retail sold (VinSolutions): 1 of 31 retail workable · Delivered 1 · On Order 0
DMS deals file through Aug 07, 2026 does not cover this window (Nov 1–9, 2026) — close from VinSolutions leads email
What this means
Headline close uses VinSolutions lead export retail sold ÷ retail workable (Motosnap leads email). DMS deals are optional — used only when that file covers this window.
Retail close only — acquisition and wholesale/auction solds stay on the Leads tab and out of this grade.
On Order is still a retail sold (customer has a car ordered) — counted in close, broken out from Delivered.
DMS deals file through Aug 07, 2026 does not cover this window (Nov 1–9, 2026) — close from VinSolutions leads email
Rough store-level bands used here: ≥8% good · 5–8% watch · under 5% problem.
4) Untouched over 24 hours
Workable opps still with no attempt · as of Nov 09, 2026
Good
0
From opportunities in Nov 1–9, 2026
What this means
Workable leads still sitting with zero attempt after a full day. Ideal is 0. This is the same-day coaching list.
How the team is trying to reach customers
Workable opportunities · Nov 1–9, 2026
What this means
Share of opportunities where phone, email, or text attempts were logged. Multi-channel = two or more methods on the same opportunity. This is handling effort mix — not demand shape.
| Method | Share of workable opps | Plain English |
|---|---|---|
| Phone attempt | 51.6% | Someone tried calling |
| Email attempt | 71.0% | Someone sent an email |
| Text attempt | 54.8% | Someone sent a text |
| Multi-channel | 58.1% | Used 2+ methods on the same opp |
| Customer contact logged | 77.4% | CRM shows an actual customer connect, not only outbound |
Needs attention
Based on unique opportunities in Nov 1–9, 2026
What this means
Handling problems to bring into the next sales meeting — slow or no-attempt work, untouched leads, named coaching flags.
Source mix and close-by-origin live on the Leads tab.
- Audi Partner: 5 opportunities, close rate 0.0% — keep separate from website quality.
- Internet speed: 6 timed leads (40.0%) took longer than 15 minutes. Any first response after 15 min is not good.
Stage 5 · People + execution
Salesperson effectiveness
Who owns volume and retail close — and where coaching should start — by team group.
Sales team scoreboard
Workable unique opportunities · Nov 1–9, 2026 · split by VinSolutions team · most sold first inside each group
New New Sales 31 workable opportunities
| Salesperson | Total opps · sold · close | Avg response internet · >4h dropped | Internet opps · sold · close | Phone opps · sold · close | Walk-in opps · sold · close | Other opps · sold · close | Internet contact | Untouched >24h |
|---|---|---|---|---|---|---|---|---|
| David Marcantel | 11 opps1 sold9.1% close | 6 min 66.7% ≤15 · n=3 | 4 opps1 sold25.0% close | 1 opps0 sold0.0% close | 6 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Jak Langston | 10 opps0 sold0.0% close | 8 min 60.0% ≤15 · n=5 | 6 opps0 sold0.0% close | 4 opps0 sold0.0% close | ——— | ——— | 100.0% | 0 |
| Randon Kimery | 6 opps0 sold0.0% close | 10 min 50.0% ≤15 · n=4 | 4 opps0 sold0.0% close | 2 opps0 sold0.0% close | ——— | ——— | 100.0% | 0 |
| Steven Montgomery | 4 opps0 sold0.0% close | 7 min 66.7% ≤15 · n=3 | 3 opps0 sold0.0% close | ——— | 1 opps0 sold0.0% close | ——— | 100.0% | 0 |
| Total / avg | 31 opps1 sold3.2% close | 8 min 60.0% ≤15 · n=15 | 17 opps1 sold5.9% close | 7 opps0 sold0.0% close | 7 opps0 sold0.0% close | ——— | 100.0% | 0 |
Scoreboard legend
Green rowOverall close rate 14% or higher
Red rowOverall close rate under 14%
Gray rowFewer than 3 workable leads, or system / unassigned
Sort orderMost units sold at the top inside each team group (New Sales first, then Used)
Avg responseInternet timed leads only · average drops responses over 4 hours (overnight/slow-tail outliers) · % ≤15 still uses all timed
How to read this
New Sales first, then Used Sales on the Store view. Channel columns = opps · sold · close %.
On Order solds show under Total as N on order.
Avg response = internet timed only; average drops responses over 4 hours.
Opps — workable unique opportunities assigned to them.
Total / channel columns — opps · sold · close % (sold ÷ that channel’s opps).
Internet contact — % of their internet leads with a real work attempt.
Avg response — internet timed only; average drops responses over 4 hours; shows % ≤15.
Date ranges on this page
Month to date: Nov 1–9, 2026.
Same days last month: Oct 1–9, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-11-01 → 2026-11-06): 4,332 visits · 3,938 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.
Month to date: Nov 1–9, 2026.
Same days last month: Oct 1–9, 2026.
Organized as a sales funnel: website traffic → inventory health (active lot) → demand shape (VOI / trades) → CRM opportunities (site + 3rd party → internet/phone/walk-in) → handling quality (including how the team tries to reach customers) → salesperson execution. Unique opportunities after de-dupe (VIN/stock within 7 days, or same salesperson + day + vehicle). Internet + phone + walk-in on the same shopper counts as one. Headline contact rate is internet leads only (workable, de-duped, any real attempt). Internet speed uses CRM adjusted response time on internet leads only. Inventory panel uses VinSolutions live-lot units when an inventory export is present. Lead data: VinSolutions. Website traffic (GA4 cache 2026-11-06 · GA4 2026-11-01 → 2026-11-06): 4,332 visits · 3,938 people. Generated Nov 09, 2026 10:14 AM. This page is for Audi Baton Rouge · New only — no other stores.