Getting the most out of your marketing dollars is all about return on investment: the ROI is just a measure of how much you spent compared to how much you got back. It's a simple concept, but when we talk to companies that are part of our program, we're often surprised to see how few actually measure ROI in a consistent, ongoing way.
If you use a comprehensive sales tracking system, like Salesforce.com, Sugar CRM, or similar software, you've already got a leg up: those systems make it easy to track each lead back to its source. But what if you don't?
We want to help. We're working on a simple ROI calculator that you can use to compare the performance of all your internal and external lead gen programs, as well as do basic lead tracking. Want to check it out? Download it here:
BuyerZone Lead Tracker.xlsIt's just an Excel file -- no software to install, and no real CRM features like workflow, dashboards, or automatic importing or exporting from other tools. We're not saying you can use this to run a large sales organization. But what you
can do is use it as a guideline for calculating the ROI for BuyerZone or any other lead gen program.
What's in the calculator
The first tab,
basic ROI, lets you calculate a simple ROI based on the number of leads and their cost, or your total expense on a program. If you'd like to use this tracker for multiple programs, you can copy that sheet and reuse it for each program.
The second tab is a basic
lead tracker where you can enter each lead on its own line. This information feeds into the next sheet,
results, which gives you a basic breakdown of each of your lead sources and how they're performing.
What SHOULD be in the calculator?
Now you tell us. What else should a basic lead tracking sheet like this do? Would you like a breakdown by month, for example? What other information should it contain on each lead? We want to make this a useful, free way for businesses to get started tracking ROI on lead gen programs, so any feedback you have is appreciated.