The Automation Company
Get a free automation plan

Automated weekly campaign reporting for marketing teams

Every Monday, campaign reporting automation pulls the week's results from Google Analytics, Meta and LinkedIn and explains what changed in plain language. Nobody spends the morning in a spreadsheet.

Get a free automation planMore for marketing automation
Works withGoogle AnalyticsMeta AdsLinkedInGoogle Sheets
Slack#ops-requests

Run weekly campaign reporting for today and post what changed

Weekly campaign reporting
Weekly campaign reporting · done in 19s
  • Pull sessions and conversions
  • Pull spend and ROAS
  • Pull lead gen results
  • Update the dashboard
  • Write what changed
StepToolResultTime
Pull sessions and conversionsGoogle AnalyticsGoogle AnalyticsLast 7 days vs prior 74s
Pull spend and ROASMeta AdsMeta Ads6 campaigns · $18,420 spent3s
Pull lead gen resultsLinkedInLinkedIn212 leads · $41 CPL3s
Update the dashboardGoogle SheetsGoogle Sheets12 tabs refreshed2s
Write what changedClaudeClaude5 bullets, in plain language7s

How the Monday report gets built

  1. Google CalendarTrigger · Google CalendarWhen this happensEvery Monday at 8:00
  2. Google AnalyticsStep 1 · Google AnalyticsPull sessions and conversionsLast 7 days vs prior 7
  3. Meta AdsStep 2 · Meta AdsPull spend and ROAS6 campaigns · $18,420 spent
  4. LinkedInStep 3 · LinkedInPull lead gen results212 leads · $41 CPL
  5. Google SheetsStep 4 · Google SheetsUpdate the dashboard12 tabs refreshed
  6. ClaudeStep 5 · ClaudeWrite what changed5 bullets, in plain language

Weekly campaign reporting without the copying

See every channel in one sheet

The agent pulls sessions and conversions from Google Analytics, spend and ROAS from Meta Ads, and lead results from LinkedIn. It refreshes your Google Sheets dashboard before anyone opens it, and the same report covers every campaign our marketing automation runs.

Weekly campaign reportMonday
  • Google AnalyticsOrganic+12% leads
  • Meta AdsMeta Ads−8% leads
  • LinkedInLinkedIn+4% leads
SlackMeta leads dipped after Variant A ran out. Swap in Variant C?

Read a summary instead of a spreadsheet

Claude writes a short note on what moved compared with the week before. It posts to Slack, and anyone can reply in the thread to ask about a campaign.

Slack#paid-media
The Automation CompanyAPP9:41 AM

Your Search campaign for spring roof repair in Calgary is ready. Want me to publish it?

Budget$3,200 / monthAd groups8 · 46 keywordsHeadlines15 per groupStartsPaused until you say
ApproveEditReject
Automations/Weekly campaign reportingLive
Weekly campaign reportingWhenGoogle CalendarEvery Monday at 8:00
Run #4,997 · started just nowRunning · 0/5
  1. Google CalendarTriggeredEvery Monday at 8:00
  2. Google AnalyticsPull sessions and conversionsLast 7 days vs prior 7
  3. Meta AdsPull spend and ROAS6 campaigns · $18,420 spent
  4. LinkedInPull lead gen results212 leads · $41 CPL
  5. Google SheetsUpdate the dashboard12 tabs refreshed
  6. ClaudeWrite what changed5 bullets, in plain language

Related use cases

All use cases
Google AdsGoogle SheetsGoogle AnalyticsSearch campaign builderAd spend goes up and leads don't. New Google search campaigns get built from your brief and wait for your approval.
Meta AdsCanvaSlackMeta creative refreshMeta ads go stale and nobody notices until results drop. Tired ads get spotted and replaced with new variants you approve.
SemrushMeta AdsGoogle SheetsCompetitor monitoringYou hear about a competitor's new price or ad after your customers do. Their changes reach your Slack every morning.

Campaign reporting questions

Get Monday's report without building it

Start with a free automation plan for your marketing team, or see where you stand with the AI readiness assessment.

Get a free automation planTake the AI readiness assessment