How to sign your Mac OS X App for Gatekeeper

If a prospective customer downloads your software onto Mac OS X 10.8 and it hasn’t been signed, they will see a scary warning:

Not good. To run unsigned software they need to go into Mac OS X Preferences>Security & Privacy>General and change Allow applications downloaded from Mac App store and identified developers to Anywhere:

Or they need to right/Ctrl click and see another scary warning. Double plus not good. This is the new Mac Gatekeeper system in action. Apple being Apple, Gatekeeper defaults to only allowing users to run software they have downloaded off the Internet if it has been signed. This could have a big effect on your conversion rate on Mac. So if you are shipping software for the Mac, you really need to sign it.

Apple fanboys will tell this is a sensible way for Apple to control software quality. A valid certificate shows that your software hasn’t been tampered with and, if it turns out to be malware, Apple can revoke your certificate. The more cynical might see it as a way for Apple to exert even greater control over Mac developers than it already does, while simultaneously extorting $99 per year from each and every one of them. Make your own mind up on that one.

I have now managed to sign my table planner software, ready for its next release. I should have done it months ago. But I expected the process to be so tedious that it has taken me this long to get around to it. And it was every bit as mind-numbingly tedious as I expected trying to find a few useful nuggets amongst the acres of Apple documentation. I found some useful stuff in blogs, but it was quite fragmented. So I have thrown together these notes in the hope that it saves someone else a few hours going round in circles. Note that I am not currently submitting my software to the Mac App Store, so I don’t cover that here. Also my software is developed in C++/Qt using Qt Creator, rather than Objective-C/Cocoa using XCode, and my approach reflects that.

1. Sign up for Apple Developer Connection ($99 per year). Doesn’t matter if you already paid through the nose for a Windows authenticode certificate. Gatekeeper only accepts Apple certificates, so you have no choice. On the plus side, you do get other benefits, including downloading new OS upgrades for free.

2. You need Mac OS X 10.8 so you can test that your signing works. If you have an Apple Developer Connection subscription, you can download 10.8 for free (get a code from the ADC downloads area and using it in the Mac App Store). I found the upgrade from 10.6 to 10.8 was surprisingly painless (Microsoft eat your heart out).

3. Request your Apple certificates and install them into your Keychain. You can do this from Xcode (instructions here). You may need to upgrade Xcode to a recent version.

4. Use the codesign command line tool to sign:

  • Every framework in your .app bundle
  • Every plugin in your .app bundle
  • Your .app file

I believe you can do this as part of your Xcode build. But I prefer a shell script. For example:

echo --sign frameworks --
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Frameworks/QtCore.framework/Versions/4/QtCore
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Frameworks/QtGui.framework/Versions/4/QtGui
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Frameworks/QtNetwork.framework/Versions/4/QtNetwork
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Frameworks/QtSql.framework/Versions/4/QtSql
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Frameworks/QtXml.framework/Versions/4/QtXml
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Frameworks/Qt3Support.framework/Versions/4/Qt3Support

echo --sign plugins--
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/accessible/libqtaccessiblecompatwidgets.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/accessible/libqtaccessiblewidgets.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/bearer/libqcorewlanbearer.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/bearer/libqgenericbearer.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/codecs/libqcncodecs.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/codecs/libqjpcodecs.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/codecs/libqkrcodecs.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/codecs/libqtwcodecs.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/graphicssystems/libqtracegraphicssystem.dylib
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app/Contents/Plugins/imageformats/libqjpeg.dylib

echo --sign app--
codesign --force --verify --verbose --sign "Developer ID Application: <yourID>" <yourApp>.app

I do this in a build shell script that automates the whole process of creating a .dmg for download. I’m not sure if the order you sign the components in is important.

Note that:

  • <yourID> is the ID on your certificate (in my case “Oryx Digital Ltd”).
  • For frameworks you sign the folder, not the file.
  • Any changes to the .app bundle after signing may invalidate the signature (that is kind of the point).

5. Verify the  signing of the .app file. For example:

codesign -vvv -d <yourApp>.app

6. Package your .app into a .dmg, .zip, .pkg or whatever other format you use to install it (I believe .pkg files might require additional signing with a different certificate).

7. Make sure your Mac OS X 10.8 machine is set to the default Gatekeeper setting.

8. Download your software onto Mac OS X 10.8 and check if the scary warning has gone away.

9. Pray that Apple doesn’t decide to revoke your certificate at some point for an infraction, real or imagined.

Until you have released a signed version you can put up a warning with some simple Javascript, for example:

