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
-
Unsolved Anyone out there know MOZ well enough to provide a consultation on our results?
Hi Fans of MOZ, is there anyone out there that knows MOZ like an uber user and understands the details on crawl reports and what they mean? I'm looking for someone to review my MOZ results and give me some practical suggestions to work on with my SEO and web teams. Any takers?
Moz Pro | | NCPG
Bob Preston,0 -
OSE seems to be less and less accurate
Howdy folks, Into our 3rd year of using MOZ and OSE and well not sure about you guys but I think OSE is reporting less and less accurately. Has anyone seen a drop in it's accuracy or ability to delivery what it claims to? I know many of you also use AHREFS and others but why not get this tool right MOZ?
Moz Pro | | wearehappymedia0 -
Open Site Explorer produces better results for www.50campfires.com than 50campfires.com
Our website url is 50campfires.com and www.50campfires.com redirects to 50campfires.com Look at the Open Site Explorer results for the two and www.50campfires.com has better results. Does google have an issue with this or may it be confusing them? We have redirects in place. How would I go about fixing this? More on what strategies would improve Page Authority and Page Rank. Thanks in Advance. 79JtBKA.png lrHwsOU.png
Moz Pro | | revonick0 -
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 | | JasonOliveira0 -
OSE Releases
Does anyone know how often OSE index is updated? We've relaunched our website recently, and I'd really like to see how our redirects, PR efforts and new internal linking structure is working out for us. I think I have previously seen a schedule somewhere, but I can't find it at the moment. Any help is appreciated!
Moz Pro | | tomcraig860 -
Using Keyword Difficulty Report along with OSE to calculate SEO Pricing?
Has anyone thought of or created a algorithm or Excel function that uses the results from the Keyword Difficulty Report percentage of difficulty and SERP ranking analysis set against potential client's own OSE rankings to come up with an estimated SEO pricing tool?
Moz Pro | | easystreetint0 -
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 | | scanlin0 -
Why is my domain not being indexed by OSE?
My domain: http://www.seoproim.com/ is not being analyzed by OSE for whatever reason. GWT and YSE can see the inbound links.... Whats up?
Moz Pro | | LucasGarvin0