Building a One-Page Lead Source Report for the GM

The controller emailed a 14-tab workbook titled "Internet Mix." Tab three was paid search. Tab seven was a CRM dump with 40 columns. Tab eleven was last quarter. The GM opened it in the Monday meeting, scrolled, asked "so which source should I keep," and got three different answers. The report had data. It did not have a decision.

Building a one-page lead source report for the GM is an editing job. The GM needs source, volume, work completed, appointments, shows, cost, and a note that explains the outlier. Everything else is for the internet director's desk, not for the person who also has recon, payroll, and a lender call at 10:15.

This guide is for internet directors and office managers who are tired of producing a novel nobody reads. It specifies the page, the definitions, the monthly rhythm, and the traps that turn one page back into fourteen.

Building a One-Page Lead Source Report for the GM That Gets Read

Design the page for a 12-minute conversation. If it cannot be read standing up, it is not one page.

The columns that earn a place

If you cannot fit Sold without starting a fight, leave Sold to a joint scorecard and keep this page on set and show. That is still enough to cut or keep a vendor.

Sources the page must separate

• Each paid vendor, by contract name.
• Website organic versus website paid, if you can defend the split.
• Phone-ups that were not internet.
• Marketplace (and any other social channel you actually work) as its own line.
• Repeat / database / sold-follow-up, if those are being counted as "new leads" today — they usually should not be.

If Marketplace sits inside "Other," the GM will underfund the work and overfund the aggregator. Attribution rules belong in lead source naming conventions. The one-pager only works after those names exist.

What does not belong on the GM page

• Bounce rates, impressions, and follower counts.
• Individual rep leaderboards (that is a coaching report).
• Daily sparkline charts for every source.
• Last year's tabs "for context" that nobody opens.
• Vendor logos.

Put diagnostics behind the page. Bring them only when the note column says "see sample."

The Definitions a One-Page Lead Source Report for the GM Must Freeze

A pretty table with sloppy definitions is how the meeting becomes a trial about who "stole" a lead.

Unique people, not raw fires

Count a buyer once per source per vehicle per week, or pick another de-dupe rule and write it on the page footer. Two form fills in two hours is not two leads. CRM duplicates of the same cell number are not two leads.

Worked means a human attempt

Auto-responders do not count. A task created but not completed does not count. If speed to lead is on the SLA poster, the report's "worked" should be reconcilable with that SLA, not a new invention.

Appointment and shown mean the funnel

Use the same language as lead to appointment funnel stages. The GM page is not allowed to use a third definition of appointment. Footer the page: "Appointment = buyer-agreed time, vehicle, location."

Cost means invoices plus a stated rule on labor

Either:

• Media only, labeled "media," or
• Media plus allocated internet labor, labeled "loaded."

Never mix those in the same column across sources. Organic Marketplace will look free on media-only and expensive on loaded. That is fine if the label is honest.

Period and lag

Use calendar month plus a note that appointments set on the 31st may show in the next month. Do not pretend the CRM's "sold date" and the vendor's "lead date" are the same clock. Pick lead-created-date as the cohort unless you have a reason not to, and say so.

How to Produce the Page in Under an Hour

If the report takes a full day, it will be late, and the GM will go back to vendor anecdotes.

A repeatable build

1. Export new records for the period with source, created time, and current stage.
2. De-dupe on the written rule.
3. Map stages to: unworked, worked, set, shown, sold.
4. Pull vendor invoices. Do not type memory.
5. Write one note per source that moved more than the others — direction does not need a fake percentage of "significance," just the operational reason.
6. Paste into a single-page template. Stop.

Exception notes worth writing

• "Saturday specialist off; unworked pile sat until Monday."
• "Vendor sent a duplicate file; unique count dropped after de-dupe."
• "Sold units still live on Marketplace; inquiries were not real availability."
• "New paid source turned on mid-month; do not annualize."

Notes like "seasonality" with no mechanism are filler. Cut them.

Who prepares, who signs

The internet director prepares. The BDC lead checks that "worked" matches reality on a sample of ten. The GM does not rebuild the sheet in the meeting. If the GM does not trust the sheet, the fix is the sample, not another tab.

Using the Page in the Meeting Without Reopening Fourteen Tabs

Twelve-minute script

1. Two minutes: what changed versus last month in sets and shows, not in fills.
2. Five minutes: two sources — the one to keep and the one on the bubble — with the note column.
3. Three minutes: coverage or inventory hygiene that polluted the numbers.
4. Two minutes: decision (keep, cut, cap spend, or fix process first) written in the minutes.

If someone asks for website bounce rate, schedule a marketing conversation. Do not hijack the GM page.

Decisions the page is allowed to drive

• Cap or pause a paid source until unworked-new is under control.
• Move money toward a source with acceptable cost per appointment and show rate.
• Staff Saturday before buying more Monday volume.
• Force sold-unit cleanup when the note says inquiries were dead cars.

The page is not allowed to fire a BDC specialist by itself. That is a scorecard conversation with tape and samples.

Independent lots and franchise stores

An independent GM may be the internet director. The page still matters; it is how they talk to themselves honestly. A franchise store with a group-level dashboard still needs a rooftop page, because group exports hide the sold-unit problem that only this lot created.

How PostToMarket Automates This

The GM page falls apart on Marketplace when the source is unlabeled, the lister is a shared login, and sold cars keep generating rows that look like demand. Building a one-page lead source report for the GM requires a Marketplace line that is as boringly countable as a vendor CSV. PostToMarket is the operations layer that makes that line possible.

Give Marketplace its own honest row

• Team analytics by rep and source.
• Leads inbox for managers so sampled threads match the counts.
• Roles and per-rep queues so "who worked it" is not a guess.

Stop dead inventory from looking like a source problem

• Mark as sold and archive.
• Statuses (draft, posting, posted, sold, failed).
• Bulk import error logs when the junk started as a file, not as a buyer.

Keep the labor column from being a mystery

• AI copy, photo picker, CSV/Excel import.
• AutoPost one vehicle at a time with human-like delays and server-enforced daily limits.
• Mobile dashboard so after-hours work is visible instead of unofficial.

PostToMarket is independent and not affiliated with Meta. It does not guarantee a prettier ROI row. It reduces the operational mess that makes the Marketplace line unreportable.

One Page, One Meeting, One Decision

Building a one-page lead source report for the GM means fewer columns, frozen definitions, unique people, firm appointments, shows, honest cost, and a note that names the operational miss. Produce it in an hour. Read it in twelve minutes. Decide keep, cut, cap, or fix process. Leave the 14-tab workbook for the analyst who asked for it.

PostToMarket feeds the Marketplace line of that page: unlimited vehicles, paced posting, queues, leads, and source analytics. Starter is $59 per month for a solo seller with one login. Dealership is $299 per month for up to 13 team logins.

Start your 10-day free trial through secure Stripe checkout. Get source, owner, and sold-status in one system before you ask the GM to pick winners from a spreadsheet fog. Cancel anytime.