Online communities offer a wealth of intelligence for blog owners and business owners alike.
Exploring the data within popular communities will help you to understand who the major influencers are, what content is popular and who are the key content aggregators within your niche.
This is all fair and well to talk about, but is it feasible to be manually sorting through online communities to find this information out? Probably not.
This is where data scraping comes in.
What is Scraping and What Can it do?
I’m not going to go into great detail on what data scraping actually means, but to simplify this, here’s a definition from the Wikipedia page:
Data scraping is a technique in which a computer program extracts data from human-readable output coming from another program.
Let me explain this with a little example…
Imagine a huge community full of individuals within your industry. Each person within the community has a personal profile page that contains information about their interests, contact details, social profiles, etc.
If you were tasked with gathering all of this data on all of the individuals then you might start to hyperventilating at the thought of all the copy and pasting you’d need to do.
Well, an alternative is to scrape all of this content so that you can automate all of this process and easily export all of this information into a manageable, more consumable format in a matter of seconds. It’d be pretty awesome, right?
Luckily for you, I’m going to show you how to do just that!
The Example of Inbound.org
Recently, I wanted to gather a list of digital marketers that were fairly active on social media and shared a lot of content online within communities. These people were going to be some of my core targets to get content from the blog in front of.
To do this, I first found some active communities online where these types of individuals hang out. Being a digital marketer myself, this process was fairly easy and I chose Inbound.org as my starting place.
Scoping out Data Requirements
Each community is different and you’ll be able to gather varying information within each.
The place to look for this information is within the individual user profile pages. This is usually where the contact information or links to social media accounts are likely to be displayed.
For this particular exercise, I wanted to gather the following information:
- Full name
- Job title
- Company name and URL
- Personal website URL
- Twitter URL, handle and follower/following stats
- Google+ URL, follower count and list of contributor URLs
- Profile image URL
- Facebook URL
- LinkedIn URL
With all of this information I’ll be able to get a huge amount of intelligence about the community members. I’ll also have a list of social media accounts to add and engage with.
On top of this, with all the information on their websites and sites that they write for, I’ll have a wealth of potential link building prospects to work on.
You’ll see in the above screenshot that a few of the pieces of data are available to see on the Inbound.org user profiles. We’ll need to get the other bits of information from the likes of Twitter and Google+, but this will all stem from the scraping of Inbound.org.
Scraping the Data
The idea behind this is that we can set up a template based on one of the user profiles and then automate the data gathering across the rest of the profiles on the site.
Once you’ve installed the plugin, you’re good to go on the actual scraping side of things…
To begin with, you’ll need to do a little Excel admin. Simply add in some column titles based around the data that you’re gathering. For example, with my example of Inbound.org, I had, ‘Name’, ‘Position’, ‘Company’, ‘Company URL’, etc. which you can see in the screenshot below. You’ll also want to add in a sample profile URL to work on building the template around.
Now it’s time to start getting hands on with XPath.
How to Use XPathOnURL()
This handy little formula is made possible within Excel by the SEO Tools plugin. Now, I’m going to keep this very basic because there are loads of XPath tutorials available online that can go into the very advanced queries that are possible to use.
For this, I’m simply going to show you how to get the data we want and you can have a play around yourself afterwards (you can download the full template at the end of this post).
Here’s an example of an XPath query that gathers the name of the person within the profile that we’re scraping:
A2 is simply referencing the cell that contains the URL that we’re scraping. You’ll see in the screenshot above that this is Jason Acidre’s profile page.
The next part of the formula is the XPath.
What this essentially says is to scrape through the HTML to find a tag that has ‘user-profile’ id attached to it. This could be a div, span, a or whatever.
Once it’s found this tag, it then needs to look at the first h2 tag within this area and grab the text within it. This is Jason’s name, which you’ll see in the screenshot below of the code:
Don’t be put off at this stage because you don’t need to go manually trawling through code to build these queries, there’s a much simpler way.
The easiest way to do this is by right-clicking on the element you want to scrape on the webpage (within Chrome); for example, on Inbound.org, this would be the profile name. Now click ‘Inspect element’.
The developer tools window should now appear at the bottom of your browser (or in a separate window). Within that, you should see the element that you’ve drilled down on.
All you need to do now is right-click on it and press ‘Copy XPath’.
This will now copy the XPath code for your Excel formula to the clipboard. You’ll just need to add in the first part of the query, i.e. =XPathOnUrl(A2,
You can then paste in the copied XPath after this and add a closing bracket.
Note: When you use ‘Copy XPath’ it will wrap some parts of the code in double apostrophes (“) which you’ll need to change to single apostrophes. You’ll also need to wrap the copied XPath in double apostrophes.
Your finished code will look like this:
You can then apply this formula against any Inbound.org profile and it will automatically grab the user’s full name. Pretty good, right?
Check out the full video tutorial below that I’ve put together that talks you through this whole process:
XPath Examples for Grabbing Other Data
As you’re probably starting to see, this technique could be scaled across any website online. This makes big data much more attainable and gives you the kind of results that an expensive paid tool would offer without any of the cost – bonus!
Here’s a few more examples of XPath that you can use in conjunction with the SEO Tools plugin within Excel to get some handy information.
Twitter Follower Count
If you want to grab the number of followers for a Twitter user then you can use the following formula. Simply replace A2 with the Twitter profile URL of the user you want data on. Just a quick word of warning with this one; it looks like it’s really long and complicated, but really I’ve just used another Excel formula to snip of the text ‘followers’ from the end.
=RIGHT(XPathOnUrl(D57,"//li[@class='ProfileNav-item ProfileNav-item--followers']"),LEN(XPathOnUrl(D57,"//li[@class='ProfileNav-item ProfileNav-item--followers']"))-10)
Google+ Follower Count
Like with the Twitter follower formula, you’ll need to replace A2 with the full Google+ profile URL of the user you want this data for.
List of ‘Contributor to’ URLs
I don’t think I need to tell you the value of pulling in a list of websites that someone contributes content to. If you do want to know then check out this post that I wrote.
This formula is a little more complex than the rest. This is because I’m pulling in a list of URLs as opposed to just one entity. This requires me to use the StringJoin function to separate all of the outputs with a comma (or whatever character you’d like).
Also, you may notice that there is an additional section to the XPath query, “href”. This pulls in the link within the specific code block instead of the text.
As you’ll see in the full Inbound.org scraper template that I’ve made, this is how I pull in the Twitter, Google+, Facebook and LinkedIn profile links.
You’ll want to replace A2 with the Google+ profile URL of the person you wish to gather data on.
=StringJoin(", ",XPathOnUrl(A2,"//a[@rel='contributor-to nofollow']","href"))
Twitter Profile Image URL
If you want to get a large version of someone’s Twitter profile image then I’ve got just the thing for you.
Again, you’ll just need to substitute A2 with their Twitter profile URL.
=XPathOnUrl(A2,"//*[@class='profile-picture media-thumbnail js-tooltip']","data-resolved-url-large")
Some Findings from the Data I’ve Gathered
With all big data sets will come some interesting findings. Here’s a few little things that I’ve found from the top 100 influential users on Inbound.org.
The chart above maps out the average number of followers that the top 100 users have on both Twitter (12,959) and Google+ (9,601). As well as this, it shows the average number of users that they follow on Twitter (1,363).
The next thing that I’ve looked at is the job titles of the top 100 users. You can see the most common occurrences of terms within the tag cloud below:
Here’s the spread of domains that were the most popular to be contributed to:
It Doesn’t Stop There
As you’ve probably gathered, this can be scaled out across pretty much any community/forum/directory/website online.
With this kind of intelligence in your armoury, you’ll be able to gather more intelligence on your targets and increase the effectiveness of your outreach campaigns dramatically.
Also, as promised, you can download my full Inbound.org scraper template below:
Want this post as a PDF? Fill in your name and email address below and we will email you a download link :)
- Online communities hold valuable data on your target audiences – use it!
- Scale out your intelligence gathering by brushing up on your XPath.
- Download my Inbound.org scraper template and let it work its magic.