How to Build Custom Metrics in Sparkforge Dashboards
Custom Metrics let you define KPIs by combining data from multiple sources with your own formulas. Add them as widgets to any dashboard or report, and push them to other sub-accounts via snapshots.
Custom Metrics turn your dashboard into a calculator. Instead of exporting data to a spreadsheet to compute conversion rate, ROI, or cost per acquisition, you build the formula once and Sparkforge displays the result as a widget.
This feature is available on plans $497 and above.
What Custom Metrics do
You combine up to four metrics from different data sources, apply mathematical operators and constants, and pick how the result displays — integer, float, currency, or percentage. Custom Metrics work in dashboards, custom reports, and snapshots, so the same KPIs follow you wherever you report.
Build a Custom Metric
- Open Dashboard from the left menu.
- Click the Edit Dashboard icon (top right) to enter edit mode.
- Click Add Widget, then select the Custom Metrics tab.
- Click + Create Custom Metrics.
- Choose Start from scratch or Clone existing, then click Select.
- Fill in the metric details and formula (covered below).
- Click Create to save.
Metric details
- Metric Name — A clear label like Revenue Growth Rate.
- Data Type — Integer, Float, Percentage, or Currency.
- Description — A short explanation so your team understands the KPI.
Formulas
The formula field combines metrics with operators (+, -, ×, ÷) and constants. Example: divide Won Opportunities by New Leads, multiply by 100, and display as a percentage to get a Conversion Rate.
Advanced settings: date properties
Each metric in your formula can have its own date property. The dropdown options change based on the metrics you picked. For a conversion rate measuring visits-to-bookings within the same window, match Page Views (Visited On) with Appointments (Created On).
Comparison value (trend direction)
Decide whether an increase or a decrease should display as a positive trend.
- Increase is positive — Use for revenue, appointments, leads.
- Decrease is positive — Use for response time, churn rate, complaint volume.
Set this incorrectly and your dashboards will mislead the team — marking longer response times as a positive trend, for example.
Reuse across sub-accounts
Custom Metrics can ride along in snapshots. Formulas stay intact when the destination sub-account has access to the same data sources and fields. Missing fields cause the metric to display but not calculate until they're mapped.
Frequently Asked Questions
Can I combine metrics from sources with different date properties?
What happens if I clone a metric and the source data changes?
Do trend direction settings affect calculation?
Will Custom Metrics survive a snapshot push?
Which plans include Custom Metrics?
Was this article helpful?
Thanks for the feedback.