A lot of dealership reporting gets built once, looks impressive, and then goes unused within a month. Often the underlying problem is a confusion between what a dashboard is for and what a report is for, resulting in something that tries to be both and does neither well.
What a daily dashboard is actually for
A dashboard answers a narrow question fast: is anything wrong right now that needs attention today? It should show a handful of numbers, response time, new leads, any campaign with an unusual cost spike, glanceable in under a minute, not a comprehensive view of every metric available.
What a monthly or quarterly report is actually for
A report answers a different question: what's the trend, and what should change strategically? This is where deeper analysis belongs, comparing performance across channels and time periods, understanding cost-per-sale trends, and making budget or strategy decisions based on a fuller picture than any single day provides.
Why confusing the two produces something nobody uses
A dashboard cluttered with every metric available becomes too slow to check daily, so it gets ignored. A report reduced to a handful of daily numbers doesn't provide enough context for real strategic decisions. Building one artifact trying to serve both purposes usually satisfies neither.
What belongs on a dealership owner's daily dashboard
Keep it to four or five numbers: new leads received, response time to those leads, any campaign showing an unusual cost spike, and showroom visits or test drives booked. This should take under a minute to review and immediately surface whether something needs attention today.
What belongs in the monthly or quarterly report instead
Cost-per-sale by channel, conversion rate trends across the funnel, comparison against the prior period, and any structural changes worth considering, like reallocating budget between Google Ads and Meta Ads based on sustained performance patterns rather than a single day's numbers.