{"id":4666,"date":"2017-08-12T10:59:27","date_gmt":"2017-08-12T09:59:27","guid":{"rendered":"http:\/\/positech.co.uk\/cliffsblog\/?p=4666"},"modified":"2017-08-12T10:59:27","modified_gmt":"2017-08-12T09:59:27","slug":"more-messing-with-marketing-stats","status":"publish","type":"post","link":"https:\/\/www.positech.co.uk\/cliffsblog\/2017\/08\/12\/more-messing-with-marketing-stats\/","title":{"rendered":"More messing with marketing stats"},"content":{"rendered":"<p>Its very frustrating to not know if your ads work. I also know that you can never truly correlate these things, but I guess I enjoy trying. With that in mind lets look at 8 days of Production Line sales and marketing<\/p>\n<table style=\"border-collapse: collapse; width: 490px; height: 246px;\" border=\"0\" width=\"192\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col style=\"width: 48pt;\" span=\"3\" width=\"64\" \/> <\/colgroup>\n<tbody>\n<tr style=\"height: 15.0pt;\">\n<td style=\"height: 15.0pt; width: 48pt;\" width=\"64\" height=\"20\">Sales<\/td>\n<td style=\"width: 48pt;\" width=\"64\">Marketing<\/td>\n<td style=\"width: 48pt;\" width=\"64\">Net profit<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$1,140.00<\/td>\n<td class=\"xl63\" align=\"right\">$351.94<\/td>\n<td class=\"xl63\" align=\"right\">$389.06<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$1,283.00<\/td>\n<td class=\"xl63\" align=\"right\">$306.24<\/td>\n<td class=\"xl63\" align=\"right\">$527.71<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$1,453.00<\/td>\n<td class=\"xl63\" align=\"right\">$362.78<\/td>\n<td class=\"xl63\" align=\"right\">$581.67<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$999.00<\/td>\n<td class=\"xl63\" align=\"right\">$583.09<\/td>\n<td class=\"xl63\" align=\"right\">$66.26<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$934.00<\/td>\n<td class=\"xl63\" align=\"right\">$0.00<\/td>\n<td class=\"xl63\" align=\"right\">$607.10<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$796.00<\/td>\n<td class=\"xl63\" align=\"right\">$0.00<\/td>\n<td class=\"xl63\" align=\"right\">$517.40<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$916.00<\/td>\n<td class=\"xl63\" align=\"right\">$0.00<\/td>\n<td class=\"xl63\" align=\"right\">$595.40<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl63\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">s$936.00<\/td>\n<td class=\"xl63\" align=\"right\">$0.00<\/td>\n<td class=\"xl63\" align=\"right\">$608.40<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>There are taxes, distributors cuts etc which explains the lower amount you see as net profit. In any case, is there *any* correlation here? A fairly crude approximation shows average profit when I have no marketing running is $582 versus $391 when I&#8217;m running ads. Yikes. Obviously its not that simple. Firstly the ads could be adding to my wishlists and thus further sales. Or I could be generating more facebook likes. Its so complex.<\/p>\n<p>if I look at visits to the steam store page for production line and add that in I get this:<\/p>\n<table style=\"border-collapse: collapse; width: 473px; height: 224px;\" border=\"0\" width=\"256\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col style=\"width: 48pt;\" span=\"4\" width=\"64\" \/> <\/colgroup>\n<tbody>\n<tr style=\"height: 15.0pt;\">\n<td style=\"height: 15.0pt; width: 48pt;\" width=\"64\" height=\"20\">Sales<\/td>\n<td style=\"width: 48pt;\" width=\"64\">Marketing<\/td>\n<td style=\"width: 48pt;\" width=\"64\">Net profit<\/td>\n<td style=\"width: 48pt;\" width=\"64\">visits<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$1,140.00<\/td>\n<td class=\"xl65\" align=\"right\">$351.94<\/td>\n<td class=\"xl65\" align=\"right\">$389.06<\/td>\n<td align=\"right\">357<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$1,283.00<\/td>\n<td class=\"xl65\" align=\"right\">$306.24<\/td>\n<td class=\"xl65\" align=\"right\">$527.71<\/td>\n<td align=\"right\">295<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$1,453.00<\/td>\n<td class=\"xl65\" align=\"right\">$362.78<\/td>\n<td class=\"xl65\" align=\"right\">$581.67<\/td>\n<td align=\"right\">342<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$999.00<\/td>\n<td class=\"xl65\" align=\"right\">$583.09<\/td>\n<td class=\"xl65\" align=\"right\">$66.26<\/td>\n<td align=\"right\">515<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$934.00<\/td>\n<td class=\"xl65\" align=\"right\">$0.00<\/td>\n<td class=\"xl65\" align=\"right\">$607.10<\/td>\n<td align=\"right\">122<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$796.00<\/td>\n<td class=\"xl65\" align=\"right\">$0.00<\/td>\n<td class=\"xl65\" align=\"right\">$517.40<\/td>\n<td align=\"right\">86<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$916.00<\/td>\n<td class=\"xl65\" align=\"right\">$0.00<\/td>\n<td class=\"xl65\" align=\"right\">$595.40<\/td>\n<td align=\"right\">96<\/td>\n<\/tr>\n<tr style=\"height: 15.0pt;\">\n<td class=\"xl65\" style=\"height: 15.0pt;\" align=\"right\" height=\"20\">$936.00<\/td>\n<td class=\"xl65\" align=\"right\">$0.00<\/td>\n<td class=\"xl65\" align=\"right\">$608.40<\/td>\n<td align=\"right\">122<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Which suggests that I am at least successfully driving traffic with the ads. However, the percentage of visits to the store page that come from external sites over that period is only 22%. In other words, I really should be scaling any boost in sales (if there was one) by 0.22 anyway. I can see that I&#8217;ve managed to peak that share of visits from external sites to 38% on the 7th August, at a cost of about $480. Hmmm<\/p>\n<p>So what can be learned?<\/p>\n<p>a) My suspicion that direct attribution of ads-&gt;sales is difficult to correlate certainly seems true.<\/p>\n<p>b) You can probably double your visits to your steam store page for about $600\/day.<\/p>\n<p>You really can&#8217;t learn much from 8 days data. I&#8217;m trying to resist the temptation to advertise more for a few more days so I have a better dataset (I have ad-spending data going back about 30 days before I stopped).<\/p>\n<p>I have a suspicion that the cost to generate enough &#8216;loss-leading&#8217; traffic to push the games popularity up to the point where it gets noticed by steams algorithms and thus starts to generate sales from within steam at a higher rate is quite high.\u00a0 I&#8217;m digging into the stats of all of my games to try and work out how many extra sales I need to push PL into the top 10 &#8216;topsellers&#8217; among indie strategy games&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>Yup, this is all very small fry. I&#8217;m trying to find a winning strategy before I start shovelling wheelbarrows full of marketing dollars at it :D<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Its very frustrating to not know if your ads work. I also know that you can never truly correlate these things, but I guess I enjoy trying. With that in mind lets look at 8 days of Production Line sales and marketing Sales Marketing Net profit $1,140.00 $351.94 $389.06 $1,283.00 $306.24 $527.71 $1,453.00 $362.78 $581.67<\/p>\n<p class=\"text-right\"><span class=\"screen-reader-text\">Continue Reading&#8230; More messing with marketing stats<\/span><a class=\"btn btn-secondary continue-reading\" href=\"https:\/\/www.positech.co.uk\/cliffsblog\/2017\/08\/12\/more-messing-with-marketing-stats\/\">Continue Reading&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4666","post","type-post","status-publish","format-standard","hentry","category-business"],"_links":{"self":[{"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/posts\/4666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/comments?post=4666"}],"version-history":[{"count":2,"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/posts\/4666\/revisions"}],"predecessor-version":[{"id":4668,"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/posts\/4666\/revisions\/4668"}],"wp:attachment":[{"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/media?parent=4666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/categories?post=4666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.positech.co.uk\/cliffsblog\/wp-json\/wp\/v2\/tags?post=4666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}