I consulted with the local Chamber of Commerce this evening to discuss Membership renewals. The Chamber is a fantastic organization, but is a great example of a service where renewals are the heart beat of the organization. I’m fairly certain that the Chamber probably loses money on folks that join in the first year. However, after that year, their profitability increases – and the value to the Chamber Member never goes down.
今晚我與一位同事交談， 達林·格雷（Darrin Gray），介紹我們如何輕鬆地建立一個協作站點，協助續訂的成員可以跟踪他們與新成員或可能面臨風險的成員的聯繫。 我們通過開發一個網站來進行演講，這需要幾千美元和幾週的時間才能完成。 Darrin尋求一個更好的解決方案，並最終表示了……“我希望我們可以將電子表格簡單地放在人們可以更新其信息的某個地方。”
瞧！ 谷歌電子表格. A friend of mine, Dale, shared a spreadsheet with me a few weeks ago and I remembered him telling me to check it out. It took until tonight, but I did and it’s great. After you save your spreadsheet, you have the opportunity to invite folks to edit or view the spreadsheet.
What a great tool, though! I think it will work. Darrin and I have been helping the Chamber to analyze their businesses for some predictive prospecting analysis the last two years. Last year, I developed a proprietary Z-Score based on SIC, Years in Business, Number of Employees, and Total Sales Volume. This allowed us to review and pull 1/10th the prospects for their sales teams to contact. The results of the campaigning have been above average, but we’re modifying the model to improve the results this year.