Land> Reports: Understanding Your Deal Flow KPI’s

We have a few key reports built into the Investment Dominator regarding your land investment deal flow, located under the ‘Land> Reports‘ section.

Interest By Property

This report will show you the number of people interested in a particular property based on how many people are connected to your property under the ‘Interest In‘ field of your Buyers List (‘Marketing‘ tab).

You can click on the number next to the property description to load the actual list of contacts interested in that particular property.

This report shows you what types of properties get more interest than others.

Saved Searches

This is where all of your saved ‘Advanced Searches‘ are displayed. For more information on how to create an ‘Advanced Saved Search‘ please review this article: https://user-guide.investmentdominator.com/advanced-search-and-saved-searches/

Property By Tags

This report shows the number of records that contain a particular tag. This is useful when segmenting your list by tags.

Click the number next to the Tag name to load the specific list of properties that contain that Tag.

Land Deal Summary

This section displays the main KPI’s of your land deal flow. They include:

  • Total Invested (Land)
    This is the amount you have spent and recorded in the system to purchase land.
  • Total Asset Value (Land)
    This is the total amount value based on the Market Values entered in the system for the property you own.
  • Total Revenue Generated (Land)
    This is the amount of revenue you have generated by selling land based on the recorded sale price saved in the system.
  • Total Profit (Land)
    This is the total profit generated from land sales based on data entered into the system under the ‘Transaction Information‘ section of your property records.
  • Average Deal Life Cycle (In Days) (Land)
    This is how long on average does it take to buy and sell a property according to data entered into the system.

Land Deal By Stage

Your deal flow is organized by Stages in the system. You can view a count of properties in each Stage of your deal flow so that you can identify bottlenecks quickly.

Hover over a column to view the number of properties within that Stage and click the column to load the list of properties within that Stage.

Share this article:

Raw Data Processing: Identifying Entities

If the County saves both individual owner names as well as entities under a single Property Owner field then one of the data processing steps you will need to conduct is to programmatically identify these entities and move them to the ‘Company’ column within your list. You will also need to indicate under the ‘Type’ field that these records are companies by entering the value of ‘Company’ for these records.

Below is a list of common keywords that would indicate that the owner is not an individual but rather a company or entity:


acquisition
aka
assoc
associa
association
bank
benefactor
beneficiary
business
c/o
care of
church
city
club
county
dept
develop
eastern
es
est
estate
et al
family
firm
foundation
holding
inc
invest
ira
land
llc
lp
ltd
northern
of
owner
ownership
partner
property
school
service
southern
st
state
tenant
tr
trs
trust
univ
us
western

Raw data lists also contain multipart names or prefixes and suffixes that need to be identified and properly formatted into the ‘First Name’ and ‘Last Name’ columns in the case of ‘Individual’ records and should not be treated as companies simply because they contain multiple spaces. You can also use this list to distinguish between common multipart names and middle initials that the county may also include in the raw data and which should be removed.

Below is a list of common multipart names, prefixes, and suffixes that you should account for in your data processing scripts:

Atty
Da
De
Del
Della
Des
Di
Dr
Du
Esq
Et Al
I
II
III
IV
Jr
La
Le
Mac
Mc
MD
Mr
Mrs
O
PhD
Prof
Ret
Rev
Sir
Sr
Von

Below is an example macro that you can use (and adjust as needed) that identifies companies or multipart names based on keywords lists like the ones posted above. We use similar scripts to identify the Companies in a list and move the company name to the ‘Company’ column in our list.

First, create a workbook with 3 sheets:

    Set InfoWs = Sheets("info")
    Set Kw = Sheets("keywords")
    Set SmpleWs = Sheets("sample")

The “info” sheet must have a title in column “A”, where you paste the OWNERS on row 2. The “keywords” sheet starts in Column “A” row 1, and the data will be on the “sample” sheet row 2, so the titles for the “sample” will be “Type”, “First Name”, “Last Name” and “Company”.

Then add and run this macro to identify records based on the keywords listed in your “keywords” sheet:

