Eliminated a $30,000-Per-Year Manual Role for a Chicagoland Media Foundation
"A human had to be the bridge between every system."
Client: A media company and family foundation operating an industry magazine focused on non-profit content
Industry / size: Publishing / nonprofit media
Over a 12-year engagement with a Chicagoland media foundation, we built a custom editorial workflow that eliminated the equivalent of a full-time role — turning manual chaos into a system that ran itself.
The situation: The owner had a vision that broke the traditional advertising model: instead of selling ads, non-profits would submit their own stories and the magazine would publish, amplify, and drive traffic back to them. The CRM they used was built for standard print/digital magazine operations, not for managing hundreds of non-profit submissions, custom editorial workflows, grant tracking, and traffic attribution. The software couldn't do what the business needed out of the box.
The problem: Non-profits submitted stories through a basic web form that captured everything as one block of text with attachments. An editorial trafficker spent roughly 20 hours per week manually reading submissions, classifying them, routing them to the right editor, saving attachments to the right folders, and updating the CRM. Stories got lost. Deadlines slipped. Sales couldn't see where any given article stood in production. The form tool and the CRM didn't talk to each other, so a human had to be the bridge between every system.
How We Helped
What We Built
- Custom structured intake forms replacing the one-blob submission model
- Automated routing of every submission directly into the CRM, attached to the correct client record
- Automated file handoff to the right Google Drive folders
- Automated reminder emails for stories with upcoming deadlines
- A custom URL-tracking system so every published article had a unique trackable link, allowing both the magazine and the originating non-profit to measure shares and traffic back to the CRM record
- Automated publication notifications — when an editor marked a story live, the system pulled the production contacts from the CRM and sent a custom email with social handles, sharing instructions, and the trackable link
- A grant-tracking workflow that monitored when non-profits met their objectives and automatically notified accounting to release payouts
The Results
- Eliminated approximately $30,000/year in manual editorial trafficking work (a full 20 hour/week role)
- Successfully processed 150+ non-profit submissions for the 2025 philanthropy awards alone, plus 5-10 additional editorial submissions every month for the regular calendar
- Site sustained 58,000-70,000 users and roughly 64,000 monthly page views — driven in part by the trackable URL system that incentivized non-profits to share their published stories
- The team lost staff over the years and still did more work with fewer people because the systems absorbed the manual workload
- Sales had full visibility into article status without asking the editor
- Grant payouts became automatic and audit-friendly
- The system kept evolving for 12 years as the business changed
The Deeper Lesson
Late in the engagement, another consultant proposed migrating the entire operation to a non-profit CRM at six-figure implementation cost, abandoning a system that had been customized over years to fit the business. We had spent a decade making the existing CRM do exactly what the business needed. The right answer is rarely rip and replace. It's usually fit the tool to how the business actually works.
Are your systems working as hard as you ?
If any of this sounds familiar, let's talk. A free audit identifies your biggest hidden costs and quickest wins.