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.
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.
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.
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 […]
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 […]
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 […]
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 […]
While machine learning and artificial intelligence are making news every now and then, it hasn’t changed the way we do marketing. Most marketers rely on the pre-built models in tools to guide their way through machine learning. While there are challenges in terms of learning python and implementing a lot of the machine learning models […]
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 […]
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 […]
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. […]
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 […]
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 […]