Marketing & Growth

How to send a weekly marketing report as DTC Brand Founders

Marketing & GrowthFor DTC Brand Founders3 apps11 steps~22 min to set up

Every Monday you're copy-pasting last week's Meta ROAS into a Google Sheet, pulling Klaviyo open rates from a separate tab, checking Shopify revenue in another browser window, and trying to make all three tell a coherent story before your 10am call. By the time you've stitched it together it's already Tuesday and the numbers are stale. You don't have a growth analyst on staff. You have a spreadsheet that three different people have touched and nobody fully trusts. The report goes out late, if it goes out at all, and the decisions you should be making on Friday get punted to the following week.

Build this on Starch → See the apps used

Marketing & GrowthFor DTC Brand Founders3 apps11 steps~22 min to set up

Outcome

What you'll set up

A weekly marketing digest that automatically pulls your ad spend, email performance, and Shopify revenue into one report and lands in your inbox every Monday morning before you've had coffee

Cross-channel visibility into which campaigns are actually driving revenue — not just clicks — so you can cut what's bleeding and double down on what's converting

A repeatable reporting rhythm you don't have to rebuild from scratch every week, freeing up 2-3 hours you currently spend on copy-paste work

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 Ads Agent Email Agent

Data sources & config

Starch connects to Shopify and Klaviyo from its integration catalog — the agent queries them live when the weekly report runs. Connect Meta Ads and Google Ads from the integration catalog the same way. Gmail syncs your inbox on a schedule so the Email Agent can surface supplier and agency threads without you digging. Growth Analyst reads PostHog if you're tracking site behavior. No scheduled data warehouse needed — each Monday trigger pulls fresh numbers from each source.

Prompts to copy

Every Monday at 7am, pull last week's Shopify revenue by channel, my Meta and Google ad spend and ROAS by campaign, and Klaviyo open and click rates by flow. Write a 300-word digest that tells me what moved, what's underperforming, and the one thing I should change this week. Email it to me.

Which of my Meta ad sets spent more than $500 last week with a ROAS below 1.5? List them with spend, revenue, and ROAS side by side.

Summarize any emails from my 3PL, agency, or suppliers from the past 7 days that mention delays, budget changes, or performance issues — flag anything that needs a response.

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

Walkthrough

Step-by-step

1 Connect Shopify from Starch's integration catalog. The agent will query your orders, revenue by channel, and refund data live each time the weekly report runs.

2 Connect Meta Ads and Google Ads from Starch's integration catalog. The agent queries campaign-level spend, impressions, clicks, and ROAS across both platforms without you logging into Ads Manager.

3 Connect Klaviyo from Starch's integration catalog so Starch can pull open rates, click rates, and attributed revenue from your flows and campaigns.

4 Starch syncs your Gmail on a schedule. This lets the Email Agent scan for threads from your agency, 3PL, or suppliers that mention budget changes, shipping delays, or performance flags — so nothing gets buried.

5 Open the Growth Analyst starter app and customize it for DTC: swap the default PostHog metrics for your Shopify and Klaviyo KPIs. Tell Starch: 'Add Shopify revenue and Klaviyo click rate to the weekly digest alongside PostHog signup trends.'

6 Set the Ads Agent (currently in beta — request access) to pull cross-channel paid performance. Tell it: 'Every Sunday night, flag any Meta or Google ad set that spent over $300 last week with a ROAS below 1.8.'

7 Write the automation trigger: 'Every Monday at 7am, compile last week's Shopify revenue, Meta and Google ad ROAS by campaign, and Klaviyo email performance. Write a digest with a one-paragraph summary, three bullet callouts, and one recommended action. Send it to my email.'

8 Add a secondary trigger for anomalies: 'If any single campaign's daily spend exceeds $200 and ROAS drops below 1.0, send me a Slack message immediately — don't wait for Monday.'

9 Test the full run manually on a Thursday. Check that revenue numbers match Shopify, ROAS matches what you see in Ads Manager, and the email lands formatted correctly.

10 Review the first two live Monday digests and refine the prompt — tell Starch to add or drop sections based on what's actually useful versus noise.

11 Once the rhythm is stable, use Presentation Agent (currently in development — request beta access) to turn the monthly rollup into a clean board-ready slide deck: 'Build a 6-slide monthly marketing summary with CAC trend, channel ROAS comparison, email revenue contribution, and top three takeaways.'

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 17, 2026 — post-spring-sale debrief

Sample numbers from a real run

