Is there a easy way to take all links from O.S.E and add them to My Google WMT.CSV file?
-
Good morning everyone.
I have recently discovered that someone has targeted me with a negative SEO campaign and I have been inundated with 13,000 anchor text links from spam sites pointing to my domain.
I have run Open Site Explorer and gotten all of my backlinks on my desktop but what I need to do is add them to the back links .csv file from Google Webmaster Tools so that I can upload the file to my CognitiveSEO campaign.
What I would like to know is, does anyone know how to transfer all backlinks from the open site explorer.csv file over to the webmaster tools .csv file in a bulk action without having to copy each link individually?
I don't really have any working knowledge of excell in this capacity for SEO so, If anyone could explain how this would be done I would be eternally grateful because adding one link at a time is very painful and very time consuming.
Thank you.
Cam
-
Never mind, I figured it out
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
-
Why is Link Explorer showing the same domain strength for domain and sub-domain? Shouldn't it be different?
I believe in the past the sub-domain score was different than the domain score in Link Explorer. Now I am seeing that it is reporting the same score. I have to use exact page to get a sense of how strong the sub-domain is.
Link Explorer | | Liamis0 -
Moz Pro: Filter inbound links by partial anchor text?
My site has been targeted by a spam farm with hundreds of different domains, all linking to images on our CDN with similar variations of anchor text, eg: get free high quality hd wallpapers wedding cake makers
Link Explorer | | James_NZ
get free high quality hd wallpapers hairstyle makeover
get free high quality hd wallpapers living room cafe
etc Is it possible within Moz Pro to filter all incoming links with anchor text including "free high quality hd wallpapers" so that I can disavow all of the domains en masse? So far I've only been able to display/download the list of links exactly matching the full anchor text which is very time-consuming with 100+ variations. Regards,
James0 -
Moz's new Link Explorer, including our revamped index and DA/PA scores is now open to everyone!
Hey Moz Community, Link Explorer is now open to the public! Everyone can access it via a subscription or a free Moz ‘Community’ account. As you may know by now, the brand-new Link Explorer tool is primed to replace Open Site Explorer as Moz’s link building and analysis tool. The Link Explorer project is the result of an incredible amount of perseverance and hard work by the team, and we’re proud to be able to finally share it with you — we know it’s going to revolutionize how you approach link building and make your job easier. You can read more about the tool here in Sarah Bird’s announcement post. Because Link Explorer improves on almost every aspect of Open Site Explorer, the metrics have improved, too. That means you’re likely going to see some Domain Authority and Page Authority discrepancies between OSE’s index and Link Explorer’s index. We definitely suggest you use the new DA/PA from Link Explorer, as they’re more accurate and refresh daily rather than monthly, as was the case with OSE’s index. However, we also realize that many of you use these metrics to report to your clients and colleagues, and a sudden change or fluctuation could potentially make your job harder. Which DA is the real DA? The new DA is based on a much larger index that has many improvements, several of which are designed to make the index more like Google’s than ever before. You should consider moving towards the new DA (and the old DA won’t be updated after April 26th 2018, so the sooner the better). While there will be fluctuations as we improve the model and add features to the index, we expect it to remain largely stable and to be a far more accurate picture of a site’s authority according to how it’s seen by Google. Why is Link Explorer’s DA/PA considered better than OSE’s, and which should I trust? The larger link index with improved crawl selection allows us to produce a stronger model that includes a much larger proportion of the web. That being said, DA and PA should always be considered in the context of your competitors. A drop in PA or DA relative to the old OSE is of little concern if your competitors saw similar movement. Is Domain Authority/Page Authority an absolute score or a relative one? Both DA and PA are relative to the Internet as a whole. If Facebook acquired a billion new links, everyone’s PA and DA would drop relative to Facebook. Because of this, it’s always best to look at PA and DA in comparison to your competitors. What does a drop/raise in DA mean in Link Explorer vs OSE? How can I explain this to my clients when I’m reporting it? DA and PA should always be considered in the context of your competitors. A drop or raise in PA or DA relative to the old OSE is of little concern if your competitors saw similar movement. Reporting that your site has moved from a DA of 45 to a DA of 42 doesn’t tell the whole story, but reporting that your site has a DA of 42 while your main competitor moved from a 43 to a 37 shows that, relative to the sites you’re competing against in the SERPs, your site has significantly more authority and ranking power. What’s happening to MozTrust and MozRank and why, and what should I replace those with? The improvements to our DA/PA and Spam Score metrics now now account for more important nuances in helping you determine one site’s ability to rank higher than another. Because they no longer correlate with Google’s ranking model as well as they used to, MozRank and MozTrust are being deprecated for better metrics. Users should rely on Page Authority, Domain Authority, and Spam Score to determine the importance and quality of pages, domains, and links. I have historical data I use to help my clients benchmark their progress. What do I do now that DA is calculated differently? You should annotate any KPI changes referencing the change in DA and PA. However, most importantly, you should compare those changes to your competitors, as this will best show how strong your site’s authority is relative to the sites you’re competing against in the SERPs. We take updating our metrics very seriously, and our last major update to the model was 7 years ago. Users of Domain Authority and Page Authority can expect us to continue to produce steady, reliable metrics for the long haul, and only make changes to these metrics when we believe the benefits dramatically outweigh the stability of the metric. Do you have any questions about the new metrics? Anticipating a tough time reporting changes to clients or bosses? Metrics, features or functionality missing that you would want to see? Let us know in the thread, and we’ll work to find a good answer for you. Hope you enjoy the new Link Explorer product and the amazing new link index powering it. We are very excited to provide this valuable data to our community and customers.
Link Explorer | | IanWatson9 -
Just Discovered Links not appearing in main index
Hi Around October, November (and ongoing since then) we had some links appear in the "just discovered" index of OSE, and yet they've never made it into the main list of domains linking to the website. We have amassed quite a few links from various domains that seem to get picked up in "Just Discovered", but not by the standard list of links to our site Is there any reason for this?
Link Explorer | | Lexica0 -
OpenSiteExplorer is showing all link root domains or not?
I want to know open site explorer is show all link root domain or not? As my point of view missing some linking root domain of my website on opensiteexplorer,so, Why Its not showing all link root domain?
Link Explorer | | renukishor0 -
How to increase number of internal links
Hi all, Using Open Site Explorer and Moz, we're getting only 50 internal links and like to know why. Our site is an online store with a quite good DA (26, see attached files) comparing with competitors, and all pages are in sitemap since several months, and crawled by google. Assuming that we have more than 2000 products in our site, and more of 10000 crawled pages with a link to the home page, we can't understand how "Total internal links" returns only 50. How can we increase internal links? Perhaps we misunderstood the meaning of "Total internal links" in page metrics. What does this value exactly mean? Any help will be appreciated. Thanks in advance. wuud3Lu RRvn31p
Link Explorer | | citricamente0 -
What is the difference between a "Just Discovered" link and an "Established" link in OSE?
What is the difference between a "Just Discovered" link and an "Established" link in OSE? How long does it generally take for a just discovered link to migrate in to the established link section? Are there other parameters that need to be met before a link can be referred to as established? Sorry for all the questions in one post, but I've had the same "just discovered" links in OSE for quite some time and have yet to see them migrate over to the "established" link section. I was hoping that when these links become established that it would help improve my site DA. Can anyone shed any light on this issue or have any other comments? Thanks MOZ!
Link Explorer | | GalcoIndustrial1 -
OSE Says I have 3,115 total links but I can only export 660 via advanced reports
Hi Everyone! My site (http://carwow.co.uk) has 3,115 total links according to OSE, I need to export them all but advanced reports export will only give me 660. Please advise! Thanks, James
Link Explorer | | JamesPursey0