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
-
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 -
How does OSE select top 10,000 links
Quick question about OSE, if you are extracting with excel all inbound links from a big site like IMDB.com, OSE only exports 10,000. However IMDB has alot more links then that. I was wondering what criteria does OSE use to select those 10,000 links from the 100,000+ which IMDB has. Is it a random selection of those 10,000 links or does it select those 10,000 links based on metrics like DA or PA? For the settings i have selected: followed + 301s, only external, pages on this root domain, group by domain. Cheers, Chris
Moz Pro | | MBASydney0 -
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 -
Getting odd results with MOZbar. (Some pages are 0,0,0)
I'm trying to review the Domain aurhotiry, Page Authority, and MozRank & Moztrust for some news websites and I found it odd that may sites will have excellent DA,MT,MR & PA on most of the pages but then when I view one of their blog posts the PA,MR & MT are 0. Here's are two examples Site
Moz Pro | | SheffieldMarketing
http://www.washingtonpost.com/lifestyle Individual Post
http://www.washingtonpost.com/lifestyle/home/checking-in-with-thomas-pheasant/2012/10/30/a2920ed4-1df5-11e2-ba31-3083ca97c314_story.html Site
http://www.philly.com/philly/living/ Individual Post
http://www.philly.com/philly/home/Home_Style_Silver_makes_holiday_decorations_really_shine_.html Does that mean that links from blog posts would not be very benificial? The domain authoity is still crazy high but everything elese is 0. Anyone know why? I'm new to using the Moz bar. Thanks0 -
Link not showing up in OSE
I created a profile in April this year on CrunchBase for my company http://www.crunchbase.com/company/wallpapered but it is not appearing in the "inbound links" of Open Site Explorer. All the other companies I have checked in OSE have their CrunchBase profile in their inbound links (many share the same Page authority as mine). Any suggestions would be really helpful. Thanks
Moz Pro | | roberthseo0 -
What period of time do OSE social media metrics represent?
When one hovers over the social media metrics in Open Site Explorer the popups say that the numbers represent the total number of times the URL has been posted, liked, tweeted or +1'd. Those numbers are [appear to be] more dynamic than the data in OSE's other reports and seem to get a fresh analysis each time the URL is entered. So I'm wondering what period of time is it counting in it's "total number of times" determination? If I'd like to track the data to get an idea of, say, total number of Facebook Shares for a one month period, how often should I check the numbers?
Moz Pro | | BlastAM1 -
How to tell OSE about new backlinks
I've recently obtained some great backlinks from popular news sites but OSE hasn't picked up on them yet. Is there a way to "show" OSE what's happened, or do I just have to wait?
Moz Pro | | deuce1s0 -
Anyone having issues with OSE?
Everytime i try to access the tool i get the following error: "Error 310 (net::ERR_TOO_MANY_REDIRECTS): There were too many redirects."
Moz Pro | | Anest0