Power Reports library

Power Reports library

This guide has been reviewed against our global client base and classed as relevant to all regions

How to use the Power Reports library

  • Read a summary of the report and, if you want to run this report on your data, just import the RRD file beside it

    • For instruction on this, see first section below titled Import an RRD file & use Predefined Reports

  • Once imported, the report will be added as a Predefined Report in Power Reports

    • This means the report criteria can now be easily accessed and run - a Predefined Report can also be added as a category on an Organiser panel

After importing, report criteria can be built on, or criteria options removed, as required

Import an RRD file & use Predefined Reports

1. Save RRD file

  • Using the library below, click the required RRD file

  • Click Download and choose a place to store it on your PC/laptop

    • Your screen may display as shown below, click Download icon (top right)

Download icon.png

2. Access Power Reports screen

From the main menu:

  • Click Reports and select Power Reports

 

3. Locate RRD file

Locate the saved RRD file on your PC/laptop

  • Click and drag the file to the Predefined Reports section on Power Reports screen

    The Import Report screen will be displayed

 

4. Import Report

  • In New Report Name, enter an appropriate title for this report

  • Share with allows you to choose how you wish to share this report criteria
    Options are: Share with Everyone, Offices, Negotiators or Do not share

  • When sharing the report, tick the box if you want to stop the report criteria from being edited by those you are sharing it with

  • Click Save

 

5. Run a saved report & further options

The saved report is shown on the right of the Power Reports screen as a Predefined Report

  • Click the report to display its criteria to the left
    Ensure that all criteria options are entered/picked, as required (or leave blank to report on all)
    e.g. if a report requires date, office or negotiator criteria to be entered, ensure you enter the required date or date range/offices/negotiators before running the report

  • Click Run Report

  • Right-clicking over the Predefined Report gives further options

    • Sharing options displays the screen shown in step 4 to allow the share settings to be changed

    • Delete report removes the report criteria from the Predefined Report list

    • Export to file allows an RRD file to be saved for the current report criteria

    • Export to code - for use by Reapit Support

    • Create new report based on this allows a duplicate report to be created and saved

Predefined Reports can also be added as a category on an Organiser panel, as outlined here:  https://reapit.atlassian.net/wiki/spaces/RW/pages/41976056 (see step 3b)

This library contains reports for (click a link to skip to a section):

Potential business

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Local applicants not yet on market

Applicants that, according to their applicant status, are not yet on the market but haven't been identified as a potential client in the applicant status screen

Need to use the Postcode criteria to enter required postcodes for your area

Once this report has been run and the applicants contacted - where relevant, applicants should be marked as a Potential Client in Applicant Status (to ensure they are included in a Potential Client report)

Potential clients out viewing

Active sales/lettings applicants from the current office, marked as potential clients

Need to enter the date range you want to report on

 

 

Matched recently, not viewed

Active sales/lettings applicants, recently matched to properties (from a given date), but with no viewings (from a given date)

Use Created/Time fields to enter the date you wish to report from

Current market appraisals

Live sales/lettings Market Appraisals that have an associated market appraisal diary appointment after a specific date

Could also add Last call to the Property criteria to return MAs not contacted since a given date

Need to enter the date you want to report after

 

 

Properties marked as 'lost instruction' after market appraisal

Returns sales/lettings properties with the status of lost instruction

 

 

Appraised but not instructed

