← Back to Blog

Engineering

Your Sales Team Deserves Better Than Standard Dashboards — Here's How We Build Them with Claude Code

If you’ve spent any time in a complex Salesforce org, you’ve hit the wall. Twenty dashboard components. Five dynamic dashboards on Enterprise edition. No cross-object joins without report types you have to beg an admin to create. You start layering workarounds on top of workarounds, and before long your “reporting solution” is a spreadsheet someone exports every Monday morning.

We see this pattern constantly. A client’s Salesforce instance has grown past the point where standard dashboards can keep up, but they’re not ready to license Tableau CRM (now CRM Analytics) at $75+ per user per month just to see their pipeline data the way they need it.

There’s a middle path: custom Lightning Web Component dashboards. And with Claude Code, we’re building them in hours instead of days.

Custom LWC executive dashboard showing goal tracking, pipeline coverage, and sales trends A custom LWC executive dashboard — unlimited components, real-time data, interactive charts, and role-based views. No CRM Analytics license required.

Where Standard Salesforce Dashboards Fall Short

Let’s be specific about what breaks. These aren’t edge cases — they’re everyday needs for any org past a certain complexity:

  • The 20-component limit. If your executive team needs a single view that covers pipeline, team activity, case resolution, and revenue metrics, you’re already over budget. You end up splitting into multiple dashboards, which nobody wants to flip between.
  • No real-time data. Standard dashboards refresh on a schedule. Your ops team is making decisions on stale numbers, and they know it.
  • Limited interactivity. You can’t click into a pipeline stage and drill down into the underlying opportunities, filter by rep, and see trend lines — all in the same view. Standard dashboards are static snapshots.
  • Cross-object reporting gaps. Want to show how Case resolution time correlates with Account renewal rates? Standard reports can’t do that without custom report types, and even then the joins are limited.
  • No conditional logic. You can’t show different KPIs to different roles, highlight at-risk accounts dynamically, or color-code metrics based on thresholds without hardcoding report filters.
  • Mobile experience. Standard dashboards on mobile are, to put it generously, functional. Not useful.

If any of this sounds familiar, you’ve already been thinking about custom solutions. The question is how to build them without a six-month project timeline.

Why LWC Is the Right Answer

Lightning Web Components sit on the web standards stack — native JavaScript, HTML templates, CSS. They render fast, they’re composable, and they live inside Salesforce’s security model. No iframe hacks, no external hosting, no SSO gymnastics.

For dashboards specifically, LWC gives you:

  • Unlimited components. Build as many widgets as you need in a single page.
  • Wire service for real-time data. Components react to data changes without manual refreshes.
  • Chart.js, D3, or any JavaScript library. Upload to Static Resources and render any visualization you can imagine.
  • Role-based rendering. Show different data based on the user’s profile, role, or custom permissions.
  • Mobile-first design. LWC components are responsive by default if you build them that way.
  • Record-level actions. Click a metric, open the record, take action — all without leaving the dashboard.

The tradeoff has always been time. A custom LWC dashboard with four or five interactive widgets, an Apex controller for aggregated data, and proper error handling used to take a developer two to three weeks. That’s where the math gets interesting.

How Claude Code Changes the Build

We started using Claude Code for Salesforce development about a year ago. The impact on LWC dashboard work specifically has been significant — not because it writes perfect code on the first try, but because it eliminates the tedious parts and lets us focus on architecture.

Here’s what a typical dashboard build looks like — including the actual prompts we use.

Step 1: Let Claude Study Your Current Reporting

Before building anything, we point Claude Code at the client’s existing Sales Management dashboard and related reports. Claude acts as a data engineer and sales ops specialist — it understands Salesforce’s data model, knows what metrics matter for sales leadership, and can spot opportunities to tell a better story with the data.

Prompt:

Look at our Sales Management dashboard and all the reports it
references. I want to understand what our sales leadership is
tracking today — the metrics, the groupings, the filters, how
they're thinking about pipeline and forecasting.

