Back in April at Linklove, I presented on Tools of the SEO Trade. In that talk, I talked about somewhere in the neighborhood of 60 different tools available for use. I built out a couple for people to use as well (for free), and today I want to talk about one of them.
Introducing the Quora RSS
One of the tools I built out, which is actually a tool that I built back in January or February for a client, is a Google Spreadsheet that imports the most recent Quora posts based on a Quora category. I’ll explain this further down, but if you’re impatient you can:
How It Works
This spreadsheet is pretty simple, and the purpose is to help you find out what people are talking about pertaining to your topic so that you can get content creation ideas.
When you first load up the above sheet, you will see this:
What we are doing is using =importfeed to pull the RSS for the topic from Quora in order to import the 20 most recent questions within that category. Let’s break down an =importfeed function real quick so that you can see exactly what is going on:
Let’s say I want to import the most recent questions asked in the Pinterest category. Here is our function:
The parts are:
- The RSS URL (which for Quora is http://www.quora.com/CATEGORY/rss)
- “Items Title”, which is the question title (the other options are listed in the importfeed Support Doc);
- “False” because I don’t want the column headers;
- “20″ is the number of results I want pulled.
Finding the Quora Category
Step one, of course, is figuring out what you want to write about. Then, search for the category of the topic you are seeking to write about. I recommend using this search:
If I am going to write something about, say, Harry Potter, I would do:
“harry potter” site:quora.com
The URL you want will usually be the first result. For the above Harry Potter search, we get this SERP:
As you can see, the Quora URL for this search is “Harry-Potter”. There is also, right below it, “Harry-Potter-4″, which means that there is also “Harry-Potter-2″ and “Harry-Potter-3″ at least, and possibly “Harry-Potter-5″ and higher.
You’ll want to use the base result to get as many of the recent questions as possible. So our ImportFeed URL now becomes:
That’s it! It’s a pretty quick-and-dirty, not-too-complicated, simple way to import Quora RSS feeds and see what people are asking about your topic so that you can write content that people are already asking about and searching for.
A couple of other useful importers as well:
- Kate Morris’ eHow Importer from Boston ProSEO 2011
- SEOgadget’s Content Strategy Generator V2 (which is freakin awesome)