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
-
Why are my month old links not showing in WMT or OSE?
Hey Everyone! I've been working hard on boosting my ranking after launching my new site 2 months ago. I realize that this process normally takes some time however I've come across a questions that I'm not sure I know that answer to... I had some really solid back links added about a month ago but nothing is showing up yet in WMT on them. When I run an OSE I don't see any links there (not even under newly discovered). Can someone please help with some insight on why they might now be showing. Is it just a time thing or should I be doing something different?Any insight will be very helpful. Thanks
Moz Pro | | MDesigns0 -
Google Local results ranking
Are Google Local position results included in Moz ranking reports? If not, how can these be tracked and monitored? Is a Google Local result likely to achieve a similar CTR as previous organic results? Some of our previous good organic search rankings seem to have been replaced by Google Local results for our restaurant and hotel clients. Is this likely to achieve the same traffic and if not, is there a way to get back to organic results? Thanks!
Moz Pro | | ignitehospitality0 -
Several DA 70+ websites linked to me, not showing in OSE
Like the title says, about 3 weeks ago several websites linked to me. Those websites have very high and probably 100% of this board has heard of them. I'm wondering how long it takes for OSE to recognize these links, and if my website's DA and mozTrust will increase as a result?
Moz Pro | | CHEATERS0 -
Trying to boost Backlinks but OSE still shows same figures for past month
I often check Open site explorer to see if I increased in linking root domains to my site after getting some backlinks on it. I have a concern about the number it is displaying: How does this statistic get updated? If I spread backlinks on some sites do i have to do anything else like ping it so google can crawl it so OSE sees it and counts it towards my linking root domain statistic? Is this current figure OSE is reading from cache and giving me an outdated number? NNzAn.jpg
Moz Pro | | lafurniturestore0 -
What happened to OSE/Linkscape data?
Can any member of the Moz team or of the community comment on the most recent OCE/linkscape update as of 09/08/2011. It appears that the link data capture for one of our platform is dramatically different than previously and that there are some huge discrepancies? Any update on the change would be appreciated as we use all these updates as benchmarks. Thanks
Moz Pro | | OlivierChateau0 -
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 -
Best way to use OSE Advanced Reports
I can see that Open Site Explorer's Advanced Reports feature is very powerful in terms of sifting through large amounts of link data, but does anyone have any useful tips on how to get the most out it? I want to use my 5 reports a month, but I want to make to maker sure I'm making the most of that allowance.
Moz Pro | | seanmccauley0 -
OSE doesn't report backlinks from groupon.ca or tuango.ca. Is that possible?
Hi there, Open Site Explorer doesn't report backlinks from groupon.ca or tuango.ca. Is that possible? Thanks, Adrien
Moz Pro | | AdrienOLeary0