Marketing & Growth

How to send a weekly marketing report as Small Marketing Teams

Marketing & GrowthFor Small Marketing Teams2 apps12 steps~24 min to set up

Your three-person team rebuilds the weekly marketing report from scratch every Friday. Someone exports HubSpot deals to CSV, someone else pulls GA4 channel data, a third person downloads the Meta Ads and Google Ads spend reports, and then you spend 90 minutes in a Google Sheet stitching pipeline contribution numbers to cost-per-MQL by channel. By the time you've sent the report to the CEO, half the numbers are already a day stale. You don't have Looker or a BI tool. You have tabs, exports, and a VLOOKUP that breaks every other week when HubSpot adds a column.

Build this on Starch → See the apps used

Marketing & GrowthFor Small Marketing Teams2 apps12 steps~24 min to set up

Outcome

What you'll set up

A live marketing report app that pulls HubSpot deals, GA4 sessions, and ad spend from Meta, Google, and LinkedIn into one view — no exports, no spreadsheet stitching

A weekly automated email digest that summarizes MQL volume, pipeline contribution, cost-per-MQL by channel, and top content — sent to your CEO every Monday morning before standup

A Growth Analyst that tracks what changed week-over-week in your traffic and conversion data and tells you the three things that actually matter, with numbers

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 Sales Agent CRM

Data sources & config

Starch syncs your HubSpot data on a schedule (contacts, companies, deals, owners) so deal and MQL data is always current. GA4, Meta Ads, Google Ads, and LinkedIn Ads are connected from Starch's integration catalog and queried live when the report runs. PostHog is also connected from Starch's integration catalog for product and signup funnel data. Gmail is synced on a schedule so the weekly digest can be sent directly from your connected inbox.

Prompts to copy

Build me a weekly marketing report app that pulls HubSpot new deals created this week (by source), GA4 sessions and conversion events by channel, and Meta Ads and Google Ads spend and clicks for the same 7-day window. Show MQLs created, pipeline dollars influenced, cost-per-MQL by channel, and week-over-week change for each. Send a summary email to me and the CEO every Monday at 8am.

Start from the Growth Analyst app, but add a section that connects to PostHog conversion data and surfaces which referral sources drove signups this week versus last week, and flag any channel where cost-per-click went up more than 20% week-over-week.

Build me a dashboard that shows total ad spend vs MQLs created this week across Google, Meta, and LinkedIn, with a sparkline for each over the last 8 weeks.

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

Walkthrough

Step-by-step

1 Connect HubSpot in Starch — it syncs deals, contacts, companies, and owners on a schedule so your pipeline data is always ready without a manual export.

2 Connect GA4, Meta Ads, Google Ads, and LinkedIn Ads from Starch's integration catalog. The agent queries each live when the report runs, so you're always pulling the actual week's numbers.

3 Connect Gmail in Starch so the automated weekly digest can be sent from your real work email, not a noreply address.

4 Open the Growth Analyst starter app. Customize it with a prompt like 'add a HubSpot MQL section that shows new deals created this week by lead source, alongside GA4 sessions by channel and Meta + Google ad spend for the same window.'

5 Set the report to run on a schedule — every Monday at 7:45am is a good default so it lands in your CEO's inbox before the week kicks off.

6 Define the metrics that matter to your team: MQLs created, pipeline dollars influenced, cost-per-MQL by channel, sessions by source, and week-over-week change for each. Tell Starch exactly which numbers to include and it builds the layout.

7 Add a week-over-week change layer. Tell Starch: 'flag any channel where MQL volume dropped more than 15% or cost-per-MQL increased more than 20% compared to last week, and include a one-sentence note explaining the shift.'

8 Build a separate live dashboard (not just the email) that your team can check mid-week. Prompt: 'Show me a running view of this week's ad spend vs MQLs by channel, updated whenever I open it.'

9 Wire in PostHog if you track product signups or free-trial conversions separately from HubSpot MQLs — connect it from Starch's integration catalog and add a signups section to the Growth Analyst digest.

10 Test the report by running it manually for last week's date range. Verify the HubSpot deal counts match what you'd get from a manual export, and that ad spend totals match the platform dashboards.

11 Share the live dashboard link with your CEO and demand gen lead so they can pull up current-week numbers without waiting for Friday's email.

12 Iterate the report prompt over the first two weeks — add the sections that keep coming up in the CEO's follow-up questions (e.g., 'what's the content piece driving the most assisted conversions this week?') until the report answers the meeting before the meeting happens.

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 April 7–13, 2026 — Weekly Marketing Report

Sample numbers from a real run

