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
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 1
Explorer ✭ ✭ ✭

Hello everyone, I have a question regarding the presentation of report data on a dashboard - I am displaying on-site search data on a report alongside failed searches. Failed searches are identified by the prefix 'failedsearch|'. I have applied a filter to the 'top failed searches' grid which filters out only terms that have this prefix, which works fine, but I would like to know if it is possible to clean the results on the dashboard to hide/remove the 'failedsearch|' text?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Ben P
November 2016

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Yep, just create a custom dimension with the formula REPLACE(column name, 'failedsearch|', '')

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Ben P
November 2016

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Yep, just create a custom dimension with the formula REPLACE(column name, 'failedsearch|', '')

 

Cleaning report data on a dashboard

Explorer ✭ ✭ ✭
# 3
Explorer ✭ ✭ ✭

Excellent, thank you @Ad A!