Use casesReporting

Automate the weekly marketing report instead of rebuilding it every Monday

Mitra automates the weekly marketing report by collecting the numbers from the dashboards they live in. Describe the report once and an agent pulls traffic from Google Analytics, signups from PostHog and email performance from Mailchimp into your 'Marketing weekly' sheet every Monday at 9am. The agent then posts what went up and what went down to #marketing in Slack.

Runs: Mondays at 9am
Used by: Marketers · Ops / Chief of Staff

The prompt

Every Monday at 9am, pull last week's traffic from Google Analytics, signups from PostHog and email performance from Mailchimp into my 'Marketing weekly' sheet, then post what went up and what went down to #marketing in Slack.

Google Analytics

PostHog

Mailchimp

Google Sheets

Slack

Build this agent

200 credits to start · no credit card

What the agent actually does.

Read last week's traffic
The agent opens Google Analytics and takes the week just gone: sessions, users, and which channels sent them.
Count the signups
In PostHog it collects the people who signed up in the same window, so acquisition sits next to the traffic that produced it.
Pull the email numbers
From Mailchimp it takes the campaigns that went out and how each one performed — opens, clicks and unsubscribes.
Write one row in the sheet
The agent appends a single row to your 'Marketing weekly' sheet, in the columns you already use. Your formulas and charts pick it up on their own.
Post what went up and what went down
It compares the week against the one before and posts the movements to #marketing in Slack, each number with a direction beside it. A number without a direction is not a report.

Make it yours.

For the marketer or growth lead who opens four dashboards every Monday morning and retypes the same numbers into the same sheet. Change any of this by saying so — there is nothing to rewire.

Add ad spend to the row so cost per signup lands beside the signups.
Email the summary to the marketing lead instead of posting it in Slack.
Call out any metric that moved more than 20% at the top of the post.

Questions, answered.

Can I automate a marketing report that pulls from more than one tool?

Yes — Mitra reads each number from whichever tool holds it, so one agent can cover Google Analytics, PostHog and Mailchimp in a single run. You name the tools and the metrics in plain English, and Mitra works out the order of the steps. Adding a fourth tool later is one sentence.

How do I get a weekly report that shows whether numbers went up or down?

Tell Mitra to compare the week against the one before, and the agent writes a direction beside every number rather than a bare figure. Mitra reads last week's row from your sheet to make the comparison, so the post says traffic is up nine percent, not just the total.