Lead_Master.csv
48 leads with source, intent, vehicle, consent, timing, and current status — plus trade and finance interest.
A Honda store has 48 internet leads sitting in the CRM. Some are open, some got closed out. A few are high-intent buyers who got a form letter. A few are duplicates of each other. At least one has asked to be left alone. Some had appointments that never happened.
Nobody has told you which is which. That's the point.
You have 48 leads, 121 activity records, and 18 cars on the ground.
48 leads with source, intent, vehicle, consent, timing, and current status — plus trade and finance interest.
121 inbound and outbound records. This is where you find out how the store actually responded.
18 new and used units the leads are asking about. Price, days in stock, color, key features.
Consent status is real. If someone opted out, they're out. No exceptions, no clever workarounds.
Same 48 leads for every team. Judges aren't looking for one correct ranking - they're looking for a ranking you can defend.
No invented facts. If a payment, a rate, or an incentive isn't in your files, it doesn't exist.
Public tools only. No dealer-only platforms, no paid automotive products.
Who deserves attention first, and what in the data says so?
What went wrong across the whole set - not one lead, the pattern?
If you handed this process to a BDC manager who wasn't in the room, could they run it?