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.
  • Ask your own questions โ€” any page, any line, any month, cited to the sheet.
  • Your full composite review, front to back, with a Money Map priced in dollars.

How it works

From the uploaded workbook to the meeting notes.

1

The composite lands

Your moderator uploads the monthly workbook to your group's library.

2

Pages stay faithful

Every page, dealer column, and ranking row matches the original 1:1.

3

Find your store

Sign in and your dealer is highlighted on every page automatically.

4

Read with an analyst

Ask about any page, line, or dealer โ€” every AI answer cites its source line.

5

Watch the trend

Chart any metric across months to see what's moving and by how much.

6

Follow the syllabus

Meeting findings and notes, organized by page and ready to export.

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.