Weighted sort was a nice feature from Google Universal Analytics table charts. Adjusting the sorting to inject the importance of the quantity represented by each row helped a lot, applied to rates. If you sort by descending order a list…
Read moreCategory
Some examples of advanced solutions to address specific reporting needs inside Looker Studio (ex Google Data Studio)
Weighted sort was a nice feature from Google Universal Analytics table charts. Adjusting the sorting to inject the importance of the quantity represented by each row helped a lot, applied to rates. If you sort by descending order a list…
Read moreLast year, I wrote an article describing how to build a simple funnel chart with a single table chart. A way to demonstrate in Looker Studio (ex Google Data Studio…should I continue to specify it) that we don’t need 20…
Read moreFew years ago, I wrote a tutorial about how we can include annotations inside Looker Studio line charts. My custom solution was nice for instant events and correlation analysis. This time, we will take care about periods and events occurring…
Read moreKeeping charts as simple as possible is very challenging. For some cases, a single interactive feature can offer a first level of data exploration or calculation without overloading the default state of your Looker Studio (formerly Data Studio) chart. In…
Read moreI always prefer preparing data outside Data Studio and I always prefer using builtin chart types when it is possible. But sometimes, we need something fast, more or less disposable, addressing temporarily visualization needs, to get a first level of…
Read moreFunnel report type inside Looker Studio, a recurring need for a popular visualization. There are a lot of solutions, templates, articles describing how to do. Most of these resources are nice and address the visualisation need. Technically speaking, they are…
Read moreWaterfall charts are nice & efficient to visualize cumulative values of a metric and the related participation weight of each item, towards the final value. In digital analytics fields, it can address insights about frictions on funnels, form filling, web…
Read moreLet’s describe step by step, inside Looker Studio (formerly known as Google Data Studio) – how to split delimiter-separated values – as example with comma – from a text dimension to get the same related metrics, drilled down by real…
Read moreThe preparation & the deployment of a URLs redirection plan require method, know-how, a lot of rigor of execution, involving various digital team members and expertises (from traffic management to IT services). Because of its high weight of impacts, and…
Read moreWithin your organisation, dashboards and reports multiply to address various needs of analytics & digital performance. Some (most) of them are probably built with Google Data Studio if you are reading these lines. The creation of a dashboard calls for…
Read moreThe quick tip below describes how to transpose Looker Studio (formerly known as Google Data Studio) table charts composed with rows of specific dimension values and column of metrics TO rows of metrics with columns corresponding of the dimension values….
Read moreConditional formatting is typically a very good automatic highlight system for dashboards to read fast and see what it is the more important. On the other hand, Google Data Studio can be also used for manual reports and data viz…
Read moreGoogle Data Studio can help you to address a lot of challenges of dashboarding, reporting or data story telling. You can also use it for technical monitoring. In this article, we will create a simple Google Data Studio report based…
Read moreMarketers & website owners use to fill annotations inside Google Analytics Universal, adding temporal context to data with external events. Unfortunately, this feature is not available for the moment inside Google Analytics 4 and also inside a lot of tools…
Read more