In preparation for my upcoming crowdsourcing campaign in February, I decided to get started early on the market research and lead generation I’ll need to run a PR and marketing campaign.
Happy Hour! is a competitive drinking card game, challenging players to collect ingredients to deliver drinks like a real bartender! Not only is Happy Hour! fun to play, but players are also subliminally learning facts about their favorite alcohols and drink recipes.
In order for Happy Hour! to have a wildly successful campaign, we would need to market the game (and it’s future possibilities) to the alcohol, nightlife, and cocktail cultures. I knew the areas that I wanted to focus on, but I honestly didn’t have the first idea on where to start. For Dinner’s Ready!, I sought out celebrity chefs to endorse the game. This project was going to be a much bigger project that quite frankly, I wasn’t interested in doing.
I decided to outsource the project to a virtual assistant. I figured somebody else out there has had a similar need to acquire contact information, so chances are there is a freelancer that runs a “bot” that scours the internet to return a spreadsheet containing rows and rows of contact information. However the information is collected, I’m sure it was going to be happen faster than I could do it.
Here’s my original job posting on Upwork:
I’m looking for someone to help me build a database of alcohol-related contacts for marketing an upcoming crowdsourcing campaign.
I’m looking for you to fill out a spreadsheet containing the following data:
First Name, Last Name, E-mail Address, Company, Phone Number, Note
Ideally you would locate approximately 100 contacts for each of the following categories (roughly 750-1000 contacts):
– Bartending Schools (online and offline)
– Bar and Restaurant Chains (North America)
– Tabletop Game Stores (North America)
– Alcohol Brands (International)
– Distilleries (International)
– Fraternities (North America)
– Adult Gaming Communities (online and offline)
– Relevant Newspaper Contacts (online and offline)
– Drinking and Liquor Blogs
– Tabletop Game Blogs
– Famous Bartenders (if there is such a thing?)
If doing this kind of research sounds interesting and fun to you, please Submit an Application! Also please include the recipe of your favorite mixed drink. If you omit this, I will not consider your application.
The response I received to the ad was not what I had imagined, but it was definitely what I needed. I received a message from Shah, from Bangladesh, India. He cut right through to the core of my job, and he didn’t waste time with my challenges. Maybe he didn’t read the whole post? Maybe he doesn’t know the word cocktail? Maybe Shah doesn’t drink?
Nevertheless, this is the response I received:
Hi, I can do the task.You can trust me in your project.I see all of your requirements and ready to star now. Please reply me and give me the opportunity. Thanks. Shah.
Looking over his freelancing resume, I had to trust him. His portfolio was extensive in just one area: scouring the internet for e-mail addresses. Despite the secrecy around Shah’s favorite cocktail, everything seemed good enough for me so I reached back out and we started working out the kinks, mostly negotiating the price per 100 rows of contact information. Ultimately we decided on 1200 rows of contacts.
Hi, Sir Here is first 100 rows. Kindly See my attach and check this. I start first Country – USA. keyword Bar and Restaurant Chains. Please replay me. Thanks,shah
His grasp on the English language is starting to wear thin, but that’s not what I hired him. I hired him to track down info, and here he was delivering the first 100 rows, less than 24 hours after we started the project. As I went through the information, I noticed he had collected contact information for dozens of restaurant chains in Montana. While that information may one day be important, in pitching a cocktail-related drinking game, restaurants are probably at the bottom of the list. Shah and I recalibrate on goals, and locations, then I sent him back to check in at 250 rows.
Sure enough, 12 hours later, Shah sent me the first 250 rows. Everything looked great so I sent him off to collect the remaining 950 contacts as I tucked into bed, Shah just returning from his lunch break in Bangladesh.
As I thought about it more, there’s no way that Shah can be doing all of this research by hand. He’s got to have a bot or something scouring and collecting data. If that’s true, then he should be able to turn this thing around in a few days. Since it’s my first time hiring a freelancer, I decided to reach out to Shah to see how long it would take to get the full 1200 addresses.
Yes Sir Thanks for replay. I will complete it within 2/3 days. Or ASAP. Thanks- Shah
My man, Shah!
On Friday, I got this e-mail:
Hi, Sir, Here is Completed Task.. Kindly see and check my attach. Here is 9 tabs, Total 850 Rows. Previous 350 rows. Total 1200 Rows Completed. Rate $5 + $1 Upwork Fee. per 100 Rows. So, Total, 12* ($5*$1)= $72 USD. You Already paid $30.00 . Thanks-Shah
I checked into the spreadsheet and I was happy to see that he had collected a majority of the data I was looking for, but there was one caveat: the bars listed in the spreadsheet were all from Charlotte, North Carolina, rather than Portland, Oregon. So I reached back out to Shah, asking if there was any chance he was able to collect the 100 bar contacts in Portland.
After a little negotiation…
Ok I will Add new Row for that.
I woke up this morning and pulled up my e-mail, and sure enough, there was Shah!
Here is new Sheet. Kindly see and check this.
He provided one last spreadsheet with 99 bar contacts for Portland, Oregon (and one from New South Wales, Australia, which makes me sure he’s using a bot.) But that was absolutely great, and I couldn’t have been happier with the results of my first attempt at outsourcing.
All in all, this entire data collection project cost me a little over $70, including fees, and saved me hours upon hours of my own time. Collecting this amount of information would have most likely taken me a full 40-hour week, but working with Shah, the project breaks down to roughly $0.05 per contact. Not a bad deal!
Did you like this post? Check out some of our other popular Mystery Tin posts!
The Wisdom of Shark Tank is a mega-post of the insight I gained by watching every episode of the investment show Shark Tank.
Starting A Monthly Newsletter is a look at the inner workings of my new Mystery Tin Monthly e-mail newsletter. (You can sign up here!)
Personal Fire Ecology is a quick look at the rationale behind my yearly purge by fire.
How to Run a Successful Crowdsourcing Campaign is a fantastic overview of the nuts and bolts in running a crowdsourcing campaign.