I recently had to create a dynamic date range selector for a Klipfolio dashboard. It took me more time than I would expect to complete this task and  I couldn’t really find any great resources to guide me. Therefore, here is my own tutorial. The first part of this tutorial is divided in three steps : … →

How does the data layer really works ? What’s behind the Google analytics “raw” data ? How does “hits” are sent to GA ? These questions might have crossed your mind if you’re willing to work in the analytics field. However the answers aren’t obvious. In reality you don’t even know how data are really collected, stored or … →

Are you tired of spending your time collecting, organising and presenting data while someone else is doing the interesting job ? Would you rather be a Reporting Squirrel or Analytics Ninja ? Here are five tips to automate your dashboard and reporting. They will help you save a lot of time so you can actually deliver valuable work. … →

How to automatically export Facebook post data to Google BigQuery every day with Google Apps Scripts and Supermetrics. Playing with data can be fairly simple even if you have very basic technical skills. However It can also be intimidating if you don’t have any idea on how to interact with a database for example. This … →

Building a dashboard is hard, making it useful and easily updatable is even harder. If there are a lot of marvellous tools out there to help you accomplish this task, the one you really want is always too expensive and let’s be honest most of the time far from perfect. Beyond the tool, there are … →