How to create dynamic date range selector in Klipfolio with Google Analytics API.

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 : … 

 

JavaScript introduction guide for Data Analyst and Marketers.

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 … 

 

5 tips to build a fully automated dashboard using Google Sheet.

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 load Facebook post data into Google BigQuery

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 … 

 

How I build a simple, flexible and efficient Dashboard with Supermetrics (and why !)

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 … 

 

How I built the ideal list of youtube influencers with “data” using Social Blade and Import.io

Playing with data allow you to do many things. You can build beautiful data visualizations, create dashboard for reporting or enter information that is not normally available Once you start understanding what’s an API and how to use a spreadsheet properly you can collect data and organise them in order to solve any kinds of …