Digital Product Analyst · Automotive retailInternal analytics dashboardAI product · concept to spec

AI Overviewfor the morning.

A daily AI insight and action plan inside an automotive dealer group’s internal dashboard, so dealer leaders know which KPI is behind, why, and who does what today.

  • 01I came up with the concept: the insight logic and the UI.
  • 02I mapped every use case across 4 roles and their KPIs: 99 in total.
  • 03I spent time with frontliners, and it shaped the design.
AnalyticsAP
Selamat pagi, Kacab.8 hari kerja tersisa. Tiga hal untuk hari ini.
✦ AI Overview BetaDiperbarui 06.00
SPKNPS+ KPI
1SPK 87,5% A/T

SPK tertinggal karena follow-up leads lambat

  • 42 dari target berjalan 48; butuh 3 SPK/hari.
  • 23 leads belum di-FU, 9 lewat SLA.
  • FU ini bisa menutup ±4 dari gap 6.
Action plan
  1. Budi & Dedi FU leads lewat SLA, sebelum 12.00.
  2. SS bagi 5 prospect test drive ke AE.
Cek besok: Not Yet FU 23 → 0
NPS on track · 102% dari target
Diperbarui setiap hari · data dummy
RoleProduct owner of the feature: concept, research, use cases, insight logic, UI concept
TeamMe + [X] developers + business stakeholders
Timeline[X weeks / months]
Tools[e.g. Figma, Excel, Claude]
01 / ContextA national car dealer network, Indonesia

Many reports,one morning.

The client is a national car dealer network in Indonesia, run as Head Office › Region › Area › Branch. Its leaders work from an internal analytics dashboard, with reports for sales, aftersales, finance and customers.

AI Overview is a feature inside that dashboard. Every day it reads the reports for a user’s KPIs and writes a short insight and action plan, for four roles: Branch Heads (Kacab), Workshop Heads (Kabeng), Area Heads (ABH) and Head Office.

02 / Problem
  • TimeLeaders had plenty of reports but little time to diagnose them each morning.
  • Generic AIThe first AI output gave soft advice (“Saran saya…”) and repeated the same root cause across several KPIs.
  • No contextNumbers came without a comparison. Actions came without an owner or a deadline.
  • No specThe dev team had no clear definition of a “good insight”, or of how the feature should look.
03 / ImmersionBefore writing a single rule

I went to the branchesbefore the prompt.

I spent time with [who: e.g. Branch Heads, Workshop Heads, Sales Supervisors, Service Advisors] at [X branches], by [how: e.g. sitting in morning briefings, interviews, watching how they read the dashboard].

What I saw became the standard the playbook asks the AI to meet. Every rule below traces back to how leaders actually run their day.

Key decisionAn insight that stops at “KPI X is behind, please check” doesn’t help anyone.
Finding 01

Leaders act in the morning briefing.

Advice without a person and a time goes nowhere once the briefing ends.

→ So every action names who, what (a countable object) and when
Finding 02

They want the point first.

No opening sentences, no “saran saya”, no hedging. Encouragement is welcome, but not mixed into the analysis.

→ So headlines are conclusions, and encouragement lives only in the greeting
Finding 03

Names point to a PIC, not a verdict.

Naming the person behind a number helps a leader know who to ask, as long as it never reads as a judgment.

→ So names appear only to assign the action
04 / Mapping the use casesEvery insight the AI may write

99 use cases,4 roles, one map.

KacabBranch Head

27

Whole branch: sales, aftersales overview, cost, receivables, NPS.

KabengWorkshop Head

23

Unit entry, CPUS, revenue, gross profit, down to SA and process.

ABHArea Head

24

The same KPIs, read across the branches in an area.

HOHead Office

25

Every KPI, compared across regions, areas and branches.

Step 1A data catalogI audited every metric in the dashboard. Anything the AI couldn’t see was cut, like a finance ratio with no data source.
Step 2A KPI driver treeOutcome KPIs → driver KPIs → process signals. Only a leading signal may be cited as a cause.
Step 3Tagged use casesEach one carries its KPI, trigger, data source, depth and an example action.
Step 4Iterated with stakeholdersComplaints folded into customer satisfaction; selection moved from category to KPI.
Outcome
NPBTBranch profit
NPSCustomer
Driver KPIs
SPKOrders
DODeliveries
Unit EntryWorkshop visits
CPUSService revenue / unit
Process signals (leading only)
Leads not followed up · past SLA · test drives
SPK held at matching, leasing, documents, stock
Bookings, reminders, customers due for service
Work orders not yet billed · WIP · lead time

A signal can only be named as the cause of a KPI if it leads that KPI. That rule alone stopped the AI from blaming one root cause for everything. Simplified here; the full tree lives in the playbook.

KPIDetailed for the ownerSummary for
SPK, DOKacab: per sales exec, funnel stage, outstanding SPK status, stockABH, HO: per branch, area, region
Unit Entry, CPUS, Revenue, Gross ProfitKabeng: per SA, bookings, reminders, WIP, lead timeKacab: status, main cause, action routed through the Kabeng. ABH, HO: per branch, area, region
NPBT, OPEX, Absorption Rate, ARKacab: cost lines, margin, receivables per customerABH, HO: per branch, area, region

Same KPI, different depth by role. The map lives in a master Excel, the playbook and a stakeholder deck.

05 / Concept: insight logicWritten as the “Foundation” playbook

One KPI,one story.

The AI only uses real dashboard data. No internal targets are hard-coded; comparisons are relative: last month, last year, the 4-week average, the area average.

