Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.
If you’ve written five hundred articles and the only three articles you wrote on “mobile gaming” are all receiving the most traffic at your blog, then you know it’s a topic your visitors are hungry for.
One way that you can easily identify these sort of trends, especially when you have hundreds and hundreds of articles on your site, is to go through your top performing 50 to 200 article titles and identify certain patterns.
These patterns will be groups of two to five words that repeat with a certain frequency. In this article, I’m going to do an analysis of the keywords on one of my private blogs to show how you can come up with cool article topic ideas that you know your visitors will be interested in.
How to Identify Keywords From Top Performing Articles
The first step in doing this analysis is to extract your articles that are attracting the most organic traffic. Organic traffic is the incoming traffic that you’re collecting from search engine queries.
First, log into your Google Analytics account and under “Content” click on “Content by Title.”
This sorts all of your pages with the most traffic from the most visited page down to the least. Now, this information itself is valuable, because often just by glancing down through titles you may recognize an obvious trend and see a topic that your readers seem particularly interested in.
The genre of this particular website, a conspiracy theory site about top secret projects and spying, is such a fringe topic that article titles run the gamut. With such a site, I really need a good way to dig more deeply and identify word trends that indicate a common topic that my readers like. First, scroll to the bottom of the list and change the display from 10 to 50 titles.
Once this page lists all of your top 50 titles, all you have to do is export the list to Excel so that you can easily pluck out the titles for analysis. You can do this export by scrolling back up to the top of the screen and clicking on “Export” and “CSV for Excel.”
This exports all 50 titles, as well as their statistics, directly into an Excel spreadsheet. Once the sheet is open, you can scroll down to the titles, highlight all 50 and copy the entire list to your clipboard (either right-click and copy or use the Excel copy function).
Paste this list into your favorite text editor. For me, it’s Notepad – but make sure to choose one that has a good “search/replace” feature so that you can clean up the titles for better analysis.
Clean Up The Titles
Once you’ve got the list of titles in text format in your text editor, it’s in the perfect format for identifying word frequencies. However, before you can do a good analysis, you need to clean up the titles. Google Analytics usually appends the name of the website to each title, so you’re going to have to clean this up. You can do this in any standard text editor using the Search and Replace feature.
In this case, I’ve copied the bit of text at the end of one of my titles that contains the unique text “| Top Secret Writers” and using the Replace feature in Notepad, I’m replacing that text with nothing. When you click “Replace All” it’ll clean up your entire list. Since the text includes the symbol “|” at the beginning, your titles that simply feature your website name won’t be modified.
Now that you have a nice, clean list of your top 50 titles. By the way, if you have hundreds or thousands of articles on your site, you may actually want to select 100 to 200 of the top titles, rather than just the top 50. In my case, my site is so small and new that the top 50 should provide a good enough snapshot.
Conduct The Word Frequency Analysis
Highlight your list of cleaned-up titles, and then head on over to the free online text analysis tool at Online-Utility. I’ve found that while there are a lot of “text analysis” tools available online, this one is one of the best because it breaks down keyword patterns into phrases that are one to five words in length. Just paste your list of titles into the large text field in the tool.
Click on “Process text” and within less than thirty seconds, you’ll receive a full report of word and phrase patterns recognized throughout your list of titles.
Unless you have a lot of titles on your site, the longer phrases don’t always identify clear standout leaders in terms of occurrences, but often even on smaller sites the single word analysis section will reveal some hidden gems.
As you can see, the list above tells me that aside from the common words “and”, “of” and “the” – the titles where I use the words “ufo”, “secret”, “alien” and “cia” are by far the most popular of all of my titles. Focusing on those particular topics, I will be catering to what my readers clearly enjoy reading about on my blog.
Did you try this analysis on your own blog, and if so, what did you learn? Do you know any other cool keyword analysis tools? Share your insight in the comments section below.