Kim van Dijk
Kim van Dijk

Reputation: 1

Keyword Labeling in Google Looker Studio

I want to label Google Search Console keywords in Google Looker Studio. I tried doing to do so using a CASE as well as an IF function:

CASE 
WHEN Average Position <= 10 THEN "High Ranking" 
WHEN Average Position <= 20 THEN "Mid Ranking" 
WHEN Average Position > 20 THEN "Low Ranking" 
END

and

IF(Average Position <= 10, "High Ranking", 
IF(Average Position <= 20, "Mid Ranking", 
"Low Ranking"))

Both result in a metric containing the values "High Ranking", "Mid Ranking" and "Low Ranking". However, I want this to be a dimension. Any suggestions?

Upvotes: 0

Views: 376

Answers (1)

Max_Stone
Max_Stone

Reputation: 649

I noticed an error in your logic and have corrected it below, This code works for me to create a dimension from a calculated field. Let me know if I have misunderstood your question.

   CASE 
   WHEN Average Position <= 10 THEN "High Ranking"
   WHEN Average Position > 10 AND Average Position < 21 THEN "Mid Ranking"
   WHEN Average Position >= 21 THEN "Low Ranking"
   END

Upvotes: 0

Related Questions