As mentioned in my last Google Analytics Unravelled blog this next instalment is about searching and filtering reports. There’s a number of ways to do this in a number of places but we’ll break down some of these here.

Searching within a standard report

This is probably the most common kind of search or filter you will perform as these are in every aspect of analytics.

In most reports in analytics there’s a search box with accompanying magnifying glass logo just under the main graph (shown below)

Searching in Analytics

This allows you to search for a specific thing by name, for example in the keywords report a specific term or in the content reports all pages which contain a specific word.

Next to these search boxes is a link called “advanced” this enables you to search in more detail or to perform searches on different dimensions. You can also perform negative searches (where any result does not contain your search query). You can also use some regex in here.

The below search box shows an advanced search in the content report.

Refining searches in Analytics

On the left you can change the search from “Include” (which is default) to “Exclude”, to remove certain things from the results.

In the middle you can see the Dimension which is currently set to Page – however you can change this to any other dimension you want.

Then the next box allows you to choose what type of search, the default here is “Containing”.

The final box is the box where you put the actual thing you are looking for (such as “widget” in this case).

You can then, if you need to add another Dimension or Metric. This is Added as an AND to your query so in the below search we are looking for all pages which contain “Widget” in the URI AND have received greater than 100 pageviews in the given time period.

Refining Search Metrics and Dimensions

As discussed in the last Google Analytics Unravelled you can also add filters to Custom Reports. I didn’t go into much detail with that in the last blog so as we are talking about filters now, here’s an example filter on a custom report

Filtering a custom report

This custom report, like the one’s in my last blog, shows you the number of visits and conversions but this time we’ve looked at it by Source. In the Filter I’ve added a filter which only shows Organic visits, so my report now shows me the name of the search engine which has driven traffic, the number of visits and completed goals.

Again you can add additional Dimensions to this filter and again these will be AND filters. So you could filter by Organic Visits (as we’ve done above) AND by the landing page – in the below example we’ve shown Organic search engine visits and traffic which has landed on any pages within the Blog folder on a site.

Double Filter in Google Analytics

You can also filter all of the traffic from to the site using a profile filter, but we’ll deal with this when we look at profiles later in the series as there’s a few things to the take into account when working with profiles.

I hope this latest blog has helped you search through your analytics in more detail to get more from your data.

Happy Analysing and I’ll see you next time.