Bill Franklin

Working at ChartMogul. Oxford University student.

Read this first

Deconstructing the Google Analytics tracking script

What does the Google Analytics script actually do? It’s pretty convoluted at first glance.

    (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
    ga('create', window.ga_id, 'auto');
    ga('require', 'linkid', 'linkid.js');
    ga('send', 'pageview');

After beautifying it with jsbeautifier it’s still not clear what the script actually does.

      (function(i, s, o, g, r, a, m) {
          i['GoogleAnalyticsObject'] = r;
          i[r] = i[r] || function() {
              (i[r].q = i[r].q || []).push(arguments)
          }, i[r].l = 1 * new Date();
          a = s.createElement(o),
              m =

Continue reading →

SaaS Metrics in the command line

So I have this Terminal. How do I get SaaS Metrics in it?

Screen Shot 2016-10-09 at 21.04.50.png

With chartmogul-cli!

With quick commands you can get metrics for a specified period. For example, all metrics (MRR, ARR, etc.) since the beginning of 2016.

$ chartmogul all --start-date 2016-01-01 --end-date 2016-10-15

Screen Shot 2016-10-09 at 21.05.39.png

Get a metric for a group of plans

$ chartmogul all -s 2016-01-01 -e 2016-10-15 --plans Gold,Silver

Get a metric for a region or set of regions

$ chartmogul all --this month --geo US,GB,DE

Get a chart of your metrics.

$ chartmogul mrr --this year --chart

Screen Shot 2016-10-09 at 20.59.58.png


$ npm install -g chartmogul-cli

You would need a ChartMogul account for the authentication + metrics. Visit the Github repository for more information.

Continue reading →

How to do inbound sales

 1. Need leads

Get a steady flow of potential customers signing up to try your software. These are inbound leads.

 2. Send a personal hello

When a person shows an interest in your software, reach out with an email or call. Start a conversation about their requirements and find out if they are a qualified lead (person who will find the software valuable).

I do this with a personalised email within an hour of someone signing up:

Hi {{first name}},

Great to hear you’re trying out {{software}}. {{something personal about their business}}.

{{#if not_qualified_yet}}
I see that you didn’t yet {{perform qualifying action}}. {{ask why not}}.
I see that you {{performed qualifying action}}, that’s great!

{{#if qualified_and_bigger_lead}}
It might be worth having a call to discuss your use case. Let me know if you’d like to schedule a demo.
Please let me know if you...

Continue reading →