Friday 19 December 2008

Measuring the competitiveness of keywords

When writing a new website and choosing keywords, it's easy to make the mistake of choosing ones which are far too competitive. For a new website, it will be difficult to rank well for competitive keywords unless you can get some very high quality links from high PR sites.

Competitiveness is a difficult thing to measure and it has to be balanced against the search volume for any particular keywords. It might be worth optimising for competitive keywords if the search volume is very high and you don't mind taking a longer term view of ranking well. Taking the opposite view, it isn't worth optimising for uncompetitive keywords if the search volume is very low.

One way of investigating the competitiveness of keywords is by using Google's own keyword research tool at https://adwords.google.com/select/KeywordToolExternal. This tool shows monthly search volumes for keywords together with a rough gauge of the competition for the keywords.

Another rough way of gauging the competition is by using the allintitle: operator when doing a search. Using the allintitle operator makes the SERPS only contain those pages which have the search words in their title. Since a page title is a key SEO factor, the number of results returned is a rough and ready gauge of competitiveness. For example, if you want to measure the competition for web design, do the following search on google.co.uk:

allintitle:web design

This returns 9,800,000 results. Trying:

allintitle:seo

returns 13,800,000 results.

Contrast these numbers with a set of keywords that we can guess are pretty uncompetitive:

allintitle:british vineyards

This returns 639 results, or ...

allintitle:web design worcester

which returns 1050 results.

Of course, the number of pages that include keywords in their title doesn't tell you the full story of how competitive a set of keywords are but it is a start. For one thing, allintitle doesn't tell you how well optimised the pages are, e.g. the first 50 pages in the results might have good links and content and be hard to beat without a lot of work. allintitle though is a useful tool to add to your SEO arsenal.

Monday 15 December 2008

SliQ 1.5 Released

After a few months development SliQ 1.5 has been released and includes a new recurring invoice feature. The recurring/ automatic invoice feature has been in development for the last 3 months. During this time, feedback from a number of users/ potential users was used to guide the implementation. In line with earlier feature additions, the emphasis has been on making recurring invoices as easy to set up as possible.

With two or three mouse-clicks you can now make SliQ Invoicing automatically raise repeat copies of invoices. All you need is select an invoice and check the Recurring? box in the toolbar.

... then confirm the frequency for raising the invoices ...



This will save loads of time for anyone regularly raising repeat copies of invoices, e.g. website designers charging monthly for SEO or website maintenance.

SliQ 1.5 also includes a bulk printing facility. SliQ now tracks which invoices have been printed and allows the user to print all un-printed invoices with a single menu click. This should greatly speed up the monthly billing process for SliQ's users, especially if most of the user's invoces are automatically raised by SliQ using the recurring invoice feature.

Wednesday 3 December 2008

SEO: Doing it professionally

After helping out a few friends and acquaintances with website optimisation, I've been approached by a web designer about doing SEO work for them on an ongoing basis. They would like me to propose a service or set of services I could offer together with a set of prices.

The easiest and cheapest service I could offer is sets of directory submissions. To do these I could use my development version of professional directory submitter, SliQ Submitter Pro. This should allow me to do a hundred or so submissions an hour.

Of course there are a lot of other techniques I could use to do link-building. The more I think about it though, the more I feel a fixed price service won't do the job. SEO is a long-haul activity and needs to be spread over a number of months. Ideally I would spend 6 or so hours a month doing offsite optimisation for a website using directory submissions, articles where appropriate plus other link-building techniques I've become familiar with.

Spreading the SEO work over a few months should give better value and satisfaction to the customer. With a one-off hit at link-building, there won't be time to see any results before the work is completed. It's also likely to be unsuccessful. To do optimisation, you have to be able to monitor the results and make changes over a period of weeks. with newer sites this is especially important as the sites tend to perform well for a period before dropping back.

The other aspect I've got to price up is the on-page optimisation. Do I charge per page? Do I have a minimum charge that makes it worthwhile doing the job in the first place? If I think back to when I was looking for SEO help, I would often get quoted £350 a site or £100 per page. I never felt entirely comfortable with quotes like that since they didn't quantify what work was being done. Now, I've got more experience I can also see that it's pretty hard - or at least less optimal - to optimise a single page on a website.

I'll also have to think through whether I offer any PPC, e.g. Google Adwords advice. My feeling right now is that I shouldn't since I don't think it's a good medium to long term way of getting traffic/ sales, or rather I think that organic SEO will be the most cost-effective after a 6 month to 1 year period.

Sunday 30 November 2008

Software Trial Periods: How long before customers buy?

With the November releases of SliQ Invoicing and Quoting (Standard and MC), I made a change to the format of the product and unlock codes. The idea behind this was to simplify the process for users, making it easier to check if a product code was correct. The new format also makes it easier to generate an unlock code. The new unlock code format is also longer - meaning that people will be less likely to try and type the code in by hand. This should reduce the chances of the unlock code being mistakenly typed. On the advice of a fellow software vendor, I now use the customer’s identity - land and email addresses in the code making it easier to match codes to customers in the future.

I've always wondered how long people use my software before purchasing. People have up to 30 days free use before they need to buy but until now I've had no way of gauging how long people try before buying on average. With the change in the code format, I've been able to tell whether someone download the software before or after the change. Previously, I’d read posts from other shareware authors or marketing people advising that people tend to buy more or less immediately - within hours - if they are going to buy. The longer people leave between trying and buying, the less chance of a purchase. Although not a scientific test, in the three or so weeks since the last release, 90% of purchasers still use the old format code. I'm taking this to mean that, at least with my products, most people take pretty much full advantage of the 30 day trial period.

Of course, I could get worried by purchasers still registering with the old product codes. With the credit crunch I could assume that I’m not getting any new customers and I’m just exhausting the supply of people who downloaded a trial a month ago. However Google Analytics is actually showing an increase in traffic over the past 3 weeks and my download bandwidth has increased too. This means I'm probably getting proportionately more new trial users. The sales haven't dropped off either, which I was kind of expecting for business-related software in the run-up to Christmas.

If all this means that most people take advantage of the trial period then I’m glad. I want people to use the full trial period to make sure they are happy to purchase. Hopefully it reduces the support overhead in the long-term since those people who do buy will be more happy with the features the software provides.

Friday 28 November 2008

Remote Support Access

For a while, I've been looking for a way of improving support to customers. If a customer is confused by a feature or we can't understand the problem they are trying to describe things can be difficult. The only real way to move forward in such situations is to see what the customer is actually doing on their PC. Site visits are not really possible - for cost reasons if nothing else - so I've been looking for a way of sharing PC desktops remotely over the internet.

Discussions with friends raised a number of possibilities - Webex, Windows Invite a Friend and NetViewer were mentioned. The cheapest options is Windows Invite a Friend - it comes free with Windows XP and Windows Vista. I tried it our on a pair of PCs in our office but found that:

  1. You have to explain to the client/ customer how to get the service going and send an invite for support.
  2. The help pages linked from XP's help are no longer present on Microsoft's website.

Both of these points make me wary of using Invite a Friend - they wouldn't make SliQTools look professional.

So I took at NetViewer. This seems a reasonable service - the cost is good and the service works well. The support technician sends an invite to the customer, the customer downloads a small client program (linked from the support invite email) and gives access to his PC to the support person.

To see an alternative, I took a look at LogMeIn Rescue. This turned out to be the Rolls-Royce remote support service. It's a really good package, working more smoothly and with a more professional, friendly feel for the technician and customer. The only downside is the cost - 4 times that of NetViewer. Overall though, I think you get what you pay for and LogMeIn Rescue seems like a good choice.

Wednesday 12 November 2008

Free Directory Submission Software

It's about 3 months since I made a new release of my free directory submission tool, SliQ Submitter. Since I made the release, I've been busy on other projects. One of those projects is a faster directory submitter that should make the whole submission process much quicker - perhaps as little as 1 or 2 seconds if the directory doesn't have a captcha.

SliQ Submitter was my first attempt at writing directory submission software. Initially I made 3 releases very soon after each other - first with a free web directory list containing 450 directories, quickly followed by 2 more releases until the package listed over 2000 web directories. I initially tested submissions to all the listed directories and was confident that all directories worked and would accept submissions.

