New Outside Data Service Integration Feature

Did you know the Investment Dominator recently updated with a new feature now available in the Import of the Land tab?

With this new update, you will now be able to Generate Criteria for your search on a specific land county. You will then be able to import that list of prospects into the Investment Dominator.

Going to Land -> Import

Then select the option for ‘Get Data From Our Outside Data Service‘ to start the process.

There’s a ton of information on how you can set up this integration, generate criteria as well as FAQ below:

How to Enable the Integration:
https://user-guide.investmentdominator.com/how-to-add-the-datatree-integration/

How to Generate Criteria:
https://user-guide.investmentdominator.com/how-to-generate-a-new-data-tree-mailing-list/

FAQ:
https://user-guide.investmentdominator.com/datatree-faqs/

Outside Data Service – FAQ’s

Since we launched our new import Paid Data Service, there have been some great questions submitted to us from Investment Dominator users and we want to take a moment to address them here.

  1. Are we able to integrate our existing DataTree account with the Investment Dominator?

    No, while our Paid Data Service does pull data from DataTree in the background you cannot connect it with your individual DataTree account.

    If you have an existing account with DataTree you can still export that data from your account with them and then import that data that is manually processed by you into the Investment Dominator via our ‘Upload Import CSV File‘ option.

    For more information about that see our user guide article on how to import data via a. CSV file.
  2. Can you transfer accounts from DataTree to Investment Dominator?

    No, because we use a corporate account to integrate with DataTree and an individual account cannot be used in its place.
  3. How do I get started with the Paid Data Service?

    You must first select one of our paid addon plans for the Paid Data Service under the ‘Land> Import> Get Data From Our Outside Data Service> Select New Data Criteria‘ screen.

    NOTE: You can pull a record count based on your criteria prior to upgrading to a paid account, but you will not be able to import those records until your account has upgraded with a paid addon.
  4. What is the fastest way to learn more about our Paid Data Service?

    Navigate to our user guide located under the ‘Help’ tab of your Investment Dominator system or by going directly to https://user-guide.investmentdominator.com search for the keyword “Data” in the search bar, or click on the ‘Data’ tab.
  5. How much does the Paid Data Service cost?

    We have three main affordable plans to choose from:
    $47 per month gets you access to up to 470 records per month.
    $97 per month gets you access to up to 1385 records per month.
    $147 per month gets you access to up to 2450 records per month.

    Contact Sales at 1-(602)-712-0182 if you need access to more than 2450 records per month and they can set you up with a custom plan based on a cost of $0.06 per record per month.
  6. How can I upgrade my Paid Data Service subscription to a different plan?

    Simply contact your concierge, or call our sales line at 1-(602)-712-0182.
  7. Can I just purchase a set amount of records vs. having a monthly subscription?

    At this time, we only have monthly subscription plans. You can purchase a list from other 3rd party list broker services and then filter and process it into a .csv import file and upload that into your system.
  8. Do unused records roll over to the next month?

    No, your Paid Data Service record limit resets at the beginning of each billing cycle and any unused records do not roll over to the next billing period.
  9. What is your cancellation/ refund policy on the Paid Data Service Integration?

    You can review our cancellation/ refund policy here under the ‘Subscription and Memberships’ section.
  10. Are more Advanced Filters and Options going to be added to the DatatTree Integration?

    Yes, you can review the list of planned updates here. Some updates are dependant on what our Data Provider allows, however, we are working closely with them to try and make more options available to us so more features can be rolled into our system.
  11. I want more Data Service options what do I do?

    We want to hear all your feedback about this new integration (good and bad), but please submit all feedback and feature requests through your Investment Dominator system under the ‘Help> Suggest A Feature‘ section. This allows us to effectively organize the requests on our end and focus our efforts on the most requested items from all our users in our planning and development of upcoming system updates.
  12. How can I limit the number of records I download from the Paid Data Service?

    After creating your search criteria and clicking ‘Get Record Count‘ look for the field ‘Limit Size of Mailing‘ then input the number of records you wish to choose out of your limit.
  13. I Added the Paid Data Service To my account, but I still cannot pull a list, what do I do?

    One thing to note is that the permissions for the Outside Data Service are only assigned by default to the Primary (or Super Admin) of the account. This means that if you have a team of 5 people on your account only the primary will be able to pull the data unless you specifically assign the ‘Allow Import From Outside Data Service‘ permissions to a member of your team. To do this simply follow the instructions discussed in more detail here: https://user-guide.investmentdominator.com/datatree-user-permissions
  14. I need help with the Paid Data Service what do I do?

    The first thing to do is log into your Admin Console and click the ‘Help‘ tab then do a quick keyword search under the ‘Search Our User Guide‘ section to see if we have a User Guide Article already that covers what you need help with.

    If you don’t find a User Guide article or still have questions, send us a message under the ‘Create A New Support Ticket‘ section and we will be happy to help you figure out a solution, take a look at your account, and troubleshoot issues as needed, or point you to training resources that answer the questions you have.
  15. If I pull a partial list from a county then come back later and pull the rest does the system ignore the ones I already pulled previously?

    Yes, but only if you had previously pulled the original dataset through the DataTree Integration, choose a ‘Saved Criteria/Previously Saved Criteria’ and also the ‘Exclude Previously Imported Records‘ option is set to ‘Yes‘ when you subsequently pull data from that same County.

    Note: If you try to import from the same County again and not use the ‘Exclude Previously Imported Records‘ option, you might be pulling the same records you had already imported before. This will spend a lead on a duplicate record.
  16. How is Market Value determined? Is it really Assessed Value?

    DataTree provides a data point called Market Value and for the majority of Counties in the United States, they have data for that. According to DataTree, they generate that value based on sold data from the County to determine the market value. In some cases, however, this data point is empty, and in those scenarios, the fallback in our system is to reference the Assessed Value instead.
  17. Do we exclude owners that own more than one property?

    Currently, we do not do this by default however if you click ‘Advanced Filters‘ you can set the filter called “Include owners with multiple properties?” to “No” and then it will exclude those owners.
  18. How old or fresh is the data is from the Data Service?

    It varies by County. Generally speaking, it is up-to-date because DataTree data is used by Title Companies such as First American Title to assist them with their closings however, it is not a real-time feed from the County. One of the upcoming features we want to add to our integration is to provide our users with the exact date that DataTree last refreshed the data in the selected County. At this time though this data is not possible to display on our screens.