Further reading:

http://www.hardcoded.net/devlogs/20120407

http://www.mactech.com/articles/mactech/Vol.24/24.11/CodeSigning-GetUsedtoIt!/index.html

http://www.macworld.co.uk/macsoftware/news/?newsid=3338078

http://support.apple.com/kb/HT5290

http://www.macworld.com/article/1165408/mountain_lion_hands_on_with_gatekeeper.html

http://developer.apple.com/library/mac/#documentation/ToolsLanguages/Conceptual/OSXWorkflowGuide/CodeSigning/CodeSigning.html

http://developer.apple.com/library/mac/#documentation/ToolsLanguages/Conceptual/OSXWorkflowGuide/DistributingApplicationsOutside/DistributingApplicationsOutside.html

Qt related:

http://lynxline.com/submiting-to-mac-app-store/

http://www.digia.com/en/Blogs/Qt-blog/Pasi_Matilainen/Dates/2012/4/How-to-Publish-Qt-Applications-in-the-Mac-App-Store/

http://comments.gmane.org/gmane.comp.lib.qt.user/637

Java related:

http://blogs.oracle.com/talkingjavadeployment/entry/java_applications_and_gatekeeper

http://www.ej-technologies.com/products/install4j/whatsnew51.html

Thanks to Jonathan of DeepTrawl and Stephane of LandlordMax for some useful pointers.

************** Update **************

Things have changed again for Mac OS X 10.9/10.10. See this post for an update.

33 tips for giving great technical support at a small software company without being swamped

To have the best chance of success you need a great product, great marketing and great support. Many companies with great products and marketing fall down on the support.

Good support is essential to a good user experience. Any non-trivial piece of software is going to result in questions that need to be answered and issues that need to be resolved. But supporting customers is often seen as an onerous chore. An overhead. Something to be done by those not talented enough to be developers.  This is a very unfortunate attitude. But it also an opportunity, as software companies that provide great support can really stand out from their competitors. The lower they set the bar, the more opportunity you have to shine.

The fact that the support staff and the developers are often the same people in a small company is a real strength. Because the developer knows the product better than anyone else, they can give better answers. Also, the direct feedback developers get from customers can be very helpful in further improving the product. This means that a small company can often provide much better support than a large company that has multiple layers of support between the customer and the developer. The downside is that the more time developers spend on support, the less time they can spend doing development. Eventually you may reach a level of sales where you are spending nearly all your time doing support, with very little left for the development and marketing required to grow the business. The challenge is to provide great support without being swamped by support work.

I have been supporting my own wedding table plan software since it was first released in 2005. I have managed to grow my sales for 7 consecutive years without being overwhelmed by support. In fact technical support emails have stayed at roughly 40 per week for the last few years despite increasing sales. Before that I had never really done much technical support, so it has been a learning experience. Here are some of the things I have learnt along the way.

Manage customer expectations

Make the level of support clear to the customer:

  • Is it free or does it have to be paid for?
  • Is it email only or is telephone support also available?
  • What sort of response time can they expect?
  • What languages do you provide support in – just English?

I don’t provide technical support by telephone or instant messaging, because it is too disruptive to me as a one-man-band.

Manage your own expectations

Your software is a means to an end for the customer. Very few customers will read the documentation you spent all those hours writing if they can possibly avoid it. Some of them won’t even read to the end of a 1 sentence error message (really). Some of your customers will be ‘technically’ challenged (often without even realizing). Sometimes the problem exists between keyboard and chair. Get used to it, because human nature isn’t going to change any time soon.

Make it easy for the customer to contact you

Don’t hide your support email address. Allow the customer to email you from the software itself. This also gives you the opportunity to add some useful information to the email (the software version, their OS, whether they have a licence etc).

Be responsive

Generally speaking, the faster you respond, the better. When I send an email to support I expect to get a response by the same time on the next working day and hopefully within a few hours. I try to answer my support emails at least twice a day, 364 days a year. I do this because I want to give a great service, but it also means I don’t come in to a massive pile of support emails every Monday morning. It means taking a laptop with me whenever I am away for a night. But I find it isn’t a huge chore to spend an hour a day answering support emails on holiday. Especially when I remember that the business is paying for the holiday!

But not too responsive

The downside of being very responsive is that it makes some customers lazy. If they know they will get a response within a few hours they may email you about things they could easily look up themselves. The best response to this is ‘throttling’ (NB/ I don’t mean strangling) – when you notice that a customer is being lazy, take longer and longer to respond to each email. Eventually they will take the hint.

