Report with Days Occupied?
storallgsa
Registered User, Daily Operations Certified, Advanced Operations Certified, myHub Certified ✭✭✭
So, I am gathering the data to calculate my customer average lifetime
value, and I can't find a report that shows the number of days units
have been occupied. I KNOW it exists, I think I am just experiencing
Monday morning brain issues. LOL.
If someone could *please* point me in the right direction, I would really appreciate it LMAO.
Thank you.
0
Comments
-
I believe what your talking about is in "reports" and under the "Payment History" will show you how many times a tenant has paid0
-
Look at the Marketing History. It will have a breakdown of average tenant stays. 1-2 months, 2-3, etc0
-
MamaDuke7 Registered User, Daily Operations Certified, Advanced Operations Certified, Administrator Certified, myHub Certified ✭✭✭✭✭I answered on the other forum, but I will put it here, too, in case anyone else wants to know.
You can run a Rent Roll report into Excel and put in a calculation that will give you this info.
Open the report in Excel, add 2 columns at the end. In the first, put in today's date for all customers. In the next, the calculation is the field with today's date - Column AF, which is the rental date. The calculation should be re-formatted as a number, not a date, and that will give you the number of days in the unit as of today.
1 -
storallgsa Registered User, Daily Operations Certified, Advanced Operations Certified, myHub Certified ✭✭✭MamaDuke7 said:I answered on the other forum, but I will put it here, too, in case anyone else wants to know.
You can run a Rent Roll report into Excel and put in a calculation that will give you this info.
Open the report in Excel, add 2 columns at the end. In the first, put in today's date for all customers. In the next, the calculation is the field with today's date - Column AF, which is the rental date. The calculation should be re-formatted as a number, not a date, and that will give you the number of days in the unit as of today.0 -
MamaDuke7 Registered User, Daily Operations Certified, Advanced Operations Certified, Administrator Certified, myHub Certified ✭✭✭✭✭storallgsa said:MamaDuke7 said:I answered on the other forum, but I will put it here, too, in case anyone else wants to know.
You can run a Rent Roll report into Excel and put in a calculation that will give you this info.
Open the report in Excel, add 2 columns at the end. In the first, put in today's date for all customers. In the next, the calculation is the field with today's date - Column AF, which is the rental date. The calculation should be re-formatted as a number, not a date, and that will give you the number of days in the unit as of today.
In Column MK, type =MJ2-AF2 and hit enter. Then fill down for the entire column to calculate for every customer.
Then highlight the entire column MJ and in the top bar, click the comma in the number section. This gives you the number of days from the day they rented until today.0 -
themage Registered User, Daily Operations Certified, Advanced Operations Certified, Administrator Certified, myHub Certified ✭✭✭✭✭MamaDuke7 is right as usual.
Not to make it more confusing, but you can also put the formula =Today()-AF2 in MJ2 and fill down for everyone, then you wont need the MK column.
Then highlight the entire MJ column and click the comma in the number section in the toolbar.1
Categories
- All Categories
- 2 What's New
- SiteLink Community Discussions
- 1.9K SiteLink General Discussions
- 79 SiteLink myHub
- 48 Lead to Lease
- 15 Price Optimization
- 36 SiteLink Certified Professional
- 185 How-To's
- 97 Training Videos
- 7 Other Resources
- 79 SiteLink, SpareFoot & storEDGE merge
- Self-Storage Operations
- 65 Starting Out in Self-Storage
- 3 3rd Party Management
- 223 Regional Discussions
- 187 Miscellaneous Discussions
- 39 Industry Webinars
- SiteLink Marketplace
- 62 Self-Storage Website Design & Listing Services
- 31 Credit Cards & Payment Processing
- 31 Self-Storage Call Centers & Kiosks
- 46 Notifications, SMS & Phone Integrations
- 92 Self-Storage Insurance, Legal & Auctions
- 11 Self-Storage Revenue Management & Analytics
- 24 Gates & Access for Self-Storage Facilities
- 10 Ancillary Services for Self-Storage Facilites
- Self-Storage Times
- 62 News
- 30 Opinion
- 146 Lifestyle