Claude Code connects to the org via SF CLI, pulls the dashboard metadata and every underlying report, and comes back with a breakdown: here’s what you’re tracking, here’s how the data relates, here’s where your current reports are doing the job and where they’re falling short.

Prompt:

We want to build something better than this. Think like a sales
ops analyst. What metrics should we be combining that we're
looking at separately today? How can we tell a clearer story
about whether we're going to hit our number?

This is where it gets interesting. Claude doesn’t just list components — it thinks about the data strategically. It might suggest combining closed-won revenue and forecast pipeline into a single progress bar so leadership sees the full picture at a glance, or overlaying this year’s actual sales curve with last year’s results and the current forecast on the same chart so trends jump off the screen. These are the kinds of insights that make people buy Tableau or Clari. You’re building them natively in Salesforce.

Step 2: Design the Dashboard

With Claude’s analysis in hand, you describe what you want to see. Not in technical terms — in business terms.

Prompt:

Build me an LWC dashboard with tabs for different views: Overview
& Goals, Pipeline, Forecast & Closed Won, and Leads & Accounts.

For the Overview tab, I want to see:
- Goal tracking for the fiscal year. Show closed won YTD, forecast
  pipeline, gap to goal, and where we were this time last year.
- Break the goal down into Land (net new) and Expand with separate
  progress bars showing closed vs forecast coverage.
- A sales chart that overlays this year's actual closed won, this
  year's forecast, and last year's numbers on the same line chart
  so we can see the trajectory.
- A pipeline chart comparing this year vs last year over time.

Claude Code takes this and builds everything — the Apex controller with the right aggregations, the LWC components, the tab navigation, the charts. It knows it needs to combine closed-won actuals with forecast pipeline data into unified visualizations. It handles the Chart.js Locker Service workarounds, the wire service patterns, the responsive CSS.

Custom LWC executive dashboard showing goal tracking, pipeline coverage, and sales trends The Overview & Goals tab — goal tracking with Land vs Expand breakdown, year-over-year sales overlay, and pipeline comparison. All built from a plain-English prompt.

Step 3: Add Predictive Analytics

This is where you leave standard dashboards in the dust. The same data that sits in your Salesforce org can power velocity forecasting, pipeline-weighted predictions, and confidence scoring — you just need someone to build the math and the visualization.

Prompt:

Add a Forecast tab with velocity-based forecasting. I want to see:
- Team velocity in dollars per business day
- A velocity forecast that projects the full year based on current pace
- Show velocity forecast vs goal as a progress bar
- A chart showing predictive velocity vs historical velocity trending
  over the last 10 months
- A pipeline-weighted forecast that compares against the velocity
  forecast and gives me a confidence score — High, Medium, or Low
  based on how close the two methods are

Custom LWC velocity forecast dashboard showing predictive analytics and pipeline-weighted forecasting The Velocity Forecast view — predictive vs historical trends, pipeline-weighted forecasting, and confidence scoring. This is what companies pay $75/user/month for from analytics vendors.

Claude builds the velocity calculations, the dual-method comparison logic, and the confidence scoring algorithm. It renders the trend chart with both lines overlaid and creates the forecast card that shows your team exactly where they stand — not just the raw numbers, but whether the numbers agree with each other.

Step 4: Iterate in Plain English

Once the foundation is built, refining is just conversation.

Prompt:

The sales chart is hard to read with three lines. Make the FY2026
line dashed and lighter so the current year pops more. Also add
a Combined/By Type toggle on the pipeline chart so they can split
by new business vs expansion.

Prompt:

Add a tooltip on the confidence score that explains why it's
Medium — show the variance between the two forecast methods.

Prompt:

The KPI cards need trend arrows. Show green up arrow if we're
ahead of where we were last year at this point, red down if behind.

