Weekly KPI Report in Slack: Template + Automation (Shopify, GA4, GSC)

A weekly KPI report in Slack is a short, repeatable message your team posts every week—same metrics, same format—so you can spot changes fast without opening 5 dashboards.

This guide gives you copy/paste templates (founder, ecommerce, agency) and a practical automation spec so the report posts to #marketing automatically—pulling from Shopify, GA4, and Google Search Console. It’s written for teams who manage multiple data sources and want the signal in Slack, not the chaos in dashboards.

New: If you want a marketing-specific version (not just KPI scorecards), use: Marketing Weekly Report Template for Slack (Copy/Paste + Automation).

Want an SEO-only version (GSC scorecard + alert thresholds)? Use: SEO Report in Slack: Copy/Paste Template (GSC Scorecard + Alerts).

Need the monthly version? Use: Monthly KPI Report in Slack: Template + 30-Minute Close Workflow.

What to include in a weekly KPI report (the 60-second checklist)

If your weekly report doesn’t answer these questions, it becomes busywork:

What changed vs last week? (WoW deltas)
What changed vs the 4-week baseline? (trend sanity-check)
What should we do next? (1–3 actions, not commentary)
What’s broken? (alerts / anomalies / tracking issues)

Rule: keep the core report to 10–15 lines. Attach detail as links or a thread.

Slack Weekly KPI Report Template (copy/paste)

Use this format when you want a compact executive summary.

Weekly KPI Report — {{week_ending_date}}

Revenue: ${{revenue}} (WoW {{revenue_wow}}%)
Orders: {{orders}} (WoW {{orders_wow}}%)
AOV: ${{aov}} (WoW {{aov_wow}}%)
Conversion rate: {{cvr}}% (WoW {{cvr_wow}}%)

Paid spend: ${{ad_spend}} (WoW {{ad_spend_wow}}%)
Paid CAC: ${{cac}} (WoW {{cac_wow}}%)

Organic clicks (GSC): {{gsc_clicks}} (WoW {{gsc_clicks_wow}}%)
Organic impressions (GSC): {{gsc_impressions}} (WoW {{gsc_impressions_wow}}%)
Top rising query: {{top_rising_query}} ({{rising_impressions}} imps)

Top win: {{win}}
Top risk: {{risk}}
This week’s focus (1–3):
- {{priority_1}}
- {{priority_2}}
- {{priority_3}}

Tip: post the report, then put context in a thread. That keeps the channel scannable.

Ecommerce Weekly KPI Report Template (Shopify-first)

Use this when you operate an ecommerce store and need operational signals, not just topline.

Ecommerce Weekly KPIs — {{week_ending_date}}

Shopify
- Gross sales: ${{gross_sales}} (WoW {{gross_sales_wow}}%)
- Net sales: ${{net_sales}} (WoW {{net_sales_wow}}%)
- Orders: {{orders}} (WoW {{orders_wow}}%)
- Refunds: ${{refunds}} (WoW {{refunds_wow}}%)
- Chargebacks: {{chargebacks}} (WoW {{chargebacks_wow}}%)

Funnel (GA4)
- Sessions: {{sessions}} (WoW {{sessions_wow}}%)
- Add-to-cart rate: {{atc_rate}}% (WoW {{atc_wow}}%)
- Checkout-to-purchase rate: {{checkout_to_purchase}}% (WoW {{ctp_wow}}%)

Ops (only if relevant)
- Unfulfilled orders: {{unfulfilled}} (WoW {{unfulfilled_wow}}%)
- Inventory risk: {{inventory_risk_note}}

Notes
- Biggest driver: {{driver}}
- Biggest anomaly: {{anomaly}}

Agency Weekly KPI Report Template (multi-client)

Use this when you’re reporting across multiple clients and need consistency.

Agency Weekly Snapshot — {{week_ending_date}}

Client A ({{client_a_name}})
- Revenue: ${{a_rev}} (WoW {{a_rev_wow}}%)
- Paid spend: ${{a_spend}} (WoW {{a_spend_wow}}%)
- Organic clicks: {{a_clicks}} (WoW {{a_clicks_wow}}%)
- Next action: {{a_next_action}}

Client B ({{client_b_name}})
- Revenue: ${{b_rev}} (WoW {{b_rev_wow}}%)
- Paid spend: ${{b_spend}} (WoW {{b_spend_wow}}%)
- Organic clicks: {{b_clicks}} (WoW {{b_clicks_wow}}%)
- Next action: {{b_next_action}}

How to automate the report (a simple spec you can hand to an ops person)

You can automate this in lots of ways, but the spec is always the same:

Schedule: Monday 9:00am (your team’s timezone)
Destination: #marketing (or #client-{{name}})
Time window: last 7 full days vs previous 7 days
Outputs: (1) headline KPIs, (2) deltas, (3) 1–3 anomalies, (4) 1–3 next actions
Noise control: only expand details if a KPI moves > X% (example: 15%)

If you want this to run without manual dashboard checks, DataVessel can post it automatically via scheduled agents—connecting Shopify, GA4, and Search Console and delivering the report in Slack.

Common failure mode: “we post the report but nobody acts”

Two fixes that consistently work:

Assign one owner for the thread each week (rotate weekly).
Force a decision: “What are the 1–3 actions we’re taking this week?”

If you’re building an alert-driven culture (instead of dashboard culture), read Stop Checking Dashboards. Start Acting on Alerts. and the companion guide Scheduled Agents.

Frequently Asked Questions

What should a weekly KPI report include?

Include a small set of KPIs tied to your goals, plus week-over-week deltas and 1–3 next actions. If it doesn’t lead to action, it’s not a KPI report—it’s a log.

How long should a weekly KPI report be?

Short enough to read in under a minute: typically 10–15 lines. Put context and charts in a thread or link out to a report.

Should KPI reports be daily or weekly?

Weekly is best for trend decisions (budget shifts, campaign direction, SEO momentum). Use daily alerts only for anomalies (e.g., revenue drop, tracking break, refund spike).

How do you automate a weekly KPI report in Slack?

Use a scheduled workflow that pulls from your core sources (Shopify, GA4, GSC), computes WoW deltas, and posts a consistent template to Slack. The key is noise control: only expand details when something moves meaningfully.