Your skip trace results file has many more columns than the file you uploaded. This guide explains how to download it and what each group of columns means.
Resources
→ How To Use Lead Sherpa's Integrated Skip Tracing Tool
→ FCC - FIPS codes for states and counties
1. Download your results
- In the menu on the left, click the Skip Trace icon.
- Find your file in the list and click the download icon next to it.
- Choose an export:
- Export by Input Row: one row for each row in the file you uploaded, in the same order. This is the layout described in this guide.
- Export by Contact: the results organized by contact instead of by your original rows.
- Read the DNC disclaimer and click I Understand. The file downloads as a CSV.
2. What's in the file
The columns appear in this order.
Your original data
| Columns | What they mean |
| Submitted Owner Full Name, First Name, Last Name, Business Name | The names exactly as they were in your file. |
| Submitted Mailing Address, City, State, Zip | The mailing address from your file. |
| Submitted Property APN, FIPS, County, Address, City, State, Zip | The property details from your file. |
| Submitted Custom 1 to 6 | Any extra columns you mapped as custom fields are copied here. |
Property
| Columns | What they mean |
| Property APN, Address, ZipCode, City, County, State, FIPS | The property as matched in our data, including its parcel number and county FIPS code. |
| Property Mailing Address, ZipCode, City, County, State, FIPS | The mailing address on record for the property. |
Owner
| Columns | What they mean |
| Owner Business Name | The company or trust that owns the property, when there is one. |
| Owner Contact Type | owner for a person who owns the property, or officer for a person connected to a company or trust that owns it. |
| Owner Officer Title | For officers, their role in the company, for example: Manager or Registered Agent. |
| Owner Full Name, First Name, Last Name | The name of the owner or officer. The phone numbers and emails in the row belong to this person. It can be different from the name you uploaded. |
| Owner Phone 1 to 3 | Up to 3 phone numbers. Each has a Type (mobile or landline), a Last Seen date and DNC Registered (True if the number is on the National Do Not Call Registry). |
| Owner Email 1 and 2 | Up to 2 email addresses, each with a Last Seen date. |
| Owner Mailing 1 and 2 | Up to 2 mailing addresses for the owner, with zip, city, county, state and FIPS. |
| IP Address, IP Last Seen | An IP address linked to the owner, when available, for online marketing. |
| Golden Address, City, State, Zip, Last Seen | The most up-to-date mailing address we found for the owner. Use it for direct mail. See Golden Address® Explained. |
| Owner Age | The owner's approximate age. |
Flags
| Columns | What they mean |
| Owner Is Deceased | True if the owner is reported as deceased. |
| Owner Bankruptcy, Owner Foreclosure, Lien, Judgment | The date of the record when one was found, or No Data. |
| Quitclaim, Available Equity | Filled in when the data is available. |
| Litigator | True if the owner is a known litigator. Be very careful before contacting these owners. |
Relatives
| Columns | What they mean |
| Relative 1 and 2 | Up to 2 people connected to the owner, such as relatives or other officers of the same company. Each has a first and last name, a contact type, an officer title (if any) and up to 3 phone numbers with DNC Registered. |
Result
| Columns | What they mean |
| Has Hit | True if the lookup returned data for that row. |
| Record Status | new if the record wasn't in your account yet. You aren't charged again for records you already have recent data for. |
| Result Details (Beta) | What happened with the row, for example "Owner Contact Phone Found", "Property Details Not Found" or "Duplicate Row". Use it to fix rows that failed and run them again. |
3. Tips
- Phone 1 is usually the best number to start with, but keep every phone type when you upload to a campaign. A mobile number is sometimes labeled as a landline.
- Check the DNC Registered columns before you call or text. You're responsible for the DNC status of the numbers you contact.
- Pushing the file to an SMS campaign? Your prospects are scrubbed for litigators on upload, and you can turn on the DNC scrub per campaign with Use DNC Scrub. See How To Start A New Campaign.
What you're charged for
You're charged for each lookup that returns an owner phone number, mailing address or email. Duplicate rows and records you already have recent data for are free. All skip trace charges are final and non-refundable. See Skip Trace Data & Pricing.
Questions? Email support@leadsherpa.com.
Comments
Article is closed for comments.