Skip to content

Real client

Marketing agency's own AI app, untangled onto one database

An agency that serves law firms built its own app with AI, and it started fighting back. We found two systems holding the same data, moved everything onto one database, and weekly work on it continues.

Agency web app listing intake calls with AI scores, one call open with three red flags and its transcript.Rebuilt on test data
Trade
Law firm marketing agency
Client since
May 2026
Repeat work
Weekly work since Jul 2026, after two milestones.
Built in
Two paid milestones, then weekly work since Jul 2026
Built by
Senior AI engineer and a PM
Tools
  • Next.js
  • Supabase
  • Inngest
  • Claude
  • CallRail
  • Google Ads
  • Meta Ads
  • Metricool

Before and after

He built his own app with AI. It grew past him, and every fix to one part broke three others.

Before and after
BeforeAfter
DataSheets scripts and a database held the same data, so one fix broke anotherOne database
Script filesAbout 495 or 6

What we built

  • One source of truth. We took over his code and retired the second system.
  • Every call scored. Each inbound call is transcribed and scored by AI.
  • SEO red flags. Weekly SEO PDFs are read by AI into red flags per law firm.
  • Ads in plain English. Ask about Google Ads and Meta Ads, get the answer from an AI agent.
  • A portal per firm. Each law firm sees its own. The owner sees all of them.

How it works

  1. An intake call is recordedCallRail
  2. AI scores the transcript and flags what was missedClaude
  3. Weekly SEO PDFs are read into red flags per firmClaude
  4. Everything lands in one database, with a portal per firmNext.js, Supabase, Inngest
  5. Approved posts are scheduledMetricool

What broke and how we fixed it

What broke

Two systems held the same data, so every fix broke something else. About 20 percent of the SEO PDFs failed to read at first.

How we fixed it

We picked one database and moved everything onto it. Then we fixed the PDF reading.

The result

About 49 to 5 or 6 script files after the code rescue

Source: Our project brief (Jun 2026) and the 11 Oct case file

Built your own tool and now it fights back?

Tell us what your app does and what keeps breaking. We will look for the cause first.

Or send one sample file on WhatsApp (opens WhatsApp). Fake names are fine.

Tell us what breaks

We reply within one business day. No card, no contract.

More builds like this

More on AI Workflow AutomationSee all case studies