← Back to blog

Marketing Data Dictionary for Car Dealerships

November 19, 2026
Marketing Data Dictionary for Car Dealerships

A marketing data dictionary is a single document that defines every metric your dealership reports on: its name, plain-language meaning, formula, data source, owner and effective date. For a franchise dealership it matters because each vendor reports its own version of "lead," "conversion" and "cost per lead," and the numbers cannot be compared until everyone uses the same definitions. Build the dictionary first and the vendor reports start to line up. The gaps that remain show you where budget is leaking.

Autoroiq
autoroiq.com
Make Dealership Marketing Data Clear
AutoROIQ provides independent analysis and executive-level recommendations to clarify vendor performance and where your marketing budget is being used.
Visit

TL;DR

  • A marketing data dictionary defines each metric once: name, meaning, formula, source system, owner and effective date.
  • Dealerships need one because vendors define leads, conversions and costs differently, which leaves leadership making decisions on emotion and swapping vendors repeatedly.
  • Start with the 10 to 15 metrics already in your monthly leadership reports, not your whole technology stack.
  • Record changes with effective dates instead of overwriting old rules, so trends stay comparable.
  • The dictionary only works if someone independent of the vendors enforces it.

Table of Contents

What a marketing data dictionary is

In data work, a data dictionary is a catalog of data elements and what each one means. A marketing data dictionary applies the same idea to the numbers marketing produces. Think of the lines on a vendor report: leads, form fills, VDP views (vehicle detail page views), cost per lead, cost per sale, appointments set, showroom visits. Each of those is a term. The dictionary states exactly what counts and what does not.

A KPI dictionary is the same document narrowed to key performance indicators. A metric is any measurement. A KPI is a metric leadership has chosen to judge performance and budget by, such as cost per vehicle sold from a channel. Most dealerships need one document with a column that flags which metrics are KPIs.

People searching this topic often find general marketing glossaries that define terms like "impressions" or "retargeting." A glossary explains what a word means in the industry. A dictionary fixes what the word means in your reports: which system produces it, how it is calculated, who answers for it. Only the second one settles an argument in a vendor meeting.

Why dealerships need one

A typical franchise store buys from several sources at once: a website provider, a search and social agency, third-party listing sites, a CRM (customer relationship management system), a call-tracking tool, and TV or OTT (streaming TV) buys. Each one reports from its own system with its own rules.

Digital Dealer's reporting on data attribution identifies this as the weakest link: every vendor reports its own metrics, creating a blind spot that pushes dealers to decide on emotion and replace vendors repeatedly. The same piece recommends standardizing Google Analytics source and medium tags, so traffic is labeled the same way across vendors, and using a vendor-neutral platform for comparisons.

A dictionary is the human side of that fix. Tags and platforms carry the data, but the dictionary records what the data means, so a general manager reading three reports is comparing like with like.

An example of the problem

The numbers below are illustrative, not from a real store. Suppose two vendors each report 100 leads for $5,000 in a month, so both show a $50 cost per lead. Vendor A counts only form submissions and phone calls longer than 60 seconds. Vendor B counts every click on a phone number, every chat opening and every form start, including abandoned ones. The headline numbers match. The underlying quality does not.

With a dictionary entry that says "Lead: a submitted form or a call of 60 seconds or more, deduplicated by phone or email within 30 days, as recorded in the CRM," Vendor B's 100 may become 40. Its real cost per lead is then $125. Nothing changed about the spend. Only the definition changed, and the budget decision changes with it.

Reported and adjusted lead costs compared

What each entry should contain

A useful entry is short but complete. MTF Institute's marketing analytics playbook describes a metric "contract" that documents the entity, grain, numerator, denominator, eligible population, window, timezone, currency, filters, exclusions, source, owner, refresh cadence and target. That is thorough, and a dealership can trim it to the fields that settle disputes. Here is a working template.

FieldWhat to recordDealership example
Metric nameThe exact label used in reportsCost per lead (CPL)
Plain-language definitionOne sentence a general manager can repeatMarketing spend divided by qualified leads in the same period
FormulaNumerator, denominator, date rangeChannel spend for the calendar month / qualified leads created in the CRM that month
Counting rulesWhat is included and excludedExcludes duplicates, spam, employee test leads
Source systemThe one authoritative systemCRM for leads; ad platform for spend
OwnerA named role, not a vendorDigital marketing director
Time rulesWindow, timezone, refresh frequencyEastern time, refreshed daily, closed on the 5th of the next month
StatusObserved, modeled, estimated or unavailableObserved
Effective dateWhen this definition took effectSet by your team when approved

