Which channels produced signed contracts?

The searches that produce urgent break-fix inquiries are cheap, plentiful and almost never turn into a managed agreement. The searches and campaigns that produce managed contracts are quieter, more expensive per inquiry, and produce nearly all the recurring revenue.

Measured on inquiry volume the first looks like the winner every month. Measured on signed annual contract value the ranking usually inverts entirely, which is the single most useful thing an MSP can learn about its marketing.

Most MSPs get a substantial share of new contracts from existing clients, vendor partners and personal networks. That revenue is real and it is not produced by advertising, so crediting it to whichever campaign ran that quarter makes the paid figures worthless.

It lands in Direct / Unknown, shown rather than redistributed. Quantifying it is often the finding that changes the plan — a firm discovering that 39% of contract value is referral usually decides to invest in that deliberately rather than accidentally.

A managed agreement priced at forty seats rarely stays at forty seats. Clients hire, buy a competitor, add a second site, move a line of business onto your stack, and every one of those events raises the monthly invoice without any new marketing being involved. The signature value is what gets recorded in the pipeline report, and it is the smallest figure that agreement will ever produce. Judging the campaign that won the client on it is the same mistake as valuing a maintenance customer at the first visit.

Exporting billed revenue rather than contracted value changes the ranking. Pull invoices by client and month from the billing side of your professional services platform, upload them, and every month of billing credits the channel that produced the client in the first place. A source that signed three small clients who each tripled in two years moves above one that signed a single large account which has not grown since. That is the comparison an owner already makes informally, usually from memory and without any of the numbers.

It also makes churn visible in the only place that matters. A channel whose clients stop billing after fourteen months and a channel whose clients are still billing at year four look identical on signed contract value and completely different on revenue earned. Nothing has to be flagged or categorized for this to appear. Billing simply stops in the export and the cumulative figure against that channel stops growing with it, which is a finding the report never had to be told how to look for.

Recurring management pays the bills and project work pays for growth. A cloud migration, a hardware refresh, an office move, a remediation after a security assessment: these are billed separately, often at several times a month's recurring fee, and they arrive because a technology roadmap conversation went well rather than because anybody clicked an advertisement. Marketing is credited for none of it, and in many firms is not even shown the figures, so the demand budget is argued over on the slowest-moving part of the revenue.

Because every project invoice carries the same client contact as the managed agreement, it credits the channel that produced that client. Map a revenue-type column as Product / service and the report shows agreement revenue and project revenue as separate lines, with how much of each traces to a channel. The channel ranking itself covers both, so project revenue raises the channels that produced clients who later buy projects, which can change what the firm advertises and which service pages it bothers to maintain.

This is also the honest answer to the objection that project work is sold by the account team rather than won by marketing. It is, and the report does not claim otherwise. It credits the channel that produced the relationship the account team then sold into, and the revenue-type column separates the two effects for anyone who wants them separated. What you should not do is leave project revenue out of the file entirely, because that is the version of the numbers that makes marketing look like pure cost.

The revenue side is straightforward. The platform that raises your invoices holds a client identifier, an amount and a date for every agreement and every project, which is the same report the office already runs to reconcile the month. That is the whole revenue file. Nothing connects to your monitoring or management tooling, nothing reads ticket content, and no agent goes anywhere near a client network, which matters because your own clients audit you on precisely that point. Everything the report needs was produced in order to get an invoice paid.

The demand side is where most firms have less than they think. There is usually a website form, perhaps an advertising account, and then a long tail that lives in somebody's head: the vendor who passes leads, the accountant who recommends you, the chamber breakfast, the client who left and came back. Each of those is a list of people with contact details; combined into the one lead file, each row tagged with its source, each ranks on billed revenue beside the paid campaigns.

Assembling that second file is usually a morning's work and it decides how useful the first report will be. Every source you can supply moves revenue out of Direct / Unknown and into something you can act on, and everything you cannot supply stays honestly unattributed. The bucket is never redistributed to make the paid channels look healthier, which is the entire reason the paid figures can be trusted when somebody on the leadership team starts asking where they came from.