Write the weekly campaign roll-up in Google Sheets
Set Carly up to pull last week's campaign performance every Monday and she'll write the standard rollup tab in the Campaign Performance Sheet, highlight the 2 best and 2 worst campaigns by CPA, and drop a 4-line summary into Slack #marketing with links straight back to the sheet.
What Carly does
- 01 Pull last week's campaign sends, opens, and clicks from HubSpot
- 02 Pull the same window from Google Analytics: sessions, conversions, CPA per campaign
- 03 Write the standard rollup tab in the Campaign Performance Sheet — one row per campaign
- 04 Highlight the 2 best and 2 worst campaigns by CPA with a one-line note on each
- 05 Drop a 4-line summary into #marketing on Slack with a link back to the sheet
Monday morning, the rollup is already in Slack
No more cobbling numbers together from three tabs. The sheet is current, the winners and losers are called out, and the team reads the read in Slack instead of opening a dashboard.
Email this to Carly to kick it off.
Hey Carly, Can you run the weekly campaign roll-up for me, every Monday at 8am ET? Pull last week's campaign performance: sends, opens, and clicks from HubSpot, plus sessions, conversions, and CPA from Google Analytics. Write the standard rollup tab in the Campaign Performance Sheet — one row per campaign, week-over-week deltas in the right-hand columns. Then highlight the 2 best and 2 worst campaigns by CPA with a one-line note on each (what worked, what didn't). Drop a 4-line summary into #marketing on Slack with a link straight back to the sheet so anyone can dig in. Thanks!
More recipes for marketing teams
Read the launch post, draft three emails, pull the segment, and schedule the campaign — same afternoon.
Read →Google Doc → Typefully threads + LinkedIn posts, staggered Mon–Fri so the launch keeps breathing all week.
Read →GA + PostHog → a written-up Google Doc with the week-over-week story and the one number that moved.
Read →Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."