Use case · marketing agencies

Where the monthly client report comes from.

Every agency builds this report the same way. Someone opens the ad platforms on the last Friday of the month and copies numbers into a deck, then writes the paragraph explaining what happened. The numbers are mechanical. The paragraph is the part clients actually read, so it tends to get written last and fastest.

Company
A performance marketing agency
Team
19 people, 14 retained clients
Region
US
Stack
Google Ads, Meta Ads, Google Analytics, Slack
01The situation

Reporting month costs two days and the commentary still gets written last.

Reporting month was two days of an account manager reading dashboards and retyping them, which the agency had tried to fix twice already. A reporting tool drew the charts but still left the commentary blank, and a template deck meant everyone filled it in differently. The work that was left over was the work that needed judgement, so it kept landing on the person with the least time.
02How it works

How the droid took it on.

Rather than build the report and hope someone spots the odd campaign, the agency handed the whole cycle over. On the 1st the droid reads every client’s accounts, compares the month against the one before, and writes the draft with anything that went wrong sitting at the top.

TASK#204Monthly client performance reportActive
Schedule
1st of each month, 06:00 local
Scope
One run per client account
Reads
Google Ads, Meta Ads, Google Analytics
Writes
Report doc + draft email to the account manager
Escalates
Broken connections, and any client with no spend at all

Set up by asking for it in a sentence, then narrowed once the first month came back too long.

FIG. 1The durable task, exactly as it exists in the runtime.

Every client trips the same loop:

FIG. 2The loop each run walks.
03Ongoing handling

How it ran, client after client.

One reporting morning as it unfolded. Fourteen clients, nine flags, and one account the droid refused to write up because the Meta connection had expired.

  1. 06:00run 1 of 14

    Pulled June and May for the first client. Nothing tripped a rule, so the draft went over as-is.

  2. 06:04run 4 of 14escalated

    Search campaign held spend at $4,180 while conversions dropped from 61 to 19. Put it at the top of the report with both months side by side.

  3. 06:11run 9 of 14escalated

    Meta token had expired, so rather than write the month up from Ads alone it stopped and asked for a reconnect.

  4. 06:23run 14 of 14

    Fourteen drafts waiting, nine flags across six clients, one account blocked on a reconnect.

FIG. 3One night, run by run.

It found a campaign we'd been quietly funding for six weeks after it stopped converting. Nobody had looked because the totals still looked fine.

Account directorPerformance agency, 19 people
The result

What changed, by the numbers.

2 days → ~40 minreporting month, per cycle
9flagged campaigns in the first month
$0.14typical cost of one client's report

An illustrative workflow built from real product mechanics. The connected apps, the schedule and the flagging rules are how a droid actually runs; the agency, the quote and the figures are composites rather than a customer's numbers.

Try this workflow

Run this workflow yourself.

Copy the brief below and paste it into Unify. It’ll walk you through the prerequisites, connect what it needs, and stand the workflow up with you.

Workflow brief
We're a marketing agency and we send every client a performance report at the start of the month. Connect the client's Google Ads, Meta Ads and Google Analytics. Schedule a task for the 1st of each month. On each run, pull last month and the month before it — spend, impressions, clicks, conversions, cost per conversion, and revenue where it's tracked — broken down by campaign, and compare the two. Flag any campaign where spend held steady or rose while conversions fell by more than a third, any campaign where cost per conversion moved more than 40%, and anything that spent over $200 and converted nothing. Write it up as what happened, then why, then what we'd change, with the flagged campaigns at the top. Give me a doc and a draft email addressed to me, not to the client. Don't send anything to anyone.
Read next

Other jobs handed over

All use cases →

What would you take off your desk?

Tell us the job that never gets done before close. We'll wire it up on a call and you can watch it work.