WeavrCRMWhy Sent Date, Not Created Date, Defines Quote Age
Age should be counted from the day the customer received the quote, not the day you built it. A quote you drafted Monday and sent Friday is only one day old from the customer's perspective, but five days old if you use created date. Using created date makes quotes look staler than they are and can push you to follow up before the customer has even had a fair look.
The practical rule: start the clock when you hit send or hand over the written estimate. If your process uses a CRM like Weavr where quotes move through a workflow from draft to sent, only count quotes that have left your side of the conversation. Drafts have no age yet because no one is deciding anything.
Related resource: Estimate Detailing Customer Lifetime Value With Conservative Inputs
Which Quotes Belong in the Report
Include only quotes in an open, sent state. Exclude drafts you have not delivered, quotes the customer has already approved and booked, and quotes you have already marked declined or withdrawn. Approved quotes belong in your booking pipeline, not your follow-up queue. Declined quotes should be closed so they do not inflate your apparent open count.
This distinction matters because your report's purpose is to guide action, not to measure conversion rate. Conversion rate is a separate calculation using a denominator of all sent quotes over a defined period. The aging report is an operational tool for right now, not a historical metric.
Related resource: Calculate Your Detailing Repeat Booking Rate
Setting Up Time Buckets That Mean Something
Buckets organize quotes by urgency without requiring you to evaluate each one individually. A three-bucket structure works for most solo operators or small teams: 0–3 days old (fresh, no action needed yet), 4–7 days old (ready for one polite follow-up), and 8 or more days old (stale, decide whether to re-engage or close).
The cutoffs you choose should reflect how long your typical customer takes to decide. A $120 express detail might convert in two days or not at all. A $900 paint correction job might need a week of consideration. If you offer both, consider separating them into different rows rather than mixing them in the same bucket logic, or at least flag high-value quotes in the stale bucket for a personal call instead of a text.
| Bucket | Days Since Sent | Recommended Action | Notes |
|---|---|---|---|
| Fresh | 0–3 | No outreach yet | Give the customer space to read and think |
| Follow-up due | 4–7 | One polite message or call | Reference the specific service quoted |
| Stale | 8–14 | Personal outreach or close it | High-value jobs get a call; lower-value get a final text |
| Archive | 15+ | Mark declined and close | Keeping these open distorts your open quote count |
What Each Row in the Report Needs
A useful aging report row contains: customer name, vehicle or service quoted, dollar amount, date sent, days since sent, bucket, assigned owner if you have a team, and a next-action note. The next-action column is what separates a report you actually use from a spreadsheet you glance at once.
The owner column becomes important the moment you have more than one person handling customer inquiries. If both you and a part-time helper send quotes, you need to know who is responsible for following up on each one. Without an owner column you will either both follow up (awkward) or neither of you will (costly).
QUOTE AGING REPORT — Week of: ___________
Customer Name | Vehicle / Service | Quote Amount | Date Sent | Days Open | Bucket | Owner | Next Action
-------------|-------------------|--------------|-----------|-----------|--------|-------|------------
| | | | | | |
| | | | | | |
| | | | | | |
Total open quotes: ___
Fresh (0–3 days): ___
Follow-up due (4–7 days): ___
Stale (8–14 days): ___
Archive now (15+ days): ___
High-value stale quotes (list separately for personal outreach):
-
-
Quotes to close this week (no response after final outreach):
-
-Hypothetical Worked Example: Marcus's Eight Open Quotes
Imagine Marcus runs a solo mobile detailing operation and opens his aging report on a Thursday. He has eight open sent quotes. Two are from Tuesday this week, sitting in the fresh bucket. Three are from last Friday, now six days old and in the follow-up-due bucket. Two are from twelve days ago in the stale bucket, including one for a $750 paint correction. One is from nineteen days ago with no reply ever received.
Marcus's action plan from that one review: ignore the two fresh quotes, send a brief personal text to each of the three six-day-old customers referencing their specific vehicle and service, call the $750 paint correction customer directly rather than texting, send a final message to the other stale quote, and close the nineteen-day-old quote as archived. In under twenty minutes he has a clear plan. Without the report, he likely either ignores all of them or spends the same time wondering where to start.
Where the Report Fails and How to Avoid It
The report breaks down if you do not keep quote statuses current. If approved quotes stay marked as open, your follow-up bucket fills with customers you have already booked, wasting time and making you look disorganized when you reach out unnecessarily. Build a habit of updating quote status the same day a customer approves or declines.
A second failure mode is treating all stale quotes identically. A $95 basic wash that went cold at day ten is probably not worth a phone call. A $600 ceramic coating inquiry that went quiet at day ten absolutely is. The bucket tells you timing; you still have to apply judgment about method and effort. The report guides priority, it does not replace your knowledge of the customer.
Reviewing the Report on a Fixed Schedule
Running the report once a week on the same day, such as every Monday morning before you book anything new, keeps follow-up from falling through the cracks. It takes less than fifteen minutes once the format is set up. If you review it less often than weekly, quotes will age past actionable without you noticing.
Weavr's quote and lead workflow gives you a place to track quote status and linked contacts, and you can use scheduled tasks tied to a quote to flag follow-up timing. That structure supports the weekly review habit without requiring you to maintain a separate spreadsheet if your quote volume is low enough to manage inside the platform.
Related resource: Detailing Business KPIs: A Small Set Worth Reviewing
Connecting Quote Aging to Broader Business Decisions
Over several weeks, your aging report tells you more than just who to call today. If you consistently have a large stale bucket, your pricing, response time, or service clarity may be the issue rather than follow-up frequency. If fresh quotes convert quickly without any follow-up, you may be able to simplify your outreach process.
The aging report is not a conversion rate tool, but it feeds into one. When you close out stale quotes as declined, you create cleaner data for calculating what share of sent quotes actually become jobs. That separation matters: a quote aging report answers who needs attention now, while a conversion rate answers whether your quoting process is working over time. Both questions are worth asking, but they require different data and different cadences.
The practical takeaway
Build your aging report from sent date only, exclude drafts and approved quotes, assign a bucket and a next action to every open row, and review it every week on a fixed day. That habit alone will surface follow-up you would otherwise miss.
Explore the relevant WeavrCRM workflow · Review integrations and requirements