How To Load Saved Criteria For Our Outside Data Service

NOTE: If you would like to know How To Generate A New Land List Via our Outside Data Service please click here.

In order to Load Your Saved Criteria first, navigate to the ‘Land’ tab then click on the ‘Import’ option.

Click the ‘Get Data From Our Outside Data Service’ option, this will allow you to see the options below like ‘Load Criteria’:

Select the saved criteria that you would like to load, then click the ‘Load Criteria‘ option:

From this point, you will get a new pop up screen that contains your previously saved list criteria.

You can make any final adjustments to fine-tune and adjust your query before importing your next list of records.

How To Convert AgentPro247 Data To Import Into Investment Dominator

AgentPro247 is a 3rd party self-service research and lead generation tool for Real Estate Investors to utilize in order to pull specific County data for importing into the Investment Dominator CRM. The data coming from AgentPro247 is extracted in a specific format and data fields must be added and modified to successfully import the records into Investment Dominator for processing.

The following steps can be executed to accomplish this task:

Step 1) Access AgentPro247 Data For Download

AgentPro247 is sent and must be downloaded as follows:

Note: Once file is downloaded onto your computer save the file in the appropriate file location for future access.

Step 2) Open Saved Excel File And Add Column Headings

Open up the saved Excel .CSV (Comma Delimited) file from Step #1, add and modify column headings appropriately.

Note: It is common for AgentPro247 data to be missing ‘Mail Address’ along with a missing ‘Type’ and ‘Company’ field information. The ‘Type’ and ‘Company’ fields must be added to the .CSV file as shown:

Modify the existing column headings based on AgentPro247 Data Investment Dominator Field Comparison as shown:

Any unnecessary columns should be deleted from the Excel file such as PZip, PZip4, MUnitNumber, MUnitType etc.

Step 3) Save Newly Modified Excel File For Import

Save the newly modified Excel .CSV (Comma Delimited) file from Step #2 as an appropriately named file for importing into Investment Dominator.

Note: Any Optional fields can be added and imported based on Optional Fields list in How to Import your List (for Land Investing) Article in Investment Dominator.

The newly saved Excel .CSV (Comma Delimited) should have 11 mandatory data fields for successful importing; as well as, any optional fields as shown:

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.

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.

Team> Activity Log: How To Undo Actions

Most single actions that you or other users in your system do (for example, changing a value of a field, deleting a record, merging a record, creating a record… etc) are logged and indexed under ‘Team> Activity Log‘.  Also under this section, you can ‘Undo’ past actions.  So for example, if you accidentally deleted some information from a record you can look up the action record of when you deleted the information and undo that action, which will restore the previous data back into that field.

Continue reading “Team> Activity Log: How To Undo Actions”