The client
A digital marketing agency in Bangkok with three account managers and a small creative team, looking after roughly fifteen retainer clients across paid social, search, and email. Their monthly client reports were eating somewhere between thirty and forty hours of senior time every cycle.
The problem
Each report pulled numbers from six or seven platforms (Meta Ads, Google Ads, GA4, the client’s CRM, their email tool, and so on), got assembled into a slide deck, and then needed a written commentary explaining what had changed and why. The data-pulling was tedious. The commentary was where the real value was, but it was also the part that kept getting cut for time.
The approach
The build wired all the relevant platforms into a single Airtable warehouse through n8n, pulling data nightly for every client. The reporting flow ran on the first of each month: it generated the standard charts in Looker Studio, then ran the period’s data through an LLM with detailed prompts about each client’s specific business goals and seasonal patterns. The output was a draft commentary, reasoned around the actual numbers, with flagged anomalies for the account manager to verify.
The account manager spent thirty to forty minutes per client reviewing, editing, and personalizing the report. Two hours per cycle, instead of two and a half days.
The result
Client-reporting time dropped from roughly thirty-five hours a month to about ten across the team. The freed capacity went into actual strategic work for clients, which the agency’s principal had been wanting to invest in for years. Two clients commented unprompted that the new reports felt sharper, which was the polite way of saying they had finally been getting a commentary at all.