Skip to content

Dashboard templates

Manufacturing · Marketing

Make-to-order factory doing B2B marketing: industrial trade fairs, search and LinkedIn ads, catalogues, email to distributors, technical articles. Output, OEE and machine downtime, plus campaign spend, leads, CPL, CAC and marketing spend relative to output value.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For factory B2B marketing: industrial trade fairs, search and LinkedIn ads, catalogs and distributor email. The "B2B marketing and output" dashboard compares marketing spend and new customers' first order value with output value. The "Campaigns and budget" and "Marketing funnel" dashboards cover campaign spend, prospects, CPL, CAC and marketing ROI. Needs machine, item, production order, machine shift, campaign and daily marketing spend data. Leads are optional.

Use this template to

  • Pick which trade fairs are worth attending again by prospects and new customers won.
  • Compare CAC by channel across search, LinkedIn and distributor email.
  • Keep marketing spend in proportion to the factory's output value.

6 ready-made dashboards

B2B marketing and output

B2B marketing cost (trade fairs, ads, catalogues) versus factory output value, and the share of output filled by new customers' first orders.

  • Marketing spend to output value
  • New customer first-order value to output value
  • Marketing spend
  • Output value
  • Monthly marketing spend to output value
  • Monthly new-customer first orders to output value
  • Cost per new customer by channel
  • Leads by campaign

Marketing funnel

Cost, leads, qualification rate, new customers and cost per new customer by channel and source.

  • Marketing spend
  • Leads
  • Cost per lead (CPL)
  • Customer acquisition cost (CAC)
  • Funnel by marketing channel
  • Lead qualification rate by source
  • Lead-to-customer rate by source
  • Weekly leads by channel

Campaigns and budget

Budget, cost, budget utilization and performance of each marketing campaign.

  • Budget utilization
  • New customer value to spend (marketing ROI)
  • New customers from marketing
  • Click-through rate (CTR)
  • Results by campaign
  • Budget utilization by campaign
  • Cost per new customer by channel
  • Weekly marketing cost by channel

Output and OEE

Good output, output value and OEE broken into availability, performance and quality rate by workshop, machine and shift.

  • Good output
  • Output value
  • OEE (overall equipment effectiveness)
  • Scrap rate
  • OEE by machine
  • Weekly OEE by workshop
  • Performance by shift
  • Weekly good output by workshop

Downtime

Machine downtime by reason, machine and workshop; unplanned downtime drags availability down.

  • Downtime minutes
  • Unplanned downtime share
  • Availability
  • Downtime minutes by reason
  • Downtime minutes by machine
  • Weekly downtime minutes by workshop

Quality and production orders

Scrap and inspection defects by item and defect type; completed production orders and on-time rate.

  • First pass yield (FPY)
  • Inspection defect rate
  • Completed work orders
  • On-time completion rate
  • Quality by item
  • Defect rate by defect type
  • On-time rate by workshop
  • Monthly on-time rate

Ask Si as soon as the build finishes

  • “How did new customer first-order value to output value change compared with last month?”
  • “What is driving marketing spend to output value this quarter?”
  • “Show campaign budget by month for the last six months.”
  • “Where is budget utilization highest this month, and why?”

30 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
New customer first-order value to output valueTotal first-order value of new customers won through marketing (by conversion date) divided by good output value at standard selling price in the same period; measures the share of plant capacity filled by new customers.= New customer first-order value / Output valueRatio (%)
Marketing spend to output valueMarketing cost of all campaigns (trade fairs, ads, catalogues, email, content) divided by good output value at standard selling price in the same period.= Marketing spend / Output valueRatio (%)
Campaign budgetTotal budget of campaigns starting in the period. The full campaign budget is recorded on its start date.Currency
Budget utilizationMarketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budgetRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
New customer first-order valueTotal value of the first transaction of leads converted in the period, by conversion date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
LeadsNumber of leads (prospects) created in the period, by creation date.Count
MQL rateMarketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / LeadsRatio (%)
Marketing-qualified leads (MQL)Leads created in the period that passed marketing qualification (status MQL, SQL or converted to customer).Count
New customers from marketingLeads that became customers in the period, by conversion date. Converted leads with no conversion date fall in no period.Count
New customer value to spend (marketing ROI)New customer first-order value divided by marketing spend. Above 1 means first orders have covered the cost.= New customer first-order value / Marketing spendNumber
Marketing spendTotal cost of marketing campaigns by spend date.Currency
AvailabilityRun minutes divided by planned minutes. The first component of OEE.= mfg_run_minutes / mfg_planned_minutesRatio (%)
Completed work ordersWork orders completed in the period, by completion date.Count
Inspection defect rateDefective samples divided by inspected samples across the inspection lots in the period.= mfg_defect_qty / mfg_inspected_qtyRatio (%)
Downtime minutesTotal machine downtime minutes recorded in the period, for every reason (including changeovers and scheduled maintenance).Number
First pass yield (FPY)Good output divided by total output. The quality component of OEE.= Good output / Total outputRatio (%)
OEE (overall equipment effectiveness)Availability x performance x first pass yield, computed on the period totals.= (mfg_run_minutes / mfg_planned_minutes) * (Total output / mfg_ideal_output) * (Good output / Total output)Ratio (%)
On-time completion rateWork orders completed on time divided by work orders completed in the period.= mfg_on_time_work_orders / Completed work ordersRatio (%)
Good outputGood units (total output minus scrap) produced in the period's shifts, by shift date.Count
Output valueGood output multiplied by the item's standard selling price, by machine shift date.Currency
PerformanceTotal output divided by the ideal output for the run time. The second component of OEE.= Total output / mfg_ideal_outputRatio (%)
Total outputTotal units produced in the period's shifts, including both good units and scrap.Count
Scrap rateScrap units (total output minus good output) divided by total output.= (Total output - Good output) / Total outputRatio (%)
Unplanned downtime shareUnplanned downtime minutes divided by total downtime minutes.= mfg_unplanned_downtime_minutes / Downtime minutesRatio (%)

Data you need

Required

machine, item, work_order, machine_shift, mkt_campaign, mkt_spend_daily

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, mkt_lead

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: machine, item, work_order, machine_shift, mkt_campaign, mkt_spend_daily.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 6 dashboards and 30 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Manufacturing · Marketing with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes