Start learning with our library of video tutorials taught by experts. Get started

Google Analytics Essential Training (2010)

Sorting data with inline and advanced filters


From:

Google Analytics Essential Training (2010)

with Corey Koberg

Video: Sorting data with inline and advanced filters

Inline filters are a simple but powerful tool to allow us to quickly control and consolidate the data that we're analyzing in the data table and its graphs. Before we begin, let's talk about terminology. There are three primary types of filters; profile filters, inline filters, and advanced filters. If we take a look at the profile settings in the Filters tab, here we'll see some advanced profile filters that will restrict some of the data that we can get into the profiles. When we talk about inline or advanced filters, we're not talking about profile filters at all. Rather, we're talking about the filters at the top of the data table and the reports.
Expand all | Collapse all
  1. 6m 2s
    1. Welcome
      1m 13s
    2. How to get the most from this course
      3m 11s
    3. What's new in this update?
      1m 38s
  2. 5m 19s
    1. The pitfalls of hit counting and turning data into information
      3m 6s
    2. Web analytics: A tool and a process
      2m 13s
  3. 15m 30s
    1. Defining goals and conversions: Why do you have a web site?
      5m 40s
    2. Understanding data: Averages, segments, trends, and context
      1m 51s
    3. Introducing segments
      2m 38s
    4. Understanding trends and context
      5m 21s
  4. 11m 25s
    1. How does Google Analytics work?
      2m 18s
    2. Setting up an account
      2m 49s
    3. Installing tracking code on a site
      6m 18s
  5. 24m 20s
    1. Understanding accounts and profile administration
      6m 59s
    2. Navigating the reports and the Data Over Time chart
      4m 45s
    3. Selecting and comparing date ranges
      6m 50s
    4. Using annotations to make notes in data
      2m 30s
    5. Using the help tools
      3m 16s
  6. 24m 20s
    1. Viewing data in different formats (overview, tabular, pie, bar, compare to site)
      6m 10s
    2. Navigating data with site usage, goals, and e-commerce metrics
      9m 20s
    3. Sorting data with inline and advanced filters
      8m 50s
  7. 10m 26s
    1. Understanding the importance of segmentation in data analysis
      4m 40s
    2. Slicing data with dimensions
      5m 46s
  8. 7m 38s
    1. Why share data?
      1m 10s
    2. Managing user accounts and profiles
      4m 8s
    3. Emailing reports
      2m 20s
  9. 29m 12s
    1. Understanding who is visiting a site
      1m 20s
    2. Analyzing location data
      4m 52s
    3. Using language identification to segment users
      1m 35s
    4. Differentiating new users from returning users
      2m 1s
    5. Understanding visitor loyalty vs. recency
      4m 25s
    6. Comparing data according to visits, visitors, and page views
      2m 10s
    7. Sorting data by browser capabilities
      3m 56s
    8. Analyzing data from mobile browsers
      2m 34s
    9. Using flow visualization to see common paths
      6m 19s
  10. 23m 50s
    1. Linking an AdWords account to Google Analytics
      2m 46s
    2. Identifying campaigns and segmentation options
      5m 55s
    3. Using keyword reports
      1m 31s
    4. Fine-tuning your match type with the Matched Search Queries report
      3m 44s
    5. Optimizing traffic by time of day
      1m 37s
    6. Using the Destination URL report to identify landing pages
      1m 45s
    7. Identifying the best placement options for ads
      2m 0s
    8. Keyword positions
      4m 32s
  11. 40m 3s
    1. Understanding where site visitors come from
      2m 32s
    2. Analyzing the All Traffic Sources report
      2m 4s
    3. Identifying direct traffic
      2m 20s
    4. Identifying users who were referred to your site
      3m 9s
    5. Viewing search engine reports (overview, organic, and paid)
      4m 52s
    6. Introducing campaign tracking
      11m 17s
    7. Planning, creating, and logging a tracking strategy
      2m 58s
    8. Tracking offline campaigns
      7m 11s
    9. Finding data in a Campaign report
      3m 40s
  12. 36m 43s
    1. Analyzing top content by metrics and the navigation summary
      3m 29s
    2. Sorting top content according to page title
      3m 57s
    3. Understanding when to use content drilldown
      2m 25s
    4. Measuring the importance of top landing and top exit pages
      3m 41s
    5. Identifying slow-performing pages with the Site Speed report
      4m 6s
    6. Understanding the Site Search and Usage report
      3m 29s
    7. Analyzing the Search Terms and Search Term Refinement reports
      4m 12s
    8. Using the Site Search Pages report to understand how users search
      5m 19s
    9. Configuring Site Search
      6m 5s
  13. 33m 49s
    1. Understanding the Goal reports
      4m 24s
    2. Configuring goals
      9m 55s
    3. Understanding funnel visualization
      9m 48s
    4. Identifying value through E-commerce reports
      4m 35s
    5. Using goal flow to find detailed insights
      5m 7s
  14. 24m 25s
    1. Real-time data for time-sensitive analysis
      4m 21s
    2. Using intelligence alerts to flag important events
      8m 59s
    3. Creating custom intelligence alerts
      5m 48s
    4. Creating and customizing dashboards
      5m 17s
  15. 43s
    1. Goodbye
      43s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
Google Analytics Essential Training (2010)
4h 53m Beginner Oct 08, 2010 Updated Dec 20, 2011

Viewers: in countries Watching now:

In Google Analytics Essential Training, Corey Koberg shows how to use the Google web analytics platform to generate and evaluate information about the visitors to a web site, including data on site traffic, user behavior, and marketing effectiveness. This course covers the out-of-the-box functionality, from account creation to reporting fundamentals, and explains how to glean insights from the vast array of data available.

Topics include:
  • Setting up an account
  • Installing tracking code on a site
  • Reading the dashboard and understanding high-level metrics
  • Understanding how visitors use and navigate web site content
  • Analyzing visitor and traffic source reports
  • Tracking AdWords and other marketing campaigns
  • Planning and configuring goals
  • Utilizing segmentation for deeper analysis
  • Understanding the raw data and how it's collected
  • Selecting and comparing date ranges
  • Using flow visualization to see how visitors navigate through a site
  • Identifying slow-performing pages
  • Performing real-time analysis
  • Using annotations and other best practices
  • Configuring and analyzing internal site search
  • Determining the best report view to use
  • Navigating reports with tabs
  • Cleaning up data with inline filters
  • Sharing data and reports
Subjects:
Business Online Marketing Web Data Analysis Web Analytics SEO
Software:
Google Analytics
Author:
Corey Koberg

Sorting data with inline and advanced filters

Inline filters are a simple but powerful tool to allow us to quickly control and consolidate the data that we're analyzing in the data table and its graphs. Before we begin, let's talk about terminology. There are three primary types of filters; profile filters, inline filters, and advanced filters. If we take a look at the profile settings in the Filters tab, here we'll see some advanced profile filters that will restrict some of the data that we can get into the profiles. When we talk about inline or advanced filters, we're not talking about profile filters at all. Rather, we're talking about the filters at the top of the data table and the reports.

Let's take a look. As we move here to the Languages report, in the Visitors section, under Demographics, we can see all the different languages of people who are visiting our site. If I was interested in analyzing just the Spanish language visitors, I could click on es. The problem is that different browsers report Spanish in different ways, and I want to capture all the Spanish language users. So what I can do is come here to the filter box at the top of the table, and I can click on es, click the magnifying glass to run the filter, and this will capture all the different lines that contain es, whether it's just by itself, whether it's Spanish, whether it's going to be a Latin American, Caribbean, Mexican, etcetera.

From here, I'm able to evaluate them individually, and see how many visits came from each different version, but I can also see what the group represents as a whole. On the scorecard across the top, I can see the metrics for all of them summed together, and the data over time graph updates as well. So I can see here, there were 20,000 visits in total from Spanish users on my site, who stayed for an average of 2.9 pages per visit, 1 minute and 6 seconds, 92% of them were new visits, etcetera. There are tons of uses for this type of filtering inside these reports. Let's take a look at some more. Click on over to the All Traffic report inside the Traffic Sources tab.

Here, we see the different sources and mediums that bring traffic to the site. Maybe your question is, how many blogspot blogs are bringing traffic to your site? If we simply type in blogspot here in the filter box, hit Return, and what we'll see down here is a list of all the different blogspot blogs that are bringing traffic to my site, and the scorecard, and the data over time graph will update to reflect the overall aggregate numbers for those blogspots put together. If I am interested in individual blogspot blogs, I can look down here and see all the different metrics associated with each one of those blogs. Another possible example is, what if we were interested in the number of Apple devices sending traffic to our site? If I click on Visitors, and Mobile Devices, we can filter for Apple.

Type Apple into the search box, and what we're going to see is the data table down here is restricted to only things that contain Apple, and we can see individually which Apple products are bringing them, as well as the total amount that Apple is bring in to my site across the top. Let's head over to the organic search report to see what else we can do. This report under Traffic Sources > Sources > Search, and Organic is going to default to show the keywords that users search to find our site. When we talk about keywords that bring people to my site, we can break these down into two different kinds of keywords; keywords that indicate someone is already familiar with my site, my brand, or my company, and the more generic keywords, where someone was not necessarily familiar with my company at all, but was simply looking for some information, or a solution to their problem.

For example, if you typed in the word Google, or any derivative of that, you're probably already familiar with the company Google; you're not just looking for a generic search engine. Now, if you type in something like Google merchandise, you might not be looking for the Google Store specifically, but just a store that happens to sell Google stuff. In fact, you may not know such a thing as the Google Store even exists. When we're working on SEO for your site, most people tend to want to focus on these non-branded terms. These are the terms that are going to bring you net new visitors, and let's face it, if you're not ranking for your own name, then your SEO has other issues.

When we're ranking for some of these generic keywords, it can take a bit more effort, and we want to measure our progress using Google Analytics. To do this, we'll go over here next to the filter box, and we're going to click Advanced. This is going to drop down some more options to filter our data. For our purposes, we want to exclude keywords containing our brand name, Google, and click Apply. So we type in google, we're going to change Include to Exclude Keyword, and click Apply. Now, I've definitely got rid of my branded term of Google, but I've got a few more terms in this list that would qualify as branded terms, or people who are familiar with my brand.

