Server moving Oct 5-8

Posted on October 2nd, 2008 in General, Site Stuff by Ken Puls

I’m not sure how much effect this will have on my site, but my host is moving a server to a new data centre (different city) on Oct 5.

It’s funny, actually.  TThey prefaced the email with a blurb on being careful not to change web pages, and then gave a HUGE amount of technical details on all of the different phases of the move.  What they failed to make clear, however, is if the server will be down at all, or if you’d lose any changes made from start to finish, or only during certain times.  A classic case of can’t see the forrest for the trees.

At any rate, the move is supposed to be coplete in 3 days.  I probably won’t post anything or make site changes during that three day period.  I’m hoping the site is up the whoel time, but we’ll see.

One year blogging

Posted on November 18th, 2007 in General, Site Stuff by Ken Puls

So apparently today is the one year anniversary of my blog.  It’s kind of hard to believe it’s been that long in some ways, and in others I can’t remember not having it…

According to my blog dashboard:

Blog Stats

There are currently 82 posts and 253 comments, contained within 12 categories.

Spam

Akismet has protected your site from 44,694 spam comments.

I have to say that my personal favourite spam comments are the ones that start with “Sorry :( “  Seriously… is someone holding a gun to your head?  Give me a break!

Feeds

According to Feedburner, I currently have 61 people subscribed to my blog via RSS as well.

Just for fun, here’s a map from Google that shows where the majority of visitors come from and some other related stats:

xlgstats.png

I believe that the visits listed in the stats are unique visitors, not gross visitors.  It’s the only way that I can explain that I had over 44,000 spam comments without the visits.  I’m fairly sure, based on the IP addresses in the spam queue, that I don’t have people just sit here posting multiple spam comments.  They must return every so often to try again.

So happy birthday to the blog.  :)

Who is the number one choice of spammers?

Posted on June 18th, 2007 in General, I hate it when..., Site Stuff by Ken Puls

The other day my wife received over 5000 bounced emails… she hadn’t sent any out, but I guess our email address got spoofed, not doubt when someone who knew us got a virus in their inbox.  I’ve looked into it, and apparently, I can get a SPF put on my email so that mail servers can tell it didn’t come from us, but I just haven’t quite got there yet.

So today, I took a quick peak at my spam filter on the blog.  Check this out:

spam.jpg

Almost 4000 spam messages in just over two weeks.  Unreal.  So if your comment got moderated, and hasn’t shown up, you might want to try again.  (And maybe even email me if it doesn’t show up after a day or two.)

I have to admit that I’m kind of curious on this point… I know a bunch of other bloggers using Wordpress.  How many spam messages do you have in your Akismet filter?  My blog started back in December, so the 20,764 is only for about 7 months.

PS… sorry for the lack of posts here.  I’ve been very busy with a large project that isn’t due to be finished for a month or so.  I’ll try to put something up in the mean time, but this is pretty much consuming my evenings and weekends.

February Stats

Posted on February 28th, 2007 in General, Site Stuff by Ken Puls

Well, it’s been about a month since I last did this. I know that Ross was really keen on it, so I thought I’d share my web site traffic stats again.

I’m curious to know if anyone else finds this interesting or not. Post a comment to tell me either way, and I’ll take it into account next month. :)
It hasn’t been a really busy month on my blog, with only four new posts in February. (Five including this one… and yes, it is still Feb 28 for another 20 minutes where I am!) Despite that, my traffic has increased, and so have the number of visitors that have subscribed to my RSS feed. Unfortunately, my Spam count has also increased astronomically as well, but we’ll get to that in a bit. ;)

One thing I should mention… all the screen shots in this post (actually on my sites) were captured with Techsmith’s SnagIt. It’s a great little app that I will post a review on at some point. :)

Web site Feed stats
As I write this, there are now 30 people subscribed to the blog through one feed or another. And if you’re interested, you can actually see the current number at the left of your screen just below the “subscribe to RSS” gadget. Again, this is complements of the free Feedburner service, which provides me with the full graph for feed growth shown below:

feb-feedburner.jpg

So as of last month, the highest subscribers I had was 19, and now that’s my average, with a peak of 30. Not too shabby for growth in a low post month. :)

Excelguru.ca Main Site Traffic

I was actually helping a friend out with an email issue earlier tonight, and she was asking about my blog. Specifically, the question was “who reads that?”… especially after I told her that none of my visitors were from my family as they don’t hold any interest in this. ;)

Honestly, I can’t really answer the question. I know that some of my online friends do, but there are a great many people who return here that I just don’t know. What I can say, beyond that they have some interest in the material, is where they come from. Thanks again to Google’s free Analytics service, here’s the graph that shows Excelguru.ca’s traffic for February 2007:

excelguru-main-feb.jpg

Total visits (at least up till 10:30PM my time) is up to 6640 from 5977 in January. That’s just over a 10% increase in one month. Total pageviews have also increased, from 12,434 to 13,349. Not quite 10% there, but still an increase. I sure do see some wild dips on weekends… you’d think that no one reads Excel stuff on their days off or something. ;)
My returning visitor percentage actually dropped a bit in February at the main site. It’s down from 22.82% to 21.54%. I’m trying to decide if I should be worried about it or not. In the grand scheme of things, January saw about 1360 of my visits came from people who returned at least once, and that number grew to about 1430 in February.

With regards to the map, remember that the dots indicate the highest numbers of visitors from specific areas. There were also many different visitors from other countries that are not shown, but they were filtered out if there were less than 9 visits from that city in the month. (It’s an automatic stats thing on Google’s part. I didn’t decide on that magic number.)

Google is still my biggest referrer, (no surprise there,) and mvps.org is still second on the list.

While I was fooling around in Analytics getting the info for February, I stumbled on how to actually pull a custom period too. I actually only installed Analytics on October 31, 2006, and therefore meaningful stats didn’t start being generated until November 1. I was curious to see the site growth over that time, so snapped it as well:

excelguru-main-4mos.jpg

The nice little dip in traffic in the middle is the week around Christmas, but despite that, I’ve managed to attract over 23,000 visitors in four months. That’s pretty neat. In addition, the traffic is on an up hill climb, which is also kind of cool.

With regards to the rest of the pie graph stats, they’re honestly pretty much in the same range as I’m used to seeing. For reference, though, the lowest number I could find on the map was 27 visitors. Anything less than 26 has been ignored for map clarity.

Blog Stats

I’m only going to share the blog stats for February, as I didn’t snap the Analytics into it until the first week of December. There just isn’t the same amount of info there, but I may show a three month view if I post on this subject again at the end of March. Here’s the February view for the blog:

excelguru-blog-feb.jpg

So… things to note here are…

My total blog visits are up 32% from 1250 to 1652, but Pageviews are only up 10% from 2784 to 3056. This is pretty much telling me that while more people are finding the blog, they’re not necessarily interested in what’s here. My visitors last month looked at an average of 2.23 pages before they left, while now it’s down to 1.85. Actually, since many of the original visitors were friends and colleagues, it doesn’t really surprise me that this is happening, and I’d actually expect the average pageviews to drop as the number of visitors continues to increase.

My returning visitor percentage also dropped to 28.15% from 39.84%. That’s pretty drastic, so maybe I should start posting some worthwhile content again. :)

That really big lump on the left side of the map is Los Angeles. It seems that I get the most visits to my blog from that city.

With regards to the referral sources, I’m going to save commenting on that. The percentages this month bear almost no resemblance to last month. If you are still reading, and interested, let me know and I’ll add it to the post.

Spam

One of my biggest, err.., “accomplishments” this month seems to have been attracting spammers. It would actually be interesting to know just what my stats looked without them. I actually cleared all my spam filters at the beginning of the month, and then saved every one that I got, as I figured it would make an interesting study. Th thing is that I forgot that I use a spam filter on my email server which black-holes spam, so I don’t actually get a record of it. On my blog, though, it’s another story.

Wordpress has a great little anti-spam snap-in called “Akismet“, which seems to work very well. In the entire time I’ve been running it, it’s only given me two false positives, (sorry, Will!) and only missed a few. Fortunately, I have a moderation system in place for comments, so I could flag those as spam before they showed up.

What I found with spam on my blog surprised me though. From February 1-14, Akismet caught 370 spam messages. I cleared all of them out, and my spam filter currently holds another 875 from February 15-28! That’s 1245 spam posts in one (short) month, at a rate of over 44 per day! In fact, it was about 26 per day in the first half of the month, and is up to over 62 per day in the last half. At that rate of increase, I could be seeing 100 per day by the end of March, easily. (I hope it’s not exponential, or I might have to buy more server space. LOL!)

I do have a quick review of them, to try and see if anything was a false positive, and some of them are pretty funny. I had one with a subject of “Mexican Taco”, (which wasn’t about food ,) several which tell me how great my site is, (only to be followed up with a link to theirs,) and even a marriage proposal. Too funny, but a total waste of time.

At any rate, that’s all for now, but please do tell if you like this kind of post or not.

Snap!

Posted on January 24th, 2007 in General, Site Stuff by Ken Puls

I’m trying out a new script for the site, based on the feedback from my friend Will Riley, called Snap.

For the record, I’ve also seen Snap in action on one of my other friends sites (Dennis Wallentin’s) as well, and had to check it out on Will’s site as well.

Snap is a script that you can add to your web templates that will allow a pop-up preview of links contained in the text. It’s also got a Search box on it, but the instant preview is the real selling feature. If you like, just try mousing over any of the copious amounts of links that I shamelessly included in this post. :)

So far, it looks pretty neat, but I’m concerned about the performance a bit. Does anyone find that it slows down the site, or is it still okay? Feedback on that would be appreciated, as the last thing I want to do is kill the site performance for a cool feature.

One thing I have noticed is that my “Write Post” pages in the Wordpress control panel do sometimes have issues when I try to edit them if this script is on.

Okay, I can’t stand posting any more shameless links now… like this one, to my main site. Okay, seriously, now I feel dirty… :)

Update on January 25, 2007

For anyone who is reading this who missed it, the Snap preview looked like the following picture when you moused over a link:

As you might have guessed, I’ve turned the feature off on my blog…

Earlier in the post, I’d made a comment about Snap affecting the content authoring/editing section of the blog. Because of this, I submitted a bug report to the Snap folks. In addition to what is below, I also pointed them back at this post, as I figure they appreciate the feedback they get. At any rate, here’s what I submitted as my issue:

I find that when I’m editing a post in the Site Admin area, it sometimes doesn’t finish loading. Instead of seeing a formatted blog post in process, I see all the {p} and {br} coding. Usually this appears briefly on the way to full load, but the full load doesn’t happen with Snap installed. Ironically, clicking on the Save button completes the load, and then I have to click Save again.

I got a response from them today:

Thanks. Our tech team is aware of that. Sometimes Snap Preview Anywhere
and WYSIWYG editors do not play well together. Hopefully there’ll be a
fix coming, but I’m afraid I can’t say when.

I read your blog and wanted to point out that part of the speed issue
was temporary, and has been fixed, but still if there are lots of links
on a page, page loading can be a bit slow. But – happy day! – we have
some tips on how to speed that up, here:

http://www.snap.com/about/spa_faq.php#q

I’m glad they took the time to acknowledge my reply and answer it. That’s very cool and much appreciated. :) I’m also glad they know about the editor issue and hopefully they can make a fix for it.

I wasn’t sure if I was going to keep this feature on anyway, but this is serious enough for me that I cannot work with the product, as it makes editing posts virtually impossible.

Web Site & Blog Stats

Posted on January 24th, 2007 in General, Site Stuff by Ken Puls

This probably isn’t something that everyone would do, but I figured “what the heck”!

If you recall, back in December I posted about Google Analytics, as well as adding FeedBurner to track the number of subscribers here. In this post, I’m going to share some of that info. Please keep in mind that I haven’t really publicized either site much, as this is not really a commercial venture for me. I like to share info, which is the point of the main site, but the blog is really just a place for me to sound off in a less formal environment. While I have Google Adwords on both, neither is really meant to become a full time job to solicit business. I get just enough consulting jobs to earn a little extra funds, which serves me just fine.

At any rate… I added a new “widget” to the left sidebar, just under the orange icons, which tells you how many people are subscribing to the site via RSS. At the time of this writing, there are all of 19. Not many, I know, but I find it flattering that there are even that many people who want to know when I’ve posted more of my ramblings. :D

In general, I’ve been following the Feedburner stats since I installed it. It takes a couple of days before it starts tracking, but once it does, it spits out a report like the following:

Okay, so maybe it isn’t the most impressive of all reports, but it tracks the ups and downs. It also fills in the gap for Google Analytics, which tracks basically everything else that you could want.

Again, my sites are not the busiest out there by any means. They’re both growing constantly, though, which is great. Hopefully I’ll remember to post the entire 2007 stats chart in December to see how it worked out.

Now, here’s what I found interesting… I have Analytics installed for both my main site and the blog, and it tracks them separately. This is pretty cool, as I can get separate reports for each. This really showcases the differences that I have in my readership. Rather than let you guess about it, here’s the Analytics dashboard for Excelguru.ca:

And the picture below is the dashboard for the blog:

What I found really amazing is the difference in the returning visitor stats. The blog has almost twice the rate of returning visitors that the main site does. Maybe that makes sense, given the higher volume of the main site.

Some other interesting differences:

  • The blog’s Google referrals are 41.55% (the google.com number is 4.93%) vs the 69.89% of the Main Site. (59% vs 30% of visitors were referred by other websites.)
  • The blog visitors tend to read a higher average of pages… granted not much, but it’s still higher
  • The geographic disbursement is similar, although it seems like there may be slightly less blog readers in the Middle East and Indonesia.
  • The blog stats are less volatile on weekends than the main site… but that could just be that the RSS subscribers turn their PC’s on on weekends. ;)

So there you have it. That’s the performance of my sites in a nutshell. :)

New RSS Feed Link

Posted on December 7th, 2006 in General, Site Stuff by Ken Puls

It’s been a bit of a busy week for me at work, and my evenings have been spent doing a little more behind the scenes tweaking of the site… well… not Monday. We had our work Christmas party on Monday, so that night was kind of shot. :)

So what did I do? A few things actually, from testing a new web gallery software to installing a couple of web statistics packages for the blog. I’ll chat quickly about the web stats packages.

Google Analytics
Earlier this week I installed Google Analytics for the blog, in an attempt to start capturing the stats on readership. I.e. how many I get, and where they come from. If you’re not familiar with their services, Google offers the analytics services for free at this URL. Snapping it in to Wordpress is pretty easy too. If you don’t feel like editing the page templates yourself, you just download an Analytics plug-in, activate it, and drop in your ID. Within 24 hours, you’re up and running.

So why use it? It captures some pretty cool stats on your readers… and no, nothing personal. In fact, there is so much captured, that I haven’t even explored it all. I have attached an overview from my main site to show the dispersal of my viewers:

Mouse over each of those dots, and it tells you the city and number of visitors. I find this pretty cool to see where my traffic is coming from.

There is much, much more than this, of course. I have full graphs of my unique visits, the percentages of new versus returning users, what sites referred and even an overlay showing exactly what links were clicked from what pages. All in all, very cool stats. Especially for free. :)

Feedburner

One thing I haven’t figured out from Google Analytics is how to track the number of RSS Subscribers to my blog. After a little searching, I came across FeedBurner, which is another free service to capture and track RSS feeds. This is pretty cool, as I also would like to know how many people subscribe, but don’t necessarily visit every time I post new content. To that end, the new RSS feeds (which I’m told will work with any RSS reader) are:

Main Feed: http://feeds.feedburner.com/excelguru

Comments Feed: http://feeds.feedburner.com/ExcelguruComments

Now this install takes a little more work. Based on what was in and inferred in this article, I downloaded and installed the Feedburner plugin and set off adjusting my template code. The Feedburner site itself actually has some pretty good pointers on what to adjust, so it wasn’t hard. The only part that I’ve shied away from for now is trying to redirect the old RSS feed to the new one, as it looks a bit more difficult. I figure the blog is new enough that I probably don’t have a huge number of subscribers at this point anyway, although hopefully that will change.

Once I’ve been using FeedBurner for a while, I’ll post back with an opinion on it. :)

At any rate, I think I’m done tweaking for now, so should be back to posting some more RibbonX examples soon.

You have to love the internet

Posted on December 1st, 2006 in General, Site Stuff by Ken Puls

As you can see from reading the frame here, I use WordPress to power the blog. I wasn’t really happy with the skin, though, so I took a browse through the Wordpress theme gallery, and found the Cordobo-Green-Park theme. It was exactly what I wanted… only it was green. I really liked the layout, but not the colour.
And so here comes the power of the net. I accidentally found this page, which happens to be all about adjusting this theme to use the exact colours I want!

I’ve never used GIMP before, so didn’t know if I’d like it. I also didn’t know if it would run on Vista. Rather than clutter my PC, I created a new Virtual PC (using a differencing disk off my master), and had a fresh WinXP OS up an running in five minutes. I downloaded and installed GIMP, and followed the awesome instructions at the afore mentioned link to customize my skin. Perfect!

The only comment I have on the tutorial is that I had to do tons of gif and png images, but it didn’t take too long, and I’m way happier with the look of the site now.

Wordpress Eats my XML

Posted on November 20th, 2006 in I hate it when..., Site Stuff by Ken Puls

Well this sucks… I was writing up a post on using XML to customize the Excel 2007 Ribbon, but Wordpress interprets my XML. Nothing I’ve done so far seems to get it to post in plain text. I’m still pretty new to this, but it’s really annoying so far.

20 minutes later…

And Wordpress is on a diet! I found the iG:Syntax Hiliter, which is awesome. Super easy to follow instructions to install and configure, even for a non-php and HTML guy like myself. :)

A further 30 minutes later…

And I’m not so sure. The XML works, but only if I post it right away. If I preview it, it eats it again! Grr… At least I can get something out there though.

Another geeky blog…

Posted on November 18th, 2006 in General, Site Stuff by Ken Puls

Okay, well here we go. I’ve added a blog to my site to give me an avenue to post without feeling the restriction of getting everything perfect the first time. I’m going to share some of what I’m doing, things I see, and some of my opinions on things. If anyone finds it interesting then great. If not, go read someone else’s site. ;)