# How to build a weekly marketing scorecard for your team

Create a weekly marketing report with defined KPIs, owners and next actions. Use lead-generation and ecommerce examples to turn numbers into decisions.

Canonical page: https://cpcinsider.com/insights/weekly-marketing-scorecard/
Author: Vladlens Kecko
Published: 2026-09-29
Updated: 2026-10-12


A weekly marketing scorecard should help your team make a decision. It does not need every number available in an advertising account. Start with the question the meeting must answer: fix a measurement issue, improve qualification, change an offer or release more budget?

Use a small group of measures with clear definitions. Keep commercial outcomes visible, but recognise that results from a long sales cycle will not mature every week.

## 1. Give each metric a definition and an owner

Record the data source, reporting period, filters and denominator. “Leads” is too ambiguous if one person counts form submissions and another counts sales-accepted opportunities.

| Metric record | Fill in |
| --- | --- |
| Business question | Decision this metric informs |
| Definition | Exact event, stage or calculation |
| Source and scope | Report/system, channel, currency and exclusions |
| Period or cohort | Activity dates or group of customers being followed |
| Owner | Person responsible for explaining the result |
| Comparison | Comparable prior period or agreed baseline |
| Next action | Decision, responsible person and review date |

A metric without an owner often becomes a number everyone sees and nobody investigates.

## 2. Use a lead-generation scorecard

The figures below are illustrative. They demonstrate a review method, not expected performance.

| Weekly observation | Business interpretation | Action to investigate |
| --- | --- | --- |
| 20 new enquiries; 12 assessed; 6 accepted | Eight are still unassessed; accepted share among assessed is 6/12 | Complete the review before judging overall quality |
| Three accepted enquiries await a response | The constraint may be handling, not demand | Assign owners and agreed follow-up times |
| €600 media spend | Current-week spend does not describe mature acquisition cost | Follow the enquiry cohort through the sales cycle |
| Four deals closed this week from older enquiries | These are not a conversion rate for this week's 20 enquiries | Report closed outcomes with their source cohort |

Keep rejection reasons visible. “Wrong location”, “unsupported service” and “could not contact” require different actions. Use the [lead-generation system guide](https://cpcinsider.com/insights/b2b-lead-generation-system/) to align marketing and sales definitions.

## 3. Use a separate ecommerce view

| Measure | Definition to agree | Decision it supports |
| --- | --- | --- |
| Orders and net revenue | Treatment of cancellations, refunds and taxes | Whether demand produces usable revenue |
| Contribution before ads | Revenue minus defined variable costs | How much acquisition the order can support |
| Advertising spend | Channels and period included | Whether acquisition fits the economics |
| New and returning customers | Customer identification and time window | Whether growth comes from acquisition or repeat purchase |
| Fulfilment or returns issues | Operational data source and timing | Whether more demand can be served profitably |

Use the [break-even ROAS worksheet](https://cpcinsider.com/insights/break-even-roas/) to define the cost calculation. Avoid counting each platform's attributed sales as additional business revenue when channels overlap.

## 4. Separate leading indicators from mature outcomes

A [marketing-team discussion](https://www.reddit.com/r/marketing/comments/18d6oq0/) asks whether one KPI can measure a whole team despite a long sales cycle. It highlights why an outcome and a few diagnostic indicators are often more useful than a single unexplained number.

Use a weekly cadence for operational issues and a suitable longer window for mature sales, retention or contribution. BDC's [budget guidance](https://www.bdc.ca/en/articles-tools/marketing-sales-export/marketing/marketing-budget-cut-not-cut) supports regular spending and effectiveness reviews; the weekly format here is a practical recommendation, not a universal standard.

## 5. Finish the meeting with a decision log

For each issue record the observation, proposed explanation, action, owner and next review. “Conversions down” is an observation. “Test the mobile form because successful submissions are missing” is an actionable next step.

If data volume is small, say so. Compare like-for-like periods and annotate tracking, pricing and campaign changes. A green dashboard is not a substitute for understanding the business.

### Do we need an expensive reporting tool?

No. A shared table can work while definitions and ownership are being established. Automate repeated collection after deciding which measures actually support decisions.


For customer losses hidden by new acquisitions, use the [customer retention worksheet](https://cpcinsider.com/insights/customer-retention-rate/) to reconcile the opening cohort before comparing rates.

## Turn reporting into clear team priorities

[Request a free performance audit](https://cpcinsider.com/#audit) or explore [marketing leadership support](https://cpcinsider.com/services/marketing-leadership/). We can help connect reporting, responsibilities and the next commercial decision.