The Moz Q&A Forum

    • Forum
    • Questions
    • My Q&A
    • Users
    • Ask the Community

    Welcome to the Q&A Forum

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

    1. SEO and Digital Marketing Q&A Forum
    2. Categories
    3. Link Building
    4. 28,000 links - How to analyse sensibly

    28,000 links - How to analyse sensibly

    Link Building
    6 4 1.1k
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as question
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Big_Partnership
      Big_Partnership last edited by

      Hi

      My client has a large amount of back links. Does anyone have a simple way of analysing these and making sense of such a large dataset.

      Thanks

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

        extract, and use excel - pivot tables are your friends 🙂 http://www.powerpivot.com/

        Big_Partnership 1 Reply Last reply Reply Quote 0
        • Big_Partnership
          Big_Partnership @rishil last edited by

          Hi Rishi

          Extract how, pivot to what?

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

            Hi Neil,

            We're following up on old, unanswered questions. Did you ever figure out a good way of analyzing the backlinks that you could share with us?

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

              Hi Keri

              Sorry, never got any decent responses

              Neil

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

                Hi Neil,

                A direct link to download the program mentioned previously can be found here. What the previously user likely meant in regards to your question is to extract the data to a CSV file using Open Site Explorer, and then to use the aforementioned PowerPivot (a data analysis tool for Microsoft Excel) to help sort and gather information for your data. This tool is designed to help organize large datasets, so it would be worth a try.

                1 Reply Last reply Reply Quote 0
                • 1 / 1
                • First post
                  Last post
                • Inbound link is follow link but we put no follow link back - is it beneficial for rankings?
                  advertisingcloud
                  advertisingcloud
                  0
                  2
                  57

                • How to analyse a big drop in external links
                  Deacyde
                  Deacyde
                  0
                  4
                  206

                • Tools to visually analyse link profiles?
                  Anders_Alknes
                  Anders_Alknes
                  0
                  2
                  164

                • Page links, header links, footer links
                  RuthBurrReedy
                  RuthBurrReedy
                  1
                  6
                  757

                • Does a hashtag link pass the same amount of link juice as a link without a hashtag?
                  Cyrus-Shepard
                  Cyrus-Shepard
                  0
                  4
                  690

                • Why does my website have 2,000+ links, but only 16 linking root domains?
                  My-Favourite-Holiday-Cottages
                  My-Favourite-Holiday-Cottages
                  0
                  3
                  431

                • How do i sind links for back links
                  KeriMorgret
                  KeriMorgret
                  0
                  3
                  568

                • Does google scrape links from PDF files? do these links pass link juice?
                  Cristina.Andrei
                  Cristina.Andrei
                  0
                  8
                  2.9k

                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
                • Digital Marketers
                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 - 2026 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
                • Accessibility
                • Terms of Use
                • Privacy