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.
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
-
Crawl results on keyword rankings differ from actual search rankings
For the second week in a row, the weekly keyword rankings in my MOZ account show "not in top 50" for most keywords. However, when I check some of my rankings I still broadly have the rankings that I used to have. It seems that the MOZ crawl is experiencing some difficulties. Does anyone have suggestions how to find out what's going on? If I can't rely on the crawl outcomes, then the tool is not very useful anymore!
Moz Pro | | matteis0 -
Results of keyword rankings way off??
I just did my first crawl, and a bunch of the keywords show my rank as being like 76 or 102 and I'm number 1 for the search when I search manually. **I of course have personal results turned off and I'm not logged into gmail when I search.
Moz Pro | | immortalgamer0 -
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 -
OSE Report Shows HTTP Status "No Data"
Open Site Explorer shows HTTP Status "No Data" on 1,575 urls of the 3,335 urls listed in the "Top Pages" report for my site. What does this mean?
Moz Pro | | debc0 -
OSE Too Slow
I have a client site that's been up since March. GWT reports over 60 linking domains, most of which are relevant and high quality, yet OSE has never shown more than eight anyone else have similar experience?
Moz Pro | | waynekolenchuk0 -
Bulk OSE Open Site Explorer Tool?
I am trying to do some spring cleaning for a client and hoping to prune any unnecessary domains. Is there a tool that will check, in bulk, these domains through Open Site Explorer? I've looked through all the different Excel spread sheet apps and google doc apps but they are incredibly buggy if they work at all since SEOmoz changed their data limits. Maybe a new tool has been updated in the last few months that I am not aware of. Thanks!
Moz Pro | | kerplow0 -
OSE Advanced for specific directory only?
Pls how do I set up Open Site Explorer Advanced to look for backlinks to files in ONLY a certain directory? so if the domain is 1234.com, I don't care about links to 1234.com. OSE can find those very neatly! What I do care about is ONLY links to 1234.com/profiles and I can't seem to figure out a way to do this. the /profiles directory has thousands of profiles in it - and we think we have hundreds of thousands of backlinks - so ideally, I'd like to use regex or DOS like filtering to look at only those which start with 9 or 8 or whatever.
Moz Pro | | seo_plus0 -
Why does my crawl report show just one page result?
I just ran a crawl report on my site: http://dozoco.com The result report shows results for just one page - the home page, but no other pages. The report doesn't indicate any errors or "do not follows" so I'm unclear on the issue, although I suspect user error - mine.
Moz Pro | | b1lyon0