If you are trying to look like a bigger company than you are, then you probably don’t want to answer support emails outside of normal work hours.

Respond as clearly as possible

  • Quote the customers email in your reply where appropriate for context.
  • Number step-by-step instructions.
  • Use quotes to refer to elements in your software, e.g. select ‘Help’>’About’ from the main menu.
  • Write in short paragraphs, not big chunks of text.
  • Avoid technical jargon unless you are sure that your customer will understand. For example, say “window” rather than “modal dialog”.
  • Use proper grammar and check the spelling.
  • Avoid long email signatures.

Use images and videos

It is often helpful to include an annotated image with your response. For example you can do a screenshot, highlight important items in the screenshot and then email this as an attachment, along with some text. I find the screen capture tool SnagIt is excellent for doing this (available for both Windows and Mac). In some cases it may also be worth doing a short screencast, uploading it and then sending the customer a link (SnagIt can also do this).

Restate unclear questions

Support questions can be very vague. I have even had people email me just “It doesn’t work” – it wasn’t even clear whether they were referring to the website, the installer or the software. It often takes a few emails to understand what the problem is. If you aren’t 100% sure what they mean, make your best guess at what they are trying to say and restate it in your own words followed by “Did I understand correctly?”. Ask them if there are any error messages. Ask them to send you a screenshot (include a link to instructions on how to do this).

Finish an email exchange

If the customer started the exchange, you should generally finish it (i.e. send the last email). But it is probably not worth responding to an email that is just a 1-line thank you.

Pick up the phone when required

Even if you don’t officially offer telephone support, it sometimes can sometimes save a lot of time and aggravation on both sides if you pick up the phone and talk to the customer.

Put your documentation online

If you have your documentation online you can easily include links to relevant pages in your documentation in your email. This might also encourage the customer to look in the documentation first next time. But don’t just send a link. Answer their question in the email and then include the link as supplemental information.

Help the customers to help themselves

The beauty of a software product business is scalability. In theory, you only need to create your product once and then you can sell it to as many people as you can convince to buy it with negligible marginal cost. In theory. In reality, while a software product business is inherently much more scalable than a consulting business, the marginal cost per sale is not negligible. Far from it. Customers need support.  Here are some of the way you can reduce the support cost per customer:

  • improve the user interface and documentation, based on customer feedback
  • add an FAQ
  • allow customers to retrieve their licence key direct from your website (emailed to the registered email address, for obvious reasons)
  • encourage customers to look at documentation, FAQs, forums etc before emailing you (below is the window I show when customers select Help>Technical support in PerfectTablePlan).

Note that it has been shown experimentally that the more text you show someone, the lower the percentage of it they read. So it is generally more productive to concentrate on simplifying the user interface, rather than writing more documentation.

Of course, you can also reduce support requests by making it difficult for the customer to contact you (the Amazon model). But this leads to less feedback and a worse user experience, so I wouldn’t recommend it.

Allow customers to help each other

If you have a sizeable user base you can set-up a forum to encourage users to help each other. This can have various benefits:

  • customers may be able to get answers straight-away by searching existing content on the forum
  • customers may answer some questions for you
  • customers may respond faster than you can
  • it increases your SEO footprint

But it also has its drawbacks:

  • nothing looks sadder than a deserted forum
  • a forum has to be actively moderated or it will end up reflecting badly on your company
  • spam can be a problem

Automatically report crashes

It is often possible to detect that the software is going to crash or has crashed and send yourself some diagnostic information. This allows you to monitor how stable the software is and gives you some clues for debugging. For example, on Windows you can use the Win32 API method SetUnhandledExceptionFilter() to detect when things have gone horribly wrong. Don’t send it without their permission though. Give them the option to see the information you are going to send and then allow them to send it with a single button click.

Remember that every computer is different

There is a rumour that there are 2 identically configured PCs somewhere in Nebraska. But I don’t believe it. The customer may have configured their OS with all sorts of strange options you have never heard of. Anti-virus software, malware, DLL hell and hardware issues can cause problems. A cosmic ray might have even passed through their RAM! So I generally don’t spend too much time on a bug report unless either I can replicate it myself or 2 separate people have reported it.

Be proactive

I actively seek feedback from my customers. It increases the support burden somewhat, but I think this is more than compensated for by increased customer satisfaction and improved feedback.

Make use of feedback

