News

How to choose an eCommerce Solution for engagement and conversion

There are a real plethora of eCommerce solutions out there now, making it difficult to isolate which solution is best for you. Some solutions are free and open-source, some licensed or bought off the shelf, and others custom-built – each has it’s advantages and disadvantages. This post is an outline of what your decision-making process with your IT consultant should look like.

  1. Will you be marketing your products to the search engines? If so, you need, at a minimum, a solution with 301 Redirect Management, keyword-rich URLs, and management facilities for title and meta-tags. This will rule out a sleuth of options.
  2. What is your estimated annual turnover, average transaction value, and average unit price? Payment gateways (i.e. PayPal, Google Checkout, Protx, ChronoPay, etc.) differ in their charges, and you should choose to minimise your costs.
  3. Continue reading

Troubleshooting your FORMSOF & INFLECTIONAL searches not working, SQL Server 2005

For the life of me, I couldn’t figure out why I didn’t get different results, using SQL Server 2005, for a simple Full-Text Search query and a Full-Text Search query using the FORMSOF and INFLECTIONAL keywords.

What I stumbled across eventually was that when creating and configuring my SQL Full-Text Indexes, I had left the language parameter as the default selection. When I changed this to English, voila!, my FORMSOF (INFLECTIONAL, @query) queries started to produces fantastic search results!

Also, an example query showing how to parameterize the the search term, and how to rank your results:

@query varchar (100)

SET @query = ‘FORMSOF (INFLECTIONAL, ‘ + @query + ‘)’

SELECT FT.rank, P.id, P.title
FROM Products P
INNER JOIN CONTAINSTABLE (Products, *, @query) AS FT ON P.id = FT.[key]

If you’ve any questions, I’ll do my best to help. Also, if you’re just starting with Full-Text, check out my posts on installing Full-Text Search on SQL Server 2005 and how to setup and configure SQL Server 2005 Express Full-Text Search the easy way.

SQL Server 2005 Express Full-Text Search Setup Tutorial

I recently had to setup a search facility on a website driven by SQL Server 2005 Express. My natural choice was SQL Server’s Full-Text Search feature, but setup was not entirely intuitive, and the web was full of misinformation. I’ve put together a tutorial to save you time.

If you’re not sure if your have Full-Text installed, read my post on installing SQL Server 2005 Express Full-Text Search.

Once, Full-Text is installed, you need to create your index:

CREATE FULLTEXT CATALOG MyFullTextCatalog

Managing your index is then actually very simple:

  • Browse to the tables of your database, right click and select ‘Design’
  • In the main window, right click and select ‘Fulltext Index…’
    If you see the message, ‘You need to define one or more full-text compatible indexes on the table to create a full-text index’ and the ‘Add’ button is greyed out, it’s because you don’t have a column the database can use to uniquely identify each row. Make sure you have a primary key, and if you’ve no success, start your troubleshooting with this video – it discusses unique indexes about 1/3 of the way through.
  • Otherwise, click ‘Add’, and you have a new index.
  • To configure the columns in the index, click the ‘…’ button next to ‘Columns’
  • For each column, select the column, and select the appropriate language
    To understand why the language parameter is important, see my post on use of the FORMSOF and INFLECTIONAL keywords in SQL Full-Text Search

It’s that easy! Any questions, let me know and I’ll do my best to help.

Communicating the ROI of Web Design with Web Forms

It is often hard for those needing a website to justify the costs of design. Design is often viewed as a ‘talent’ before a learned skill, and as something that we either have or we don’t, and it naturally follows that if you ‘have it’ should be able to produce it without greart expensive.

Luke Wroblewski gave an excellent presentation at the An Event Apart 2007 conference (Chicago) that helps communicate the complexity and process of design, and the value a strong design can contribute.

Luke’s presentation focuses on the web form, which is any interface that accepts user input – common examples are login/registration, enquiry, and eCommerce checkout forms. It’s clear that many businesses depend upon their customers completing these forms to generate, maintaining and convert leads, and logically follows that the quicker and easier a form is to complete, the more likely those customers will do so.

Luke presents three simple variants of webform design to demonstrate the potential impact on revenue the design of the form can have. Each form input field has a label that tells the customer what information to put in that field. Luke’s variations placed the label above the field, and to the left of the field, either left-aligned or right-aligned. His referenced studies found that customers completing forms with right-aligned labels surprisingly did so twice as quickly as those with left-aligned labels, but that quicker still were those customers completing forms with top-aligned labels.

Clearly, big differences can be made to conversion rates by assessing the quality of your web form. Luke’s presentation is available on his blog, and goes on to discuss the consideration of required/optional fields, primary/secondary actions, contextual grouping and progressive disclosure, tabbing, the path to completion, inline validation and assistance, and feedback mechanisms.

He also provides excellent example of both good and bad web forms in a very accessible presentation that will ensure you know what to expect when commissioning the design of a web form.

SQL Server 2005 Express with the Full-Text option greyed out

I’ve just been struggling to enable full-text search on my installation of SQL Server 2005 Express Edition, and so want to share the solution.

If, like me, the ‘Use full-text indexing’ checkbox was greyed out under Database > Properties > Files, you first need to test whether Full-Text Indexing is installed or not. To do this, execute the query.

