Draft client campaign recaps for you
Every Monday, WebRun opens Sprout Social to pull the past week's reach, engagement, and click metrics for each active campaign, builds the numbers into a running Google Sheet per client, and drafts a client-ready recap email summarizing the week, leaving it in the account manager's inbox to review and send.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I draft weekly campaign performance recaps for clients automatically?
WebRun builds your weekly campaign recap without a manual metrics pull. Every Monday it reads reach, engagement, and click data from Sprout Social for each active campaign, logs the numbers and their week-over-week change in Google Sheets, and drafts a client-ready recap email highlighting the top post, leaving it for the account manager to review and send.
- Weekly recaps drafted without a manual metrics pull every Monday
- Week-over-week swings over 20 percent get flagged automatically
- Every client email still gets a human review before it sends
Built for social media agencies · account managers · campaign managers · marketing agencies
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.sproutsocial.comin a real browser with your saved login - no setup, no API keys. -
1
Sprout Social - pull the week's campaign metrics
sproutsocial.com How to Automate Sprout Social
WebRun opens Sprout Social to pull the week's campaign metrics. - Open Sprout Social analytics and select each active campaign
- Pull reach, impressions, engagement rate, and link clicks for the past 7 days
- Note the best-performing post of the week for each campaign
Done when The week's metrics are captured for every active campaign.
-
2
Google Sheets - build the weekly numbers
google.com How to Automate Google Sheets
WebRun opens Google Sheets to build the weekly numbers. - Append this week's row to the running performance sheet for each client
- Calculate the week-over-week change for reach and engagement rate
- Highlight any campaign whose numbers moved more than 20 percent
Done when Every client's weekly numbers are logged with the week-over-week change.
-
3
Gmail - draft the client recap
gmail.com How to Automate Gmail
WebRun opens Gmail to draft the client recap. - Draft a short recap email in the client's usual format with the week's headline numbers
- Include the best-performing post and a one-line takeaway
- Leave the email as a draft for the account manager to review and send
Done when A ready-to-send recap is drafted for every client with an active campaign.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it send the recap to the client automatically?
No. WebRun drafts the recap email and leaves it in the account manager's inbox. A person always reviews the numbers and the wording before anything reaches a client.
Which metrics does it pull?
Reach, impressions, engagement rate, and link clicks for each active campaign, straight from Sprout Social analytics, plus the best-performing post of the week.
Does it work for campaigns just starting out?
Yes. A campaign with only a few days of data still gets a recap row, though week-over-week comparisons only appear once a prior week exists.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.