A glimpse into Google Analytics power

For a few years now I always recommend Google Analytics to anyone who is looking for a statistical / analytical package for their web site.  While there are a few alternatives, I think that almost none of them can match Google Analytics in both ease of use and analytical power.

Easy installation (a copy-paste of provided JavaScript snippet), web-based reports available from anywhere, multi-user access, schedule reports, exports to several formats such as CSV and PDF, schedule reports, customizable dashboards, multiple site and profile management, A/B testing, goal conversion tracking, and much more – and all of it for free.  That’s hard to compete with.

Google Analytics help

And if you want to see how much you can get out of it and how easy that would be to configure, consider a recent example posted in Google Analytics blog – “Advanced: Structure Your Account With Roll Up Reporting And More“.

Russian web shoppers : the relative absolutes

Quintura blog has this nice post with some statistics of Russian online shoppers – how often they buy, what they buy, and how they pay.  As any other bit of statistics, it’s rather interesting.  However, I think there is more to it than the article covers.  Here are my random thoughts in a bullet list format.

  • “85% of Russian Internet users shop online”.  It would be extremely interesting to see at least some approximation of country population to its Internet users.  According to Wikipedia, Russian population is about 142,000,000 people.  How many of these are online?  According to some resources, such as, for example, Public Opinion Foundation Database, it’s somewhere between 18% and 25%.  And then again, it’s depends a lot on where you are looking at.  Moscow and surrounding areas have a much higher Intenret penetration than Central and Eastern Russia.  Moscow can have as much as 56% of its population online, while less than 20% of the Urals and the Siberia population are connected.
  • “The Russian e-commerce market has doubled to $3.2 billion in 2007”. Sounds huge, doesn’t it.  But let’s see. I’ll pick 28,000,000 people or 25% of connected population as per Public Opinion Foundation Database for the calculations.  85% of these are shopping online.  That’s about 23,800,000 people.  $3.2 billion market devided equally between all those people comes down to $135.  So, the market is huge, rather because there are so many people around, as opposed to how much those people buy. If you need more numbers to explain you the situation, have a look at the state of the Russian economy at Wikipedia.
  • “However, it’s yet to become a habit because only 16% of users shop online once a month”. Sounds like the other 84% shop less than once a month.  Why?  Maybe because it isn’t so easy to find a few people to batch into a single order.  Or maybe they just don’t have time to, between the two jobs or something.
  • “Most of the shoppers or 70% paid for online goods in cash upon delivery while only 12% of responders used bank cards in online transactions and another 10% used online payment systems”.  Internationally recognized credit cards, like Visa or MasterCard, are probably either expensive to have or difficult to get or both.  Personally, I don’t have much experience in this area, but I’ve heard a few of my Russian friends complaining about the state of the banking system in the country.  Also, there is another thing to remember – language.  I don’t have any numbers at hand, but I’d say that people who can at least read and understand at least one foreign language are a minority in Russia.  With no credit card and foreign language knowledge, most of the purchasing activity would stay within the country.
  • “The most popular shopping items included books (51% of responders), computers (43%), home appliances (42%), software (31%), movies (26%), beauty products (25%), and music (23%)”.  It looks like the majority of Russian online shoppers are rather young, tech-savvy people.
  • All of the above make it sound like a lot of marketing opportunities – large number of people, who are roughly in the same age group, with somewhat poor geographic distribution and limited access to credit cards… And with that, it’s interesting to see at the advertising channels.  TV, radio, Internet itself.  And then, which Russian sites with some sort of ad campaigns are the most visited?

Feel free to throw in your thoughts and more numbers via comments.

MostSliced.com summary – picking PSD slicing company

Everybody who ever made a web site, knows that design is hard. Making something outstanding and unique, but at the same time classy and easy to use, requires a professional designer. Everybody who ever made a web site knows that almost all web design is done in Adobe Photoshop, and that after the actual design is done, there comes an often lengthy and painful stage of slicing the design into its web variant – a conversion of Adobe Photoshop .PSD file into HTML, CSS, and web optimized images.

Apparently, slicing up a design is not a tough job it all. It’s slicing it up properly that makes all the difference. Anybody who has Adobe Photoshop installed can slice up a design. Photoshop can do most of the job for you anyway. But it takes a real professional do it properly. Don’t believe me? Let’s see. Have you ever sliced up a design? If so, feel free to answer the following questions in the comments:

  • How complex was the design?
  • How much time did it take you to slice it?
  • In how many browsers did you check the results?
  • Did you try to validate the HTML and CSS?
  • Did you spent any time making the result load faster – optimize images and code for slow connections?
  • How about accessibility – can people with disabilities, people using special software like screen readers, make any sense of the pages that you created?
  • Was there any SEO (search engine optimization) – semantic coding – in your work?
  • What about the comments in the markup and styles? Did you left any? Will other people be able to modify your results easily?
  • Did you have any considerations regarding technical nuances of the job – DIVs vs. tables, fixed width vs. fluid, scalable fonts vs fixed sized ones, etc?
  • Did you have to shape your slicing results into a theme for some CMS software, like WordPress or Drupal?
  • Have you enjoyed the process? Would you like to do it again?
  • How much would you pay not to do it again? Ever again?

