Industry guide
Car dealership marketing dashboard: from ad spend to cost per vehicle sold
A car dealership marketing dashboard shows what every channel costs and how many of its leads turn into appointments, shows and sold units, using the DMS as the record of what was actually delivered. This guide is for dealer principals, general managers, group marketing directors and the automotive agencies that run their media. It covers the KPIs each role needs, where the data lives, the problems that break dealer reports, and how our team builds the dashboard in Data Studio.

Quick answer
What should a car dealership marketing dashboard track?
A car dealership marketing dashboard should track spend, leads, appointments set, appointments shown and vehicles sold for every source, split by new and used. The headline figures are cost per lead, cost per show and cost per vehicle sold, with sold units read from the DMS rather than from ad platforms, so budget follows deliveries instead of form fills.
- Judge every channel on cost per vehicle sold, using DMS deals as the sales record.
- Split new and used, and franchise from independent, because economics differ sharply between them.
- Lead deduplication and a locked original source field matter more than chart design.
- Agencies with several rooftops need one template and a store dimension, not copies.
What should a car dealership marketing dashboard show?
A car dealership marketing dashboard should answer one question first: which sources sell cars, and what does each sale cost in marketing. Clicks, impressions and website sessions support that answer but should not lead the report.
Most stores already have the pieces. Google Ads, Meta and Microsoft Ads report spend. Third-party listing sites send leads by email or through the CRM. GA4 records VDP views, credit applications, trade-in valuations and payment calculator use. The CRM holds every lead and appointment, and the DMS holds every deal that was delivered. What is usually missing is the join between them, so a campaign gets praised for 300 leads while nobody can say how many bought.
We lay the report out in four pages. An overview for the dealer principal or GM with spend, leads, shows and units sold by month. A source page that compares channels on cost per stage. A sales process page with response time, appointment set rate and show rate by BDC agent or salesperson. An inventory page that shows VDP views and leads by vehicle, so the used car manager can see which units attract interest and which sit unseen.
- Overview: spend, leads, appointments, shows and units sold, new and used, with month-on-month change.
- Sources: cost per lead, per show and per vehicle sold for every channel and listing site.
- Process: first response time, appointment set rate and show rate by BDC agent or salesperson.
- Inventory: VDP views, leads and days in stock by stock number, make and model.
Which automotive marketing KPIs matter most?
The automotive marketing KPIs that matter are the ones closest to a delivered vehicle. Cost per vehicle sold decides budget, but it arrives weeks after the spend, so pair it with leading indicators that move within days.
Response time is the most actionable of these. If a source's leads wait hours for a first reply, the problem is the process, and cutting that source's budget would punish the wrong thing. Show rate is the second check: a channel can set plenty of appointments that never arrive at the store.
| KPI | How it is calculated | Where the data lives | Who reads it |
|---|---|---|---|
| Cost per lead | Spend divided by unique leads from that source | Ad platforms plus CRM | Marketing manager, agency |
| First response time | Minutes from lead creation to first logged call, text or email | CRM activity log | BDC manager, GM |
| Appointment set rate | Appointments set divided by unique leads | CRM | BDC manager |
| Show rate | Appointments shown divided by appointments set | CRM | Sales manager, GM |
| Close rate | Vehicles sold divided by unique leads | CRM matched to DMS deals | GM, dealer principal |
| Cost per vehicle sold | Marketing spend divided by units sold from that source | Ad platforms plus DMS | Dealer principal, group marketing |
| VDP views per unit | Vehicle detail page views divided by units in stock | GA4 plus inventory feed | Used car manager |
What does a worked cost per vehicle sold example look like?
Cost per vehicle sold is total marketing spend for a source divided by the vehicles that source sold in the same cohort. A worked example shows why it changes decisions that cost per lead would get wrong.
For scale, NADA Data 2025, as reported by Dealership Guy in May 2026, puts average franchised dealer advertising at $739 per new vehicle sold and total dealer ad spend at $9.96 billion, with digital media at 74.9% of the total. Search engine marketing took about one in five ad dollars and social media 14.2%. Those averages are a sanity check, not a target: a dashboard tells you your own figure by source.
Take an illustrative store that spends $30,000 in a month across three sources. Paid search costs $12,000 and brings 240 unique leads, of which 24 buy within 60 days: $50 per lead and $500 per vehicle sold. A listing site costs $10,000 and brings 400 leads, of which 20 buy: $25 per lead and $500 per vehicle sold. Paid social costs $8,000 and brings 320 leads, of which 8 buy: $25 per lead but $1,000 per vehicle sold.
On cost per lead, paid search looks like the worst channel. On cost per vehicle sold, it ties for best, and paid social is the one to question. The dashboard only shows this if leads are deduplicated, matched to DMS deals and grouped by the month they arrived.
Which data sources feed a dealership reporting dashboard?
A dealership reporting dashboard usually draws on six to ten sources. Some connect natively to Data Studio, some need a partner connector, and the CRM and DMS almost always need an export or a warehouse in between.
Google Ads, GA4, Search Console, YouTube and Google Sheets have native connectors. Meta, Microsoft Ads and TikTok need a partner connector from vendors such as Supermetrics, Windsor.ai or Porter Metrics. Dealer CRMs and DMS platforms such as CDK, Reynolds and Reynolds or Dealertrack typically reach a dashboard through scheduled reports or an approved data feed, which we land in Google Sheets or BigQuery.
Blends in Data Studio are limited to 5 data sources with equality joins, and a single store with ads, GA4, a CRM, a DMS and call tracking already reaches that. Past it, we move the joins into BigQuery and give Data Studio one clean table per page. That also keeps GA4 inside its API quotas when every manager opens the report on the first of the month.
- Paid media: Google Ads, Meta, Microsoft Ads, YouTube and any OEM or tier 2 co-op programs.
- Website: GA4 events for VDP views, credit applications, trade-in valuations and chat starts.
- Listing sites: leads by source and vehicle, usually read from the CRM rather than portal reports.
- CRM: lead source, owner, appointment set and shown dates, and status.
- DMS: deal date, stock number, new or used, front and back gross if the group wants them.
- Call tracking and inventory feed: calls by campaign, and stock numbers with days in stock.
Why do dealer marketing dashboards give the wrong answer?
Dealer marketing dashboards usually go wrong in the data, not in the charts. Three problems cause most of the bad numbers we see in dealer reports.
The first is duplicate leads. One shopper submits a form, calls, then sends a listing site enquiry, and the CRM counts three leads. Unless the report deduplicates by phone, email or customer ID inside a time window, cost per lead looks low and close rate looks poor. The second is source overwriting. Salespeople edit the source field, so the original channel is lost. A locked original source field, separate from the latest source, fixes it.
The third is the hybrid buyer. The Cox Automotive Car Buyer Journey Study for 2025, reported by Digital Dealer in January 2026, surveyed over 2,300 recent buyers and found 44% of new-vehicle buyers followed a hybrid path that mixes online steps with time at the store, and total buying time was just under 14 hours. Many of those buyers walk in without ever filling a form. Matching DMS deals back to earlier leads by phone or email, and reporting walk-ins as their own source, keeps those sales from vanishing.
Smaller traps add up too: OEM co-op spend that sits outside the store's ad accounts, Google Ads conversions counting all calls rather than qualified ones, and new and used deals mixed into one close rate.
How should agencies report across several rooftops?
Agencies and dealer groups with several rooftops should build one report with a store dimension, not one copy per store. Copies drift apart within months, and every fix has to be made many times.
In practice, that means each source carries a store ID: ad accounts are mapped to stores in a lookup table, CRM and DMS exports include the rooftop code, and GA4 properties or data streams are tagged by store. A store filter then lets a GM see one rooftop while the group marketing director compares all of them on the same page. For agencies that resell this reporting under their own brand, our white-label service handles the template, the per-store data and the delivery schedule.
Access needs thought as well. Data source credentials set to the owner's credentials let viewers see data without platform access, so we check which figures each store manager should see before the report goes out, especially gross profit.
How do we build a car dealership marketing dashboard?
We build a car dealership marketing dashboard in five steps, and most of the effort sits in the first three. The visible pages come last.
A single store with clean exports is usually a short project. A dealer group with several CRMs or DMS platforms takes longer because each system's fields must be mapped to one model before any chart is trustworthy. We confirm scope and a fixed price after a free review of your sources.
- Agree definitions: what counts as a lead, a show and a sale, and the cohort window for matching.
- Map sources: one source list, a lookup for listing sites and campaigns, and a locked original source.
- Connect and model: ad platforms, GA4, CRM and DMS into Sheets or BigQuery, with deduplication rules.
- Build pages: overview, sources, process and inventory, with store, new or used and date filters.
- Reconcile and hand over: totals checked against the DMS and ad platforms, then documentation and ownership transfer.
When should a dealership not build a custom dashboard?
A custom dashboard is not always the right call. If your website provider or CRM already reports leads to sold units by source and your team trusts it, a second report adds work without new answers.
It is also too early if the CRM source field is empty for most leads or the DMS cannot export deals with a phone or email to match on. Fix intake first, then build. And if you run one store with one or two channels, a simple native report on Google Ads and GA4 may be enough until spend grows.
FAQ
Frequently asked questions
What is a good cost per vehicle sold for a dealership?
There is no universal target, because it varies by brand, market and new versus used. NADA Data 2025 puts the franchised dealer average at $739 in advertising per new vehicle sold, which is a useful reference point. Your own dashboard should show the figure by source so you can compare channels.
Can Data Studio connect to my dealer CRM or DMS?
Usually not directly with a native connector. Most stores send scheduled CRM and DMS reports or an approved data feed into Google Sheets or BigQuery, and Data Studio reads from there. That route also lets us clean and deduplicate the data first.
What KPIs should a dealership track for digital marketing?
Track cost per lead, first response time, appointment set rate, show rate, close rate and cost per vehicle sold, split by new and used. Add VDP views per unit for inventory merchandising. Cost per vehicle sold should be the figure that drives budget.
How do you attribute walk-in customers in a dealership dashboard?
Match each DMS deal back to earlier leads by phone number or email within a set window, such as 60 or 90 days. Deals with no match are reported as walk-ins rather than dropped. This shows how much of the store's business came from earlier digital contact.
Can one dashboard cover several dealerships in a group?
Yes. Build one report with a store dimension and map every ad account, GA4 stream and DMS export to a rooftop code. A filter then shows one store or the whole group, and fixes are made once rather than in many copies.
Can an automotive marketing agency white-label the dashboard?
Yes. Data Studio reports can carry your agency's branding, and the same template can be pointed at each dealer client's data. We build and run white-label dealer reporting for agencies, including the per-client data sources and scheduled delivery.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.