Each prompt takes minutes, not hours. Claude Code updates the components, handles the edge cases, and you review the output. The entire dashboard — Apex controllers, LWC components with Chart.js visualizations, tab navigation, responsive layout, test classes — comes together in a single working session.

Step 5: Test and Deploy

Prompt:

Write tests for everything and make sure it handles bulk data.

Claude Code generates the test classes — data factories, assertions for every aggregation, bulk tests, permission tests. We review, run them, and deploy. The whole cycle from “we need a better dashboard” to production is typically one to two days, not weeks.

Bonus: AI-Generated Sales Briefs with Agentforce

If your org has Agentforce licenses, you can take this one step further. We recently added a component to a client’s dashboard that uses Salesforce’s native Prompt Builder and Flow to generate an AI-written executive summary every Monday morning.

Sales leaders open the dashboard and see a two-to-three paragraph brief — in plain English — that highlights the biggest pipeline risks, team velocity trends, and recommended actions for the week. No clicking through charts, no interpreting numbers. The AI reads the same data powering the dashboard and writes the narrative for you.

Here’s how it works:

  • Prompt Builder defines the template — what data to include, what tone to use, what questions to answer (e.g., “What are the three biggest risks to hitting our number this quarter?”)
  • A scheduled Flow runs Monday morning, pulls the current dashboard data, passes it to the Einstein prompt, and stores the generated summary
  • An LWC component on the dashboard displays the latest brief with a timestamp

Prompt to Claude Code:

Add a component to the dashboard that shows an AI-generated weekly
sales brief. Use Prompt Builder and a scheduled Flow that runs
Monday mornings. The brief should cover pipeline risks, velocity
trends, and what the team should focus on this week. Keep it to
2-3 paragraphs, written for a sales leader, not an analyst.

AI-generated weekly sales brief displayed on a custom LWC dashboard An AI-generated weekly sales brief — pipeline health, velocity trends, and recommended actions written in plain English by Salesforce’s native Einstein AI. Sales leaders open the dashboard Monday morning and know exactly where to focus.

This is the kind of thing that would be a premium add-on in an analytics platform. With Agentforce and a custom LWC dashboard, it’s just another component — powered entirely by native Salesforce AI infrastructure.

Stop Paying Per-User for Insights That Live in Your Own Data

Let’s talk about what this replaces. Companies running complex sales orgs typically end up licensing one of the analytics platforms to get the kind of visibility we just built:

  • Clari — $75-100+/user/month for pipeline inspection, forecast intelligence, and revenue analytics
  • InsightSquared — Similar pricing for pipeline analytics, forecasting, and activity tracking
  • Salesforce CRM Analytics (Tableau CRM) — $75/user/month for advanced dashboards and Einstein predictions
  • Gong/Chorus — Even more per seat if you want conversation intelligence layered in

These are good tools. But here’s the thing: the core forecasting and pipeline analytics — velocity tracking, multi-method forecast comparison, goal decomposition, year-over-year trending, confidence scoring — all of that is math applied to data that’s already sitting in your Salesforce org. You’re paying per-user licensing fees for someone else to query your own database and show you charts.

A custom LWC dashboard gives you:

  • Zero per-user cost. It runs on your existing Salesforce licenses. Ten users or ten thousand — same price.
  • Your data stays in Salesforce. No syncing to third-party platforms, no data residency questions, no integration maintenance.
  • Complete customization. You’re not limited to the vendor’s chart types, layout options, or metric definitions. Want to combine velocity forecast and pipeline-weighted forecast with a confidence score? Just ask Claude to build it.
  • Instant iteration. When your VP of Sales says “I also want to see it broken down by rep” or “add SE activity to the forecast,” it’s a prompt away — not a feature request to a vendor’s roadmap.

We’re not saying you should rip out Clari tomorrow. But if the main thing you’re using it for is pipeline visibility and forecast analytics, a custom LWC dashboard can cover that at a fraction of the cost — and it’s built exactly the way your team thinks about the business.

