AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.3K members online now
5.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Can I extract string from dimension ?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Can text data be extracted from a dimension field and be used as a text ?

 

Use case: Display the customer name on a report based on a list of customer names

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Anton B
December 2016

Can I extract string from dimension ?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Anton B,

 

You could extract text from a dimension using REGEXP_EXTRACT, but you can't currently display this on your report simply as text. You may be able to use a data table and style it to your requirements.

 

Hope this helps!

Ben

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Anton B
December 2016

Can I extract string from dimension ?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Anton B,

 

You could extract text from a dimension using REGEXP_EXTRACT, but you can't currently display this on your report simply as text. You may be able to use a data table and style it to your requirements.

 

Hope this helps!

Ben

Can I extract string from dimension ?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Ben, that worked - good work around!