Sell More Games

Last two months has been really busy and I haven’t put much attention to advertising. Actually, I haven’t done it at all. Until yesterday.

I hate advertising because I always feel like the only one that earns money is the Ad Server.  Even if clicks or impressions are not soo expensive it is hard to turn them into profits. Why? Games are either too cheap or too expensive.

But I read a book about AdWords and it gave me some inspiration. I also noticed that Pony World has quite good visitor to download ratio - over 40% of visitors download the game. With that ratio maybe it will not to that hard to turn AdWords into profits?

I created two ad variations for selected keywords and set up a daily budget of a little over $10. And today I got the results (that’s what I love about AdWords - almost instant results).

My ads received 90 clicks total: 51 for ad variation #1and 39 for ad variation #2. CTR for those ads: 1.55% for #1 and 1.22% for #2. Not so bad,  especially one you show it by keywords: the best CTR is 10.38% and the lowest one is 0.77%. The lowest one represents most of impressions and clicks.

Because that’s just 90 clicks I don’t know if it’s profitable yet or not, but we can do some estimations. Let’s go to Google Analytics and check if those clickers download the game. This is where we face first disappointment. Only 19.48% of clickers downloads the game. It’s still much better than what I had for Runes of Avalon campaign where only 11% of visitors downloaded the game.

If Pony World Deluxe has 1% CR (download to sale) then I need 100 downloads to sell one game. And I need 513 clicks to get 100 downloads. 513 clicks will cost me over $68. And I get only $17 out of each sale, so each sale makes me a loss of $51.

Judging just by those numbers you can for sure say that advertising is a waste of money. And it is if you do it wrong. It is if you aim short term. It is if you don’t tweak your ads, your game and your game description web page. It is if you don’t increase your visitor value.

It takes time to turn advertising into profits. Most people are not patient enough.

I made some tweaks to my ads and will do for at least few more days. If I can see improvements then I’ll keep advertising until I make a profit or run out of money :D

I check Google Analytics every day. I want to know what’s happening. The good thing about GA is that they update it daily (just daily), so you can’t get too addicted.

Today, for the first time my site conversion was over 1%. Site, not game. That means that 1 of each 100 visitors, not downloaders bought a game from my site, or actually… bought one of my games, since I don’t track affiliate sales in GA.

1.01% site conversion is an average for last 30 days (little update, next day it went up to 1.05%). You can see on the graph it peaks to as high as 2%. Unfortunately there are still days where I sell nothing.

The good thing is that site conversion was not correlated with number of visitors. It means that even in peak times those were quality visits. Obviously, site conversion is correlated with your games conversion. So the better your games convert, the better your site converts.

Interesting peaks
April 1st, Tuesday - 2.17% - well, that was April Fools day - I don’t know if that’s just coincidence but I posted a joke on that day that prices for all my games will rise 10x next day :)

March 23rd, Sunday - 1.96% - I send out newsletters on March 20th

April 4th, Friday - 1.75%

April 8th, Sunday - 1.58%

March 16th, Sunday - 1.39% - well, Sunday is just the day for buying stuff online.

While Sundays have usually high conversion rates it doesn’t mean that I have highest volume of sales on this day. The most busy day is usually Saturday.

You can have Google Analytics anabled and working great, but if your e-commerce service is located on 3rd party domain, then you lose a lot of important informations, such as referral site, visits to purchase, days to purchase, etc. If you use the trick described below you will be able to track all this useful informations. I made it to work with eSellerate, but I am sure it can be done with Plimus, BMT and other e-commerce providers.

First of all, all your buy now links have to call a script that will save Google Analytics cookies to database. To match visitors with cookies we will use visitor IP. The script that will set the cookies on e-commerce domain will delete database entry right after retrieving it. It is not a perfect solution, but it will work in 99.999% (how many orders do you expect placed within few seconds from the same IP?). So instaed of calling:

store.esellerate.net/s.asp?s=STR4587075495&Cmd=BUY&SKURefnum=SKU41198308198

you call

www.yourdamain.com/buy/mygame.php

Mygame.php has to include save_GA_cookies.php script and then redirect to real e-commerce address. save_GA_cookies.php script looks like this:

<?
// this script should be called before you redirect to e-commerce shopping cart
// it saves Google Analytics cookies to database along with User IP

// include your database engine
include(”db.php”)

$dbga = new clsDBAnawiki();$IP = $_ENV['REMOTE_ADDR'];

$utma = mysql_escape_string($_COOKIE['__utma']);
$utmb = mysql_escape_string($_COOKIE['__utmb']);
$utmc = mysql_escape_string($_COOKIE['__utmc']);
$utmx = mysql_escape_string($_COOKIE['__utmx']);
$utmz = mysql_escape_string($_COOKIE['__utmz']);
$utmv = mysql_escape_string($_COOKIE['__utmv']);
$utmk = mysql_escape_string($_COOKIE['__utmk']);