Soon after the last release though, I realised that web directories don't stand still. Before long the PR of the web directories changed, with a lot going to PR0. Whether this caused a number to give up I don't know, but quite a few of the 2000 went offline. As the months have passed, a number of the domains expired and a good percentage of the directories switched to paid.

In the last few days, I've rechecked the directories, removing those which are dead or have switched to being paid. Of the original 2250, there are now about 1250 left. As of today though, all of these are free and if a submitted website gets accepted by a good proportion of the 1250 directories, the site should get a good boost in PR and performance in SERPs.

Getting more Visitors and Page Views

I've been helping a friend optimise his software archive site SoftTester. The site is nearly 5 years old and has about 100,000 pages as well as being listed in DMOZ. Over the last couple of years his site had been slowly losing visitors. By June he was down to only a few hundred a day. Needless to say, his income from Adsense had fallen away to almost nothing.

In June, we decided to do some SEO on the site. We mainly concentrated on on-page SEO and improved page titles and descriptions as well as adding good h1 and h2 tags. His site is database-driven, with most of the content coming from PAD files submitted by software authors.

We changed some of the data used to display info as well as shuffling the position of some the displayed items. Whatever we did, it seems to have paid off. Within a couple of weeks, search engines started sending more traffic to the site. In particular traffic from Google began to grow steadily.

As well as on-page optimisation, we set about getting new links to the site. One of the main ways software download sites get links is by reviewing and making awards to listed software packages. Software authors can then use a nice award graphic on their own websites and link back to the archive. The existing graphics were a bit tired, so I encouraged my friend to buy classy new ones and before long he began to get extra links to his site.

After waiting 4 or 5 months, the number of visitors and page views had grown by a factor of nearly 5 and the income from Adsense had grown along with the traffic. Not a bad result for a few hours work spread over a few days.

Monday 10 November 2008

SEO’ing webpages using precise Keywords

A friend of mine has been trying to optimize his webpages. His site is an online shop selling jewellery. On each webpage, he's added a set of links to each product page. These links aid the user in navigating around the site and also attempt to improve SERPs performance as the anchor text for each link includes the keywords for each product page. For example, on one page he's trying to sell some Choker Jewellery, so he made Choker Jewellery the anchor text of the link to the page.

All the links and anchor text are chosen to reinforce the keywords used on the linked page. He's taken things one stage further and dynamically parsed the page description from the backend database and generated the anchor text for the links automatically. This will make it much easier to add product pages in the future and is a good example of using a database to make management of a website easier.

To give the links extra value he's added the navigation near the top of each webpage on the site. This should show google that these links are important. To make the placement of the links useful to visitors he's also added the text “Recent Searches” so the links look like phrases people have used to search for items on my site, but more importantly providing google with an important set of links.

He wasn't sure whether to have these links at the top of the page as they do look odd. However his biggest problem was deciding what keywords to use for his home page. He finally decided on Cheap Jewellery. Having developed several websites in the past and getting little traffic, he was keen to better this time and used the Adwords keyword tool to find keywords with a good expected level of traffic. He then matched the best keywords against the products on his shop site. An example would be Jewelry which is a spelling mistake, but a good keyword from a volume point of view with a good, i.e. low, level of keyword competition. This was a difficult process but he found that keywords with a good expected level of traffic aren’t necessarily the keywords people use when searching for things to buy from his site. Therefore the whole strategy is quite risky, but definitely worth trying.

Monday 13 October 2008

Capturing an image/ thumbnail of a webpage in C#

For a while I've been figuring out how to programmatically get an image of a web page using C# and .Net. This could have a number of uses such as displaying a thumbnail of a web page. I found a number of methods by Googling but on the whole they seemed a bit lengthy. Eventually, I combined bits of a number of methods and then simplified things by trying out an alternative approach myself. One key thing I wanted to do was to create a mini picture of a website for display in a new desktop app I'm developing.

In the end I wrote a simple class with a single static method called
GrabImageOfWebPage. GrabImageOfWebPage takes a .Net WebBrowser control instance as an argument together with the required size for the captured image. The web page loaded in the WebBrowser control is captured (the entire client area of the control is captured) and shrunk/ enlarged into a bitmap of the required size. Here's the code:


using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using Microsoft;
using mshtml;
using System.Runtime.InteropServices;
using System.Runtime.InteropServices.ComTypes;
using System.Drawing;

namespace BrowserComponents
{
///
/// Class providing a static method to return a bitmap of a web page rendered in
/// a .Net webbrowser control.
///

public class CBrowserImageGrabber
{

[ComVisible(true), ComImport()]
[GuidAttribute("0000010d-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute(ComInterfaceType.InterfaceIsIUnknown)]

private interface IViewObject
{
[return: MarshalAs(UnmanagedType.I4)]
[PreserveSig]
int Draw(
//tagDVASPECT
[MarshalAs(UnmanagedType.U4)] UInt32 dwDrawAspect,
int lindex,
IntPtr pvAspect,
[In] IntPtr ptd,
//[MarshalAs(UnmanagedType.Struct)] ref DVTARGETDEVICE ptd,
IntPtr hdcTargetDev,
IntPtr hdcDraw,
[MarshalAs(UnmanagedType.Struct)] ref tagRECT lprcBounds,
[MarshalAs(UnmanagedType.Struct)] ref tagRECT lprcWBounds,
IntPtr pfnContinue,
[MarshalAs(UnmanagedType.U4)] UInt32 dwContinue);
}

public static Image GrabImageOfWebPage

(WebBrowser Browser, Size ImageSize)
{
// Get the view object of the browser
//
IViewObject VObject = Browser.Document.DomDocument as IViewObject;


if (VObject != null)
{
// Construct a bitmap as big as the required image.
//
Bitmap bmp = new Bitmap(ImageSize.Width, ImageSize.Height);


// The size of the portion of the web page to be captured.
//
mshtml.tagRECT SourceRect = new tagRECT();
SourceRect.left = 0;
SourceRect.top = 0;
SourceRect.right = Browser.Right;
SourceRect.bottom = Browser.Bottom;



// The size to render the target image. This can be used
// to shrink the image to a thumbnail.
//
mshtml.tagRECT TargetRect = new tagRECT();
TargetRect.left = 0;
TargetRect.top = 0;
TargetRect.right = ImageSize.Width;
TargetRect.bottom = ImageSize.Height;



// Draw the web page into the bitmap.
//
using (Graphics gr = Graphics.FromImage(bmp))
{
IntPtr hdc = gr.GetHdc();
int hr =
VObject.Draw((int)DVASPECT.DVASPECT_CONTENT,
(int)-1, IntPtr.Zero, IntPtr.Zero,
IntPtr.Zero, hdc, ref TargetRect, ref SourceRect,
IntPtr.Zero, (uint)0);
gr.ReleaseHdc();
}



// Return the bitmap.
//
return bmp;
}
else
{
return null;
}
}
}
}


}
To gain visibility of the types in this example, you have to include the following uses:
using mshtml;
using System.Runtime.InteropServices;
using System.Runtime.InteropServices.ComTypes;
using System.Drawing;
and you also need to add a .Net reference to your project for Microsoft.mshtml.

Using the method is then pretty easy. The example code below create a webbrowser control and loads a webpage. When the webpage is fully loaded, it grabs an image 10% the size of the original page and displays it in a picture box.

WebBrowser mWebBrowser;

public Form1()
{
InitializeComponent();

mWebBrowser = new WebBrowser();
mWebBrowser.Width = 1024;
mWebBrowser.Height = 768;
mWebBrowser.ScrollBarsEnabled = false;

mWebBrowser.DocumentCompleted +=
new WebBrowserDocumentCompletedEventHandler
(mWebBrowser_DocumentCompleted);
mWebBrowser.Navigate
(@"http://www.software-product-development.blogspot.com");
}


void mWebBrowser_DocumentCompleted(object sender,
WebBrowserDocumentCompletedEventArgs e)
{
if (mWebBrowser.ReadyState == WebBrowserReadyState.Complete)
{
Image Img =
BrowserComponents.CBrowserImageGrabber.
GrabImageOfWebPage(mWebBrowser, new Size(102, 77));

if (Img != null)
{
pictureBox1.Image = Img;
}
}
}

Monday 6 October 2008

Losing a PageRank Value

In the mini-update toolbar export on Sept 26th this blog lost its PR, i.e the value went to N/A. Previously the PR had been 3. Why this has happened I don't know. I haven't linked to any silly sites or reduced the frequency of posting.

Today I also noticed that a few inner pages on the blog have PR. I haven't noticed this before. It's strange that the older posts have PR but the blog home page is back to PR N/A. Google Analytics isn't showing any change in the level of traffic to the blog.

Friday 12 September 2008

How to keep on the good side of Google

When people are trying to improve their ranking in search engine results page, a lot of people will use any advice they can find in a struggle to improve rankings. People need to be wary which advice they follow though. Some advice will cause you to be penalised by Google.

If a page on your website is penalised, it will not perform as well as it might in search results. Here are some tips to help avoid penalties. In the case of a new website, it may never get to perform well in the first place.

Remember that outside Google, no-one really knows what counts as good or bad in terms of SEO. There is some general advice from Google about having good, unique content and quality backlinks. Other than that, people are justing using their experience and guesswork to find out what works and doesn't. A lot of SEO information online is copied and spread as online myths.

With this proviso in mind, here's a fairly non-controversial list of things to avoid.

