Marketing analytics SaaS teams can tie to revenue

Marketing analytics for SaaS connects acquisition spend to opportunities, won customers and recurring revenue from the same acquisition cohort. Start with campaign, CRM and subscription exports, then match the revenue to finance records. Keep bookings, recognized revenue and annual recurring revenue separate throughout the report.

Give each measure a specific job

Marketing needs to know which acquisition activity brings accounts worth pursuing. Sales needs to know whether those accounts become qualified opportunities and customers. Finance needs to know what the company has actually recorded and which costs the comparison includes.

Those questions need different measures:

Created pipeline here means original unweighted opportunity value, including opportunities that later won, lost or remained open. It is neither a probability-weighted forecast nor an amount to add to bookings.

For the earlier steps of the sales journey, use the separate guide to B2B marketing analytics. This report follows those acquisition records into SaaS commercial outcomes.

Build comparable acquisition cohorts

Define acquisition as the first qualifying new-account response, not every contact or campaign touch. Give each account a stable company ID and one primary acquisition source. Keep additional touches in a separate view so the additive source report does not count the same customer repeatedly.

Export the source, first qualifying response date, opportunity ID, opportunity creation value, close status and account ID. Finance supplies signed bookings, recognized revenue and recurring subscription amounts keyed to the account. Remove existing-customer expansions from this new-acquisition comparison.

Use the same entry month and reporting cutoff across sources. The example below follows January 2026 entrants through June 30, 2026. Both source cohorts have the same calendar exposure; accounts can still enter at different points in January, so review entry dates before treating a small difference as meaningful.

Work the figures from the same rows

A US subscription software company compares paid search with educational webinars. These are illustrative company records, in USD. The campaign costs include the stated acquisition activities, without claiming to include all sales and marketing overhead.

With these columns in A:F and the first source in row 2, calculate opportunity conversion, entrant-to-customer conversion and spend per won customer:

=D2/C2
=F2/C2
=B2/F2

Format conversion cells as percentages. Totals divide the summed numerators by the summed denominators, rather than averaging source percentages.

Webinars have stronger recorded conversion and lower campaign spend per won customer in these rows. That last measure is not fully loaded CAC: the separate customer acquisition cost guide explains the broader cost boundary.

Separate the contract from the revenue

For the same won customers, finance supplies these amounts through the June cutoff. MRR is eligible recurring subscription revenue at June 30 under the company's policy. In this example ARR equals MRR multiplied by twelve; implementation fees are excluded from MRR and ARR.

Bookings reflect signed contract value, including eligible nonrecurring charges in this company's definition. Recognized revenue follows the finance schedule and service timing. Ending ARR annualizes the eligible recurring run rate at the cutoff. These amounts describe different things and should never be added together.

To assemble source totals from a prepared account worksheet, put source in column B, signed bookings in C, recognized revenue in D and ending MRR in E. With the desired source in H2:

=SUMIFS(C2:C1000,B2:B1000,H2)
=SUMIFS(D2:D1000,B2:B1000,H2)
=SUMIFS(E2:E1000,B2:B1000,H2)*12

Microsoft's SUMIFS documentation describes summing values that satisfy specified criteria. Use only the prepared cohort rows in this worksheet; otherwise a source match can pull in customers from another period.

Prove the report before moving budget

The first check is membership: the account worksheet must contain unique eligible accounts. With a won flag in column F, the customer count for the source in H2 is:

=COUNTIFS(B2:B1000,H2,F2:F1000,1)

Microsoft's COUNTIFS documentation confirms that all criteria must be met. It counts qualifying rows, so account deduplication must happen before this formula.

Next reconcile the $72,000 spend to the cost schedule, $63,750 recognized revenue to the cohort's finance records and $25,500 MRR to eligible subscriptions. The ARR check is $25,500 multiplied by twelve, giving $306,000. Keep unmatched accounts outside the source comparison and show their amounts separately until resolved.

The report supports a review of webinar audience quality and sales follow-up. It does not prove that expanding webinar spending would reproduce the same results. For subscription retention after acquisition, use the existing SaaS CRO questions about the base.

Where SaaS acquisition reporting goes wrong

• Mixing clocks. This month's campaign spending divided by this month's wins can compare unrelated acquisition cohorts.
• Repeating account revenue. Joining several contacts or opportunities to an account can multiply its subscription amount.
• Treating pipeline as sales. Original opportunity value includes deals that may never close.
• Calling ARR recognized revenue. The annualized ending run rate does not describe revenue already recorded during the observation period.
• Ignoring cost scope. Campaign spend per won customer cannot answer a fully loaded acquisition-cost question without the missing expenses.

Covirage is not affiliated with Microsoft.

Compare your SaaS acquisition cohorts in Covirage

Bring a sample of your own campaign, CRM and finance exports; Covirage maps the columns, and its tools compute and check the cohort figures. The external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.

See analytics for SaaS sales teams for the business context.