Shopify revenue (7-day)	84,200
Meta Ads spend	11,400
Google Ads spend	4,800
Meta blended ROAS	3.1
Klaviyo attributed revenue (flows)	19,600
Klaviyo open rate (broadcast)	38
Refunds (7-day)	3,100

The Monday digest drops at 7:02am. Shopify revenue came in at $84,200 for the week — up 22% versus the prior Monday window — driven mostly by the spring sale push. Meta spend was $11,400 with a blended ROAS of 3.1x, but the digest flags one specific ad set: 'Spring Sale — Cold — 25-34F' spent $2,100 at a 0.8x ROAS while the retargeting set hit 5.4x on $1,800. Starch's recommended action: shift $1,500 from the cold set to retargeting before Tuesday's budget cycle. Klaviyo flows contributed $19,600 — the abandoned cart sequence alone drove $8,400, which is up 15% week-over-week after you tweaked the second email subject line. Refunds are $3,100, and Starch's Email Agent flagged a thread from your 3PL sent Friday afternoon about a fulfillment delay on your best-selling SKU that would have sat unread until Tuesday otherwise. Total time you spent producing this report: zero. You spent 12 minutes acting on it instead.

Measurement

How you'll know it's working

Blended ROAS by channel (Meta, Google, TikTok) week-over-week

Customer acquisition cost (CAC) by paid channel vs. email-attributed revenue

Klaviyo flow revenue vs. broadcast revenue, and open/click rates by segment

Shopify revenue by traffic source with refund rate overlay

Ad spend as a percentage of gross revenue (efficiency ratio)

Comparison

What this replaces

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

Triple Whale or Northbeam

Purpose-built for DTC attribution and solid at it, but you get another dashboard you have to check manually — it won't write you a digest, flag the underperforming ad set, or surface the supplier email in the same workflow.

Google Sheets + native Klaviyo/Meta exports

Free and fully in your control, but you're the one pulling CSVs every Monday, and the formula that worked last month breaks the week your intern touches it.

Looker Studio (formerly Data Studio)

Good for static dashboards once you've built them, but no natural-language authoring, no automated narrative digest, and setup requires someone comfortable with connector configs and calculated fields.

Klaviyo Analytics + Meta Ads Manager + Shopify Analytics (native)

Three separate tabs, three separate logins, and nothing that combines them into a single weekly narrative or acts on the data automatically.

On Starch RECOMMENDED

One platform — growth analyst, ads agent, email agent 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 connect to Meta Ads and Klaviyo, or do I need to set up a custom integration?

Both are available in Starch's integration catalog — you connect them from inside Starch and the agent queries them live when your weekly report runs. No custom integration work or API keys to manage on your end.

Will this store all my Shopify and ad data in Starch permanently?

Shopify, Meta Ads, and Klaviyo are queried live from Starch's integration catalog each time the automation runs, not stored in a persistent data warehouse inside Starch. If you need a years-long historical archive to query against, that's worth knowing upfront — Starch is built for live operational data surfaces, not long-horizon data warehousing.

The Ads Agent is listed as in development. What can I actually use today for ad performance reporting?

Today, you connect Meta Ads and Google Ads from Starch's integration catalog and build a custom automation that pulls campaign-level spend and ROAS on a schedule. The Ads Agent (in beta — request access) adds a higher-level AI layer on top: budget reallocation recommendations, automatic pausing of underperforming sets, and a unified cross-channel dashboard. The core reporting works now; the autonomous management layer is what's coming.

Can Starch pull TikTok Ads data into the weekly report?

TikTok Ads is reachable through Starch's integration catalog. Connect it the same way as Meta and Google and tell Starch to include it in the digest prompt. If you run into any gaps on a specific TikTok metric, Starch can also automate your TikTok Ads dashboard through browser automation — no API needed.

My agency manages our Meta account. Can they see the report too, or does this only work for my own login?

You connect the Meta Ads account from Starch under your own credentials (or a shared agency login if that's how your account is structured). The weekly digest emails to whoever you configure — you can add your agency contact to the distribution without giving them Starch access.

Is Starch SOC 2 certified? I'm connecting my ad spend and revenue data.

Not yet — Starch is not currently SOC 2 Type II certified. If your compliance requirements make that a hard requirement, that's worth factoring in. It's on the roadmap.

How is this different from just setting up a Klaviyo or Shopify automated report?

Native reports from each platform only know about that platform. Starch's digest combines Shopify revenue, Klaviyo email attribution, and ad spend ROAS into a single narrative — and it's written in plain language with a recommended action, not a table of numbers you still have to interpret yourself.