AI data analyst for automotive retail
Spot aged stock while there’s still gross in it.
Every rooftop’s units, gross and aged stock, before the morning meeting.
Group sales and stock
September to date · 5 rooftops
- Units retailed
- 398
- +5%
- Gross per car
- $1,840
- −$95
- F&I per car
- $2,210
- +$40
- Used 60+ days
- 142
- +23
Used units over 60 days, last 12 months
Northgate: a fifth of used stock, over a third of aged units.
dms.vehicle_inventory + dms.deals · refreshed 06:30
Trusted by forward-thinking teams
Ask it anything
Inventory meeting at 11. Walk in with the reason.
Your numbers
Defined once. Used in every answer.
- Units vs objective
units_mtd / (objective × selling_days_elapsed / selling_days_in_month)- Gross per car
sum(sale_price − vehicle_cost − recon − pack) / units_retailed- F&I per car
(finance_reserve + product_gross − chargebacks) / units_retailed- Aged inventory
units_over_60_days / units_in_stock- Days supply
units_in_stock / (units_retailed_30d / 30)- Service absorption
fixed_ops_gross / (total_expenses − variable_selling_expenses)
From a data analyst
“It's like having a second analyst to bounce ideas off. I mainly use it to kickstart SQL queries, validate my thinking, and explore alternative approaches.”
Kerem PilavData Analyst, StarBerry Games- estimated annual savings
- ~€100k
- faster pipeline setup
- 3x
- running on Bruin
- 1.5 years
Built on the Bruin platform
What runs behind the answer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFrequently asked
Questions from dealer groups.
How do I know Bruin’s gross and F&I numbers are right?
Every answer shows the query and the DMS tables behind it. Gross per car, F&I per car and aged stock have one definition for every rooftop, tested on every run.
Can Bruin read data from our dealer management system (DMS)?
Yes, through a database connection, scheduled exports to SFTP or cloud storage, or an API. Bruin also connects Salesforce, HubSpot, Google Ads, Facebook Ads and spreadsheets.
Can Bruin flag used cars before they hit 60 days in stock?
Yes. Set a rule, like units past 45 days or 7 days in recon, and Bruin posts them to the store’s channel and tags the used car manager.
Can Bruin show where reconditioning is holding up our used cars?
Yes. With recon dates from the DMS, it shows days to frontline-ready by rooftop and lists the units that have sat longest.
Can Bruin tie dealership leads and ad spend to cars sold?
Yes. Leads from Salesforce or HubSpot, Google Ads and Facebook Ads spend and DMS deals sit in one model, so you see cost per unit sold by source and rooftop.
Can Bruin build our monthly dealer group report?
Yes. Ask for it or schedule it as a PDF: units against objective, gross, F&I and service absorption by rooftop, each figure linked to its query.
Does our dealership need a data team or data expertise to use Bruin?
No. Connect your DMS and CRM and ask in Slack. If you have a data team, Bruin runs on their models and checks.
Can our GMs and sales managers use Bruin in Microsoft Teams or WhatsApp?
Yes. Bruin answers in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email or the browser. Nobody has to learn a new tool.
How is Bruin different from the reports in our DMS?
DMS reports show one system, often one store at a time. Bruin answers across the DMS, CRM and ad accounts for the whole group, and explains why a number moved.
How is Bruin different from asking ChatGPT about our dealership data?
A chat assistant only sees what you paste in. Bruin answers from your connected DMS, CRM and ad data, runs the query itself and shows its sources.
How much does Bruin cost, and is it per seat?
Bruin Cloud is free to start: $100 in credits and 50 AI tasks, no credit card. After that, compute is billed per second (about $2.50 an hour for SQL, $10 on a standard instance) and AI tasks cost $1 to $3 each, depending on complexity. Committed-use discounts lower the rate as usage grows. No seats.
Is our dealership’s customer data safe with Bruin?
Bruin is SOC 2 Type 2 attested and ISO/IEC 27001:2022 certified. Your data, customer records included, is never used to train AI models.
Move the aged units before they go to auction.
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.
