Filtering OSE Results
-
Issue: When I export OSE Linking Pages results to .CSV, I'd like to filter only unique domains.
It seems to me that there should be a way to do this with Excel, perhaps pivot table.
Anyone have a quick solution for this?
Alternatively, I can use Linking Domains, which gives all unique roots, but then i lose follow/nofollow filter.
Thoughts?
-
Sort by domain name.
Export to Text.
Find replace / with tab character.
Put back into Excel.
Do a count of domain names.
Compress at totals.
You'll have a list of unique domains.
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
-
Using Keyword Tool Results
I love the keyword tool for giving me direction and helping to prioritize. My question: Once I have the prioritized keywords, do you recommend having a page for each of the top keywords, using the keyword as the page name? Or is it better to sprinkle the keywords into existing pages? Thank you.
Moz Pro | | bhsiao0 -
Can we disavow all spammy looking sites in OSE with a spam score of 5 or above?
Hello, We'd like to use OSE to make a disavow list. Can we just go through everything with a spam score of 5 or higher that looks like spam when we visit the site and disavow all of them? I'll be using Moz pro, are there any other free tools that I can utilize? What do I keep in mind? Thanks!
Moz Pro | | BobGW0 -
OSE and Facebook
Hi, I recall being able to use OSE for Facebook. Take https://www.facebook.com/VICE/ which we know as a URL would have many backlinks. It's not registering any. Has this always been the case?
Moz Pro | | wearehappymedia0 -
Results still being seen for old deleted content
Hi, Our site has a blog. We had "Categories" and "Tags" in our blog. This caused SEO chaos with Duplicate content and 404 Errors. We removed all the Categories and Tags about a month ago. Why would these issues still be showing up on Moz as errors on our Crawl Diagnostics page? Do we need to do some thing else other than just remove them from our blog. Thanks
Moz Pro | | Studio330 -
Why do my Rankings Report show different results than the Rank Tracker tool?
I noticed that my ranking report puts be at 33 in google for one term, but when I use the Rank Tracker under Research tools it places me at 15.
Moz Pro | | trainsimple0 -
Discrepancy in OSE data
When I look up a domain in OSE, it shows that there are 3K+ links from 349 domains. However, when I download the CSV, I only see around 1,500 links. Why the discrepancy?
Moz Pro | | inhouseseo0 -
Why has my OSE csv report been finalizing for 3 days?
Hi guys, My CSV report has been finalizing for 3 days. Is that right? I read some posts from last year when there was a backlog Is that happening again. Can someone have a look at that please? Many thanks.
Moz Pro | | Rosewood0 -
Has anyone noticed slight drops in the Domain mozRank of their sites since the OSE update?
There's been no significant changes to their link profiles, so I'm thinking how mozRank is measured may have changed. Anyone else have this issue?
Moz Pro | | RiseSEO0