Ad sales report ready the night before the big presentation
He needed to compare ads ordered against ads delivered.
Media
I spent two weeks trying to build this report myself.
- The problem
- I spent two weeks trying to build this report myself. The presentation is tomorrow.
- What we built
- Ordered against delivered. An Excel workbook with macros that matches the slots.
- What changed
- Report delivered before his presentation.
The problem
I spent two weeks trying to build this report myself. The presentation is tomorrow.
- He needed to compare ads ordered against ads delivered.
- He spent two weeks trying to build it himself.
- His deadline was a presentation the next day.
What we built
- Ordered against delivered. An Excel workbook with macros that matches the slots.
- Built live with him. One comparison report, built on the call.
What changed
Report delivered before his presentation.
Milestone approved.
Stuck on a report that is due tomorrow?
Send the report you rebuild by hand. We will tell you what can build itself.
Two more like this
- ConstructionHas a video, 1 minute 4 seconds
Contractor asks his CRM on WhatsApp
My CRM has years of deals. I never have time to dig through it.
- Home services
HVAC owner gets his numbers by asking
My numbers sit in the CRM and the invoices. A revenue picture means pulling it by hand.
Tools
- Excel
- VBA