Frey Chu

I don't think...

There's nothing new here.

I went over this in the last pod, but Outscraper is still the cheapest option for me.

I've used Appify and other kind of alternatives, but just keep it simple.

I think Outscraper is a great place to start.

And there's tons of videos online where people can learn how to scrape data from Google Maps using Outscraper.

So I went and did this.

I got 71,000 rows and potential listings.

and cover the entire state.

I build nationwide directories and the whole game plan is to sell leads in this high ticket niche.

So pretty straightforward.

The problem is 71,000 rows is massive and we definitely have to do a lot of cleaning as far as data goes.

So this is when I introduced Cloud Code into the mix and I used to have to manually clean data and I would have all of the obvious junk data removed.

remove things like listings with no business name, address, city, state, permanently closed ones, and any like obvious ones that don't relate to my niche, like big box retailers.

And so this is the prompt that I wrote

And obviously people are gonna have to kind of retrofit this to your own niche, but I'm just telling Cloud Code, here are my five CSVs, go ahead and just look at every single one and use this criteria to clean the data.

And so this simple prompt got me from 71K down to 20,000 listings.

And if you are going to use this prompt, I think anyone can benefit from this particular part, which is just getting rid of obvious junk data.

And yeah, what we're left with is just still a massive piece of data.

So the next round is...