the startups.com platform about startups.comCheck out the new Startups.com - A Comprehensive Startup University
Education
Planning
Mentors
Funding
Customers
Assistants
Clarity
Categories
Business
Sales & Marketing
Funding
Product & Design
Technology
Skills & Management
Industries
Other
Business
Career Advice
Branding
Financial Consulting
Customer Engagement
Strategy
Sectors
Getting Started
Human Resources
Business Development
Legal
Other
Sales & Marketing
Social Media Marketing
Search Engine Optimization
Public Relations
Branding
Publishing
Inbound Marketing
Email Marketing
Copywriting
Growth Strategy
Search Engine Marketing
Sales & Lead Generation
Advertising
Other
Funding
Crowdfunding
Kickstarter
Venture Capital
Finance
Bootstrapping
Nonprofit
Other
Product & Design
Identity
User Experience
Lean Startup
Product Management
Metrics & Analytics
Other
Technology
WordPress
Software Development
Mobile
Ruby
CRM
Innovation
Cloud
Other
Skills & Management
Productivity
Entrepreneurship
Public Speaking
Leadership
Coaching
Other
Industries
SaaS
E-commerce
Education
Real Estate
Restaurant & Retail
Marketplaces
Nonprofit
Other
Dashboard
Browse Search
Answers
Calls
Inbox
Sign Up Log In

Loading...

Share Answer

Menu
KPI Dashboards: How to evaluate KPIs – Trello or Google Sheets? This is for a hiring & recruitment business. When companies need staff, we find them & get commission
JF
JF
Joey Flores, Startup CEO/CMO/CPO with 20 Years Experience answered:

I typically end up doing this in Excel in order to get more granular.

Although your KPIs are supposed to be the most important overall metrics of your company, each major source of candidate leads, each of your sales teams, the role types, all ultimately drive these KPIs. Monitoring the health of the most important segments you have independently can help you identify changes in performance or help you allocate resources to better performing areas.

For that reason, I usually create a spreadsheet that calculates all of my KPIs, then duplicate it onto additional tabs and plug in the individual data for my most important segments. In your case, segments might be teams (or individual reps if there aren't too many), certain role types you're trying to fill, candidate leads that came from particular sources, etc.

Then, I usually create one tab of graphs that show me how my overall KPIs are trending, and then a long tab with graphs for each KPI broken down and showing me how my most important segments are trending vs one another.

This allows me to see my big picture numbers easily, and also monitor the underlying performance that affects them. Without it, I have found that you can get wins in an area while performing poorer in another and not even notice that your business has started to fare worse with leads from certain sources, or in filling certain roles.

Talk to Joey Upvote • Share
•••
Share Report

Answer URL

Share Question

  • Share on Twitter
  • Share on LinkedIn
  • Share on Facebook
  • Share on Google+
  • Share by email
About
  • How it Works
  • Success Stories
Experts
  • Become an Expert
  • Find an Expert
Answers
  • Ask a Question
  • Recent Answers
Support
  • Help
  • Terms of Service
Follow

the startups.com platform

Startups Education
Startup Planning
Access Mentors
Secure Funding
Reach Customers
Virtual Assistants

Copyright © 2025 Startups.com. All rights reserved.