Bingo Card Creator Sales Stats

As promised yesterday, I’ve cobbled together a feature to semi-automatically generate monthly sales reports.  At the moment I can’t show you guys the more impressive portions of the backend, as they integrate customer data at the moment, but I did manage to totally bulletproof the monthly sales report.  (Meaning it is physically impossible for anyone to get from the sales data to any identifiable information about customers, which would be 101 flavors of bad.  The actual backend code is not even uploaded on the production copy of the server.  I’m a little paranoid, what can I say.)

You can take a gander here.  Note the stats for March 2008 are, by necessity, not complete yet. ;)

Comments Off

Adding some backend tracking…

I have been working on backend stats tracking for Bingo Card Creator to supplement Analytics.  While most of it is completed, I have to get the stats out of the Rails console, which while quite useful (arbitrary queries!) leaves something to be desired in the eye candy department.  Since I eventually want to present stats to my users, I figured I would teach myself how to use the Plotkit Javascript library, which makes pretty charts client-side so they don’t crash my server.

I’m sort of tired at the moment, so I can’t describe exactly everything I did to get this running (some other day, I promise), but as a proof-of-concept I graphed the total number of times bingo cards have been downloaded from Daily Bingo Cards and Bingo Card Creator (and, of course, the combined site as of March 1st).  Its a little rough around the edges but, hey, its dynamically updated.  Interested folks (and competitors ;) ) can find it here.

Two goals here:

  1. Better data visualizations lead to better decisionmaking.  I really started believing this after working with CrazyEgg for a while.
  2. If I can hook this sort of stuff directly into the backend sales tracking I can have the website report my monthly sales without having to do any work.  Programming is the art and science of being strategically lazy, after all.  Then that is one less blog post a month I have to write.  (Or fail to write, as the case may be — need to catch up on that tomorrow.)
Comments Off

Pressing My Customers' Buttons

In my continuing desire to split test the heck out of everything, and my continuing total inability to graphically design to save my life, I went back to the LogoSamurai folks and got some buttons designed for the website as drop-in replacements of my current ones.  I’m also getting some made by my web designer Gursimran, and will be testing tNew buttons to testhe two against each other (and, of course, against the current set) and keeping the ones which are most successful at driving the conversions. 

Gursimran isn’t done with her set yet, but since the Logo Samurai guys are, I thought I’d give you a sneak peek.

As you can see, these are much more Web 2.0 than most web sites in my niche, and quite different from the previous look&feel for the Bingo Card Creator site.  That’s why we test them, of course — I don’t want my opinion on what my customers want to calcify and blind me to the actual facts of what they act upon.  Gursimran has a very different visual style so I’m intensely interested in seeing how things work out.  (Sidenote: I love the pencil!)

Cost for these, incidentally: $60, $15 per button.  I had to convince Gursimran to take money for the buttons, as she wanted to just throw them in with the price I already paid for the web design.  As great a deal that is, I would feel really terrible imposing on her like that — professionals should not be afraid to charge money for services, in my opinion.

Plus, if the winning set of button increases my trial conversion rate by 1% and/or my purchase conversion rate by 1%, that would work out to be quite a bit of money.  I also like keeping all of my freelancers happy with me, as I feel it will tend to get me work done in a timely and high quality manner, and thus prevent me from having to go play Russian Roulette with the freelancer sites to find a replacement source of talent.

Comments Off

Results of Site Redesign

About a week ago I merged Daily Bingo Cards and Bingo Card Creator, and embarked on a massive site redesign.  I thought I would write a bit about how this improved my numbers.  I have compared traffic to the combined total of the two sites — all other comparisons are against Bingo Card Creator itself, because I am lazy.  These are not rigorously devised statistics — they’re my quick eyeball of typical statistics for a weekday.

Visitors: 900 -> 1,200

Pages per Visit: 2.5 -> 3.5

Time per visit: 90 seconds -> 150 seconds

Trial Downloads: 100 -> 125 to 150 (hasn’t settled yet)

Confirmed Application Installs: 20-25 -> 30-40 (hasn’t settled yet)

Sales: 2 -> slightly under 1.

I’m sort of at a loss as to what is causing the sales to go down.  Its possible that is just natural fluctuation, as all of the pre-sales indicators are way the heck up.  I also might have some folks working through the trial pipeline who remember the old branding and get turned off by the new design (“This isn’t the right site!” is a very serious worry in my market). 

A graphic on how well the design focuses user attention, stolen shamelessly from my page on St. Patrick’s Day bingo and courtesy of CrazyEgg (I just upgraded to their $19/month plan because I’m getting too much traffic for the $9 plan to be useful — please, God, send me more problems like that one).  (This image will almost certainly be truncated by WordPress.  Click to see the full sized version.)

St. Patrick's Day click tracking

And one more, because images are fun.  Caution: this isn’t the best test in the world, because I did some significant changes to the sidebar several times while the test was running, and when element IDs change sometimes CrazyEgg “loses” the clicks from some of the views.  (This is so that you don’t see big red splotches where page elements no longer exist, obviously, but it also means that most of the clicks on those buttons aren’t getting shown.)

