Category: applications

Viewing an Excel file should not be so hard

Posted 10 December 2010 in applications, user experience | No comments yet

I needed to open a .xls Excel file on my PC and OpenOffice wouldn’t open it so I tried the Microsoft Office Excel Viewer program but it said no:

I thought perhaps the viewer was out of date so I found the “Check for updates” link which opened up a tab in my Chrome browser helpfully suggesting I should be running Internet Explorer 5 or later.

It had been a long time since I installed the Excel Viewer so I went through the checking for updates process, did some installations, but still the file wouldn’t play ball.

I switched over to Internet Explorer, set myself up with a Windows Live account and decided I’d try and open it with Microsoft Office Live, but Internet Explorer suggested that it wasn’t safe:

I ignored the advice but even then the file refused to open:

Having wasted a lot of time and failed miserably, I waited until I had access to another PC with Microsoft Office installed on it and Excel opened my troublesome file happily.

The three most frustrating things about this experience:

  • all that effort that got me nowhere
  • lack of appropriate guidance from the applications
  • the behavioural difference between an installed copy of Office and Office Live

Why do so many people spend so little time on my site?

Posted 23 November 2010 in applications, business, content | No comments yet

Google Analytics can be a great tool for understanding how people use your site, and how to improve your site, however there are some tricks involved in interpreting the data it provides. The “Length of Visit” report is particularly likely to trip people up.

In “Visitors > Visitor Loyalty > Length of Visit” you can see how long people spend visiting your site:

Google Analytics - Length of Visit

The number of 0-10 seconds visits can be quite high and distressing. Why? Because Google Analytics lumps every bounce visitor (those who only view one page of a web site during their visit) in the 0-10 seconds category. Google states:

“In order to capture the length of a visit, Google Analytics tracks the elapsed time between pageviews. The last page of a visit will not be recorded (as there is no subsequent pageview).

Single-page visits are assigned to the 0-10 second category.”

(from: How are the Length of Visit report values calculated?)

Certain sites (eg. blogs, product support sites, tv guides) are more likely to have a high bounce rate because people may want to only get one piece of information at a time. A high bounce rate isn’t always a bad thing. A site may be aimed at on-going engagement so a higher priority may be the number of times a person re-visits (“Visitors > Visitor Loyalty > Loyalty”), or how frequently they come back (“Visitors > Visitor Loyalty > Recency”).

However using “Advanced Segments” you can change the “Length of Visit” report to only show “Non-bounce Visits” (make sure you un-tick the “All Visits” segment before clicking “Apply”) to get a less skewed view of whether people are engaging with your site for a reasonable amount of time.

Google Analytics - Advanced Segments option

Google Analytics - Non-bounce Visits

Google’s in-page help mentions that the “Length of Visit” report can be skewed if people leave their browser windows open, but why doesn’t it mention the 0-10 seconds lumping for bounce visits? Considering how vastly it can skew the perception of activity on your site, I’m surprised that Google doesn’t provide a note about it on the report, or at least on the “About this Report” help section.

Google Analytics - Length of Visit - About this Report

To get a clearer picture on whether people are landing on your site and leaving quicker than you’d like them to, gaAddons is a useful enhancement to the standard Google Analytics code. It’s a code snippet (free for personal or non-commerical use, or a fee for commercial use) that can be added in the same way as your Google Analytics tracking code. You can set a suitable length of time to not consider a visit to be a real bounce. The default is 30 seconds and you can change how it’s reported but if you use the Event Tracking method (“Content > Event Tracking”) you will see something like this:

gaAddons - over 30 seconds report

If you want to take it further, there are calculations that can be done to determine a “real” bounce, or lack of engagement, rate.

Learning a bit about the EPUB format

Posted 25 February 2010 in applications, content | No comments yet
Shopping cart suggestion to buy an EPUB book

Screenshot of the shopping cart letting me know I could buy an EPUB version

I was buying some books on Rosenfeld Media, when the shopping cart suggested I buy Donna Spencer’s Card Sorting and that it was available in the EPUB format for iPhone and Sony Reader.

Although I was intending to buy the physical book, for curiosity I decided to also give the EPUB version a go. A few weeks ago I briefly glanced over an article What Web Designers need to know about EPUB (via Russ Weakley’s Some links for light reading) but hadn’t delved further so I thought it would be a good chance to learn more.

I completed my order, downloaded the EPUB file, and then realised I didn’t know how to view it! (Note: I didn’t mind figuring it out for myself and although Rosenfeld Media don’t currently have instructions for using EPUB files they have let me know that they will be improving the experience of buying EPUB books as they ramp up their EPUB publishing.) A little research and I found a number of applications including Stanza which is available as an iPhone app and a desktop program. Their instructions helped me to transfer the EPUB file from my PC to my iPhone via wifi – in the end a simple process.

Poking around Stanza on my iPhone I found that I could download other books, many offered free by publishers or through lapsed copyright, and some paid books. I realised I had previously used a similar app to download a few books but perhaps I’d stumbled on a poorly built app as I wasn’t too awestruck by the idea of reading on my phone at the time. Stanza’s interface and interactions, while a little clunky, are alright and “Card Sorting” is formatted well for reading on screen while I wait for the physical book to arrive.

I realise that the EPUB format has been around for a number of years but it feels like it’s been one of those ideas floating around waiting for technology to catch up. Sure, the iPhone might not be the ideal reading interface but the Kindle, iPad, and whatever else comes next means that people who might be unable to access good (or any) book shops/are environmentally conscious/want to save some money/want to try before they buy/etc have a much easier method to do so. Australian books are pricey which I presume is due to the distance books have to travel from overseas, or because the shipping orders are small due to our small population, so providing access to quality information in affordable and environmentally friendly ways is a step in a good direction.

I know that I won’t be giving up on my much-loved bookshelves any time soon, but in the same way that digital music downloads of single tracks encourages me to try more artists without spending a lot of money on CDs, I expect I’ll now “try” more books before I buy physical copies.

Now if only the various publishers, hardware developers, software developers, etc could agree on a single format for e-books and sort out the whole DRM mess!

A few links I’ve stumbled on while looking for more EPUB information:

On reflection as I hit “Publish” this begins to feel like an ignorant post, but I actually don’t know anyone who owns a Kindle or an e-reader, and I’ve been very much in love with the physical flipping of book pages since I was a child. From my choice to download an EPUB book and having a good experience with it, I’m now much more willing to give e-books a go.

Is gmail.google.com kaput?

Posted 13 March 2009 in applications, user experience | 2 comments

Following on from this morning’s curious gmail access problems, I tried to access gmail.google.com from home and found that the page’s text is now appearing in German.

I’m sure I’m in Australia. And I’m sure I don’t have any settings on my work and home Macs and PC that refer to Germany or German.

Does this mean the URL gmail.google.com can no longer be used from anywhere globally?

Or did someone just mess up with the IP address detection script?

As per my previous post, why, when people have used the gmail.google.com URL for so long, would this page not be translated to multiple languages?  If I landed on this page without having seen the English version this morning I would have been very baffled.

The mail.google.com site still contains Gmail branding so I’m leaning towards this being caused by a bug rather than a global initiative/re-branding.

Maybe tomorrow I’ll find that page talking at me in Finnish.

[Edit: Just to clarify, I don't mind if gmail/Google Mail needs to be accessed via another URL from now on, I'm just picking on the execution of the change - it is not user friendly]

gmail auf deutsch

meine deutsch ist nicht gut