  • Avoid Exchanging Links
    Excessive link exchanging should be avoided as Google may see this as an attempt to artifically improve rank. A few link exchanges will be OK but avoid large numbers. Link farms - where a large group of sites hyperlink to all other sites in the group should always be avoided.
  • Do not Sell links
    Selling links is a no-no - unless the hrefs use the nofollow attribute. If your site sells dofollow links and Google becomes aware it may well be penalised. Google's WebMasters site allows people to report paid links. Rumour has it that Google may use this information to adjust its algorithms to improve detection of paid links.
  • Do not buy links
    Recently, Google has threatened to penalise sites they discover have purchases dofollow links from another site. Logically thinking though, this does not seem possible - or at least it would be extremely unfair! If this were to be the case it would be easy to penalise a competitor by purchasing links to their site and then reporting them to Google.
  • Avoid duplicate content
    If possible, avoid duplicate content. For example, don't make the same post to two different blogs. Google will ignore copies of content. A few copies will make it into Google's index but lots of copies will be ignored. Even on different pages within a website, try to keep the textual content unique and avoid repeating whole paragraphs of text.
  • Don't stuff keywords
    If you want to perform well for a certain keyword, stuffing your webpages full of the keyword will not help. Write you copy in a natural way so that it reads well. If you are writing a web page about Google penalties (for example), the keyword "Google Penalty" will naturally appear a number of times - you don't need to repeat the phrase scores or hundred of times.
  • Don't include hidden text
    Make the contents of the webpage visible to the user. For example, don't include extra content such as white text on a white background that the user cannot see.

Sunday 7 September 2008

Sitelinks update

Today, Google Webmasters shows an updates in my sitelinks but these don't seem to have made it to the SERPs yet. Three new links have been added to my sales, support and SliQ Submitter pages. When these links make it to the search results, the sitelinks will look much better than at present.

Sunday 31 August 2008

Further thoughts on Google Sitelinks

Thinking about it a bit more, my feeling is that Google needed knowledge of where people went after landing on the SliQTools homepage in order to choose the sitelinks. The only way Google could have this knowledge is by using Google Analytics data. I wonder if sitelinks have ever been given to a site that did not use Analytics?

One of the search terms for which sitelinks are displayed is used by people revisiting the site to see if there is a new release. After landing on the homepage, they go to the Release History Page.

I did a rejig of the homepage a couple of weeks ago and shuffled around some of the thumbnails to make people go to a better page after the homepage, i.e. the Invoice Software page instead of the Invoices & Payments page. I think the Invoices & Payments sitelink was generated before this reshuffle. Perhaps after 90 days the sitelinks will be regenerated inline with the new site linking stucture.

SliQTools now has SiteLinks

Today I noticed that for a couple of search terms, the SliQTools website now has sitelinks on Google. The links aren't really to the pages I would have wished to highlight to users.

If I could generate the sitelinks manually - which isn't possible with Google sitelinks - I'd have chosen the invoice software page, download trial page, invoice templates page and sales pages. Instead, Google has chosen the Invoices & Payments page, Invoice Templates page and Release History pages.

It's interesting how Google has chosen the names for the links too.

The names aren't the first words in the page titles, i.e. in the HTML title tags. Also, in the case of the Invoice Templates link, the link text isn't the anchor text used for links to the pages within the site either. Interestingly, the Invoices & Payments link has only one text link pointing to it within the SliQTools website - mostly it's linked from a thumbnail. I thnk the sitelinks persist for 3 months, i.e. the links won't change for 90 days.

Monday 25 August 2008

Different sites, different visitor profiles

I thought I'd make a record of the share of visitors two of my sites get from different search engines. The profiles are very different and not really what I'd expected. the first sets gets over 90% of its traffic from direct addresses/ bookmarks but here are its search engine stats:-

  1. Windows Live - 53%
  2. Google - 32%
  3. Yahoo - 10%
  4. AltaVista - 2%
  5. Alexa,Google Images,Tiscali,Dogpile,AllTheWeb - 3%

The second site gets less than 5% of visitors from direct traffic. Its search engine stats are:-

