Skip to main content
ARPILeads & Marketing

Leads & Marketing

Granite Chevrolet, Granite Subaru · 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 controls1 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

    715

    70 duplicates excluded

    KPI-FUN-001

  • Contact rate

    72.4%

    of valid leads

    KPI-FUN-002

  • Appointment-set rate

    37.3%

    of contacted leads, not of all leads

    KPI-FUN-003

  • Lead-to-sale

    1.8%

    of valid leads. Not the product of the steps

    KPI-FUN-006

  • Show rate

    59.0%

    appointment grain, scheduled date

    KPI-FUN-004

  • Median response

    27.5 minutes

    answered leads only

    KPI-FUN-008

  • Never answered

    82

    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 715, Contacted 518 (72.4% of valid leads), Appointment set 193 (37.3% of contacted leads), Reached showroom 109, Sold 13 (1.8% of valid leads).

  • Valid leads715

  • Contacted51872.4% of valid leads KPI-FUN-002

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

  • Reached showroom109

  • Sold131.8% 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 715, Contacted 518 (72.4% of valid leads), Appointment set 193 (37.3% of contacted leads), Reached showroom 109, Sold 13 (1.8% of valid leads).
StageLeadsShare of leads receivedGoverned rate
Valid leads715100.0%No governed rate at this stage
Contacted51872.4%72.4% of valid leads (KPI-FUN-002)
Appointment set19327.0%37.3% of contacted leads (KPI-FUN-003)
Reached showroom10915.2%No governed rate at this stage
Sold131.8%1.8% 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.

307 scheduled appointments, 73 cancelled in advance, 234 eligible to show, 138 shown, 8 shown and sold.

  • Scheduled appointments307
  • Cancelled in advance73

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

  • Eligible to show234

    scheduled less advance cancellations

  • Shown138

    59.0% of eligible appointments KPI-FUN-004

  • Shown and sold8

    5.8% of 138 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 appointments307Count only
Cancelled in advance7323.8% of scheduled — removed from the show-rate denominator
Eligible to show234scheduled less advance cancellations
Shown13859.0% of eligible appointments (KPI-FUN-004)
Shown and sold85.8% of 138 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 633 answered leads, with 82 leads carrying no recorded response.

  • Median

    27.5 minutes

    the headline: the distribution is heavily skewed

    KPI-FUN-008

  • Mean

    61.6 minutes

    moved by the tail

    KPI-FUN-007

  • 90th percentile

    149.1 minutes

    the tail the median cannot see

  • Under 5 minutes6310.0%
  • 5-15 minutes14923.5%
  • 15-60 minutes23637.3%
  • Over 60 minutes18529.2%
  • Never answered82

    A share of 715 valid leads, not of the answered population above: response coverage 88.5%. 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 minutes6310.0%
5-15 minutes14923.5%
15-60 minutes23637.3%
Over 60 minutes18529.2%
No recorded response82Excluded from both KPIs

Where the cohort stopped

Mutually exclusive

Furthest stage reached

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

  • Did not reach contact197
  • Did not reach appointment325
  • Did not reach showroom84
  • Showed without attributed sale103
  • Showed and bought6

Each lead is counted once, at the furthest stage it reached, and the counts sum to 715 valid leads. They say where progression stopped, never why: no communication or activity detail exists in this project to carry a reason. Separately, 7 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.

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

  • Dealer Website Form11274.1%37.3%0.9%
  • Dealer Website Chat5381.1%23.3%3.8%
  • Email Marketing Response3271.9%34.8%0.0%
  • Organic Search Landing4872.9%25.7%0.0%
  • Direct Site Visit1369.2%11.1%0.0%
  • Paid Search Brand5477.8%47.6%5.6%
  • Paid Search Non-Brand6783.6%32.1%0.0%
  • Paid Social Feed Campaign4746.8%22.7%0.0%
  • Paid Social Video Campaign2128.6%0.0%0.0%
  • Third-Party Marketplace Listing8063.8%37.3%0.0%
  • Third-Party Trade Valuation Portal2065.0%53.8%0.0%
  • Radio Spot Response1464.3%22.2%0.0%
  • Direct Mail Response1861.1%36.4%0.0%
  • Television Spot Response757.1%25.0%0.0%
  • Showroom Walk-in6487.5%55.4%3.1%
  • Customer Referral2785.2%52.2%3.7%
  • Community Partner Referral1788.2%73.3%17.6%
  • Service Lane Opportunity1485.7%25.0%7.1%
  • Repeat Customer Outreach771.4%20.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 Digital11274.1%37.3%0.9%1
Dealer Website ChatOwned Digital5381.1%23.3%3.8%2
Email Marketing ResponseOwned Digital3271.9%34.8%0.0%0
Organic Search LandingOrganic Web4872.9%25.7%0.0%0
Direct Site VisitOrganic Web1369.2%11.1%0.0%0
Paid Search BrandPaid Search5477.8%47.6%5.6%3
Paid Search Non-BrandPaid Search6783.6%32.1%0.0%0
Paid Social Feed CampaignPaid Social4746.8%22.7%0.0%0
Paid Social Video CampaignPaid Social2128.6%0.0%0.0%0
Third-Party Marketplace ListingThird Party8063.8%37.3%0.0%0
Third-Party Trade Valuation PortalThird Party2065.0%53.8%0.0%0
Radio Spot ResponseTraditional Media1464.3%22.2%0.0%0
Direct Mail ResponseTraditional Media1861.1%36.4%0.0%0
Television Spot ResponseTraditional Media757.1%25.0%0.0%0
Showroom Walk-inWalk-in6487.5%55.4%3.1%2
Customer ReferralReferral2785.2%52.2%3.7%1
Community Partner ReferralReferral1788.2%73.3%17.6%3
Service Lane OpportunityInternal1485.7%25.0%7.1%1
Repeat Customer OutreachInternal771.4%20.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

    $7,286

    cost-attributable sources only

  • Cost per valid lead

    $20.24

    total spend ÷ total attributed leads

    KPI-MKT-001

  • Cost per attributed sale

    $2,428.64

    total spend ÷ total attributed retail units

    KPI-MKT-002

  • Gross return on ad spend

    1.22

    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.

