Skip to main content
ARPILeads & Marketing

Leads & Marketing

Granite Pre-Owned · December 2025

Granite Auto Group is fictional. Operating figures are synthetic.

Every warehouse record in this project is synthetic. Granite Auto Group and its three stores are fictional. No real dealership, customer, employee or lending data exists anywhere in the project.

Dataset v17 · developmentAs of 31 December 2025Real-engine validation pending

Real-engine validation pending. Neither accepted ADR-0008 path has recorded a result, so nothing on this page may be read as evidence that the Power BI semantic model has been validated. This console renders exported SQL figures; rendering a number in HTML proves nothing about a DAX measure.

The evidence behind both statements

How this is built, governed and validated

Filters and controls2 applied

Scopes both sides of every rate on this page, including the appointment outcomes.

Scopes the funnel, response, appointment and marketing blocks alike.

This period includes an immature cohort. Leads count in the period they arrived, so the newest ones have had least time to convert: lead-to-sale, cost per attributed sale and gross return are structurally incomplete here and improve as those leads mature.

Demand

December 2025
  • Valid leads

    231

    23 duplicates excluded

    KPI-FUN-001

  • Contact rate

    72.7%

    of valid leads

    KPI-FUN-002

  • Appointment-set rate

    33.3%

    of contacted leads, not of all leads

    KPI-FUN-003

  • Lead-to-sale

    0.4%

    of valid leads. Not the product of the steps

    KPI-FUN-006

  • Show rate

    66.7%

    appointment grain, scheduled date

    KPI-FUN-004

  • Median response

    27.5 minutes

    answered leads only

    KPI-FUN-008

  • Never answered

    27

    excluded from both response figures

How every figure on this rail is measured

Valid leads (KPI-FUN-001) counts non-duplicate lead records on the date the lead arrived. Duplicates are removed from both sides of every rate rather than from neither: they inflate volume and depress every conversion rate at once.

Contact rate (KPI-FUN-002) divides contacted leads by valid leads. Appointment-set rate (KPI-FUN-003) divides by contacted leads, not by all of them: an appointment cannot be set with someone who was never reached. Lead-to-sale (KPI-FUN-006) divides by valid leads again, so it is not the product of the steps above it.

Show rate (KPI-FUN-004) is an appointment-grain measure over eligible appointments on the scheduled date. One lead can produce several appointments, so it does not continue the lead counts beside it, and it is on this rail as context rather than as a funnel step.

Median response (KPI-FUN-008) is recomputed from the exported response population under the current filters, not blended from published medians: a median does not decompose, and averaging daily or store medians gives a different and wrong answer. It and the mean both exclude leads that were never answered, which is why Never answered is on the same rail. A lead with no recorded response was never answered; it is not a response of zero seconds, and a genuine zero-second auto-response is counted normally.

No figure here is coloured or compared to a target. ARPI holds no benchmark for any of them and publishes none.

Lead cohort

Lead grain · lead-creation date

Lead-created cohort

Every stage counts LEADS, on the date the lead arrived. Bar length is the stage over valid leads.

Valid leads 231, Contacted 168 (72.7% of valid leads), Appointment set 56 (33.3% of contacted leads), Reached showroom 37, Sold 1 (0.4% of valid leads).

  • Valid leads231

  • Contacted16872.7% of valid leads KPI-FUN-002

  • Appointment set5633.3% of contacted leads KPI-FUN-003

  • Reached showroom37

  • Sold10.4% of valid leads KPI-FUN-006

The bar is arithmetic on two exported columns, not a governed KPI; each governed rate is named beside its count with the denominator it divides by. Reached showroom carries no rate — the governed show measure is appointment grain and sits in the figure beside this one, not inside it.