If slicing up designs is not your bread and butter, you’ll pretty soon arrive to the conclusion that you need someone else to do it. One of the solutions is to outsource this job to one of the PSD slicing companies. There are quite a few of them out there – some are better, some are worse, some new, some old, and some we know nothing about.

But which company to choose? How to pick the one that will do the magic for you without screwing a thing or two in the process? Well, of course, there is always fear, uncertainty, and doubt involved, but if we are to put these aside, how can we proceed?

Finding a company to outsource PSD slicing was something I’ve been asked to do on more than one occasion over the past few weeks. Finally, I got over my busy schedule and unlimited laziness and came up with something.

There is a web site called MostSliced.com . It is a directory of PSD slicing companies with some brief information about each, user submitted reviews, ratings, and what not. It’s not a huge directory – it only features 20+ companies. It’s not a very user friendly web site. But it’s a good place to start.

Before making any decisions, it’s good to figure out the requirements for the best match. Here are the things I had in mind while learning about these companies – your mileage may vary of course:

  • How fast can they do the job?
  • How flexible they are in their technical expertise – cross-browser compatibility, W3C standards compliance, SEO, accessibility, code commenting, etc?
  • How many people have ever used their services and how many of those got satisfied?
  • What were the weak points from those users who weren’t satisfied?
  • How expensive are they?

I quickly realized that I need to group MostSliced.com listing into a table, add my own rating, and see which companies are doing the best. So, I fired up my Google Spreadsheet and did exactly that. I’ve published the table for anyone to see, but if for some reason you can’t access it, feel free to use an image below (click it for a larger version).

Things that you see in that table are:

  • Company name.
  • Company URL.
  • Price. This is a price in US Dollars for the first page, as reported by MostSliced.com .
  • Time. This is the time in days that the company will need to slice up your design.
  • Reviews. This is the number of reviews for this company posted at MostSliced.com for the moment of creating the table.
  • Reviews rating. This the average rating of the company given by all reviews at MostSliced.com.
  • Combined rating. This is the rating that I came up with. It is calculated like so: combined rating = ((Reviews / 2) * (Reviews rating / 10) / (Price * Time)) * 1000. The idea is the following: half of the ratings are submitted by the companies themselves or by their very biased users. So we’ll just use the other half. We’ll decrease the review rating range from between 0 and 10 to between 0 and 1. Then we’ll multiple this rating by the number of the reviews the company has. The result of this multiplication we’ll divide by a product of time and price. The slower they are, or the more expensive, the lower their rating will be. The more reviews they have, and the more positive their reviews are, the higher their rating goes. And just to make the rating numbers into some sensible numbers, multiply the result by 1,000.

To make things a little bit easier to digest, I added some colors. White and gray backgrounds are just for stripes, to make it easier to read. The best values for each column are highlighted in green. The worst values are highlighted in red. The values in between are highlighted in yellow. The final table is sorted by the Combined Rating, so that the best companies to choose from are at the top. According to these findings, the top three best companies to give our trust to are:

  1. xHTML Master
  2. PSD Slicing
  3. Frontenders

As I said, your mileage may vary. Things that you should keep in mind are:

  • There are more companies out there than those that are listed in MostSliced.com .
  • There are other factors to take into consideration which weren’t even mentioned here – for example, the timezone the company is in, languages they can communicate with, payment conditions, etc.
  • I am pretty bad at anything that needs any calculations. Seriously.

I will most likely continue with the research in this area. Or maybe I will just go ahead and try a few of them out. But in either case, if you have any suggestions or ideas in these matters, please let me know.

30, here I come!

Yesterday I celebrated my 30th birthday.  That was a blast!  I received congratulations and best wishes from more people (and bots) than I ever did.  In fact, there were so many that I can publish some statistics (numbers are approximated):

  • Automated greeting messages from forums and social services: 35
  • Phone calls: 15
  • SMS messages: 10
  • Paper postcards: 1
  • E-cards: 1
  • Emails: 4
  • IM chats: 15
  • Social networks contacts (Odnoklassniki.ru, Facebook, etc): 70
  • In person: 20

Some of these overlap, but not that much.  Messages started coming in from Monday afternoon and they are still pouring  in. Needless to say, I am overwhelmed.   A huge thank you to all of you!  You made my day.

4,000 posts

While playing around with this and that (more on this a bit later), I noticed a perfectly round number in one of my sidebars – 4,000.  That’s exactly how many posts I have published on this blog.  Technically, I have a little bit more, but it’s 4,000 posts that are available to all of your for reading, linking, and commenting.

Last celebrated milestone of this blog that I could find was 2,000 posts, which was almost three years ago.   Not bad, not bad at all.  I’m still here and I’m still kicking.  Let’s see if I can push it towards 5000, 10000 and 50000…