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
-
Local search results reporting
Is there a way I can report on local search results for our keywords by city?
Moz Pro | | RPM5
For example could I specify Phoenix or Chicago and then see how we rank as if we did the search in that city?0 -
Can anybody point me to an OSE tutorial blog on Competitive Analysis?
I came across a few blogs which got me started here on an SEOmoz Pro account and now I am working on building a competitive link analysis spreadsheet in Excel in order to identify how are competitors are beating us in Google rankings for specific keywords. One article I came across seemed to do exactly what I wanted, but the images are all broken and the downloads require a membership to some service I am not interested in: http://www.seerinteractive.com/blog/how-are-they-beating-you-quick-seo-analysis-tools-part-1/ Anybody have any resources like this they can share? Thank you.
Moz Pro | | jesse-landry0 -
Why is OSE so infuriatingly annoying
Damn thing tells me the www.domain im researching has 599 links internal and external. I download an advanced report for the whole root domain of external links....and its come up with 64 in a csv file.....wtf is that about? The data about root domain says i have External Followed Links 408 and
Moz Pro | | xtopher66
55,736 total links...........which is BS. this site hasnt enough internal or external to shoot from the low figure up to 55,0000 By the way, im a 79 tall but ive never meaured my height.. Sounds like SEO data!0 -
Why does the csv export from OSE only include 25 of the 90+ links?
In OpenSiteExplorer, I clicked "Download CSV" for a report on backlinks from one domain to another. The online visualization in OSE showed 93 external inbound links from site A to site B. When I opened the report, there are only 25 linking pages listed. How do I download the full list?
Moz Pro | | DanielH0 -
Why Do Links, DA and PA have no affect on this search result?
When I type 'plumbing courses' into Google, why does Able Skills with these statistics: Page Authority: 57,
Moz Pro | | MartinHof
2,752 Links from 330 Root Domains
Domain Authority: 52,
575,594 Links from 1,211 Root Domains rank below other pages with inferior statistics?0 -
Over 90% of anchor text tends to be brand-name on OSE link profiles. Why?
I reported this as a bug in OSE, because often I explore these links and find that the pages include both a brand-name link AND a regular keyword link, but for some reason OSE was only reporting the brand-name link... This led me to wonder how many links this occurred for, and therefore whether or not to trust the fact that the majority of the sites I ran OSE on returned at least (in most cases, more) than 90% brand-name links. I understand that brand-name links are amongst the most important to obtain, but that it's also important to get anchor text for keywords to build a varied profile. Given this apparent flaw in OSE, is it wrong - in the case of very successful sites - to take this ~90% as being anywhere near the correct percentage of brand-name links that I should be aiming for as a proportion of the total profile? Extra Credit :)... And this may help potentially help resolve the issue: does "Inbound Links" tab in OSE just report links to the Root Domain, or to that and every other page on the site?
Moz Pro | | ZakGottlieb710 -
What is the quickest way to get OSE data for many URLs all at once?
I have over 400 URLs in a spreadsheet and I would like to get Open Site Explorer data (domain/page authority/trust etc) for each URL. Would I use the Linkscape API to do this quickly (ie not manually entering every single site into OSE)? Or is there something in OSE or a tool I am overlooking? And whatever the best process is, can you give a brief overview? Thanks!! -Dan
Moz Pro | | evolvingSEO0 -
Keyword Difficulty Tool on local results. Is this really working?
I've tried the Keyword Difficulty Tool on "consultant seo" in Romania (that is .ro) The tool says that it's Highly Competitive (59%), but I've got my website on #8 in 2 weeks. Question: Is this tool really working for local results? It seems way off... Actually I was kind of expecting for this keyword to be easy, what is confusing is the "59%" from the Keyword Difficulty results. Thanks for the answers!
Moz Pro | | wizant0