Overview
For a single chosen day, the Rates by Unit Group report gives a unit group by unit group snapshot across one or more facilities. For every unit group at every selected facility, the report shows the number of units and their statuses, the sizes and features of those units, the street and web rates set on them, and the in-place rates paid by current tenants.
The Rates by Unit Group report helps you compare asking rates with the rent tenants actually pay, and see how occupied each unit group is, facility by facility. Common uses include rate reviews, finding unit groups where vacant units stay empty for long periods, and getting ready for a bulk rate change.
Prerequisites
Access to the Corporate level Rates by Unit Group report depends on one report permission:
Read Rates by Unit Group permission must be enabled under the Corporate tab in the Report permissions section.
Key Terms, Calculation Basics, and Rules
The definitions, display rules, and calculation logic below apply to the Rates by Unit Group report as a whole, not to one particular column.
Key Terms
The terms below are used in this article to explain the Rates by Unit Group report. Not every term appears in the report itself: some match column names or values on screen, while others, such as snapshot, are used only to describe how the report works:
Street rate – The regular asking price assigned to a unit. All units carry a street rate. The Rates by Unit Group report shows street rates in the Current Rate column.
Web rate – An asking price for renting online, assigned to a unit. The Rates by Unit Group report shows web rates in the Current Web Rate column.
In-place rate – What a tenant owes under an active lease as of the end of the For date. To find the in-place rate, the report takes the newest entry in the lease's rate history that is dated on or before the end of the For date. If a rate increase is set to start after the For date, then the report does not use that increase. The Rates by Unit Group report shows in-place rates in the Min Rate and Max Rate columns.
Snapshot – The most recent saved version of each unit's record as of the end of the For date, in that unit's facility time zone. If a unit's rates or attributes are edited, or the unit is deactivated, after the For date, then that run of the Rates by Unit Group report does not reflect the change.
Unit group – The name of the unit type a unit is set to, for example "10x10" or "5x5 Climate." A unit has one unit group, never more. Within a single facility, the unit group name is the only thing that splits units into different rows; units with the same unit group name at different facilities appear in separate rows.
Category – A broad grouping linked to a unit's type: Storage, Parking, Office, Wine Storage, Billboard, Mailbox, Antenna, or Locker. A unit always has at least one category, and each row of the Rates by Unit Group report lists every category its units have.
Formatting Rules
The figures in the Rates by Unit Group report follow these display rules:
Every unit count is a whole number and is never left blank. If no unit in a row meets a count's condition, then that count shows 0.
%O and %V use a scale of 0 to 100 rather than 0 to 1, for example, 70.48%.
Average Days Vacant is the one figure the Rates by Unit Group report rounds, always to a whole number.
Street rates and web rates appear exactly as they are stored on each unit, without rounding.
The W, L, H, and Area columns show values exactly as they are recorded on each unit.
A range column displays the smallest and largest value among the row's units. If all the units in a row share one value, then that value is shown as both the minimum and the maximum.
A blank cell in the Current Web Rate, Min Rate, Max Rate, or Days Since Last Move-In column means none of the row's units has the data that column relies on. These columns never show 0 in place of a blank.
How Rows Are Formed
Every row in the Rates by Unit Group report stands for one unit group at one facility. Units share a row only when they are at the same facility and carry the same unit group name:
A unit's row is decided by its facility and its unit group name alone. Units with different dimensions, rates, or features still share a row, and those differences are shown as ranges or lists within it.
If two selected facilities both have a unit group with the same name, such as "10x10", then each facility gets its own row for that unit group. Rows are never merged across facilities.
If two unit group names are not identical, even when the only difference is a space, then their units land in separate rows. For example, "5x5" and "5 x 5" produce two rows.
The report includes only units that are active on the For date. If a unit group has no active units on the For date, then that unit group does not appear as a row.
If a unit lacks a size or feature value, then the unit remains in its unit group's row instead of forming a new one. The bullet for each size and feature column explains what is shown for a missing value.
How the For Date Is Applied
The Rates by Unit Group report reads unit, status, and lease data as it stood at 23:59:59 on the For date, in each facility's own time zone. The For date affects the results in the following ways:
If the report is run for a date in the past, then the report shows units, statuses, and leases as they were at the end of that day, not as they are now. The result is an accurate snapshot of that date.
If the selected facilities are in different time zones, then each facility is read at the end of the For date in its own time zone. The Corporate level report is therefore a collection of per-facility snapshots, not a single moment in time.
If a unit's status was changed after the For date, then the report ignores that change and uses the status that applied at the end of the .
If a unit was added after the For date, then the unit is left out of that run.
If a unit was deactivated after the For date, then the unit is still included in that run. If a unit was deactivated on or before the For date, then the unit is left out.
If a unit's status changed to Vacant on the For date, then the unit's days vacant is 0 or 1, never a negative number.
Report Scope
This article describes the Corporate level version of the Rates by Unit Group report, which can cover one facility or many facilities in a single run. Facilities can be selected individually, through facility groups, or both. If you only need the facility you are currently working in, then the Facility level version of the report covers that single facility.
💡 Tip: The Corporate level Rates by Unit Group report can be set up to be emailed on a recurring schedule. A scheduled Corporate level report reuses the same inputs as a manual run: the For date and the selected facilities and facility groups.
Report Layout
The top of the Rates by Unit Group report page holds the report parameters and the Filter and Export controls. This section describes those elements; the results table is described in the Main Table Content section.
Report Parameters
The Rates by Unit Group report lists these parameters at the top of the page:
Report name and category – Displayed as Rates by Unit Group, marked with an orange Operations badge.
Facility scope – The facilities the report covers: one or more individual facilities, one or more facility groups, or a combination of both.
Date range – The one day the report covers, chosen in the For date field. The For date must be filled in, and is read as a calendar day in each facility's own time zone.
Report Generated timestamp – The date and time the report was run, which tells you how up to date the figures are.
Report parameters of the Rates by Unit Group report showing report name and category, facility scope, date range, and Report Generated timestamp
Filter and Export
Two controls on the Rates by Unit Group report page let you change and download the results:
Filter – Opens the Generate Rates by Unit Group Report drawer. At the Corporate level, the drawer contains the For date field, a facility groups picker, and a facilities picker.
Generate Rates by Unit Group Report drawer of the Rates by Unit Group report
Export as – Saves the Rates by Unit Group report as a CSV, Excel, or PDF file.
Export as options of the Rates by Unit Group report
The following situations affect which facilities appear in the Corporate level Rates by Unit Group report:
If no facility and no facility group are selected, then the report does not run and shows the message "At least one facility or facility group must be specified."
If the same facility is selected more than once, for example directly and also through a facility group, then the facility appears in the report only once.
If a selected facility has no active units on the For date, then that facility adds no rows and does not appear in the report.
Main Table Content
The Rates by Unit Group report has a single results table, in which every row is one unit group at one facility. The columns fall into five groups: identifying columns, size and feature columns, unit count columns, percentage and day count columns, and rate columns.
Identifying Columns
The identifying columns tell you which facility and unit group a row of the Rates by Unit Group report belongs to, and which categories its units have:
Facility Name – The facility the row belongs to, displayed with the facility's current name. If the facility was renamed after the For date, then the row shows the current name rather than the name in use on the For date.
Unit Group – The row's unit group name, shown exactly as it is stored.
Category – All categories assigned to the row's units, each listed once, in alphabetical order. If units in one unit group have different categories, then every one of those categories is listed.
Identifying columns of the Rates by Unit Group report showing Facility Name, Unit Group, and Category columns
Size and Feature Columns
The size and feature columns describe the units in each row of the Rates by Unit Group report. Each size column gives a range that runs from the smallest to the largest value recorded among the row's units:
W (Width) – The smallest to largest width recorded among the row's units. If a unit in the row has no width recorded, then that unit is treated as 0, which makes the row's minimum width 0 while the maximum is unaffected.
L (Length) – The smallest to largest length recorded among the row's units. If a unit in the row has no length recorded, then that unit is treated as 0, which makes the row's minimum length 0 while the maximum is unaffected.
H (Height) – The smallest to largest height recorded among the row's units. If a unit in the row has no height recorded, then that unit is treated as 0, which makes the row's minimum height 0 while the maximum is unaffected.
Floor – The floor numbers where the row's units are located, each listed once, in ascending order. If a unit has no floor recorded, then floor 0 appears in the row's floor list.
CC (Climate controlled) – The climate control settings present among the row's units, each listed once: None, Heated, Cooled, or Both. If a unit has no climate setting, or the setting is blank, then that unit is not included in the list.
DU (Drive up) – Whether the row's units offer drive-up access, shown as Yes, No, or both, with each answer listed once. If a unit has no drive-up answer, then that unit is not included in the list. If none of the row's units has a drive-up answer, then the list is empty.
Area – The smallest to largest area recorded among the row's units. If a unit in the row has no area recorded, then that unit is treated as 0, which makes the row's minimum area 0 while the maximum is unaffected.
Size and feature columns of the Rates by Unit Group report
Unit Count Columns
The unit count columns in the Rates by Unit Group report count each row's active units by their availability status at the end of the For date:
Units – How many active units the row contains, regardless of their availability status on the For date.
#O (Occupied) – How many of the row's units have Occupied status, regardless of whether the unit is marked rentable.
#V (Vacant) – How many of the row's units have Vacant status and are marked rentable.
#U (Unrentable) – How many of the row's units have Vacant status and are marked not rentable. A unit counted in #U is never also counted in #V.
#C (Company) – How many of the row's units have Company status, which means the facility keeps those units for its own use.
#R (Reserved) – How many of the row's units have Reserved status.
Unit count columns of the Rates by Unit Group report
The unit count columns of the Rates by Unit Group report handle the following situations as described:
If a unit has only ever had Unavailable status as of the For date, then the unit counts toward Units but toward none of the five status columns. If that unit is marked rentable, then the unit still counts toward the rentable-unit total used for %V.
If a unit with Vacant status is marked not rentable, then the unit is counted in #U rather than #V.
If a unit with Occupied, Reserved, or Company status is marked not rentable, then the unit is counted in its status column normally, but is excluded from the rentable-unit total used for %V.
If a unit has Reserved status, then the unit is counted in #R and in no other status column. A reserved unit does not count as vacant, even though no tenant has moved in.
Percentage and Day Count Columns
The percentage and day count columns in the Rates by Unit Group report measure how occupied each unit group is and how long its vacant units have stayed empty:
%V (Vacant) – The percentage of the row's rentable units that have Vacant status, from 0 to 100. Calculated as: #V divided by the number of rentable units in the row (whatever their status), multiplied by 100. The rentable-unit total does not have its own column in the report. If the row contains no rentable units, then %V is 0.
%O (Occupied) – The percentage of the row's units that have Occupied status, from 0 to 100. Calculated as: #O divided by Units, multiplied by 100. If the row contains no units, then %O is 0.
Days Since Last Move-In – How many days have passed since the latest move-in among the row's units that have an active lease. Calculated as: for every unit in the row with an active lease, the number of days between the lease's move-in date and the end of the For date; the report shows the smallest of these numbers. If none of the row's units has an active lease, then Days Since Last Move-In is left blank instead of showing 0.
Average Days Vacant – The average length of time, in whole days, that the row's vacant units have been vacant. Calculated as: the days vacant of all units with Vacant status, whether rentable or not, added up and then divided by #V. If #V is 0, then Average Days Vacant is 0.
Percentage and day count columns of the Rates by Unit Group report
⚠️ Warning: In the Rates by Unit Group report, the total behind Average Days Vacant includes unrentable vacant units, but the divisor does not. Days vacant from units counted in #U are added to the total, while the total is divided only by the units counted in #V. If a row has any units in #U, then Average Days Vacant can be higher than the true average for rentable vacant units.
Rate Columns
The rate columns in the Rates by Unit Group report set the asking rates on each row's units side by side with the rates current tenants pay. The Current Rate and Current Web Rate columns each show a range from the lowest to the highest rate found:
Min Rate and Max Rate – The lowest and highest rates that current tenants are contracted to pay, based on the row's units that have an active lease with a rate in effect on the For date. If none of the row's units has such a lease, then the Min Rate and Max Rate columns are blank.
Current Rate – The lowest to highest street rate set on the row's units, covering every unit whether occupied or not. Current Rate always shows a value.
Current Web Rate – The lowest to highest web rate among the row's units that have a web rate. If only some of the row's units have a web rate, then the range is based on those units alone, and units without a web rate do not pull the minimum down to 0. If none of the row's units has a web rate, then Current Web Rate is blank.
Rate columns of the Rates by Unit Group report
The following situations determine which leases count toward the Min Rate, Max Rate, and Days Since Last Move-In columns of the Rates by Unit Group report:
If a lease's move-in date falls after the For date, then the lease is not treated as active for that run and contributes nothing to the Min Rate, Max Rate, or Days Since Last Move-In columns.
If a tenant moved out at any point before the end of the For date, including earlier that same day, then the lease is not treated as active for that run.
If a lease has a rate increase that takes effect after the For date, then the report ignores that increase and uses the most recent rate set on the lease on or before the end of the For date.
⚠️ Warning: The in-place rates in the Rates by Unit Group report are taken from each lease's rate history, not from invoices or payments. Min Rate and Max Rate reflect the rent tenants are contracted to pay, not the rent actually collected. The Rates by Unit Group report does not use payment or ledger data of any kind.
Sorting and Totals
The Rates by Unit Group report comes with a default sort order and has no totals row:
At the Corporate level, rows are sorted by Facility Name, from A to Z. The default sort can be cleared by clicking the X on the right side of the report table.
The Rates by Unit Group report does not include a totals row. Every row is independent, and no figures are added up across unit groups or facilities.
FAQ
The following questions cover situations in the Rates by Unit Group report that are commonly found confusing:
1. Why is a facility I selected missing from the Rates by Unit Group report?
If a selected facility has no active units on the For date, then the facility adds no rows to the Rates by Unit Group report and does not appear in the results.
2. If a facility is selected directly and is also part of a selected facility group, does the Rates by Unit Group report show it twice?
No. If the same facility is selected more than once, then the Rates by Unit Group report includes that facility only once.
3. Do facilities in different time zones use the same cut-off time in the Rates by Unit Group report?
No. If the selected facilities are in different time zones, then each facility's data is read at 23:59:59 on the For date in that facility's own time zone.
4. Why does the Rates by Unit Group report show a facility's new name for a date before the facility was renamed?
The Facility Name column always displays the facility's current name and code. If the facility was renamed after the For date, then the row still shows the current name and code.
5. Why can Average Days Vacant look higher than expected in the Rates by Unit Group report?
The days vacant of unrentable vacant units, counted in #U, are included in the total, but only rentable vacant units, counted in #V, are used as the divisor. If a row has units in #U, then Average Days Vacant can be higher than the average for rentable vacant units alone.
6. Why is Current Web Rate blank for some rows in the Rates by Unit Group report?
If none of the units in a row has a web rate set, then Current Web Rate is left blank for that row. If at least one unit has a web rate, then the column shows the range for those units only.
Related Reports








