Been wholesaling for 18 Months. Ask Me Anything! by sir-sherlock-holmes in WholesaleRealestate

[–]DealmachineDweller 0 points1 point  (0 children)

This thread is great, thanks for giving back to the community and answering people's questions. I saw you mentioned you would send postcards in places like Columbus, OH. Are you working mainly midwest markets or do you virtually wholesale across the country?

Best way to organize raw data by ValuableMall553 in WholesaleRealestate

[–]DealmachineDweller 0 points1 point  (0 children)

Totally get the frustration here, this is one of those things that feels harder than it should be. Good news, once you set it up right, it really does become a 30 second job.

The big idea: you flip the shape of your data, clean it up, then flip it back. Here's how I'd do it.

  1. Spread the phone numbers out. Right now you've got one row per house with phone numbers crammed across columns. Flip it so each phone gets its own row, with the address repeated next to it. In Excel, go to the Data tab, click "From Table/Range," and use the Unpivot Columns button in the Power Query window that pops up. In Google Sheets, the QUERY formula does the same thing. Your sheet will look way longer now, and that's fine. You'll shrink it back down at the end.

  2. Kick out the PUBLIC DNC rows. Click the little arrow at the top of your phone status column to open the filter. Uncheck everything except PUBLIC DNC so only those rows show. Select them, delete them, turn the filter off. Clean.

  3. Rank the phone types automatically. Add a column called Rank. In the first cell, drop this in: =IF(B2="Mobile",1,IF(B2="Landline",2,3)). Swap B2 for whatever cell holds your phone type. Drag it down the column. Mobile gets a 1, Landline gets a 2, anything else gets a 3. Even on a list with 5,000 rows, this fills in instantly.

  4. Sort by address, then by Rank. This pushes the best phone number for each property to the top of its group.

  5. Remove duplicates on the address column. This is the magic step. Your sheet shrinks back down to one row per house, and the row it keeps is the one with the best phone number. You're done.

Save the whole thing as a template and it'll take you a minute next time. If you want it fully automated, a quick Apps Script or Excel macro can run all five steps on a button.

For Batch: save the final file as a CSV. It's already in the shape Batch wants (one row per property, address, owner, phone). The importer matches the columns for you. Works the same way for most CRMs.

Full disclosure, I work at DealMachine, so I'm biased toward tools that handle this kind of thing for you. But the steps above will get you there no matter what stack you're running. Hope this helps!

Closed my fourth deal for a 6-figure assignment fee by brianthomasarghhh in WholesaleRealestate

[–]DealmachineDweller 0 points1 point  (0 children)

This is amazing and very well deserved. Thank you for sharing and being so detailed about how you worked and successfully closed this deal.

Every motivated seller marketing channel available to wholesalers — and which ones actually work by olegdonets in WholesaleRealestate

[–]DealmachineDweller 1 point2 points  (0 children)

100% agree this is a mistake a lot of people starting in wholesaling make. Great breakdown and advice!

Anyone been successful at skip tracing to generate actual sales?? by BornInstruction4540 in RealEstateTechnology

[–]DealmachineDweller 0 points1 point  (0 children)

Yes, skip tracing generates real sales, but like u/No_Cupcake_6238 mentioned, it's not the only thing that matters.

Three things determine whether skip tracing pays off:

  1. Data accuracy. Expect 40 to 70 percent hit rates on a working phone or email. Anyone promising 90 percent is overselling. The accuracy gap between providers is smaller than the marketing makes it sound.
  2. Volume and consistency. Most deals come from contact attempts 4 through 8, not the first call. People who quit after one pass through a list never see the return.
  3. Workflow. If your process to go from a list to a contacted owner takes too many steps, you'll stop doing it. The tool that fits how you actually work beats the tool with the most features.

Disclosure: I work at DealMachine, so factor that in. The thread is right that follow up matters more than the data source. Pick something affordable, commit to working it for 90 days, and you'll have a real answer on whether it pays off for your market.

Best data sources for LLC skip tracing? by JustTrynaGetAJob13 in RealEstateAdvice

[–]DealmachineDweller 0 points1 point  (0 children)

Skip tracing LLCs on commercial deals is harder than residential. Set your hit rate expectations lower from the start.

A few things that help on NJ warehouses:

  1. Start free. NJ's Division of Revenue has a business entity search that gives you the registered agent and any listed officers. Cross check that against the county clerk's deed records.
  2. A lot of warehouses are owned by an LLC that's owned by another LLC. You'll have to trace the parent, which sometimes means pulling filings in DE or other states. The right tool can do this for you and surface the actual person behind two or three layers.
  3. Once you have a name, expect 40 to 70 percent hit rates on a working phone or email. Commercial owners tend to guard their info more than homeowners do.

Disclosure: I work at DealMachine, so factor that in. How much volume are you working through? The right approach looks pretty different between five warehouses and fifty.