/datastudio/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
-
3/29/19
Filtering specific keywords from the search console database 0 Recommended Answers 6 Replies 13 Upvotes
1 Recommended Answer
$0 Recommended Answers
Last edited 3/29/19
Hey there!

I want to filter some specific keywords from the search console database.
So when I just filter one keyword everything works - but not when I ad a second or a third keyword in an "or".

For Example this works:
Include > Query > Equal to (=) > Keyword A
The Table shows the "Keyword A" with the KPI's

This doesn't work:
Include > Query > Equal to (=) > Keyword A
OR
Include > Query > Equal to (=) > Keyword B

The Table shows only: 
"Record configuration error 
No connection between Data Studio and the record possible."

I hope someone can help me.

Thanks =)
All Replies (6)
3/30/19
Try using regex match instead of OR. 
Alternatively, you could make individual rules if you are only trying to filter 2 or 3, and just add each one. 
You could also add a filter widget that lets end users filter for keywords with their own rules.
marked this as an answer
Helpful?
5/30/19
I had a case statement to show you but I guess this new forum doesn't allow it :(
marked this as an answer
Helpful?
7/22/19
Hi! Did you resolve this issue? If yes, how did you do it? I'm facing the same problem
marked this as an answer
Helpful?
8/11/19
I would 100% go with using regular expressions here. This would work - 
keyword1|keyword2|keyword3

The pipe - | - acts as the OR function. 

If you use 'regex contains' in the filtering option and apply your keywords then this will work.
marked this as an answer
Helpful?
8/20/19
I am aslo getting same issue, can any one help me?
marked this as an answer
Helpful?
9/5/19
This is the only current way to filter a large amount of specific queries or landing pages within a Google Data Studio report that I have found: 

- Add queries to a Google Sheet and make this into a data source.
- Blend this data with Google Search Console, Google Analytics or any other software.
- Make the keywords from both data sources the "key point" in the blended data source.
- Build out any data visualisations using the queries from your Google Sheets

This should display the performance for only the queries you include within the Google Sheet.
marked this as an answer
Helpful?
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/datastudio/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/datastudio/profile/0?hl=en