Weekly ad reports that write themselves

You run ads in two markets. Every week you copy numbers out of Ads Manager, campaign by campaign, and still can't say why results moved.

Regional online marketplace · SG and HKBuilt in-house by our founder
0manual data pulls
8-10 hrssaved by the team each week
2markets reported weekly and monthly
In their shoes · A marketing team running ads in two markets

Before and after.

A regional marketplace pulled its Facebook Ads data by hand, campaign by campaign, across Singapore and Hong Kong. Reports were slow and inconsistent, and nobody could explain why performance moved.

  • Ad data pulled by hand, market by market
  • Hours each week copying into spreadsheets
  • Raw numbers with no explanation
How it works

What we built, step by step.

Step 1

Pull both markets on schedule

Every week and every month, the system pulls campaign, ad set and ad data for Singapore and Hong Kong at the same time.

Step 2

Keep it in one sheet

Every row lands in a structured Google Sheet, so both markets are tracked the same way every time.

Step 3

AI writes the summary

AI reads the numbers and writes a short performance summary covering spend, cost per lead trends and which creatives worked.

Step 4

Every ad on the register

A separate weekly run adds new ads to a register, skips duplicates and reads the ad format from its name.

0manual data pulls
8-10 hrssaved by the team each week
2markets reported weekly and monthly
The full story

From busywork to running on its own.

The problem

A regional marketplace pulled its Facebook Ads data by hand, campaign by campaign, across Singapore and Hong Kong. Reports were slow and inconsistent, and nobody could explain why performance moved.

What we built

We built six connected workflows that pull campaign, ad set and ad data from both markets on a weekly and monthly schedule. The data lands in Google Sheets, and AI writes a plain summary of spend, cost per lead and creative performance. A separate workflow keeps a register of every ad, skipping duplicates and reading each ad's format from its name.

What changed

Nobody pulls report data by hand anymore, and the team saves 8-10 hours a week. Both markets get the same report format, and the ad register stops the team from testing the same creative twice.

Built withn8nMeta AdsOpenAIGoogle Sheets

Built in-house by our founder, before or alongside Workchestra. Names and numbers in the screens are samples; the results are real.

Want this for your team?

A free 20-minute call with the founder. We will tell you honestly if it is worth automating.

Book a free call
Case studies

Keep exploring the work.

18 case studies from real teams. Each one started with a team doing the same task by hand, every day.

Case study 01Workchestra client

More than 1,200 candidates are routed and traceable from first contact to orientation, with nothing retyped by hand.

Philippine manpower agencyRecruiters and the agency's management1,200+candidates routed and tracked
Case study 02Workchestra client

Management can compare any period, refreshed every hour, while the operations team keeps the same workbook.

Philippine manpower agencyManagement at a manpower agencyHourlyrefresh, fully unattended
Case study 03

Response time dropped from hours to under 60 seconds, with no manual data entry.

Regional online marketplaceAccount managers and their sales lead< 60 sfrom ad form to CRM record
Case study 04

Every thread, meeting and client session now has one source of truth.

US executive coaching firmA CEO and his executive assistant3ranked time slots per request
Case study 05

802 at-risk accounts, 35% of the 2,267 in scope, got a timely personal message in a single run.

Regional online marketplaceAccount managers with hundreds of accounts802at-risk accounts messaged in one run
Case study 06

Research that took 20-30 minutes now finishes in under 2 minutes.

Regional online marketplaceAccount managers preparing for first calls< 2 minto research one company
Case study 07

Decisions take seconds because each card carries its own context, so anyone on the team can act.

US executive coaching firmThe CEO's team reviewing AI workHourlyAI runs reviewed in one place
Case study 08

3.04 TB and 36,118 files moved, preserving about seven years of client history in the firm's own storage.

US executive coaching firmA firm with years of session recordings3.04 TBmigrated end to end
Case study 09

Every lead gets an instant reply, at 2 PM or 2 AM.

Regional online marketplaceSales reps and account managers5qualifying questions asked automatically
Case study 11

The mastersheet updates itself, so nobody runs VLOOKUPs.

Regional online marketplaceThe ops person who owns the mastersheet3data sources joined automatically
Case study 12

Coaches get overviews the same day and can turn one into a client email draft with a single button, now rolled out to every coach.

US executive coaching firmCoaches following up after client sessions8kinds of AI mistakes checked
Case study 13

A spoken note becomes a review-ready draft in under 30 seconds.

Internal teamAn executive who thinks faster than they type< 30 sfrom voice note to email draft
Case study 14

Both markets start the day with an enriched, cleaned lead list, and existing clients never reach sales.

Regional online marketplaceSalespeople who should be selling300leads discovered per run
Case study 15

Every submission is classified within seconds, before the sales team opens the file.

Regional online marketplaceSales reps calling new sign-ups< 2 sto verify each submission
Case study 16

A 2-day, 4-person process became one click.

Regional online marketplaceA sales manager approving monthly results1 clickto approve, down from 4 people and 2 days
Case study 17

Every request gets an answer within seconds and lands on the calendar, so nothing falls through the cracks.

Internal teamThe one builder everyone messages0requests left unacknowledged
Case study 18

The content team gets polished Google Docs drafts in both languages on schedule.

Regional online marketplaceA content team serving two markets2languages written at the same time