How to Build Custom Analytics Dashboards in OSCOM (5 Templates Included)

Most analytics dashboards fail for the same reason: they show everything instead of showing what matters. A wall of charts and numbers creates the illusion of data-driven decision making while actually making decisions harder. When a marketing leader opens a dashboard with forty-seven widgets, their eyes glaze over and they revert to gut instinct because the dashboard is not doing the cognitive work of surfacing what is important and what needs attention. Effective dashboards are opinionated. They answer specific questions, highlight specific thresholds, and guide specific decisions. The OSCOM analytics dashboard builder is designed around this principle. Instead of starting with "what data do we have?" it starts with "what decisions do you need to make?" and works backward to build visualizations that serve those decisions. This guide walks through building five custom dashboards for the most common marketing and go-to-market use cases, with downloadable templates you can activate in your workspace.

Before building any dashboard, you need to connect at least one data source. OSCOM's analytics module supports native connections to Google Analytics 4, Google Search Console, HubSpot, Salesforce, Stripe, and any tool with an API through custom connectors. The dashboards in this guide assume you have at least GA4 and a CRM connected. If you also have Search Console connected, the SEO-specific dashboards will have richer data. Each data source takes five to ten minutes to connect through OAuth, and OSCOM begins syncing historical data immediately after connection.

The Dashboard Builder Interface

The OSCOM dashboard builder is accessible from Analytics, then Dashboards, then "New Dashboard." The interface has three panels. The left panel is the widget library, which contains all available visualization types organized by category. The center panel is the canvas where you place and arrange widgets. The right panel is the configuration panel, which shows settings for the currently selected widget.

Widget types. The library includes seven core widget types. Metric cards display a single number with optional comparison to a previous period (for example, "2,847 sessions this week, up 12% from last week"). Trend charts show a metric over time as a line, bar, or area chart with configurable time granularity (daily, weekly, monthly). Comparison tables display multiple metrics in rows with columns for current period, previous period, and percent change. Funnel visualizations show conversion through sequential stages with drop-off rates between stages. Cohort grids show retention or behavior patterns across user cohorts over time. Pie and donut charts show proportional breakdowns of a metric by dimension (traffic by channel, revenue by product, leads by source). Leaderboards rank items by a metric in descending order (top content by traffic, top campaigns by conversion, top keywords by clicks).

Widget configuration. Each widget has configuration options specific to its type. All widgets share common settings: data source selection, date range (fixed or rolling), comparison period, and conditional formatting (color the metric red if below threshold, green if above). Trend charts add options for smoothing (moving average), trend lines, and annotations. Funnel visualizations add options for stage naming, conversion window (how long between stages counts as a conversion), and segment filters. Leaderboards add options for the number of items to display, secondary sort criteria, and sparkline mini-charts showing trends for each item.

Layout and sizing. The canvas uses a responsive grid system. You drag widgets onto the canvas and resize them by dragging their edges. Widgets snap to grid lines for clean alignment. The grid has twelve columns and unlimited rows, so you can create dashboards of any density. A common layout pattern is two to three large widgets at the top (the most important metrics and trends), four to six medium widgets in the middle (supporting metrics and breakdowns), and a row of small metric cards at the bottom (tertiary indicators). This visual hierarchy guides the viewer's attention from most important to least important.

Template 1: The Executive Summary Dashboard

This dashboard is designed for weekly leadership reviews. It answers three questions: Are we on track to hit our quarterly targets? What is working? What needs attention? The dashboard fits on a single screen without scrolling, which is intentional. Executive dashboards that require scrolling lose their audience before they reach the bottom.

Row 1: Target progress. Three large metric cards spanning the full width. Each card shows a key quarterly target, the current value, and a progress bar showing percentage toward the target. The three targets depend on your business but typically include pipeline generated (current pipeline value versus quarterly target), revenue closed (closed-won revenue versus quarterly target), and marketing qualified leads (MQLs generated versus quarterly target). Each card uses conditional formatting: green when on pace or ahead, yellow when within 10% of pace, red when more than 10% behind pace. This row gives the executive team an instant read on whether marketing is tracking to plan.