CrazyEgg analytics of front page

Alright, back to my favorite Saturday activity: doing taxes!  (I got the uISV part done already.  It came out to a bit over $800 on $6,300 odd of profits.  Now I’ve just got to collect a bunch of statements documenting less than $100 in interest and then fill out a bunch of boring administrivia forms.)

Comments Off

Add An Image, Increase CTRs By Lots

I found a nice free icon set to spruce up my Irish bingo cards blog post, which is going to get seen by several thousand people in the next week.  I figured, hey, add a cool looking image to useful content and you’ll get much better linkable action out of it.  Plus, folks are much more likely to click it.  Doesn’t it grip you so much more than just the text alone?

Comments Off

Brilliant Bit of Javascript for Redirecting Downloaders

One of my uISV buddies, Ethan (king of language learning software), took me to task earlier today for spending so much time optimizing my download page when I could just eliminate it entirely and link the download direct to the download button in most cases.  I had always had these issues with that solution:

  • My users don’t necessarily know what to do with a window that pops up
  • If I do an HTTP Refresh or Javascript redirect, many browsers pop a security warning
  • I have to discriminate between Mac and PC users somehow
  • It is impossible to track that conversion for AdWords purposes, currently

Examining Ethan’s code made it really easy to avoid the first two issues:

function SetUpRedirect()
{
var destination = “http://www.bingocardcreator.com/free-trial.htm“;
setTimeout(“window.location='”+destination+”‘”,3000);
return true;
}

If you stick that in the OnClick attribute of a link pointing at your favorite executable, three seconds after clicking the link and having the download initiate, the user’s browser goes to the download page in the background.  This causes no security warning, scores them as a download conversion with the appropriate code on the page, and presents graceful fallback behavior if they don’t know what to do with the window that just popped up, since you can give them instructions.

Ahh, but what to do about the difference between Windows and Mac computers, which need different installers?  First, we make a controller method to handle it in Rails:

def free_trial_download
    if request.user_agent.downcase =~ /mac/
      send_file “public/files/BingoCardCreator.zip”, :type => “application/zip”
    else
      send_file “public/files/BingoCardCreatorInstaller.exe”, :type => “application/exe”
    end
  end

 That essentially says “If I’m positive you’re using a Mac, initiate a download of the zip file.  Otherwise, initiate a download of the exe file.”  (Obviously since 92% of my downloads are PC users I want to err on the side of caution.) 

Then, with a simple route added to routes.rb:

map.downloadFreeTrial ‘free-trial/download’, :controller => ‘static’, :action => ‘free_trial_download’

we get a simple URL which is platform agnostic and which decides, on the server side, which version of the file to give them.  You can then decorate your links to the platform-agnostic URL with the code to redirect the page to the download page in the background, with Analytics click tracking, and what have you.  Easy peasy!  One less step in the conversion funnel, and instantaneous recovery of a large portion of the 20% of folks who bounce out of the funnel at the download page.

WARNING: send_file will cause your Rails process to block while that IO transfer takes place under certain older versions of Rails (not in 2.0 in my testing).  This will cause requests coming to the same Mongrel after the download to wait until the download completes to start, which if you have a 56k modem user could potentially cause your basic site access to be delayed for minutesNot good news!

My site has two Mongrels running, very few dynamic requests, and very small executables.  If your site doesn’t have this profile, instead of using send_file, 302 redirect the browser to the appropriate file and let your web server handle the request before Rails does.

WARNING NUMBER TWO: You don’t want bots hitting that action, so its time for a good-old robots.txt exclusion of it.  Note that deploying this sitewide will cause your free trial page to lose quite a bit of the juice you’re sending to it.  However, given that that page is typically linked far and wide on the Internet and doesn’t include much interesting content on it (which would distract from the conversion to the trial!), you can probably live with that tradeoff.

Quick request: if you run an obscure browser or a Mac, kindly use my OS-agnostic link and tell me if it works for you.  (You should get a prompt to download BingoCardCreator.zip )

Comments Off

Regsoft Picks Up the SWREG Scam

I just paid ~$16 to the excellent Robosoft folks to renew my subscription to their updates for the submission service, and lo and behold, it seems that Regsoft is now doing the same scam that SWREG got into hot water for earlier:

Regsoft Scam

To add insult to injury, they put my order through extended verification because they’re afraid that I’m trying to scam them.  (This happened when I purchased Robosoft the first time — IP address in Japan + billing address in America = fraud screening.  I need to remember to use my US proxy server next time, so that my profile looks like a smart crook rather than a dumb, legitimate customer.) 

(For those of you who haven’t heard of this before, the scam is that if you hit that Continue button or the link right next to it, your credit card gets charged $9 a month until you call up the number on your statement to cancel it.)

And if it were anybody but Robosoft, and would probably have called Visa already to report a probable fraud in progress.

Comments Off

I Never Really Set Out To Have A Brand

… but Google decided I have one, anyhow:

Sitelinks image

Those extra links under the result for me are called Sitelinks, and the general idea is that Google wants to simplify access for the most common subnavigational queries on your brand, thus removing a click from the process for your visitor.  If you’ve got a name that could ever be directly searched, you might want to consider that folks may not come in at the home page.  (Heck, this is the Internet: you should ALWAYS consider the possibility of folks accessing your site in essentially a random manner.  Something like 70% of my traffic comes in at an entrance other than the home page!  Thus, if you have a free trial page, you need to try “selling” the free trial without the benefit of the homepage explaining what it does, etc.  I made some edits to my page today to try doing just that, without taking away from the Big Orange Buttons directing folks to actually download the trial.) 

Speaking of sitelinks, if you’re on the bubble for having them, you can see them in the Google Webmaster Console.  You’re given what links Google has chosen and the opportunity to nix individual links, but they won’t let you add new ones or specify (or indeed see) which queries will bring them up.  “Bingo Card Creator” doesn’t, for example, possibly because the algorithms aren’t yet convinced that that is navigational as opposed to someone looking for a bingo card creator.

It seems that Sitelinks, which used to be primarily the domain of the big brands with gazillion dollar advertising budgets, got democratized recently.  (I mean, heck, Daily Bingo Cards?  I’d be suprised if that saw more than 50 searches per month.)  Several other uISVs have them: Perfect Table Plan, Helpspot, and LandLordMax when I tried some quick searches.  (Others that I rather expected would have them didn’t, for whatever reason.)  Its, of course, an unalloyed good thing when you have them, since it means a search for the brand that you worked so hard building directs almost all the clicks to you, as opposed to folks trying to arbitrage off your brand equity, like say a download or typosquatter site. 

(I end up paying about $25 a month to download sites put ads for BCC right next to the actual download link for BCC and have customers hit it by mistake.  I’m happier to pay for the click than lose it to a competitor, but I can’t say I’m a big fan of the process.)

Comments Off

Candidates for New Bingo Card Creator Logo

Logo Candidate #1

Candidate #2

Candidate #3

 As a common comment about the new Bingo Card Creator redesign was that the current logo doesn’t really play well with a blue/green color scheme, I had a few new logos drawn up with an eye towards possibly replacing the logo with one of them.  I used LogoSamurai, whose art style really captivated me from the first time that I saw it, although I have some reservations that it might be a little too hip for my customers. 

Of the three above, I have a clear sentimental favorite, but I’d be interested in hearing your take on things.

Incidentally, their checkout process had the most brilliant upsell I’ve ever seen: “You’re about to buy a logo for $67.  But wait, for just $50 more, you could get 2 additional logos.  What is not to like?”  Indeed, that is a great deal and minimizes the perceived risk of the transaction (getting a logo which you don’t like) while grabbing them additional sales from the folks they have already persuaded to become customers.  Good call.

Comments Off

Significant Changes To Website

I’m now testing some of the upgrades to my website made possible by the new design: my purchasing page now has eye-level testimonials (the first of many — got to go through a year of email and put them on rotation) and some sidebarized credibility enhancing goodness.  The rails code for this is pretty simple:

<%= render :partial => ‘paging_bob_walsh’ %>

(He finally nagged me enough to put up testimonials.  OK, so perhaps he didn’t mention it to me directly, but the little Marketing Bob angel on my shoulder kept saying “Patrick, Patrick, where are your credibility markers?” until I gave in.

The second change I’m particularly proud of — it is designed with both SEO and users in mind.  Take a look at the sidebar on any of the “static” pages of the site (you know, the ones which are normally stuffed full of content but which don’t typically directly help conversions).

New and improved sidebar

As you can see, I now stealthily plug the holiday bingo cards for a period in advance of (and slightly past) the actual holiday, giving Google plenty of time to spider me and apply the front page link juice straight to that card.  I then pad out the rest of the slots with cards and categories chosen randomly.  That is iteration 1.0 of my linking architecture — I’m going to transition it to a neat little concept I call Rawlsian linking in a week or so, after I have it coded.  Suffice it to say its what linking would look like if the goal were to redistribute the wealth between pages.  The randomness is a fairly decent first approximation for now, and hopefully my users will also enjoy it, causing them to spend more time on my pages and become more likely to download the free trial.

Finally, I noticed in my logs that Google was hitting a lot of URLs with capital letters in them.  This was suprising, since my app is only supposed to generate URLs with lower-case letters.

Example:

http://www.bingocardcreator.com/bingo-cards/Economics

http://www.bingocardcreator.com/bingo-cards/economics

(Same content, different URLs — uh oh!  Note if you were to click on those now you’d see it has been fixed.)

This was also catastrophically bad news, because if two URLs share the same content, they split their link juice and invite the duplicate content penalty to chase both URLs out of the index.

I fixed it by identifying the two actions which had the issues and then, if the URL had a capital letter in it, lowercasing the URL and issuing a 301 redirect to the proper, canonical version.  There is probably a less hackish way to do this:

def show
#prevent Google from indexing uppercased and lowercased versions of same content
if (request.request_uri != request.request_uri.downcase)
headers[“Status”] = “301 Moved Permanently”
redirect_to request.request_uri.downcase
else #process as normal
end
end
end

Comments Off