AI-powered AVM generator built with Pro and Delfos to turn Hepic's audience-value model from a slow Excel workflow into an automated, LLM-driven platform.
I led the development of the AVM Generator platform for Hepic (hepicmarketing.com), working together with Pro Internacional (prointernacional.com) and Delfos (delfoslabs.com), both part of the Domus Global ecosystem. The goal was to take Hepic's AVM model —their internal framework for planning content and campaigns— and turn it into a usable product instead of a manual, spreadsheet-based process.
Hepic is a B2B content marketing and demand generation studio that creates content in multiple digital formats (blogs, ebooks, scripts, podcasts, social, email, and more) to help organizations grow through content. Their AVM (Audience/Value Model) breaks down potential audiences for a product or service in a cascading way: macro segment → segment → interests and pains → media they consume → content formats that create impact. This model is powerful, but maintaining it manually in Excel meant weeks of research and iteration for each new client or campaign.
We transformed that manual process into a web platform built with Next.js on the front end and AWS Lambda functions as a serverless backend. At the core, we designed a wizard-style form that captures all the client's core information (industry, product or service, target audiences, objectives, tone, constraints) in a structured way, so the AVM logic can be automated instead of reconstructed from scratch every time.
On top of this, we integrated LLMs (OpenAI) to generate the full AVM matrix in minutes. From the initial brief, the system produces structured outputs for:
The result is a cascading audience map that replicates Hepic's methodology but now generated programmatically. The platform outputs the AVM as structured data that Hepic's team can review, adjust and export, instead of starting from a blank spreadsheet every time.
From a technical standpoint, I designed and implemented the front-end architecture in Next.js, the serverless logic on AWS Lambda, and the LLM prompt and orchestration layer around OpenAI. We focused on:
Before this project, building one AVM required several weeks of manual research and spreadsheet work. With the AVM Generator, the Hepic team can create AVM matrices in minutes, and then invest their time where they add the most value: refining the strategy, validating insights with clients, and producing high-impact content, instead of wrestling with Excel.