Internet Marketing Driver

  • GSQi Home
  • About Glenn Gabe
  • SEO Services
    • Algorithm Update Recovery
    • Technical SEO Audits
    • Website Redesigns and Site Migrations
    • SEO Training
  • Blog
    • Web Stories
  • Contact GSQi

How To Create a Custom Report in Google Analytics by Customizing a Standard Report [Tutorial]

March 20, 2012 By Glenn Gabe

Share
Tweet
Share
Email
17 Shares

Custom Reports in Google Analytics

Custom reports in Google Analytics are incredibly powerful.They enable you to tailor reporting, based on your own business, your own conversion goals, key metrics, etc.The problem is that custom reports can be confusing to create. You have metric drilldowns, dimension groups, report views, filters, etc. If you aren’t familiar with creating custom reports, the interface could be daunting. That said, you shouldn’t give up trying to create custom reports! Again, they can be very powerful for analyzing traffic.

In this post, I’m going to walk you through creating a custom report that displays organic search traffic from mobile devices. The report will also enable you to view those visits by location. It’s a nifty custom report for any local business. The report lets you quickly view top keywords leading to your site via organic search (mobile traffic), but also lets you view how many of those visits are from potential buyers (people located near your business).

In addition, Google recently released functionality for customizing a standard report versus having to create every custom report from scratch. This is a great option if you are new to custom reports and want to tailor some of the existing reports in Google Analytics to fit your needs.

Creating a Custom Report from a Standard Report
As I mentioned earlier, we’ll start with a standard report in Google Analytics and tailor it to meet our goals. Since we are going to create a report showing organic search from mobile devices, let’s start with the Mobile Overview report and customize it to display:

  • Organic keywords leading to the site (mobile traffic).
  • The region those visits are from (i.e. states).
  • The cities within those regions that visits are coming from.
  • The mobile operating system from those visits (android, iphone, etc.)

The goal of the report is to know the organic keywords leading to the site from mobile visits, and how many of those visits are from potential customers (people located near your business).

How to Create the Custom Report (from a Standard Report)

1. Open up Google Analytics, click the “Audience” tab, and then expand the “Mobile” link in the left side navigation. Click the “Overview” link to view the Mobile Overview report.

Accessing the Mobile Overview Report in Google Analytics

2. Click the “Customize” link in the action bar of the report. This will enable you to customize this report for your own needs (by creating a custom report based on this standard report). Note, not all standard reports can be customized this way. Tabular reports can be customized this way, but you will find other reports within GA that cannot be converted to custom reports:

Customizing a Standard Report in Google Analytics

3. When you click “customize”, the standard report will be loaded into “report builder”. The initial view will show you the current report mapped out already in report builder. Then you can tailor the various elements, based on what you are trying to achieve with your own custom report.

Report Builder in Google Analytics

4. You can keep the current metric groups if you want. If you ever want to go back and customize the metric groups, you can by editing the custom report. For example, you definitely want to set up various conversion goals and events so you can better understand quality traffic. Once you do, you can add them to your metric groups so you can view performance by traffic in your custom report.

5. Under dimension drilldowns, you will only see “Mobile” listed. Adding more dimensions will enable you to drill into each level to find more data. As I explained above, we want to drill into mobile traffic to reveal the organic keywords leading to the site. Then we want to view location by region and state. So, let’s add those additional dimensions to our report.

Adding Dimensions to a Custom Report in Google Analytics

6. Click the “Add Dimension” box in dimension drilldowns and select “Keyword” from the “Advertising” list.

Adding More Dimensions to a Custom Report in Google Analytics

7. Next, add more dimensions to your report. Click the “Add Dimension” box again, and include the “Region” dimension from the “Visitors” list. After adding “Region”, you should go through the same process to add another dimension for “City”.

Adding Location Dimensions to a Custom Report in Google Analytics

8. Filter Your Traffic
The last step is to make sure the traffic is only from organic search. We only want to view mobile traffic from organic search, so we need to tell Google Analytics to filter that traffic for us. Click the “Add a Filter” box under the “Filters” category. Select the “Medium” dimension under the “Traffic Sources” list. Then select “include” from the first filter dropdown, leave “Medium” as the dimension, leave “Exact” in the third dropdown, and then enter “organic” in the text box (without quotes). See the screenshot below to follow along. This text tells Google Analytics to include all traffic that exactly matches “organic” as the medium. “Organic” is what’s listed for all organic search traffic.

Filtering Traffic in a Custom Report in Google Analytics

Congratulations! You just created a custom report, based on a standard report. Click “Save” at the bottom of the report and you’ll be taken to the functioning report in Google Analytics.

You can start drilling into the report by clicking “Yes” in the mobile report, which will reveal all organic keywords from mobile traffic. Then you can click any keyword to view the region those visits are from. If you click the region, you can view the cities within that region. Again, this report can help you identify mobile traffic from organic search, the keywords being searched for, and identify if these are potential customers (based on their proximity to your local business).