I think all developers should spend at least some time supporting the products they developed. A few days every now and then in the support trenches answering customer emails and phone calls would give developers a better appreciation of how customers think and of the real costs of that cool feature shoe-horned into the release a week before the ship date.

Look at every support request as a possible way to improve your product. The first time you get a support request you answer it. The second time you get the same request you need to start thinking about how you can improve the product so that question doesn’t get asked a third time. By continually improving your product in this way you can greatly reduce the average amount of support time required per customer over time. Obviously you need to make it easy for customers to contact you to make this work.

Don’t take things personally

No matter how hard you try some people are not going to like your software. I once got so angry with Microsoft Project that I nearly threw a monitor out of a window. An angry customer might send you an angry email. Try not to take the criticism personally (link note: funny, but sweary). Maybe the customer is having a bad day. Perhaps they just don’t have any manners. As long as they remain a small minority, try not to lose any sleep over it. On the plus side – at least they cared! And it is often possible to turn a passionately angry customer into a passionate advocate for the product. Indifference is much harder to convert into a sale.

Don’t shoot the messenger

If someone reports what they think is a bug, you should thank them, rather than taking it as an insult to your programming skills. Experience shows me that most people who encounter a bug won’t bother to report it. If you have ever tried reporting a problem to a big company like Microsoft, you will understand why. An unreported bug can result in a lot of unhappy customers and lost sales. Customers who report bugs are a precious resource and should be treated accordingly.

Tell a customer when you have fixed their bug

Whenever a customer reports a bug  I record their email address along with the bug report. When it is fixed I then email them. This encourages them to report other bugs they find in future. Similarly for feature requests.

Give credit where credit is due

When I list bugs fixed in a release I also give the names of the customers who reported the bugs (first name + initial of last name). If a customer has been particularly helpful, e.g. putting significant effort into helping me find a bug, I may also list them in the software ‘credits’ window. It doesn’t cost me anything and it encourages these customers to feel more ownership of the product and report more bugs.

Google translate is your friend

I only officially provide support in English. But if someone emails me in another language I will use Google translate to read their email and reply in English, including a translation of my reply from Google translate. The quality of the translation may not be great, but it is probably good enough.

Use the right tone

Being professional doesn’t have to mean cold and impersonal. Try to sound like a real person, rather than a robot. Include your name in your signature. I address people by their first name (where known) and I’m not above including a smiley, where I think it is appropriate. Different markets and cultures may demand different levels of formality. Usually you can take your cue from how formal the customer is. Above all, try not to blame your customer or make them feel stupid.

Only support your own product

It isn’t your job to teach your customer how to use a computer. Try to steer clear of providing support that isn’t directly related to your own product. Otherwise you might find you end up as their general IT helpdesk.

Get the price right

If you are swamped in support emails, consider raising your price. Depending on the price elasticity of your product, you may be  able to generate the same or more revenue with less customers and therefore (hopefully) less support emails.

Firing a customer is the final resort

Sometimes a customer will buy your product when they really shouldn’t have, either because it is the wrong tool for the job or because they don’t have the skills required to use it. They will then bombard you with email after email. In such cases it may be best to refund them. Allow them to keep using the software, but tell them that you won’t be able to provide any further support. Something along the lines of “It appears that our software is not a good fit for your requirements. We have therefore refunded your purchase in full. Please feel free to keep using the software, but please note that we won’t be able to provide further technical support.”. This is the nuclear option. I have only had to resort to it a handful of times in 7 years.

Don’t tolerate abusive customers

The customer is not always right. Buying your product does not give them a right to be abusive, no matter how much they paid. Politely and professionally fire them if they can’t behave like a decent human being.

Never send an email in anger

People can sometimes be unreasonable, even downright rude, especially when they are safely at the other end of an Internet connection. But never, under any circumstances, respond with a rude or sarcastic email. Your email might be posted onto forums for all the world to see, forever more, devoid of its original context. Not good. Also, sending a rude response is only going to pour petrol on the fire. Always keep your emails polite and professional. If you find yourself getting angry, go and do something else for a while, until you can send a calm reply. If you can’t reply professionally, don’t reply at all.

Use the right tools

You don’t need a lot of tools to provide good support. I mainly use:

  • an email client (Thunderbird)
  • a bug/feature request tracking database (OnTime)
  • a screen capture tool (SnagIt)
  • a phrase expander for quickly typing common phrases (PhraseExpander)
  • a database of licence keys (home rolled)
  • VM software for emulating different operating systems (WMWare Workstation)

