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

1649

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

Woocommerce filter urls showing in crawl results, but not indexed?

I'm getting 100's of Duplicate Content warnings for a Woocommerce store I have. The urls are
etc These don't seem to be indexed in google, and the canonical is for the shop base url. These seem to be simply urls generated by Woocommerce filters. Is this simply a false alarm from Moz crawl?
Moz Pro | | JustinMurray

0
Does SEOMOZ planing to restructure OSE metrics?

As you know SEO slowly turning into SEM and some metrics and numbers from Open Site Explorer are no so relevant any more. As a customer of SEOMOZ product i am warning if you guys are planning to add more value and ranking metrics according to the new ranking metrics and factors to your tools?
Moz Pro | | JasonOliveira

0
Are header directives such as X-Robots and Link supported by OSE/Linkscape/SEOMoz tools?

SEOMoz tool reports show lots of duplicate content where there are http header directives in place on pages to eliminate dupes. Googlebot obeys but Roger the robot doesn't. Are header directives such as X-Robots and Link (rel=canonical) supported by OSE/Linkscape? I'd like to put my mind and clients at ease. Thanks
Moz Pro | | Mediatorr

0
OSE question

Hi guys, when will open site explorer update next?
Moz Pro | | Eavesy

0
How do I get moz to search google with the settings of a certain city...ie keyword results as if I was living in Los Angeles ?

Seomoz search setting question
Moz Pro | | MarketingPugetSound

0
Www.mydomain.tld same as mydomain.tld - unexpected results

Hi I set up a campaign to monitor a website and chose to track the root domain, however the report showed every single page on my website was duplicated with itself when seen as www.mydomain.tld as opposed to just mydomain.tld. I deleted the campaign and set it up to monitor only the www.mydomain.tld as I don't use any other subdomains, however in Bing results the website is listed without the www and so is not recognised in the ranking checker. How can I set it up so that seomoz recognises the pages as the same either with or without the www?
Moz Pro | | PandyLegend

0
Why is the Rankings Report of SeoMoz always show inaccurate results?

I have been using SEOmoz PRO tool from last two months but I am not happy with the SEOmoz PRO Ranking Report.The results are very inaccurate and I am not able to understand why there is such a difference in the ranking results when SEOmoz tracks and when I track?Please reply at the earliest. Regards, Prashakth Kamath
Moz Pro | | 1prashakth

0
Why do I see different ranking results for Bing and Yahoo?

If Bing is running the Yahoo search results then it seems to me the ranks for both Bing and Yahoo should be the same. So why are my SEOmoz ranking reports showing different positions for each?
Moz Pro | | Thos003

2