  1. Google - 77%
  2. Yahoo - 10%
  3. Unknown - 8%
  4. AOL - 2%
  5. MSN, Tiscali, Ask Jeeves, Alexa, AltaVista - 3%

The search engine stats are very different between the sites. The second site is my oldest. For both sites Google is very important but I'm surprised to see Windows Live heading up the list for the first site. The first site is quite new - less than 2 months old. In another couple of months I'll see how the search engine stats are looking then.

Saturday 23 August 2008

Google PageRank - Second Update

I'd been confused by the visible Pagerank of this blog as shown on the Google toolbar. After the last export of rank values at the end of July this blog had still not been assigned a rank value by Google and was still showing PR N/A. However today - Aug 23rd - the rank is showing as PR 3! This is great news and much more in line with what I was expecting. I'd been doing a mixture of different types of link-building and had also been doing directory submissions using SliQ Submitter, my directory submission software. This now looks as though it has paid off - at least in terms of PR - and ties up with the increase in the number of visitors to the blog over the past 4 weeks.

Thursday 21 August 2008

Tracking performance in SERPS for keywords

A few day ago I was speaking to a friend who was testing out SliQ Submitter for me and providing some useful, constructive feedback. He was wondering what tools I used to check the ranking of my site on Google for different keywords. I don't use anything other than Google searches by hand but I thought I'd look to see if there was anything on the market.

I soon found a tool called WebPosition Gold or WPG for short. This tool allows you to automatically track the performance of sites on Google and show nice graphs of the historical trend. Trouble is that with a bit more reading online, it turns out that Google mentions that use of WPG is against Google's terms of service. the terms specifically name WPG as well as saying that similar tools are also not to be used.

To use WPG you have to a Google API key for their SOAP search API. Google no longer issue such keys and there are stories online saying that WPG users are now finding that WPG gets blocked. The future doesn't look good for WPG.

When I think about, it seems fairly clear that tracking a few keywords is interesting but not necessarily informative anyway. What really matters is traffic to your site and conversion of visitors to sales. You could be performing really well for certain keywords - and improving in performance too - but really you need to measure traffic. Google itself provides a better measurement tool - Google Analytics. If you have the time, Google Analytics can provide valuable data about the performance of your website - traffic figures, how people got to your site (not just SE performance) and where they went went they landed on your site.

Monday 18 August 2008

SliQ Submitter - New Release

SliQTools have released an updated version of their free directory submission tool SliQ Submitter.

After feedback from beta testers, a number of enhancements have been made:-
  1. SliQ Submitter now attempts to learn directory categories selected by the user on the directory page. This means that the user is no longer restricted to a small, fixed set of categories to be filled in automatically - the more categories you use when submitting to directories, the more categories SliQ will learn.
  2. If SliQ Submitter can detect that a website has been successfully submitted, SliQ will load the next directory automatically.
  3. A number of GUI enhancements have also been made.

The end results of these improvements is that SliQ Submitter is now easier to use and makes the process of web directory submission faster.

Read the original release post for SliQ Submitter.

Sunday 27 July 2008

Google Pagerank update - Strange results

Two or three days ago Google exported the current Pagerank values to the Google toolbar. I always find this interesting - not because I put a huge amount of faith in a higher Pagerank value, but simply because I take a higher Pagerank value to mean I'm probably doing something right in terms of SEO.

This time round I had some confusing results. On the main SliQTools website, 6 inner pages moved from PR2 to PR3 but one page dropped from PR2 to PR0. The homepage itself remained at PR3 while another page (relatively new) that does really well in SERPS for certain keywords had PR 0. I find it a bit hard to explain how so many pages are PR3 and the homepage is only PR3 and why other pages are PR0 but still do well in SERPs. I guess Pagerank isn't as important as it used to be.

The other confusing aspect about the recent export, is that another of my websites has gained PR2 from PR0. This is hard to explain since it only has links from a forum. Its inner pages are PR1 even though one of them is virtually blank.

I collaborate on another blog with a friend. This blog is still PR0 but he has a new website - registered less than 2 months ago that only has links from the PR0 blog - and the new site has a PR of 1 which is higher than the only external site giving incoming links.

Strange!

New Directory Submission Tool

SliQTools have just released a beta of a new directory submission tool called SliQ Submitter.



SliQ Submitter helps speed manual submissions to web directories. Submitting to web directories can still be an important way of gaining backlinks for a website in order to help with positioning in search engine result pages.

SliQ Submitter is available for free. The tool currently handles submission to about 450 directories and will be updated in a future release to handle many more.

The software allows up to 5 titles and descriptions to be specified together with up to 6 categories. SliQ Submitter autmatically fills out the fields in web directory submission forms. All you have to do is review the submitted details, enter any captcha and click the directory's Submit or Continue button to complete the process.

To find out more about SliQ Submitter, go to http://www.sliqtools.co.uk/directory-submission-tool.aspx.

Thursday 24 July 2008

.Net WebBrowser Control & DocumentComplete event

Lately I've been developing a new application that includes an embedded web browser. The application loads specific web pages and then reads and writes to the fields on the page. For example, it might set some fields to text values defined by the user or read the value of a combo/ dropdown to see if a user-defined criteria is met.

The fundamentals of the new application were working OK but under some conditions my code failed to access the fields on a loaded web page. The access code is executed in the .Net WebBrowser control's DocumentCompleted event.

The DocumentCompleted event is fired after calling the control's Navigate method to load a web page. After some investigation I found that the DocumentCompleted event was being called more than once when a page was loaded. What I had to do in the event was test the WebBrowser's ReadyState property and check that the state was Complete. Only when a Complete state was set could the DocumentCompleted event run code to access the HTML fields on the web page. The DocumentCompleted event might be fired many times as a page is loaded but any code accessing the WebBrowser's Document property should only be executed if the ReadyState property has a value of Complete.

Friday 18 July 2008

Keyword Research Tools

Google have recently released a new keyword research tool at this link:

https://adwords.google.com/select/KeywordToolExternal

This new tool gives estimates of search volumes for different keywords and can be configured to specific regions, e.g. the UK. If you need to choose keywords for a new web page where ranking in SERPs is important, this tool can provide a better way of picking good words and phrases than simply guessing which might be good.

Thursday 17 July 2008

.Net Double vs. Decimal

One twist with floating-point values is that they cannot represent every possible number. In part this is because the types are of limited size, e.g. Double only has 64-bits of data to work with. The number base used to represent values also has an effect. The .Net float and Double are encoded in base 2 (binary) format. It's not possible to represent every base 10 decimal number in base 2.

To increase accuracy, use the Decimal data type. The .Net Double data type is a 64-bit floating point value whereas the .Net Decimal data type is a 128-bit floating point value. These extra bits alone might be sufficent to make the Decimal type more accurately represent numbers than Double. However, unlike Double, Decimal is encoded in base 10. This means it can exactly represent base 10 numbers, i.e. the number system humans use, and make it an ideal type for financial calculations. The way the type works allows 28 digits of accuracy, i.e. you can represent 28 decimal digits with the decimal point moved to any position amongst the digits.

So why use Double if Decimal is available? The downside with Decimal is performance. Decimal operations can take 20 to 40 times longer than Double calculations. Most, if not all, processors used in PCs these days have 64-bit floating-point support built into the processor. Decimal operations however have to be done in software and take much longer to execute.

Wednesday 16 July 2008

Beefing up Backup/ Restore Protection

Sometimes the easiest solutions are the best. Rather than worry about whether having Restore buttons on the new Company tab in multi-company SliQ could carry a risk of users overwriting data with data for the wrong company, we've now added an extra check. When the user restores data, we now check if the data being restored is for the same company. If it isn't we let the user know and ask for confirmation before continuing with the restore.

This additional check will also make it into the single-company version of SliQ on the next release.

The actual risk of data loss is quite small. Even if the user does load the incorrect backup file, the daily autobackup will have saved a very recent copy of data in any case.

CD Autorun in Windows XP and Vista

To get Windows to automatically launch an application when a disc is inserted into a CD or DVD drive you need to include an autorun.inf file on the root of the CD folder.

The autorun.inf file is a text file written in a Windows INI file format. The sections in the file tell Windows what to launch, e.g.

[autorun]
shellexecute=install-instructions.html

launches the default browser on your PC, e.g. Internet Explorer, and displays the install-instruction.html file in the root of the CD (or DVD). You can then include further instruction in the HTML file together with links to launch an installer for example.

Thursday 10 July 2008

Windows Update & AVG Firewall

I just lost 3 hours of support time due to Windows Update. I switched off my computer at lunchtime and XP said it would install another update from Windows. I left the computer to update itself as I've never had problems before.

When I came back this evening, I couldn't connect to the BT wireless router. My other PC with an Ethernet cable was fine but my main PC refused to connect. I used my wife's PC in the end and found that a lot of other people were experiencing the same thing. The fix turned out to require cranking down the AVG firwall setting. Very frustrating!

Tuesday 8 July 2008

First Review of Multi-Company SliQ

First review of the multi-company version of SliQ highlighted a couple of areas that need reconsideration:-

  1. Upgrading from the single company version. How do you transfer data from one version to the other?
  2. Is it entirely friendly to have a Restore Backup button on the Companies tab?

For point 1, the current idea is that you create a dummy company and then load an SLB (SliQ backup file) into the company overwriting the existing contents. This isn't entirely friendly however, so we may have to add a feature where you can create a new company by opening a backup file.

For point 2, although it seems to be convenient to have the button on the Companies tab, in some ways it's a bit inconvenient - the user could end up overwriting data in the wrong company by mistakenly clicking on the wrong row. Perhaps the easiest, less problematic thing to do would be to remove the save and restore backup buttons from the Companies tab and leave them in the Setup tab and SliQ start menu as in the single company version.

Sunday 6 July 2008

Installshield 11.5 and .Net 2.0 runtime install

I'm doing a new installer for a new software package and it's 6 months since I last used Installshield. I find it pretty difficult finding my way around Installshield so I'm making a blog post about what I had to do to get .Net 2.0 installed as well as the main package.

Last time I did an installer I needed to install the .Net 2.0 runtime prior to the main package. I had to a fair bit of research using Google to find the info I needed. This time around I ended up doing the same searching so I'm making a note in this blog for future reference.

Using InstallShield 11.5 ...

