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
1.5K members online now
1.5K 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 2017

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 2017

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