How to export data from TheMLS.com / CLAW for Titan Analytics
This document explains how to export data from TheMLS.com / CLAW and create a CSV file for use in the Titan Analytics 1004MC and analytics charts.
Document 3118 | Last updated: 06/28/2018 RR2
To get data from your MLS into Titan Analytics, you first need to set up an export template on your MLS website. This is a one‑time process — once it's set up, you can simply choose your custom template from a list. Follow the instructions below to get started.
- First, run a search for the properties you want to include in your 1004MC analysis. Be sure to include Active, Sold, Pending, Withdrawn, and Expired listings going back at least a year. The 1004MC form uses just one year, but the graphs in Titan Analytics use your whole data set.
- Next, click the Settings icon in the top right and choose One Line Report.
- Then, click Create New.
- Select each field you need from the list on the left and click Add.
At a minimum, add the following fields:
- Close Date
- Concessions Amount
- List Price
- List Date
- Living Area Square Feet
- MLS #
- Sale Price
- Sale Type (for foreclosures)
- Sold Date
Some fields are included in the list on the right by default. If a field isn't pertinent to the 1004MC, and you don't want to include it with your export, select the field and click Remove. Feel free to select additional fields from the left and add them as needed to determine outliers.
- Enter a report name, such as TitanAnalytics, and click Save.
- Back at your main search screen, check the box near the top left to select all the properties in the search results. If you're exporting more than 100 properties, choose Select All from the drop-down menu next to this check box. Then, click Export near the top right.
- Select the export template you created in step 5 (A). Then, select the .csv option (B), adjust the file name as needed (C), and click Export again (D).
- Depending on your web browser, you may receive a prompt to choose the destination folder, or the file may go straight to your Downloads folder. Just make note of where it's saved.
That’s all there is to it. Your data is ready for Titan Analytics. Next time, you can skip steps 1 - 5 and go straight to the Export button in Step 6 after searching.