Monitoring Driver Volumes to Keep Proposals Up to Date (Driver Metrics Monitor)

If you use client facts as pricing drivers (such as employee numbers, bank statement lines, transactions, or annual revenue) in your proposals, you can now monitor client volumes to make sure their pricing still reflects their usage.

This guide explains how to configure your Driver Metrics Monitor, upload usage data, and interpret the results.

Driver monitoring helps you to track client volumes over time, so you can:

This workflow uses the same upload process as Subscription Monitoring, but with additional configuration to map spreadsheet columns to pricing drivers.

You can monitor the following client facts in Socket:

Before you upload data, you’ll need to choose which spreadsheet columns you want Socket to track. Only numeric or range-based drivers can be monitored at this stage.

You can choose to match columns to price drivers on an 'Automatic', 'Manual', or 'Hybrid' basis.

Automatic search: Socket will try to find services automatically by looking for drivers linked to the relevant client fact.

Manual search: If the drivers are not found you can opt to manually search for them.

Hybrid search: Combines automatic and manual search, so that future changes to drivers can be automatically picked up, while also being able to select other drivers manually.

If no drivers are automatically found, you can manually search for the correct drivers.

Download the pre-built XLSX template from the Driver Monitor dashboard.

This file includes:

Add your usage data collected from your other tools. There is no need to delete any columns you’re not using, as long as you've selected the drivers during set up.

Tip: Keep client names the same or Socket may not recognise them.

Socket will process the figures and compare them against the drivers used in each active proposal. Once processed, you’ll see:

We’ll automatically try to match clients listed in your file upload to your clients in Socket. If we haven't been able to make a match, you’ll see a grey warning triangle. Click the triangle to manually select the correct client.

The dashboard will categorise the matched clients into one of four statuses:

OK - the proposal price and the uploaded file price are the same.

Under Charged - the proposal price is less than the uploaded file price.

Over Charged - the proposal price is more than the uploaded file price.

Missing Data - there is missing data and a calculation cannot be made.

Hover over the 'Missing Data' chip to identify what data is missing. A client could be missing data because:

The 'Recalculate' button will appear when there has been activity with proposals or clients linked to the dashboard results, for example, if a proposal or client has become active or inactive. Click 'Recalculate' to update the calculations.

Uploading a new CSV or XLSX will clear the current displayed data for the selected service/s. To upload a new file, simply select 'Upload Data' again and follow the steps above.

If you need to include additional services to be monitored:

• Click 'Upload Data' then select the 'Settings' button.

• Add any extra services you’d like Socket to cross-check

Based on results, you might: