As stated in one of my other articles, a growth hacker devotes a large part of his agenda to studying multiple graphs and analysing the data found. The goal is to find amongst other things where the value of the product is (while reducing the friction at the same time), the attributes which will determine your power users, the actions that will influence retention, the most profitable acquisition channel etc.
Nevertheless, sometimes it is handy to present on one screen real time data from different sources (Mixpanel, Youtube, Facebook, Twitter, Bitly…). If one day you are in need of a solution, it is easy to use Geckoboard. For 50$ a month, this tool allows you to directly connect to the most popular API’s and to make with just a few clicks an interface which includes all of your most important data (the image opposite). In this article, you will have to create a dashboard and show it on a screen inside your startup thanks to a Raspberry Pi.
#1. Constructing and organizing a Geckoboard.
The first thing to do is to create an account on Geckoboard. You are given a complete 30 day trial for free in which there are no payment commitments (you don’t even need to give your credit card details). Fill in correctly the different requirements and submit.
As soon as your account has been confirmed, you will be redirected towards your dashboard. By clicking on « Add Widget » in the top right corner, you can select a platform and show something you created using this. The size as well as the position for these different widgets is adjustable. It is also possible to set an objective on some of these or to show the performance according to a certain period. Don’t forget that Geckoboard also has an API to show data that comes from platforms that are not yet available.
Concerning how you organize your Geckoboard, one of the core principle is to save time by taking a step back to look at your current situation from every perspective. Keep the top left part of the screen for Mixpanel, the right hand side for Google Analytics and the bottom for YouTube… You must be logic and rigorous, as the aim of this dashboard is to get a quick overview of what happened and comparing your data. It can also be useful to put together all of the other things that may have a link together (so you are more able to see a correlation for example).
You must also be dynamic and flexible. If it is necessary to delete or to add new metrics according to your current objectives, then do it. Let’s take an example, for instance in the case of redesigning a homepage, it could be interesting to show the new conversion ratio for signing up (by comparing it with the last one). Geckoboard is malleable and everything can be set up easily, so make use of this.
#2. Showing your Geckoboard on a TV thanks to a Raspberry Pi.
As soon as your Geckoboard is correctly set up, the important thing is to make your content visible and easy to access. And to do this, what is better than showing it on a TV in the middle of your startup?
For less than $100;, it is possible to get a Raspberry Pi II and all the accessories needed to implement the system. Here is what you will need :
- A Rasberry Pi 2 .
- A protective case for the Raspberry (I strongly recommend it) .
- A mains adapter with a micro-USB .
- A microSD card .
- A USB WiFi stick (unless you prefer connecting your Raspberry via Ethernet cable).
- A HDMI cable to connect your Raspberry Pi to your TV.
These products are available to purchase separately but to save time; I recommend this complete Rasberry Pi kit found on Amazon. If you don’t have a keyboard or a mouse at your disposal, you can also order these. The two peripherals are obviously essential to control your Geckoboard.
#2.1. Formatting the microSD and installing NOOBS.
The first thing to do is the format your microSD so you can install Raspian (the operating system for Raspberry which is based on Debian). We will need to copy NOOBS (New Out Of The Box Software) on it, with the objective being to facilitate the boot up of the installation of your Raspberry.
If you are a Mac user, download SDFormater. This little application allows us to correctly format our microSD card. For those that use Windows, I will leave you to your own devices to do your own research for this.
Connect your microSD to your Mac :
- Select the card that you have just connected .
- Select « Overwrite Format » .
- Enter an appropriate name for your MicroSD (like the name of your startup).
- Click on the button « Format ».
All that is left to do is to copy NOOBS to the root of your microSD. For this, download this here, decompress the file then copy its content onto your newly formatted microSD. Be careful, and do not move the folder NOOBS itself onto your card, it’s the contents that must be at the root of this (see the image below). Eject it now to finish correctly. We will now start installing your operating system on to your Raspberry.
#2.2. Installing your operating system onto your Raspberry.
Connect your keyboard and your mouse to the numerous available USB slots as well as the HDMI cable to your Television. Hook up your Ethernet cable or your WiFi stick. Place your microSD in its slot and connect your Raspberry to the mains thanks to your adapter delivered with the kit. NOOBS will automatically start up and the interface below should appear on your television.
This is where it is possible to configure your Raspberry for different operating systems. Select Raspian, change the language on your keyboard to French (to not have a QWERTY keyboard) then click on « Install ». Wait for a few minutes to let it install. You will be alerted by a pop-up when your system is ready. Your Raspberry PI will reboot automatically and it will be time to start your first configurations.
#2.3. Configuring your Raspberry.
When it’s rebooted, you will be taken to a page concerning configuration and different other tools. Use the TAB key to navigate between the different sections. In general, I leave everything on default and then click « Finish ».
You will still be able to access later on this panel by entering the following command in your terminal:
If no error comes up, you will now be able to access your terminal. It is here that you will be able to do the majority of your experiments. If you are at ease with the graphic interface, remember that at any given moment it is possible to switch to this by typing the following instruction :
We will now update your different packages then install chromium (a light browser which will allow us to view your Geckoboard on the screen without having a navigation bar).
sudo apt-get update sudo apt-get upgrade sudo apt-get install chromium
So that your screen doesn’t go into Standby after a certain amount of time, we will now install xscreensaver.
sudo apt-get install xscreensaver
Turn on your graphic interface with startx, when you get to the menu « Start > Preferences > Xscreensave », and deactivate the standby.
#2.4. The display of your Geckoboard.
Go back to your terminal, we will now be able to start up your Geckoboard. Each dashboard contains a URL only accessible in the reading only mode, this is the one that I recommend in general to load. It is possible to recover by clicking on the on tab « Share ».
It is now time to display your Geckoboard. Boot up the last command chromium below and the turn is played.
chromium --kiosk https://[your].geckoboard.com/dashboard/[yourID]
#2.5. Time to show off.
To conclude and this is the essential part, remember that giving visibility to the numbers that count, improves on the one hand the quality of discussions that your teammates could have between them but helps them especially day to day in detecting the actions that have an impact from those that do not. You save a lot of time in the visualisation but also in the interpretation. And in this race against time, this is a competitive advantage which is priceless. Once again, execution is key.
I hope that this tutorial was useful and improves your execution, do not hesitate in sharing this article on social media or to subscribe to my newsletter below. 🙂
Automating and Scraping Like a Growth Hacker
If I had to talk about one specific unfair advantage that a growth hacker has to...