CUSTOM DASHBOARDS VS SAAS: WHEN A CSV BEATS A $200/MO TOOL

Operations teams discover the dashboard problem in three stages. Stage one: nobody has time to make the report. Stage two: they buy a $200/mo analytics SaaS that promises to make it automatic. Stage three: 6 months later, nobody's opened it in a week and it's still being paid for.

Most teams reach for a SaaS dashboard when one of three cheaper things would have actually solved the problem. Here's the decision tree.

QUESTION 1: WHO ACTUALLY LOOKS AT IT?

If the answer is "one person, once a week," you do not need a dashboard. You need a Monday-morning CSV export in their email. Build that, save $200/mo, move on.

If the answer is "the leadership team, every day," or "every store manager checks their numbers," you might need a real dashboard. Keep reading.

QUESTION 2: HOW WEIRD IS THE METRIC?

The off-the-shelf SaaS (Looker, Metabase, Power BI, Mixpanel) is cheapest when your metric is the metric everyone tracks: revenue, sign-ups, churn, page views. The math is built in. Point it at your data, done.

But once your metric is weird, like "revenue per fulfilled order excluding refunds, by region, only for SKUs over $50", you spend more configuring the SaaS than you saved by not building custom. We've seen operations teams spend 60 hours making a $200/mo tool answer the same question a 200-line custom page would have answered cleanly.

QUESTION 3: IS THE ACTION OBVIOUS FROM THE NUMBER?

A dashboard is only useful if seeing a number triggers a clear action. "Inventory of widget X is below 50" → reorder. "Response time is over 4 hours" → pull a second person in.

If looking at the number doesn't change what anyone does, you don't have a metric. You have a vanity number. Most SaaS dashboards are 90% vanity. Custom dashboards force you to design for the action.

THE THREE CHOICES, RANKED BY COST

• $0: CSV in email. Best for one-reader, once-a-week views. A scheduled query and a Mailgun account is all you need.
• $0–$30/mo: Metabase / Superset self-hosted.Best for standard metrics + a small team. Open-source. Free if you already run a VPS.
• $200/mo+: SaaS analytics (Looker, Power BI, Mixpanel).Best if you need shared admin, RBAC, embedded reporting for hundreds of users. Overkill for a 5-person team.
• $5k–$15k one-time: custom dashboard.Best when the metric is weird, the action is operational, and the team is small enough that a SaaS is overkill. Pays back vs the SaaS within ~30 months at $200/mo. Owns the data.

WHEN WE'LL BUILD YOU CUSTOM (AND WHEN WE WON'T)

We'll build custom when: the metric is operational (drives action), it's weird (specific to your business), and the team looking at it is small enough that a SaaS license stack is overkill. Typical scope: $5k–$15k for an owned dashboard with auth, a few key views, and email alerts.

We'll tell you to use Metabase or Power BI when: you have standard metrics, your team is technical enough to maintain the config, and you'd rather rent than own. We've walked away from at least 4 dashboard projects we should have lost on principle.