Case study About Contact Book a Free Sales Audit

Tracking  ·  Reporting Cadence & Templates

Build a Service-Line Performance Report

Generate a report template that compares win rate, ACV, and margin across your agency's service lines.

foundermanagerAdvanced
When to use

Use monthly or quarterly when you sell more than one service (SEO + paid + web, etc.) and want to know which line actually drives the business. This template puts win rate, ACV, retention, and margin side-by-side so you can double down — or kill — a service.

The prompt
Prompt
You are a sales ops lead at a multi-service digital marketing agency.
Agency: [AGENCY_NAME] — [SERVICES] | Reporting period: [REPORTING_PERIOD] | Audience: founder + leadership | KPIs: [KPIS] | Service lines to compare: [SERVICE_LINES]
Design a service-line performance REPORT TEMPLATE that compares each service line head-to-head so leadership can decide where to invest, raise prices, or sunset.

- One page summary + one detail page per service line max
- Must include 'What's the action?' — invest / hold / fix / sunset call per service
- Apples-to-apples metrics across all lines
- Include delivery margin if data available (sales without margin = misleading)

Markdown template with: (1) Summary table (rows = service lines; cols = pipeline $, win rate, ACV, gross margin, 12-mo retention, NPS), (2) Headline (3 bullets — biggest signal), (3) Per-service detail block (one per line: trend, top win, top loss, biggest issue), (4) What's the action? — recommendation per service (invest/hold/fix/sunset) with rationale. 1-line prompt per section.
Variables
  • [AGENCY_NAME]Your agency name
  • [SERVICES]Top-level service mix
  • [REPORTING_PERIOD]Trailing 90 days or quarter
  • [KPIS]Metrics measured per service
  • [SERVICE_LINES]Specific lines compared, e.g. SEO retainer, Paid media, Web design, CRO
Example input
Input
AGENCY_NAME: Beacon Marketing | SERVICES: SEO, paid, web, CRO | REPORTING_PERIOD: Q1 2026 | KPIS: pipeline $, win rate, ACV, gross margin, 12-mo retention | SERVICE_LINES: SEO retainer, Paid media, Web design, CRO sprints
Example output
Output
# Beacon — Service-Line Performance, Q1 2026

## Summary
| Service | Pipeline $ | Win rate | ACV | Margin | 12-mo Ret. | NPS |
|---|---|---|---|---|---|---|
| SEO retainer | __ | __ | __ | __ | __ | __ |
| Paid media | __ | __ | __ | __ | __ | __ |
| Web design | __ | __ | __ | __ | __ | __ |
| CRO sprints | __ | __ | __ | __ | __ | __ |

## Headline (3 bullets)
- _Biggest signal._
- _Second._
- _Third._

## Detail per service
_Per line: trend (▲▼), top win, top loss, biggest issue._

## What's the action?
| Service | Call | Why |
|---|---|---|
| SEO retainer | Invest | _rationale_ |
| Paid media | Hold | _rationale_ |
| Web design | Fix margin | _rationale_ |
| CRO sprints | Sunset or repackage | _rationale_ |
Pro tips
  • Watch the margin column closely — a high-win-rate, low-margin service can quietly sink the agency.
  • Pair this with the Lost-Deal Report tags to see if losses cluster on one service.
  • Run it BEFORE pricing changes — never the other way around.

Free 20 minute sales audit

A prompt is not a system.

These are free and they work. What they cannot do is make your team run the play every week. That is the part we install.

Book a Free Sales Audit