Mehdi Oudjida, Freelance Digital Analytics Consultant
Looker Studio blog by Mehdi Oudjida Tips, Hacks and tutorials
Menu
Freelance analytics services Looker Studio Chrome extension
Custom reports

How to insert your marketing planning as part of Looker Studio trend charts

October 26, 2022 - by Mehdi Oudjida

Few 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 more
Custom reports

Interactive comparison of selected values from Google Looker Studio series charts

October 3, 2022 - by Mehdi Oudjida

Keeping 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 more
Custom reports

How to prepare data for overlap analysis with Venn diagram inside Google Data Studio

July 25, 2022 - by Mehdi Oudjida

I 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 more
Custom reports

How to create a funnel report with a single Google Data Studio table chart

June 23, 2022 - by Mehdi Oudjida

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 more
Data viz

How to display series name beside each series line of your Google Data Studio chart

May 11, 2022 - by Mehdi Oudjida

For 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 more
Calculated fields

Google Data Studio calculated field – Older date from a date field

May 3, 2022 - by Mehdi Oudjida

The Google Data Studio calculated field below returns the older date from a date dimension. The min date in other words. Explanations of the formula step by step Get the older date of the date field using MIN function that…

Read more
Calculated fields

Google Data Studio calculated field – Most recent date from a date field

May 3, 2022 - by Mehdi Oudjida

The Google Data Studio calculated field below returns the most recent date from a date dimension. The max date in other words. Explanations of the formula step by step Get the max Date of the date field using MAX function…

Read more
Custom reports

Waterfall chart with Google Data Studio basic features

April 22, 2022 - by Mehdi Oudjida

Waterfall 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 more
Calculated fields

Google Data Studio calculated field – File name from URL

March 25, 2022 - by Mehdi Oudjida

The Google Data Studio calculated field below returns the file name with the related extension from a field providing an absolute URL.

Read more
Tricks

Websites favicon as dynamic images for Google Data Studio reports

March 9, 2022 - by Mehdi Oudjida

Few 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 more
Data sources

How to mimic UNION ALL operator with Looker Studio and combine sets of data

February 22, 2022 - by Mehdi Oudjida

Last 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 more
Features

Data blending with Looker Studio – How to blend data using left, right, inner, outer and cross join

February 16, 2022 - by Mehdi Oudjida

The 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 more
Calculated fields

Google Data Studio calculated field – Extract query parameter value from URL

January 23, 2022 - by Mehdi Oudjida

The Google Data Studio calculated field below extracts the value of a specific query parameter and returns it as a text / string. Input Field corresponding to the URL / Page address with parameters (test / string) Example 1 –…

Read more
Data viz

Looker Studio year over year (YoY) metric comparison for analytics annual report

January 11, 2022 - by Mehdi Oudjida

Building 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 more
Data sources

How to reveal and leverage selected date range of Google Data Studio reports

December 7, 2021 - by Mehdi Oudjida

Need 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 more
Older posts
  • Categories

    • Advanced controls (4)
    • Calculated fields (7)
    • Custom reports (13)
    • Data sources (6)
    • Data viz (10)
    • Features (9)
    • Tricks (9)
  • Chrome extension for Looker Studio

    Looker Studio Companion - The Google Chrome Extension for Google Data Studio users
  • Data preparation

    Supermetrics to grab data from various sources, transform and prepare it for Google Data Studio viz.

    Supermetrics for Google Sheets
  • Recent Posts

    • How to insert your marketing planning as part of Looker Studio trend charts
    • Interactive comparison of selected values from Google Looker Studio series charts
    • How to prepare data for overlap analysis with Venn diagram inside Google Data Studio
    • How to create a funnel report with a single Google Data Studio table chart
    • How to display series name beside each series line of your Google Data Studio chart
  • Data Studio calculated fields

    • Google Data Studio calculated field – Remaining number of days until the end of the month
    • Google Data Studio calculated field – Extract query parameter value from URL
    • Google Data Studio calculated field – File name from URL
    • Google Data Studio calculated field – Older date from a date field
    • Google Data Studio calculated field – Most recent date from a date field
  • Freelance analytics services
  • Looker Studio Chrome extension
  • Contact
© 2023 Mehdi Oudjida. All Rights Reserved