Blog de Louis Dubruel
On SEMRush, there is a graph that makes all customers agree and leads everyone to take out a subscription. I am of course talking about the analysis of the number of keywords per position interval over time!
Cohort analysis is a fairly simple way to visualize your user retention. And we’re going to see how simply we can do it in Data Studio. Expected result This tutorial is based on a Spreadsheet data source but the principle remains the same for any data source with a Date field that indicates the 1st user interaction and a second Date field that indicates the interactions in the user’s life. …
Have you ever said to yourself, “My dream is to create a synergy between my Search Console data and my Google Ads data to optimize my media spend!” What a wonderful dream. Let’s make it happen. Yes, now. JOIN method Definition and use The JOIN method allows you to combine data from several data sources around one or two dimensions in order to bring more consistency to a multi-source analysis. …
One of the most used functions in calculated fields: the famous CASE function! You can use it to segment all types of data. CASE function Use The CASE function allows related data to be grouped together under certain conditions. The syntax of the function is as follows: CASE WHEN … THEN “…” WHEN … THEN “…” ELSE “…” END WHEN is a condition. It accepts many functions like the 3 …
Under the right circumstances, pie charts are great for showing part-to-whole relationships; however, our perceptual system is bad at comparing areas or angles accurately. If you use a pie chart, a best practice is to use a dimension with two to five categories, and add labels to help your audience make more accurate judgments. Pie charts are useful for: Showing a high-level breakdown of a measure by dimension with two …
Tree maps and pie charts are good choices for showing part-to-whole comparisons. But, unlike pie charts, tree maps are good for displaying data sets with long tails, those that have many small values that contribute to the whole dataset.
The Time plot, a very nice viz to quickly identify increases of a metric in time. And it’s pretty 🙂 Of course a community visualization exists but what better way than create a time plot through the native viz of Data Studio Expected result To be able to create this kind of trail of colored dots that take a size according to the value of a metric and that spreads …
When you track your favorite KPI, you can easily visualize the absolute values of that KPI over time. What if we could visualize the percentage growth rate over time instead? Expected result The result of this tutorial is the following: a time series that describes the daily evolution rates: We will use the Google Analytics data source (but this method is valid for any data source) and the following concepts: …