September 25, 2021

How I generated 2500+ organic leads on Linkedin on autopilot

It was the morning after I posted a giveaway on Linkedin for marketing spreadsheet utilities I had developed while I was running my own agency. What I saw the next day was something I hadn’t expected at all.

2500+ comments 700+ Likes and 300+ connection requests

The technique was simple, get people to comment in order to get more reach on Linkedin. So I told them to comment with their email addresses. I was sceptical whether people would comment for privacy concerns but a lot of them did. Over the next week, my inbox was filled with messages and my profile views went through the roof.

But I made a promise to email the resource to everyone who commented and comments were in all shapes and forms. So the challenge was not only to scrape the comments but to extract the email addresses from the comments.

While I tried writing javascript code to scrape the comments but Linkedin loads only 10 comments at a time. So technically I will have to load more 250 times to get to the bottom of the page.

Looking for better alternatives, I signed up for the free trial of PhantomBuster and used their LinkedIn comment extractor to extract all comments with the profiles of the commenters and put them in a spreadsheet.

Clean-Up Process in Spreadsheet

Though I was able to extract the comments in a CSV, that was only half the job. The data was not suitable to extract the emails. Since there were line breaks in the comments, I used “find and replace” in a spreadsheet and replaced “\r\n|\n|\r” with “ “ to remove all line breaks from the comments. Then I used

=TRIM(MID(SUBSTITUTE(TRIM(G5), “ “, REPT(“ “, 200)), (LEN(LEFT(G5, SEARCH(“@”, G5)))-LEN(SUBSTITUTE(LEFT(G5, SEARCH(“@”, G5)),” “, “”)))*200+1, 200))

to extract the emails from the raw comments. This formula essentially creates 200 empty spaces between words and then searches for @ in the comments to extract the email using Mid function and then trims back the sentence. The final spreadsheet looked something like this.

Living up to the promise

The next challenge was to use some free tool to send out emails without having to land up in spam because of the sheer volume of these emails. Additionally, I wanted to track my email opens as well.

So I used Mailtrack’s free version to send campaigns in batches of 200 emails and used my personal Gmail id to make the email look authentic. The copy went something like;

I wanted to make sure I remind people of the reason behind the email so I attached the screenshot of the post they commented on and also asked them to write back if they felt the need to.

Additionally, I directed traffic to my blog and got people to subscribe to it and most of the people did. People liked the free tools and there was nothing more I could expect with a single post and 0 marketing spend.

Content is King

The post was posted at around 5 PM (IST) on a Saturday evening with only 4k connections at the time and no fanbase on LinkedIn whatsoever. This goes awry from the advice of any marketing guru to be successful on Linkedin. So my rule is simple, just post content that you think is valuable for you.

I spent a good amount of time developing these resources and have used them multiple times with new projects to speed up some of my manual marketing work. This was thus appreciated by fellow marketers as well and this is how I hacked my growth on LinkedIn.

Related Blogs

7 Facts revealing the true face of Facebook

7 Facts revealing the true face of Facebook

After reading this research article, you would definitely doubt the effectiveness of the most popular social media platform and yes you guessed it right, it’s Facebook. With its most legitimate revenue coming from ads-based revenue but have you ever pondered over the authenticity of the entire model? While one could easily increase its reach on […]

Read More »
Master your email marketing with these 6 Golden Pro Tips

Master your email marketing with these 6 Golden Pro Tips

Since the dawn of the internet age and the invention of the popular mailing service HotMail, one of the most profitable and of course misused marketing channels is email. If you are a marketer living in India you are fortunate enough to have the most relaxed rules when it comes to email marketing. Refer to […]

Read More »
3 highly secret Facebook marketing hacks!

3 highly secret Facebook marketing hacks!

If you are doing paid media marketing, chances are you must be heavily relying on Facebook to fuel your marketing ROI. While ads and landing pages are a good place to start optimising your Return On Ad Spends (ROAS), nothing is more important than targeting the right audience. You can’t expect to sell dog food […]

Read More »
How to do AB testing, the fail-proof way!

How to do AB testing, the fail-proof way!

Marketing is science, an iterative process that involves testing and one of the common practices in testing is the A/B test. But unfortunately, over 90% of AB tests that are conducted, are done with the right intention but the wrong method. Typically this has got to do with Type1 and Type 2 errors with Type1 […]

Read More »
How to Predict Sales using Machine Learning

How to Predict Sales using Machine Learning

When it comes to forecasting sales, most marketers rely on a simple function in excel, sometimes their boss’s fancy or even wild conjectures. While realistic forecasts are hard to put together, marketers can leverage pre-built machine learning regression models to their use. This now only gives realistic and pretty accurate predictions about your sales and […]

Read More »
Create a sales funnel that brings in customers every time!

Create a sales funnel that brings in customers every time!

The World Wide Web has evolved multi folds over the last decade and to sell online is no longer just about having a website. With over 1.5 billion websites, businesses have little evolved to capture that attention and sell their products the way it works. Everything starts with a sales funnel. I am not going […]

Read More »
Do these 5 things before your next marketing plan

Do these 5 things before your next marketing plan

Be it your assignment in your job application or a client pitch for your agency, if there is one thing people ask for is a Digital Marketing Plan. I am not going to bother you with free templates to design your plan, instead what I am going to focus on is the way to think […]

Read More »
Steps to advance AdWords search campaign audit

Steps to advance AdWords search campaign audit

If you are working in a niche market, search networks on AdWords and bing are bound to give you the most relevant traffic on your website. Here you have control over what search terms to target and optimize for long-tail keywords that have higher conversion rates. This scenario might sound like an SEO problem but […]

Read More »
Email tactics that 96% of email marketers don’t know!

Email tactics that 96% of email marketers don’t know!

In 2019, global email users amounted to 3.9 billion users (Statista, 2020). This figure is set to grow to 4.3 billion users in 2023. That’s half of the world’s population. With such a ubiquitous channel for communication, companies rely heavily on email marketing to grow sales in the pursuit of cheaper conversions. But off late email marketing […]

Read More »
Marketer’s guide to Markov and Shapley Multi-Channel Attribution models

Marketer’s guide to Markov and Shapley Multi-Channel Attribution models

When it comes to multi-channel attribution models, the 2 most common models are Markov and Shapley models. While there are plenty of blogs talking about these models along with the Python libraries to implement them, it was a struggle to find resources that talk about these models, not to a data scientist but a marketer. […]

Read More »

Subscribe to my newsletter

[contact-form-7 id="919" title="my form"]

Form

Copyright © 2020. AnkitBagga. All rights reserved.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram