Email Automation Solutions, How to Extract Data from BankProspector
Hey folks, Brecht Palombo here, and here’s this week’s Weekly Q&A.
This week I have a question from a member about email.
Do you know of any email client or add-on that allows you to populate multiple merge fields from a CSV file?
This is a great question. I’m so glad that you asked this. I’ve actually been meaning to put some new training into the course, which you’re going to see over the next several weeks because there have been some real advances. I’m going to walk through one pretty simple solution, and then I’ll go over one that’s a little bit more complex.
Let’s first talk about GMass. This is a Gmail add-on, and basically, it lets you do exactly what you asked about. It lets you go ahead and do a merge from your Gmail without anything else.
Now you’d use a professional Gmail, ideally. All of my businesses always use Google products; we use a form of Gmail called Google Suite or Workplace. The name has been evolving, but GMass is what you would use.
For all these options, there’s a monthly fee. This one’s pretty low. I think it starts at around $12.95. With it, you can use Google Sheets and the GMass mail merge that work together.
There’s a link and a great demo video down below. GMass is sort of the most simple version that I think you would or should use.
The other thing that I really like right now is Woodpecker – Woodpecker is really advanced. It’s an impressive, impressive piece of software. It will actually automate a whole prospecting system. So, for example, let’s say you took a batch of maybe 1,000 contacts and you were going to email them over 4 or 5 days, but you also wanted to touch them on LinkedIn.
Maybe there are some other tasks that you want to do. You can drop that all into this one place and automate the whole thing. It’ll walk you through it when you get signed up – you do have 30 days free, and you should definitely check that out.
You log in and get snippets, which come from data that you connect with a CSV or other integrations. Right now, I’d probably just use the CSV, which you can get out of BankProspector. I’ll go over that in a minute.
To use it, you’d put in your subject line, and then you would put in your variables like your company, maybe the amount of non-performing loans they have, or the amount of REO that it says that they have in different categories.
You can schedule it when you want it to send, and you can test different versions, including the subject and the whole body here. And always, when you’re doing this, send yourself a test email so that you can see how it looks in your own inbox after you do it.
What’s really cool is you can make a whole campaign out of this. So you can say, I want to send this email today. Then I want to wait 2 days, and if they have opened it, I’m going to do one thing. If they haven’t opened it, I’m going to do another thing. I’m going to send a different email, and then maybe I’m going to wait a little bit, and then I’m going to give a call.
I hope this seems familiar to you because this is exactly the kind of process I teach inside the Academy training. If you haven’t looked over that, you should go there and put together a campaign to see what it would look like for you to put your 8 by 8 in here; 8 contacts over 8 weeks. Just plug it right in – your calls and your emails.
You go, and you connect to your prospects (the folks who are going to get this) from a file; you’re not going to do it from a database in this case. From integrations or manually, I strongly suggest you use the file, and I’m going to go over how to do that in just a minute.
Once you’ve populated the whole thing, you get a summary. But what’s really great about Woodpecker is that it can do a whole bunch of different stuff for you and automate the whole thing.
So whether it’s an email or a task or a call or something on LinkedIn, you can put all that stuff right in here in sort of a templated, merged kind of way, and because you have this ability to AB test different versions, you can learn much more quickly what’s working.
So I strongly recommend that you check out Woodpecker. Again, you get 30 days free, which is pretty great; not even a credit card is required upfront. When you want to go get this data, I suggest you come over into BankProspector, where you’ve got your contacts.
Now I should say this: you might get excited about this and go and drop 1,000 contacts in there, and you send them all at once. I wouldn’t do that. I would instead determine an appropriate amount of drip per day. So maybe you’re sending 20 or 30 or 50, and you can do all those things right in here. You can say how many you want to have sent. And again, I suggest you do what would be a normal human amount, say maybe up to 50.
When you go to get your list, go into BankProspector. Find the button for exporting contacts, click it, and go over into our advanced export.
To do this, first, I would say I want to get contacts from all of my targets, and I want to include loans for sale, non-accrual. Now some of this data is going to have numbers that are meaningful. Some of this data is not going to be meaningful. If the bank didn’t have any loans for sale in non-accrual, then you’re going to get a zero, and that’s going to be a weird merge.
That’s the kind of case where you’d use tags instead, and you’d say, okay, I’m only going to send this to banks that I have tagged as “non-accrual sold” because I know they’ve been selling non-accrual. Then, you put in the different things you want, the different fields, and the different columns you want to get out of there.
So maybe we’ll say 1-4 family junior liens, non-accrual, and then from there, we’ll do a residential REO also. Then I’m going to name it “non-accrual sold.”
Then I would say, “Start my Export,” and it will get to work. And because we’re pulling and sifting through so much different data, you’ll get a little pending message. That means that it’s working.
When it’s ready, it will have a new little code that’ll say it’s available. Usually, just give it a minute while it does its work, then bring it back into something like Woodpecker or something like GMass and upload those items there.
So, below are links to these two different resources. I really think you should check out Woodpecker. Also, just note that the link is an affiliate link, which means that if you sign up, Distressed Pro does get some piece of it. I’m not sure how much it is, but it doesn’t cost you anything different in any case. So, I hope that you use the link. If not, you can just go to Woodpecker.co.
That’s it, and I think that if you’re serious about it and you don’t want to be sitting down sending 50 new emails manually every single day, you should use the advanced export, use Woodpecker, and upload the data. Take the 30 days free that you’re going to get from the link below and start sending anywhere from 30 to 50 emails per day.
And again, we talk about starting with the list of 100 to 200 banks. You want to have a couple of contacts per bank, which means we’re talking about 250 to 500 or 1,000 contacts. Put them all in there, but then don’t blast it all at once; drip that out.
I hope this has been helpful for you. Links to resources are below, and we’re going to see a more comprehensive cold email strategy and campaign strategy in the training before the end of September.
Make it a great day. Thanks for being a member.
I can’t wait to get your questions next week.
Resources:
