Report and KPI ideas

Antti Korpi avatar
Antti Korpi
Cover for Report and KPI ideas

Reporting and tracking key metrics is the lifeblood of any business. The future cannot be influenced without a map of the current situation, the past, changes and trends. Reports bring these to light allowing us to see the links between things and adapt our actions accordingly.

Reports and KPIs are the basis for assessment, forecasting and decision making in all areas of business. Which KPIs are important depends in part on the nature of the business. On this page you will find a comprehensive collection of examples of the most commonly used reports from different teams and departments.

QuickBI consults on all reporting issues, from working with Excel to using BI tools, leveraging APIs, building integrations, and creating company- and industry-specific reports. We help companies get exactly the information they need to make better decisions, understand performance, and realize growth.

Finance

  • Gross margin and gross margin percentage
  • Operating profit (EBIT) and operating margin
  • Net profit and margin
  • Operating expense ratio
  • Working capital
  • Current ratio
  • Quick ratio (acid test)
  • Debt-to-equity ratio
  • Return on assets (ROA)
  • Cash conversion cycle (CCC)
  • Burn rate
  • Accounts receivable
  • Accounts receivable turnover ratio
  • Accounts payable turnover ratio
  • Budget variation
  • Income statement
  • MRR (monthly recurring sales)
  • Average payment time for invoices
  • Customer churn
  • Cash flow forecast
  • Customer lifetime value (CLV)
  • Service/office/material surcharges
  • Capital tied up in inventories
  • Capital tied up in the logistics chain
  • Purchases from different suppliers
  • Activity accounting
  • Warranties for equipment in use
  • Energy costs
  • Energy cost / manufactured product
  • Equipment maintenance costs
  • Capacity utilization (e.g. equipment)
  • Sales rate
  • Billing rate
  • Hourly billing
  • Turnover per employee
  • Average turnover per customer
  • Turnover churn
  • Payroll headcount ratio
  • Mileage allowances per employee
  • Market share
Example finance dashboard
Example finance dashboard

Management

  • Sales by product or service
  • Product profitability
  • Discounts granted
  • Revenue per FTE
  • Sales vs targets
  • Average sales per customer
  • Customer acquisition cost (CAC)
  • Customer lifetime value (CLV)
  • Customer Satisfaction Score (CSAT)
  • Employee satisfaction
  • Pricing vs competitors
  • Operating margin
  • Gross margin
  • Return on Equity (ROE)
  • Return on Assets (ROA)
  • Working capital
  • Current ratio
  • Quick ratio (acid test)
  • Debt-to-equity ratio
  • Budget variation
Example management dashboard
Example management dashboard

Operative

  • Order fulfilment cycle time (OFCT)
  • Installation times
  • Delivery in full on time rate (DIFOT/OTIF)
  • Labour vs materials
  • Processes developed
  • Adjustments on schedules
  • Material costs
  • Utilization rates
  • Cash flow
  • Rework rate
  • Bugs in software
  • Customer complaints
  • Customer lifetime value (CLV)
  • Labour utilization
  • Employee turnover rate
  • Employee absence rate
  • Employee training and courses
  • ROI of outsourcing
Example operative dashboard
Example operative dashboard

Sales

  • New inbound leads
  • Response time to inbound leads
  • Lead conversion rate
  • Total pipeline value
  • Sales vs targets
  • Lead to opportunity rate
  • Opportunity to order rate
  • Average order value
  • Average sales cycle time
  • Sales change (month/quarter/year)
  • Shopping cart mean value
  • Number of purchases / customer
  • Abandoned shopping carts
  • Upsales
  • Upsell rate
  • Cross-sales
  • Sales by location
  • Sales funnel metrics
  • Sales activities
  • Outbound calls
Example sales dashboard
Example sales dashboard

Marketing

  • Return on ad spend (ROAS)
  • Campaign ROI by channel
  • Marketing qualified leads (MQLs)
  • Sales qualified leads (SQLs)
  • Cost per lead (CPL)
  • Lead acquisition channels
  • New customers
  • Cost per conversion
  • Conversion rate (by goals)
  • Average order value
  • Total revenue
  • Revenue by product/service
  • Upsell rate
  • Customer acquisition cost (CAC)
  • Customer lifetime value (CLV)
  • Net Promoter Score (NPS)
  • Customer Satisfaction Score (CSAT)
  • Marketing funnel metrics
  • Organic traffic/leads
  • Website traffic
  • Website traffic sources
  • Mobile vs desktop
  • Social media followers/fans
  • Social media followers/fans
  • Influencer marketing reach
  • Newsletter subscribers
Example marketing dashboard
Example marketing dashboard

