Blog · Industry
Explore customer, product and recurring-revenue performance for your software business. Work with dashboards and an AI analyst on reports tailored to your subscription, licensing or service model.
Reconcile signed bookings, net billings, recognized revenue and recurring-revenue movements from SaaS exports. Follow a worked contract example, spreadsheet formulas and checks that explain why the totals differ.
Oct 23, 20266 min readA product health dashboard compares customer adoption, continued use, and recurring revenue on the same cohort base. Build the comparison from supplied usage and subscription exports, with formulas and checks that keep the measures aligned.
Oct 22, 20265 min readSaaS gross margin measures revenue left after delivery costs. Classify hosting, support and other delivery costs consistently, reconcile product margins, and separate real changes from accounting reclassifications.
Oct 21, 20266 min readCalculate SaaS cost per lead from campaign and CRM exports, then follow the same leads into opportunities and customers. This worked example connects lead costs to acquisition cost and gross-profit payback.
Oct 20, 20265 min readAn adoption dashboard compares qualifying usage, feature uptake, and later return activity. This worked software example starts with exported user rows, proves the cohort totals, and changes one input to show what moves.
Oct 18, 20265 min readAn MRR dashboard explains how recurring revenue changes from one month to the next. Build a customer movement table from subscription exports, calculate the bridge in Excel, and prove it matches closing MRR.
Oct 17, 20264 min readCustomer success analytics connects account adoption and service effort with renewal and expansion outcomes. Build a comparable account table from your exports, calculate the measures in Excel, and reconcile the results before assigning action.
Oct 15, 20265 min readPassive churn is customer loss caused by unresolved payment problems rather than a deliberate cancellation. Measure the final outcome of a billing cohort and reconcile recovered, lost and unresolved customers before comparing periods.
Oct 15, 20265 min readA customer success dashboard brings renewal status, recorded adoption, service effort, and revenue into one account review. This worked example reconciles the totals and changes one usage input to show what moves the result.
Oct 14, 20266 min readBuild an ARR forecast from opening subscriptions, renewal assumptions and recurring pipeline. Work the customer-group bridge, reproduce it in Excel and check that every movement reaches the closing total.
Oct 12, 20266 min readSaaS ARR annualizes recurring subscription charges under a stated company policy. Calculate it from contract lines, reconcile customer movements and keep it separate from bookings and recognized revenue.
Oct 9, 20265 min readCalculate SaaS marketing ROI using acquisition costs and realized subscription contribution. Compare equally mature cohorts, find the observed payback month, and keep projected lifetime returns separate.
Oct 9, 20266 min readB2B product KPIs connect account adoption and repeat usage with customer retention and recurring value. Use a worked customer-cohort example to separate user behavior from commercial outcomes.
Oct 7, 20265 min readSoftware financial ratios connect delivery margins, operating spending and cash generation. Use a worked quarterly comparison to build a consistent finance scorecard from revenue, cost and cash exports.
Oct 7, 20266 min readRank recorded SaaS cancellation reasons by lost ARR, tenure and product usage. Build a reproducible spreadsheet breakdown, reconcile the losses and separate recorded explanations from evidence of a cause.
Oct 4, 20266 min readSaaS financial management connects recognized revenue, delivery costs, operating spending and cash with budget. Build a monthly review from finance exports, reconcile the results and assign the decisions.
Oct 4, 20265 min readBuild a SaaS sales dashboard from CRM deals and subscription summaries. Separate signed bookings, recurring revenue movements and open pipeline, then check how each total connects to its source rows.
Oct 4, 20265 min readCustomer success segmentation groups accounts by lifecycle, renewal exposure and service needs. Build a coverage table from account and contract exports, reconcile workload, and assign capacity from the evidence.
Oct 2, 20265 min readSaaS bookings measure signed commitments, while ARR annualizes eligible recurring charges at a reporting date. Reconcile the same contract rows through term, services, start dates and renewals.
Oct 1, 20265 min readThe Rule of 40 adds a software company's revenue growth rate to its profit margin and asks whether the sum reaches 40%. This page gives the formula and the Excel version, works five companies, shows how the choice between EBITDA and free cash flow margin can flip the result, and covers which growth figure to use and what the score cannot tell you.
Sep 26, 20266 min readUnit economics is the profit and loss of one customer: what it pays, what it costs to serve, what it cost to win and how long it stays. This page builds the per-customer P&L for three segments of one software company, ties CAC, payback and LTV together, caps the lifetime so low churn cannot inflate it, and shows the same method for businesses without subscriptions.
Sep 26, 20268 min readAverage SaaS CAC measures acquisition spending per new customer, but contract size and sales motion change what the average means. Compare consistent segments, calculate gross-profit payback and select benchmarks that match your definitions.
Sep 23, 20265 min readThe LTV to CAC ratio divides a customer's lifetime gross profit by the cost of winning them. This page gives the formula, works three segments with CAC payback in months, shows why a blended ratio hides the segment below 3:1, and caps the lifetime so a low churn rate cannot turn into a ten-year customer.
Sep 23, 20266 min readApp user behavior analysis compares completed tasks and return activity in existing exports. Build a user-level worksheet, calculate funnel completion and returning-user rates, and compare signup cohorts with equal observation windows.
Sep 22, 20266 min readCustomer lifetime value is the gross profit a customer brings over the whole relationship. This page gives the standard LTV formula, where each input comes from, a worked example on three segments with LTV against CAC, a discounted version, a method for B2B businesses without subscriptions, and the check that proves the segment figures.
Sep 22, 20266 min readA SaaS cash flow statement explains customer receipts, spending and the change in cash. Follow a worked example connecting annual advance billings, deferred revenue, receivables and operating cash, then test a slower renewal month.
Sep 22, 20266 min readCustomer acquisition cost is the sales and marketing cost of winning a new customer. This page gives the formula and what belongs in the cost, a small spreadsheet calculator for CAC and payback, a worked example across four channels with the weighted-average check, and the difference between blended, paid and fully loaded CAC.
Sep 19, 20266 min readBurn rate is how fast a company uses cash. This page gives the gross and net burn formulas, works six months of a software company's bank data with the Excel formulas, turns net burn into runway on a stated average, proves the figures by walking opening cash to closing cash, and covers the burn multiple.
Sep 17, 20266 min readProduct funnel analysis compares signup cohorts through a defined activation sequence. Use prepared usage summaries, exact spreadsheet formulas, and a reconciliation to locate the transition that needs investigation.
Sep 16, 20266 min readSaaS user analytics connects supplied usage summaries with account renewals and revenue. Define active users, build a consistent renewal cohort and reproduce adoption and renewal comparisons in a spreadsheet.
Sep 15, 20265 min readBuild a customer-month SaaS revenue forecast from retention, contraction, expansion and new sales. Separate recurring run rate from recognized revenue and reconcile the plan with actuals.
Sep 14, 20265 min readConvert a constant monthly churn rate into compounded annual churn. Follow a complete customer-cohort example, distinguish projected losses from observed losses, and check the result against monthly subscription exports.
Sep 11, 20265 min readA product management report connects adoption and retention changes with commercial results and accountable follow-up. Build a recurring review from customer, usage, and revenue exports, with a worked comparison and spreadsheet formulas.
Sep 11, 20265 min readSaaS FP&A connects recurring revenue with delivery costs, acquisition spending and department budgets. Build a monthly review from revenue and ledger exports, calculate the variance bridge and check that cohort and department totals reconcile.
Sep 10, 20265 min readAverage SaaS churn depends on customer size, contract term, renewal opportunities and revenue definitions. Work through a billing-export example that separates logo losses, renewal losses and the recurring revenue bridge.
Sep 8, 20265 min readSaaS onboarding KPIs connect checklist completion, activation time, and later usage. Compare signup cohorts with an account-level example and checks that keep unfinished cohorts out of the results.
Sep 7, 20265 min readBuild reproducible product-user groups from signup dates and recorded usage. Compare their counts, subsequent retention and recurring revenue, with spreadsheet formulas and reconciliation checks.
Sep 3, 20266 min readHow SaaS companies should choose analytics software: start from the questions, check the data you hold, ask vendors ten questions, avoid the traps.
Sep 2, 20264 min readAverage revenue per user divides a defined revenue amount by the matching user population. Work the formula by plan, reconcile the total and separate revenue changes from changes in user activity.
Sep 1, 20265 min readThe honest answer to what share of contracted seats or licenses should be in use: the 70 to 85 percent figures quoted depend on what active means, on the time since the contract started, and on how use is spread across the account, because a customer at 80 percent with all use in one team is a different renewal from one at 60 percent spread across five. This page gives the ranges, the three measurable things that set the right figure for one base, and the table to compute before anyone quotes a percentage.
Aug 27, 20263 min readThe honest answer to what net revenue retention a company should have: the widely quoted 100 percent floor and 120 percent aspiration are SaaS investor figures that depend on segment, contract structure and what is counted as expansion. This page gives the ranges by segment, the three measurable things that set the right figure for one base, the cohort, the gross retention underneath, and the expansion source, and the table to compute before anyone quotes a percentage.
Aug 26, 20263 min readConsumption-based pricing charges customers for measured usage. Compare pricing structures, work through tiered charges and gross margin, and reconcile usage to billing before interpreting growth.
Aug 16, 20266 min readA SaaS financial model workbook connects subscribers, subscription revenue, delivery costs, spending and cash. Use this layout and worked formulas to build checks and compare supplied model outputs with actual results.
Aug 16, 20266 min readBuild a subscription cash forecast from billing, customer collection dates and operating payments. A worked example separates annual prepayments from revenue and shows how a delayed renewal changes cash headroom.
Aug 15, 20265 min readThe ten customer base KPIs a B2B SaaS company should run on, each with its formula, the export it comes from and what it tells you: net revenue retention by cohort, gross revenue retention, seat utilization before renewal, whitespace reconciled to ARR, expansion pipeline against whitespace, untouched accounts by ARR, time to value, renewal calendar coverage, expansion by source, and ARR concentration. Also the three measures most SaaS teams miss, the figures to drop, the identities, and who owns what.
Aug 11, 20264 min readBuild SaaS financial projections from customer movements, pricing, delivery costs and hiring assumptions. Follow a monthly spreadsheet example, reconcile cash and receivables, and compare the projection with actual performance.
Aug 11, 20265 min readA software company's conventional cash cycle can miss the effect of advance subscription billing. Compare receivable and payable days with billings, collections and deferred revenue before judging the cash position.
Aug 9, 20265 min readHow a SaaS company turns the hand-colored whitespace spreadsheet into a computed, valued list per account: fit from what similar customers own, the gap at list price, untouched accounts from CRM activity, AE capacity, and the reconciliation to ARR.
Aug 7, 20263 min readHow to build the untouched accounts report from Salesforce or HubSpot activity: which accounts in each territory have had no two-way contact in the window, ranked by ARR and renewal date, per AE and CSM, with the capacity check that turns it from a list into a plan.
Aug 5, 20263 min readHow a SaaS customer success team finds the onboarding milestone that most separates renewed from churned accounts, from the usage export, the onboarding log and the renewal outcomes: days to each milestone per account, first-renewal retention by whether and when the milestone was reached, the milestone with the largest separation, the accounts in onboarding now that are past its typical day without reaching it, and the honest statement that it is an association.
Aug 5, 20263 min readThe ten questions a SaaS chief revenue officer puts to the sales and success teams about existing customers, what is net revenue retention by cohort and which cohort broke, which accounts renew inside 120 days under their seats, is the expansion pipeline on the accounts with whitespace, which onboardings are behind the milestone that predicts renewal, what is whitespace reconciled to ARR, which accounts are over their cap, which accounts have gone untouched, what do bookings, billings and revenue each say, which deals slipped three times, and what changed, each with the table from the subscription ledger, the usage export and the CRM, and the answer to send back.
Jul 31, 20262 min readHow a SaaS revenue team turns product usage and the contract register into a renewal risk and expansion list: active seats against contracted seats per account, the utilization trend over the last two quarters, the accounts under a threshold with a renewal inside 120 days, the accounts at or above their seat cap, and the identity that ties the seat table to ARR.
Jul 24, 20262 min readCompare commission payouts under explicit usage-revenue rules. Build a workbook from approved usage, credited revenue and payout assumptions, then test timing, rate changes and reconciliation checks.
Jul 18, 20265 min readConnect SaaS acquisition spending to pipeline, won customers and recurring revenue from matched exports. Keep bookings, recognized revenue and ARR separate, and compare cohorts with the same observation window.
Jul 15, 20265 min readHow a SaaS finance or revenue team computes net revenue retention per signing cohort from the subscription ledger, the four movements that make it up, expansion, contraction, churn and reactivation, the identity that ties every cohort's movements back to the ARR bridge, and why a single company NRR figure hides the cohort that is quietly failing.
Jul 12, 20262 min readHow a SaaS revenue team checks whether its expansion pipeline covers the whitespace the account data shows: expansion opportunities per account against the account's valued whitespace, the accounts with large gaps and no open opportunity, the opportunities on accounts with no gap, the share of whitespace value under active pursuit per rep, and the identity that ties expansion pipeline to the whitespace grid.
Jun 30, 20263 min readSoftware analytics for your business.
See the page