As I am the only one doing support I find that it is sufficient for me to use my Thunderbird email client to check previous correspondence (search by email address), track status (using different coloured tags for: awaiting their response, follow-up later etc) and enforce a simple workflow (move to different folders). If you have multiple people doing support you may also need helpdesk software (such as Helpspot) and/or a ticketing system.

You can use remote access software such as CoPilot to remotely log in to a customers computer. But I try to avoid this where possible, as it is time consuming and also the customer might blame me for any problem they have with their computer afterwards (e.g. a virus infection).

Think twice before outsourcing support

It is cheap to outsource your support to e-workers in developing countries. But they won’t know or care about your product as much as you do. And moving yourself further away from the customer reduces that all important feedback that you need to keep improving the product.

Time new releases carefully

You are going to get the most support emails after you put out a new release. So try to avoid putting out a new release just before you go on holiday.

Have the right attitude

While it can be frustrating to provide support to someone less technically minded than yourself, remember that not everyone is a computer geek and these people are paying your salary.

Remember the golden rule

The basic rule of technical support is to treat your customers how you would wish to be treated. If you bear that in mind, you shouldn’t go far wrong.

Further reading:

If You Want to Write Useful Software, You Have to Do Tech Support (Nick Bradbury)

Did I miss anything? What have been your experiences supporting your software? What surprised you?

Monetization: Ads vs Toolbars vs Charging

I believe that the best way for most small software vendors to make money off their software is to charge for it. So I was interested to spot a post on BOS by someone who had tried ads, toolbars and charging to monetize the same piece of software. He kindly agreed to share his experience anonymously. Obviously it is only one data point, but the results are pretty unequivocal.

I developed a freeware program six or seven years ago. A piece of utility software, for either home or business use, in an extremely crowded and competitive niche. The downloads grew organically and settled into what they are now, around 30,000-40,000 per month. I’ve never used any paid advertising, but have always had a forum and been responsive to user queries. That, coupled with regular updates, built the software a fairly loyal user base.

My original idea was to make money by attracting visitors to the website and using Google Ads. This isn’t generally done on software sites, but it kind of worked for me (I still had a day job though). Eventually it was making one or two thousand dollars per month. I experimented with toolbar installer offers – Bing for the US and UK, Ask for the rest of the world. The revenue wasn’t too bad, but the ads made more.

Eventually I decided to try selling a ‘Pro’ version of the software, with even more features. I planned to keep the free version as a ‘gateway’. Note the free version still has more features than non-free competitors. It took about 6 months to write (evenings and weekends), and was finally released (with no marketing, apart from the website) in Jan 2012.

As you can see, from the first full month the sales revenue brought in ten times what the toolbar did. I wound down the site ads, and eventually removed the toolbar (you can see the revenue tail off in the chart).

I quit the day job!

See also:

Selling software vs selling eyeballs

Farewell to software on CD?

I currently offer a CD as an optional extra when customers buy my wedding table plan software. I have put stamps on so many CD envelopes that I might instinctively lick the Queen’s face if I ever met her. The graph below shows the % of sales that have included a CD over time.

% CD sales

The overall trend is hard to miss. Some factors have varied over that time:

  • I have stopped CD sales for periods of a few weeks at a time, e.g. near a new release.
  • I have emphasized CDs less over time on my purchase page.

But I don’t think these have had much effect on the general trend. Download speeds are always increasing and customers are getting used to buying downloads instead of physical media. Anyone with a broadband connection can now download PerfectTablePlan in a minute or two. The demise of CDs is hardly ground breaking  news, but I thought it might be worthwhile to show some real data.

I won’t really miss CDs. They are an extra hassle to organize and the profit margins are slim and decreasing. I didn’t want to use the ugly looking CDs in a cardboard mailer that print-on-demand CD companies offer. I didn’t really feel it reflected well on the quality of my software. Particularly in the wedding market, where aesthetics are important. Instead I send a full colour silk screen printed CD, in a DVD box with a professionally designed, full colour wrap and insert.

I order the CDs and packaging in batches of a thousand and burn and post them as required. I have managed to delegate quite a bit of this to a family member. But it is still a fair amount of hassle. CDs go missing in the post or get eaten by dogs. Also the UK post office recently hiked the cost of sending a CD + DVD case in a Jiffy bag by airmail from £2.10 to £3.86. A monstrous overnight price increase of 84%. But I don’t feel I can increase the CD price much above the current £7/$10 when you can buy game and film DVDs for less in the supermarket. The only plus side of CDs is that my data shows that customers that order a CD are 3 times less likely to ask for a refund (my terms stipulate that they have to return the CD). Given that refund requests are low, this isn’t a huge advantage. Also (repeat after me) correlation does not imply causation.