HubSpot MQLs created (all sources)	47
Pipeline influenced (new deals by marketing source)	218,000
Google Ads spend	4,200
Meta Ads spend	2,800
LinkedIn Ads spend	1,900
Total ad spend	8,900
Blended cost-per-MQL	189
GA4 sessions (organic search)	9,400
GA4 sessions (paid)	3,100

The report that landed in the CEO's inbox Monday at 8am showed 47 MQLs created in the prior week, down from 61 the week before — a 23% drop that would normally prompt a 'what happened?' Slack message at 9am. Instead, the report already included a flagged note: LinkedIn Ads cost-per-MQL jumped from $112 to $287 after one campaign targeting the VP of Marketing audience ran out of budget on Wednesday and shifted spend to a lower-converting ad set. Google Ads held steady at $94 per MQL on 4,200 in spend. The growth digest section (from the Growth Analyst connection to PostHog) showed that the blog post on demand gen benchmarks drove 34 trial signups, making it the top assisted-conversion content piece of the week. The CEO's only reply: 'pause the LinkedIn campaign, push the budget to Google.' No spreadsheet. No Friday scramble. The team spent 15 minutes on the actual decision instead of the 90 minutes building the context for it.

Measurement

How you'll know it's working

MQLs created by source (week-over-week)

Pipeline dollars influenced by marketing channel

Cost-per-MQL by paid channel (Google, Meta, LinkedIn)

GA4 sessions by channel with week-over-week change

Top content pieces by assisted conversions or signups (PostHog)

Comparison

What this replaces

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

Looker / Looker Studio + manual data sources

Looker Studio can build this view but requires someone to wire up the data connections, maintain the schema when HubSpot or GA4 changes, and rebuild the layout when the CEO asks for a new metric — Starch lets you change the report by describing what you want.

Google Sheets + CSV exports

Your current process: works until HubSpot adds a column, GA4 changes an API, or the person who built the VLOOKUP is on vacation — Starch queries the sources live so there's nothing to maintain.

HubSpot Marketing Hub reporting

HubSpot's built-in reports are good for HubSpot-only data but won't join in GA4 sessions or Meta/Google ad spend without a paid BI add-on; Starch pulls all three in one app.

Supermetrics

Supermetrics pulls ad and analytics data into Sheets or Looker Studio well, but you still need to build and maintain the report layout yourself — and it doesn't connect to HubSpot deal data without additional work.

On Starch RECOMMENDED

One platform — growth analyst, sales agent crm 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 store our HubSpot and GA4 data, or is it pulling it fresh every time?

HubSpot is a scheduled-sync provider — Starch syncs your contacts, deals, companies, and owners on a schedule and stores them in Starch's database, so report queries run fast even against large deal histories. GA4, Meta Ads, Google Ads, and LinkedIn Ads are queried live from Starch's integration catalog each time the report runs. That means ad spend and session numbers are always current, but Starch isn't archiving years of historical ad data — it's pulling the window you specify.

We use Customer.io for email, not Mailchimp. Can Starch pull email performance data into the report?

Yes. Customer.io is reachable from Starch's integration catalog — connect it and tell Starch to include open rates, click rates, and unsubscribes from your active nurture campaigns in the weekly digest. You'd add a line to your report prompt like 'include Customer.io campaign performance for emails sent this week: opens, clicks, and unsubscribes by campaign name.'

Can it flag anomalies automatically, or does someone still have to read the numbers?

You can tell Starch exactly what to flag. For example: 'if MQL volume is down more than 15% week-over-week, include a note in the email summarizing which source drove the drop' or 'highlight any channel where cost-per-MQL increased more than 20% and explain what changed in the ad data.' The agent writes those callouts into the digest — your CEO gets context, not just a table of numbers.

What if we want to add Amplitude instead of or alongside GA4?

Amplitude is reachable from Starch's integration catalog. Connect it and add it to your report prompt the same way you'd add any other source. If Starch can't find a direct connector, it can automate Amplitude through your browser — no API needed. You'd just tell Starch which metrics to pull and where to include them in the report.

Is Starch SOC 2 certified? We'll get asked by security before connecting HubSpot.

Starch is not SOC 2 Type II certified yet. If your company's security review requires SOC 2 Type II, that's worth knowing upfront. It's on the roadmap. For teams where that's not a blocker, the HubSpot and Gmail connections work today.

The Growth Analyst starter app mentions PostHog — we use Amplitude. Do we have to use PostHog?

No. The Growth Analyst starter app is built around PostHog but you can fork it and swap in Amplitude (or GA4, or both) when you customize it. Tell Starch 'use Amplitude instead of PostHog for the signup and conversion data sections' and it rebuilds the app around your actual stack.