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
-
Local search results reporting
Is there a way I can report on local search results for our keywords by city?
Moz Pro | | RPM5
For example could I specify Phoenix or Chicago and then see how we rank as if we did the search in that city?0 -
Old data in OSE?
Hello, I know the Mozscape was recently updated, but it's been a week and my site data ( DA, number of backlinks) in Open Site Explorer is still the same. The seomoz toolbar and my pro tools show my DA has increased ( I don't know of another way to verify my backlink count, so I'm not sure on that front). Any idea of the reason behind the disparity? Thanks.
Moz Pro | | richje0 -
What's Happened To OSE's External Links For My Site?
Hi, I'm just taking my first steps with Open Site Explorer. I've hit a problem that I'd be really grateful for some help with. I'm running a website (that I didn't create) and want to get a clear picture of the inbound links. When I enter the URL into the OSE search bar, there are no external domains listed under the 'Inbound Links' and 'Linking Domains' tabs. Only internal site links are registered. Setting the filters, "only external" + "pages on this root domain", under the Inbound Links tab, does bring up a list of external sites. But I haven't had to enter filters just to see a list of inbound links with any other sites. Also, the breakdown under the Linking Domains tab remains the same - only links within my site are shown. Does this ring a bell? Any ideas what I might be doing wrong, or what might be wrong with my site to cause this problem? Cheers for helping, Josh
Moz Pro | | JoshAustin460 -
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 -
SEO Moz Tools - too many on the page links result driving me nuts
A while back I remember Rand and I having a conversation about how many links on the page and up until that point I had followed the NO MORE THAN 100 links on a page rule - which is what the MOZ tools are telling me now in the campaigns I have running. But then during a seminar both of us were holding this 100 link rule question came up and Rand commented that this was probably old hat now as the search engines can crawl a much greater number of links in the page. I was encouraged by his answer especially where ecommerce websites are concerned. But the MOZ tool is driving me nuts telling me that this 100 link rule is still something to be adhered too. It is especially frustrating when we are discussing ecommerce website sites with editable mega menus. Examples to support this question are www.bohemiadesign.co.uk or www.flowersbuydelivery.co.uk which are 2 ecommerce sites I am aware of using such mega menus that are editable and give a link count greater than 100. and I am sure there are many more sites like this, even Amazon for example. So, how much notice do we take of this warning in MOZ tools that is telling me about excessive numbers of links on the pages it lists as needing corrected?
Moz Pro | | ICTADVIS0 -
What is the quickest way to get OSE data for many URLs all at once?
I have over 400 URLs in a spreadsheet and I would like to get Open Site Explorer data (domain/page authority/trust etc) for each URL. Would I use the Linkscape API to do this quickly (ie not manually entering every single site into OSE)? Or is there something in OSE or a tool I am overlooking? And whatever the best process is, can you give a brief overview? Thanks!! -Dan
Moz Pro | | evolvingSEO0 -
Best way to use OSE Advanced Reports
I can see that Open Site Explorer's Advanced Reports feature is very powerful in terms of sifting through large amounts of link data, but does anyone have any useful tips on how to get the most out it? I want to use my 5 reports a month, but I want to make to maker sure I'm making the most of that allowance.
Moz Pro | | seanmccauley0