19 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 Response$96$3.01No data0.00
  • Organic Search LandingNot applicableNot applicableNot applicableNot applicable
  • Direct Site VisitNot applicableNot applicableNot applicableNot applicable
  • Paid Search Brand$1,329$24.62$443.156.66
  • Paid Search Non-Brand$2,519$37.60No data0.00
  • Paid Social Feed Campaign$458$9.75No data0.00
  • Paid Social Video CampaignNo dataNo dataNo dataNo data
  • Third-Party Marketplace Listing$1,347$16.83No data0.00
  • Third-Party Trade Valuation Portal$973$48.67No data0.00
  • Radio Spot Response$402$28.75No data0.00
  • Direct Mail Response$160$8.88No data0.00
  • 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
  • Repeat Customer OutreachNot 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 applicable1121Not applicableNot applicable$2,492Not applicableOrganic or internal — no advertising cost
Dealer Website ChatNo campaignNot applicable532Not applicableNot applicable$9,789Not applicableOrganic or internal — no advertising cost
Email Marketing ResponseNo campaignNo data60No dataNo data$0No dataLeads with no recorded spend
Email Marketing ResponseSummer Clearance 2025 - Email$96260$3.70No data$00.00Spend with no attributed sales
Organic Search LandingNo campaignNot applicable480Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Direct Site VisitNo campaignNot applicable130Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Paid Search BrandNo campaignNo data40No dataNo data$0No dataLeads with no recorded spend
Paid Search BrandLabor Day Sales Drive 2025 - Paid Search$17962$29.82$89.46$2,69915.08Measured
Paid Search BrandSummer Clearance 2025 - Paid Search$7730$25.79No data$00.00Spend with no attributed sales
Paid Search BrandModel Year Close-Out 2025 - Paid Search$401120$33.38No data$00.00Spend with no attributed sales
Paid Search BrandSummer Clearance 2025 - Paid Search$288161$17.98$287.73$6,15521.39Measured
Paid Search BrandModel Year Close-Out 2025 - Paid Search$385130$29.60No data$00.00Spend with no attributed sales
Paid Search Non-BrandNo campaignNo data90No dataNo data$0No dataLeads with no recorded spend
Paid Search Non-BrandModel Year Close-Out 2025 - Paid Search$52770$75.27No data$00.00Spend with no attributed sales
Paid Search Non-BrandModel Year Close-Out 2025 - Paid Search$1,255350$35.86No data$00.00Spend with no attributed sales
Paid Search Non-BrandLabor Day Sales Drive 2025 - Paid Search$737160$46.09No data$00.00Spend with no attributed sales
Paid Social Feed CampaignNo campaignNo data70No dataNo data$0No dataLeads with no recorded spend
Paid Social Feed CampaignCertified Used Push 2025 - Paid Social$458400$11.46No data$00.00Spend with no attributed sales
Paid Social Video CampaignNo campaignNo data210No dataNo data$0No dataLeads with no recorded spend
Third-Party Marketplace ListingNo campaignNo data160No dataNo data$0No dataLeads with no recorded spend
Third-Party Marketplace ListingSummer Clearance 2025 - Third-Party Listings$336300$11.20No data$00.00Spend with no attributed sales
Third-Party Marketplace ListingLabor Day Sales Drive 2025 - Third-Party Listings$1,011340$29.73No data$00.00Spend with no attributed sales
Third-Party Trade Valuation PortalLabor Day Sales Drive 2025 - Third-Party Listings$18710$187.31No data$00.00Spend with no attributed sales
Third-Party Trade Valuation PortalModel Year Close-Out 2025 - Third-Party Listings$786190$41.37No data$00.00Spend with no attributed sales
Radio Spot ResponseNo campaignNo data20No dataNo data$0No dataLeads with no recorded spend
Radio Spot ResponseYear-End Sales Event 2025 - Radio$402120$33.54No data$00.00Spend with no attributed sales
Direct Mail ResponseNo campaignNo data90No dataNo data$0No dataLeads with no recorded spend
Direct Mail ResponseYear-End Sales Event 2025 - Direct Mail$16090$17.76No data$00.00Spend with no attributed sales
Television Spot ResponseNo campaignNo data70No dataNo data$0No dataLeads with no recorded spend
Showroom Walk-inNo campaignNot applicable642Not applicableNot applicable$8,292Not applicableOrganic or internal — no advertising cost
Customer ReferralNo campaignNot applicable271Not applicableNot applicable$3,458Not applicableOrganic or internal — no advertising cost
Community Partner ReferralNo campaignNot applicable173Not applicableNot applicable$18,663Not applicableOrganic or internal — no advertising cost
Service Lane OpportunityNo campaignNot applicable141Not applicableNot applicable$3,877Not applicableOrganic or internal — no advertising cost
Repeat Customer OutreachNo campaignNot applicable70Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost

Vendor reconciliation

Vendor counts against the CRM

Over 2025-12, vendors reported 317 leads against 715 valid CRM leads.

  • Vendor reported317
  • Lead records received785
  • Duplicates excluded70
  • Valid leads (KPI-FUN-001)715

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.