What does my support load look like?

What does my support load look like?

DigMyData lets you examine your Support load by using the suggested calculated lines.

This process requires the Total Revenue line to be already setup.

 

How much can I support to spend on E-mail?

1. Add a new calculation line and setup the following in the New calculation line dialog:

 

 

 

 

 

 

 

 

 

· Take Total Revenue

· divide it by Support Emails

· Name it as Revenue per Support Email

· set the line format as Currency.

2. Click the Save button to add the new data line into the chart line list at the left pane.

3. Show this line in Deep View so you can see how it changes over time.

 

 

 

 

 

 

 

 

In the above example, for every revenue gained, expect a corresponding support email. You will be able to determine how much your Email Support costs.

 

Is it time to hire another Support Person?

This process requires an Employee Count historical spreadsheet configured in DigMyData Settings.

 

 

 

 

 

 

 

 

To upload a spreadsheet file:

a. Click the New Uploaded XLS or CSV button.

 

 

 

 

 

 

 

 

The following screen will be displayed:

 

 

 

 

 

 

b. Click the Download blank template (.xls) to download the spreadsheet template supported by DigMyData.

c. Save the file to a desired folder then open the file in a spreadsheet program associated with it.

d. Enter your historical data related to employee history count.

The spreadsheet must have the following information:

· Every day that the company has operated under Date column

· Number of employees on that day under Value column.

· Description column is optional.

 

 

 

 

 

e. Save the file and upload it back to the Spreadsheets page in DigMyData Settings.

f. When DigMyData confirms successful upload of the file, uncheck Sum daily data and return to Deep View.

 

 

 

 

 

 

 

 

In the example chart above, DigMyData shows historical employee count as it changes over time.

Setup the Support Load per Employee calculation line:

1. Add a new calculation line and setup the following in the New calculation line dialog:

 

 

 

 

 

 

 

 

 

· Take Support Mails

· divide it by Employee Count

· Name it as Support Load per Employee

· set the line format as Number.

2. Click the Save button to add the new data line into the chart line list at the left pane.

3. Show this line in Deep View so you can see how it changes over time.

 

 

 

 

 

 

 

 

 

In the above example, you will learn when to hire another Support person with the predicting feature of DigMyData.