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
      • MozCon
      • Webinars, Whitepapers, & Guides
    • Blog
    • Why Moz
      • Digital Marketers
      • Agency Solutions
      • Enterprise Solutions
      • Small Business Solutions
      • 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.

      NEW Keyword Suggestions by Topic
      Moz Pro

      NEW Keyword Suggestions by Topic

      Learn more
    • 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.

      • MozCon

        Save on Early Bird tickets and join us in London or New York City

      Unlock flexible pricing & new endpoints
      Moz API

      Unlock flexible pricing & new endpoints

      Find your plan
    • Blog
    • Why Moz
      • Digital Marketers

        Simplify SEO tasks to save time and grow your traffic.

      • 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.

      • 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. SEO Tactics
    3. Reporting & Analytics
    4. How to identify rising keywords in analytics?

    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 identify rising keywords in analytics?

    Reporting & Analytics
    4
    10
    1775
    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.
    • TheUniqueSEO
      TheUniqueSEO last edited by

      Hi Guys

      I just spotted in the Google Analytics > Traffic Sources > Search Engine Optimisation > Queries section a keyword that on the 27th Feb went from generating 35 impressions per day to 2000 impressions per day.

      This was down to people searching for a newly launched product.

      Does anyone know how I can identify any increases like this easily?  I only came across this by accident, and I am 1 month behind the times.  It would have been ideal to pick this up closer to the time so I could capitalise and write some great content on the topic.

      Thanks

      Paul

      1 Reply Last reply Reply Quote 0
      • MattAntonino
        MattAntonino @TheUniqueSEO last edited by

        I totally dorked up the cells in step 9 - I fixed that in my answer above.

        As far as the Step 10 - 11 thing, I don't think I did.  I think you skipped the second half of step 10. 😉  Here's my original text, with bold.


        1. Highlight the cells from H1 to H12.  Grab the black square in the bottom right of the border box.  Drag this selection down all the way to H2000.  **Copy all your cells from A1 to H2000 and paste values to remove any formulas.  We want just text now.  **

        ---------------------

        Instead of copying and paste values for Column H, I just said do the whole thing.  At this point you only want text so it makes sense.  I was going to edit but I think the correct step is already in there.

        1 Reply Last reply Reply Quote 0
        • MattAntonino
          MattAntonino @TheUniqueSEO last edited by

          😄  I'm glad you liked the answer.  Sometimes it's difficult to take the time to write up a long answer like that but once in awhile it just happens and comes out.  I had a feeling others may like being able to mess with that sort of data so why not, right? 🙂

          I'll write it up soon - I think I may do a bit on "playing with your food data in Excel."

          I'm going to go make a few edits to my post so it has all the right steps.  Thanks!  I see that I messed up my Bs and Hs.  After awhile I think I lost track of typing up each step and tried to recreate in my head what I had done. lol

          1 Reply Last reply Reply Quote 0
          • TheUniqueSEO
            TheUniqueSEO @MattAntonino last edited by

            Excellent, did it, got data, very happy.

            Just incase anyone else comes across this there is 1 correction to the above, and 1 missing step:

            1. To match keywords to their change line, follow this specifically.  In H4, type =B1  This should now say your keyword.  Manually type in a few of these, so go to B8 and insert the formula =B5, then do the same with B12.  The formula is =B9.  You should see three keywords in Column H.

            should be

            1. To match keywords to their change line, follow this specifically.  In H4, type =B1  This should now say your keyword.  Manually type in a few of these, so go to H8 and insert the formula =B5, then do the same with H12.  The formula is =B9.  You should see three keywords in Column H.

            So you only put this formula in Column H, referencing column B.

            Then, between Step 10 and 11 you need to copy column H and do Paste Values, otherwise when you sort in step 11 you will end up with #REF errors.

            This has yielded some excellent data for me to slice and dice.

            MattAntonino 1 Reply Last reply Reply Quote 0
            • TheUniqueSEO
              TheUniqueSEO @MattAntonino last edited by

              WOW!

              That is the most detailed response I have seen in a Q&A.  Thanks for going to so much detail.

              Definitely write this up as a YouMoz, as I have a feeling this would be a great interest to a lot of people, and could well get promoted to the main blog.

              Right, I'm off to fire up Analytics and Excel and see what I can see.

              This truly is brilliant.  Thanks so much.

              Keri, thanks for the heads up on the alerts blog post.  I have used alerts, but for some reason I just didn't think to use these to identify changing trends in keyword usage.  So I will give this a look also.

              Thanks Guys

              MattAntonino 1 Reply Last reply Reply Quote 1
              • KeriMorgret
                KeriMorgret @MattAntonino last edited by

                Ahh, the problem is that the OP changed jobs, and the new person removed those custom alerts. I hadn't realized that until just now. Thanks for letting me know, and I'll see if we can do anything to get it fixed.

                1 Reply Last reply Reply Quote 0
                • MattAntonino
                  MattAntonino @KeriMorgret last edited by

                  Thanks for the endorsement Keri! Appreciate that.

                  From the post you linked - it doesn't look like the Grab It link works with the new Analytics.  Those are great alerts to setup but maybe someone can write up a 2013 version.

                  TY!

                  KeriMorgret 1 Reply Last reply Reply Quote 0
                  • KeriMorgret
                    KeriMorgret @MattAntonino last edited by

                    Awesome response here! I'd also like to add we did have a great YouMoz post two years ago about essential alerts for GA that would email you when certain events happened. It's at http://www.seomoz.org/blog/7-essential-google-intelligence-custom-alerts-that-keep-me-sane.

                    MattAntonino 1 Reply Last reply Reply Quote 0
                    • MattAntonino
                      MattAntonino last edited by

                      Sure, you mostly care about ones that have already jumped up in impressions or clicks, right? I'm going to be very specific on the steps but this isn't as hard as it looks.


                      1. Go to Traffic Sources > Search Engine Optimization > Queries

                      2. Select a date range and then use "Compare to" and use "Previous Period."

                      3. Set Show Rows to 500.

                      4. Sort the table by Impressions.

                      5. Copy all the data from the table starting from "1. keyword" and finishing with the end of the table (last change%).  Paste this data directly into Excel. You should have columns A-F used, it'll look very messy.  Something like the attached "sorting1.jpg"

                      6. Find & Replace "% Change" with "Change"

                      7. In Column G put this formula:  =IF(LEFT(B1,6)="Change","Yes!","")  Copy this formula from G1 to G2000.  Every line that says "Change" should now say "Yes!" at the end.

                      8. Copy column G and use "Paste Values" to remove the formula and leave only the "Yes!" in place.

                      9. To match keywords to their change line, follow this specifically.  In H4, type =B1  This should now say your keyword.  Manually type in a few of these, so go to H8 and insert the formula =B5, then do the same with H12.  The formula is =B9.  You should see three keywords in Column H.

                      10. Highlight the cells from H1 to H12.  Grab the black square in the bottom right of the border box.  Drag this selection down all the way to H2000.  Copy all your cells from A1 to H2000 and paste values to remove any formulas.  We want just text now.

                      You should see a list of keywords in column H now, every 4 cells or so.  Check Sorting2 attached.  The rest is very simple.

                      1. Sort by Column G, Sort by Values, Z to A.  This should be looking valuable now.

                      2. Delete Rows 501-2000.  All rows should be "Yes!" now.

                      3. Delete Columns A, B and G.  Feel free to move Column E to Column A if it makes you feel better. 🙂

                      4. Insert a new Row 1 at the very top.  Label each like this:

                      Cell A1: Impressions

                      Cell B1: Clicks

                      Cell C1: Avg Pos.

                      Cell D1: CTR

                      Cell E1: Keyword

                      1. Highlight Row A and push View > Freeze Panes > Freeze Top Row.  Highlight all the data, press Ctrl T to create a Table.  Now you can easily sort any row and sort through your data.  See sorting3.jpg attached.

                      It's really not as complex as it looks.  Just use the two formulas, follow the steps and boom, sortable and pretty data.

                      (I may write this up as a YouMoz post with better screenshots, maybe a video tutorial or something, so thanks for giving us the chance to help!)

                      sorting1.jpg sorting2.jpg sorting3.jpg

                      KeriMorgret TheUniqueSEO 3 Replies Last reply Reply Quote 2
                      • Bryan_Loconto
                        Bryan_Loconto last edited by

                        The fact that you went from generating 35 impressions per day to 2000 impressions per day, could mean that one of your pages is on the first page of a SERP that has high traffic. However, that can also mean that it is in the last spot and not driving any conversion.

                        To find out the keyword go to secondary dimension and select: Traffic sources > Keywords

                        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

                        • ahirai

                          Whatstuffwherebot user agent messing up Google Analytics

                          Starting yesterday, Aug 26, 2020, I noticed a new bot crawling our site with user agent whatstuffwherebot. Google Analytics is counting these hits as human traffic, completely throwing off my numbers - yesterday, Analytics reported nearly triple my typical number of visitors. As of now, Search Console only shows data through Aug 25 so I don't know if Search Console is also affected. Is anybody else seeing something similar? Does anybody know what the whatstuffwherebot bot is? I don't get any results when I search on Google or Bing. For what it's worth, the traffic is coming from Columbus, OH, running over Amazon AWS via 278 different IP addresses so far. Also, WordFence (my WordPress security plugin) correctly identifies these hits as bot traffic.

                          Reporting & Analytics | | ahirai
                          0
                        • Johnroger

                          Strange landing page in Google Analytics

                          Hello MOZ Community, The website in question is https://x-y.com/ When i looked at the landing pages report in GA , x-y.com is appended at the end of every URL like this. https://x-y.com/x-y.com When i open the above URL in GA interface, it shows page not found. This is obvious as there is no such URL.
                          The metrics like sessions, Users, Bounce rate all look good. In the property settings, The default URL is written like this http:// cell-gate.com (Please note that s is missing in property settings). But how is traffic tracked correctly How do i solve this problem. What settings should we change to make the landing pages report look ok Thanks

                          Reporting & Analytics | | Johnroger
                          0
                        • Armen-SEO

                          Tracking 301 redirect traffic in Google Analytics

                          if I 301 redirect www.mywebsite.com to go to www.yourwebsite.com, how can I track the traffic in Google Analytics that is coming from mywebsite.com??  I don't think that's a referral traffic, is it?

                          Reporting & Analytics | | Armen-SEO
                          0
                        • amichaels

                          Google Analytics SEO Queries Not Showing

                          Hi All, This might be a silly question, but for all the properties I monitor in Google Analytics, I'm now showing no data for SEO Queries under Acquisition for the past 6 days. Normally I would expect a few day delay in queries, but nothing for 6 days is somewhat peculiar especially as it was functioning fine prior to November 12th. Does anyone have insight into what might be going on? Thanks! URaNMa3

                          Reporting & Analytics | | amichaels
                          0
                        • KarlMarxTheBear

                          Google Analytics Real Time Not Working! :(

                          Hello Everyone, Today, the real time feature in my google analytics stopped working. I am able to see that traffic is visiting my site, but not in real time. The real time count is usually at 0. But, there are some instances where real time will come back online, but there will be only 1 unique visitor.  At any given time, our website usually has 20 visitors or so..Has anyone encountered this issue? Where should i start looking for fixes? What are the possible problems? Thanks!

                          Reporting & Analytics | | KarlMarxTheBear
                          0
                        • aaronprimal

                          Referral Traffic vs. Campaign Traffic in Google Analytics

                          I have two sites: a blog and an ecommerce site. The blog funnels people to the ecommerce site. In Analytics I'm seeing declines in referral traffic from the blog to the ecommerce site. During the same time I'm seeing an increase in campaign traffic to the ecommerce site, with most campaign traffic coming from the blog. I believe the increase in campaign traffic is largely a result of simply having installed more tracking links. This leads me to believe that the declines I'm seeing in referral traffic is simply a result of the increase in campaign traffic. In other words, what was once counted and reported as being referral traffic is now being counted and reported as campaign traffic. So my question is this: In Google Analytics is campaign traffic ALSO reported as referral traffic, or is campaign traffic reported separately and not duplicated in referral traffic reports? I'll provide a concrete example to make this more clear in case it isn't: Say site X sends 1000 visits each month to site Y. Say 50 of those visits come from a single link on X. If that link is changed so that campaign Z data info added (via the Google URL Builder), would you expect to then see 950 referral visits each month from site X to site Y plus 50 campaign visits to site Y via new campaign Z, or would you continue to see 1000 referral visits plus the new 50 campaign visits? Many thanks in advance to anyone that can shed some light on this.

                          Reporting & Analytics | | aaronprimal
                          0
                        • essentialworld

                          On google analytics what is Mozilla Compatible Agent under browser and OS?

                          On my Google Analytics (I know this is not SEOMOZ) I have a lot of visits from mozilla compatible agent with 100% bounce rate. Does anybody know what this is?

                          Reporting & Analytics | | essentialworld
                          0
                        • ErinTM

                          How do shortened links show up in Google Analytics?

                          Hey, How do shortened links show up in GA? So if I tweet about something and use bitly, does twitter get the referral? I am thinking not. I have never seen bitly show up as a referrer, but we gets lots of clicks from those links. Hmmmm. Anyone? E

                          Reporting & Analytics | | ErinTM
                          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
                        • Local Citation 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.