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 RR2

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:

  • Method 1 — All properties in one CSV file
  • Method 2 — Separate CSV files for competing and neighborhood properties
At this time, the graphs and charts in Titan Analytics only use properties labeled as competing.

Method 1: One CSV file

If your 1004MC data is the same as your neighborhood data, you can import a single CSV file, and label it as Competing+Neighborhood.

  1. From the Import step of Titan Analytics, add your CSV file as usual.  You can browse for the file by clicking on the upload area, or use drag‑and‑drop.
  2. A drop‑down menu appears just below the name of your file.  Click the drop‑down arrow and select Competing+Neighborhood.

    Competing+Neighborhood

  3. That's it!  Now, when you export your data to TOTAL, the One‑Unit Housing Trends section appears on your major form.  The 1004MC and Trends step of Titan Analytics gives you a preview of the completed section.

    (A):  This section uses properties that are marked as both Competing and Neighborhood.
    (B):  This section uses all properties marked as Neighborhood, regardless of whether or not they are also marked as Competing.

Method 2: Two CSV files

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.
  1. On the Import step in Titan Analytics, add both of your CSV files.  You can browse for each file by clicking on the upload area, or use drag‑and‑drop.

    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.

  2. Titan Analytics automatically selects Competing for the first file and Neighborhood for the second file, but you can toggle this using the drop‑down menu.

    Two CSV files

  3. Click Next to proceed to the Market Analysis screen.  On this step, you can use the Filter Properties drop‑down to show your Competing properties and/or your Neighborhood properties.

    Two CSV files

  4. That's it!  Now, when you export your data to TOTAL, the One‑Unit Housing Trends section appears on your major form.  The 1004MC and Trends step of Titan Analytics gives you a preview of the completed section.

    (A):  This section uses properties that are marked as both Competing and Neighborhood.
    (B):  This section uses all properties marked as Neighborhood, regardless of whether or not they are also marked as Competing.

Related Links