The status row comes from the same playbook, which recommends labeling measurements as observed, modeled, estimated or unavailable and making limitations visible when a report mixes them. This matters for dealerships because some numbers are counted directly, such as a form submission, while others are inferred, such as a store visit credited to an ad. A reader should know which is which.

The "authoritative source" rule

Many metrics live in more than one system. Leads appear in the CRM, the website platform and the ad platform. Pick one system as the source of record for each metric and say so in the entry. When a vendor's dashboard disagrees with the source of record, the dictionary tells you which number wins, and the conversation becomes about why they differ rather than which one to believe.

Core metrics a dealership dictionary should cover

Do not try to document everything. Start with the metrics that drive budget decisions. Group them by where they sit in the buyer path.

Visibility and traffic

  • Impressions: the number of times an ad or listing is shown. Define whether it counts only measured, viewable impressions.
  • Click-through rate (CTR): clicks divided by impressions, multiplied by 100. Adverity's KPI guidance gives this formula and suggests segmenting CTR by device, placement or audience to diagnose creative fatigue.
  • VDP views: views of an individual vehicle detail page. Define whether you count unique sessions or total page loads, and whether bot traffic is filtered out.

Leads and conversion

  • Lead: the most important entry in the document. Spell out each type (form, phone, chat, text, credit application), what makes one "qualified" and how duplicates are handled.
  • Conversion rate: conversions divided by the visits or clicks that could have converted. Name both the numerator and the denominator.
  • Appointment set and appointment shown: two different metrics. Say who records them and where.

Cost and return

  • Cost per lead: spend divided by qualified leads, as in the template above.
  • Cost per sale (or cost per vehicle sold): spend divided by vehicles sold that trace back to the channel. State the attribution rule used to trace them.
  • Customer acquisition cost (CAC): Adverity defines it as total spend divided by the number of new customers, combining ad-spend data with CRM or commerce customer data. In a dealership, decide whether service-drive customers who buy a vehicle count as new.
  • Marketing ROI: gross profit attributed to marketing minus marketing cost, divided by marketing cost. Decide whether you use front-end gross, total gross including finance and insurance, or both.

Attribution

  • Attribution model: the rule for assigning credit among touchpoints, such as last click or position based. Google's Dealer Guidebook recommends moving beyond last-click attribution to understand the customer journey, and lists store visits and store sales among the measurement capabilities for dealership advertising. Your dictionary should name the model in use for each report.

For deeper treatment of attribution definitions, see our guides on lead source attribution for automotive dealerships and dealership attribution modeling.

Benchmarks belong in the dictionary only with a source and a year

It is tempting to add a target column filled with industry averages. Be careful with the dates. A 2019 Digital Dealer article on using metrics to assess effectiveness cited auto benchmarks of $33.52 average cost per action on Google Search and $23.68 on Google Display, with conversion rates of 6.03% for Search and 1.19% for Display. Cost per action means the cost of each completed action the advertiser defined, which could be a form fill or a call.

Benchmarks belong in the dictionary only with a source and a year

These are 2019 figures. Costs and conversion rates move with auctions, seasons and the way each platform counts an action, so treat any published benchmark as a reference point for that year, not your target. The more useful number is your own trend under a fixed definition. Record your targets as your own, with the date set, and review them on a schedule. For more recent dealership figures, our dealership marketing benchmarks article and the Facebook ads benchmarks for dealers piece show how cost per lead compares with cost per sale.

How to build the dictionary in six steps

  1. Pull the reports leadership already reads. Collect the last three months of vendor reports, the monthly marketing summary and any dashboards. Begin with metrics already in leadership reports rather than documenting the whole technology stack. That keeps the first version to a size people will finish.
  2. List every metric name and note the conflicts. Put each term in a spreadsheet with the vendor that uses it. Where two vendors use the same name for different things, mark it. "Lead" and "conversion" will almost always be flagged.
  3. Choose the source of record. For each metric, name one system that holds the official number. Leads and sales come from the CRM and dealer management system. Spend comes from invoices and ad platforms. Web behavior comes from your analytics property.
  4. Write the entries using the template. Keep definitions in plain language. If a sentence needs a specialist to interpret it, rewrite it.
  5. Validate with the people who own the numbers. The MTF playbook recommends validating definitions with channel, product, data and finance owners. At a dealership that means your digital lead, the BDC (business development center) manager, the controller and the sales manager. Finance sign-off on cost and gross profit definitions prevents later disputes.
  6. Version it and require vendors to use it. The same playbook recommends versioning the contract and recording approved changes with effective dates rather than overwriting historical rules. Add the dictionary to vendor agreements and onboarding so new reports arrive in your definitions from the first month.

