Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Filtering OSE Results

Moz Pro

1641

Gyi last edited by

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?
1 Reply Last reply
Reply Quote 0
RyanPurkey last edited by

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.
1 Reply Last reply
Reply Quote 1

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Blog Post Not Picked up by OSE

How come this blog post of mine which got lots of links has not been picked up by Open Site Explorer: http://infographicdirectory.wordpress.com/2012/08/22/the-internet-a-decade-later/
Moz Pro | | Eavesy

0
Keyword tool results - broad match or exact?

Do the SEOmoz keyword rankings display results for exact match or broad match?
Moz Pro | | ClaytonKendall

0
OSE Advanced Reports best practices

I'm curious how people use the OpenSiteExplorer Advanced Reports tab. It seems very powerful. What do you use it for? In particular, I see that it has choices for 'same C block' and 'different C block'. Those seem useful to find C blocks that my competitors have links from that I do not, but I'm not totally clear on how to construct the query. Any help or best practices would be appreciated. Thanks!
Moz Pro | | scanlin

0
Site recently updated- are my campaign results really accurate?

I recently updated a website and it seems as though my campaign results are not accurate. I feel that the more I learn about SEO, the less I know (if that makes sense?). Every time I check my campaign results for this site I feel like I am missing something but just don't know where to begin. The site is aphroditedesserts.com For example, "aphrodite desserts" is one of my keywords. When I type that into Google, it automatically pulls up the site as #1. But in my campaign, it shows that "aphrodite desserts" does not rank in the top 50 for google. Why is this? (I know there is a lot I could do to improve the SEO keywords on this site, but I am limited because of the client's budget.) However, if I could just get a handle on the answers for these types of issues, I think I would feel much more confident as an SEO specialist. Right now I feel more like a fraud. =( Any insight into what may be causing this would be greatly appreciated! Thank you.
Moz Pro | | RuthWrites

0
New OSE

Since the rollout of the new OSE the many sites i run are indicating a huge loss of links overnight. is there an issue with OSE, either before or after the update or am I missing something ? Thanks
Moz Pro | | blocker0408

0
What is mT/mR good for In the keyword tool difficulty full report results?

So the ratio is MozTrust to MozRank, but what is this good for? What can I deduce from this and what can I use it for?
Moz Pro | | MarloSchneider

2
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 | | AlanBleiweiss

0
Incorrect domain authority result on SEO tool bar and OSE

The SEO tool bar is returning what I believe to be an incorrect domain authority of 71 and showing 24,356,141 lins from 153,051 domains. The OSE is also returning 71 as domain authority. Anyone know what could be doing this? Thanks. Jason
Moz Pro | | jayderby

0