Customer story · A multi-location dealership group

Reports built by hand. Now 30 people just ask.

A dealer group with five rooftops and three brands in Southern California. With Black Octopus AI & Automation, they brought sales, service, F&I, inventory and customer data into one place and automated the reports. With FrontierOps, their managers ask that data questions in Claude, with the group’s definitions, each person’s permissions and every question on record.

Book a 30-minute call What changed

Results

30

people asking their own questions

across sales, service and management.

Nobody
in between. Ask, and the answer comes back. No request, no queue, no analyst to wait on.
Real time
from question to answer, and the follow-up right after it, instead of tomorrow’s spreadsheet.
Every role
asks for itself. A salesperson about their deals, a GM about their store, ownership about the group.
Before

Manual reports, four systems, five stores. One person with an Excel macro.

Every morning, one person logged into the DMS, the CRM, the manufacturer portals and the video tool for each of the five stores, pasted it all into Excel macros and emailed the reports to the team. More than 25 hours a week, by hand. The data warehouse, the data cleansing vendor and the AI chatbot the group had already paid for weren’t connected to any of it.

Before

  • Reports assembled by hand from four systems
  • 25+ hours a week pulling and formatting data
  • Managers waiting for emailed Excel files
  • The same flat reports for everyone, whatever their role
  • Stale data unnoticed for days at a time
  • A separate reporting vendor, just for the views the DMS couldn’t produce
  • Equity mining on a subscription about to expire

After

  • Every report automated and delivered on schedule
  • The person who built them moved to higher-value work
  • Dashboards by role: ownership, GM, sales manager, salesperson
  • Freshness checked automatically, with an alert when a feed goes stale
  • The reporting vendor retired
  • 74,000+ customers scored for equity outreach
  • Any manager asks in Claude and gets the group’s number
How it came together · eight weeks

A live report on their own data in two weeks. The whole group in eight.

No six-month roadmap and nothing taken on faith. Black Octopus AI & Automation started by understanding how the group runs, proved it on one report in two weeks, and built the rest on that understanding, each step checked on live data before the next. The AI came once the numbers were right.

  1. By week 2

    The first report, live on their own data

    How the group counts a sold unit, gross and a deal’s store, written down first. Then one report, rebuilt on live data and checked line by line against the manual one.

  2. By week 6

    Every store modelled, every report running

    Sales, service, F&I, inventory and customers, modelled by store, brand and role, in the managers’ own words. Once the numbers matched what the GMs knew, the spreadsheets and the reporting vendor fell away.

  3. By week 8

    Claude, for every manager

    74,000+ customers scored the same way: equity, financing, lease maturity, service history. FrontierOps put the whole model in Claude, so every manager could ask about their own store in plain English.

  4. Since then

    30 people asking

    From the few who got the reports to 30 people across sales, service and management, each asking their own questions. Black Octopus keeps the model current. The group’s own team runs the rest.

Every day

Everything a dealer group needs to know, asked in plain English.

Ownership, general managers and salespeople ask about every part of the business in Claude, and get the group’s numbers back.

Sales

Units, gross, F&I penetration and deal-level profit, by store, team or salesperson, by day or by month.

Who’s leading on front gross this month, across all five stores?

Ownership · asked in Claude

Service

Repair order volume, advisor productivity, technician efficiency, and customer-pay against warranty and internal.

Which advisors are under target on hours per RO this week?

Service manager · asked in Claude

Inventory

Days in stock, turn rates, floor plan cost per VIN, reconditioning status, and the new to used mix.

What’s aged past 60 days at the north store, and what’s it costing us in floor plan?

General manager · asked in Claude

Equity

74,000+ customers scored by equity position, financing terms, lease maturity and service history, best opportunities first.

Who’s in positive equity with a lease ending this quarter?

Sales manager · asked in Claude

What they see

Ask in Claude. Get the group’s number back.

Each manager asks about their own store, in their own words, and gets the same numbers ownership sees. Nobody waits, and nobody sees more than they should.

How did the downtown store do this week?

41 units, up 6 on last week. Front gross is flat. F&I penetration is up to 78%, the best week this quarter.

sales · F&Idowntown store · store access

Which of our customers are in positive equity with a lease ending in the next 90 days?

214 customers at the downtown store. 38 of them serviced with you in the last six months, and they’re listed first.

customers · equitydowntown store · store access

Asked by a general manager · Store access · on record · Example numbers

If it was all in one place, that would make life so much easier. Now it is. And it changed how we run every store.
Dealer principal, a multi-location dealership group
Who did what

A data partner built the foundation. FrontierOps put it to work.

Consulting and the data platform

Black Octopus AI & Automation

The understanding of the business, and the data model that carries it: every store, brand and role, the numbers defined the way a dealer group runs, fed from the DMS and the other systems, kept accurate with checks, with the security to match. Black Octopus keeps it current as the group changes.

The layer to the AI people use

FrontierOps

The group’s definitions, each person’s own access, every question on record, and the same setup for whichever AI the group chooses. The part that turned a reporting project into something 30 people use every day.

The group owns all of it, the data, the models and the reports, in its own accounts. Adding a sixth rooftop means one more store, not a new system.

What changed

Five stores, one place to ask. Every team with the information it needs.

Ownership sees the group. General managers see their store. Sales managers see who’s leading and which customers to call. Service sees advisors and technicians by day. Nobody waits for the morning spreadsheet, and nobody sees more than they should.

Bring one operational challenge your managers keep hitting. We’ll show you how to solve it.

Then we prove it on your data in a week. Already working with a data partner? We work alongside them, as we did here.

Book a 30-minute call