Real Problems, Real Solutions
How Chicagoland businesses are saving time and money with custom AI tools
Service Business - Field Operations
The On-Site Estimating Tool That Saved 40 Minutes Per Job
The Problem
A renovation company with 12 field crews was losing 30-45 minutes on every potential job. Their process: crew visits the site, takes measurements and photos, drives back to the office, builds an estimate in Excel, emails it to the customer. By the time quotes went out, competitors had often already closed the deal.
The owner knew this was killing their close rate but couldn't find an off-the-shelf solution that matched their specific pricing structure — different multipliers for materials, labor, and studio work, with variations based on job complexity.
The Approach
I spent half a day shadowing their estimators, understanding their pricing logic and the Excel gymnastics they performed for every quote. Then I built a mobile-friendly web tool that lives on their phones and tablets. Select the service type, enter measurements, toggle options — the tool calculates everything using their exact pricing formulas, generates multiple quote variations, and produces a professional PDF right there on site.
The data syncs to Airtable so the office has full visibility, but the crews never have to touch a spreadsheet or drive back for anything.
Result: Estimates that took 30-45 minutes now take under 5. Crews close more jobs on the spot. The owner estimates they're winning 15-20% more bids simply because they're first to respond with professional quotes.
Digital Agency - Content Production
The Page Factory That Turned 8 Hours Into 45 Minutes
The Problem
A digital marketing agency had a client with 50 location pages on their website — 25 with broken formatting from a bad migration, and 25 more that needed to be created from scratch. Each page required specific SEO optimization, local content, proper schema markup, and consistent formatting.
Doing this manually meant 6-8 hours of mind-numbing copy-paste work. The kind of task that makes talented developers want to quit.
The Approach
I built a Python script that reads location data from a spreadsheet, generates unique content for each location using AI (pulling in real local data like nearby landmarks and demographic info), applies the agency's exact template structure, fixes all the broken code patterns, and optimizes everything for local SEO with proper schema markup.
The first version cut the work from 8 hours to 2. After refining it based on their feedback, we got it down to 45 minutes for all 50 pages.
Result: The agency now uses variations of this tool for every client with multiple locations. They've saved hundreds of hours and can take on more location-based SEO projects without adding headcount. One developer said it was "the best $3,000 the agency ever spent."
Tax Preparation Company - Marketing Operations
The Billboard Map That Gave Marketing Their Fridays Back
The Problem
A tax preparation company with 12 offices was spending $200K+ annually on billboard advertising across the Chicago metro area. The marketing team had no way to visualize where their billboards were in relation to offices, competitors, or high-income neighborhoods. Everything lived in separate spreadsheets — billboard locations in one, office addresses in another, campaign performance in a third.
Creating reports for leadership meant hours of manual work every week, usually eating up most of Friday afternoon.
The Approach
I built an interactive map that pulls data from their existing Google Sheets (so they didn't have to change their workflow). The system geocodes all office addresses, extracts billboard coordinates from vendor spec sheets, and plots everything on an interactive map with filters for campaign, date range, and spend levels.
Leadership can now see at a glance which billboards are near which offices, identify gaps in coverage, and track spending by region. The dashboard updates automatically whenever they update their spreadsheets.
Result: Friday afternoon report generation went from 3-4 hours to zero — the dashboard is always current. The owner called it "the clearest view of our outdoor advertising we've ever had." They've already identified $35K in redundant billboard spend they can reallocate.
Service Business - Lead Management
The Commission Tracker That Eliminated 12 Hours of Manual Call Review
The Problem
A home services company was paying 10% commission on qualified leads but had no efficient way to verify which incoming calls actually qualified. The owner was spending 10-12 hours every week listening to recorded calls, checking durations, determining if the caller was a real prospect or just a price shopper, and manually tracking everything in spreadsheets.
The business used two different call tracking platforms (CallRail and CallScaler), which made the manual review even messier. Salespeople were constantly asking "Did that one count?" and the owner was drowning in busywork that had nothing to do with growing the business.
The Approach
I built a system that connects to both call tracking platforms via API, automatically transcribes every call using AI, and qualifies leads based on duration, content, and conversation quality. The system analyzes the transcript to determine if it's a genuine prospect (asking about services, requesting quotes, booking appointments) versus spam or wrong numbers.
Qualified leads get logged to Google Sheets with full transcripts, caller info, and commission amounts. The system even manages SMS follow-up communication and tracks payment status. Everything the owner was doing manually now happens automatically within minutes of the call ending.
Result: The owner went from 12 hours of weekly call review to zero. Commission disputes dropped to nearly nothing because everyone can see the full transcript and qualification criteria. The business now processes 3x more leads without adding admin overhead, and salespeople get paid faster because the system auto-generates payment reports.
Digital Agency - Content Marketing
The SEO Content Engine That Publishes 40 Blog Posts Per Week
The Problem
A digital marketing agency knew that consistent blogging drove organic traffic for their clients, but creating quality SEO content at scale was impossible. Hiring enough writers was too expensive, and AI-generated content on its own was generic and didn't rank. They needed a way to publish 30-40 optimized blog posts per week across multiple client sites without sacrificing quality.
Their manual process — keyword research, content brief creation, writing, image creation, formatting, publishing, and Google Business Profile posting — took 2-3 hours per article. At that rate, they'd need a team of 10 writers working full-time.
The Approach
I built an automated content pipeline that starts with Google's "People Also Ask" data to find real questions their target audience is searching for. The system uses AI to generate well-structured blog posts that actually answer those questions, creates custom featured images with DALL-E, optimizes everything for SEO with proper schema markup and internal linking, publishes directly to WordPress, and posts summaries to Google Business Profile — all on a drip-feed schedule they control.
The content isn't generic because it's trained on each client's brand voice and pulls in real data about their specific services and locations. The agency reviews and approves everything in batches before it goes live.
Result: The agency now publishes 40+ SEO-optimized blog posts per week across their client portfolio without hiring additional writers. Organic traffic for their clients increased 60-120% within 4 months. One account manager said, "This tool is worth more than our entire content team's salary — and we got to keep the team and just make them more effective."