The AM flagged that our client’s October 2026 revenue looked far below October 2025: 104 closed-won deals and about $1.3M last year, versus 8 RCFX deals and ~$300K this year. The client was not worried at this point, so we didn’t want to create a fire where there wasn’t one. I used our internal huddle to find out whether the gap was real.
It wasn’t a performance problem. It was three data issues:
The client’s reports for current-month data were mostly right. The year-over-year comparison was what was off, and that was our side to fix. We didn’t want to wait to loop in the client in the event they started digging deeper into the reports and could flag the discrepancies before we addressed them directly.
Now, the real issue -> how do I effectively communicate this to the client without causing panic or creating more work for them?
The approach
I brought the client an issue we had already found and were already fixing, and I asked for only one small thing in return. The message conveyed “here is what we found, here is what we’ve done about it, and here is the one thing that helps.” That order is what kept it calm.
How I did it
How the message was built
Each choice in the email was made to lower the temperature while staying accurate.
The email for the client’s sales team
I wrote the email Tim could forward as-is. That took the work off his plate, and it let me speak at the sales team’s level instead of his. This is the version I included:
Subject: Action needed: CRM status updates by the 5th of each month
Hi team,
To make sure our marketing reporting reflects the work you’re doing, please follow these two steps in the CRM moving forward:
Once a lead has a Deal ID, change its status from “New Lead” to “Open” or “Working Sales Process.” Leave a record as “New Lead” only if it is truly new and has no Deal ID yet, as records in the “New Lead” status don’t show up in our pipeline reporting.
Make sure all sales for the prior month are entered and updated by the 5th of every month. That’s when we pull data for reporting, and anything not updated by then gets left out.
These updates will help us show the full impact of your sales efforts.Thank you,
Tim
Why it works:
The achievement is not the email itself. A client who wasn’t asking questions yet was about to see an October comparison that looked like a drop of about $1M, and the cause was our data, not their sales. Instead of waiting for that question, we found the cause first, fixed our side, and fixed the upload timing so it doesn’t repeat.
It also surfaced a gap the client didn’t know about: paid search pipeline could never be reported while records sat in a certain CRM status. The client now owns that fix, and offered on his own to reinforce it with dealers in his next marketing communication. The client responded with thanks and gratitude, not concern!
Here’s the full email I sent to our POC:
Hi Tim,
I hope your week is going well!Alicia raised a flag on the October year-over-year numbers, so I took a closer look at the data behind them.
Good news: it’s all very fixable, and the only thing we need from you is a quick note to your sales team.
Here’s what we found:
- Four October closed-won deals were in your CRM but hadn’t been updated yet when our monthly upload ran. I’ve re-uploaded them, and we can regenerate the October reports once the cleanup is done.
- The October 2025 comparison was inflated by some duplicate records from when we switched our uploads from lead ID to deal ID at the end of last year. Our developers are removing them and will reprocess 2025 so everything lines up.
- Note: You may see slightly different year-over-year numbers starting in November, but the current-month data is now accurate
- Paid search pipeline reporting is empty right now because most records are still marked “New Lead” in the CRM and never move to an ‘open’ project sales status.
Here’s where we could use your help:
- Could you pass along the email below to your sales team? It explains how to update statuses so your pipeline shows up in reporting.
- We’ve moved our monthly upload date to the 5th, so sales data must be updated in the CRM by then to be included in our monthly reports.
—
Subject: Action needed: CRM status updates by the 5th of each monthHi team,
To make sure our marketing reporting reflects the work you’re doing, please follow these two steps in the CRM moving forward:
Once a lead has a Deal ID, change its status from “New Lead” to “Open” or “Working Sales Process.” Leave a record as “New Lead” only if it is truly new and has no Deal ID yet, as records in the “New Lead” status don’t show up in our pipeline reporting.
Make sure all sales for the prior month are entered and updated by the 5th of every month. That’s when we pull data for reporting, and anything not updated by then gets left out.
These updates will help us show the full impact of your sales efforts.Thank you,
Tim—
Please let me know if you have any questions!
Macenzi
And this was the client’s response:
That’s great news, thanks Macenzi!