12.10. Creating Dynamic Dimensions with Parameters (Looker Studio Tutorial / Data Studio Training)
Vložit
- čas přidán 8. 09. 2024
- In this lesson, we will explore dynamic dimensions in Looker Studio. Typically, when you create a table or chart, you determine the dimensions and metrics, and the viewer has limited options to modify it. However, parameters allow you to give viewers the ability to change dimensions.
Looker Studio Certification:
When you're ready, take the final exam to test your knowledge and become a certified Looker Studio Expert →
lookerstudioma...
📩 lookerstudio.tips → Receive my weekly Looker Studio tips.
💬 lookerstudio.co... → Get help with Looker Studio.
🔔 Subscribe and turn on notifications so you don't miss the future lessons!
Consider a table that breaks down sessions by source. If you want to enable viewers to change the table from sessions by source to sessions by medium, campaign, or country, you can do that with parameters.
Learning Objectives
1. Understand the concept of dynamic dimensions in Looker Studio and its applications.
2. Learn how to create a dropdown menu using text-based parameters.
3. Utilize the `CASE` function to change the table dimensions based on user selection.
4. Create custom fields to implement dynamic dimensions in tables.
5. Develop techniques to change table titles based on the selected dimension.
Main Concepts and Topics
- *Dynamic dimensions:* Allowing users to change table dimensions using parameters.
- *Text-based parameters:* Used to create a dropdown menu with allowed values.
- *CASE function:* Changes the dimension in the table based on the selected value of the parameter.
- *Custom fields:* Required to create a table breakdown field that uses the `CASE` function.
- *Changing table titles:* Creating an additional table with no header or metric to display the selected dimension as the title.
*Creating the Dropdown Menu*
Start by creating a dropdown menu using a parameter called *breakdown*. It's a text-based parameter with five different values (by source, by medium, by campaign, by country, and by other dimensions you want to include). Text-based parameters with allowed values can be connected to a dropdown menu.
*Using the CASE Function*
Next, use the `CASE` function to change the dimension in the table based on the selected value of the parameter. For instance, when the parameter equals "by country," the dimension of the table should be "country." The `CASE` function looks at the value selected by the user and outputs the categories within different dimensions based on that value.
*Creating a Custom Field*
Create a custom field called table breakdown*. This field does not exist in Google Analytics, so it should be a custom field. The custom field will use the `CASE` function to output the appropriate dimension based on the value of the *breakdown parameter.
*Changing the Table Title*
To change the table title based on the selected dimension, create another table with no header, metric, or row numbers. The table will display the selected dimension as the title.
**Real-Life Example:**
Imagine you are a marketing analyst for an e-commerce website. By using dynamic dimensions, you can create a single table that allows your team to switch between dimensions such as sessions by source, medium, campaign, or country. This enables your team to quickly analyze different aspects of your marketing efforts, improving decision-making and saving time.
Hello Ahmad! To get the URL with the utm parameters from the previous video, I'm assuming we use the CASE function like you use in this example, right? TY
How can we show Grand Total for each row in Table/Pivot Visuals? There is a requirement of custom calculations.
Hi Ahmad, This is really useful, thanks! I found that when I have a table with a parameter to change the breakdown, if I added a comparison date range to the table, it breaks. Why would this be? Do you have any suggestions for making this work with a comparison period? Thanks.
Hi Carolyn,
For assistance and support with your questions and challenges in Looker Studio, please post in Looker Studio Community: facebook.com/groups/lookerstudiocommunity/
It’s a great place to ask your technical questions and connect with other Looker Studio users and experts. While I may not be able to respond to every query, other community members may be able to assist you!
Hello!
I am facing an issue in Looker Studio. I will appreciate if you can help me out in this.
I have created a table with names of companies in Column A and Boolean values under different columns for Rising Sales, Rising Profit and Rising Margins (in Column B, C and D respectively). Now, some companies will be satisfying more than one Boolean also.
How do I create a dropdown control with options for Rising Sales, Rising Profit and Rising Margin, such that I can choose more than one together?
I tried to do it by creating a custom filter using CASE function, but it gives me result for only Rising Sales. If I choose Rising Profit, it removes companies which have Rising Sales. Similarly, choosing Rising Margin removes companies with Rising Sales or Rising Profit.
CASE
WHEN Rising Sales then "Rising Sales"
WHEN Rising Profit then "Rising Profit"
WHEN Rising Margin then "Rising Margin"
else "None"
END
3
HI Ahmad, I want to create a text description which has dynamic text based on user filter selection on Google Data Studio. The text should highlight the filters selected by users currently and will change based on future selections. can you help me