Marketing & Growth

How to send a weekly marketing report as Chief of Staff and Founder's Office

Marketing & GrowthFor Chief of Staff and Founder's Office2 apps12 steps~24 min to set up

Every Monday morning, you're the one who fields 'can you send out a marketing update?' — then spends 90 minutes pulling numbers from HubSpot deals, Plaid/Stripe revenue data, Gmail campaign threads, and whatever PostHog dashboard the last growth hire set up. You stitch it into a Google Doc, paste screenshots that are already stale, and write a narrative summary that nobody asked you to write but everyone would miss if it weren't there. By the time it goes out, the weekly all-hands has already started. You're not a marketing analyst. You're the person who makes sure marketing doesn't fall through the cracks because there's no one else to catch it.

Build this on Starch → See the apps used

Marketing & GrowthFor Chief of Staff and Founder's Office2 apps12 steps~24 min to set up

Outcome

What you'll set up

An automated weekly marketing report that pulls live data from HubSpot, PostHog, and Gmail and lands in Slack every Monday morning before the all-hands — without you touching it.

A Growth Analyst app configured to your company's specific channels and KPIs, so the digest highlights what actually changed this week, not just a data dump.

A natural-language report builder you can point at any new data source — paid ads, LinkedIn, email campaigns — when the CEO asks for a one-time deep-dive.

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

Growth Analyst

Data sources & config

Starch syncs your PostHog data on a schedule via the Growth Analyst app. HubSpot connects directly to Starch on a schedule, pulling contacts, companies, and deals. Gmail syncs on a schedule so Starch can read agency reports and campaign threads. Slack is connected from Starch's integration catalog and queried live when the automation posts the finished report. All data sources are wired through Starch's scheduled sync or live integration catalog — no manual exports, no copy-paste.

Prompts to copy

Every Monday at 7:30am, pull last week's signups, conversion rate by channel, and top referrers from PostHog. Compare to the prior week. Write a 5-bullet summary of what changed and why it matters, then post it to #marketing-updates in Slack and email a copy to the exec team.

Watch my Gmail for any email from our paid agency or growth contractors with 'report' or 'weekly' in the subject. Summarize the key numbers and append them to this week's marketing update draft before it sends.

Pull our HubSpot pipeline data — new deals created, deals moved to proposal stage, and deals closed this week — and add a 'sales pipeline' section to the Monday marketing report.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Install the Growth Analyst app from the Starch App Store. It comes pre-wired for PostHog and Gmail — connect both accounts in the setup flow. PostHog and Gmail sync on a schedule so data is ready before Monday morning.

2 Configure the Growth Analyst digest to match your company's actual KPIs: tell it which PostHog events matter (signups, activations, trial starts), which channels to break out (organic, paid, direct, referral), and which conversion steps to track week-over-week.

3 Connect HubSpot to Starch. Starch syncs your HubSpot contacts, companies, and deals on a schedule. Tell the Growth Analyst to add a pipeline section: new deals created, deals advanced to proposal, and deals closed in the past 7 days.

4 Connect Slack from Starch's integration catalog. Build an automation that posts the finished weekly report to your chosen Slack channel — #marketing-updates, #exec-team, wherever your company actually reads things — at 7:30am every Monday.

5 Add a Gmail-watch step: Starch reads your inbox for emails from your paid agency or freelance contractors and extracts the key performance numbers (spend, impressions, ROAS, clicks) to append to the report before it sends.

6 Set up a natural-language prompt to generate the narrative summary — not just a data table. Tell Starch: 'Write three sentences explaining what drove the biggest change in signups this week and what we should watch next week.' This is the paragraph that replaces the 45 minutes you spend writing context for executives.

7 Wire the report to also email the exec team directly. Use Starch's Gmail send capability so the Monday report arrives in inboxes as well as Slack — useful for executives who miss Slack on weekends.

8 Test the full automation end-to-end on a Thursday or Friday by triggering it manually. Review the output, adjust the summary prompt if the narrative is too generic, and confirm all data sections are pulling correctly.

9 Customize the report template for board-prep weeks: once a month, add a prompt variation that pulls the prior four weeks of data instead of one, and formats it as a monthly trend summary your CEO can drop into the board deck.

10 Share the Starch app link with any functional leads who contribute to the marketing update (growth, product, sales) so they can add custom sections — like a product release note or a sales pipeline call-out — without sending you a Slack message at 9pm Sunday.

11 Review the report output once a week for the first month. When you notice a missing data point or a section that needs a new data source (like LinkedIn Ads performance), add it with a natural-language prompt: 'Add a section on LinkedIn Ads spend and click-through rate from last week, pulling from our LinkedIn Ads account.'

12 Once the automation is stable, remove the Monday morning marketing-report task from your calendar entirely. Starch runs it. You read the output like everyone else.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

Week of March 10, 2026 — Q1 push into enterprise segment

Sample numbers from a real run