Read lead-created cohort as a table
Lead-created cohort. Valid leads 231, Contacted 168 (72.7% of valid leads), Appointment set 56 (33.3% of contacted leads), Reached showroom 37, Sold 1 (0.4% of valid leads).
StageLeadsShare of leads receivedGoverned rate
Valid leads231100.0%No governed rate at this stage
Contacted16872.7%72.7% of valid leads (KPI-FUN-002)
Appointment set5624.2%33.3% of contacted leads (KPI-FUN-003)
Reached showroom3716.0%No governed rate at this stage
Sold10.4%0.4% of valid leads (KPI-FUN-006)

Appointments

Appointment grain · two date bases

Appointment outcomes

Counts APPOINTMENTS, not leads: one lead can produce several, so these denominators are not the lead counts beside them. Show rate is on the scheduled date; show-to-sale on the show date.

95 scheduled appointments, 20 cancelled in advance, 75 eligible to show, 50 shown, 1 shown and sold.

  • Scheduled appointments95
  • Cancelled in advance20

    21.1% of scheduled — removed from the show-rate denominator

  • Eligible to show75

    scheduled less advance cancellations

  • Shown50

    66.7% of eligible appointments KPI-FUN-004

  • Shown and sold1

    2.0% of 50 visits on the show date KPI-FUN-005

Read appointment outcomes as a table
Appointment outcomes: count, governed rate and the denominator it divides by.
StageAppointmentsGoverned rate
Scheduled appointments95Count only
Cancelled in advance2021.1% of scheduled — removed from the show-rate denominator
Eligible to show75scheduled less advance cancellations
Shown5066.7% of eligible appointments (KPI-FUN-004)
Shown and sold12.0% of 50 visits on the show date (KPI-FUN-005)

Response

Lead grain · lead-creation date

Time to first response

Median first response 27.5 minutes across 204 answered leads, with 27 leads carrying no recorded response.

  • Median

    27.5 minutes

    the headline: the distribution is heavily skewed

    KPI-FUN-008

  • Mean

    73.4 minutes

    moved by the tail

    KPI-FUN-007

  • 90th percentile

    159.4 minutes

    the tail the median cannot see

  • Under 5 minutes2411.8%
  • 5-15 minutes4924.0%
  • 15-60 minutes7134.8%
  • Over 60 minutes6029.4%
  • Never answered27

    A share of 231 valid leads, not of the answered population above: response coverage 88.3%. Excluded from the median and the mean by definition — never answered is not a response of zero seconds.

Read the response distribution as a table
First-response bands, with the count of answered leads in each and its share of all answered leads.
BandAnswered leadsShare of answered
Under 5 minutes2411.8%
5-15 minutes4924.0%
15-60 minutes7134.8%
Over 60 minutes6029.4%
No recorded response27Excluded from both KPIs

Where the cohort stopped

Mutually exclusive

Furthest stage reached

231 valid leads partitioned across 5 terminal stages, each lead counted once.

  • Did not reach contact63
  • Did not reach appointment112
  • Did not reach showroom19
  • Showed without attributed sale36
  • Showed and bought1

Each lead is counted once, at the furthest stage it reached, and the counts sum to 231 valid leads. They say where progression stopped, never why: no communication or activity detail exists in this project to carry a reason. Separately, 0 of the leads that bought have no modelled showroom visit — already counted in an earlier stage above, shown here rather than added.

Sources

Sources on volume and the three governed rates

The three rate columns share one 0–100% scale and compare directly. Volume is scaled to the largest source in scope and shares no scale with them. Business-code order; nothing is ranked and no composite score exists.

