SQL KPI Query Examples
 
       
             
  Distinct Products  
  Total Products  
  Average Retail Price  
  Total Retail Value  
 
 
  Example Key Performance Indicators  
  Budget variance  
  Current accounts payable  
  Current accounts receivable  
  Net profit margin  
  Operating cash flow  
  Value of returned goods  
  Working capital  
     
  Lead-to-sale conversion rate  
  Monthly calls per sales rep  
  Monthly new leads per sales rep  
  Monthly sales  
  Monthly sales - existing customers  
  Monthly sales - new customers  
  Percentage of sales from existing customers  
     
  Number of accounts per account manager  
  Number of monthly orders  
  Number of monthly quotes  
  Quote To Close ratio  
     
  Monthly website traffic  
  Average page views per visit  
  Shopping cart abandonment rate