E-Commerce

  • Conversion rate
  • Total revenue
  • Website visitors and sessions
  • Average session duration
  • Traffic sources
  • Average order value
  • New customers
  • Customer retention rate (CRR)
  • Abandoned shopping carts
  • Landing page KPIs
  • Return on ad spend (ROAS) per advertising channel
  • Customer acquisition cost (CAC)
  • Bounce rate
  • Customer lifetime value (CLV)
  • Customer device and browser type
  • Customer geographic location
  • Customer segment profitability
  • Marketing campaign efficiency
  • Discount campaign efficiency
  • Net Promoter Score (NPS)
  • Highest converting pages
  • Customer complaints
  • Newsletter subscribers
  • Customer journey
  • Purchase frequency
  • In-site searches
  • Social media followers/fans
  • Cost and revenue per session
  • Average gross margin

Social

  • Social share of voice (SSoV)
  • Reach
  • Impressions
  • Followers/Fans
  • Audience growth rate
  • Share rate
  • Interest rate (likes, reactions, favorites)
  • Response rate (comments, replies)
  • Reach of posts
  • Reach of hashtags
  • Clicks
  • Site traffic from social channels
  • Conversions from social channels
  • Conversion rate of social channels
  • Revenue from social channels
  • ROI of social campaign

Customer service

  • Issues by type
  • Most active support employees
  • Cost per conversation
  • Customer Satisfaction Score (CSAT)
  • Net Promoter Score (NPS)
  • Positive customer reviews
  • Google reviews
  • Customer Effort Score (CES)
  • Customer retention rate
  • Support costs vs revenue
  • Knowledge base articles
  • SLA monitoring
  • Warranty returns
  • First response time (FRT)
  • Average response time
  • Average resolution time
  • First contact resolution rate (FCR)
  • Answered calls vs missed calls
  • Response time
  • Call duration
  • Waiting time
  • Queuing time
  • Longest calls
  • Response rate
  • Answered calls / target time
  • Reach rate
Example customer service dashboard
Example customer service dashboard

Service production

  • Customer demographics - age/size/industry…
  • Customer demographics - geographic location
  • Tickets monitoring
  • Recalls
  • Customer message conversions
  • Sales and resourcing by weekday and hour
Example service production dashboard
Example service production dashboard

Project Management

  • On-time completion rate
  • Milestones on time rate
  • Estimate to project completion
  • Adjustments to schedule
  • Planned hours v. actual hours
  • Resources used
  • Planned budget vs actual budget
  • Budget iterations
  • Planned Value (PV)
  • Actual Cost (AC)
  • Billable hours
  • Time spent on projects
  • Project ROI
  • Errors
  • Customer complaints
  • Change requests
Example project management dashboard
Example project management dashboard

HR

  • Labor cost per FTE
  • Labor cost revenue percent
  • Revenue per FTE
  • Human capital ROI (HCROI)
  • Full-time/part-time ratio
  • Worker composition/diversity
  • Manager quality index
  • Employee satisfaction
  • Length of employment relationships
  • Promotion rate
  • Employee time tracking
  • Overtime work hours
  • Sick leaves
  • Absenteeism rate
  • Employee retention rate
  • Voluntary turnover rate
  • Vacancy rate
  • Successor gap rate
  • Internal mobility
  • Resignation/retirement rate
  • Retirement rate forecast
  • External hire rate
  • ROI of outsourcing
  • Recruiting expense per new hire
  • Recruiting funnel metrics
  • Employee training and courses
  • ROI of training
  • HR functional cost per employee

SaaS

  • Annual/Monthly Recurring Revenue (ARR/MRR)
  • ARR/MRR Growth Rate
  • Customer Churn
  • MRR Churn
  • Customer lifetime value (CLV)
  • Customer acquisition cost (CAC)
  • CAC payback period
  • CLV:CAC Ratio
  • Customer Health Score
  • Sales cycle length
  • Active users (per day/week/month)
  • Average Revenue Per Account (ARPA)
  • Marketing qualified leads (MQLs)
  • Sales qualified leads (SQLs)
  • Lead conversion rate
  • Customer Satisfaction Score (CSAT)
  • Net Promoter Score (NPS)
  • Customer Effort Score (CES)

IT

  • Support tickets total
  • Open support tickets
  • Ticket resolution time
  • Reopened tickets
  • Support employees per end users
  • Total of projects
  • Projects on budget
  • Uptime percentage
  • Average time between failures
  • Average time to repair
  • Server downtime
  • Security related downtime
  • Critical bugs
  • Costs vs revenue
Example IT dashboard
Example IT dashboard

Build better reports

Start moving data with QuickBI

  • 300+ data sources
  • Analyze with any data tool
  • Quick and easy setup