New signups (PostHog)	214
Trial-to-paid conversion rate	18
Top referrer: G2 review page (visits)	890
HubSpot new deals created	7
HubSpot deals moved to proposal	3
Paid agency email: Google Ads ROAS	3.2

Monday at 7:31am, #marketing-updates in Slack receives a report with six sections assembled entirely by Starch. Signups were 214 for the week — down 8% from the prior week's 233 — but the narrative section flags that G2 drove 890 visits and trial starts from that channel were up 31%, suggesting the review generation campaign is working even if total volume dipped. HubSpot shows 7 new deals created versus 4 the prior week, with 3 moving to proposal stage, both trending in the right direction for the Q1 enterprise push. The Gmail-watch step caught last Friday's agency report and extracted the Google Ads ROAS of 3.2x, down from 3.8x the week prior — the summary flags it as worth watching but not yet a reason to pause spend. The exec team received the same report by email at 7:31am. The chief of staff didn't touch it. By the time the 9am all-hands starts, three executives have already replied in Slack with questions the report anticipated.

Measurement

How you'll know it's working

Time from week-end to report delivery (target: before 8am Monday, no manual steps)

Exec team engagement rate with the weekly report (replies, reactions, follow-up actions taken)

Coverage of marketing data sources in the report — are all active channels represented without manual additions

Number of ad-hoc marketing data requests that come to you after the report goes out (goal: reduce to near zero because the report answered the questions preemptively)

Board-prep time saved in months with a board meeting — does the weekly cadence make the monthly summary a one-click pull rather than a half-day project

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

Manual Google Doc + screenshots

You control the narrative completely, but someone (usually you) spends 60-90 minutes every single Monday assembling it — and it's always a little stale by the time it's read.

Databox or Klipfolio dashboard

Good for always-on metric visibility, but dashboards don't write the narrative summary or post it to Slack on a schedule — executives still have to go look at it, which they often don't.

HubSpot reporting + email

Native HubSpot reports are solid for CRM data but can't pull in PostHog, Plaid, or Gmail agency threads — so you're still stitching multiple tools together by hand.

Notion database + manual weekly update

Notion is where your documentation lives, but it has no native ability to pull live data from HubSpot or PostHog — every number still gets typed in by a human.

Hiring a growth analyst or marketing coordinator

The right long-term answer for a 150-person company, but at $70-90k loaded cost, hard to justify when the workflow is one report per week — and you'd still need to define what goes in it.

On Starch RECOMMENDED

One platform — growth analyst, founder inbox all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

Does Starch actually write the narrative summary, or does it just dump a data table?

It writes the narrative. You tell Starch in plain English what you want: 'Write three sentences explaining the biggest change in signups this week and what the team should watch next.' Starch pulls the numbers, compares them to prior-week data, and generates a plain-English summary. You can refine the prompt any time if the tone or focus isn't right.

What if we use Salesforce instead of HubSpot for our CRM?

Salesforce is available in Starch's integration catalog — the agent queries it live when your automation runs. You won't get the same scheduled sync depth as HubSpot, but deal data, pipeline stage, and new opportunities are all reachable. Tell Starch which Salesforce objects matter for your weekly report and it pulls them.

We run paid ads on Google and Meta. Can the report include ad performance?

Yes. Google Ads and Facebook Ads are both in Starch's integration catalog and queried live. You can add a prompt like 'Pull last week's Google Ads spend, clicks, and ROAS and add it to the marketing report' and Starch handles it. If your paid agency sends a weekly email with performance numbers, Starch can also read that Gmail thread and extract the data — useful if the agency uses a platform Starch doesn't connect to directly.

Is the data in the report real-time or could it be a day behind?

PostHog and HubSpot sync on a schedule — typically daily — so the data in your Monday morning report reflects activity through the prior day. For most weekly-cadence reporting, this is exactly right. If you need same-hour accuracy, that's not what Starch is optimized for; it's built for recurring operational reporting, not a live trading dashboard.

We're not SOC 2 certified — does that matter for a weekly marketing report?

Starch is not SOC 2 Type II certified yet. For a weekly internal marketing report pulling from your own tools, most growth-stage companies are comfortable with that. If your legal or security team has a hard requirement for SOC 2 Type II before any third-party tool can access HubSpot or Gmail data, that's worth knowing upfront — Starch would tell you the same thing.

What happens if the report automation breaks on a Sunday night?

Starch surfaces errors in the automation log and can notify you via Slack or email when a step fails. You'd see which step broke — the PostHog pull, the HubSpot query, the Slack post — and can re-run that step or the full automation manually. The goal is that you catch the failure at 7:30am when the report doesn't appear in Slack, not at 9am when your CEO asks about it.

Can I customize the report for different audiences — a shorter version for the exec team and a detailed version for the marketing lead?

Yes. Build two automations off the same underlying data pull: one prompt that writes a 5-bullet executive summary and posts to Slack, and a second that writes a longer section-by-section breakdown and emails it to your marketing lead. Both run from the same Monday morning schedule. You describe each version in natural language and Starch generates them separately.