Back to Blog 5 Metrics for Your Workweek – Monday: Open Job Orders by Guest Author on January 4th, 2013 Welcome to a new Bullhorn Blog series entitled “5 Metrics for Your Workweek.” InsightSquared and Bullhorn are teaming up to get you more involved and engaged with your data. Read a new business intelligence metric tip each day and learn how running your recruiting business by the numbers can help drive success. It’s Monday. Better double up on the espresso shots as you start off the workweek. Sure, not many people genuinely love Mondays, but while you shake off the weekend haze, you can prep yourself for the coming workweek with your first dose of metrics. Today, let’s see how monitoring your employees’ Open Job Orders can help plan out your week. Think of Open Job Orders as a pipeline for each of your employees. When considered by stage (i.e. Job Order, Internal Submission, Sendout, Interview, Placement, or whatever nomenclature you might use) this will show you a snapshot of what each employee is working on for the coming week. For example, at a glance, it can tell you that John has a lot of early stage Job Orders in his pipeline so this week he will be working on Submissions and Sendouts. Jane, on the other hand, has a lot of late stage Job Orders so it is likely she’ll be booking a few this week. Knowing this on the employee level is important for a manager to plan the week out. It tells you: Can you expect bookings this week? Does the team need to hit the phones harder this week? Knowing monthly goals, how does the team look in terms of hitting them? Has a certain employee improved upon his pipeline from the last week? Who might need coaching getting Job Orders from stage to stage? Which employees have too small a pipeline? How to Calculate: Choose a timeframe (current week or month are good) and use a Pivot Table in Excel to tally the number of Job Orders in various stages for each employee. Of course, in order for you to impact your business, you’ll need to make sure your Job Orders are consistently being entered when you get them, not just when they close. Otherwise your data quality won’t be up to snuff. This report can also clue you in to when you might want to consider walking away from a Job Order. Drilling into the report, is there a Job Order that’s been stuck in a certain stage for a long time? Running this report each week will start showing you trends of how swiftly Job Orders last in each stage, on average. If one is stuck in neutral, you might want to consider moving on. Many recruiting managers already pull overall Job Order pipelines, but slicing them by employee is often eye-opening when you can see the division of work and stages among your team. Run the Open Job Order report each and every Monday and let these metrics start your week off with a clear picture of what’s ahead. Want an easier way to pull this metric? Ask your Bullhorn rep about InsightSquared today! About the Author Robert Woo is the Marketing Manager at InsightSquared. You can read more of his analytic entries at InsightSquared.com.