SkipCheap

List stacking: combine lists, dedupe, then trace

Prices read · How we price

List stacking means combining several lists of distressed properties, such as tax delinquent, absentee, vacant and pre-foreclosure, and finding the properties that appear on more than one. The same property often shows up on two or three lists. Remove the repeats before you trace, or you pay for the same owner more than once.

How to stack in a spreadsheet

  1. Use the parcel number as the key. Addresses are spelled many ways; the parcel number (APN) is the same on every list. If a list lacks it, add it by matching the address to the county record.
  2. Tag each list. Add a column called Source to each file, such as "tax delinquent" or "absentee".
  3. Paste all lists into one sheet with the same column order.
  4. Count how often each parcel appears. In a new column: =COUNTIF(A:A,A2), where A holds the parcel number. A 2 or 3 means the property is on more than one list.
  5. Keep one row per parcel. Use Data, then Remove duplicates on the parcel column, after you copy the Source tags of the repeats into one cell. Keep the count: it is your priority score.
  6. Check for the same owner on many parcels. Sort by owner name. One owner with six parcels needs one trace, not six.

What deduping saves

Take 5,000 records with 20% duplicates. That is 1,000 repeats; 4,000 are unique. Here is the month's cost at the cheapest per-record service and the cheapest per-match service at 5,000 records, before and after dedupe (80% of records assumed to match):

BillingCost at 5,000Cost at 4,000Saved
Per record: Best Skip Tracer$497$417$80.00
Per match: PennySkips$80.00$64.00$16.00

A per-record service charges for every row, so every repeat is billed. A per-match service may bill a repeat too, if both copies match. In both cases, dedupe first. Some services say they remove duplicates themselves; check the price page, as many do not.

Which lists stack well

Keep the Source column through the trace. When an owner picks up, you know which problem to ask about first.

Then trace the stacked list

Trace the unique list once. The parcels that sit on several lists are your best leads, so call or mail them first. Price the stacked file in the calculator, or see the 5,000-record price table.

Next: find absentee owners, per record vs per match, or the cheapest at every size.