How to track your channel ROIs from Google Analytics eCommerce?

Google Analytics has many options to define goals which are perfect if you need to measure simple objectives as: how many users reached a given page, created a cart, did a checkout… But if you have an eCommerce website with traffic coming from several channels, your most important KPIs to track are your channels ROIs. To […]

How to query several segments for your Google Analytics widget?

Google Analytics segments are powerful to finely understand user behaviours on a website. But most dashboard tools let you query data for a single segment at once. With these tools, it gets very complicated to create a chart with data from multiple GA segments. In this article, I’ll show you how you can easily create charts […]

Displaying a different version of a dashboard for mobile devices

Is responsiveness the best solution to multi-devices dashboards? Serenytics dashboards are responsive. When you open a dashboard on a mobile device, the widgets layout will be modified compared to the desktop layout. The widgets are moved to a single column and tabs are displayed within a combobox. This is a technical answer to the problem of […]

Compute Year-To-Date growth

A Year-to-date KPI gathers data (e.g. sales) from the beginning of the year up to today. What’s very interesting is to compare this KPI with the same computation done at the same period of last year (let’s call it Last-Year-To-Similar-Date). For example, if today is “2016-11-19″, I want to compare : Year-to-Date : values within […]

Trigger a data processing job from a Slack command

You often need to share a few metrics with your team. For that you need a small ETL script (query the data source, e.g. data from 3rd party SAAS you use such as your CRM), transform the data and share the output with some people. You can create a script in your favorite language and […]

Use Serenytics Python client to create dashboards from CapsuleCRM

CapsuleCRM is a great CRM. We use it and love it at Serenytics. One issue is that the integrated dashboard is not configurable. We’ll see in this tutorial how to use connect CapsuleCRM and Serenytics to create the exact sales dashboard you want. This tutorial is about connecting data from the Capsule CRM. But it’s also a […]

Create your app to track your Velib station availability and history

In this tutorial, you will learn how to pull data from the Velib API into Serenytics, and then create a dashboard with this data. The app will give you the number of bikes available at some stations in real time (useful on a smartphone) and a map of all stations. We’ll also show the history of the […]

Reporting Sales with a Dashboard

This guide will explain how to build a sales reporting dashboard starting from a simple Excel file (click here to view). No IT skills required. By the end of this tutorial, you will have created a dynamic web-report that can be easily shared with your colleagues. Loading the Input Data Throughout this tutorial, we’ll use this excel file as the […]

2016 US Presidential Candidates and their Official Websites – Are they good at SEO?

This is the hot topic in many TV news shows right now and for a few months more: who will be the republican candidate? And who will be the next US President? In the race towards the White House, each candidate has to consider every option to rally votes. The official websites of candidates are […]

Computing new columns in your data sets

Serenytics lets you create new columns in your data sets with three types of formulas: Mathematical formulas (we call them only ‘formulas’ within our tool) Conditional formulas Aggregation formulas Of course, all those formulas are available for all the types of sources we handle (SQL, XLS, CSV, API, Merge of sources, Concatenation of sources,…). To […]