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
                • Backlinks vs External Links vs Referral Links vs Outbound links
                  NCOREGSEO
                  NCOREGSEO
                  0
                  3
                  4.2k

                • Internal Linking - Post links vs Side Bar Links behaving differently
                  BlueprintMarketing
                  BlueprintMarketing
                  0
                  4
                  119

                • I am getting links on people's wordpress blogs but are not showing up on the just discovered tool. Is it true that wordpress links are no-follow links that do give off any link-juice?
                  BlueprintMarketing
                  BlueprintMarketing
                  0
                  3
                  122

                • Linking Analyse
                  JohannNortje
                  JohannNortje
                  0
                  2
                  358

                • Link to those that link to you? Worthwhile?
                  RyanKent
                  RyanKent
                  0
                  3
                  620

                • Link Building: Asking for links versus building links
                  MBayes
                  MBayes
                  1
                  6
                  1.4k

                • Best Way to Analyse Linking Structure of My Site
                  joemas99
                  joemas99
                  0
                  3
                  844

                • What percentage of my links should be directory links
                  KeriMorgret
                  KeriMorgret
                  0
                  4
                  1.2k

                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