Each insight is a story. The headline is the conclusion. Up to three points follow: status, main cause, impact. Then up to three direct commands, each with who, what and when, ending with “check tomorrow: this number should move from X to Y”. If nothing is wrong, it is one line: on track.

Key decisionThe user picks what matters. The system makes sure what’s worst is never missed.
The 3-slot modelTry it · illustrative branch data
Pick up to 3 KPIs, as a Branch Head would
  • 01Your picks come first, in the order you chose them.
  • 02Empty slots fill with the KPIs furthest behind target, ranked by % of target (flipped for lower-is-better KPIs).
  • 03The same root cause is never shown twice.
  • 04Empty slots are never padded with on-track KPIs.

06 / Concept: UIMaking the logic readable on screen

Every elementearns its place.

Greeting panelContext, then calm

Sets the day: working days left. Encouragement lives only here (Finding 02).

Numbered cardsOne per KPI

KPI tags, a conclusion headline, up to 3 bullets and a separate action box (Finding 01).

KPI pickerUp to 3

Auto-filled cards say “picked automatically · behind target”, so nothing appears without a reason.

Quiet statesOn track, warnings, status

A one-line on-track row, a warning slot and a status strip for KPIs outside the 3 slots. Cards collapse; a timestamp shows the daily refresh.

Prototype · desktop · Branch HeadScroll to walk through · dummy data
01

The whole morning, on one screen.

The AI summary sits on top of the reports a Branch Head already opens every day.

02

One line to start the day.

A conclusion first: what is behind, and where the problem actually sits.

03

A number, with what it takes.

Status against the running target, plus the pace needed for the working days left.

04

Then a task with an owner and a time.

Who and when on every action, with a check to mark it done.

05

The cause, not the symptom.

Orders are up but deliveries are down: the hold-up is leasing and stock, not leads.

06

Quiet about what’s fine.

Improved items are shown, unchanged ones collapse. Colour always comes with a label.

Prototype · mobile · four rolesSame KPI, different depth
Kacab · Branch Head

The whole branch.

Deliveries behind target, with the hold-up after the order: leasing and stock.

Kabeng · Workshop Head

Down to each advisor.

Unit entry behind, closed by tomorrow’s bookings and customers due for service.

HO · Head Office

Regions side by side.

The same KPIs, compared across regions, areas and branches.

FAH · Finance & Accounting

Explored, then redirected.

Prototyped here; in the final playbook, finance executes branch actions instead of getting its own summary.

KACABBranch Head
KABENGWorkshop Head
HOHead Office
FAHFinance & Accounting

These are the prototype screens from an earlier exploration, live and anonymized. The 3-slot layout in the mockup at the top is the concept the playbook now specifies.

07 / Before / afterIllustrative dummy data · Indonesian with English gloss
The first AI output

“Saran saya, MRA dan Service Advisor menghubungi pelanggan… fokus meningkatkan kedatangan unit.”“My suggestion: MRA and Service Advisors contact customers… focus on increasing unit arrivals.”

  • Soft advice, no owner
  • No number, no comparison
  • No deadline, no way to check
With the Foundation rules

SPK tertinggal karena follow-up leads lambat ConclusionSPK is behind because lead follow-up is slow.

Status · cause · impact
  • SPK MTD 42 dari target berjalan 48 (87,5%); butuh 3 SPK/hari di 8 hari kerja tersisa.Orders month-to-date: 42 of 48 so far; 3 a day needed over the 8 working days left.
  • 23 leads belum di-FU, 9 lewat SLA, terbanyak di Budi (4) dan Dedi (3).23 leads not followed up, 9 past SLA, mostly Budi’s (4) and Dedi’s (3).
  • Dengan konversi biasa 18%, FU leads ini menutup ±4 dari gap 6 SPK.At the usual 18% conversion, these follow-ups close about 4 of the 6-order gap.
Action plan · who, what, when
  1. Minta Budi dan Dedi FU leads lewat SLA sebelum jam 12.00.Have Budi and Dedi follow up past-SLA leads before 12:00.
  2. Minta SS bagi 5 prospect test drive ke AE di briefing pagi.Have the Sales Supervisor assign 5 test-drive prospects to sales execs at the morning briefing.
  3. Cek besok: Not Yet FU turun dari 23 ke 0.Check tomorrow: not-yet-followed-up drops from 23 to 0.
08 / DeliverablesWhat the dev team builds from
PlaybookFoundation

Business context, data catalog, KPI driver tree, insight and action-plan rules, the 3-slot concept.

Library99 use cases

Across 4 roles, plus worked examples per KPI.

AlignmentMaster Excel + deck

The classification behind the map, and the stakeholder slides.

UI conceptStates & components

Greeting panel, insight card, action box, KPI picker, on-track and warning states.

09 / OutcomeWhere it stands
StatusRolling out

The feature is rolling out to branch, workshop, area and head-office users, built from the Foundation playbook as its spec.

How I’ll judge itActions done, numbers moved

Whether leaders act on the plan the same morning, and whether the “check tomorrow” number actually moves the next day.

10 / ReflectionWhat I’d tell the next team
  • Time with frontliners changed what “useful” meant.On paper, a good insight was accurate. In a branch, it was one a leader could act on before the briefing ended.
  • Constraints made the AI more trustworthy.“Only what the dashboard shows” cut use cases, but every number it writes can be checked against a report.
  • An AI feature needs a writing system.Not just a prompt: a use case map, a driver tree and rules for what a good sentence looks like.
Still to add
  1. Immersion photos or notes, anonymized
  2. The full use case map (roles × KPIs) from the master Excel
  3. The complete KPI driver tree
  4. Real names, branch data and numbers blurred or replaced with dummy data