When You Should Consider Custom LWC Dashboards

Not every org needs this. Standard dashboards work fine for straightforward reporting. But if you’re hitting three or more of these signals, it’s time:

  1. Users are exporting to Excel to get the view they actually need.
  2. You’re at the 20-component limit on multiple dashboards.
  3. Decision-makers complain about stale data or lack of drill-down.
  4. You need cross-object metrics that standard report types can’t join.
  5. Mobile access matters and the standard mobile dashboard experience isn’t cutting it.
  6. You want interactivity — click a number, see the underlying records, take action.

If this sounds like your org, the ROI on a custom LWC dashboard is typically measured in weeks, not months. Your team stops working around Salesforce’s limitations and starts working with a tool built for how they actually operate.

The Engineer’s Advantage

We build these with Claude Code not because it’s trendy, but because it removes the bottleneck. The hard work in a custom dashboard isn’t writing the Chart.js integration or the wire adapter boilerplate — it’s understanding the data model, designing the right UX, and ensuring the queries perform at scale. That’s engineering work, and it’s what we focus on.

If you’re evaluating whether custom LWC dashboards make sense for your org, we’re happy to look at your setup and give you a straight answer. No sales pitch, just a technical assessment from engineers who’ve built dozens of these.

Download Our Claude Code Skills

The skills we use internally to build these dashboards are available as free downloads. Drop them into your Claude Code setup and start building LWC dashboards with the same patterns we use.

LWC Development Skill — Component architecture, wire service patterns, imperative Apex, event communication, Lightning Message Service, Jest testing, and security best practices. This is the foundation skill for all our LWC work.

Chart.js in LWC Skill — Locker Service-compatible Chart.js patterns that actually work. Covers the critical responsive: false requirement, window.Chart constructor pattern, canvas setup with lwc:dom="manual", and every chart type (bar, line, doughnut, stacked, mixed). Includes the common pitfalls table that will save you hours of debugging.

How to use these skills

  1. Download the .md files
  2. Place them in your project’s .claude/skills/ directory (create it if it doesn’t exist)
  3. Claude Code will automatically pick them up when you’re working on LWC files
  4. Ask Claude Code to “build a pipeline chart component” or “create a dashboard with KPI cards” — it’ll follow the patterns in these skills

These are the same skills our engineers use on client projects every day. No signup required, no strings attached.

Have questions about setting these up or want help getting started with Claude Code for Salesforce? Reach out at info@cumulusvision.com or schedule a call — we’re happy to help you get going.

FAQ

How long does it take to build a custom LWC dashboard?

With Claude Code accelerating development, a typical custom dashboard with four to six interactive widgets takes one to two days from requirements to production. Complex dashboards with real-time data, role-based views, and multiple data sources may take three to five days.

Do custom LWC dashboards count against Salesforce API limits?

No. LWC components using the wire service and Apex controllers run server-side within Salesforce. They don’t consume REST API calls. Cacheable Apex methods also benefit from the Lightning Data Service cache.

Can custom LWC dashboards work on mobile?

Yes. LWC components are responsive by default and render in the Salesforce mobile app. Unlike standard dashboards, you have full control over the mobile layout, touch interactions, and data density.

How does this compare to CRM Analytics (Tableau CRM)?

CRM Analytics is powerful but comes with significant per-user licensing costs and a learning curve for building custom lenses and dashboards. Custom LWC dashboards are included in your existing Salesforce licenses and give you complete control over the UX. For most custom reporting needs, LWC is more cost-effective and flexible.

What about Salesforce’s native AI features for reporting?

Salesforce’s Einstein and Agentforce features are evolving rapidly, but they’re focused on insights within the standard reporting framework. Custom LWC dashboards complement these by providing the visualization and interaction layer that standard reports can’t deliver. You can even integrate Einstein predictions as data sources in your custom dashboard components.