Skip to main content
ARPILeads & Marketing

Leads & Marketing

All three stores · October 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.

Demand

October 2025
  • Valid leads

    851

    81 duplicates excluded

    KPI-FUN-001

  • Contact rate

    71.6%

    of valid leads

    KPI-FUN-002

  • Appointment-set rate

    35.8%

    of contacted leads, not of all leads

    KPI-FUN-003

  • Lead-to-sale

    4.5%

    of valid leads. Not the product of the steps

    KPI-FUN-006

  • Show rate

    64.6%

    appointment grain, scheduled date

    KPI-FUN-004

  • Median response

    29.6 minutes

    answered leads only

    KPI-FUN-008

  • Never answered

    98

    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 851, Contacted 609 (71.6% of valid leads), Appointment set 218 (35.8% of contacted leads), Reached showroom 148, Sold 38 (4.5% of valid leads).

  • Valid leads851

  • Contacted60971.6% of valid leads KPI-FUN-002

  • Appointment set21835.8% of contacted leads KPI-FUN-003

  • Reached showroom148

  • Sold384.5% 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 851, Contacted 609 (71.6% of valid leads), Appointment set 218 (35.8% of contacted leads), Reached showroom 148, Sold 38 (4.5% of valid leads).
StageLeadsShare of leads receivedGoverned rate
Valid leads851100.0%No governed rate at this stage
Contacted60971.6%71.6% of valid leads (KPI-FUN-002)
Appointment set21825.6%35.8% of contacted leads (KPI-FUN-003)
Reached showroom14817.4%No governed rate at this stage
Sold384.5%4.5% 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.

309 scheduled appointments, 66 cancelled in advance, 243 eligible to show, 157 shown, 32 shown and sold.

  • Scheduled appointments309
  • Cancelled in advance66

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

  • Eligible to show243

    scheduled less advance cancellations

  • Shown157

    64.6% of eligible appointments KPI-FUN-004

  • Shown and sold32

    20.4% of 157 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 appointments309Count only
Cancelled in advance6621.4% of scheduled — removed from the show-rate denominator
Eligible to show243scheduled less advance cancellations
Shown15764.6% of eligible appointments (KPI-FUN-004)
Shown and sold3220.4% of 157 visits on the show date (KPI-FUN-005)

Response

Lead grain · lead-creation date

Time to first response

Median first response 29.6 minutes across 753 answered leads, with 98 leads carrying no recorded response.

  • Median

    29.6 minutes

    the headline: the distribution is heavily skewed

    KPI-FUN-008

  • Mean

    73.5 minutes

    moved by the tail

    KPI-FUN-007

  • 90th percentile

    167.1 minutes

    the tail the median cannot see

  • Under 5 minutes749.8%
  • 5-15 minutes16822.3%
  • 15-60 minutes29038.5%
  • Over 60 minutes22129.3%
  • Never answered98

    A share of 851 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 minutes749.8%
5-15 minutes16822.3%
15-60 minutes29038.5%
Over 60 minutes22129.3%
No recorded response98Excluded from both KPIs

Where the cohort stopped

Mutually exclusive

Furthest stage reached

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

  • Did not reach contact242
  • Did not reach appointment391
  • Did not reach showroom70
  • Showed without attributed sale118
  • Showed and bought30

