How to organize your hubpages links: Using Microsoft Excel to generate more traffic to your hubs

Use Excel to Organize Your Hubs

Organize to provide relevant backlinks and drive traffic to your hubs
Organize to provide relevant backlinks and drive traffic to your hubs

Why you need to organize your hubs

As I write more and more hubs, I am beginning to find it difficult to efficiently link other related hubs that i have written in the past. I believe this is likely to be a common problem here on hubpages and would like to give my best advice on how to organize your hubpage articles using Microsoft Excel.

The main reason I think that it is so difficult to create backlinks to my previous articles is due to the fact that as the number of hubs that i write continues to grow the harder it is to find them simply by "eyeballing" similar topics that are already published under my user account. When I only had a couple of hubs, I could easily glance at the list of my published hubs and cut and paste the URL into a relevant keyword, or create a list of related links at the bottom of the page that might be useful to the readers enjoying my most current hubpage. Now that I have 30+ articles it is far too easy to scroll up and down my list of published hubs and miss one or several hubs that is relevant to my new article.

The underlying issue is one of organization. I am not organized by any stretch of any definition of any dictionary you would ever happen to come across. I do try, but mostly I fail. Unfortunately, once you find yourself with more and more articles here on hubpages, you have to make the decision to either become organized in your writing, or miss out on great opportunities to create backlinks to your other hubs, and hence lose out on making money on hubpages. This is especially difficult for me because, as I mentioned earlier, I am not a naturally organized person, and also because I write about a variety of different topics. Some fine hubbers here are what you would call "niche-hubbers", as they are able to create really good hubs on one or two related subjects. Now, they may not necessarily need to organize their hub links since every topic they write about is similar. Let's say their niche happens to be personal finance. After they finish writing their article titled "Retirement Savings", they can easily chose from any of their previous hubs on "401Ks", "Roth IRAs", "How to pick an Investment Advisor", "Early Retirement", and "Riding the ups and Downs of the Stock Market" and create the links. They do not even have to really put any thought in it, but rather just cut and paste a few of the URLs into their new hub and move on. While all of these subjects are related, some of the better authors here on hubpages are able to take it a step further and sub-categorize their topics. For instance under their "Retirement Savings" hub they may choose to only link "401Ks", "Roth IRA's", "Early Retirement", and other more specific writings that they have on retirement subjects.

When I first start writing her on hubpages, I had planned on sticking to one niche, but as I mentioned a couple of times above I am generally unorganized, or scattered, and I believe that this is reflected in the variety of subjects I have written about here.

While I do have primary interests I try to focus on in my writings, I am easily distracted and often find my writings follow my new interest that week. I may churn out a couple of different recipes I like one week, and then switch over to about investment strategies, technology, or passive income with my next several hubs. I don't necessarily think that this is a bad thing, however, because I like to write and when I write I found it is much easier to write about my interests. It also provides me with opportunity to see which types of hubs are most successful simply by checking my account to see the number of views I have for each of my hubs. However, I really do need to organize my different writing categories so that I can efficiently provide useful backlinks in my hubs. The truth is that in the past I had often provided links to totally unrelated topics. Like, if you were to look under my hub about The Best Office Chairs, you will find links for a weekly budget planner and Starbucks Financial Analysis. These two links i provided have absolutely nothing to do with the Best Office Chairs. I have realized that the chances on someone clicking on one of these links and driving traffic to my other pages is very slim at best. So, why take the time to even add them in the first place. The answer to that riddle, is that I shouldn't... If I don't have any relevant links, I should be helping to promote other related links here on hubpages, even when they are not my own.

Anyway, to get back on subject... I write about a variety of topics, and I have found that I need to organize these hubs based on related content I have written, so I created a Microsoft Excel document to help organize them for me.


Sorting through your hub topics with Excel

Microsoft Excel can allow you to track your URL's and create a quick and easy way to cut and paste relevant hubs you have already written.
Microsoft Excel can allow you to track your URL's and create a quick and easy way to cut and paste relevant hubs you have already written.

The first step to organizing your hubpage links

