Your CRM tracks deals. Your marketing platform tracks clicks. But neither tells you the full story. Here’s why a Business Intelligence tool is the missing layer in your revenue stack.
The Problem With Working in Silos
Most growing businesses have a CRM (HubSpot, Salesforce, Zoho take your pick) and a marketing automation platform (Mailchimp, Mautic, ActiveCampaign). They generate mountains of data every single day leads created, emails opened, deals closed, campaigns run.
But here’s the uncomfortable truth: most teams are only seeing a fraction of that data, filtered through pre-built reports that answer yesterday’s questions.
You can see your open rate. You can see your pipeline value. What you often can’t see is:
- Which lead source produces the highest lifetime value customers?
- At which stage are leads most likely to go cold and why?
- Is your top-performing campaign actually producing revenue, or just clicks?
- How does sales cycle length vary by industry, region, or persona?
These aren’t exotic questions. They’re the questions that drive better decisions. And answering them requires a Business Intelligence (BI) tool sitting across your data not inside it.
What a BI Tool Actually Does
A BI tool connects to your underlying data sources your CRM database, your marketing platform, your website analytics, your ad spend and lets you query, blend, and visualise that data on your own terms.
I’ve personally worked with two tools that stand out for different reasons: Metabase for self-hosted, on-premise deployments where data privacy and control matter, and Preset (the cloud-hosted version of Apache Superset) for teams that want a powerful, fully managed BI environment without the infrastructure overhead.
Unlike the built-in reporting inside your CRM or marketing tool, a BI layer gives you:
- Cross-source analysis — combine CRM deal data with email engagement and ad spend in a single view
- Custom metrics — define revenue per lead, cost per qualified opportunity, or churn signals your CRM doesn’t natively track
- Historical trend analysis — see how your funnel has evolved over quarters, not just snapshots
- Self-serve exploration — let marketers, sales managers, and executives answer their own questions without waiting on a developer
The Gaps Your CRM Report Won’t Show You
1. The Lead Source ≠ Revenue Fallacy
Most CRMs show you lead volume by source. But volume is vanity. A BI tool lets you trace each lead source through to closed-won revenue, average deal size, and sales cycle duration. You might find that your Google Ads campaign brings 3× the leads of your LinkedIn outreach — but LinkedIn deals close at twice the value in half the time.
Without cross-referencing sources with deal outcomes, you’ll keep optimising for the wrong metric.
2. Campaign Attribution Beyond Last-Touch
Marketing platforms typically report on the last touchpoint before conversion. A BI tool lets you build multi-touch attribution models — understanding which combination of touchpoints (cold email → nurture sequence → webinar → demo request) actually produces revenue, not just which one got credit.
3. Sales Funnel Drop-Off Analysis
Your CRM can tell you how many deals are in each stage. A BI tool can tell you which deals are stuck, for how long, and what characteristics they share — company size, lead source, sales rep, industry. That’s the difference between a pipeline report and a pipeline diagnosis.
4. Marketing Spend vs. Revenue Contribution
If you’re running paid ads, email campaigns, and content marketing simultaneously, you need a single view of spend versus pipeline contribution versus closed revenue. Your marketing platform doesn’t know about closed deals. Your CRM doesn’t know about ad spend. Only a BI tool sitting across both can show you true return on marketing investment (ROMI).
A Practical Example: CRM + Mautic + Metabase or Preset
Imagine you’re running outbound campaigns via a tool like Mautic, managing your pipeline in a CRM like HubSpot or SuiteCRM, and you want to answer this question:
“Which email sequences are generating the most revenue-qualified pipeline?”
Your marketing platform shows opens, clicks, and replies. Your CRM shows deal stages and values. Neither answers the question on its own.
Here’s how I approach it in practice: I use Metabase connected to my self-hosted CRM and Mautic databases for day-to-day operational dashboards it’s fast to set up, the no-code query builder is accessible to non-technical teammates, and keeping it on-premise means sensitive contact data never leaves my infrastructure.
I even use Preset. Being cloud-hosted, Preset makes it easy to collaborate without needing to expose internal servers, and its Apache Superset foundation gives it serious horsepower for complex SQL-based charts and cross-source datasets.
Point either tool at both data sources, write a simple SQL join on contact email address, and suddenly you have a table like this:
| Email Sequence | Contacts Enrolled | Replies | Deals Created | Pipeline Value |
|---|---|---|---|---|
| Fintech Outbound v2 | 240 | 18 | 7 | $42,000 |
| Generic Cold v1 | 580 | 22 | 4 | $9,200 |
| Engineering Manager Flow | 150 | 14 | 9 | $61,000 |
That single table changes your entire campaign strategy. You’d never see it inside either platform alone.
Metabase vs. Preset Which One Should You Use?
Both tools are excellent, but they serve slightly different needs:
| Metabase | Preset | |
|---|---|---|
| Hosting | Self-hosted (open source) or cloud | Fully managed cloud |
| Best for | Data privacy, on-prem control, small teams | Collaboration, sharing, scale |
| Query interface | No-code + SQL | SQL-first with visual layer |
| Cost | Free (self-hosted) | Free tier + paid plans |
| Setup effort | Low (Docker-friendly) | Very low (SaaS) |
My recommendation: start with Metabase if you’re self-hosting your stack and want to keep data in-house. Move to or complement with Preset when you need to share dashboards across teams or with clients without VPN access.
When Should You Add a BI Tool?
You don’t need a BI tool on day one. But you probably need one sooner than you think. Consider adding one when:
- You have more than one source of customer data that you wish you could combine
- You’re spending time manually exporting and merging spreadsheets to build reports
- Leadership is asking questions your CRM dashboards can’t answer
- You’re scaling paid marketing spend and need to justify ROI with precision
- You want your marketing and sales teams working from a single source of truth
The Bottom Line
Your CRM is your operational tool. Your marketing platform is your execution engine. A BI tool is your intelligence layer — the place where raw activity data becomes strategic insight.
The teams winning in competitive markets aren’t the ones with the most leads or the most campaigns. They’re the ones who understand what’s actually working — and double down on it fast.
Whether you go with Metabase for a self-hosted setup or Preset for a managed cloud environment, adding a BI layer to your CRM and marketing stack isn’t a luxury. For any team serious about data-driven growth, it’s a foundation.
Have questions about setting up a BI layer across your CRM and marketing stack? This is exactly the kind of technical marketing infrastructure I help teams build — feel free to reach out.
