A ready-to-use weekly marketing scorecard template for business owners. Five metrics, one dashboard, five minutes every Monday morning.
Executive summary: This scorecard gives you a weekly marketing review you can complete in five minutes. It tracks five metrics that connect marketing activity to revenue outcomes: qualified opportunities created, cost per qualified opportunity, channel attribution, pipeline velocity, and trend comparison. Each metric includes the data source, acceptable ranges, and the specific question it answers for an owner. The format is designed for operators who need to know whether marketing is working without becoming marketing experts.
You do not have time to become a marketing analyst. You need a scorecard that tells you whether marketing is producing revenue in the same amount of time it takes to review your daily cash position. This is that scorecard.
Right now, your marketing review is either too long (monthly agency meetings full of charts you do not understand), too shallow (a quick glance at whatever number the agency highlights), or nonexistent (you assume it is working until revenue dips). A scorecard replaces all three patterns with a structured five-minute check that connects marketing spend to business outcomes every single week.
You open one dashboard every Monday. You see five numbers. Each number has a green, yellow, or red indicator based on whether it is on track compared to the trailing four-week average. Green means marketing is performing. Yellow means watch it this week. Red means something needs attention now. The entire review takes five minutes. When everything is green, you move on with your day knowing marketing is producing.
A scorecard built on vanity metrics gives false confidence. The five metrics in this scorecard are selected specifically because each one connects to revenue, not marketing activity.
Monthly cadence means problems compound for four to six weeks before detection. Weekly cadence catches issues while they can still be corrected within the same budget cycle.
Numbers without context are meaningless. Each metric needs a defined acceptable range so you know instantly whether the number you see represents health or a problem requiring intervention.
Multi-location pest control company (Home Services): 22% improvement in marketing ROI within first quarter. Weekly scorecard visibility allowed the owner to spot a declining channel within two weeks and reallocate budget before the monthly review would have surfaced the problem. The saved spend redirected to a higher-performing channel produced measurable ROI improvement.
IT managed services provider (Technology Services): 4 hrs/mo saved from eliminated agency review meetings. Replaced monthly two-hour agency review meetings with a shared weekly scorecard. Owner reviews independently in five minutes. Agency receives specific questions via Slack when metrics are off trend. Both parties save time and conversations are data-driven rather than narrative-driven.
| Metric | Before | After |
|---|---|---|
| Qualified Opportunities Created | Not tracked separately | Weekly count + trend |
| Cost Per Qualified Opportunity | Blended CPL reported | CRM-verified by channel |
| Channel Attribution | Agency-reported | CRM source-of-truth |
| Pipeline Velocity | Unmeasured | Days to close, tracked weekly |
| 4-Week Trend | No comparison baseline | Automated trend indicator |
This scorecard replaces your agency's monthly PDF with a weekly five-minute review that connects marketing spend to business outcomes.
Every Monday morning, open your CRM dashboard and check these five metrics. Each one answers a specific question an owner needs answered.
Metric 1: Qualified Opportunities Created This Week
Data source: CRM pipeline — count new opportunities created with marketing as the source.
Acceptable range: Your baseline plus or minus 20%. Establish the baseline after four weeks of consistent tracking.
Action trigger: Two consecutive weeks below baseline means marketing volume or quality has shifted. Investigate channel performance.
Metric 2: Cost Per Qualified Opportunity by Channel
Data source: Total marketing spend per channel divided by qualified opportunities sourced from that channel (CRM data, not platform data).
Acceptable range: Below your maximum CAC divided by your close rate. If max CAC is $1,000 and close rate is 25%, max cost per opportunity is $250.
Action trigger: Any channel consistently above acceptable range for three weeks should have budget reduced and reallocated.
Metric 3: Channel Attribution
Data source: CRM source field on each qualified opportunity, mapped back to originating marketing channel.
Acceptable range: Distribution should match your investment allocation. If you spend 60% of budget on paid search, paid search should produce roughly 50-70% of opportunities.
Action trigger: Any channel consuming disproportionate budget relative to its opportunity production needs evaluation.
Metric 4: Pipeline Velocity
Data source: Average days from opportunity creation to closed-won, calculated weekly from your CRM.
Acceptable range: Within 15% of your trailing twelve-week average.
Action trigger: Velocity increasing by more than 20% signals prospects stalling in your pipeline. Diagnose which stage is creating friction.
Metric 5: Trailing Four-Week Trend
Data source: Each metric compared to its own four-week trailing average.
Acceptable range: Flat or improving.
Action trigger: Any metric declining for three consecutive weeks requires investigation, even if the absolute numbers are still within range.
Week 1: Configure UTM tracking and CRM source fields. Ensure all active campaigns carry consistent parameters.
Week 2: Build the dashboard in your CRM with all five metrics. Set up automated refresh.
Week 3-4: Collect baseline data. Do not make decisions yet — you need four data points to establish reliable baselines.
Week 5: Begin weekly reviews. Set acceptable ranges based on your four-week baseline.
Ongoing: Five minutes every Monday. That is the commitment. When everything is green, move on. When something is yellow or red, investigate.
This scorecard replaces monthly agency review meetings, ad-hoc performance questions you send via email, the anxiety of not knowing whether marketing is working, and the gut-feeling budget decisions that come from operating without data.
It does not replace strategic marketing planning. But it ensures that your strategic decisions are informed by operational data rather than agency narratives.
Part of the AI Marketing Systems insights cluster at JubilantWeb. Reviewed by Nelson Penagos, Founder & Systems Architect. Contact: hello@jubilantweb.com | (407) 630-8771
The scorecard requires three technical connections: your ad platforms feeding conversion data to your CRM, your CRM tracking source attribution at the contact level, and a dashboard tool pulling from CRM data to display the five metrics. Most CRMs — HubSpot, Salesforce, Pipedrive — have native dashboard capabilities that support this. The initial setup involves configuring UTM tracking across your campaigns, mapping source fields in your CRM, and building a custom dashboard with the five metrics and their trend indicators. This is a one-time architecture build that typically takes 7-10 days. Once configured, the dashboard updates automatically with no manual data entry required.
A qualified opportunity is a lead that has been confirmed to meet your minimum criteria for a viable sale. The specific criteria depend on your business, but typically include: the prospect has a relevant need your company can address, they have budget or financial authority to make a purchasing decision, and they are within your serviceable market in terms of geography, company size, or industry. A lead is anyone who has expressed interest — filled out a form, called your office, downloaded a resource. The gap between lead count and qualified opportunity count reveals your marketing's quality. Strong marketing produces a high percentage of leads that qualify. Weak marketing produces volume without quality.
This varies by industry and deal size, but here is a practical framework: divide your average deal value by your target LTV-to-CAC ratio, then adjust for your lead-to-close rate. If your average deal is $5,000 and you target a 4:1 LTV-to-CAC ratio, your maximum CAC is $1,250. If your close rate on qualified opportunities is 25%, your maximum cost per qualified opportunity is $312. The actual number is less important than the trend. If your cost per qualified opportunity is declining month over month, your marketing efficiency is improving regardless of the absolute number. Track the trend and react when it inflects.
Pipeline velocity measures the average number of days from opportunity creation to closed deal. Healthy velocity depends on your sales cycle norms: service businesses with simple offerings might close in 7-14 days, B2B companies with complex sales might take 45-90 days, and enterprise contracts might take 120 days or more. The absolute number matters less than consistency and trend. If your velocity increases suddenly, prospects are stalling somewhere in your pipeline — diagnose which stage they are getting stuck in. If velocity decreases, your marketing is attracting better-fit prospects or your sales process has improved. Track it weekly and investigate any change that persists for two or more consecutive weeks.
When all five metrics are on track, you have earned the right to focus on something else. That is the entire point of the scorecard — it tells you when marketing does not need your attention. Resist the urge to change things when they are working. The most common mistake operators make with a healthy scorecard is tinkering with what is producing results. If every metric is green for four consecutive weeks, consider testing a budget increase on your highest-performing channel. A 15-20% increase with monitoring will tell you whether you can scale without degrading efficiency. But do not fix what is not broken. A green scorecard is permission to spend your attention elsewhere.