For example, I see YouTube in here, in different spelling variations; I see Android. Those are things that have to do with my brand as well. So let's go back to the Advanced filter, and we have this ability to run multiple filters on here. We have an and operator. We can click this again; we can select a dimension of Keyword. I can choose to Exclude, and I can put in words containing things like -- now we have YouTube; we have some people who spelled YouTube with a space, and others, So I am just going to put tube in here in general, and that should cover most of those. Click Apply. Okay, now we look down through the list, and we still see some Android ones I need to take care of. We see Google misspelled. In fact, we even see Google up here in Cyrillic.

So one thing to not is that this is not going to do any type of translation, or cover languages. If you specifically want to include foreign language versions of this, then you're going to have to address those individually. I can come up here, and I can continue to add and ones down here. I can also change this to do something else; for those of you that are familiar with regular expressions, I can use the vertical pipe bar here to add additional words that I want to exclude. So in this case, I want tube, and gogle, and android, and we are going to apply that. I am going to increase the number of rows to 50, and we can look down through list, and look for a few other variations of ones with more Os, ones without the O; there's plenty of misspellings in here. We can look for Chrome, and other ones through here.

I can continue to add these through here, and build up my list of branded keywords that I want to exclude. Now, one important piece to note here for SEO purposes is this second result here: not provided. In 2011, Google decided that for any user who is logged into their Google account -- perhaps they logged in from Gmail, or a Google Plus account, and never logged out -- that they will automatically be redirected to a secure version of the Google search engine whenever they search. When this happens, the Google search engine will not pass individual search terms through to Web analyst tools like Google Analytics.

It's an unfortunate loss of data, but everyone faces the same challenge, as no tools can recover the data, even Google analytics. So it's not a branded term, but it may skew your data. So if we want to filter that one out, let's go back to edit our filter again. We're going to add a dimension, select Keyword, Exclude, Exactly matching, and type in not provided. Apply this, and we can see that our list can update to where the not provided keywords will not be included in our list.

Okay, so if we continue on in this fashion, we can weed out our branded terms, and continue to improve our list, but let's go ahead and take this list of non-branded search terms, and sort them by performance. Now, bounce rate is a good metric, so let's look for ones that have a low bounce rate. We can easily find this by sorting on the Bounce Rate column. We click on the Bounce Rate column; first it's going to show us the largest bounce rate. Click it again, and we'll see bounce rate sorted by the least. So this is what we want; terms that don't bounce at all.

Now, what we've got here is a list of non -branded terms that have a great bounce rate, and so we all know that they're very valuable; we should pour all of our marketing efforts into this list, right? Well, not quite. As you astute viewers have noticed, this is actually not valuable data at all. In fact, this is nearly junk data. Just because one person typed product.asp into here doesn't mean that this is the hot new keyword, and I should run out and tell my CPC folks to go nuts on that as a new keyword. When we talk about performance, we're really talking about performance in the context of a reasonable amount of visitors.

So let's use filters to turn that English, a reasonable amount of visitors, into data that we can put into Google Analytics. What I really want to see are just the ones that brought in, let's say, five or more visits; not these onesy, twosy ones that are simply anomalies. We are going to go back into our Advanced filter; we're going to add another row. We're going to select a metric, and we're going to select Visits, and we're going to say Greater than 4, so that will give us 5 or more visits. Click Apply, and now we can see this is going to update to show us ones that still have a good bounce rate, but have a reasonable amount of visits.

This list looks much better. You see we've now got some real contenders, and with a bit more massaging, we'll have a true list of our best keywords. This type of data filtering is essential when you're dealing with any kind of rate based metric, such as e-commerce conversion rate, goal conversion rate, bounce rate, etcetera. Another tip for this type of analysis is to expand your date range to get as much keyword data as possible. Advanced filters and inline filters are incredibly powerful tools you'll use over and over again in your analysis. You'll find advanced filters particularly powerful anytime you're sorting by a rate to strip out those cases with just a handful of visits.

Find answers to the most frequently asked questions about Google Analytics Essential Training (2010).


Expand all | Collapse all
Please wait...
Q: The course was updated on 12/19/11. Can you tell me what's changed?
A: Many movies were updated to reflect the changes in the Google Analytics user interface and new movies were added to the course as well, with topics including using flow visualization to see common paths, identifying slow-performing pages with the Site Speed Report, using goal flow to find detailed insights on funnels and conversion paths, analyzing real-time data for time-sensitive analysis, and fine-tuning match types with the Matched Search Queries report.
Q: Where can I learn more about internet marketing?
A: Discover more on this topic by visiting internet marketing on lynda.com.
Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Google Analytics Essential Training (2010).

Return to your organization's learning portal to continue training, or close this page.


OK

Course retiring soon

Google Analytics Essential Training (2010) will be retired from the lynda.com library on May 14, 2014. Training videos will no longer be available, but the course will still appear in your course history and certificates of completion. For updated training, check out the all new Google Analytics Essential Training coming soon to the lynda.com Online Training Library.


Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked

Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.