18 lead sources in scope, each with valid leads, contact rate, appointment-set rate and lead-to-sale conversion.

  • Dealer Website Form3577.1%40.7%0.0%
  • Dealer Website Chat1181.8%44.4%0.0%
  • Email Marketing Response4100.0%50.0%0.0%
  • Organic Search Landing1573.3%18.2%0.0%
  • Direct Site Visit450.0%0.0%0.0%
  • Paid Search Brand1984.2%31.3%0.0%
  • Paid Search Non-Brand2770.4%26.3%0.0%
  • Paid Social Feed Campaign757.1%25.0%0.0%
  • Paid Social Video Campaign714.3%0.0%0.0%
  • Third-Party Marketplace Listing3974.4%31.0%0.0%
  • Third-Party Trade Valuation Portal1172.7%37.5%0.0%
  • Radio Spot Response757.1%25.0%0.0%
  • Direct Mail Response560.0%66.7%0.0%
  • Television Spot Response650.0%33.3%0.0%
  • Showroom Walk-in1687.5%35.7%0.0%
  • Customer Referral988.9%37.5%11.1%
  • Community Partner Referral450.0%0.0%0.0%
  • Service Lane Opportunity580.0%50.0%0.0%

Contact divides by valid leads (KPI-FUN-002). Appt set divides by contacted leads (KPI-FUN-003). Lead-to-sale divides by valid leads (KPI-FUN-006). Appointment-set rate divides by CONTACTED leads and not by all of them, so a source reached rarely can post a higher one than a source reached often.

Read source outcomes as a table
Lead source, category, valid leads, contact rate, appointment-set rate, lead-to-sale conversion and sold leads.
SourceCategoryValid leadsContactAppt setLead-to-saleSold
Dealer Website FormOwned Digital3577.1%40.7%0.0%0
Dealer Website ChatOwned Digital1181.8%44.4%0.0%0
Email Marketing ResponseOwned Digital4100.0%50.0%0.0%0
Organic Search LandingOrganic Web1573.3%18.2%0.0%0
Direct Site VisitOrganic Web450.0%0.0%0.0%0
Paid Search BrandPaid Search1984.2%31.3%0.0%0
Paid Search Non-BrandPaid Search2770.4%26.3%0.0%0
Paid Social Feed CampaignPaid Social757.1%25.0%0.0%0
Paid Social Video CampaignPaid Social714.3%0.0%0.0%0
Third-Party Marketplace ListingThird Party3974.4%31.0%0.0%0
Third-Party Trade Valuation PortalThird Party1172.7%37.5%0.0%0
Radio Spot ResponseTraditional Media757.1%25.0%0.0%0
Direct Mail ResponseTraditional Media560.0%66.7%0.0%0
Television Spot ResponseTraditional Media650.0%33.3%0.0%0
Showroom Walk-inWalk-in1687.5%35.7%0.0%0
Customer ReferralReferral988.9%37.5%11.1%1
Community Partner ReferralReferral450.0%0.0%0.0%0
Service Lane OpportunityInternal580.0%50.0%0.0%0

Marketing economics

2025-12

Attribution is single-source and first-touch: a customer who arrived through three channels is credited to one, and sales are anchored to the originating lead's creation month rather than the sale date. Association under that convention is not causation.

  • Attributable spend

    $1,221

    cost-attributable sources only

  • Cost per valid lead

    $9.25

    total spend ÷ total attributed leads

    KPI-MKT-001

  • Cost per attributed sale

    No data

    total spend ÷ total attributed retail units

    KPI-MKT-002

  • Gross return on ad spend

    0.00

    attributed gross ÷ spend. Contribution, not profit

    KPI-MKT-003

Cost and return, by source

Whole calendar months only: 2025-12. Each column is scaled to its own largest source; lengths compare within a column and never across two.

