Page Comparison

...

The Pipeline dashboard, one of the Lettings Management Information (MI) real-time dashboards available in AgencyCloudReapit, offers inbuilt real-time analysis of your current lettings pipeline

...

Accessing the dashboard & filtering the data shown, plus general tips

Access the dashboard

From the main menu, click Reports and select Lettings Pipeline Report
The screen below shows all available columns, if you can’t see all columns, these can be enabled via Settings or via the Hidden Columns option, see next section

Image Modified

Viewing hidden columns (& removing columns)

If not all columns are shown, they can be added via the Hidden Columns menu

Click Hidden Columns and select the required columns to show or click Show All

Image Modified

Columns can then be hidden again - hover over the column to remove and click the cross (top right)
Image Modified
All Pending Offers columns or Arranging Tenancies columns can be removed in one go - hover over the heading and click the cross (top right)

Filter by office, user and/or tenancy role

The whole company pipeline is shown by default
To filter the pipeline by office, click Office & select which office(s) to view
Image Modified
To filter pipeline by user, click Negotiator and select the required name(s) from the list
This uses the Key Contact name on the tenancy record (set in the Relationships panel)
To filter pipeline by tenancy roles, click Role and select the required role
Image Modified

General tips for using the dashboard

Use the Settings screen to change which columns are shown by default
Hover over column headings & figures to see information about the data displayed
Click on a figure to see the data behind it in a grid - when viewing the data in a grid, use grid functions to sort and filter the data, as covered in this section: Statistics explained including viewing data in a grid

Switch from current pipeline to future pipeline

Switch from current pipeline to future pipeline

The current pipeline is shown by default (indicated by All in the menu)
Beside Date option, click All for the option to change the view to:
- This Month - displays the pipeline for the current month
- Next Month - displays the pipeline for the next month
- Pick dates - usually dates in the future would be selected
  e.g. it is possible skip forward to view the pipeline for the first week of June

Image Modified

Show fees setting

The Show Fees As setting allows you to choose to view fees as a total or average amount - by default, fees are shown as Total Amount
Click Show Fees As for the option to change to show as an Average Amount
Image Modified

Statistics explained including viewing data in a grid

Tip
The statistics shown in the screenshot below are for Arranging Tenancies - the same statistics can be shown for Pending Offers If you can’t see Pending Offers on your dashboard, click Hidden Columns and choose Show All

Image Modified

Count

Shows the total number of arranging tenancies /pending offers for the selected date filter

Av Monthly Rent

Shows the average monthly rent for arranging tenancies /pending offers for the selected date filter

Addl. Fee

Shows the total additional fees for arranging tenancies /pending offer for the selected date filter
Additional fees are the total sum of management fees, letting fees and landlord fees
Both Management Fees & Letting Fees are set-up on the tenancy Financial & Renewals tab
Landlord fees are set on the property Rent/Fee Details screen

Calc. Fees

Shows the total yearly sum of management fees and letting fees for arranging tenancies /pending offers
Both Management Fees & Letting Fees are set-up on the tenancy Financial & Renewals tab
This calculation does not use the date filters at the top of the dashboard, it is taken over the duration of the tenancy, using the tenancy start and end date
e.g. if a tenancy is 6 months, the figure shown here will be the total monthly management & lettings fees multiplied by 6

Viewing data behind the statistic in a grid

Clicking any of the statistics shown will show a data grid for the related tenancies
For example, this grid is shown when clicking a figure in the Av Monthly Rent column
Image Modified
The grid displayed when clicking a Count figure shows more information, such as rent per month, fees, holding deposits & number of offer days (click screenshot below to enlarge, where required)
Image Modified
Click the column headings to sort by that column (ascending/descending)
To add more columns or remove existing columns from the grid, right-click over the column headings and select Pick columns
New columns are added to the right of the grid, click and drag to the desired position then right-click over the column headings again and select Save grid layout
Click a figure in the grid to see the associated property & tenancy records

Export to Excel

The current dashboard data can be exported to Microsoft Excel

Click Export (top right)
Excel will open with the current data displayed, allowing Excel functions to be used to manipulate the data

Image Modified

Settings

Tip

Settings allows you to choose what data is displayed on your dashboard

Changes made to Settings apply to the user who made them, therefore allowing you to customise your dashboard to match your priorities

Accessing Settings

Click Settings (top right)

Image Modified

Settings options

By default, data on Arranging Tenancies is displayed on the dashboard

Data on Pending Offers can be added to the dashboard and Arranging Tenancies columns can be removed
Tick/untick the required columns to show by default
Click Save

Image Modified

Reset

Puts all settings in this screen back to their default settings

Versions Compared

Old Version 11

New Version 12

Key

Accessing the dashboard & filtering the data shown, plus general tips

Switch from current pipeline to future pipeline

Show fees setting

Statistics explained including viewing data in a grid

Export to Excel

Settings

Related articles