Data Advice Tip

How To use your Sales Data to drive Targeted Marketing

Capture and analyse sales data

To turn sales data into more meaningful information for your business, make it tell you where the customer came from.  You can do this with promotional codes, for instance by labelling each of your different ad placements with a separate code.  Keep track of which ‘promo’ code a customer uses when making a purchase and you will build up a picture of which ads work, which products each customer likes, and which ads work for which customers for which products!  That’s targeted marketing. (Click diagram below for close-up).Read More »How To use your Sales Data to drive Targeted Marketing

6 Questions to ask yourself before buying Business Software

1. What do I need and want the software to do?

It may seem an obvious question!  I would really recommend writing it all down though.  It will really clarify what your requirements and expectations are.  Getting into the detail early will help you prepare and increase the likelihood of success.  When you contact potential suppliers or prospective developers it gives you a great starting point.

Once you have made your full list of requirements, separate them into ‘must-haves’ and ‘nice-to-haves’.  There will be some requirements which are absolutely crucial.  The sort of thing where you think, if it doesn’t do that there there’s no point.Read More »6 Questions to ask yourself before buying Business Software

Spreadsheets vs Databases – Round 6: Restricting Access by Logon

Moving into the second half of this Spreadsheets vs Database contest we look at how to restrict user access by using logins and setting access levels. That is, allowing certain people to see certain things, but not others.

This is about keeping our more sensitive information secure and private, such as payroll or customer information.  In addition, restricting access based on a user’s logon priviledges can also be helpful in keeping software simple to use as the user is not presented with too many options at once.

Round 6: Restricting Access by User Logon Priviledges

Spreadsheets

restrict-access-by-login-priviledgeWithin Microsoft Excel it is possible to set a password for the entire workbook (or file).  Using that in combination with the individual cell properties it is possible to make certain cells read-only, therefore blocking the user from making any alterations to that cell.

You can also hide columns, rows and worksheets with a workbook.  This means that you can hide certain aspects of the spreadsheet. However, with the single password you can undo all these preventative measures and make hidden elements visible again.Read More »Spreadsheets vs Databases – Round 6: Restricting Access by Logon