The Quest for Dynamic Data For Prospecting In Real-Time

The Quest for Dynamic Data For Prospecting In Real-Time

Specialist · Greenville, SC · Member since 2014 · 149 posts · 67 votes

I follow a lot of post on this forum about gathering information on motivated sellers and using it for prospecting. The big sites are mentioned  (List Source, Zillow, Attom Data API) for sourcing house data. It seems OP starts out with good ideas and then a couple years pass and nothing more is mentioned. So, I decided to start my own thread.

The most common response for prospecting list "why not just buy a list and mail to them... or buy 2 list and stack them and then phone/mail." My problem with that is list lose value, houses sell, vacants aren't vacant, people pay delinquent taxes, landlords replace tenants,  ect. 

I want data that is evergreen: when the house sells the new owners mailing address is updated, Somehow gather all "list"  combined, stacked, updated and output daily. That way you don't need to source new list. 

I started a beta project in Tarrant County TX to see how much of my quest could be completed.

Step 1 Collect every Parcel ID in the county.

Step 2 Standardize every address and owner name

Step 3 Crack LLC's to find rep/owner/manager

Step 4 Create relationships between owners and properties (how many properties they own) 

Step 5 Gather Delinquent Tax roll filter and apply to owner

Step 6 Run Vacancy status on every valid parcel address

Step 7 Collect all "pain causing" court cases daily and scrub for owners address

Step 8 House all court records that match owners.

Step 9 Create a SellScore that displays current and historical court cases

Step 10 Make filters for all data to be sorted in cloud and downloaded if needed

Step 11 Data append phone,email and daily update of owners that have court cases

I think this covers the most common list.

  • Vacant
  • Absentee
  • Tax Delinquent
  • Liens
  • Eviction
  • Divorce
  • Probate  

The end result will output 2 csv files daily

ownername,owneraddress,propertyaddress,caseType,TotalProperties,#Vacants,TotalTaxDel,SellScore,DivorceY/N,ProbateY/N,#Evictions,phone1,phone2,phone3,email

2nd file- Just phone formated for RVM or Text upload

What other information would you add to create your perfect prospecting? 

7Reply
77 views

Most Popular Reply

Investor · Kansas City, MO · Member since 2015 · 70 posts · 22 votes
7y

@Nettles Mason How has this worked out? At the time of this posting did you already have this entire system in place and automated, or were you still in the process? Gathering, manipulating and continually updating data has been an ongoing bottleneck in my marketing.

See this reply in the discussion

11 Replies

Jump to latestLatest
  • Specialist · Greenville, SC · Member since 2014 · 149 posts · 67 votes
    7y

    The best program I found is LINQPad5. If you are like me and DON'T know SQL.  It allows access your DB with C# and writes SQL that actually works. This lets you manipulate all data inside the database for output on a website/portal 

  • Investor · Kansas City, MO · Member since 2015 · 70 posts · 22 votes
    7y

    @Nettles Mason How has this worked out? At the time of this posting did you already have this entire system in place and automated, or were you still in the process? Gathering, manipulating and continually updating data has been an ongoing bottleneck in my marketing.

  • Specialist · Greenville, SC · Member since 2014 · 149 posts · 67 votes
    7y

    @Chris Trupiano Yes, I fully automated it in 5 counties so far. We are developing a sync between texting (LeadSherpa), Podio (BeastMode CRM) and out custom databases to work together on Do not call, Dead leads, Direct Mail (Yellowletterhq) to fully automate prospecting. Our first AI prospecting that uses pain point data rather than some bs numerical algorithm !

  • Investor · Kansas City, MO · Member since 2015 · 70 posts · 22 votes
    7y

    @Nettles Mason I can’t say my data skills come close to this level. My only other thought of lists to add would be for water **** offs. This would need to be sourced from the utility not county most likely.

    Do you source all lists daily from the county? I’m assuming they have a regularly updated online source for all this data then.

  • Specialist · Greenville, SC · Member since 2014 · 149 posts · 67 votes
    7y

    @Chris Trupiano I appreciate your suggestion on the water cutoffs. Will check it out.

    Data is sourced from public sites or purchased.

    Tax data is updated quarterly

    Property Records - monthly 

    Vacancy - every 2 weeks

    Civil Court - daily 

    Combine blacklist from all marketing platforms - daily

    CRM scrubbed monthly to remove houses that sold

    Simple Overview- Person owns real estate has a problem, system identifies them as prospect, stacks historical pain to create SellScore and markets to them the day they have their "pain point". We use 3 different marketing platforms. Text, RVM, Direct Mail (Door knocking-Geo route mapping & Facebook are developed and coming soon). When they sell, become a lead, or ask to be removed from list system will remove them from all marketing.

    Real time data is the future of real estate. It is here now and will only get better.

  • Investor · Philadelphia, PA · Member since 2012 · 135 posts · 80 votes
    7y

    @Nettles Mason this is good stuff!

  • Investor · Philadelphia, PA · Member since 2012 · 135 posts · 80 votes
    7y

    @Nettles Mason this is good stuff!

  • Specialist · Rijeka, Croatia · Member since 2019 · 34 posts · 10 votes
    7y

     @Nettles Mason, this sounds pretty sweet. Is this a service that I could purchase from you?

  • Rental Property Investor · Minneapolis, MN · Member since 2019 · 14 posts · 9 votes
    7y

    Any updates on this?

  • Specialist · Greenville, SC · Member since 2014 · 149 posts · 67 votes
    7y

    @Benjamin Parker 

    Yes, we built out 5 counties that are running. It took wayyyy longer than expected but added many new features. 

    Most of our users run Podio for their CRM (BeastMode to be exact) 

    We integrated or synced Podio, texting platform and are finalizing direct mail and RVM now.

    Having clients upload their marketing list and integrate with data we collect is where we are at right now.

    This will almost automate the prospecting side of marketing.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.