When I was speaking at NamesCon in January I said that I would like to show the attendees the best computer game I’ve ever played. It has all the aspects of both a tactical and strategic game with a bit of time travel for good measure. Everyone leaned forward with expectation…
I then put Excel up on the big screen in the room. It’s safe to say there was a bit of laughter. Let’s think about it for a second, Excel allows us to answer questions about the performance of our domains like no other application can. We can view the past, compare it to the present and even predict the future.
Right now we are going to mobilise the data that we have arrayed from the previous articles in the series so that we can understand what is happening with our domain traffic. This will be a VERY high level view of our traffic test but I believe that it will help get some answers to our questions.
The first thing we need to do is to ensure that all of the baseline data is in the same currency as the testing monetisation source. Once this is done then we then need to convert everything to daily data. The reason why we need daily data is that it gets rid of the problems associated with 28/30/31 days in a month and also allows us to later compare the data against daily from the new testing source.
Next, create another tab in Excel and call this “Latest Data”. When capturing data make sure that you have multiples of 7 days so that any variability caused by the weekends can be minimised. All of this data needs to be brought back to a daily format so that we can then compare it to the baseline.
Make sure you check the DNS settings of EVERY domain in the test so that domains not pointed correctly can be removed. There’s no point in penalising a test by having domains with baseline data and no data from the testing source.
Now create a tab called “Analysis”. In this tab you need to add you complete list of domains in column A, Column B, C and D are for the baseline views, revenue and RPM. Columns E, F and G are for the new monetisation company’s views, revenue and RPM.
Now that the data is sorted out you are now in a position to conduct some analysis.