I might run an A/B test to see if removing CDs from the purchase page makes any difference. But, given that only around 3% of customers are now buying a CD, I can’t see it making much difference. If I was starting a new product now, I don’t think I would even bother to offer a CD option, unless the download size was huge.

Am I the only one still sending out CDs?

An experiment with Pinterest

Pinterest is the latest darling on the social media scene. Pinterest reportedly hit ten million monthly unique visitors faster than any other website. It is currently claimed to have some 15 million users. Basically it allows you assemble (‘pin’) images from anywhere on the web into themed folders (‘pinboards’). You can download browser plug-ins that allow you to pin an image from a website to one of your pinboards in a few clicks. The social element comes from ‘following’ other Pinterest users and commenting on and re-pinning their images. It is a simple idea slickly executed. The emphasis on images makes it rather different to Facebook, Twitter and other social media brands.

83% of US users of Pinterest are women and typical pinboard themes include:  fashion, funny images of cats, interior design, places to visit, food and wedding ideas. Check the Pinterest home page to see a sample of images currently being pinned. The interest in weddings is particularly relevant to me as I sell wedding seating planner software. So I started to create some wedding reception themed pinboards as an experiment. I quickly decided that scouring the web for pictures of pretty seating charts, place cards  and wedding cakes wasn’t a) a good use of my time b) the right thing for a 46 year old heterosexual man to be doing (GRRR!). So, using outsourcing site odesk.com, I found a nice lady in the Philippines to do it for me for a very reasonable hourly rate. She also (unsurprisingly) proved to have much better taste than me. I think she also really quite enjoyed herself! The resulting Pinterest pinboard is at http://pinterest.com/tableplan/.

Here is some data from my little experiment:

Cost: approx $50, plus a few hours of my time
Total ‘pins’ to date: 551
Clickthroughs to http://www.perfecttableplan.com/: 154
Avg time on site: 0:42
Bounce rate: 75%
Traceable sales (from analytics and cookie tracking): 0

So that works out >$0.30 per click for not very targeted traffic (as shown by the bounce rate and avg time on site) and not a single sale. Not very encouraging. What’s worse, it only generated traffic while new pins were being added. As soon as new pins were no longer being added the clickthroughs fell off a cliff:

I may get some SEO benefit. But Pinterest isn’t looking a like a win for me. Also there are issues with Pinterest terms and general IP issues. Pinterest’s terms originally claimed that they could sell anything you pinned. They have since amended that to something more sensible. But pinning images you don’t own the copyright to is still problematic. I think most sites will be happy for people to pin their images, as long as they are correctly attributed – it is free advertising for them.  And it is obvious that most Pinterest users are happily pinning images without any thought about copyright. But it could conceivably get you into trouble for copyright infringement.

If you are a big name company with a big marketing budget, it may be worth putting some effort into Pinterest. Especially if you already have a big catalogue of images you own. But, based on my experiences, I think most small software companies can find better ways to spend their time.

Competition

Centurion tankA couple of years ago I got to drive a Centurian tank. 50 tons of clanking, smoke belching, killing machine. I can only imagine how terrifying it must be for an infantry man up against one of these heavily armed and armoured monsters. But, quite unexpectedly, I felt very vulnerable in the tank. My top lip was exactly level with a big spike of metal that formed part of the drivers hatch – if we had stopped suddenly I would probably have lost teeth. I could hardly move without bashing a knee or elbow on something hard. It was so noisy I could barely hear the shouting of the instructor, perched on the front of the tank only a few feet away. And, with my eyes only a few inches above the hatch, the visibility was poor. The tank was also very hard to drive, requiring an odd mix of finesse and brute strength. Just changing gear is quite an accomplishment for the inexperienced. I also got to sit inside some Russian tanks of more recent vintage and their ergonomics were even more nightmarish. Being inside one of these things on a battlefield, full of fuel and ammunition, a prime target for every enemy tank, aircraft and gun, must have been terrifying. It was a lesson that, what appears as invincible strength from the outside might feel very different from the inside.

  • Your competitor has more staff than you? That means that they have got to make more sales to turn a profit and they spend a lot more time in meetings.
  • Your competitor is better funded than you? That means they are spending more of their precious time and energy dealing with investors.
  • Your competitor’s product has more features than yours? Their product is probably more complex to use than yours.
  • Your competitor is using trendier technology than you? That probably also means they have a lot more third party bugs and issues to deal with.
  • Your competitor is based in a trendy location with better access to talent? That probably means they have to pay higher salaries and office rental and are more likely to get their staff poached.

