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

Google Data Studio: Filter empty Queries

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

I have an issue regarding Google Data Studio by using Search Console data.

 

Beneath you see a table with Search Console data (filtered by a landing page). Used dimension "Query" and selected metrics are "URL Clicks", "Impressions" and "URL CTR".

 

But there are entries where no queries are displayed (ie. row 2 and 3, row 5, row 8,...).

 

How is it possible to filter the rows, where no query is displayed for?

The table should only show the metrics for (non-empty) queries.

data-studio-no-queries.jpgNo Query but metrics (i.e. Clicks, Impressions, etc.) visible

 

I hope anybody can help me on this!

 

Thanks in advance.

BR,

Philipp

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Krone M
June

Google Data Studio: Filter empty Queries

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I have a solution for this!

 

It's possible to use [EXCLUDE] - Field: [Query] - [IS EQUAL =]

If you don't fill in anything the empty fields get filtered.

 

Thanks anyway for your help! Smiley Happy

 

View solution in original post

Google Data Studio: Filter empty Queries

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi,

If I understood well you can create a filter, select Exclude, field="Query", IS NULL

Regards

Google Data Studio: Filter empty Queries

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Luis,

 

thanks for your quick response.

I tried the mentioned filter [exclude] [Query] "is null" already.

Unfortunately this doesn't work.

 

Maybe you have any other advice? Smiley Happy

 

Thanks in advance!

Marked as Best Answer.
Solution
Accepted by topic author Krone M
June

Google Data Studio: Filter empty Queries

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I have a solution for this!

 

It's possible to use [EXCLUDE] - Field: [Query] - [IS EQUAL =]

If you don't fill in anything the empty fields get filtered.

 

Thanks anyway for your help! Smiley Happy

 

Google Data Studio: Filter empty Queries

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Does anybody now to what it corresponds ? 
I got the same empty row in Auction Insight and I understood that it was actually my website shown as empty. But I can get what is the empty in data from search console ... 
Cheers
Philippe