If you work in a small but fast growing agency, you have probably experienced the ‘joy’ of tight deadlines and low budget. Nevertheless, if you want to prove yourself as a good specialist some creativity and technical skills could worth its weight in gold.
So, how to deliver an outstanding analysis at no cost? Of course, the first thing that comes up into the mind is manual counting of all the data you need (likes, shares, comments, amount of posts etc.). Well, I’ve been there, and I can reassure it’s not the most enjoyable practice, especially when your competitors have 200 posts/day (no, I’m not exaggerating).
And here I am with one of my colleagues, thinking of an easier way of doing the job.
Different channels have different approaches. So far, we have found methods of counting the engagement (likes, shares and comments) on Facebook, Twitter, LinkedIn, YouTube, and G+. The last four have a similar approach; Facebook, though, is a bit more complex.
The magic tool that can help you is called “scraper,” which you can find in your browser extensions:
The first thing you need to do is to open the competitor’s profile page and scroll down to the last post you need, I usually take the time frame of 1-3 months, depending on the number of posts. Then right-click on the number of likes and choose “scrape similar”.
This window will pop up. To have the data for all the posts, you will have to delete the first number in the code, in my example it is . Then copy them to the clipboard and paste into an excel file.
There you can count the sum. The only issue with this tool when using it on Twitter and LinkedIn is that it duplicates the values; that’s why, in the end, you’ll have to divide the results by 2.
Also, you have probably seen that there is more than one column in my file. The reason is that the tool scrapes just similar posts; that’s why, if you chose to scrape a post which contains an image, you’d have to do the same for a post which doesn’t have any attachments and then repeat the process to get the shares/retweets.
Hope this helps. In case you know any easier way of getting these stats, I would love to read them!