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 Moz is showing old results for site craw issues
Moz is showing old results for site craw issues, the ondemand craw works but I can't fix these issues without knowing what causing them.
Moz Pro | | paulwildweb0 -
Rogerbot's crawl behaviour vs google spiders and other crawlers - disparate results have me confused.
I'm curious as to how accurately rogerbot replicates google's searchbot I've currently got a site which is reporting over 200 pages of duplicate/titles content in moz tools. The pages in question are all session IDs and have been blocked in the robot.txt (about 3 weeks ago), however the errors are still appearing. I've also crawled the page using screaming frog SEO spider. According to Screaming Frog, the offending pages have been blocked and are not being crawled. Webmaster tools is also reporting no crawl errors. Is there something I'm missing here? Why would I receive such different results. Which one's should I trust? Does rogerbot ignore robot.txt? Any suggestions would be appreciated.
Moz Pro | | KJDMedia0 -
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 -
Universal results not in pdf or csv reports
Right now, the universal results show up when I look at tankings on the site, but do not show up at all in the weekly pdf reports. They also did not appear in the full rankings history .csv report. They only appear in the weekly csv report, and then, the information is not as detailed as it is on the website (it only shows whether a universal exists, but doesn't indicate at what position it shows up). This limits the usefulness of these reports to my customers. I need to be able to show them rankings histories, including universal results, in their monthly or weekly reports. Including the charts would be nice as well. Since I can individually download the .pdfs for these for each keywords, why can't we just include it in the monthly reports. Also, would like to be able to view rankings history for all three search engines at once for a keyword, or multiple keywords to reduce the number of pages in a report. Can you add this feature?
Moz Pro | | HMS0 -
Why are results different on Rank Tracker tool and New Rankings Weekly Reports?
Good Morning... Every week i get an email from SEO Moz that is showing me where the keywords i am tracking are currently in the SERPS (New Rankings and On-Page Reports)... Is there a reason that the current rank shown on these emails would be so different than what is shown when i use SEO Moz's rank tracker? For example, it shows one keyword has a rank of 48 (via email) and a rank of 16 through the rank tracker. What would cause such a great discrepancy? Thanks
Moz Pro | | Prime850 -
UK Google Results .com V's .co.uk
In the UK lots of people use google.com rather than google.co.uk. See: http://weblogs.hitwise.com/robin-goad/2008/04/how_popular_is_googles_pages_from__the_uk_search_option.html The above data is a bit out of date but still I know lots of UK people who search on google.com. When I depersonalise the results and search there is a difference between what I see on google.com V's what I see on google.co.uk. Indeed one of the companies I work for ranks ok on google.co.uk, but not so well on google.com Questions: How would I best track ranking for UK based users who use google.com AND/OR google.co.uk using the SEOmoz tools (or other tools if appropriate)? I note that in "Google Webmaster Tools" you can change the setings to "Target users in United Kingdom". Given the fact that UK users use both google.com AND/OR google.co.uk would it be better to change this to unlisted or deselect the "Target users in" option? Thanks in advance. Justin
Moz Pro | | GrouchyKids0 -
Open site explorer result discrepancy
Hi all, I'm a little confused - when using open sites explorer to view of link stats on one of our competitors site I get conflicting results. For example - Page Specific Metircs shows the url www.xyz.com has 265 external links. But Root Domain Metrics show they have 22,687 links Yet the total links at the top of the report says Total links 999 Can someone explain why www.xyz.com has 265 external links and the rot domain (which is the same) has 22687 links? I've also run the report on xyz.com rather than www.xyz.com which yielded no results. Thanks in advance
Moz Pro | | EclipseLegal0 -
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