Blog of Leonid Mamchenkov

You just stepped in a pile of posts.

Entries Tagged as 'stats'

Russian web shoppers : the relative absolutes

Posted in All, Web work on August 23rd, 2008 · 1 Comment

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.

→ 1 CommentTags: , , , , , , ,

MostSliced.com summary - picking PSD slicing company

Posted in All, Web work on May 5th, 2008 · 8 Comments

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.

→ 8 CommentsTags: , , , , ,

4,000 posts

Posted in All, Blogging, Personal, Site News on February 11th, 2008 · 2 Comments

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…

→ 2 CommentsTags: , ,

Christmas season and blog stats

Posted in All on January 14th, 2008 · 2 Comments

I don’t know exactly how all those online shops do during the Christmas seasons (probably they are blooming), but I can show you what two weeks or so of Christmas and New Year’s holidays can do to one’s blog statistics.  Here is a screenshot of weekly stats for my blog:

Weekly stats - Christmas edition

X-axis shows a few last weeks of 2007 as well as a couple of weeks of 2008.  Y-axis shows the number of visits this blog had for each of those weeks.  A home-made red marker with a word “here” tries to bring your attention to the celebration of Christmas and New Year represented on this graph.

As much as it was expected, that was quite a dive I must say.  Reasons?  I’d say there are only two:

  1. Many people are busy with shopping, celebrations, travels, and other holiday matters.  Mostly off-line.
  2. Many companies closed their offices and that minimized many employees’ access to the Web.

Gladly, things are rushing back to normal.

→ 2 CommentsTags: , , , , , , , ,

Trend : web workers, home workers

Posted in All on January 5th, 2008 · No Comments

Web Worker Daily quotes The New York Times:

But by 2006, according to data collected by the Dieringer Research Group, a marketing research company in Brookfield, Wis., more than 28 million Americans were working from home at least part time — an increase of 10 percent from just the year before, and 40 percent from 2002. The American Home Furnishings Alliance reports that 7 in 10 Americans now have offices or designated workstations in their homes, a 112 percent increase since 2000. And a recent survey by the National Association of Home Builders found that home offices ranked as the fourth most important feature in a new upscale home, just ahead of security.

It’s always nice to have some numbers, no matter how obvious the trend is.

→ No CommentsTags: , , , , , , , ,

Advertisement

  • Linux Weekly News
  • 50 ways to help the planet
  • WordPress publishing platform