  1. You have to run the Release Wizard and create a new Product Configuration to include .Net 2.0. The wizard has an option to include .Net 2.0 that appears nowhere else in InstallShield.
  2. In the Installation Designer, click on the Media/ Releases node and then, in the middle panel, click on the release to configure more .Net install options. Then ...
  3. In the Command Line to dotnetfx.exe option, put " /q:a /c:\"install /qb\"". This forces a quiet install of the runtime.
  4. Set Show full user interface when installing .Net framework to Yes.
  5. Set display .Net Option dialog to No so the user is not given the option to skip installing .Net 2.0.
  6. Set Delay .Net Reboot to Yes.

Then save everything and build the installation. Now, if the setup.exe is executed on a machine that doesn't have .Net 2.0, the installer will make sure the runtime is installed on the user's machine.

Saturday 5 July 2008

Multi-Company Version of SliQ

Development of the multi-company version of SliQ is coming to an end. The last thing to be done is to update the help file and write the installer before reviewing and test begins.

The multi-company version adds a new tab (shown on the right) listing the companies SliQ knows about. Simply selecting a company in the list, loads it data into the other tabs.
The bottom panel allows the user to keep notes about the company, e.g. the dates invoicing needs to be done on each month.
When the user adds a new company into SliQ a company setup wizard is launched guiding the user through entering the company details, VAT/ tax registration number and so on. SliQ automatically creates a filename based on the company name and saves the company data.
With any luck, if reviewing and testing goes well SliQ Invoicing & Quoting MC should be released within 2 weeks.

Monday 30 June 2008

New Software Directory Launched


SliQTools have launched a shareware download site. Thousands of software packages are listed offering a mix of shareware/ try before you buy software and freeware/ completely free software for downloads.
SoftwareLode accepts listing submissions from software authors worldwide. All submissions are reviewed before being accepted into the directory. SoftwareLode only accepts submissions using the Association of Shareware Professional's PAD file format.
SoftwareLode allows users to submit reviews on downloaded software. Authors can apply to have their software reviewed and given an award by the site owners. In addition a number of advertising options are provided allowing software titles to be given more prominent advertising slots.
Feel free to browse the software directory and download one of the many titles available for free.

Friday 20 June 2008

4 Tips for Making the Most of a Hyperlink

When getting a link to one of your websites you need to make the most of the link - not all links are equal. Here are my 4 tips for getting the most benefit from a link in terms of SEO:

Place the link on a page with higher PageRank

This means the link will have more PageRank to pass to you and will hopefully help push you up the ranking in search results.

Try to place the link on a page with only a small number of other links

When passing PageRank to other pages, the rank of a page is divided up between all the outgoing links on the page. If there are a lot of links on a page, the benefit passed by each one is reduced.

Place the link on a page on a similar topic to your own

For example a link from a page talking about shoes to one with a topic of finance is probably worth less.

Make sure the link text reinforces your keywords

For example, if one of your keywords is "Greek Holidays", make this the text associated with the link using the href element.

Wednesday 18 June 2008

Keyword Research Tools for SEO

The following links point to great (and free!) tools to research popular keywords and longtail keywords for web pages.

http://freekeywords.wordtracker.com
http://inventory.overture.com/d/searchinventory/suggestion/

Monday 16 June 2008

Tool for creating a sitemap for a website

As my website grows larger and acquires more pages I want to give Google all the help I can indexing my pages so I submit a sitemap using Google's webmaster tools.

I've been looking for a good tool to create a sitemap for my website for a few months on and off.
I found a few shareware programs but the majority of these would only scan the root directory of my site or cost more than I was prepared to spend for something I would only use 3 or 4 times a year.

However, I've now found a site with a great, free sitemap generator:

http://www.xml-sitemaps.com/

It scans subfolders and also works quicker than the shareware programs I've been using. It also exports sitemaps in a number of different formats including compressed and uncompressed sitemap format as well as ROR sitemap format.

Saturday 14 June 2008

SliQ Invoicing and Quoting 1.4 Released!

SliQTools have released version 1.4 of their invoicing software SliQ Invoicing and Quoting.

Version 1.4 is available as a free upgrade to any existing purchasers. To upgrade to 1.4, all existing owners have to do is download a new trial copy from the SliQTools website and install 1.4 on their PC.

SliQ Invoicing and Quoting can be configured for different currencies and tax rates.

A fully functional 30 day trial of SliQ Invoicing and Quoting can be downloaded from the SliQTools website.

Version 1.4 of SliQ Invoicing and Quoting is still available at the same price of £24.99.

A number of useful features have been added in version 1.4:-
  • Multiple invoice templates are now supported.
  • Service Invoices as well as Product Invoices are now supported.
  • Discounts (% and amount) can now be applied to invoice items.
  • Standard discounts can be stored.
  • Remittance slips can optionally be included on invoices and statements.
  • Payment details information can be stored.
  • Customer and product data can now be exported and imported allowing data to be shared with other copies of SliQ or external applications.

All the useful features of SliQ 1.3 are still present in the new software release. SliQ supports a range of sales reports and includes the ability to create esimates/ quotes, credit notes and statements or ageing reports.

All items can be emailed from SliQ as PDFs. New copies of invoices or quotes can be raised and quotes can be turned into invoices with a single button click.

To visit the SliQTools site and find out more, go to http://www.sliqtools.co.uk/.

Friday 13 June 2008

What makes a good software tester?

Good software testers are a rare breed. There are also different sorts of testing and often a person can be good at one kind of testing but not at another. Here are some basic tips for choosing testers:

Don’t rely on a single person to do all the testing

Relying on a single person is putting all your eggs into one basket. You’re just asking for trouble. It’s very easy to get bored while testing and one person will, perhaps without realising it, miss important tests or features.

Don’t rely on the product developers to do all the testing

The product developers are simply too close to the product to see the wood for the trees. They will know the product back to front and will use the product features in the way they expect the features will be used. The product developers may not test the product in ways it will end up getting used by real customers.

Don’t rely on external developers to evaluate features

Using external people is good. They won’t be so familiar with the product. Using other developers though isn’t ideal. They are so computer literate they will, probably subconsciously, work around difficulties or things which might not be obvious to less savvy users.

Use women as well as men

Women often make very good testers. Women can be better than men at working in a detailed way. In my experience they are also less embarrassed in asking for help about something they don’t understand. This is a key skill for testers. The worst thing that can happen is a feature gets into the field, a problem occurs, and you find it was spotted in testing but not reported because the tester worked around the difficulty.

What’s a Software Bug?

If you ask this question to a software developer, you might get the answer …

"One man’s bug is another man’s feature"

Not everyone’s a software developer though, some people actually pay money for software and are called “customers”. Customers take a different view. They might say:

"This bug makes me not want to buy your software"

… or, perhaps worse …

"I wish I’d never bought this software"

There is a class of problem which everyone will agree is a bug – software developers and customers. These problems usually involve software crashing or refusing to run. To summarise, there are two main types of software bug or problem:-

  1. Something doesn’t work the way the user expects (or wants).
  2. Under certain conditions the software crashes and stops working.

By performing thorough testing of software before releasing it to customers, the number both types of problem can be minimised. If you want to sell software, conducting a proper and thorough testing phase prior to every release is essential.

To reduce the likelihood of the different types of software issues, different types of testing need to be performed.

To eliminate type 1, detailed step-by-step testing of the software needs to be performed. For small software development products or teams, thorough black box testing should suffice. This means that all features of the software should be exercised with a range of possible data and inputs to see if any problems occur.

To eliminate type 2, beta testing must be performed. Beta testing involves asking people outside the development team (or even company) to evaluate the features to see how useful and usable they are.

Thursday 12 June 2008

Software Bugs, Software Releases and Version Numbers

Occasionally the inevitable happens and I get a problem report on my software products. Usually this doesn't happen frequently, e.g. for the whole of March, April and May 2008 I haven't had a single problem report.

When a problem is reported I have to weigh up how serious the issue is and how many customers are likely to be affected. In one sense all customers could be affected by a software bug, the question comes down to how many people are actually likely to run into the issue.

One thing that helps is how long a software release has been in distribution before the problem is reported. If the release has been in the field for a few weeks - or hopefully months! - I can have more confidence there's no need for a knee jerk reaction. If this is the case I can avoid a global release to all registered customers.

Whatever happens, if a customer has reported a problem I will either try to find a workaround that we are both happy with or provide them with a new software release. I do this whether or not the customer has paid for an unlock code or is still using a trial copy of SliQ Invoicing and Quoting.

If I make a special release for a single customer I use an intermediate version number for my products. Normally I use 3 digits to number software versions. For example:

1.3.0
1.3.1
1.4.0

but if I do a release to a single customer I will use a 4th digit on the version number in the application's software version resource. For example:
1.3.1.1

if a problem was found in version 1.3.1.

This way, when I come to do a full public release of software, I can avoid documenting the intermediate versions in the Release History on the product website. I can just document the major, public releases: 1.3.0, 1.3.1, 1.4.0

Of course, one question will always be: what's the difference between a bug and feature that doesn't work the way a customer expects? This is a topic for a different post however.

What is Google Pagerank?

Put simply, it's Google's measure of the importance of a web page or put another way, a measure of how likely you are to find a web page by randomly clicking on hyperlinks online. Google gives a web page a PageRank value between 0 and 10 with 0 meaning least important and 10 meaning more important.

This is the Google definition of PageRank:

PageRank relies on the uniquely democratic nature of the web by using its vast link structure as an indicator of an individual page's value. In essence, Google interprets a link from page A to page B as a vote, by page A, for page B. But, Google looks at more than the sheer volume of votes, or links a page receives; it also analyzes the page that casts the vote. Votes cast by pages that are themselves "important" weigh more heavily and help to make other pages "important".


Basically having more hyperlinks makes a page more important in Google's eyes. Incoming links from important pages count for more than links from less important pages. In a simple sense, if two web pages contain the words "Red Bananas" and a user searches for Red Bananas on Google, the page with the higher rank will appear first in the search results.

However, things are not quite this simple. If things were this simple, there would web pages stuffed with multiple links to other pages in an attempt to improve placings in search
results on Google.

Apart from Google itself, no-one knows how PageRank is calculated. Google now say that their ranking algorithms are more sophistacted than in years past and the content of pages is now more important than previously. However Google still assign and publish pageranks for websites 3 or 4 times a year so Pagerank must still have some relevance.

These factors are likely to affect the importance or weight passed by a hyperlink.
Multiple links from one page are devalued, i.e. the second link probably counts for less than the first link.

