Before you paste: delete the customer name, phone, email and address columns before you upload the file. Keep the stock number or RO number so you can find the row.
The prompt
You're an analyst at a car dealership. I've attached a report exported from our [DMS / CRM]. It shows [what the report is, e.g. "open ROs older than 7 days"].
First tell me what you think each column means, and ask me about any you're unsure of. Then find the rows that stand out: outliers, duplicates, missing values and anything that breaks the pattern of the rest. For each one, give the row, why it stands out and the math behind it.
Don't round, and don't guess at any number that isn't in the file. End with the rows I should look at first and what a person needs to check on each.
Make it yours
Run it on the same report every week and ask it to compare against last week's file. Once you trust what it flags, save the prompt with the report name in the title so anyone can run it.
Every starter prompt has the same five parts: role, context, task, rules and format. Learn to write your own.
More starter prompts
Meeting notes to action list Leadership & Ops · Write
Read a vendor contract before you sign Leadership & Ops · Analyze
When you don't know what to ask Any Department · Plan
General information, not legal advice. Check every fact an AI tool gives you before it goes to a customer.
