How can I populate the One‑Unit Housing Trends section using Titan Analytics?
To make Titan Analytics fill out the One‑Unit Housing Trends section of your report, you can mark your CSV files as 'Neighborhood' and/or 'Competing'. This guide explains how.
Document 3006 | Last updated: 12/06/2017 MJY
The 1004MC is specific to competing properties. But on forms like the URAR, the neighborhood section is based on geographical boundaries — which may include more than just competing properties. So, by default, Titan Analytics doesn't complete the One‑Unit Housing Trends section of your report.
You can make Titan Analytics fill out this section too, though. There are two ways to do this, depending on your data:
At this time, the graphs and charts in Titan Analytics only use properties labeled as competing.
If your 1004MC data is the same as your neighborhood data, you can import a single CSV file, and label it as Competing+Neighborhood.
If your competing property data is a subset of the neighborhood, or has properties outside of the neighborhood boundaries, you need two CSV files from your MLS. One of them should contain search results for competing properties. The other should contain search results for the neighborhood.
When exporting the two CSV files from your MLS, be sure to use the same export template for both. Click here for help exporting CSV files.
You must import both of your CSV files simultaneously with this method. During the import step, Titan Analytics determines where competing and neighborhood properties overlap, and uses only those overlapping properties to calculate your One‑Unit Housing trends.