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
-
How to add my company in google search search result in bangalore (INDIA)
Hello, i want to add bangalore which is a district in INDIA to moz so that people searching from that bangalore would find our company listed in google search .Happens to be that i am not able to enter any locations apart from USA. It would be of great help if you could assist us in doing the same.Also wanted to know how how to target preferred locations in India. Thank you
Moz Pro | | Jabez0 -
OSE not displaying data
Is anyone else having a problem with OSE not displaying any data except for domain and page authority?
Moz Pro | | SamCUK0 -
Site Explorer Results - Linking Domains Tab
I have a competitor who has the following Linking Root Domains numbers on the Linking Domains tab and was wondering if some one could explain what the numbers mean? opera.com - 205,515
Moz Pro | | bridgeway04-34677
dmoz.org - 97,752 prweb.com - 198,092 quantcast.com - 115,748 tinyurl.com - 443,540 jquery.com - 57,886 URL: http://www.opensiteexplorer.org/domains?site=www.verypdf.com%2F Thanks, Brad0 -
Poor OSE results on my links
I am really disappointed with the "return on investment" I am getting from being a Pro member and using Open Site Explorer to analyze and remedy my inbound links post-penguin. My site has been crawled for over 4 months now by seomoz and OSE reprots that I have "external links" from just 25 or so domains - whereas Google webmaster tools has accurately identified well over 270 domains that link back to my site. How can do any sort of link removal strategy using open site explorer? I am paying $100/mo for SEomoz, and nothing for Google. What is the problem?
Moz Pro | | veezer0 -
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 -
Tons of Crappy links in new OSE (Open Site Explorer)
I am starting to miss the old OSE. I've found that for a lot of the pages on our site, the new OSE is showing WAY more links and most of them are garbage nonsense links from China, Russia, and the rest of the internet Wild West. For instance, in the old OSE, this page used to show 9 linking domains: http://www.uncommongoods.com/gifts/by-recipient/gifts-for-him It now shows 454 links. Some of the new links (about 5 of them) are legitimate. The other 400+ are garbage. Some are porn sites, most of them don't even open a web page, they just initiate some shady download. I've seen this for other sites as well (like Urban Outfitters) This is making it much harder for me to do backlink analysis on bc I have no clue how many "Normal" links they have. Is anyone else having this problem ? Any way to filter all this crap out ? See attached screenshot of the list of links I'm getting from OSE. NHXnn
Moz Pro | | znotes1 -
Does OSE Anchor Text Distribution CSV include internal links or external only?
Quite often when I'm using OSE and perform a CSV export, it looks like the total inbound link count and many phrases come from internal links for the domain in question. I haven't had the time to try and figure this out and don't know exactly how to go about figuring it out. So the initial question is does OSE's anchor text distribution CSV include internal links or are they external only? And alternately, how do I test for this? I deal with sites that have tens or hundreds of thousands of pages and hundreds of thousands or millions of links...
Moz Pro | | AlanBleiweiss0 -
Confused by Google Mobile App (on Blackberry) results??!
First off, Hi guys I'm a new user here, in fact only in my second week of my trial period. However, I can assure you that I'll be continuing my subscription as this website is 'one hell of a bit of kit!'. Now, to my predicament. I have a website: http://www.limegreenofficeproducts.co.uk which I am trying to move on up the rankings in Google (just like everyone else...). Well, I have followed the instructions and guidance through the Campaign Manager and I have 'A' ratings now for a couple of my preferred keywords, namely 'Office Supplies' & 'Office Products'. I also have a number of textlinks with these exact terms, some quite powerful (I'm the only outbound link on a Homepage PR5 on one). Anyway, being a complete and utter control freak - I wake up in the morning and check my rankings using the Google Mobile App for Blackberry whilst throwing as much coffee as possible down my neck. Basically (if you're not familiar with this app, it is just the same as connecting to the mobile internet and carrying out a search - or at least it should be). Well I was really excited to find that I was ranking at No.41 for 'Office Supplies' and No.17 for 'Office Products'. When I fully woke up and ventured to the office, I checked on the Mac through the normal Google UK and I'm nowhere, for either? What makes it even more confusing is that the results on the mobile seem to be intermittent - so if I check at 11.00am I'm No.17, 11.05 I'm nowhere, 11.10 back to No.17 - but only on the Mobile App. I have the Mobile App set up to Google UK, so that can't be the problem. I'm just wondering if either the Mobile App is ahead of the 'Real' Google UK results, or behind.The main reason for asking, is so that I can establish whether what I am doing is having a positive, or negative effect on the rankings. And if this is an quicker way to find out - then great! I assume the advice to come back will be '..ignore the mobile app..' but as it's being kinder to me than the 'Real' Google I'd like to be a bit kinder to it, and give the little fella the benefit of the doubt. But having said that I just checked the search results (Top 1000) for Keywords 'Office Supplies' & 'Office Products' - For Office Products the site was No.614 and for 'Office Supplies it wasn't in the top 1000, ouch. I know these things take time, as I have worked on a couple of other sites of ours and it seems that as soon as you are about to throw the towel in, the results just kick in. I'm not expecting miracles overnight, far from it - but it has me really confused. Does anyone have any suggestions/advice?(except '...get a life coffee fiend') Regards Limegreen
Moz Pro | | Limegreen0