Each lead is counted once, at the furthest stage it reached, and the counts sum to 851 valid leads. They say where progression stopped, never why: no communication or activity detail exists in this project to carry a reason. Separately, 8 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 Form12473.4%35.2%3.2%
  • Dealer Website Chat4887.5%40.5%2.1%
  • Email Marketing Response2875.0%23.8%0.0%
  • Organic Search Landing3482.4%42.9%2.9%
  • Direct Site Visit2673.1%21.1%0.0%
  • Paid Search Brand6567.7%43.2%6.2%
  • Paid Search Non-Brand7584.0%23.8%1.3%
  • Paid Social Feed Campaign4143.9%16.7%2.4%
  • Paid Social Video Campaign2142.9%0.0%0.0%
  • Third-Party Marketplace Listing11952.9%25.4%0.0%
  • Third-Party Trade Valuation Portal4654.3%16.0%2.2%
  • Radio Spot Response1877.8%28.6%0.0%
  • Direct Mail Response1963.2%58.3%5.3%
  • Television Spot Response2259.1%15.4%0.0%
  • Showroom Walk-in7893.6%46.6%14.1%
  • Customer Referral3387.9%65.5%27.3%
  • Community Partner Referral1883.3%33.3%5.6%
  • Service Lane Opportunity2584.0%61.9%8.0%
  • Repeat Customer Outreach1181.8%77.8%9.1%

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 Digital12473.4%35.2%3.2%4
Dealer Website ChatOwned Digital4887.5%40.5%2.1%1
Email Marketing ResponseOwned Digital2875.0%23.8%0.0%0
Organic Search LandingOrganic Web3482.4%42.9%2.9%1
Direct Site VisitOrganic Web2673.1%21.1%0.0%0
Paid Search BrandPaid Search6567.7%43.2%6.2%4
Paid Search Non-BrandPaid Search7584.0%23.8%1.3%1
Paid Social Feed CampaignPaid Social4143.9%16.7%2.4%1
Paid Social Video CampaignPaid Social2142.9%0.0%0.0%0
Third-Party Marketplace ListingThird Party11952.9%25.4%0.0%0
Third-Party Trade Valuation PortalThird Party4654.3%16.0%2.2%1
Radio Spot ResponseTraditional Media1877.8%28.6%0.0%0
Direct Mail ResponseTraditional Media1963.2%58.3%5.3%1
Television Spot ResponseTraditional Media2259.1%15.4%0.0%0
Showroom Walk-inWalk-in7893.6%46.6%14.1%11
Customer ReferralReferral3387.9%65.5%27.3%9
Community Partner ReferralReferral1883.3%33.3%5.6%1
Service Lane OpportunityInternal2584.0%61.9%8.0%2
Repeat Customer OutreachInternal1181.8%77.8%9.1%1

Marketing economics

2025-10

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

    $10,042

    cost-attributable sources only

  • Cost per valid lead

    $22.12

    total spend ÷ total attributed leads

    KPI-MKT-001

  • Cost per attributed sale

    $1,255.23

    total spend ÷ total attributed retail units

    KPI-MKT-002

  • Gross return on ad spend

    2.39

    attributed gross ÷ spend. Contribution, not profit

    KPI-MKT-003

Cost and return, by source

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

19 lead sources over 2025-10, 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$220$7.87No data0.00
  • Organic Search LandingNot applicableNot applicableNot applicableNot applicable
  • Direct Site VisitNot applicableNot applicableNot applicableNot applicable
  • Paid Search Brand$1,474$22.67$368.438.97
  • Paid Search Non-Brand$3,476$46.34$3,475.791.08
  • Paid Social Feed Campaign$534$13.01$533.592.81
  • Paid Social Video CampaignNo dataNo dataNo dataNo data
  • Third-Party Marketplace Listing$1,391$11.69No data0.00
  • Third-Party Trade Valuation Portal$1,130$24.57$1,130.441.98
  • Radio Spot Response$752$41.77No data0.00
  • Direct Mail Response$845$44.45$844.603.86
  • Television Spot Response$221$10.03No data0.00
  • 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 applicable1244Not applicableNot applicable$15,524Not applicableOrganic or internal — no advertising cost
