"Updating 4 old hubs a month" Hub Challenge
What a great idea, cashmere! Don't forget, you can post your updated Hubs in this thread to showcase your progress.
You are allowed to share your Hub Challenge Hubs.
Okay re-reading old hubs is a painful process. One winces at each mistake made
Any how, I managed to combine two not so great hubs based on Tarot into one decent hub that offers quality. Have deleted the one called Tarot decks and republished the one called Free Tarot Card Readings http://cashmere.hubpages.com/hub/Free-T … d-ReadingsOkay 4 old hubs updated in following manner - 2 deleted and 2 updated with current material and stuff
Challenge completed for this month, just 206 more hubs to wade through!
Thank you for this thread, cashmere. I've been updating a lot, always finding something that could be better. My biggest Achilles heel is photo attribution. When I started at HP last year, I didn't do it correctly and have been going back, hub by hub, to change some images, improve quality, and correctly attribute them. There is one hub that need new images but I haven't found the time to cook the food to take the pictures to add to the hub! I feel bad that it's incorrect all this time, especially since it's my best performing hub. You've given me incentive to make the time. It's just been too hot to cook oxtails.
Just discovering the thread a hearty best wishes and go-go-go with the aspirations. Have you tried downloading your .csv file at the statistics page onto an Excel spreadsheet yet? You can insert a column and label your hubs with the grouping. Then you can look at the group that is performing best and work toward that rather than hubs here and there.
Plus, for me it seems much more an objective viewpoint rather than a subjective one. You can use the sort and filter features. For instance group them by ever views then 30 day view with the filter. For me I see which really stand out like there is a high ever view and no 30 day view vs. a medium ever views and high 30 day view vs an low ever views and zero 30 day view. I can prioritize differently. Then it does not seem overwhelming for me. I know which to work on adding strength to a group and the overall portfolio.
I created groups with names like 'Rethink', 'Rewrite', and 'Delete' for hubs I decided to unpublish those strengthening the overall portfolio. Getting the ones I have doubts over out of the way made the ones I feel best a happier experience. Hence I use the grouping page or the downloaded .csv file converted to an Excel file instead of the statistics page where they all seem to just stare at me.
I say you are doing the best choice with the aspiration. What I suggested you may already be doing. I dun'no . . . but, sharing I find it much easier as groups and those strengths and examining away from HP much less stressful and more objective. The ambiance of my history with HP is not present on the spreadsheet. Only the facts and figures are. I hope this may be of some help.
This is a great idea! I'll participate with you. I don't have that many, but already some of them could use a dusting off. I'll be back soon with some that I've updated and look forward to seeing the ones ya'll update too.
Please feel free to join in Sherry!
Misslong123, I am struggling with my excel file as I type! There are just so many fields and too much data to processCashmere. (I simply do not know what you know of Excel. This may seem redundant. If it does I apologize
)
For the beginning just download the file and leave them in the columns assigned by the csv file.
Now, right click on that worksheet tab. In the PopUp where it says 'Move or Copy' select that. Highlight (Move to End) & click the box [Create a Copy]. Click OK. Now you have two identical sheets. Using right click on the worksheet tab rename the original - Master WorkSheet or just Master. Name the new one Playground or something.
At the first play/learn worksheet Right click on row 1. Select Delete. It is not needed. If you need to know what that original row deleted said then look at the Master WorkSheet.
Use the second copy or what I call the Playground worksheet copy begin your changes and practicing if not familiar with Excel. Again I simply am unaware if you are or not familiar with Excel. So, this is a beginning to play set of instructions.
Next, practice using the data tab features. Sort and filter. They will not change the fields, rows or columns permanently. They can be sorted back to the column labeled 'Name' anytime you like. Sorting by a column name for highest first or least will show you a way to compare hubs.
Do the following . . .
Sort the 'Total' views by largest to smallest. Highlight the top 25 or ?? with a color in that column only - light green
Sort the '30 days' views by largest to smallest. Highlight the top 25 or ?? with a color in that column only - light yellow
Now sort by title. They will be alphabetical. Look at the ones that both colors are in the same row. Those are your top hubs for the last 30 days and Total views that are a Top 25 or ??? performer. That is just a start and practice with the sort feature.
The most easiest information you will need to know is the average for hubs by month. In the column next to 'Featured' (Featured = Column N) label the column Mths Pub (It should be column 'O' (if no columns were deleted and the first column is 'A') Then type the number for months published ( 1 - 12 - 18 - ???) for each hub/row in the corresponding cell in the Mths. Pub column. The first hub/row for Mths. Pub will be cell O2
Then, at the next column label it Mths Avg. Now, type the 'equal' sign in cell for the first hub in column Mths. Avg. (should be P2 if no changes were made to the original csv file). Next, after the equal sign type O2/P2. It should look like this =O2/P2. Hit enter. The product will be the average of hubs read per month.
Now click in that cell and hold the cursor until the fat plus sign appears at the bottom right of that cell. The plus sign will become skinny. Next, with that skinny plus sign showing right click the mouse and hold it down. Drag downward. You will see a highlighted field appear. Drag all the way to the last hub/row.
Once at the bottom lift up from the right side mouse. A pop-up window will appear. Select 'Copy Cells'. The formula will be copy/pasted for every cell highlighted in that column - Mths Avg for each hub by row. You will now have the average by month.
Next, sort again by that column name - Mths Ave, for largest to smallest. Highlight and color the Top 25 or ??? those cells say light blue. Now you can see all the top performing hubs by color for Average Month, Total Views, and last 30 Days. The ones with all three colors are the very best. The ones with Total and Average and not the last 30 days are the Next Best and so forth.
Color code the hub title name by Very best say Gold. The next Best say Dark Yellow. And the Next best a different color.
Now play and discover. The goal is to discover for 'you' the strongest. In the column next to Mths Avg (should be column Q) use a code system for what you wish to do with hub. K = Keep. RW = Rewrite. D = Delete. UP = Unpublish. Or, what ever you come up with. Next, sort them by that column and they will be grouped by your Action Plan for hubs.
Copy that worksheet and name it playground 2. Look closely at each grouping of the Action Plan. Consider this is just to look about and see the best as they are today. It is not a means for measuring performance on a weekly or monthly basis. Just a place to decide what to do.
Related Discussions
- 1105
Post Your Hub Challenge Hubs Here
Thought that this new thread would make it easier for everyone to share their hubs for the Hub Challenge.....jimmyhere is my first http://hubpages.com/hub/Ladies-Rolex-Watches
- 73
Hub Challenge - transforming Old Hubs to Stellar Hubs
Take one of your old hubs, update it with new content, better photos, improved titles and add some additional modules (make it a stellar hub effectively) and then post it here for critique!
- 31
if u pay people to write hubs, make sure they know english
I just read the hub challenge that asked us to flag hubs that were poor in quality, etcso, out of curiosity I went to the Hubs section and hit latest and ....holy cwap, batman!!! there is so much junk here. It is clear that many either wrote a hub in their native language and translated it via...
- 286
Sign Up Here for the November Hub Challenge
First of all, I'd like to thank KCC for the October Challenge and the whole idea of a bunch of us joining together each month to encourage and support each other on the HubChallenge. I had a ball last month and it was great to get to know so many of you a lot better.KCC and I had so much fun in...
- 42
Modified 100 Hub Challenge in 30 days
I haven't been actively writing on Hub Pages in a while and want to get back into this and this might get me motivated.I remember hearing about a 100 hub challenge some years ago and I know that I could not possibly write 100 hubs in a month. That is why I am attempting to do this in a...
- 12
The Anti-Hub Challenge- a challenge for everyone
I posted a hub the other day titled simply the Anti Hub Challenge. In it, I gave some of my views on what others have mentioned and noted that has been happening on hubpages in regards to spam and substandard articles. I also put forth a way that all of us, for whatever reason suits us, can...