18 lead sources over 2025-12, each with spend, cost per valid lead, cost per attributed sale and gross return on ad spend.

  • Dealer Website FormNot applicableNot applicableNot applicableNot applicable
  • Dealer Website ChatNot applicableNot applicableNot applicableNot applicable
  • Email Marketing ResponseNo dataNo dataNo dataNo data
  • Organic Search LandingNot applicableNot applicableNot applicableNot applicable
  • Direct Site VisitNot applicableNot applicableNot applicableNot applicable
  • Paid Search Brand$172$9.03No data0.00
  • Paid Search Non-Brand$685$25.35No data0.00
  • Paid Social Feed Campaign$137$19.58No data0.00
  • Paid Social Video CampaignNo dataNo dataNo dataNo data
  • Third-Party Marketplace ListingNo dataNo dataNo dataNo data
  • Third-Party Trade Valuation Portal$88$8.04No data0.00
  • Radio Spot Response$139$19.86No data0.00
  • Direct Mail ResponseNo dataNo dataNo dataNo data
  • Television Spot ResponseNo dataNo dataNo dataNo data
  • Showroom Walk-inNot applicableNot applicableNot applicableNot applicable
  • Customer ReferralNot applicableNot applicableNot applicableNot applicable
  • Community Partner ReferralNot applicableNot applicableNot applicableNot applicable
  • Service Lane OpportunityNot applicableNot applicableNot applicableNot applicable

An organic or internal source has NO cost per opportunity — not a cost of zero — so it prints Not applicable and draws no bar. Gross return is attributed gross over spend: a contribution measure, not profit, ROI or incremental return.

Read spend and attribution by campaign as a table
Marketing performance by source and campaign: spend, attributed leads and retail sales, cost per lead, cost per sale, attributed gross, gross return and cost state.
SourceCampaignSpendLeadsSalesCost/leadCost/saleAttributed grossGross ROASCost state
Dealer Website FormNo campaignNot applicable350Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Dealer Website ChatNo campaignNot applicable110Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Email Marketing ResponseNo campaignNo data40No dataNo data$0No dataLeads with no recorded spend
Organic Search LandingNo campaignNot applicable150Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Direct Site VisitNo campaignNot applicable40Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Paid Search BrandNo campaignNo data00No dataNo data$0No dataLeads with no recorded spend
Paid Search BrandSummer Clearance 2025 - Paid Search$5030$16.70No data$00.00Spend with no attributed sales
Paid Search BrandModel Year Close-Out 2025 - Paid Search$121160$7.59No data$00.00Spend with no attributed sales
Paid Search Non-BrandNo campaignNo data30No dataNo data$0No dataLeads with no recorded spend
Paid Search Non-BrandModel Year Close-Out 2025 - Paid Search$501160$31.32No data$00.00Spend with no attributed sales
Paid Search Non-BrandLabor Day Sales Drive 2025 - Paid Search$18380$22.93No data$00.00Spend with no attributed sales
Paid Social Feed CampaignNo campaignNo data10No dataNo data$0No dataLeads with no recorded spend
Paid Social Feed CampaignCertified Used Push 2025 - Paid Social$13760$22.84No data$00.00Spend with no attributed sales
Paid Social Video CampaignNo campaignNo data70No dataNo data$0No dataLeads with no recorded spend
Third-Party Marketplace ListingNo campaignNo data390No dataNo data$0No dataLeads with no recorded spend
Third-Party Trade Valuation PortalNo campaignNo data10No dataNo data$0No dataLeads with no recorded spend
Third-Party Trade Valuation PortalLabor Day Sales Drive 2025 - Third-Party Listings$88100$8.84No data$00.00Spend with no attributed sales
Radio Spot ResponseYear-End Sales Event 2025 - Radio$13970$19.86No data$00.00Spend with no attributed sales
Direct Mail ResponseNo campaignNo data50No dataNo data$0No dataLeads with no recorded spend
Television Spot ResponseNo campaignNo data60No dataNo data$0No dataLeads with no recorded spend
Showroom Walk-inNo campaignNot applicable160Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Customer ReferralNo campaignNot applicable91Not applicableNot applicable$1,690Not applicableOrganic or internal — no advertising cost
Community Partner ReferralNo campaignNot applicable40Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Service Lane OpportunityNo campaignNot applicable50Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost

Vendor reconciliation

Vendor counts against the CRM

Over 2025-12, vendors reported 37 leads against 231 valid CRM leads.

  • Vendor reported37
  • Lead records received254
  • Duplicates excluded23
  • Valid leads (KPI-FUN-001)231