$dbga->query(”INSERT INTO an_ga_cookies(ga_ip, ga_utma, ga_utmb, ga_utmc, ga_utmx, ga_utmz, ga_utmv, ga_utmk) VALUES(’$IP’, ‘$utma’, ‘$utmb’, ‘$utmc’, ‘$utmx’, ‘$utmz’, ‘$utmv’, ‘$utmk’)”);
$dbga->close();

?>

Then you need to insert into your e-commerce html template following line:

<script TYPE=”text/javascript” src=”https://www.yourSSLdomain.com/buy/set_GA_cookies.php” mce_src=”https://www.yourSSLdomain.com/buy/set_GA_cookies.php”>
</script>

set_GA_cookies.php reads GA cookies from database and sets them on e-commerce domain via JavaScript. The problem is that you need a SSL domain address otherwise your shopping cart will show unsecure site message. The good news is that this domain doesn’t have to be on your server or your own domain, though you will need to tweak my code to make it work on 3rd party server.

Here is the code for set_GA_cookies.php:

<?
// script generates JavaScript code that sets Google Analytic cookies on eSellerate.net

// include your own database library
include(”db.php”);

$IP = $_ENV['REMOTE_ADDR'];
$db = new DB();

$db->query(”SELECT * FROM an_ga_cookies WHERE ga_ip=’$IP’ LIMIT 0, 1″);