  • Site-wide links are devalued, e.g. a link from every page in a 10 page website probably counts for less than links from 10 pageson separate websites.
  • Reciprocal links are devalued. Many people now consider these worthless. This gets around the mutual voting scenario.
  • A link from a page containing unrelated content counts for less, e.g. a link from a page talking about holidays to a page talking about nuclear physics, counts for less than a link from a page on another site talking about holidays.
  • A link needs to say why it links to another page to give more credit, i.e. the link text needs to be appropriate to the topic of the page being linked.

Tuesday 10 June 2008

Choosing Keywords for Web Pages

Consider these factors when choosing keywords:-
  1. The keywords should accurately describe the products or services you offer.
  2. Are the keywords ones people actually search for?
  3. The best keywords are ones people search for a lot.
  4. Can you find competitive keywords, i.e. ones that aren't used too frequently on other sites.

Some of these factors conflict.

As an example, if you are a travel agent selling holidays you might choose think holiday is a good keyword. After all, you are in the business of selling holidays and lots of people will search online for holidays. However, there are so many web pages containing the word holiday that you will unlikely to appear high in any search results. So although "holiday" will be included in lots of search terms, it is not a competitive choice since it will be used in masses of websites.

Instead choose a few more specific terms. Such as:

  • french holiday specialist
  • travel agent shrewsbury
  • discount package holidays
  • last minute package holdays
  • adventure holidays in spain

Build up a list of keywords and phrases you think people will type into search engines then include these in the text of your web pages. The best way to include the words is in a way that seems natural to the human reader.

Having read this far you might think ...

"What's the big deal? I'm a travel agent of course I'm going to include phrases like adventure holidays in France". I don't need to think too much about keywords, all I need to do is write about my products."

... and you would be correct, except there are methods to highlight your keywords so that they are emphasised to search engines. This will potentially raise your pages up the search results. If a competitor website is optimised to reinforce a certain keyword and your site is not then the odds are you will appear lower in the search results.

Monday 9 June 2008

Favourite Tools for SEO

This post contains links to some of my favourite SEO tools.

Keyword Density Checking

These tools check for the occurrence and density of keywords in websites.

www.googlerankings.com/ultimate_seo_tool.php
www.seochat.com/seo-tools/keyword-density/
www.keyworddensity.com/

Measuring your PageRank

Tools that can be used for measuring the current PageRank of a web page.

http://www.top25web.com/pagerank.php
Google Toolbar - installs a toolbar into your browser and includes the option of displaying the PageRank of pages you visit.
http://www.smartpagerank.com/

Predicting your future PageRank

These links provide tools that attempt to predict your PageRank. Note: The tools are for curiosity only and the predicted values are sometimes wide of the mark - they aren't really SEO aids.

http://www.rustybrick.com/pagerank-prediction.php

Google Results for Multiple Countries

This tool allows you to see how a website performs in multiple countries. There is no single "google" and the results from Google data centres for different countries can be very different.

www.link.ezer.com/tools/google_serps_rank_checker.asp

Find out who owns a competitor domain

This tool allows you to find out who own a domain. The report also provides an SEO rating.

http://whois.domaintools.com/

Find Blogs on a particular topic

This tool allows you to find blogs on particular topics. Posting comments on blogs can give you free backlinks.

http://www.commenthunt.com/

Tips on Writing Web Page Copy for SEO

The copy or text you write in a web page is vitally important for good search engine results. You need to include a good range of keywords. The keywords will be the ones you have calculated people will use when searching for the services you offer on Google, MSN or Yahoo. There are a number of strategies you can use to choose keywords and to write your web pages to emphasis or highlight the keywords to search engines.

There is no penalty for having too much text on a page and if you have written less than 300 words it is unlikely you will have included a good range of keywords for SEO. When writing the text on the page, always write for a human reader but also bear in mind SEO. Include more text and also include long tail keywords. Long tails are keywords that are searched for less often but if you include more long tails you are likely to get just as many, if not more, hits from the long-tails as your main keywords.

A good way to look for keywords is to analyse competitor sites. A set of keyword analysis tools can be found at www.googlerankings.com. Use the tools to find what 1, 2 and 3 word phrases appear on your competitor's web pages. Include the same phrases, where appropriate, on your own pages.

Here are my tips for writing text on a web page:

1. Include alternative ways of saying the same thing, e.g. an invoice software/ invoicing software/ software to create invoices.

2. Include the words in different orders, e.g. a man’s hat/ a hat for a man.

3. One method of adding keywords is to include a column listing benefits or features.

Good ways to ways of including alternative ways of saying the same thing are:-

a. alt text on images

b. title text on a hyperlink.

4. title tag

Use the title tag to hold as many as 3 keyword/ phrases separated by or -. For example:

invoice software billing software

The page title is probably the most important on-page SEO elements and ensure your most important keywords are at the beginning of the title.

5. h1 tag

This the most important header tag. Place a h1 tag near the top of each of your pages and make sure the keywords agree with the page title, e.g.

title = Invoice Software Billing Software
h1 = Invoice Software

6. h2, 3, 4, 5, 6 tags

Structure your pages by separating the text into topics. Use a h2 title for each topic. h3, 4, 5 and h6 can also be used to emphasise keywords.

7. Place important text near the top of the page, e.g. the first paragraph after the h1 tag should contain your main keywords.

8. Use bold or strong to emphasise keywords - Google picks up this as well as a human reader.

Strategy for Selling Software

If you are setting up a software development company and want to sell your own products, one route for selling software is to package your products as shareware. Shareware is a form of software distribution whereby customers can use your software for free for a trial period - it's a kind of try-before-you-buy means of selling software. Historically, shareware has quite often been associated with low-quality or simple software but this picture is changing.

If you want to sell software as shareware, make sure your software products have a sizeable market. It is essential to ensure that your software product will has a value in your chosen market - either because the software has unique features or is better than competitor offerings. Don't rely on a selling strategy of simply being cheaper than your competitors. These days, a lot of people realise that if they want to buy software they will possibly use for a number of years then cost isn’t a key factor when deciding to make a purchase.

Your sales and product development strategies must be based on writing a non-trivial, valuable program. There is a lot of cheap software - even free software - available. There are lots of big companies with large development resources allowing people to use software either for free or for a trial period. The distinction between fully-fledged commerical software and shareware is becoming increasingly blurred. Make sure your software has features that people are willing to pay for.

When selling shareware try to fill a niche and make a quality offering. One example of a niche is an “easy-to-use” version of a larger, more complicated software package. Note the key phrase here is “easy-to-use”, not trivial or cheap. People will pay to have complication taken away from them if the software offering still does an effective job. There is a risk here that some people will provide feedback indicating that your product is too simple and too inflexible. You must be careful in deciding which new features to add - are you willing to sacrifice simplicity and ease of use?

Many people will have made purchases they later regret simply because the product was cheap, e.g. a cheap power tool. Often, sooner rather than later you will have regretted the purchase, either because the product turns out not to be up to the job or breaks easily. People soon learn to spend a bit more money and get a product they know they can live with and continue to use for more than a couple of days. Selling software as shareware is a good way of reducing the risk of this happening with your software products - people can try out and live with your products for a period before deciding to purchase.

Small software companies can add value by offering good pre and post-sales support. A small software development company can often offer better support than a larger software company. Large companies can be unresponsive to support calls or can’t hold a meaningful discussion with a potential customer. With small companies there are few barriers between the company owner and the customer. Both sides can benefit from this - the customer can make his case and get a decision quickly and the company owner has a chance to build a relationship with the customer. Building a relationship with a customer may lead to future sales, for example if you release a major upgrade of your software.

When setting a price for your software product, don’t charge so little that you are literally working for peanuts. If a business’s products are too cheap, some customers may believe that the since the company does not value their own products why should the customer.


Read Selling Online for tips on software promotion via a website.

6 Things to Consider when Selling Software Products online

If you want to sell a software product online, the obvious route is to sell via your own website. If you want to sell software this way, you need to optimise your website to make it perform well in searches.

There is no easy solution for optimising a website to get good rankings in search engine results. No quick fix or magic trick is possible that will guarantee frequent visitors to a site and convert large percentages of your visitors into paying customers. The task of optimising a website for rankings, visitors and sales is an ongoing story of continual refinement and updates.

To sell a product online, at least 6 factors need to be considered:-