Private Sub GetCompanies_Individuals()
    Dim wrdLRow As Long
    Dim wrdLp As Long
    Dim OwnersLrow As Long
    Dim OwnersLp As Long
    Dim fndWord As Long
    Dim InfoWs As Worksheet
    Dim Kw As Worksheet
    Dim SmpleWs As Worksheet
    Dim names() As String

    On Error Resume Next

    'Define worksheet that has data on it....
    Set InfoWs = Sheets("info")
    Set Kw = Sheets("keywords")
    Set SmpleWs = Sheets("sample")

    'Get last row for keywords based on column A
    wrdLRow = Kw.Cells(Rows.Count, "A").End(xlUp).Row
    
    'Get last row for owners based on column A
    OwnersLrow = InfoWs.Cells(Rows.Count, "A").End(xlUp).Row

    'Loop through lists and find matches....
    For OwnersLp = 2 To OwnersLrow
        fndWord = 0
        For wrdLp = 1 To wrdLRow

            'Look for word...
            fndWord = Application.WorksheetFunction.Search(Kw.Cells(wrdLp, "A"), InfoWs.Cells(OwnersLp, "A"))
            'If we found the word....then
            If fndWord > 0 Then
                    SmpleWs.Cells(OwnersLp, "A") = "Company"
                    SmpleWs.Cells(OwnersLp, "D") = WorksheetFunction.Proper(InfoWs.Cells(OwnersLp, "A"))
                    'fndWord = 0
                Exit For
            End If
        Next wrdLp
        
        If fndWord = 0 Then
            names = VBA.Split(InfoWs.Cells(OwnersLp, "A"), " ")
            SmpleWs.Cells(OwnersLp, "A") = "Individual"
            SmpleWs.Cells(OwnersLp, "B") = WorksheetFunction.Proper(names(0))
            SmpleWs.Cells(OwnersLp, "C") = WorksheetFunction.Proper(names(1))
        End If

    Next OwnersLp
End Sub

NOTE: If you are not familiar with creating macros, data processing software, data processing techniques, and best practices then we highly suggest you hire a professional data processor to filter and process your raw data lists to be used for import. This article explains how you can easily outsource this step to a highly qualified professional.

Share this article:

How to Delete the last Import of Land Records

Occasionally, you may have imported several records into Investment Dominator, (in error) and you need to delete all records in that recent import. The following illustrates how to identify and delete all Land records from a specific import.

Step 1 – Identify all records in the last Import

Select [Team] function from the top level menu in Investment Dominator

Once inside the “My Team” function, select the [Activity Log] function

All Activity Log transactions are displayed in the most recent functions completed first, as indicated in the Date column.

In the Action column, the specific action you need to identify shows as “Add (By Importing List)“.