Bonus: Access the Custom Report Template
As an added bonus, I have shared the template for this custom report and you can access it by clicking the link below. Once you click the link, you can add this template to a Google Analytics profile and start using the report today. You can also analyze the report setup so you can work through creating similar custom reports. Click the following link to access the custom report for organic search visits from mobile devices.

Summary – Customize It!
I hope this post helped clear up some of the confusion associated with building custom reports in Google Analytics. I love that Google added the ability to customize standard reports, since that’s sometimes all you want to do… If you are new to custom reports, then I recommend starting with a standard report and then customizing that report to fit your needs. Going through that process should help you get more comfortable with working in report builder and could lead to more advanced custom reports. And that can all lead to advanced analysis of your traffic. Good luck.

GG

Share
Tweet
Share
Email
17 Shares

Filed Under: google, google-analytics, local-search, mobile, SEO, small-business, web-analytics

Comments

  1. Chad Agrawal says

    September 18, 2012 at 1:35 am

    Hey, thanks a lot for this tutorial. It really helped me as I needed a third dimension to identify a visitor who made a sale. Thank you :-)

    • Glenn Gabe says

      September 18, 2012 at 9:01 am

      Hey, no problem. I’m glad my post could help. Creating a custom report from a standard report is the quickest way to go.

  2. Idan says

    November 4, 2012 at 11:16 am

    Man, this post is AWESOME.
    Google analytics contains so many things we don’t use and are really great.

    Thank you.

    • Glenn Gabe says

      November 4, 2012 at 1:22 pm

      Hey, thanks Idan. I’m glad you found my post helpful. And you’re absolutely right. GA is packed with functionality and most people only use a fraction of it.

      That’s part of the reason I keep writing these tutorials. You should subscribe to my feed to keep up to date on my latest posts. Thanks again.

      GG

  3. Daniel says

    November 6, 2012 at 11:59 pm

    This is great. I love Google Analytic and they seriously need to send out an email every time they do something like this.

    So many functions that I have to dig through and because of that it is probably why I have yet to find this one.

    Thanks!

  4. Ashok Koparday says

    December 15, 2012 at 11:42 am

    Hi Glen,
    Greetings.

    You made creating Custom Report easy.
    Keyword ‘(not provided)’ shows maximum figure. How do we know these keywords?

    I shall keep learning.

    Best wishes,
    Dr. Ashok Koparday

  5. Glenn Gabe says

    December 17, 2012 at 10:15 am

    Thanks Ashok. I’m glad my post was helpful. Regarding “not provided”, it’s a huge problem that’s hard to address. I might end up writing a post detailing some strategies to employ to better understand that data. You should subscribe to my feed to make sure you know when new posts are published. Thanks again.

    GG

Connect with Glenn Gabe today!

RSS Latest Blog Posts

  • Continuous Scroll And The GSC Void: Did The Launch Of Continuous Scroll In Google’s Desktop Search Results Impact Impressions And Clicks? [Study]
  • How to analyze the impact of continuous scroll in Google’s desktop search results using Analytics Edge and the GSC API
  • Percent Human: A list of tools for detecting lower-quality AI content
  • True Destination – Demystifying the confusing, but often accurate, true destination url for redirects in Google Search Console’s coverage reporting
  • Google’s September 2022 Broad Core Product Reviews Update (BCPRU) – The complexity and confusion when major algorithm updates overlap
  • Google Multisearch – Exploring how “Searching outside the box” is being tracked in Google Search Console (GSC) and Google Analytics (GA)
  • Sitebulb Server – Technical Tips And Tricks For Setting Up A Powerful DIY Enterprise Crawler (On A Budget)
  • Google’s Helpful Content Update Introduces A New Site-wide Ranking Signal Targeting “Search engine-first Content”, and It’s Always Running
  • The Google May 2022 Broad Core Update – 5 micro-case studies that once again underscore the complexity of broad core algorithm updates
  • Amazing Search Experiments and New SERP Features In Google Land (2022 Edition)

Web Stories

  • Google's December 2021 Product Reviews Update - Key Findings
  • Google's April 2021 Product Reviews Update - Key Points For Site Owners and Affiliate Marketers
  • Google's New Page Experience Signal
  • Google's Disqus Indexing Bug
  • Learn more about Web Stories developed by Glenn Gabe

Archives

  • July 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • June 2009
  • May 2009
  • April 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • May 2007
  • April 2007
  • November 2006
  • October 2006
  • GSQi Home
  • About Glenn Gabe
  • SEO Services
  • Blog
  • Contact GSQi
Copyright © 2023 G-Squared Interactive LLC. All Rights Reserved. | Privacy Policy
This website uses cookies to improve your experience. Are you ok with this? You can always opt-out at a later time if you wish. Cookie settings ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience. You can read our privacy policy for more information.
Cookie Consent
Save & Accept