Four counts of four different populations, deliberately not reconciled to each other. Vendor spend is recorded by month, so the comparison is formed only over whole months in the selected period.

How to read this page

Why there are no targets or benchmark colours

ARPI holds no benchmark data for response time, contact rate, show rate, cost per lead, cost per sale or gross return, so it publishes no target for any of them and nothing on this page is coloured good or bad. The response bands are descriptive bins. Compare stores, sources and periods against each other; this project has no industry standard to offer you.

What the lost-stage counts do and do not say

Each lead is counted once, at the furthest stage it reached, and the counts sum exactly to the valid leads in scope. They say where progression stopped. They say nothing about why, and nothing in this project could: no communication content, activity detail, note or disposition is modelled anywhere in it. Some leads that bought have no modelled showroom visit — a walk-in later matched to a lead — which is why the chain of stage rates only approximates lead-to-sale conversion rather than equalling it. That difference is expected and is not an error.

Why marketing is monthly, and why organic sources show no cost

Spend is recorded by calendar month while leads arrive daily, so dividing a month of spend by part of a month of leads would produce a figure that looks precise and means nothing. Cost measures are computed only over whole months in the selected period, and spend is never prorated: this project governs no proration rule. For organic and internal sources, cost per lead, cost per sale and gross return are NOT APPLICABLE rather than zero — a walk-in is not a zero-cost advertising campaign, and a $0.00 cost per lead would rank it as the most efficient channel the group operates. Where spend produced no attributed lead or no attributed sale, that is stated as its own result rather than shown as an infinite or missing cost.

Why the comparison is by source and the table is by campaign

Cost per lead, cost per sale and gross return are ratios of sums at whatever group they are formed over: total spend over total attributed outcomes, never an average of per-campaign ratios, which would weight a campaign that produced two leads the same as one that produced two hundred. The same governed arithmetic is applied at three groups on this page — per source for the comparison, per source and campaign for the table, and over every cost-attributable row for the headline figures. KPI-MKT-001, KPI-MKT-002 and KPI-MKT-003 keep their published definitions at all three.

What gross return on ad spend is, and is not

It is attributed gross divided by spend: a contribution measure. It nets out the cost of the vehicle and nothing else — no personnel, facility, floor-plan, overhead, tax or agency cost beyond the modelled spend is deducted anywhere in this project — so it is not profit, not net profit and not return on investment. A revenue-based return is deliberately not shown: vehicle revenue includes the cost of the vehicle, which inflates such a ratio by roughly an order of magnitude. Clicks and impressions are vendor-reported activity rather than value, and are not presented as marketing outcomes.

How leads are attributed, and why cohorts look worse recently

Attribution is single-source and first-touch: a lead is credited to exactly one source and one campaign, and a customer who arrived through three channels is credited to one. No multi-touch, linear, time-decay, last-touch, position-based or view-through model exists in this project. Sales and gross are attributed through the originating lead’s creation month rather than the sale date, so this month’s spend is never credited with last quarter’s leads — and the consequence is that the most recent cohort has had the least time to convert and always looks worst. ARPI defines no maturity horizon, so recent cohorts are shown in full and labelled rather than hidden or adjusted.

Why vendor lead counts do not match the CRM

They are different populations on purpose. Vendors count leads their own way and typically count duplicates that the CRM de-duplicates, so the two figures are published side by side and never reconciled to each other. The gap is something to raise with a vendor; it is not automatically a data-quality failure, and the vendor figure is never substituted for the governed valid-lead count.

What this page deliberately does not contain

No lead, customer, salesperson, message, note, call recording, phone number or email address appears anywhere on this page, because none of it is exported: the response distribution is a histogram of counts with no identity attached to any bin. Every source, vendor and campaign named here is fictional, and the data is synthetic throughout. There is no employee ranking — that is a separate surface — and no recommendation: this page reports evidence and does not tell you what to do about it.