Weekly marketing report

Q: What should a weekly marketing report include?

Headline traffic and signup numbers, channel mix with CAC and ROAS, top organic and paid pages, content and email performance, and a short watch list of things to fix or double down on next week.

Q: How do I automate a weekly marketing report?

Connect your ad platforms (Google Ads, Meta, Reddit, LinkedIn, TikTok), GA4, Search Console, and CRM to Basedash. Then schedule an AI automation to read them every Monday and produce the report.

Q: What's a good blended CAC for B2B SaaS?

It depends on ACV, but a healthy blended CAC payback for self-serve SaaS is 6 to 12 months. For sales-led, 12 to 18 months. A weekly report should always show CAC trending against your target — not just the absolute number.

Free weekly marketing report template. AI pulls traffic, signups, ad spend, attribution, and campaign performance into a single weekly recap.

Use this template How automations work

Runs weekly Scheduled Delivered to Slack, Email

Weekly marketing report

Active

Trigger

Runs weekly

Instructions

Generate a weekly marketing report for the past seven days, in the voice of a sharp marketing operator.

Delivery

Slack · Email

Example output

A realistic sample of what this automation delivers — your version draws on your data.

Weekly marketing report Runs weekly · Sent to Slack, Email

Sample output

Signups by channel, last 4 weeks

W-3 Last week

Top line. 12,400 visits (+9%), 727 signups (+12%), 38 paid signups (+27%). Marketing-sourced ARR for the week: $48K.

Paid. Spend $14,200, blended CPA $373 (target $400), blended ROAS 2.4×. Best campaign: Reddit / r/dataisbeautiful (CPA $190). Worst: LinkedIn / VP Data audience (CPA $1,140) — paused.

Organic. Three pages moved into the top 10: /vs/omni-vs-sigma (page 1, +18% clicks), /blog/best-bi-tools-for-non-technical-teams-in-2026 (+22%), /tools/sql-formatter (+9%).

Email. “Why SaaS dashboards lie” sent Wednesday — 27% open rate, 6.4% CTR, 18 signups.

Watch. Paid signup blend tilted toward Reddit two weeks in a row. Consider redirecting LinkedIn budget.

The prompt

Copy, paste, customize.

Drop this into a Basedash automation. AI fills in the numbers from every source you've connected.

Instructions

Generate a weekly marketing report for the past seven days, in the voice of a sharp marketing operator.

Structure:

**Top line.** Visits, signups, paid signups, marketing-sourced ARR, vs. last week.

**Acquisition.** Top five channels by signups and CAC, with WoW change.

**Paid.** Total spend, blended CPA, blended ROAS. Best- and worst-performing campaigns.

**Organic.** Top organic landing pages by signups. Highlight movement in long-tail SEO.

**Content.** Notable blog posts, videos, or comparison pages this week — traffic and conversions.

**Email.** Sends, opens, clicks, conversions for any campaign in the past seven days.

**Watch list.** Two to four things to fix or double down on next week.

Lead each section with one number. No emoji.

Data sources