How to export data from Matrix™ for Titan Analytics
This document explains how to export data from Matrix™ and create a CSV file for use in Titan Analytics.
Document 3012 ¦ Last updated: 09/19/2017 RR2
MLS vendors integrate with MLS boards across the country to provide the interfaces you use to search for properties in your area. While you may be familiar with MLS boards like Sandicor or Arizona Regional MLS (ARMLS), what you interact with on the screen is provided by the MLS vendor. Major vendors include RapattoniMLS, Paragon®, Matrix™, Flexmls®, and Navica.
Determining the MLS vendor is simple. Typically, these names are located on the home page or login screen of your local MLS board website, either near your MLS logo or at the bottom of the page. If you have trouble locating your vendor, contact your MLS board for help determining which MLS vendor they use.
The following instructions are for Matrix™. If this isn't the vendor your MLS board uses, click here for a complete list of vendors.
We provide these instructions as a courtesy to our customers, and are not in any way affiliated with the MLS boards or MLS vendors outlined in our instructions. Steps contained in these documents are accurate to the best of our knowledge.
Follow the instructions below to create an export template in Matrix™, export and save your data as a Comma Separated Value (CSV) file, and then import the property data to Titan Analytics.
Part I — Create your template (first-time setup)
You only need to create an export template once. After you save it, you can reuse the template each time you export data from your MLS. If you already have a template for Titan Analytics, jump to Part II.
- Log in to your MLS.
- Hover your mouse over the My Matrix tab in the upper left, and use the drop‑down menu to select Settings.
- Click Custom Exports, and then click Add Export to create a new export template.
- Enter a name for the export template in the Name field — such as Titan Analytics.
- Add the fields below to your export. Click a field name in the Available Fields list on the left, then click Add to put it in the Export Fields list. Fields can be added in any order.
The field names below may be slightly different depending on your board. Titan Analytics knows how to handle these differences.
Tip: Use the search feature to quickly find any field with Date in it!
- Listing ID (MLS #)
- Status (sold, pending, etc.)
- Close Date
- Expiration Date
- Listing Contract Date
- Withdrawn Date
- Contract Date
- Purchase Pending Date
- MLS Entry Date
- List Price
- Close Price
- Distressed (bank owned, foreclosure, etc.)
- Total Days on Market
- Latitude (Optional)
- Longitude (Optional)
- Street Address (combined or individual street name, house number, etc.)
- State or Province
- Living Area (GLA)
- Lot Size (Optional)
- Year Built (Optional)
- Garage (Optional)
- Levels/Stories (Optional)
- Bedrooms (Optional)
- Bathrooms (Optional)
- Pool (Optional)
- Seller Concession Amount
If your board won't export the Listing Date for active properties, try using the MLS Entry Date instead. Then, after you load your file into Titan Analytics, match it to the Listing Date. See Doc 3004
- When you're finished, review and verify the Export Fields column on the right.
- Now, select Name for the Include Column Names option (A), select Comma for the Separator option (B), and click Save in the lower left (C).
Part II — Export to file
Once you've saved your export template, use it to export the property data from your MLS search for use in Titan Analytics.
- Log in to your MLS.
- Click on the Search tab in the upper left and enter your search criteria. Be sure to mark all property statuses you want to include in your data, and include listing and sold properties from at least the last 365 days.
- Now, run your search as you normally would, review and select the results to include in your export, and then click the Export button on the lower right.
- From the Export file format drop‑down menu, select the Titan Analytics template you created in step 4 of Part I above. Then, click Export.
- Save the export file to a convenient location such as your Windows desktop so that you can easily retrieve it in Titan Analytics.
Part III — Import data
That's it! Your CSV export file is now ready for use. Click here for step-by-step instructions on importing the data in your CSV file to Titan Analytics. Or, click here to view some of the most frequently asked questions about Titan Analytics.