Strength and weakness can be just two sides of the same coin.

I keep a vague eye on competition to my own table planning software. Over time I have built up a list of over 100 other products whose functionality competes directly with mine or overlaps significantly. New competitors appear fairly regularly. I notice that their website might look a bit more “web 2.0” than mine or their price is cheaper and my heart sinks a little. But, so far, it has never made a noticeable impact on my sales and I quickly forget about them. In fact my sales have gone up every year in the 7 years since I first released PerfectTablePlan. I just keep improving the product, marketing and support, day after day, year after year. While many of these competitors have since fallen by the wayside, with products and websites not updated for several years. Some of them are giving away their products free in the hope of making a few pennies from advertising. Some of them never even launched. Those that are still active are targeting rather different niches to my software.

Many companies respond to competition by trying to copy their competitors feature for feature. This is almost certainly a mistake. You will always be at least one step behind them. It is much better to listen to your customers and innovate. It is certainly a lot more interesting and rewarding. It is also much easier to market a product that is different[1].

There are cases where competitors can be a big problem, for example:

  • markets where there is a strong network effect (I wouldn’t want to compete head on with Ebay or Facebook)
  • markets where you might have to compete with the company that owns the platform (for example a Microsoft Office add-on isn’t likely to last long if Microsoft releases a new version of Office incorporating this feature)

So it is probably better to avoid these types of market, unless you are happy to accept that level of risk. But there are vast numbers of markets big enough to support multiple products. There are some 2 billion people with access to the Internet and they all have different requirements. Even a niche within a niche can provide a decent living for a small software business.

Competition can actually help you. The main competition for my table planning software is Excel and Post-It notes, not other table planning software. My competitors are helping to raise awareness of the fact that there is such a thing as software for table planning. Some of the people whose awareness they raise, are going to search for other software solutions and find and buy my software (thanks!).

So next time you find out about a new competitor, don’t panic. It is natural to focus on their strengths and your weaknesses, rather than your strengths and their weaknesses[2]. But they are probably doing the same, and they may be more afraid of you than you are of them.

In truth your biggest fear should be having no competition. If there is a no-one else doing what you are doing then either you are genius who has found an untapped market or the market doesn’t exist. Unfortunately, it is almost certainly the latter.

Further reading:

‘Choose your competition’ by Eric Sink

[1]This is why adverts for commodity products such as instant coffee and soap powders are so consistently awful.

[2] Microsoft should take note before they ruin a product with 90% of the highly lucrative desktop operating system market in their panic to compete with Apple in the tablet market.

Photo by Alistair Joseph.

TestLab² offer

The blog is being sponsored this month by TestLab², a software testing and QA company based in the Ukraine. I have used TestLab² on a number of occasions for third party testing of PerfectTablePlan releases on both Windows and Mac OS X. They found a number of bugs that I hadn’t been able to find on my own (testing your own software is always problematic) and gave me additional confidence that I hadn’t let any embarrassing bugs make it through into the final binaries. Their prices are very reasonable (from $20/hour) and I have always found them to be very professional and responsive (see my previous write-up on outsourcing testing). They also have access to operating systems that I don’t have set-up, e.g. Windows 8 and Mac OS X 10.8.

Special offer

Quote “successful software” when you ask for an estimate and they will give you a 20% discount. This offer is valid for first-time customers, for the next 14 days only.

TestLab².com website

The microISV test