Row 2: Trend and breakdown. Two medium widgets side by side. The left widget is a trend chart showing weekly pipeline generation for the current quarter, with a dotted trend line projecting to quarter end. This projection uses the current velocity and adjusts for seasonality if enough historical data is available. The right widget is a pie chart showing pipeline by source channel: organic search, paid search, social, email, direct, referral, and events. Together, these widgets show the trajectory and the channel mix. If pipeline is behind pace, the executive can immediately see which channel is underperforming.

Row 3: What is working and what needs attention. Two leaderboard widgets side by side. The left leaderboard shows "Top 5 Campaigns by Pipeline" with the campaign name, pipeline attributed, and conversion rate. The right leaderboard shows "Attention Needed" with items that have crossed alert thresholds: campaigns with declining ROI, channels with rising cost per acquisition, or content with dropping engagement. The "Attention Needed" leaderboard is automatically populated by the alerting system, so it always shows the most pressing issues without manual curation.

Row 4: Key activity metrics. Six small metric cards in a single row showing secondary indicators: website sessions (with week-over-week change), email open rate, social engagement rate, blog traffic, demo requests, and trial signups. These provide context for the headline metrics in rows one and two. If pipeline is behind pace but demo requests are up, the issue is likely in sales conversion rather than marketing demand generation.

Template 2: The Content Performance Dashboard

This dashboard is designed for content teams that need to understand which content drives results and which content needs improvement. It connects traffic data from GA4 with engagement data from OSCOM and pipeline data from your CRM to show the full content funnel: how content attracts visitors, engages them, and converts them into pipeline.

Section 1: Content health overview. Four metric cards showing total content pieces published (all time and this month), average engagement rate across all content, content-attributed pipeline (the pipeline value from deals where content touchpoints appeared in the buyer journey), and content production velocity (pieces published per week, averaged over the last month). Below these cards, a trend chart shows monthly content production and monthly content-attributed pipeline on a dual axis. The relationship between production volume and pipeline attribution reveals whether more content is producing proportionally more pipeline or whether there are diminishing returns.

Section 2: Top performing content. A leaderboard table showing the top twenty content pieces ranked by a composite score that weights traffic (30%), engagement (30%), and pipeline attribution (40%). Each row shows the content title, publish date, total page views, average time on page, bounce rate, and attributed pipeline value. The table is sortable by any column, so you can quickly switch between "most traffic" and "most pipeline" views. A sparkline column shows the traffic trend for each piece over the last 90 days, highlighting content that is gaining or losing momentum.

Section 3: Content by category and format. Two comparison charts side by side. The left chart breaks down performance by content category (industry, format type, topic cluster) showing average traffic, engagement, and pipeline per piece in each category. This reveals which topics your audience cares about most and which topics drive the most business value. The right chart breaks down by format (blog post, case study, whitepaper, video, webinar) showing the same metrics. Format analysis often reveals surprising insights, like case studies producing ten times more pipeline per piece than blog posts despite getting one-fifth the traffic.

Section 4: Content funnel. A funnel visualization showing the conversion path from content visitor to pipeline. The stages are: content page view, engaged visitor (time on page exceeding threshold or multiple page views), identified visitor (form submission or login), marketing qualified lead, and pipeline opportunity. Drop-off rates between stages show where content visitors are falling out of the funnel. If the drop from "engaged visitor" to "identified visitor" is steep, your content CTAs or lead capture mechanisms need improvement. If the drop from "identified visitor" to "MQL" is steep, your content is attracting traffic but not the right audience.

Section 5: Content decay tracker. A table showing content pieces with declining traffic over the last three months. Each row shows the content title, peak monthly traffic, current monthly traffic, percentage decline, and primary keyword ranking change. This table is the starting point for content refresh decisions: pieces with significant traffic decline and ranking drops are candidates for updating. The table includes a one-click action to create a Content Engine refresh brief directly from the dashboard row.

Template 3: The Pipeline Health Dashboard

This dashboard bridges marketing and sales by showing the health of the pipeline from both perspectives. Marketing sees whether their demand generation is producing enough qualified opportunities. Sales leadership sees whether deals are progressing at a healthy velocity. The dashboard requires a CRM connection (HubSpot or Salesforce) and pulls deal data including stage, value, age, and associated contacts.