Dealer Website ChatNo campaignNot applicable481Not applicableNot applicable$3,370Not applicableOrganic or internal — no advertising cost
Email Marketing ResponseNo campaignNo data50No dataNo data$0No dataLeads with no recorded spend
Email Marketing ResponseSummer Clearance 2025 - Email$10670$15.12No data$00.00Spend with no attributed sales
Email Marketing ResponseService Retention Drive 2025 - Email$114160$7.15No data$00.00Spend with no attributed sales
Organic Search LandingNo campaignNot applicable341Not applicableNot applicable$1,063Not applicableOrganic or internal — no advertising cost
Direct Site VisitNo campaignNot applicable260Not applicableNot applicable$0Not applicableOrganic or internal — no advertising cost
Paid Search BrandNo campaignNo data61No dataNo data$1,185No dataLeads with no recorded spend
Paid Search BrandLabor Day Sales Drive 2025 - Paid Search$18371$26.09$182.60$6,43735.25Measured
Paid Search BrandSummer Clearance 2025 - Paid Search$11950$23.84No data$00.00Spend with no attributed sales
Paid Search BrandModel Year Close-Out 2025 - Paid Search$429121$35.73$428.80$1,3293.10Measured
Paid Search BrandSummer Clearance 2025 - Paid Search$267120$22.25No data$00.00Spend with no attributed sales
Paid Search BrandModel Year Close-Out 2025 - Paid Search$476231$20.70$476.13$4,2738.97Measured
Paid Search Non-BrandNo campaignNo data80No dataNo data$0No dataLeads with no recorded spend
Paid Search Non-BrandModel Year Close-Out 2025 - Paid Search$66481$83.01$664.07$3,7425.64Measured
Paid Search Non-BrandModel Year Close-Out 2025 - Paid Search$1,971440$44.79No data$00.00Spend with no attributed sales
Paid Search Non-BrandLabor Day Sales Drive 2025 - Paid Search$841150$56.08No data$00.00Spend with no attributed sales
Paid Social Feed CampaignNo campaignNo data21No dataNo data$1,501No dataLeads with no recorded spend
Paid Social Feed CampaignCertified Used Push 2025 - Paid Social$534390$13.68No 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 data360No dataNo data$0No dataLeads with no recorded spend
Third-Party Marketplace ListingSummer Clearance 2025 - Third-Party Listings$308290$10.61No data$00.00Spend with no attributed sales
Third-Party Marketplace ListingLabor Day Sales Drive 2025 - Third-Party Listings$1,083540$20.06No data$00.00Spend with no attributed sales
Third-Party Trade Valuation PortalNo campaignNo data50No dataNo data$0No dataLeads with no recorded spend
Third-Party Trade Valuation PortalLabor Day Sales Drive 2025 - Third-Party Listings$250140$17.87No data$00.00Spend with no attributed sales
Third-Party Trade Valuation PortalModel Year Close-Out 2025 - Third-Party Listings$880271$32.60$880.29$2,2432.55Measured
Radio Spot ResponseNo campaignNo data40No dataNo data$0No dataLeads with no recorded spend
Radio Spot ResponseYear-End Sales Event 2025 - Radio$30940$77.13No data$00.00Spend with no attributed sales
Radio Spot ResponseModel Year Close-Out 2025 - Radio$443100$44.33No data$00.00Spend with no attributed sales
Direct Mail ResponseNo campaignNo data10No dataNo data$0No dataLeads with no recorded spend
Direct Mail ResponseService Retention Drive 2025 - Direct Mail$405101$40.49$404.86$3,2568.04Measured
Direct Mail ResponseCertified Used Push 2025 - Direct Mail$44080$54.97No data$00.00Spend with no attributed sales
Television Spot ResponseNo campaignNo data150No dataNo data$0No dataLeads with no recorded spend
Television Spot ResponseYear-End Sales Event 2025 - Television$22170$31.52No data$00.00Spend with no attributed sales
Showroom Walk-inNo campaignNot applicable7811Not applicableNot applicable$58,805Not applicableOrganic or internal — no advertising cost
Customer ReferralNo campaignNot applicable339Not applicableNot applicable$15,673Not applicableOrganic or internal — no advertising cost
Community Partner ReferralNo campaignNot applicable181Not applicableNot applicable$3,686Not applicableOrganic or internal — no advertising cost
Service Lane OpportunityNo campaignNot applicable252Not applicableNot applicable$5,319Not applicableOrganic or internal — no advertising cost
Repeat Customer OutreachNo campaignNot applicable111Not applicableNot applicable$4,200Not applicableOrganic or internal — no advertising cost

Vendor reconciliation

Vendor counts against the CRM

Over 2025-10, vendors reported 397 leads against 851 valid CRM leads.

  • Vendor reported397
  • Lead records received932
  • Duplicates excluded81
  • Valid leads (KPI-FUN-001)851

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.