Sales Account Management Tools: Part 1

Are you tracking your sales directly back to your leads? And do you also track the cost of the leads and how much you generate in sales from them? In the past this may have been difficult to do, but today there is no excuse for not measuring this. And as more marketing is done online, tracking just gets easier and more reliable. If you're not consistently tracking these metrics, how do manage the pay plan for your ISM and other Internet staff members? If their compensation is not directly tied to Internet leads and subsequent sales, how do you determine their pay plan? How do you know what's working and what's not?

I developed a powerful, yet easy to use tool to help make these measurements, make sales forecasts and much more. Access the first section of the tool at: http://spreadsheets.google.com/ccc?key=pXHR0EqhMEb3XkrmF2AWkCg&hl=en.

(You must have a Google account to access it.)

VERY IMPORTANT: The yellow cells are the only input cells. If you change anything in any cells that are not colored yellow, the spreadsheet will not work as it is intended.

Enjoy! Please let me know if you have any questions and share your experiences. More tools will come in this series.