Pipeline snapshot. A funnel visualization showing the current pipeline by stage, with deal count and total value at each stage. The funnel uses historical conversion rates to project expected revenue from the current pipeline. If you have $500,000 in proposals and your historical proposal-to-close rate is 60%, the funnel shows $300,000 as the expected revenue from that stage. This weighted pipeline view is more realistic than looking at gross pipeline value and helps both marketing and sales set accurate expectations.

Velocity metrics. Four metric cards showing average deal cycle length (days from opportunity creation to close), average deal value, pipeline velocity (the rate at which pipeline converts to revenue, calculated as deal count times average value times win rate divided by cycle length), and stage-specific dwell time (average days spent in each stage, with red highlighting for stages that exceed historical averages). These velocity metrics reveal bottlenecks: if deals are spending twice as long in the "evaluation" stage as they historically do, something is slowing decision-making and needs investigation.

Pipeline creation trend. A trend chart showing monthly new pipeline created versus monthly pipeline target. The chart includes a stacked breakdown showing pipeline by source channel so you can see whether pipeline shortfalls are caused by a specific channel underperforming or a broad decline across all channels. A secondary axis shows deal count to distinguish between fewer deals and smaller deals.

Deals at risk. A table showing deals that trigger risk signals: deals that have been in a stage longer than average, deals where the primary contact's engagement score has dropped, deals where no activity has been logged in the last ten days, and deals that were pushed from a previous quarter. Each deal row shows the deal name, value, current stage, days in stage, last activity date, and risk reason. This table gives sales managers a focused list of deals that need intervention and gives marketing a signal to re-engage contacts through targeted content or campaigns.

Marketing sourced versus influenced. A comparison chart showing two metrics: marketing-sourced pipeline (deals where the first touchpoint was a marketing activity) and marketing-influenced pipeline (deals where at least one marketing touchpoint appeared in the buyer journey, regardless of first touch). The ratio between these two numbers tells an important story. If marketing-sourced pipeline is small but marketing-influenced pipeline is large, marketing is playing a critical supporting role even though it is not always creating the initial contact. Both metrics matter, and showing them side by side prevents the common argument about whether marketing "gets credit" for pipeline.

Template 4: The SEO Command Center

This dashboard consolidates search performance data from Google Search Console with on-site engagement data from GA4 and pipeline data from your CRM. It is designed for SEO practitioners who need to monitor rankings, traffic, and the business impact of organic search in a single view.

