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 -
link building
I want to know is there any way of increasing DA/PA of the website? Is there any benefit in ranking if we increase PA of specific page? Recently my website DA is 6 i want to increase it 30.
Link Building | | hfameraya1980 -
How many links per week/month should a link building campaign acquire?
I am running a linkbuilding campaign for my company. I am mostly focusing on guest blogging opportunities and responding to emails from HARO. How many links would I have to acquire each week or month to be considered doing a good job over a 6 month or a year time period? Thank you,
Link Building | | fersu0 -
AllTop Linking Me to Other Sites Feeds, Webmasters Reporting Lots of Broken Links
I submitted my blog to All Top awhile ago and something seems to be wrong with their feed. They're sending people to mysite.com/truth-o-meter.com/this-is-a-post. It's not just truth-o-meter either. I'm getting links that are supposed to go to all kinds of political blogs. As a result, I'm getting a ton of broken links reported on Google Webmasters. I couldn't find any real support option on alltop.com, and when I log in, there are no sites for me to manage. Instead, I resubmitted the site with the correct feed address and in the comments, I mentioned the problem. All I got was a message saying the site was rejected. I believe because I already added the site. But I'm thinking they didn't pay attention to the comments. (In fact the message may have gone through an auto-filter considering how quickly it was rejected.) Is there a way to solve this? Is this a situation in which I would use the disavow tool? If All Top continues to create bad links, how do I stop the issue once and for all? Thanks!
Link Building | | eglove0 -
Link value
Hi I have some links from blogs to our ecom website. My question is if anyone knows what happens if you have several different blogs on .blogspot linking in to you. Does that make them loose value because they are on the same domain? I can probably quite easily have 5-10 blogs on blogspot all with PA of 35-40 link in to us. Is it worth striving for or should i strive to get blogs that have their own domain to link into us instead ? Or equally important ? Dan Lærum
Link Building | | danlae1 -
Do links within imbeddable widgets carry link juice?
I'm dipping my toes into infographic design. On of my desired outcomes is to gain links by having other sites embed my graphic. I'm considering using Tableau's interactive data visualization software to do so; thus creating a widget, embedding it on my blog, and including the embed code for others to post. Is it possible to include a juice passing link in such an infographic? I know its possible to include links inside the tableau graphic but not sure if they have straight SEO value. If these links are not juice passing would it be better to go with a simple image link that passes value?
Link Building | | JesseCWalker1 -
Do sites on the same c-block and same server count as seperate linking root domains when linking to each other?
Lets say there are 50 businesses who have their website on the same server and are on the same c-block but the owners of the individual sites are different (i.e. they are all completely different sites not relevant to each other). Each of those sites are linking to each other due to a feature on the sites. This obviously increases the number of total links to each site but does it also increase the number of linking root domains? Or does this just show up as one linking root domain due to all of them being on the same server and the sharing the same c-block?
Link Building | | cinternicola0 -
If I write a PR release on a site such as PRweb with anchor-text links that is picked up and published by other news sites, do the engines consider this duplicate content or additional, beneficial links?
I recently wrote a news release on PRweb that was picked up identically by 8 other news websites, with the same anchor-text links as the original. Is the reproduction of duplicate content and links across different websites like this to the benefit or detriment of SEO and ranking power? Some of the links are: http://www.mynewsdesk.com/uk/view/pressrelease/eventa-new-eventa-christmas-parties-website-is-launched-648923?utm_source=rss&utm_medium=rss&utm_campaign=Alert&utm_content=pressrelease http://www.prweb.com/releases/christmasparties/neweventasite/prweb8562064.htm Many thanks!!
Link Building | | RobertHill0