Analytics
2.5K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

(other) in the queries

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello! In Analytics dashboard (search console/queries) a large number of queries relates to (other)

Is it possible to know these queries and fix it somehow?

 

(other) in the queries

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

You can refer to this help article. Essentially, the number of rows (cardinality) in a report is limited to 50k (or 75k for Analytics 360). When over this number, all remaining values are shown as a single entry: (other).

 

One possible way to work around that is to reduce the date range - if within a day you don't have more than 50k different search queries, you will be able to see all values.

 

 

In order to get the complete list you will have to extract the data day by day from GA, store it somewhere, and create your own report. I suspect Data Studio also has a row limit for a given table. Possible solutions are:

- Go directly in Search Console / Search Analytics

- Build your own API requests, store in Google Sheet

- Do a Big Query request and use Data Studio if you are using Analytics 360

- Use Analytics Canvas "partitionning" ability, store in Tableau Extract, use Tableau Desktop to sophisticated analysis

 

Have fun! Smiley Happy

(other) in the queries

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

same problem here. I am not getting the "Other" queries. Diwali wallpapers 2017