  1. Do you have a product that has a reasonable market?
  2. Determine how people search for your product or type of product. Do they use Yahoo or Google, what keywords do they look for?
  3. Make sure the copy on your website emphasis the most frequently used search terms - plus long tail terms.
  4. Make sure the copy on your website emphasis the most frequently used search terms - plus long tail terms.
  5. Write the copy for your website to convince customers to buy your product.
  6. Images are also important - or at least the names of your images are.

Point 6 can be very important. Google searches images and uses the image filename. Lots of people look for example images of invoices and I get a few hundred hits a month on my website for images of invoices and invoice templates.

Long-tail search terms are very important. For example, on my main website the search terms are invoicing software, invoice software and billing software. I’ve done research and found that these are the main search terms in the US and UK for my type of product. However, these search terms account for only 15% of my visitors. The rest of my visitors come from long tail terms that may only be mentioned once in the whole website. I don’t always deliberately put long tails into the text, I just write text, e.g. in the Support page or the Release History page that simply gives a good variety of words and phrases. I also examine competitor sites to see if they have combinations of phrases that I haven't included. I don't do any keyword stuffing, I just modify an existing phrase to include the long tails.

Due to the way search engines work, the people who find your website will already be interested in your product, or at least in the problem your product helps with. My feeling is that your website should then describe the benefits your specific product offers, i.e. why using your product will make handling security easier, quicker and cheaper for users. Be as specific as possible about the benefits so the visitor can easily understand how they can take advantage of your product.

The other thing to remember is that Google Pagerank isn’t everything. Pagerank doesn’t guarantee a page gets visitors. Monitor your web stats and see if any changes produce a rise in the number of visitors. Make refinements and see what effect they have.

Also consider whether you should rely entirely on search engines to get customers. Are there alternative methods of advertising your software? Can you get resellers for your software in other countries. For my invoicing software, virtual assistants make good resellers as they do invoicing for clients and I add features to make the software more suitable for their use.

Read Sales Strategy for more information.

Sunday 8 June 2008

SliQ 1.4 Beta Test Rework Nearing the End

After almost a month in beta test/ rework, SliQ 1.4 is near complete and should be ready for release this week.

The beta testers provided excellent feedback about the usability of some of the features. This shows the benefits of good, independent, objective testing. It took some motivation to reopen the package and rework some of the features - especially the help file - but I knew the tester was making very valid points.

The new release is ready for final test again. 2 days should do it and then 1.4 will be released in stages over the next week or two.

Tuesday 6 May 2008

Make the most of Google Adwords using these 10 Tips

When I first created my website up and launched my brand new software package I had one main strategy for selling - get people to visit my site and download the trial copy of my software. Hopefully the software would then sell itself.

From talking with other people who owned websites and who had tried to do e-commerce, I knew it would take lots of work, possibly over many months, to rank well in search engine results. I was told to think about using Pay Per Click (PPC) to get going and that GoogleAds was the only service worth using. I signed up at
www.google.co.uk/adwords, wrote my first ad, started getting visitors within an hour and made sales on my first day.

It all seemed so easy - let GoogleAds do the work and sit back waiting for Paypal to tell me people had made a purchase. As the days passed though, the number of visitors clicking through to my site dropped and sales were harder to come by. As I should have expected, nothing in life is ever too easy and I should have done research upfront to optimise my Adwords campaign.

As the days rolled on, I had to up the amounts I was prepared to pay for each click in order to keep getting visitors. I was still making a profit but not much. After a couple of weeks of further research I decided I needed to rethink my whole campaign. I found these tips to be the most useful in improving my conversion rate of clicks to sales:

1. When choosing the keywords for which your ad is to appear, make sure that they are absolutely relevant to your site. I got good click through rates (CTR) for “
invoice templates” but at the time my invoicing software package didn’t include multiple templates.

2. Run multiple ads simultaneously. Try different ads to see which work best. Don’t use the same keywords in multiple ads – Google will only show 1 or the other ad and not both.

3. Avoid the word free. I got good CTR for phrases including the word free – like “free invoice software”. In hindsight this was probably a bad choice since those clicks probably weren’t from people wanting to make a purchase of any kind in the first place.

4. You can’t include many words in a single ad. Try selling different benefits in different ads to see which attracts most customers.

5. Write the ads in an attention-grabbing way, don’t just list features. For example – use Special Offer, Time Limited Offer.

6. Sell benefits as well as features – Save Time, No Special Knowledge, Easy to Use.

7. Try ads with and without the price – which works best?

8. Use Google’s free Adwords optimisation service. Look at their suggestions and see if they’ve spotted something your own ads and keywords haven’t covered.

9. Above all, monitor the performance of ads, keep tweaking and try different ads to see which works best. Give an ad a few days to see how it performs before changing it.

10. Use the knowledge you gain while monitoring your ads to optimise the content of the pages on your site and improve your performance in organic search results. Which keywords work best? Do you have pages that clearly focus on those keywords? Can you build backlinks that reinforce the keywords?

When used properly, Google Adwords is a very useful selling tool. Don’t expect to set up a single ad and keep making money however. When you use Google Adwords you are competing in a bidding war. Your competitors will be optimising their campaigns even if you aren’t. Ongoing monitoring and updating of ads is essential to continued success.

Monday 5 May 2008

Did I choose the right domain name?

A fellow software author tells me we’ve chosen the wrong domain names for the sites selling our products. He says we should have chosen domain names with the product (not company) name in them. I’ve heard this advice before and did consider it when choosing a domain name.

From my point of view, the problem with choosing a product-specific domain name is that it could reduce my options in the future. At the moment I sell one software product but within the next 6 months will be launching 2 more. If I were to have a separate domain selling each product I don’t think I’d have the time or energy to do the link-building. It’s pretty time-consuming doing link-building for one site less alone 2 or 3. On the other hand if I’d chosen a product-specific domain name to begin with, selling different products on the one, original site might not look right.

I used to think the domain name was very important but if you read around, it turns out that URLs are considered more important (and the domain is a specific case of a URL). With a good linking strategy within your site, inner pages can benefit from links to the homepage, e.g. several of my inner pages have a PR only 1 less than the homepage even though they have no links from external sites. These inner pages are often landing pages in searches. So as I sell different products and services I can create pages within my site, like:

http://www.sliqtools.co.uk/invoice-software.aspx
http://www.sliqtools.co.uk/invoice-templates.aspx

and so on.

All in all, I’m pretty happing with my choice of domain name and will continue to build links to one site and, for the time being, mostly to one page – my homepage.

SERPS outside the UK

While my site does well in SERPs in the UK, it doesn’t do well in other countries, e.g the US.

For some competitive search terms I’m on page 1 on http://www.google.co.uk/ but for the same terms in the US I’m below #500. I can also see that my competitor’s .co.uk sites are in the same position. In fact one site, which always ranks #1 for my main search terms comes in a few places lower than me in the US.

So the question is, what can I do to improve my search results? From the research I’ve done so far on the internet and by asking around, it’s been recommended I do 2 things:

1. Host my sites on a US-based server with a .com domain name.
2. Build US-based backlinks to my site.

I’m not sure I understand the first point. If I post a duplicate of my site on a US-based server won’t this be seen as duplicate content? Doesn’t Google penalise for duplicate content?

On the second point, what’s a US-based backlink? Does this mean I need backlinks from .com sites hosted on US-based servers. I can be polite when asking for a backlink but this seems like a tall order.

Need to think this one through ….

Sunday 4 May 2008

How does Web Design differ from SEO?

Modern web design tools, like Microsoft Expression Web or Dreamweaver, make the process of designing a website relatively easy. Using a template, a simple, presentable website can easily be written and posted online. However, getting a website found by people searching online involves more than just making the website look nice. Search Engine Optimisation, or SEO for short, is the activity of making a website rank well in searches on engines like Google and Yahoo.

In some ways making a website look good is of secondary importance: everyone's idea of what looks good is different and nowadays people are used to a reading a range of websites with varying degrees of artistic accomplishment or graphical design standard. What matters most is getting found in the first place and then having content that holds the visitor's interest.

A good web designer will perform both activities – making a good-looking site and making sure the site is well-optimised.

Most website designers will show you their portfolio of websites when you ask them to quote for your website. Good website designers should offer an SEO service too. Ask for examples of how well their client’s sites perform in searches.

If a designer doesn’t offer an SEO service, think twice about using their services – SEO isn’t something that can easily be performed after a website has been written and the pages are online. Ideally, a website needs to be constructed from the beginning with SEO in mind. The choice of URLs, domain names and linking strategy between pages all affect the site’s optimisation and should be planned before the website is written.

The amount of optimisation that can be performed depends on how much time and effort is put in. On-page optimisation (getting the page’s text and internal links to other pages on the same site) can be performed relatively quickly, but off-site optimisation will be an on ongoing task. Off-site optimisation mainly involves getting links from other sites. This can be a very time-consuming activity.

If good ranking in SERPs (search engine result pages) is essential to the success of your site, and you can afford to do so, hire an SEO expert. If you hire someone to do SEO work make sure they explain their techniques to you – at some point you may want to perform your own SEO. In particular, make sure your hired SEO only uses white-hat SEO techniques and will not use so-called black-hat SEO techniques that could result in Google giving your website a penalty or even banning your site in the future.

If you are looking for expert SEO advice and information, I would recommend the services of Four Square Innovations. They helped me with my website and set me on the road to ranking on page 1 of Google for my major search terms.

SoftTester: Top UK Freeware & Shareware Site

Distributing shareware is as important as writing the software in the first place – if people can’t find your software titles they can’t buy them. If your website is new and doesn’t perform well in searches on Google, the easiest way to distribute your software online is via one of the numerous shareware sites.

Shareware sites will allow you to advertise your software for free. For each title, you will be able to post a short description and the shareware site will provide a link to your installable package.

The majority of shareware sites are based in the US and are used by US customers. If your software is targeted solely for the UK, you may find that you are wasting download bandwidth from your site – since people in the US will download your package but will soon find that it isn’t appropriate for them. This happened to me with one of my software titles – I had to upgrade my hosting package to cater for the extra downloads.

One of the best freeware/ shareware sites in the UK is SoftTester. SoftTester has been established for a number of years and receives up to several thousand visitors a day.

SoftTester goes a couple of steps beyond the usual shareware site in that it tries to build communities amongst software developers, encouraging reviewing and testing of each others software.

SoftTester accepts the submissions using the standard shareware PAD file and from personal experience I can say that the site owner is very friendly and helpful to new authors.

SliQ 1.4 Screenshots

These are screenshots of the software package being tested today. SliQ 1.4 is a big update on previous versions. At first glance not much looks different, but 1.4 supports service invoices, discounts on invoices and quotes, 9 different templates in a range of colours, enhanced payment tracking, configurable currencies and taxes plus more.

This is the main Invoices & Payments screen from SliQ Invoicing and Quoting 1.4. The screen has been modified to incorporate the extra payments info.















The template setup tab. On this tab you can choose different templates for your invoices, quotes, credit notes and so on. 9 templates are supported with a range of different colour schemes. 1.4 also allows custom templates to be created for different users.















This tab allows you to enter your business details, select or specify a currency and enter the tax name and standard information like payment options.

Testing going well

Testing went well yesterday. Found few problems compared to the previous day.

All in all the new release is looking good and stable. Decided to make some last-minute cosmetic changes. Now all I need to do is update the help file before letting the beta testers loose.

I had a couple of potential customers asking about features. One needs a different invoice format. He loves the software but needs a different invoice template. It's reassuring that he liked the software enough to ask for an update rather than move on to try out someone else's package. Luckily the next version will include multiple invoice templates so I can give the customer what he wants. I emailed him PDFs from SliQ 1.4 and he OKed one of them as being suitable. Should get a sale with any luck.

Saturday 3 May 2008

Testing is hard work

Today I'm testing a major new release of software. The test/ review phase has been ongoing for about 3 weeks. We've been doing rounds of test interspersed with rounds of independent review by Sue the director.

I don't find testing very interesting. These days I find it hard to concentrate for more than 20 minutes and the temptation to tweak and improve is fairly irresistible.

If I'm lucky I'll get about 6 clear hours today to concentrate on testing. If we can clear the testing soon we should be able to release for beta test within the next fortnight.

My biggest distraction is the internet. I'd get along better if BT cut me off.

Friday 2 May 2008

5 Things to Consider Before Starting Your Own Business

Have you ever felt like starting your own business? Do you want to be your own boss? Want to get away from the day-to-day monotony of your current job and be in control of your own life? Well, if you do, there is only person who can make the difference between your new business being successful and being a disaster – you!

Before you begin your new life running a business, consider the following questions. If you can answer the questions honestly, you should be in a good position to start up a business.

Are you starting a new business or running away from something?

Don’t expect running a business to solve too many issues for you. Starting your own business may not turn out to be a route to a magically fulfilling life.
For example, did you decide to set up a business while on holiday? Many people think about changing their lives while on holiday, especially when faced with returning home and getting back into their normal work routine. Be sure that you are considering starting a business for the right reasons. Television shows many programmes about people who sold up and moved to a new life running their own business. To me, unless these people have already retired from work, they often seem to regret the move.

Be honest about the amount of effort involved

If you work in a company and things go badly or run late, you can always fall back on your colleagues or your boss to help. When you run your own business you will have to rely on yourself. This may mean working late at night and at weekends. If you work from home you may find it difficult to switch out of work mode if your office is just across the hallway. In the early days, while getting the business up and running, you may be working long hours and seeing little profit. Are you the kind of person who has the discipline and self-motivation to carry on?

Will you make a living from your business?

Most people will need to make a living from their business. Have you written a business plan and worked out exactly how much profit your chosen business will realistically make? Don’t start your assessment by thinking how much money you need to earn each month to pay the bills. If you do this you may end up “adjusting” profit figures to meet your needs.

Be honest about the likely profits. Do research. Get someone independent, in a similar business if possible, to talk through the likely costs and income. Work out your likely profit or losses in the months after you start your business. How long will it take you to make a living? How will you afford to live before the business is making a living wage?

Will you over commit yourself or your family?

When you start your own business it is likely you will end up working more hours than you did working for someone else. At the end of the day, the only person you can rely on to get the job done is you.

Consider the effect this will have on your partner or children. If you have very young children, will they understand why you can’t spend as much time with them? Will your partner understand?

Will you expect your partner, husband or wife, to help out when things get tough? Is this fair? Will they end up feeling pressured even when they have their own work commitments? Be honest with each other and discuss the possibilities before starting your business.

How many roles will you play?

If you work for a company, it’s likely – even though you may not think so – that you do only one job. When you work for yourself you will probably need to do many jobs. If you are setting up a one man business think: Who will do the marketing and advertising? Who will fulfil customer orders, e.g. by packing and posting goods? Who will deal with customer queries and complaints? All these roles require different skills. If you don’t have any experience in these areas, get training or advice and be prepared to learn quickly on the job.

Conclusion

I hope you find this list useful. The list isn’t meant to put you off starting your own business. Rather it is meant to help you make sure you are being honest with yourself about your expectations and the possible pitfalls in working for yourself. If you plan up front, running your own business can be a rewarding and satisfactory venture.