We create funnel reports for a while inside Google Data Studio. 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 based on…
Read moreFor a lot of cases, legends are not the best visualization solution for line chart (and similar trends chart types). Often, the chart and related data are simple BUT complicated to read because of it requires back and forth to…
Read moreThe Looker Studio (ex Google Data Studio) calculated field below returns the older date from a date dimension. The min date in other words.
Read moreThe Looker Studio (ex Google Data Studio) calculated field below returns the most recent date from a date dimension. The max date in other words.
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 moreThe Looker Studio calculated field below returns the file name with the related extension from a field providing an absolute URL.
Read moreFew months ago, I’ve discovered a nice Google hidden URL thanks to a tweet from Ben Collins about a Google Sheets tip. If you use Sheets, I strongly recommend to follow Ben and enjoy what he shares every day. Thank…
Read moreLast week, we enjoyed discovering the new possibilities of data manipulation inside Looker Studio (formerly known as Google Data Studio), thanks to the new data blending features. Now, it is time for a first tip to leverage them and built…
Read moreThe Looker Studio Google Data Studio team has just released a highly anticipated new feature paving the way for a lot of amazing possibilities about data manipulation & preparation: A new data blending engine with join types (inner, outer, right…
Read moreThe Looker Studio (ex Google Data Studio) calculated field below extracts the value of a specific query parameter and returns it as a text / string.
Read moreBuilding a statistics annual report is a nice exercise for challenging the way to display metric values comparison over a granularity of time inside our data visualisation tool. We could decide to use the default available feature of the tool,…
Read moreNeed to access to selected date range and related time repository Most of data sources and related APIs provide rows of dated data only if the requested data are available (in other words, when the combination of all requested fields…
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 Google Data Studio team has just released amazing new features about the navigation and pages management of your reports: Report makers get a new experience – as editors – for pages creation & management, smoother than before and saving…
Read moreTo fit to columns width in table charts or axis size, truncating long texts at the right – like proposed inside Looker Studio – is not always the best visualisation solution for dimension values. On the other hand, the Looker…
Read moreData label is an optimized solution to avoid the use of chart legend, putting directly the right and short information inside your chart. But sometimes we face constraints and limitation for customization inside Looker Studio (formerly known as Google Data…
Read moreOf course, nothing is better than getting cleaned, organized and grouped data to build beautiful dashboards with Google Data Studio and other data viz tools. But messy data is also our daily lives. At some point (the best reason), because…
Read moreThe purpose of this article is not to debate about the right cases & visualisation opportunities to use controversial pie charts or donut charts. This post is just made to address a simple need 🙂 Through this tip, we will…
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 moreNeed a freelance analytics expert or a Google Data Studio consultant?
