Q4 2009 Review
January 1, 2010 • JP • 4 Comments • Rate This Article
• Links to this article
Turns out, it's been a great year for this site! Goodbye 2009, hello 2010 (do you say "twenty-ten," or "two-thousand-and-ten"?)
Categories and tags have been streamlined, keywords and descriptions optimized, archives and navigation improved. As a result this blog (well, the front page anyway) has reached PR 4! 
I never thought that would happen.
Hits
- Bounce Rate: 74%
- Avg Time on Site: 1:53
- New Visits: 79%
- Visits: 52,000
- Pageviews: 98,000
- Pages Per Visit: 1.89
Note: this doesn't include December 31st.
We had the most single-day visits ever during this quarter (920 on 11/17/09). 13% of overall traffic is from refers, and the bounce rate and pages per visit are astounding: 58% bounce rate and 2.5 pages per visit for referring sites. So a big thank you to the following people for linking to and talking about this site:
- Poer from Excel VBA Macro
- Mike from DataPig Technologies
- Chandoo from PHB
- Dick from DDoE
- Debra from Contextures
- Jon from PTS
- Ron de Bruin
- Ross from MIE
- Ken from ExcelGuru
and many others who've linked to this site, both in your articles and your blogrolls. There isn't room to thank you all personally, but you know who you are.
Subscribers
We've seen consistent 900+ subscriber counts. This is the total from both the blog and the comments feed. Check the top of the right sidebar for the latest total.
Reminder: The existing site feed will be turned off on Monday.
If you subscribe to the blog feed, make sure the URL points to http://feeds.feedburner.com/CodeForExcelAndOutlook. All other feeds will remain the same.
If you read this blog via email, you will need to resubscribe (I checked but there's no option to move the subscriber list to the new feed). Visit the Subscribe page or look at the top of the right sidebar for subscription options.
Downloads
I've just started tracking file downloads in-house, so next quarter I'll post the download numbers.
Blog Content
The blog is rapidly approaching 300 posts and 1,000 comments. I expect to hit both milestones before the end of Q2 2010.
Other News
I've started writing for the Professional Office Developers Association (PODA) blog. My first article is Creating UNC paths from mapped drives, which covers a few techniques for discovering the UNC paths for your network's mapped drives. A few more articles have been scheduled, and I'm looking for more participation. If you'd like to contribute an article, contact me.
I've spent so much time hacking WordPress that I've started writing some PHP code in my spare time. There are days where I write more PHP than VBA (gasp!). As a result, I've created a page to highlight some of my work: WordPress Plugins and functions. This is a temporary home until I decide what to do with this effort. It's not linked from anywhere else on the site. The Get RSS Feed plugin is available on WordPress.org.
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Playing with Outlook AddressLists
Next Post: The JKP Name Manager just saved my bacon
That is a good quarter and year. congratulations. Wish you a rocking 2010.
Just curious.. why are you moving your feeds? If the source URL of the feed changed, you could just update the feed settings in FB?
The source didn't change, but the default URLs provided by Feedburner are ugly.
Hmm.. good point. They are ugly alright. But changing subscription for email readers could be too much trouble. May be you can shorten the ugly url using bit.ly and place that link?
PS: I have removed the old url and added new one to my google reader anyway. Your posts are too good to miss
Well, I've read that Microsoft is referring to the next Office suite verbally as 'Office Twenty-Ten', so that might be the way to say it (unless they copyrighted it!).