The Broker Report Builder is a great way to export data from dotloop for your Business+ or Teams account into a .csv file. Data for these reports is collected in the loop details section of all your agents' loops and includes all the information about the property, the contract, and closing (excluding the people/roles). Exporting this data into a file that can be viewed and organized within an Excel Spreadsheet, gives you better insight into your agents' transactions.
You can only access the report builder while you are in your admin profile.
From your admin profile, click on the reporting icon.
Click on Report Builder.
You can scroll to the bottom to view all previous reports or start at the top to create a new report.
The following steps will be for creating a new report.
Type in the name of your report
Select which loop statuses you would like included in your report. Selecting none of the options here will function the same as selecting all of the choices, and include all loops, with every status. If you want to start clean, choose the CLEAR SELECTION option.
Next, we can narrow down the report based on specific review stages. This will work the same as the last section, allowing you to select specific review stages. Say you want to only see loops that have closed, this is the section to choose that specific review stage.
The last set of options for your report is the DATE FILTER. By default, and if no date type is selected, dotloop will base loops off of their CREATION DATE. If you want to select another date type, click on the drop down and choose from OFFER DATE, CLOSING DATE, LISTING DATE, LISTING EXPIRATION DATE, or CREATION DATE.
In this example I have chosen to filter by CLOSING DATE. I can now select the start and end date for this filter. Once complete, you can also go further and click the ADD DATE FILTER to add additional date filtering!
Now that your report filters have been set, you can review them at the bottom where the text reads SHOW ME LOOPS WITH: to see the parameters you have set. Giving this a look to ensure all the information is correct, you can finish by clicking the CREATE REPORT button.
Once clicked, a yellow bar will appear at the top of the page, telling you that your report is now being created. Once you see this, you can continue working, and we will email you when your report is ready.
To confirm that your report is being made, at the bottom of the page, under the REPORTS section, you will see your report displaying with the status of RECEIVED.
Once ready, you will receive an email similar to the one above. Click on the REVIEW button to navigate to the report.
You will now see your report showing the status of COMPLETED. To download the report file, simply click on the name of the report.
You'll now be prompted with your browser's download option to save the document to your computer.
Once downloaded, the form will be a CSV file, which can be opened with your preferred spreadsheet software.
One thing to note though, if you have selected options for your report that return no loops matching the criteria, you will receive a notification email letting you know that we could not find any loops matching those options.
Pro tips
- All reports created can be accessed at the bottom of the Report Builder page.
- The date filter for any report can only be set to a year at maximum.
- If no date filter option is selected, then the date range will be by Created Date by default.
- Once a report is created, you can leave the page and it will continue to be created, even if you close your browser. We will email you when it is complete.