use [dbname]
select fulltextserviceproperty(‘isfulltextinstalled’)

If this returns 0, you need to install Full-Text Search.

Firstly, did you install SQL Server 2005 Express Edition Advanced Series? Only the Advanced Series contains full-text. If not, you may need to reinstall.

However if so, then you just need to change the installation to include Full-Text Indexing. But if you originally installed from a download from the above link (most of you) then you’ll find that when you try to modify the installation via Control Panel > Applications / Programs, Windows prompts you for the installation file ‘sqlrun_sql.msi’. This is because the download unpacked the installation files to a temporary folder which can no longer be found.

To resolve this issue, you need to download the file again from the link above, move it to a folder, and unzip (I used WinRAR). Then point Windows to the sqlrun_sql.msi file (under /setup, wherever you unzipped the download) when it prompts you for the installation file.

For additional info, see here.

For additional support setting up Full-Text Search once installed, watch this video on the topic from Micosoft, BUT I think you’ll find my new tutorial on seting up Full-Text Search in SQL Server 2005 Express much quicker and more intuitive to be honest..

10 statistics that demonstrate the value of SEO

These statistics source from a compilation of SERPS behaviour studies for which I’ve listed source information at the end of the article. If you disagree with a figure, or have additional figures or sources, please do post them to the discussion.

  1. 42% of search users click the top-ranking link. 8% click the second-ranking link, and the click-through rate (CTR) continues to drop thereof.
  2. When these two top-ranking links are artificially switched, the click-through ratio of 42-8% drops to 34-12%, demonstrating the importance of engaging copy in addition to rank position.
  3. 62% of search users click a link on the first page of search results
  4. 23% of searches progress to the second page. Presumably the difference between 62% ans 23% stems from searchers trying either another keyword or another engine, or giving up.
  5. 80% f unsuccessful searches are followed with keyword refinement.
  6. 41% of searches unsuccessful after the first page choose to refine thir keyword search phrase or their chosen search engine.
  7. 77% of search users choose organic over paid listing when searching, 67% choose organic search when purchasing.
  8. When the searcher is purchasing, organic click-through generates 25% higher conversion rates than equivalent Pay-Per-Click (PP) click-through.
  9. 40% of SEO campaigns aware of their ROI achieve returns in excess of 500%, while only 22% of PPC campaigns were able to achieve this value.
  10. Daily use of search engines rose from 33% in 2002 to 59% in 2005. The average day in 2005 reported 60 million people using a search engine. As of March 2007, Google accounts for 64% of US searches and 77% of UK searches

The validity of these statistics depend on various experimental factors (i.e. large, representative samples of searchers/searches), and on accurate statistical analysis.

For more in depth analysis, the sources for this article were:

Please post addition figures or sources, or your view, in the comments.

UK Google Market Share – March 2007

The latest figures on Google’s market share compared to its primary search competitors Yahoo, MSN, and Ask (formerly Ask Jeeves) have been published by Hitwise. As always, the numbers are astounding, revealing that Google holds a 77% market share, meaning overthree quarters of UK internet searches are made through Google. Yahoo is now holding 8%, and while MSN and Ask are both at 5% and falling.

March 2007 UK Search Market Share

Comparing the UK to the US figures, for which Google has just broken 66.6% or two thirds market share, it’s clear that UK internet searchers even more than US searchers turn first to Google.

A collective 23% is not to be sniffed at, but clearly firms services the UK market and requiring SEO services should look first to SEO specialists with strong results in google.co.uk.

[tags]seo, uk, search engine market, google, yahoo, msn[/tags]

Improve Website Performance – 10 Fundamentals

  1. Are you using Google Analytics (or require and use an alternative)?

    You can’t gauge success unless you measure performance. Google Analytics is a free and very effective tool for just this. For businesses that depends on local custom, it will qualify the proportion of your visitors that reside nearby and are therefore of value. eCommerce sites can drive sales by adjusting their site layout or structure based on the analysis of search terms used within their site when people can’t find information. The available measures are extensive.

  2. Is every page of your site connected to every other via a site map?

    Page Rank is a measure of how valuable or important Google considers a web page to be. It is based largely on the number, page rank, and relevancy of web pages that link to that page. The pages of a site can also inherit Page Rank from other pages of their website, but the more links to reach those pages, the less page rank is inherited.A site map thus maximises this inheritance by ensuring every page is just one page from every other.

  3. Continue reading

10 Direct Routes to Reduced Website Costs and Risks: That’s what web standards are about!?

“Web Standards” is like another of these modern-day web buzzwords, like “Web 2.0” and “The Blogosphere”. But buzzwords become popular for a reason – let me give this one a simple definition, and explain the business benefits of web standards, namely reduced website costs and risks.

Web standards are, quite simply, a set of coding guidelines developed by a consortium of experts to reduce the risks involved in producing a website. The simple principle is that if everybody codes in the same way, the standard way, then everybody is compatible. Continue reading

“…offered a strong understanding of how to generate traffic online, bringing innovative ideas and very valuable insight to the table"

Ed Watt
Creative Director o street

Think we may be able to help you? Why not start a conversation - chances are, you'll go away with some new ideas and knowledge.