Skip to content
← All work

Weekly marketing report agent

Automating the weekly MRR and ad-spend report I write by hand: pull the data, calculate week-over-week changes, and have an LLM draft the summary and flag anomalies.

The problem

Every week I build a report for the Head of Marketing from ChartMogul and CRM data covering MRR, ad spend, sales, community growth and MRR by region. Most of that is copy-paste.

The plan

  1. Export the data automatically on a schedule.
  2. Calculate week-over-week deltas with SQL or Sheets formulas.
  3. An LLM drafts a short narrative with the 3 biggest changes and any anomalies; a human edits before sending.

The demo will use sample data, not real company numbers.

Results

Coming soon.

Next build →

AI outbound engine: Clay enrichment + LLM first lines