December 2016 - SQLWorks

Fact Sheet: Phone Logs

Phone logs

If your business fields a lot of phone calls, accurate record keeping is an important part of your interactions with customers. SQLWorks includes a Phone Logs tool to keep track of calls, to manage workloads, and to produce valuable insights from this data.

The Phone Log itself can be found in the Navbar under CRM (1), and opens a table showing all recent phone logs to your business, who called, and other information. SQLWorks does not record audio from phone calls (unless uploaded), but creates a convenient admin trail for tracing calls and the work that was associated to them.

Pressing ‘F6’ at any time in SQLWorks opens the window to create a new phone log (2), and this can be launched quickly during/after a call. Choosing a company from your company’s list opens its lists of contacts, and the user can either select a known contact (automatically entering all their details) or right click on the contact list to add a new caller’s details.

Below this are fields for giving the detail from the call to a SQLWorks user within your company (e.g.: for assigning a new task) and you can choose a user/group to email with the call detail.

On the right hand side of the new call log window are tabs to simultaneously create new tasks, project links or sales leads using the data from the new phone log (3.) Each tab automatically copies across the data from the phone log, and provides the extra fields needed to also create these new entries, for example: task priority or lead conversion chance.

When new phone logs are saved, they are logged to the phone log table itself, and under each specific company’s Phone Logs tab in the company’s list. If used, the task, project and lead tables also receive the new entries.

SQLWorks phone log is an immensely versatile tool, which forms the backbone of a structured help desk or office environment – helping to keep track of call volumes, agent workloads and customer interaction. The phone log itself can be exported with timestamped entries for further analysis of busy periods or repeat customers, and by clicking ‘Reports’ users can produce reports on number of calls received from a list of companies.

The new phone log screen (remember: press F6!) can be customised extensively by the SQLWorks team to record information commonly taken over the phone from enquiries to your business, and to help you populate the task list, advance projects or manage sales leads elsewhere in SQLWorks more carefully.

For CRM support and advice, contact the SQLWorks team today.

Did you Know? Quoting Tips

quoting tips

Quoting a customer can be a delicate process, and sometimes you need to be able to issue a quote with detailed options. We’ve collated a few handy tips to help your sales team build the perfect SQLWorks quote.

If you’re putting together a more complex quote, it can sometimes be useful to give a customer options. You can create these by right-clicking on the line numbers on the left of each quote line, and selecting ‘Choose Option Group’ to place groups of lines under ‘Option 1’ ‘Option 2’ subheadings (1.)

These options are normally alternatives to each other, so you typically won’t want SQLWorks to total them together. You can remove the overall total by switching to the to ‘Extras and Project’ Tab in the top right of the quote header, and unchecking the ‘Print Totals’ checkbox (2.) This will remove the ‘grand total’ from the bottom of the normal quote template (please note that if you exclude VAT you’ll need to include an amendment to this effect, as depending on your settings, the total VAT may no longer be visible.)

If you need to include sub-total lines instead for each option group, the easiest way is to add a sub-total line at the end of each group. By right clicking on the grey background of any given line, you can choose ‘Toggle Line Type’ to change a line to display the sub-total of the group immediately above it, to be hidden or to become a comment line without any costs (3.)

The area around the line number will change to a different colour to reflect the line type (1), and the quote template will change to incorporate the new line type. This is useful to help keep your quote clear and tidy – to add a running sub-total, line gaps or comments.

With these extras it’s easy to build more complex quotes from SQLWorks, and give customers an informative choice.

A Quick Disclaimer: if you have a custom quotations window for your company/organisation, one or more of these quoting tips features may be disabled. If you need them – speak to the SQLWorks team!