How to use the Data Studio Case Function
Вставка
- Опубліковано 2 лип 2024
- The Case Function is one of the most advanced and most useful functions in Google Data Studio. In today’s lesson, Ahmad is here to give us a tutorial on how we can use the Case statement in building our dashboards and create calculated fields.
OUTLINE:
0:00 - Introduction
0:10 - What are Functions in Data Studio?
0:53 - The CASE Function Explained
1:02 - Use Case: Showing Traffic & Conversions by Weekdays vs. Weekend
10:25 - Logical Operators
11:52 - "in" Case Statement
12:35 - Regular Expressions
🔗 Links:
Google Data Studio datastudio.google.com
Ahmads website Siavak siavak.com/
🎓 Measure Masters Membership: measureschool.com/measure-mas...
❓ Take Our GA4 Quiz: measureschool.com/google-anal...
FREE Tag Manager Course: measureschool.com/products/fr...
FREE Analytics Course: measureschool.com/products/fr...
🎓 Measure Masters Membership: measureschool.com/products/me...
🔀 GTM Copy Paste - Our Chrome extension chrome.google.com/webstore/de...
🔴 Attend the next FREE live workshop: measureschool.com/workshop/ms...
📋 More than an Audit - Get Your Google Analytics Roadmap: measureschool.com/services/th...
🚀 Hire us: measureschool.com/services/?u...
📚 Recommended Measure Books: kit.co/Measureschool/recommen...
📷 Gear we used to produce this video: kit.co/Measureschool/measures...
📡 Our Live Streaming Software: restream.io/join/YXLM2
👍 FOLLOW US
Facebook: / measureschool
Twitter: / measureschool
LinkedIn: / measureschool - Наука та технологія
THANK YOU SO MUCH I'VE BEEN SEARCHING A TUTORIAL FOR THIS LIKE CRAZY THANK U THANK U THANK U
It's also useful to recreate custom grouping channels in Data Studio.
Using the "CASE WHEN" and "REGEXP_MATCH" functions as well as the "AND", "OR", "NOT" operators, you can pretty much do anything :)
Fentastic. it helped me a lot.
Very useful tutorial! How do we calculate the 10 top increasing average positions and top 10 decreasing positions through search console data in Data Studio?
Very useful! I have a question: I see that the "Avg. Order Value" metric values are added after the grouping. Is there a way to average them instead? Thanks!
Great tutorial! I was trying to find drop off rate between two filter (or segment ) data (certain urls). But i couldn’t firgure out how? Do you guys have any suggestionsz for me? Thanks!
Excellent!!!!
:)
Good one
I'm very glad to have learned MySQL because most of it is compatible with calculated fields. Where I struggle is to create a median value (ex: median order value) Any tips on how to do it? Thanks for sharing
Awesomeness
HI! I want to do what you did in this vid for a range of numbers. Meaning group my data via the Domain Authority range of: 0-9, 10-19, 20-29, 30-39 etc.. up to 100. Based on this example.. my formula would be rather long. Then again, is there is a solution for this? Thanks, I'll keep at it meanwhile
I did a Case When for items in a Category but when I run the report I get a No Data Message in the score card. I just want to add up certain Category Items like you did for Days of the week and put them under a group but I also need the values to bee added up. I get a No Data message, what should I try?
How to set the default content of table is based on user input?.meaning the table is empty before the input control is fill and other user cannot see the detail until the input is match
Can you use Case when Like? Like you can in SQL/Bigquery?
You have placed fixed values for week names in your calculated field, but that data is based on the end user's Google account set language. So if I were to share this with a Norwegian client, he would have had 'Mandag' instead of 'Monday' because he had his Google Account language set to Norwegian. Does that mean I have to do a whole table of every possible language combination for all 7 days of the week?
unfortunately yes.
there is a workaround this, just add weekday function and do the case function on the week day number like sunday is 1 and monday is 2
One that drives me crazy is the sort of misuse of calculated field....you have calculated dimensions and calculated facts or metrics. I think that differentiation would help a lot of new comers to distinguish between dealing with text formulas and arithmetic
Help!!! I an trying to show growth of sales achievement year to year. My data is as
China Sale Year 2018 = 20,123
China Sale Year 2019 = 22,345
Russia Sale Year 2018= 1500
Russia sale year 2019= 1670
Now i need to show the growth in percentage % ,
How i can do this calculation in Google Data Studio Matrics ?
no need to post twice
Is it possible to use control like a dropdown im CASE?
no, not right now
How to use CASE statement when I need to do this.
WHEN Avg(Field X) < 500 THEN "Low"
WHEN Avg(Field X) < 1000 THEN "Medium"
WHEN Avg(Field X) >= 1000 THEN "High"
I used another calculated field for AVG(X) and used that field here, but it is preventing me to use text as a result saying "Only numeric literals are allowed if aggregated fields are used in CASE"
same problem! WHEN a VALUE is LOWER THAN > then "Low"
no answer at all yet? thanks buddy!
Would this work?
CASE
WHEN Day of Week Name IN("Saturday","Sunday") THEN "Weekend"
ELSE "Weekday"
END
Really nice tutorial but when we converted tables to two rows the values got added rather than taking average of days
That's because they did it incorrectly. You likely followed their instructions perfectly, but the way they did it will give you inaccurate data every time.
This is like SQL
ahmad volume is waaay toooo looooooooow
thanks for letting us know... will work on that next time
Thanks for the feedback Mohamed, I'll make sure to fix it next time.