Skip to content
    Moz logo Menu open Menu close
    • Products
      • Moz Pro
      • Moz Pro Home
      • Moz Local
      • Moz Local Home
      • STAT
      • Moz API
      • Moz API Home
      • Compare SEO Products
      • Moz Data
    • Free SEO Tools
      • Domain Analysis
      • Keyword Explorer
      • Link Explorer
      • Competitive Research
      • MozBar
      • More Free SEO Tools
    • Learn SEO
      • Beginner's Guide to SEO
      • SEO Learning Center
      • Moz Academy
      • SEO Q&A
      • Webinars, Whitepapers, & Guides
    • Blog
    • Why Moz
      • Agency Solutions
      • Enterprise Solutions
      • Small Business Solutions
      • Case Studies
      • The Moz Story
      • New Releases
    • Log in
    • Log out
    • Products
      • Moz Pro

        Your all-in-one suite of SEO essentials.

      • Moz Local

        Raise your local SEO visibility with complete local SEO management.

      • STAT

        SERP tracking and analytics for enterprise SEO experts.

      • Moz API

        Power your SEO with our index of over 44 trillion links.

      • Compare SEO Products

        See which Moz SEO solution best meets your business needs.

      • Moz Data

        Power your SEO strategy & AI models with custom data solutions.

      NEW Keyword Suggestions by Topic
      Moz Pro

      NEW Keyword Suggestions by Topic

      Learn more
    • Free SEO Tools
      • Domain Analysis

        Get top competitive SEO metrics like DA, top pages and more.

      • Keyword Explorer

        Find traffic-driving keywords with our 1.25 billion+ keyword index.

      • Link Explorer

        Explore over 40 trillion links for powerful backlink data.

      • Competitive Research

        Uncover valuable insights on your organic search competitors.

      • MozBar

        See top SEO metrics for free as you browse the web.

      • More Free SEO Tools

        Explore all the free SEO tools Moz has to offer.

      What is your Brand Authority?
      Moz

      What is your Brand Authority?

      Check yours now
    • Learn SEO
      • Beginner's Guide to SEO

        The #1 most popular introduction to SEO, trusted by millions.

      • SEO Learning Center

        Broaden your knowledge with SEO resources for all skill levels.

      • On-Demand Webinars

        Learn modern SEO best practices from industry experts.

      • How-To Guides

        Step-by-step guides to search success from the authority on SEO.

      • Moz Academy

        Upskill and get certified with on-demand courses & certifications.

      • SEO Q&A

        Insights & discussions from an SEO community of 500,000+.

      Unlock flexible pricing & new endpoints
      Moz API

      Unlock flexible pricing & new endpoints

      Find your plan
    • Blog
    • Why Moz
      • Small Business Solutions

        Uncover insights to make smarter marketing decisions in less time.

      • Agency Solutions

        Earn & keep valuable clients with unparalleled data & insights.

      • Enterprise Solutions

        Gain a competitive edge in the ever-changing world of search.

      • The Moz Story

        Moz was the first & remains the most trusted SEO company.

      • Case Studies

        Explore how Moz drives ROI with a proven track record of success.

      • New Releases

        Get the scoop on the latest and greatest from Moz.

      Surface actionable competitive intel
      New Feature

      Surface actionable competitive intel

      Learn More
    • Log in
      • Moz Pro
      • Moz Local
      • Moz Local Dashboard
      • Moz API
      • Moz API Dashboard
      • Moz Academy
    • Avatar
      • Moz Home
      • Notifications
      • Account & Billing
      • Manage Users
      • Community Profile
      • My Q&A
      • My Videos
      • Log Out

    The Moz Q&A Forum

    • Forum
    • Questions
    • Users
    • Ask the Community

    Welcome to the Q&A Forum

    Browse the forum for helpful insights and fresh discussions about all things SEO.

    1. Home
    2. Research & Trends
    3. Algorithm Updates
    4. How to do effective keyword research with categories and subcategories?

    Moz Q&A is closed.

    After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.

    How to do effective keyword research with categories and subcategories?

    Algorithm Updates
    2
    2
    909
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as question
    Log in to reply
    This topic has been deleted. Only users with question management privileges can see it.
    • Eric_S
      Eric_S last edited by

      Hi all,

      I'm trying to breakdown some SEO 101 tips and start from scratch. Starting with Keywords!

      I would like to audit our site for main keywords, grouping them in categories and subcategories. My questions are:

      1. Is it possible to see where we rank on google AND search trends of visits to our site?
      2. What is a good method or structure to document (excel?) 
      3. What analysis can be made from finding the results of these keywords and how can I make use of this?

      As a beginner your help is much appreciated!!

      1 Reply Last reply Reply Quote 2
      • lydiagilbertson
        lydiagilbertson last edited by

        Hey Eric_S,

        Glad to hear you're starting the SEO 101 journey.

        1. You can view which keywords your site currently ranks for on a domain level or a page level through using the MOZ keyword explorer tool, selecting either "domain" or "page" and inputting the URL into the tool. It should then show you a list of all of the keywords and their volumes.  This can also be done using tools like SEMrush or AHREFS.

        In order to view the search traffic on your site, you will have to look at its Google Analytics data, or any other tracking program you may be utilizing and sort the data to find out the number of users that come to your site via organic search. (This is a little vague, and will vary depending on which program you're using for analytics, so feel free to ask for clarification or do further program-specific research.)

        2. Excel or google sheets both work well for keyword documents.

        3.  There are a lot of different analysis that can be made by finding the keywords you currently rank for. You can find keywords with higher volumes that you would like to rank higher for, and try to re target pages to achieve this.

        Simply having a keyword mapping document outlining the targeted keyword for each page can also be useful when writing things such as titles and h1s on a page. It really depends on your goal.

        I hope this was helpful!

        Lydia

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        Got a burning SEO question?

        Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.


        Start my free trial


        Browse Questions

        Explore more categories

        • Moz Tools

          Chat with the community about the Moz tools.

        • SEO Tactics

          Discuss the SEO process with fellow marketers

        • Community

          Discuss industry events, jobs, and news!

        • Digital Marketing

          Chat about tactics outside of SEO

        • Research & Trends

          Dive into research and trends in the search industry.

        • Support

          Connect on product support and feature requests.

        • See all categories

        Related Questions

        • rwat

          Can 'Jump link'/'Anchor tag' urls rank in Google for keywords?

          E.g. www.website.com/page/#keyword-anchor-text Where the part after the # is a section of the page you can jump to, and the title of that section is a secondary keyword you want the page to rank for?

          Algorithm Updates | | rwat
          0
        • Eyah

          Exact Keywords Domain name

          Hello everyone!, I would love to have your opinion on this matter. I am working on a company e-commerce site; these guys would like to change their domain name AND their company name, so the most logical thing that came to mind was to name the domain after the company name. However, they also bought in the past a domain that have the exact keyword they would like to rank for. I know that keywords in the URL are not as important as they used to be in the past, but nonetheless when I do a Google search for those keywords, 3 domains out of 10 on the first page are slight variations of those same keywords, meaning that they might have a really good domain name (also the other result are government, medical stuff and so on). And, no matter how many times I have read that keywords in the URL are not so important anymore, I still see a lot of sites ranking also because of their domain name (well at least outside the US) So, my question here is: would it be better for them to use the exact match keyword-domain name or should they use their company name for their new site? Or some sort combination of the two? (the keyword-domain that in some way points also to the brand domain). Thanks for your opinions on this; really appreciate it! Cheers

          Algorithm Updates | | Eyah
          0
        • vmialik

          I thought META KEYWORDS tag was dead?

          http://www.wpkube.com/wordpress-seo-plugin/ this article just came out as a one of the many guides to Yoast's Wordpress SEO.  I am surprised it mentioned: Use meta keywords tag: Google reportedly doesn’t use the keywords that your enter for your posts but as Google isn’t the only show in town, you might want to check this box.Recommendation: check I stopped using meta keywords tag because Google doesn't use it any more, plus if you are in a competitive field by using keywords you are giving free keyword research to your competitors? Does any one still use meta keywords here? If so why? Google doesn't use keyword tags, has anyone experienced a dis-benefit to meta-keywords tag from Google ie. dropped rankings etc.?

          Algorithm Updates | | vmialik
          2
        • optimalwebinc

          Does Word Order Matter in Local Keywords?

          We do a lot of local SEO, and we're wondering if it's better to target "keyword location" or "location keyword"? Does it affect ranking and keyword difficulty if we're trying to rank for "plumbing appleton" or "appleton plumbing"? Any insight would be great.

          Algorithm Updates | | optimalwebinc
          0
        • McTaggart

          Keyword density and meta tags

          Hi, I've just checked the number of keywords appearing on my website's pages. On some of them the keyword density was way too high (7-10%) if you included the meta tags, but all under 3.5% if I didn't include the keywords and description meta tags. So my question is - when looking at number of keywords used per page, do I have to worry about what's in those meta tags? Do the keywords in there count towards keyword density / number of keywords per page? Thanks, Luke

          Algorithm Updates | | McTaggart
          0
        • sellonline123

          To use the same content just changing the keywords could be seen as duplicate content?

          I want to offer the same service or product in many different cities, so instead of creating a new content for each city what I want to do it to copy the content already created for the product and service of a city  and then change the name of the city and create a new url inside my website for each city. for example let say I sell handmade rings in the USA, but I want o target each principal city in the USA, so I have want to have a unque url for ecxh city so for example for Miami I want to have www.mydomain.com/handmade-rings-miami and for LA the url would be www.mydomain.com/handmade-rings-la Can I have the same content talking about the handmade rings and just change the keywords and key phrases? or this will count as a duplicate content? content: TITLE: Miami Handmade Rings URL :www.mydomain.com/handmade-rings-miami Shop Now handmade rings in Miami  in our online store and get a special discount in Miami purchases over $50 and also get free shipping on Miami Local address... See what our Miami handmade rings clients say about our products.... TITLE: LA Handmade Rings URL: www.mydomain.com/handmade-rings-la Shop Now handmade rings in LA  in our online store and get a special discount in LA purchases over $50 and also get free shipping on LA Local address... See what our LA handmade rings clients say about our products.... There are more than 100 location in the country I want to do this, so that is why I want to copy paste and replace.. Thanks in advance, David Orion

          Algorithm Updates | | sellonline123
          0
        • MichaelWeisbaum

          Is there a way to pull historical rankings for a keyword?

          I have someone who's come to me and said that they have lost all of their organic keyword rankings.  They did launch a site redesign a few months back so that could be a reason as to why.  But after looking at the site, link profile, etc.  It doesn't look like they could have been ranking for the terms they say they were.  They have never implemented any SEO on their sites btw.  I did not build this site and have not done any SEO, they are coming to me to solve the problem.  I did notice in SEM rush that a couple months ago they were ranking organically for more terms (20 in July vs. 5 now), so they did lose some.  Is there any way to see what terms they WERE ranking for?

          Algorithm Updates | | MichaelWeisbaum
          0
        • 360ryan

          Keyword Research for Real Estate Industry

          I just finished reading the Beginners Guide to SEO at SEOMoz and joined as a Pro Member.  I have created a campaign for my new SEO project and feel like I have a good understanding now of on-page optimization.  I am going to start fixing title tags and on page content for our top 50 pages and start a new campaign to go after some keywords.  Our website is 360dwellings. I am struggling to determine what the best keywords are for us to target.  Right now our primary markets are Denver and San Diego, we also display listings for all of Colorado as well. We had originally gone after competitive keywords like "Denver Homes for Sale".  What I am learning is that even ranking bottom of page one for that term doesn't bring a ton of traffic. Meanwhile, we rank well for a lot of niche content like "5280 best neighborhoods" "Denver Lofts for Sale" and "Denver Neighborhood Map". My questions is do we completely abandon going after big keywords like 'Denver CO Homes for Sale", and 'Denver Real Estate" and go as far as removing them from title tags?  We have pages for every Denver neighborhood like Park Hill and the Highlands, but there is no search data for these searches in Google Keywords.  My gut says that if each of those pages ranked for terms like "Denver Highlands Neighborhood Homes for Sale" that it would bring good targeted traffic.  Does anyone know of search terms for Real Estate that are low competition but have some search volume? Thanks!

          Algorithm Updates | | 360ryan
          0

        Get started with Moz Pro!

        Unlock the power of advanced SEO tools and data-driven insights.

        Start my free trial
        Products
        • Moz Pro
        • Moz Local
        • Moz API
        • Moz Data
        • STAT
        • Product Updates
        Moz Solutions
        • SMB Solutions
        • Agency Solutions
        • Enterprise Solutions
        Free SEO Tools
        • Domain Authority Checker
        • Link Explorer
        • Keyword Explorer
        • Competitive Research
        • Brand Authority Checker
        • MozBar Extension
        • MozCast
        Resources
        • Blog
        • SEO Learning Center
        • Help Hub
        • Beginner's Guide to SEO
        • How-to Guides
        • Moz Academy
        • API Docs
        About Moz
        • About
        • Team
        • Careers
        • Contact
        Why Moz
        • Case Studies
        • Testimonials
        Get Involved
        • Become an Affiliate
        • MozCon
        • Webinars
        • Practical Marketer Series
        • MozPod
        Connect with us

        Contact the Help team

        Join our newsletter
        Moz logo
        © 2021 - 2025 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
        • Accessibility
        • Terms of Use
        • Privacy

        Looks like your connection to Moz was lost, please wait while we try to reconnect.