The Land record’s property ID range of that import will display, (in this case records #377 – 380).

This example shows only 4 Land records; however, depending on the size of the last import, this range could represent 500, 10,000 or more Land records.

Note: Write this property Id range down as you will need to enter these numbers in the next Step 2.

Step 2 – Selecting all records in the last import transaction

Go back to the Land records display in the Investment Dominator by selecting [Land] function

Select “Property Id Range” in [Search By] drop-down list to enter property Id range identified in Step 1.

Enter the property Id range as shown, (in the FROM and TO boxes) as search criteria to select all records in the last import.

Press the blue [Search] button to select/display all records in the property Id range.

Step 3 – Deleting all records identified and displayed in the last import

Once all records have been identified and displayed from the last import, Select All the records for deletion.

Once all records from the last import have been selected and displayed, (based on property Id range in Step 2) select the Delete function to process and confirm the deletion of all records.

System will ask you to CONFIRM the deletion

Once you CONFIRM the deletion of selected Land records and press OK, this last import is deleted from Investment Dominator.

Share this article:

How To Generate An Option Package (for Land Investing)

If you are dealing with a high priced property or one that you are not sure you want to purchase you may want to send an Option Agreement to the owner vs. an Offer Agreement. The Option gives you the option to purchase a property at a specific predetermined price on or before a particular date and gives you the right to market that property for sale within that time period. If you are able to line up an end buyer for the property before your Option expires you can do a double close or just assign the Option or Sale Agreement to the end buyer. Allowing you to do a deal with no money. If you can’t line up an end buyer in time you can simply let the Option expire.

To Generate the Options Package first make sure the record is in the ‘Pending Preliminary Research‘ status.

Enter in and save an amount under the ‘Option Amount‘ field. This will be the amount you agree to purchase the property at, if you exercise your option to buy.

If there are any back taxes on the property, enter the amount under the ‘Back Taxes‘ field and save.

If you would like to change the default dates on the Option Agreement (optional) you can override them on a per property bases by selecting a date under the ‘Option Accept By‘ and ‘Option Expires On ‘ fields.

Make sure that the Owner’s Name or Company/Entity Name is filled out and matches the County’s records.

Click the blue ‘Update Record‘ button to save the changes.

Under the ‘Generate Documents‘ page. Click the ‘Options‘ tab to toggle it open. Click on the .DOC or .PDF options to generate and download the following documents:

  • Option Cover Letter
  • Option Agreement
  • Exhibit A (Optional)
  • Envelope Labels

Here is a list of resources we use for this including the Label and Envelopes we use for the Option Package.

Once you have generated your Option Agreements click the blue ‘Bulk Update Records‘ button to the right of the ‘Generate Documents‘ page to move the records into the ‘Option Sent‘ status.

Share this article:

How To Add Multiple Owners To A Property Owner Record

To add multiple property owners to a land, or house ownership record click on the ‘Edit‘ link to the right of the property record:

Then make sure that the ‘Individual‘ option is selected under the question ‘Owner of Record> This property is owned by:‘, and the ‘Yes‘ option is selected under the question ‘Owner of Record> Are there other owners on title?‘:

Enter the name of the others on title under the 2nd through 5th owner name fields.

NOTE: Typically we don’t deal with properties that have more than five owners on title, but if you do have a property with more parties than five you can either add the remaining names under the ‘5th Owner’s Last Name‘ field, or you can mark the record as a ‘Company/ Entity‘ then put all the owners into the ‘Company Name‘ field.

Share this article:

The Investment Dominator Plugin and Theme Marketplace (COMING SOON)

We are currently looking to work with talented web developers to grow a directory of 3rd party plugins and themes for the Investment Dominator system that would allow users to add additional functionality to their business by utilizing the data they store in the Investment Dominator CRM.

Web developers would leverage our robust and secure API to access data within Investment Dominator accounts and create additional functionalities and tools that can be shared among the growing Investment Dominator user community to help improve their success in the area of Land, Home and Note Investing and management.

If you are interested in becoming an Investment Dominator plugin developer, then please send us a message under the ‘Help> Suggest A Feature‘ section and let us know, please also include your web development experience, coding languages you specialize in,  and what plugins you would like to develop. We are looking forward to working with you to help grow this platform into the #1 Real Estate Investment CRM for Land, Homes, and Notes.

NOTE: Approved developers must be an Investment Dominator user themselves, understand the structure of the platform, have a solid grasp on how the API works and should have experience or a deep understanding of Land, Home, or Note investment procurement and management.

Share this article:

Advanced Search and Saved Searches

With our ‘Advanced Search‘ option, you can easily and quickly identify records under the ‘Land Deals‘, ‘House Deals‘, and ‘Buyers List‘ section based on multiple AND/OR search criteria.

Using this feature you can identify records based on almost any record field in the system and by adding a combination of custom record filter rules such as Equal To, Not Equal To, In, Not In, Less Than, Greater Than, Between, Is Empty, Is Not Empty, etc. to the search.

Advanced Searches can also be saved and accessed under the ‘Reports> Saved Searches‘ area.

Below are some examples of advanced searches that you could run…

Example 1: By Status and By Date Created

Let’s say you want to identify all the records under your Land Deals section where the Status is set to ‘Prospect‘ and where you created the records on a particular date (through import or manually one-by-one). All you need to do is go to ‘Land Deals> Advanced Search‘ and then create a search with the following criteria:

Example 2: By Type and By Phone

Let’s say you want to identify a list of contacts in your Buyers List that have phone numbers but have not purchased a property from you yet. All you need to do is go to ‘Buyers List> Advanced Search‘ and then create a search with the following criteria:

Example 3: By City, Status, and Note

Let’s say you want to identify all the house deals you are currently researching in the Houston area, where you also mentioned “roofing issues” in a note. All you need to do is go to ‘House Deals> Advanced Search‘ and then create a search with the following criteria:

Example 4: By Status and Tag

Let’s say you want to identify all the land deals that you have successfully sold to this point and that was also tagged with a custom tracking tag that you created. All you need to do is go to ‘Land Deals> Advanced Search‘ and then create a search with the following criteria:

You can even search records that have multiple tags by clicking the options ‘Add Rule‘, ‘AND‘, ‘Tag‘, ‘contains‘ then select the other tag to search by:

Share this article:

System Merge Fields

The Investment Dominator equips you with the ability to create your own Custom Documents, Custom Website Pages, and Custom Blog and Property Posts. When creating these custom templates you can utilize system merge fields to dynamically pull in data from an Owner Record, Property Record, Contact Record, Your Company Information, or Profile.

Here is a list of system Merge Fields that you can use to output data on to your custom website pages, posts, and documents:

  • You can perform basic calculations with any numeric field in the system. To do this you must surround your calculation with double parentheses. For example the calculation for the Net To Seller amount is (([property-price]-[property-backtaxes]))
  • To output your value as a currency then place USD in front of your calculation for example: USD(([property-price]-[property-backtaxes])) will output the calculated value in the form of USD.
  • You can calculate a future date by adding the number of days to any date merge field in the system for example [current-date +7] will output the date of seven days in the future.
  • Some merge fields have option variables that you can include inside the merge field to add functionality to them. For example [optin-form confirmation_url=’/custom-page’] allows you to set a custom confirmation page URL for the Optin Form that is created when you use the merge field.
Share this article:

Data Table and Custom Column View

Under the ‘Land Deals‘, ‘House Deals‘, and ‘Buyers List‘ tabs there is a data table that displays the records under that section. Because of screen space, we do not display all columns of information for each record; instead we only display a small portion of the record data as a preview and to get the complete set of data on that particular record click the ‘Edit‘ option next to the record to open it and access all the fields of information.

How To Change The Default Column View of The Overview Table

To customize what columns of data to display on the data table click the ‘View‘ option at the top of the data table.

Select the columns that you would like to display on the data table and then click the ‘Save‘ button to save the change.

How To Reset The Column View Back To The Default View

To reset the column view back to the original recommended view, click the ‘View‘ option to load the Custom Columns settings then click the ‘Reset To Default‘ button.

Share this article: