KPI dashboard template
A KPI dashboard template built around one metric and a target
One KPI, split by the dimension you care about, measured against a target column. Download the sample, or open it in the studio and swap in your own export.
- Sample rows
- 18 across 6 months
- Comparison
- Target column drives the delta
- Format
- Currency, switchable per blueprint
One KPI at a time, on purpose
A KPI blueprint here reports a single metric split by a single dimension across periods. If you track five KPIs, that is five blueprints — which keeps each card unambiguous about what it is summing and what it is comparing against.
Targets are a column, not a setting
The target lives in the CSV next to the actual, so it moves period by period and segment by segment. The headline card compares the sum of actuals against the sum of targets; when a row has no target the row still validates and the comparison simply covers fewer rows.
Columns this template expects
Six months of closed-won revenue split by sales segment, with the monthly target in its own column so the KPI reads against a baseline. Column names are yours to change — the mapping step is what connects your headers to these four roles.
| Column | Role | Required | Rule |
|---|---|---|---|
month | Date | Required | One period per row. Any parseable date orders the trend chronologically; unparseable labels fall back to alphabetical order. |
segment | Category | Required | The dimension the KPI is split by. Empty cells are rejected before saving. |
closed_won | Value | Required | The KPI itself. Currency symbols, thousands separators, and bracketed negatives are parsed; anything without a digit is rejected. |
target | Comparison | Optional | Optional baseline. Rows without a comparison value are still valid; the KPI card then says no comparison data is available. |
The sample file, and what it fails on
The first rows of the downloadable CSV are on the left. On the right are the messages the live validator returns for a copy with an empty cell and a non-numeric metric — generated by the same code that checks your own import.
month,segment,closed_won,target
2026-02-28,Enterprise,148000,140000
2026-02-28,Mid-market,96500,105000
2026-02-28,Self-serve,42750,40000
2026-03-31,Enterprise,162400,150000
2026-03-31,Mid-market,101200,108000
2026-03-31,Self-serve,45300,42000
…- Row 3Date value is empty.
- Row 4Metric value is not numeric.
The preview this file produces
Rendered from the sample CSV by the same projection that builds a share link: totals, the date-ordered trend, the ranked category mix, and the most recent mapped rows.
Agency REPORT
Sample: Fieldline Group
SAMPLE PREVIEW18 validated rows
Performance trendClosed won over time
02-2803-3104-3005-3106-3007-31
Category mixContribution
Enterprise
$982.9K
Mid-market
$680.1K
Self-serve
$287.3K
Recent published recordsBounded share snapshot
2026-07-31Self-serve$55,450.00
2026-07-31Mid-market$129,300.00
2026-07-31Enterprise$176,900.00
2026-06-30Self-serve$51,200.00
Sample data written for this template. It is not a customer dataset, and no figure on it is a DashTrellis result claim.
How the workflow works
Move from the search problem into a working product without a fake demo or an invented integration.
Step 1
Import and validate
Paste or upload a bounded CSV, inspect row and column errors, and start from original sample data when useful.
Step 2
Map the story
Choose a supported blueprint, map dimensions and metrics, and preview KPIs, trends, category mix, and recent rows.
Step 3
Save or share
Keep versioned private configurations, export JSON or CSV, and create a revocable public snapshot containing bounded projected data.
Current product boundaries
Useful SEO starts with an accurate promise. These limits apply before you begin.
- DashTrellis does not provide live data connectors, scheduled refreshes, Looker Studio import, or team collaboration.
- Public links contain bounded aggregates and recent mapped rows, never the uploaded raw CSV or private version history.
- The template library is intentionally small and original rather than a mass of programmatic industry pages.
Questions about kpi dashboard template
Can I track several KPIs on one page?
No. One value column per blueprint. Create a separate blueprint for each KPI, or roll the KPIs into a single comparable metric before you export.
What if my KPI is a percentage or a rate?
Set the value format to percent. Note that the total card sums the rows, so a rate is best reported as its underlying count unless a sum is meaningful.
Can I set an alert when a KPI misses target?
No. There are no alerts, thresholds, or notifications — the dashboard shows the gap, it does not watch it for you.