28,000 links - How to analyse sensibly
-
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
-
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.
-
Hi Keri
Sorry, never got any decent responses
Neil
-
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?
-
Hi Rishi
Extract how, pivot to what?
-
extract, and use excel - pivot tables are your friends
http://www.powerpivot.com/
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
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.
Related Questions
-
Should I disavow these links?
Hi all, I have a ski website that I am currently performing a toxic backlink audit on. I have noted that a lot of the links being flagged as toxic/spammy by the tool I am using seem to be the same/similar sites with different URLs. The sites are vaguely related to skiing (relating to helicopter travel options for travelling to ski resorts) but it is concerning me that there are so many of them and they are being flagged as so toxic.
Link Building | | SolveWebMedia
Do you think it is worth disavowing these? Or contacting the owner to ask them to remove the link? I have included an example of some of the links below. https://www.cannes-helicopters.co.uk/index.php?menuopen=21&showcontent=5
https://nice-helicopter.co.uk/index.php?menuopen=21&showcontent=5
https://monaco-helicopter.co.uk/index.php?menuopen=21&showcontent=5 Slightly different site but same favicon icon:
https://monaco-helicopter.co.uk/index.php?menuopen=21&showcontent=5
https://www.whitetracks-holidays.com/Helicopter_Transfers_Villars_Switzerland.htm Thanks in advance for any advice / help!0 -
Disvowing Links?
I ran a report through SEM rush and it came back with 174 toxic links ( score 100-60). I have been reading mixed reviews about what to do. Most of the websites are not relevant and appear to be linking to the images. Should I disavow these links? Would it help SEO? Or should I leave it be?
Link Building | | higherimages0 -
Link building during link removal
We were advised by out outsourced link removal vendor not to build any links while they are removing links pointing to our site. I am worried that our site will lose significant traffic if we dont build any new links while waiting for them to remove links that caused our site to be penalized. What are your thoughts?
Link Building | | WizardOfMoz0 -
Link building
I keep sending personal emails to website asking for a link form them but every one says no how do other website get so many links to there website whats the best software to use
Link Building | | homesandindustrial0 -
Link removel
When removing links should I be worried about bad links from websites that have already been deindexd from Google or should I think that since it is not in these index any more it cant do harm?
Link Building | | Joseph-Green-SEO0 -
Linking to a pdf
Hi All I have a pdf that people can download from my site, what I want to know is that when people link to the pdf does the pdf share link power to pages linked to from within the pdf (like a html page would) or is the link power being waisted going to the pdf and should I somehow get the links to a normal page? The pdf is a free downloadable resource to people in the party planning industry and so gets linked to quite a bit by sites telling their readers to get the information we provide. Thanks for your thoughts Sean
Link Building | | SKE0 -
Links from Real Estate Websites Link Page, Do or Don't?
It seems that real estate sites have at times been under heavier scrutiny from the search engines. But real estate agents get networking, which makes acquiring those links a little bit easier. Plus with localization of search, I think real estate sites may give off a good GEO scent. Should SEO's go for links from real estate websites? Does a reciprocal link devalue said links?
Link Building | | Thos0030 -
Back links not being found
I am working on optimizing a client site that was launched in January of 2011. A number of back links are starting to show up when I do a competitive link analysis, however in Google WMT the only IBLs that are showing up are from the non-www of the domain, even though I have a 301 redirect from danwilson.ca to www.danwilson.ca (and has since the site launched). I also have verified the non-www version with WMT and declared the perfered domain as www.danwilson.ca. Any ideas why the non-www domain links are being shown as inbound links by Google WMT rather than internal links. This likely means the site is getting dinged for duplicate content...
Link Building | | diguno0