Returns sales/lettings properties with property status of Market Appraisal and with at least one confirmed Market Appraisal appointment (that wasn't cancelled) within a set timeframe

Need to enter the date you want to report after

 

 

Cancelled appraisals

Cancelled market appraisal diary entries from last month on properties from the current office

 

Applicants registered as potential vendors/landlords without a vendor/landlord role

Current applicants that do not have a vendor/landlord role but, according to their applicant status, are a potential vendor/landlord

 

 

Missed vendor referrals

Live sales applicants from the current office who:

  • don’t have a vendor role at Pre-Appraisal or Market Appraisal

  • were registered after a specific date (need to enter a date in Time field)

  • are not marked as a Potential Client

  • does not have a buying position of First Time Buyer or Buying Agent

  • does not have a selling position of Renting or Nothing to sell

Use the Full address field to filter applicants by address

 

Potential landlords

(live/archived investors)

Archived sales applicants whose buying reason was set to Investor/To let - worth reviewing for potential landlords

To report on live applicant records, use this report criteria, but click Archived Applicant Record and select Include live records
Archived option can be left selected or de-selected, as required

 

Withdrawn last year

Archived sales or lettings properties from the current office with the status of Withdrawn along with a journal entry of Sales or Lettings status to Withdrawn created last year

Enter the date range to report between

 

 

Archived withdrawn properties

Archived properties with sales/lettings status set to withdrawn

Can be filtered by bedrooms, reception rooms, price/rent or address

 

 

Anniversary report

Live & archived properties (for the current office) with an exchanged date in a given range

e.g. to generate a list of people who exchanged in January one year ago, enter dates as from 01/01/yy to 31/01/yy

 

Applicants

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Actively viewing applicants

Sales/lettings applicants who are actively viewing within a recent time period and who are looking to buy/rent within a specific price bracket

 

 

Applicants not contacted recently

Sales/lettings applicants registered at your office, owned by a specific negotiator, who have not had their last call updated since before a specified date

(i.e. one has never been recorded) such applicants will not be returned in the results grid, see next section for another option for this report

 

 

Applicants contacted recently

Sales/lettings applicants registered at your office who have had recent contact
Criteria is set to Last Week, but can be changed

Use the criteria in this section, but click Applicant has journal entries and change to Applicant does not have journal entries

 

 

Applicants with no selling/renting position

Current sales/lettings applicants with no selling/letting position entered

 

 

Hot applicants

Active sales/lettings applicants from the current office, marked as Hot

 

 

Hot applicants not viewed

Active sales/lettings applicants marked as Hot but who have never viewed a property

 

 

Missed hot sales applicants

Sales applicants that are renting or have nothing to sell, who have viewed this month but are not marked as Hot

 

Applicants not matched to properties

Active sales/lettings applicants registered at your office that have not been matched to any properties since a given date

In the Created field, enter the date you wish to report from

 

 

Applicant housekeeping

Generates a report of applicants who were registered some time ago and who are no longer actively looking

Before running the report, need to alter the dates in both the Registered field and journal entries Created field to suit the timeframe you wish to report on

If needing to send the report to Reapit Support for applicants to be removed in bulk, ensure that the Registered column is added to the results grid before exporting it to Excel,
click here for more information:
https://reapit.atlassian.net/wiki/spaces/RW/pages/88244266

 

 

Properties

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Recent MA to instruction

Properties with a recent market appraisal appointment plus a recent status change to for sale/to let

 

 

Fall-throughs last month

Live and archived sales properties that had an offer fall though last month

 

Recent contact with vendor or landlord

Sales/lettings properties registered at your office who have had recent contact logged
Criteria is set to Last Week, but can be changed

 

 

Properties not matched to any applicant

Current sales/lettings properties registered at your office that have not been matched to any applicants since a given date

In the Created field, enter the date you wish to report from

Completions

Properties that have completed since a specific date

In the Created field, enter the preset range you wish to report in

 

Key management

Report allowing you to manage keys and track their movements

No specific key criteria is selected, allowing you to choose what is relevant to you

 

 

Properties with specific certificate type

Lettings properties that have details of a specific certificate type uploaded

  • use Type field to select the type of certificate you wish to report on (also may want to click Pick Property Criteria & add Lettings Status & Office options to narrow down report results)

e.g. select EICR type to return properties that have details of an electrical installation condition report uploaded

 

Compliance

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Current properties with EPC

Current sales/lettings properties with an uploaded EPC graph

 

Current properties missing EPC

Current sales/lettings properties without an uploaded EPC graph

 

 

Current vendor/landlord marketing consent option

Current sales/lettings properties, focusing on marketing consent options

For the Marketing consent criteria, select the required option to report on
(e.g. given, not asked etc.)

 

 

Current vendor/landlord with no ID

Current sales/lettings properties to identify vendors/landlords without ID checks uploaded

 

 

Viewings

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Viewings and follow ups

Viewing appointments within a specified time frame that weren't cancelled

After running the report, when viewing report results, use grid functionality to review the follow up data

i.e. right-click over grid column headings, select Pick columns, select Follow up and Is followed up, then right-click again and select Save grid layout
Follow up information will then be shown in future viewings reports

 

Cancelled viewings

Cancelled viewings (made with the current office) for the current office’s properties, within a given date range

Enter the date range to report between

 

Offers

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Offers from first time buyers

Offers logged in the last month by applicants who are first time buyers and registered with your office

 

Potential buyer last call

Offers set to Pending on your office’s properties that are set to For Sale - Available where the last call date is before a specific date

In Last Call, need to enter the date you want to report before

 

Accepted offers

Properties in the current office, where the property status is For Sale - Available/Unavailable or SSTC - Available/Unavailable, with an offer status of Accepted

An Offer report is also available which is similar to running a Power Report but with the addition of displaying Sales Progress information in the results grid, click here for more information: https://reapit.atlassian.net/wiki/pages/resumedraft.action?draftId=1755447314

 

Landlords

Report title

Report summary

RRD file(s) to export

Report title

Report summary

RRD file(s) to export

Reporting on landlords with multiple properties

Returns list of landlords with more than one property - where needed, can add to criteria to narrow down

 

Former landlords