Ok, so you’ve set yourself up as a one man software company and you’ve made some sales. But are you a real microISV/micropreneur/indie/startup? Take the test below and find out.

  1. You checked the number of sales you made overnight before you had your breakfast this morning.
  2. You measure the price of desirable objects (cars, houses, Xboxes) in terms of the number of licences you need to sell.
  3. You’ve outsourced some work to someone with no idea what they look like and only a vague idea where they live.
  4. When booking a hotel you are more interested in how good the Internet connection is than how good the restaurant is.
  5. Your product has at least 20 five star awards from download sites.
  6. You know what CTR, CPC and CPM mean.
  7. You have begged all your friends and family to ‘like’ your product’s Facebook page.
  8. You set up your computer or phone so it makes a special noise each time you get a sale.
  9. Your software has been cracked at least once.
  10. You have suggested to a particularly problematic customer that one of your competitors might have a more suitable product.
  11. You’ve done technical support while wearing a dressing gown/bathrobe (or less).
  12. You have Google alerts and Twitter searches set up for your product name.
  13. You start to get anxious after not checking your email for more than half a day.
  14. The last time you set an alarm clock it was because you were going on holiday and didn’t want to miss the flight.
  15. Your relatives think you don’t have a ‘real job’.
  16. You own at least 10 domain names.
  17. You have had to fix problems with your software or website while on holiday.
  18. You have had a least one chargeback.
  19. Your software has been flagged as malware by at least one anti-virus package.
  20. You use at least 3 different email addresses in the course of a day.
  21. You have explained what you do to someone and they said “And you make a living from that???”.
  22. You have used Google translate to answer a support email in a language you don’t understand.
  23. You use “we” when talking about your company, even though its really only you.
  24. Someone told you a half-baked idea they had in the shower that morning and said they would be willing to give you 50% of the profit if you did 100% of the work to  implement it.
  25. The last time you wore a suit and tie was to a wedding or a funeral.

I scored 25/25, of course (it’s my test). How did you do? Are there any other questions I should have added? Let me know in the comments.

Thanks to fellow microISVs Steph, Oliver, Terrell, Clay and Ian for suggesting some of the above.

A curated list of 200 articles for microISVs and startups

I have been steadily adding to the curated list of links on this site. Currently there are links to 200 articles, loosely categorized into topics such as ecommerce, market research, product naming, Pay Per Click and SEO. I have tried to select articles that contain ‘actionable’ information, rather than wafflely articles about ill-defined subjects such as time management and motivation. Some of the articles linked to were written by me, but the majority weren’t. I hope you find something useful. I would be surprised if you don’t.

Go to the links page

Pivot Tables demystified

pivot tablesOnline businesses generate a lot of data. Sales data, marketing data, traffic data etc. Pivot tables can be a useful tool for analysing and extracting useful information from this sea of data. A lot of people seem to have heard of Pivot Tables without understanding what they are or how to use them. Despite the slightly cryptic name they are really just a way of summarizing tables of data. Nothing to be intimidated by. I’m going to try to demystify them here with a simple example.

Let’s imagine you have got an Excel spreadsheet with a month of (fictitious) sales transaction. It looks like this:

sales spreadsheet

You want to find out:

  1. The total value of sales of each product
  2. The number of sales of each product
  3. The total value of sales of each product by country
  4. The total value of sales of each product by day of the week

How would you do it? You can crunch the numbers using a calculator, but that is very tedious and error prone. If you are a programmer you can export the data to a .csv file and write a small program in your favourite language to read it in, crunch the data and write the results out. You probably think you can do it in 10 minutes, but I bet it will take you at least an hour to get it working and debugged. I did all the above in 1 minute and 20 seconds using Excel pivot tables.

Here is how you can do it (screenshots from Excel 2007). You can download the spreadsheet if you want to try it yourself.

Select all the data, including the header (A1 to D222).

Click on Insert in the Excel Ribbon bar.

Click on PivotTable.

pivot table 1

The Create Pivot Table window will appear. Click OK.

pivot table 2

The PivotTable Field List will appear. We want to find the number of sales for each product. Drag the product field to Column labels and the value field to Values. This gives us the total value of sales by product.

pivot table 3

To change this to the number of sales pull down the Sum of value drop-down list and select Value Field Settings….

pivot table 4

Change Summarize value field by from Sum to Count and click OK.

pivot table 5

The number of sales of each product are now shown.

pivot table 6

Now drag the country field to Row labels. Then click on Count of value, select Value Field Settings…, change it back to Sum and click OK. The total value of sales of each product by country is now displayed.

pivot table 7

We now need to add a day of the week column. Click on Sheet 1 and add a new column as shown.

pivot table 8

Now select all the data from A1 to E222 and insert a new pivot table, as before.

pivot table 9

Drag the fields as shown to get the total value of sales of each product by day of the week.

pivot table 10

(We’ll quietly ignore the fact that the number of days aren’t divisible by 7 in the data.)

We can even display by product, day of the week and country with one more drag.

pivot table 11

Excel also supports pivot charts if you prefer your results in graphical form.

pivot chart

Obviously this is a very simple example, but pivot tables can be used to quickly analyse much larger and more complex data sets. Next time you have got some data to analyse consider whether you would be better using pivot tables or pivot charts.

*** UPDATE ***

You can also use my Hyper Plan software to create pivot tables. It is a lot simpler than the above! There is a free trial.