The first step is to go to your user page, also known as "My Hub Statistics" and download the files. This will save you the time of manually writing out all of your hubpage titles, URLS, and other various information that you are provided by Hubpages. In order to do this, you just need to look towards the top left above your listed hubs and click on the export CSV file. Click on the link and a dialouge box will pop up asking if you want to open or save the file. you should save the file and store it in a folder with other related hubpages information (I keep it in a file with my hubpages ideas, and hubpages earnings data). I am trying to update this monthly, but you can also jsut update it after a set amount of hubs (like every 5 hubs you update the data to your excel document with organized hubpage link.

Now, when you first download the CSV file it will come to you in standard form, meaning that everything that hubpages has listed on your "My Hub Statistics" page will show up. Some of this can be deleted, while somethings you might opt to keep. I will keep the "Published" and "Changed" columns, so that I can create links for recent writings on the subjects, as well as know if it is time to update an older hub. You can keep or delete any of the data that is exported from the CSV file.

For the example below which I am keeping simple I am only going to be showing a few of my hubs, as if I did all of them they would take to much space on this hub. You will want to make sure you categorize all your hubs when you organize your own personal hubs. I am just going to keep the Title, and URL address, which should be a sufficent way to organize your hub backlinks for the new hubbers here. I will then go through and add new first column based on the subjects the hubs are based on and label this column Subject/Category (However, other data like views, published, and changed also provide useful information for tracking your hubs over time).


Unorganized Hubs (with only URL and Title)

URL
Title
http://meangreen.hubpages.com/hub/marketing-strategy-examined-An-analysis-of-Hershey-and-Mars-The-Kings-of-Candy
target marketing strategy examined: An analysis of Hershey and Mars (The Kings of Candy)
http://meangreen.hubpages.com/hub/frugal-living-and-having-fun-live-like-a-king-on-a-jesters-salary
frugal living and having fun: live like a king on a jester's salary
http://meangreen.hubpages.com/hub/Starbucks-Analysis
Starbucks Strategic Analysis (New strategies to stay ahead of coffee competitors)
http://meangreen.hubpages.com/hub/Specialty-coffee-industry-analysis
Specialty coffee industry analysis (is starbucks still the king?)
http://meangreen.hubpages.com/hub/how-to-start-a-new-business-5-basic-steps
how to start a new business: 5 basic steps to owning your own company
http://meangreen.hubpages.com/hub/Best-office-chairs
Best office chairs (reasonable desk chairs for your work)
http://meangreen.hubpages.com/hub/How-to-make-hot-and-sour-soup
How to make hot and sour soup
http://meangreen.hubpages.com/hub/Passive-Income-Opportunities-The-Best-Ways-To-Make-Passive-Income
Passive Income Opportunities: The Best Ways To Make Passive Income

The second step to organizing your hub links

The second step to organizing your hublinks is simply to provide general categories next to each of your hubs. Don't worry about getting to detailed, and if you happen to have one that doesn't easily fit into a category that you can think of, you can simply call it "Miscellaneous".

To add the new category click on the column marked "A" and right click. A vertical toolbar will pop up and give you a list of options. You will want to choose the "insert" option. This will create a new column which you will categorize as "Subject/Category". You will then go on to list the general categories next to each of the hubs (for instance, you can see below that I categorized the titles: Target Marketing Strategy Examined, and Starbucks Strategic Analysis, as Business Analysis, while How to Make Hot and Sour Soup was categorized as Recipes.

Once you have typed in the relevant general categories under the "Subject/Category" column, you simply need to highlight the the categories you just listed (do not accidentally highlight the "subject/category" heading...) and right click. You will once again get a vertical toolbar with options, and you will want to choose the "sort" option. Once you click the "sort" option you will be given another list of different functions you can use to sort the data. The easiest way to do this is to select a alphabetical sort. To do this click on the top icon that says "Sort A to Z", and it will sort each column alphabetically based on the "subject/category" name. The results of adding the categories and sorting those categories are shown in the table below.

The more hubs you have on a particular subject, the more detailed you can be with your category selection. Say for instance that I happed to write up 30-40 more recipe hubs. I could then sub-categorize each recipe based on type of food, and label my hub on How to Make Hot and Sour Soup as Chinese Recipes.

Organized Hub Links (now categorized and separated based on Subject/Category

Subject/Category
URL
Title
Business Analysis
http://meangreen.hubpages.com/hub/marketing-strategy-examined-An-analysis-of-Hershey-and-Mars-The-Kings-of-Candy
target marketing strategy examined: An analysis of Hershey and Mars (The Kings of Candy)
Business Analysis
http://meangreen.hubpages.com/hub/Starbucks-Analysis
Starbucks Strategic Analysis (New strategies to stay ahead of coffee competitors)
Business Analysis
http://meangreen.hubpages.com/hub/Specialty-coffee-industry-analysis
Specialty coffee industry analysis (is starbucks still the king?)
Business Analysis
http://meangreen.hubpages.com/hub/how-to-start-a-new-business-5-basic-steps
how to start a new business: 5 basic steps to owning your own company
Miscellaneous
http://meangreen.hubpages.com/hub/Best-office-chairs
Best office chairs (reasonable desk chairs for your work)
Personal Finance
http://meangreen.hubpages.com/hub/frugal-living-and-having-fun-live-like-a-king-on-a-jesters-salary
frugal living and having fun: live like a king on a jester's salary
Personal Finance
http://meangreen.hubpages.com/hub/Passive-Income-Opportunities-The-Best-Ways-To-Make-Passive-Income
Passive Income Opportunities: The Best Ways To Make Passive Income
Recipes
http://meangreen.hubpages.com/hub/How-to-make-hot-and-sour-soup
How to make hot and sour soup

A final word about using excel to organize your hubs

Hopefully this hub will help those of you that are facing the same dillemma that I do when trying to provide backlinks in my new hubpage articles. I just want to reiterate that this information was jsut an example and I would highly encourage you to play around with Excel and find out the various ways to categorize your hubs and sort as well as store the data that hubpages supplies us. It is a very valuable resource and I hope you will use it in order to improve your future hubs.



Comments 6 comments

Jessi10 profile image

Jessi10 4 years ago from Lancaster, CA

This is one great Hub! I need to do this. I've been trying to organize my hubs as much as possible, it just seems so hard because i'm constantly writing more! Voted UP and Sharing!


oliviaharrisbrown profile image

oliviaharrisbrown 4 years ago

Useful information. Thanks for sharing!


Millionaire Tips profile image

Millionaire Tips 4 years ago from USA

I have thought about trying to organize my hubs on Excel, but it seems like a cumbersome task to keep up. Have you thought about using the Groups feature on HubPages?


MeanGreen profile image

MeanGreen 4 years ago Author

Thanks, Jessi. Glad you enjoyed... It takes a little bit of time to do, but you gain that time back really quickly!


MeanGreen profile image

MeanGreen 4 years ago Author

Thanks Olivia!


MeanGreen profile image

MeanGreen 4 years ago Author

I will look into it, what do you know about it?

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working