The Custom Query
If you run Sitelink and are interested in knowing the lifetime Value of your customer here's
a handy custom query that you can run to make analyzing your data a breeze.
Download Lifetime Value Of a Customer (right click and save target/link as)
I'll post a screencast tomorrow that will show you how to run it if you don't already know how to run custom reports in Sitelink.
Why calculate the lifetime value of your customers?
Knowing the lifetime value of your customers helps you decide whether your various marketing approaches are profitable. For example, if a direct mail program attracts new customers, but at a cost that is higher than the likely lifetime value of your customers, then you should stop the marketing program because, on average, you are losing money.
If you don't run Sitelink
Here's a quick and dirty way to calculate the lifetime value of your customers. For the overall average, calculate the average length of stay for your customers then multiply the average length of stay by your average rent per occupied unit. This will give you a number a little on the low side because it won't take into account any late fees or merchandise sales of moving truck revenue, etc. You can repeat the calculation for each unit size to find out the average lifetime value for customers renting 5x5's or 10x10's or 10x20's etc.
If you're a bit geeky, keep reading for the technical details.
The script I posted above for the custom query breaks down the average lifetime value of the customer for the entire facility and for each unit size. There is a caveat to using this data. It analyzes the data based only on customers that have vacated during the period you specify. Vacated customers are used because these vacated customers have, presumably, stopped spending money with you. In other words, the amount of their lifetime value has been determined.
What this analysis doesn't take into account is that there may be customers who began renting long ago, and have yet to move out, or didn't move out during the period you specified. These customers have spent a lot of money with you and, if considered, would increase the average lifetime value calculation. However, due to the nature of the analysis, they are excluded from the consideration set.