Skip to content

Dashboard templates

Technology · Marketing

Subscription software (SaaS) company running B2B marketing (search ads, LinkedIn, webinars, trade shows, content, referral partners). MRR, trials and churn, plus the marketing funnel: spend, leads, CPL, CAC, budget, and marketing efficiency against new MRR and ARPA.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For B2B marketing at SaaS companies: search, LinkedIn, webinars, trade shows, content and partners. The "Marketing and MRR" dashboard shows marketing spend over new MRR and marketing CAC payback months. The "Campaigns and budget" and "Marketing funnel" dashboards track spend, leads, MQLs, CPL, CAC and lead-to-customer rate, with the MRR and trial dashboards right alongside. Needs account, subscription, MRR movement, MRR snapshot, daily marketing spend and lead data.

Use this template to

  • Know how many months it takes to earn back the cost of winning a customer.
  • Stop channels with a cheap CPL whose leads never convert to paid.
  • Set the quarterly budget by marketing spend over new MRR.

6 ready-made dashboards

Marketing and MRR

Marketing cost versus new MRR, and the months of average revenue per customer needed to recover acquisition cost.

  • Marketing spend
  • New MRR
  • Marketing spend to new MRR
  • Marketing CAC payback (months)
  • Monthly marketing spend to new MRR
  • Monthly CAC payback months
  • CAC by campaign

Marketing funnel

Cost, leads, qualification rate, new customers and cost per new customer by channel and source.

  • Marketing spend
  • Leads
  • Cost per lead (CPL)
  • Customer acquisition cost (CAC)
  • Funnel by marketing channel
  • Lead qualification rate by source
  • Lead-to-customer rate by source
  • Weekly leads by channel

Campaigns and budget

Budget, cost, budget utilization and performance of each marketing campaign.

  • Budget utilization
  • New customer value to spend (marketing ROI)
  • New customers from marketing
  • Click-through rate (CTR)
  • Results by campaign
  • Budget utilization by campaign
  • Cost per new customer by channel
  • Weekly marketing cost by channel

MRR overview

Average MRR, new, expansion and churned MRR, and paying customers of a subscription software company.

  • Average MRR
  • Net new MRR
  • Average paying accounts
  • Average revenue per account (ARPA)
  • MRR movement by segment
  • Month-end MRR by segment
  • Net new MRR by plan

Retention and trials

Churned customers, lost MRR, trial conversion rate and product usage.

  • Logo churn rate
  • Churned MRR
  • Trial conversion rate
  • Daily active users (average)
  • Retention by plan
  • Monthly churned MRR by plan
  • Trial conversion rate by plan
  • Weekly daily active users

Billing and collections

Subscription invoice amounts issued and collection rate by segment and billing cycle.

  • Invoiced amount
  • Invoice collection rate
  • Collection rate by segment
  • Amount invoiced by billing cycle
  • Monthly amount invoiced by segment

Ask Si as soon as the build finishes

  • “How did marketing CAC payback (months) change compared with last month?”
  • “What is driving marketing spend to new MRR this quarter?”
  • “Show campaign budget by month for the last six months.”
  • “Where is budget utilization highest this month, and why?”

33 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Marketing CAC payback (months)Marketing cost to acquire one new customer (CAC) divided by average recurring revenue per paying account (ARPA): the number of months of an average customer's revenue needed to recover the cost of acquiring them.= Customer acquisition cost (CAC) / Average revenue per account (ARPA)Number
Marketing spend to new MRRMarketing campaign cost divided by new MRR in the period: how many months of new MRR are needed to cover marketing spend. Lower means marketing brings in recurring revenue efficiently.= Marketing spend / New MRRNumber
Campaign budgetTotal budget of campaigns starting in the period. The full campaign budget is recorded on its start date.Currency
Budget utilizationMarketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budgetRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
New customer first-order valueTotal value of the first transaction of leads converted in the period, by conversion date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
LeadsNumber of leads (prospects) created in the period, by creation date.Count
MQL rateMarketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / LeadsRatio (%)
Marketing-qualified leads (MQL)Leads created in the period that passed marketing qualification (status MQL, SQL or converted to customer).Count
New customers from marketingLeads that became customers in the period, by conversion date. Converted leads with no conversion date fall in no period.Count
New customer value to spend (marketing ROI)New customer first-order value divided by marketing spend. Above 1 means first orders have covered the cost.= New customer first-order value / Marketing spendNumber
Marketing spendTotal cost of marketing campaigns by spend date.Currency
Average revenue per account (ARPA)Average MRR per paying account = total MRR across snapshots divided by the number of paying-account occurrences in those snapshots.= tech_mrr_snapshot_total / tech_paying_account_snapshotsCurrency
Daily active users (average)Average number of active users per day in the period = total daily active users divided by the number of days.= tech_active_user_days / tech_usage_daysNumber
Average MRRAverage monthly recurring revenue in the period = total MRR across month-end snapshots divided by the number of snapshot dates.= tech_mrr_snapshot_total / tech_snapshot_countCurrency
Average paying accountsNumber of accounts with positive MRR, averaged over the month-end snapshots in the period.= tech_paying_account_snapshots / tech_snapshot_countNumber
Churned accountsAccounts with at least one churn event (subscription cancellation) in the period.Count
Churned MRRTotal MRR lost from customers cancelling their subscriptions in the period, as a positive number.Currency
Invoice collection rateAmount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amountRatio (%)
Contraction MRRTotal MRR decrease from retained customers (fewer seats, plan downgrades) in the period, as a positive number.Currency
Expansion MRRTotal MRR increase from existing customers (more seats, plan upgrades) in the period.Currency
Invoiced amountTotal amount of subscription invoices issued in the period (by issue date).Currency
Logo churn rateChurned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accountsRatio (%)
Net new MRRNew MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRRCurrency
New MRRTotal MRR from subscriptions that start paying in the period (events of type new), by effective date.Currency
Trial conversion rateTrials converted to paid divided by trials started in the period.= Trials converted / Trials startedRatio (%)
Trials convertedSubscriptions that started a trial in the period and converted to paid (up to the data cut-off date).Count
Trials startedSubscriptions that started a trial in the period (by trial start date).Count

Data you need

Required

account, subscription, mrr_movement, mrr_snapshot, mkt_spend_daily, mkt_lead

Add if you have it (unlocks more metrics)

plan, invoice, usage_daily, mkt_campaign

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: account, subscription, mrr_movement, mrr_snapshot, mkt_spend_daily, mkt_lead.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 6 dashboards and 33 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Technology · Marketing with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes