Prompt Library

Recalculate B2B CAC payback and pipeline coverage by channel every month

Every month after close, Sai rebuilds CAC payback for each acquisition channel from what you actually spent and what your CRM actually closed, shows how many SQLs you are short of next quarter's target, and lets you test budget shifts before you commit them.

The PROMPTS
Copy prompt
On the [5th] business day of every month, rebuild our channel acquisition model and republish the dashboard. Channels: Outbound, Paid search, Content, Events [add or remove]. For each channel, pull last month's cost from [accounting export / budget sheet URL] — including the salaries and tools mapped to that channel in [cost mapping sheet] — and pull the funnel from [HubSpot / Salesforce]: leads, MQLs, SQLs, opportunities, and closed-won deals by original source, with deal value. Calculate per channel and blended: CAC, conversion rate at each funnel stage, average new MRR per customer, and CAC payback in months using [gross margin %]. Use a trailing [3]-month average so one large deal does not swing a channel. Deals with no recorded source go in an "Unattributed" row — never drop them or assign them to a channel. Pipeline coverage: next quarter's new ARR target is [amount], win rate comes from the CRM, and target coverage is [3]x. Show how many SQLs we need, how many the current run-rate produces, and the gap. If there is a gap, say which channel could close it fastest at the lowest CAC based on the actuals. Build an interactive web page: a slider per channel for next month's budget, recalculating blended CAC, payback, and projected SQLs as I move them, with the current actual allocation marked on each slider. Compare each channel with the previous month and flag any channel whose payback worsened by more than [2] months. Benchmarks: if I list sources at [URLs], show the benchmark beside blended CAC payback with source and year; otherwise show none. If an input is missing, mark the metric not calculable and name the input — never estimate. Keep each month's version at its own link.
Run this TaskView Demo

Platforms this prompt works across

Every B2B marketing team has a CAC number, and almost none of them agree on what went into it. Outbound looks cheap until SDR salaries are counted. Content looks free until the writers are. Events look fine until someone notices the travel sat in another budget. And the blended figure hides all of it — a healthy average can sit on top of one channel that pays back in eight months and another that never does. The only way to know which is which is to rebuild the numbers from actual spend and actual closed deals, every month.

‍

What this recurring task does

After each month's close, Sai pulls cost by channel from your finance data and the funnel by original source from your CRM, then calculates CAC, stage conversion, and CAC payback for each channel and for the business as a whole. It turns next quarter's revenue target into the number of SQLs you need, compares that with what the current run-rate produces, and shows the gap. Sliders let you test next month's budget split against real conversion rates before any money moves.

‍

Four channels, and what each one's CAC usually leaves out

A channel's CAC is only as honest as the costs assigned to it. The model keeps the cost mapping explicit, so no channel wins the budget argument by leaving out a line item.

★ FOUR CHANNELS, AND WHAT EACH ONE'S CAC USUALLY LEAVES OUT

ChannelCost countedFunnel stages trackedCommonly missed
OutboundSDR salaries and tools, data providers, sequencing softwareContacted → replied → meeting → SQL → wonSDR ramp time, and the manager's share of cost
Paid searchAd spend, agency fees, landing page toolingClick → lead → MQL → SQL → wonBrand-term clicks that would have arrived anyway
ContentWriters, freelancers, SEO tools, share of design timeVisit → signup / lead → SQL → wonThe long lag between publishing and pipeline
EventsBooth, travel, sponsorship, swag, staff daysBadge scan → meeting → SQL → wonTravel and staff time booked to other budgets
BlendedAll of the above plus shared marketing headcountNew customers ÷ total spendDeals with no recorded source, silently dropped

‍

How pipeline coverage becomes an SQL gap

Coverage models usually stop at a ratio — "we need 3x pipeline." That is not something a team can act on. Working backwards from the quarter's new ARR target and the CRM's actual win rate, the model converts coverage into a count of SQLs, then compares it with what each channel is producing now. If there is a gap, it names the channel that could close it at the lowest cost based on what actually happened, not on what the channel promised.

‍

What happens on the second run

Past months are not recalculated, so the trend shows what each channel really delivered at the time. Each channel is compared with the previous month, and any whose payback worsens by more than two months is flagged. Deals with no recorded source stay in an "Unattributed" row instead of being quietly dropped — a growing unattributed share is itself a finding, usually a tracking problem worth fixing before the next budget cycle. Benchmarks appear only when you name a source, such as OpenView's SaaS benchmarks report, and always with the year.

‍

Where this fits

Company-level CAC payback, graded against benchmarks for your stage, lives in the monthly SaaS metrics dashboard — this page breaks the same number down by channel. Once the model says which channel to feed, the weekly lead scoring rubric decides which of those leads get worked first, and automated follow-up sequences keep outbound SQLs from going cold.

Stop doing repetitive tasks. Let Sai handle them for you.

Sai is your AI computer use agent — it operates your apps, automates your workflows, and gets work done while you focus on what matters.

Try Sai