Organic traffic overview. A trend chart showing organic sessions over the last twelve months with a comparison to the prior twelve months. Below the chart, four metric cards show total organic sessions (with year-over-year change), organic conversion rate (sessions to demo request or trial signup), organic pipeline (pipeline attributed to organic search touchpoints), and indexed pages (total pages in Google's index, pulled from Search Console).

Keyword performance table. A comprehensive table showing your top fifty keywords by clicks, with columns for keyword, average position, clicks (this month), clicks (last month), change, impressions, click-through rate, and landing page. The table is sortable and filterable. A particularly useful filter is "position 4-10" which shows keywords where you are on page one but not in the top three, the striking distance keywords that represent the highest-impact SEO opportunities. Color coding highlights keywords with improving positions (green), stable positions (neutral), and declining positions (red).

Page performance breakdown. A leaderboard showing your top twenty pages by organic traffic with columns for page URL, organic sessions, average position across target keywords, bounce rate, average session duration, and conversion rate. This table reveals which pages are your SEO workhorses and which are underperforming relative to their ranking potential. A page ranking in position three for a high-volume keyword but showing a high bounce rate and low conversion rate has a content quality problem that rankings alone cannot solve.

Technical health indicators. A row of metric cards showing core web vitals scores (LCP, FID, CLS from Search Console data), mobile usability issues, crawl errors, and indexing coverage. Each card uses conditional formatting: green for healthy, yellow for warning, red for critical. Technical issues that affect SEO performance are surfaced here so they do not get buried in a separate technical audit tool that the SEO team might not check regularly.

Content gap opportunities. A table generated by cross-referencing your keyword rankings with competitor rankings (from the Market Intelligence module if connected). The table shows keywords where competitors rank in the top five but you either do not rank or rank below position twenty. Each row includes the keyword, estimated monthly search volume, competitor URL, and a difficulty score. This table directly feeds content planning by identifying topics where organic search demand exists but you have no competitive presence.

Template 5: The Campaign ROI Dashboard

This dashboard is designed for teams running multi-channel campaigns who need to track spend, performance, and return on investment across all channels from a single view. It requires connections to your ad platforms (Google Ads, Meta Ads, LinkedIn Ads) and your CRM for revenue attribution.

Total campaign metrics. Four large metric cards showing total spend across all channels, total attributed revenue, blended ROAS (return on ad spend), and cost per acquisition. Each card shows the current month's value with comparison to the previous month and the monthly target. These headline metrics give an immediate read on whether your campaign investment is producing adequate returns.

Channel comparison table. A comparison table with rows for each channel (Google Search, Google Display, Meta, LinkedIn, email, organic) and columns for spend, impressions, clicks, click-through rate, conversions, cost per conversion, attributed revenue, and ROAS. The table makes cross-channel performance comparison instant. When one channel shows a significantly higher ROAS than others, it signals an opportunity to shift budget. When a channel shows declining ROAS over multiple months, it signals saturation or audience fatigue that needs addressing.

Campaign-level detail. A expandable table showing individual campaigns grouped by channel. Each campaign row shows the campaign name, status, daily budget, total spend, impressions, clicks, CTR, conversions, CPA, and ROAS. Clicking a campaign row expands to show ad group or ad set level performance. This three-level hierarchy (channel, campaign, ad group) lets you drill from the big picture down to specific creative or targeting decisions.

Budget pacing. A visualization showing monthly budget allocation by channel versus actual spend-to-date with projected end-of-month spend. This pacing view prevents two common problems: underspending (leaving budget on the table because campaigns are not scaled) and overspending (exceeding budget because campaign costs accelerated). The visualization includes alerts when projected spend deviates more than ten percent from budget in either direction.

Attribution timeline. A timeline visualization showing how campaign touches translate into pipeline over time. The horizontal axis is time, and each attributed deal is shown as a dot positioned at its close date, with lines connecting back to the campaign touchpoints that influenced it. This visualization reveals the lag between campaign spend and revenue attribution, which is critical for setting realistic ROI expectations. B2B campaigns often show a sixty to ninety day lag between initial click and closed deal, and this timeline makes that lag visible and quantifiable.

Alerts and Automated Delivery

Dashboards are most valuable when they surface information proactively rather than waiting for someone to check them. OSCOM's alert system monitors the metrics on your dashboards and sends notifications when defined thresholds are crossed. Alerts can be delivered via email, Slack, or in-app notification.

Threshold alerts. Set upper and lower bounds for any metric on any widget. When the metric crosses a threshold, an alert fires. Examples: alert when weekly organic traffic drops more than 15% from the prior week, alert when campaign CPA exceeds target by more than 20%, alert when pipeline velocity drops below the quarterly average. Each alert includes the metric name, the current value, the threshold, and a link to the relevant dashboard for context.

Trend alerts. Beyond single-threshold alerts, trend alerts monitor the direction of a metric over multiple periods. A trend alert can fire when a metric has declined for three consecutive weeks even if it has not crossed a fixed threshold yet. This catches slow degradation that single-threshold alerts miss. For example, organic traffic might decline 5% per week for a month without crossing any individual threshold, but the cumulative 20% decline is significant and warrants investigation.

Automated delivery. Schedule any dashboard to be delivered as a PDF or interactive link via email. The most common cadence is a weekly summary delivered Monday morning so leadership starts the week with current performance data. The email includes a snapshot of the dashboard with the key metrics highlighted and a link to the live interactive version for deeper exploration. You can create different delivery schedules for different audiences: a daily briefing for the marketing operations team, a weekly summary for marketing leadership, and a monthly overview for executive stakeholders.

The difference between a dashboard that gets checked daily and one that gets forgotten is whether it answers questions the viewer actually has. Generic dashboards with every available metric create information overload. Focused dashboards built around specific decisions create clarity. The five templates in this guide cover the most common decision contexts for marketing and go-to-market teams: executive oversight, content strategy, pipeline management, SEO execution, and campaign optimization. Start with the template closest to your most pressing need, customize it for your specific business context, and iterate based on what actually gets used. The best dashboard is not the one with the most widgets. It is the one your team opens every morning.