NCM 20 Group · Composite Analyzer

Turn the monthly composite into decisions in minutes.

Load the composite exactly as your moderator distributes it, then read it the way you always wished you could: every page navigable, every rank headlined, every AI claim cited to its line.

The composite is the bible — nothing re-calculated, nothing re-ranked.
ncmcompositetool.com/composite
Page 4 — Vehicle Department Detail ▾
ALPHA — 2 / 5 on this page
Metric
ALPHA
BRAVO
CHARLIE
DELTA
BENCHMARK
New Vehicles Rtl & Lse
964
521
438
602
454
Gross per Used Retail
1,923
1,244
1,406
877
956
F&I+Wrty Net / N&U Rtl
1,091
2,445
1,519
1,014
1,405
N&U Advertising
778,921
107,066
424,736
391,208
338,540
✦ Analyze this line
Synthetic demo data

Who it's for

One tool, two seats at the table.

For Moderators

  • One upload serves the whole group — every member sees the same book.
  • Build the meeting syllabus as you review: check a finding, it files itself in page order.
  • Every AI claim cites its page and line — click the citation, land on the evidence.

For Dealers

  • Sign in and land on your store — your rank headlined on every page.
  • The navigator becomes your report card: green, amber, red, page by page.
  • Your full composite review, front to back, with a Money Map priced in dollars.

How it works

Six steps from inbox to insight.

1

Name your group

Once, from the ≡ menu. Every upload after is auto-named by month.

2

Upload the composite

The month is auto-detected and saved to your group's library.

3

Read every page

Pages, RC sheets, rankings — the workbook, 1:1.

4

Analyze anything

A page, a line, a dealer — scoped AI, cited to the sheet.

5

Trend the months

Chart any metric across every month you've uploaded.

6

Build the syllabus

Check off findings and export the meeting packet.

What you can do

The composite, readable — with an analyst on call.

📖

1:1 Composite View

Page order, dealer columns, and ranking rows match the workbook exactly.

Scoped AI Analysis

A page, a line, or a single dealer — never a black-box "explain everything."

📈

Multi-Month Trends

Chart any metric across every month in your library.

🗂

Meeting Syllabus

Curate analyses, add notes, export a ready-to-share packet.

Ground rules

The promises the tool keeps — in writing, on the front page.

  • The composite is the source of truth — no custom benchmarks, no recalculated ranks.
  • "Date Statement Received," "Date Received," and "How Received" are informational only — excluded from every KPI, flag, trend, and analysis.
  • Dealer identity, columns, and line order match the workbook 1:1.
  • Every AI analysis is scoped and cited — an unresolvable citation is flagged, not hidden.
  • Zeros and blanks are "not reported" — never ranked, never averaged, always footnoted.