Where dictionaries go wrong

  • Too broad. A 200-term document no one opens. Cap the first version at the metrics that drive spending decisions.
  • No owner. Entries with "marketing" as the owner have no owner. Name a role.
  • Vendor-written definitions. A vendor who writes its own definition of its own results is grading its own work. The definitions should come from your side of the table.
  • Silent changes. Changing how a lead is counted midyear breaks every trend line unless the change and its date are recorded.
  • Unlabeled estimates. A modeled store-visit number presented beside an observed lead count invites false precision.

What the dictionary shows once it is in use

The dictionary does not reduce waste by itself. It makes waste visible. When vendor numbers are restated in common terms, three patterns tend to appear:

  • Inflated volume. A channel with strong lead counts but weak appointment and sales rates once duplicates and non-qualified contacts are removed.
  • Credit overlap. Two vendors claiming the same sale, because each uses its own attribution window.
  • Unmeasurable spend. Budget lines that cannot be tied to any outcome under the agreed definitions, such as some TV and streaming buys. Our article on proving TV ads drive dealership sales covers this specific problem.

Once these are on the table, the questions for your next vendor review become concrete: which definition produced this number, and what is it under ours? Our guide on agency performance metrics for dealerships and the marketing governance framework show how to turn those answers into an agenda and accountability. For website data in particular, see the 90-day fix for dealer website metrics.

Our perspective

A dictionary is only as credible as the party that applies it. If the vendor defines the metric, reports the metric and is paid on the metric, the number is not independent evidence. That is the structural problem behind most conflicting dealership reports.

We do not sell advertising, manage campaigns or take commissions from vendors. Because of that, our analysis does not depend on any channel looking good. When we review a dealership's marketing, definitions come first: what counts as a lead, what counts as a sale, which system is the record. Then we restate vendor performance on those terms and give executives a scorecard they can defend in a vendor meeting or a budget review.

Our view is that a dealership principal should not need to become a data analyst to hold vendors accountable. A short, owned, versioned dictionary and an independent reading of the results are what turn a stack of conflicting reports into a decision.

AutoROIQ

Putting definitions to work with an independent review

Writing the dictionary is a few weeks of work. Getting every vendor to report to it, and reading the restated results objectively, is where most stores stall, because the people who would enforce it also have relationships and budgets tied to those vendors.

Our Marketing Intelligence Review is built for that situation. AutoROIQ is vendor-agnostic: we do not sell advertising, manage campaigns or take vendor commissions, and we deliver executive-level scorecards and recommendations on where your marketing spend is working. We also offer ongoing strategic advisory services, vendor contract negotiation and a TV/OTT marketing audit. You can read more on the Marketing Intelligence Review and advisory page, or start from the AutoROIQ home page.

Autoroiq

If you want a view on how much of your spend could be reduced or redirected, see our plan for improving automotive marketing ROI.

FAQ

What is the difference between a marketing data dictionary and a marketing glossary?

A glossary explains what industry terms mean in general. A data dictionary fixes what each metric means in your own reporting: formula, source system, owner and effective date. A glossary helps a new hire learn the vocabulary. A dictionary settles which number is right when two reports disagree.

How many metrics should a dealership include at first?

Start with the metrics already in your leadership and vendor reports, typically somewhere around 10 to 15 that drive budget decisions: leads, appointments, cost per lead, cost per sale, conversion rate, VDP views and ROI. Guidance on building these documents recommends starting with metrics already in leadership reports rather than documenting every system. Add more once the first set is in use.

Who should own the dictionary?

A named internal role should own each entry, usually the digital marketing director or general manager for marketing metrics and the controller for cost and gross profit metrics. Validation should involve channel, data and finance owners. Vendors can contribute data, but they should not write or own the definitions that judge their own results.

How often should definitions be reviewed?

Review on a fixed schedule, such as quarterly, and whenever a system or vendor changes. Record every approved change with an effective date instead of overwriting the old rule, so past results remain comparable.

Sources