Leads & Marketing
Granite Pre-Owned · December 2025
Granite Auto Group is fictional. Operating figures are synthetic.· data and methodology
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.
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.
Filters and controls2 applied
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
Valid leads
23123 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 minutesanswered leads only
KPI-FUN-008
Never answered
27excluded 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-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
| Stage | Leads | Share of leads received | Governed rate |
|---|---|---|---|
| Valid leads | 231 | 100.0% | No governed rate at this stage |
| Contacted | 168 | 72.7% | 72.7% of valid leads (KPI-FUN-002) |
| Appointment set | 56 | 24.2% | 33.3% of contacted leads (KPI-FUN-003) |
| Reached showroom | 37 | 16.0% | No governed rate at this stage |
| Sold | 1 | 0.4% | 0.4% of valid leads (KPI-FUN-006) |
Appointments
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
| Stage | Appointments | Governed rate |
|---|---|---|
| Scheduled appointments | 95 | Count only |
| Cancelled in advance | 20 | 21.1% of scheduled — removed from the show-rate denominator |
| Eligible to show | 75 | scheduled less advance cancellations |
| Shown | 50 | 66.7% of eligible appointments (KPI-FUN-004) |
| Shown and sold | 1 | 2.0% of 50 visits on the show date (KPI-FUN-005) |
Response
Time to first response
Median first response 27.5 minutes across 204 answered leads, with 27 leads carrying no recorded response.
Median
27.5 minutesthe headline: the distribution is heavily skewed
KPI-FUN-008
Mean
73.4 minutesmoved by the tail
KPI-FUN-007
90th percentile
159.4 minutesthe 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
| Band | Answered leads | Share of answered |
|---|---|---|
| Under 5 minutes | 24 | 11.8% |
| 5-15 minutes | 49 | 24.0% |
| 15-60 minutes | 71 | 34.8% |
| Over 60 minutes | 60 | 29.4% |
| No recorded response | 27 | Excluded from both KPIs |
Where the cohort stopped
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
| Source | Category | Valid leads | Contact | Appt set | Lead-to-sale | Sold |
|---|---|---|---|---|---|---|
| Dealer Website Form | Owned Digital | 35 | 77.1% | 40.7% | 0.0% | 0 |
| Dealer Website Chat | Owned Digital | 11 | 81.8% | 44.4% | 0.0% | 0 |
| Email Marketing Response | Owned Digital | 4 | 100.0% | 50.0% | 0.0% | 0 |
| Organic Search Landing | Organic Web | 15 | 73.3% | 18.2% | 0.0% | 0 |
| Direct Site Visit | Organic Web | 4 | 50.0% | 0.0% | 0.0% | 0 |
| Paid Search Brand | Paid Search | 19 | 84.2% | 31.3% | 0.0% | 0 |
| Paid Search Non-Brand | Paid Search | 27 | 70.4% | 26.3% | 0.0% | 0 |
| Paid Social Feed Campaign | Paid Social | 7 | 57.1% | 25.0% | 0.0% | 0 |
| Paid Social Video Campaign | Paid Social | 7 | 14.3% | 0.0% | 0.0% | 0 |
| Third-Party Marketplace Listing | Third Party | 39 | 74.4% | 31.0% | 0.0% | 0 |
| Third-Party Trade Valuation Portal | Third Party | 11 | 72.7% | 37.5% | 0.0% | 0 |
| Radio Spot Response | Traditional Media | 7 | 57.1% | 25.0% | 0.0% | 0 |
| Direct Mail Response | Traditional Media | 5 | 60.0% | 66.7% | 0.0% | 0 |
| Television Spot Response | Traditional Media | 6 | 50.0% | 33.3% | 0.0% | 0 |
| Showroom Walk-in | Walk-in | 16 | 87.5% | 35.7% | 0.0% | 0 |
| Customer Referral | Referral | 9 | 88.9% | 37.5% | 11.1% | 1 |
| Community Partner Referral | Referral | 4 | 50.0% | 0.0% | 0.0% | 0 |
| Service Lane Opportunity | Internal | 5 | 80.0% | 50.0% | 0.0% | 0 |
Marketing economics
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,221cost-attributable sources only
Cost per valid lead
$9.25total spend ÷ total attributed leads
KPI-MKT-001
Cost per attributed sale
No datatotal spend ÷ total attributed retail units
KPI-MKT-002
Gross return on ad spend
0.00attributed 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
| Source | Campaign | Spend | Leads | Sales | Cost/lead | Cost/sale | Attributed gross | Gross ROAS | Cost state |
|---|---|---|---|---|---|---|---|---|---|
| Dealer Website Form | No campaign | Not applicable | 35 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic or internal — no advertising cost |
| Dealer Website Chat | No campaign | Not applicable | 11 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic or internal — no advertising cost |
| Email Marketing Response | No campaign | No data | 4 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Organic Search Landing | No campaign | Not applicable | 15 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic or internal — no advertising cost |
| Direct Site Visit | No campaign | Not applicable | 4 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic or internal — no advertising cost |
| Paid Search Brand | No campaign | No data | 0 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Paid Search Brand | Summer Clearance 2025 - Paid Search | $50 | 3 | 0 | $16.70 | No data | $0 | 0.00 | Spend with no attributed sales |
| Paid Search Brand | Model Year Close-Out 2025 - Paid Search | $121 | 16 | 0 | $7.59 | No data | $0 | 0.00 | Spend with no attributed sales |
| Paid Search Non-Brand | No campaign | No data | 3 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Paid Search Non-Brand | Model Year Close-Out 2025 - Paid Search | $501 | 16 | 0 | $31.32 | No data | $0 | 0.00 | Spend with no attributed sales |
| Paid Search Non-Brand | Labor Day Sales Drive 2025 - Paid Search | $183 | 8 | 0 | $22.93 | No data | $0 | 0.00 | Spend with no attributed sales |
| Paid Social Feed Campaign | No campaign | No data | 1 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Paid Social Feed Campaign | Certified Used Push 2025 - Paid Social | $137 | 6 | 0 | $22.84 | No data | $0 | 0.00 | Spend with no attributed sales |
| Paid Social Video Campaign | No campaign | No data | 7 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Third-Party Marketplace Listing | No campaign | No data | 39 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Third-Party Trade Valuation Portal | No campaign | No data | 1 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Third-Party Trade Valuation Portal | Labor Day Sales Drive 2025 - Third-Party Listings | $88 | 10 | 0 | $8.84 | No data | $0 | 0.00 | Spend with no attributed sales |
| Radio Spot Response | Year-End Sales Event 2025 - Radio | $139 | 7 | 0 | $19.86 | No data | $0 | 0.00 | Spend with no attributed sales |
| Direct Mail Response | No campaign | No data | 5 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Television Spot Response | No campaign | No data | 6 | 0 | No data | No data | $0 | No data | Leads with no recorded spend |
| Showroom Walk-in | No campaign | Not applicable | 16 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic or internal — no advertising cost |
| Customer Referral | No campaign | Not applicable | 9 | 1 | Not applicable | Not applicable | $1,690 | Not applicable | Organic or internal — no advertising cost |
| Community Partner Referral | No campaign | Not applicable | 4 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic or internal — no advertising cost |
| Service Lane Opportunity | No campaign | Not applicable | 5 | 0 | Not applicable | Not applicable | $0 | Not applicable | Organic 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.