Do you manage a Contract Book? Maybe you’re a Contract Recruiter, Divisional Manager or Contractor Care Specialist, and you’d like better visibility over your Contract Book. If that’s the case, I have some suggestions beyond the ‘Contractors Finishing’ metric that could be really useful.

Let’s begin with cube19 Trends  (if you don’t see this in the header menu when you access cube19, please ask your internal cube19 admin to grant you permission).

Trends is a brilliant and often under-utilised tool when it comes to visualising data. The aim of Contract recruitment is growth, so it’s powerful to see when a reduction in your Contractor numbers is coming, allowing plenty of time to rectify it. 

Let’s start by editing a Trend Chart, selecting Advanced Trend, and adding 3 metrics: Contractors Out in Period, Contract Starters and Contractors Finishing. Depending on the nature of your business, it’s likely that the number of contractors working at any time will be far higher than any Starters or Finishers you have in this same timeframe. Hence, in the Y-axis dropdown, amend the ‘Contractors Out in Period’ metric to plot on the right axis. 

This will separate those results onto a different axis to Starters and Finishers, and help visualise how low Starters and high Finishers have an immediate effect on those runner numbers! Now select the individual user, group, or even the whole business. For the timeframe, let’s choose ‘This Quarter’ and ‘plot chart’.

Results like these are typical. In the space of 1 month, with some Finishers (pink) and only a few Starters (blue) booked in, the Contractor numbers will drop from 131 to 115!

For assignments that are coming to an end, you have a valuable asset at your disposal – a contractor not yet on the market who will be seeking a new project. Hopefully, they’ve had a good experience working with you, and are happy for you to represent them again. Now is a great opportunity to proactively approach potential clients who you know will need contractors with this skills set. 

Trends also allows you to visualise your Contract GP. There is a metric specifically built to do this: ‘Contractors Out in period Weekly GP’. 

When plotted on a chart, and with the data aggregated weekly, this shows the projected GP each week and can be used to look both historically and ahead. This is a projected figure based on contracts in the CRM when you plot the chart, so as new Starters are booked, their GP will be added from their start date, and of course, Finishers’ GP is removed when their contract is set to end.

As you likely experience in your own business, the Projected GP is rarely spot on. In most cases, the actual GP tends to be lower than the projected due to Contractors taking holiday and other (unchargeable) time off. This is where the Actuals functionality comes in, which allows accurate GP based on timesheet submissions to be uploaded into cube19.

Actuals will be covered in more detail separately, but an example of how to use this in Trends is to plot the Actuals metric against your Projected GP. The results might look something like this:

There is a strong correlation between projected and actual, with the latter hovering around 68% of the former, with a few dips which could be explained by public holidays in countries where you have a large project, or multiple contractors taking time off. 

Knowing that your actual margin will likely be 32% less than your projected allows you to better anticipate your future billings.

If you have any questions about this, please contact the Customer Success team at support@cube19.com or speak to your Customer Success Manager directly.