$jscode = ”;
while ($db->next_record()) {
$utma = $db->f(’ga_utma’);
$utmb = $db->f(’ga_utmb’);
$utmc = $db->f(’ga_utmc’);
$utmx = $db->f(’ga_utmx’);
$utmz = $db->f(’ga_utmz’);
$utmv = $db->f(’ga_utmv’);
$utmk = $db->f(’ga_utmk’);
$id = $db->f(’ga_id’);

$jscode = “setCookie(’__utma’, ‘”.htmlspecialchars($utma).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;
$jscode .= “setCookie(’__utmb’, ‘”.htmlspecialchars($utmb).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;
$jscode .= “setCookie(’__utmc’, ‘”.htmlspecialchars($utmc).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;
$jscode .= “setCookie(’__utmx’, ‘”.htmlspecialchars($utmx).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;
$jscode .= “setCookie(’__utmz’, ‘”.htmlspecialchars($utmz).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;
$jscode .= “setCookie(’__utmv’, ‘”.htmlspecialchars($utmv).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;
$jscode .= “setCookie(’__utmk’, ‘”.htmlspecialchars($utmk).”‘, 30, ‘/’, ‘.esellerate.net’, false) \n”;

}

if (!empty($id)) $db->query(”DELETE FROM an_ga_cookies WHERE ga_id=$id”);

?>

function setCookie(name, value, expires, path, domain, secure){
document.cookie=name+’='+unescape(value||”)+
(expires?’;expires=’+new Date(+new Date()+expires*864e5).toGMTString():”)+
(path?’;path=’+path:”)+
(domain?’;domain=’+domain:”)+
(secure?’;secure’:”);
}
<? echo $jscode; ?>

That’s it. I used PHP, but you can use any other web language to do that. Commands are self-explanatory, so I am sure you’ll be fine. Just in case you don’t want to copy the code from this page you can download zipped scripts.

If you want to get more complete image about your website you need to know how well your site is converting. It was designed with a specific goal in mind, be it game download, game purchase or filling up newsletter form. Google Analytics can help you track goal conversion rate.

For a website dedicated to games I advise to setup two goals: game download and game purchase. Those two are the most important goals your site should be aimed for. You need to maximize number of downloads per visitor and your games should maximize number of purchases.

If your Google Analytics account is set up and working you can proceed to setup goals. Click Edit link in Settings column. In the second table you will be able to setup up to 4 goals. Click edit on G1.

You will need to enter goal information: Goal URL and Goal Name. URL is important. Google uses it to determine whether the goal was achieved or not. If you enter wrong URL, your goal will not be tracked. Goal name is not that important, but keep it meaningful.

If you want G1 to track downloads you can skip funnel section completely. If you track purchases you can enter URL of all steps that are necessairy to complete order, like enter billing informations, credit card data, etc. You will be able to check where people abondon purchase process.

In additional settings you can set 3 important parameters:
- case sensitive - check it if your URL is case sensitive
- match type - there are 3 options: exact match, head match and regular expression match
- goal value - if you know average CR for games on your site you can enter ie. $0.2 (1% CR and $20 games). You can set it to 0 if you plan to track orders in G2

Match type is the trickiest one. First of all, to make it work, you need a page your game is downloading that will redirect to a certain binary file. On this page you need to put Google Analytics code. And last but not least, if you want to track all downloads, you better put that page in subfolder download and choose regular expression match. Enter /download/ as Goal URL. Otherwise if you enter URL without or with www. one of this URL’s will not be tracked.

As I mentioned in one of my previous articles, tracking orders is not so easy. First of all, you need to put Google Analytics code on your invoice page. If you are using eSellerate, you are lucky. eSellerate is kind enough to setup this on request. I don’t know if other e-commerce providers can assist you with it, but their help would let you not only track number of transactions, but also order value and quantity of purchased products (and even more, like average order value, site conversion rate, revenue per medium, etc.).

If you want to track revenue per medium (referrals), then you need to do one more thing. You need to pass Google Analytics cookies to third-party domain, which is your e-commerce providers domain. Due to security restrictions, you cannot do it from your own domain. I use set of php scripts that redirect visitors to eSellerate shopping cart. If you don’t use such scripts, you better start using them. I modified those scripts to fetch Google Analytics cookies and save them into database along with visitor IP. Then, when shopping cart loads into browser, it calls another php script on my page that writes JavaScript code to setup cookies on eSellerate domain. It sound complicated, but it’s not that hard. In next article I’ll post PHP code that does it all.

Once you get some orders you’ll be able to see a lot of great informations about your website. But having information is just the beggining, what you do with it is the key to your success.

Tracking your visitors is very important. If you don’t know who is visiting your site, where is coming from or what are your most popular pages then you are not able to improve your website. What is even worse, you don’t know if a change on your website has a positive or negative impact on your traffic. There are various options available for website owners, from free to commercial. For a long time I have been using commercial software, but it didn’t give me information I needed. And then I found Google Analytics.

Google wants you to attract more of the traffic you are looking for, and help you turn more visitors into customers.

Use Google Analytics to learn which online marketing initiatives are cost effective and see how visitors actually interact with your site. Make informed site design improvements, drive targeted traffic, and increase your conversions and profits.

Google Analytics is a free tracking tool (though some argue about it and say it’s an exchange deal - you let them know how big is your site, they let you use their software). Installation process is quite simple. You need to go to http://www.google.com/analytics/ and set up a Google account, or if you have a Google account just sign in and Google will create Analytics service for you.

The next step is to add website profile. Google will show you tracking code. All you need to do is to copy this code into your website footer (I hope you do use templates). After Google verifies placement of tracking code you are ready to go. Come back next day and check out what it was able to track. If you see no data, it means you did something wrong.

The best thing about Google Analytics is that you place just one piece of code and it detects which pages on your site are the most popular. This is something not every commercial soft offers. You can easily find out that ie. “your game description page” is the most popular page on your website and what’s more - you can find out how people go to this page (search engine traffic, referrals, direct entries, etc.).

Setting up Google Analytics is almost done. The important step is to set up goals. This will be covered in the next post.

I, just like many developers here, was suffering due to lack of sales. Creating games is fun, but when your game is done, you put in on your website and then wait… wait… and sometimes sales come, but mostly not.

I started to ask myself why is this happening. My games are great (don’t they? ;-)) so what’s wrong? Am I the only one that likes my game?

I started to read various blogs regarding making money online. No, not to make money selling ads, but to learn how to improve my website. When I finally got some results I decided to write few articles to help you find the right way.

So you want to know how to get more sales without spending a penny?

First of all, you need to know who is visiting your site and what one is doing. You need a good tracking tool. Because you don’t want to spend a penny, you can use Google Analytics (GA). That’s what I use and it works great. Installing Google Analytics is easy, so I won’t go deep into this topic today.

When you get GA working the next thing you need to do is to set goals. I recommend setting two goals, but you can have up to four. First one should be game download. Second one, game purchase.

I advise you to install same goal tracking code on all download pages. I assume that you have some kind of a page: “You are downloading…” and then this page is redirecting to binary file.

Google Analytics will track how many downloads you have and what is your site conversion to goal (CRd). What is even more important, GA can report this in depth, so you can find out CRs for each referral. This will let you choose sites that have quality traffic and you can invest some more money into advertising on those sites.

Tracking purchases ain’t that easy. Most of us make use of a 3-rd party shopping cart. I use eSellerate.net. A lot of people uses Plimus, BMT Micro, etc. If you want to track your orders you need to contact your e-commerce provider. eSellerate did a great job for me implementing GA.

You can meet a problem here. Your e-commerce provider my not let you redirect your customer to your site (thank you page), so you lose referral information. You can workaround this by using a mix of PHP and JS script that sets GA cookies on e-commerce service domain. I wrote that script for eSellerate and if you want I can send it to you (I’ll write an article about this later).

When all is set and working you need to wait a little bit to get some data. After that take a look at following metrics:

• visitors to download conversion (CRv2d)
• visitors to purchase conversion (CRv2p)
• download to purchase conversion (CRd2p)
• bounce ratio

You can improve each of this metrics. If you succeed improving it, you will get more sales without spending a penny. How to do that? You need to use Google Website Optimizer. You can read about one of my experiments in the post Improving Runes of Avalon website. In the nearest future I will talk about how you can make such experiments using Google Website Optimizer on your own.