Open site Explorer CSV output mixed up
-
If I download a CSV output of the external links and the characteristics of them, the output is mixed up. When I put the data in Columns, some columns are disordered. Do more people experience these problems? Is there some preference I have to adapt?
Thanks!
-
Thanks Martijn,
I will be emailing you back shortly.
Best,
Chiaryn
-
Hi Chiaryn,
Thanks for the reply! I will send you an e-mail, for I am not comfortable with sharing the URL in this public forum.
Regards,
Martijn
-
Hey Martijn,
Thanks for writing in and sorry that your CSV is looking off.
I'm wondering if there might be a formatting issue in OSE, but I'm not able to produce it on my end, so I was hoping you could provide me with some more information. If you aren't comfortable giving me this data in the public forum, let me know and I will create a help ticket in our system. I would need:
The URL you are searching
The filters you have set
Any modifications you made to the CSV
I look forward to hearing from you soon.
-Chiaryn
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
-
Organic Traffic Drops to Zero After Site Migration
I know this question is terribly general . . . but I don't even know where to start in terms of sharing info, which I would be glad to post on request. My site was recently re-designed and migrated to a new server. I certainly expected SOME drop in traffic as google gets the snew site all figured out, but as you can see this drop has been dramatic. It's a simple wordpress site, I have yoast ptimized on it, I don't have many obvious errors that have not already been fixed that I can see.
Moz Pro | | damon1212
I just . ..what the heck is going on and how can I fix it? Is it normal and takes a month or two to sort out? Help! Screen%20Shot%2012-04-15%20at%2011.32%20AM_zpsczdmzcjt.png0 -
How can we efficiently use Fresh Web Explorer and Just Discovered Links?
Love the fresh data sources SEOmoz is building for us. However, I'm frustrated by the lack of scale the tools offer. Let's say I have 30 competitors I want to watch (which is pretty conservative - if we're targeting 100 keywords on a site, we could easily have 100's of top 20 ranked competitors). If I have to run individual reports for each using OSE and Fresh Web Explorer, that would be hours of work every day/week. Ideally, I'd like to see a campaign feature where you could add 2-200 competitors to view in one report. You could view recent links (from FWE and JDL) for all competitors on one handy report, and sort by various metrics. So for example, if you wanted to view the top 10 links your competitors have gotten in the past week, you could see that in 30 seconds of work, vs many hours of work. Any others who think this would be useful? Any ideas for how we can use the data in such a way without this feature?
Moz Pro | | AdamThompson1 -
What is the best ranking checker solution for 100's of sites
Hello, We used IBP for over 2 years and it worked great. We were able to schedule every clients site to auto run and email our clients. Now IBP is terrible due to Google's new updates. We are looking for something cost effective since we have 100's of websites we check on a weekly basis. We are either looking for a great software that uses proxies to check, or a service that offers unlimited sites and is cheap per month. We have searched for many, however there are so many that we aren't sure what is good and what isn't. We tried Jonathan Ledgers new one and it's not good, we looked into Web CEO and it's per amount of websites which is expensive. We tried cute rank tracker which is free and added proxies and it doesn't work, it lags out and doesn't even track ranks properly. It wouldn't hurt if it had a built in report analysis of the website as well. So whats a good one?
Moz Pro | | MarketingOfAmerica0 -
Is there a way to pull ALL rankings for a site for a set of keywords?
I'm fairly new to SEOMoz, and am looking for a way to pull all rankings for a site with the keywords I've listed, not just the top ranking. So for instance if my site ranks for the keyword "widget maker in MO" in two spots. The current rank report will only show me the top result. I know I can click on each keyword individually and see a full list of the top 50, but I'm looking for a more automated way of doing this (I'm the only SEO at my agency and time is an issue). I previously used Advanced Web Ranking and the tool would like me pull a CSV of the top 30 sites for each keyword I was tracking and then I could just search for my site and pull those results easier. Anyone know of a shortcut or report I should use? Thanks!
Moz Pro | | OsbornBarr0 -
Why do some sites have a higher Page Authority than Domain Authority in OSE??
Hi, I have noticed when using OSE and enter a domain you very often see a higher Page Authority than Domain Authority. If someone could explain why this would happen then I would be very grateful - its my current understanding that page authority would ALWAYS be LESS THAN Domain Authority but that is not always the case (I have seen cases where PA is more than 10 higher then DA) Here's an example where PA > DA http://www.opensiteexplorer.org/links.html?site=www.primelocation.com Thanks
Moz Pro | | James770 -
How do I get the Page Authority of individual URLs in my exported (CSV) crawl reports?
I need to prioritize fixes somehow. It seems the best way to do this would be to filter my exported crawl report by the Page Authority of each URL with an error/issue. However, Page Authority doesn't seem to be included in the crawl report's CSV file. Am I missing something?
Moz Pro | | Twilio0 -
Opensite Explorer CSV Problems
I'm getting a few formatting errors in the CSVs I export from Opensite Explorer, after I've opened them in Excel. Specifically, in an Inbound Links export, there are several merged fields creating new rows. This seems to be caused by line returns in the Title column. At the moment I'm sorting these all out by hand, but it's a bit of a chore when there are lots of records. However it has to be done, because you can't sort of filter properly otherwise. Has anyone else had similar problems. If so. I'd really appreciate any tips to a) stop it happening, of b) speed up / automate the process of cleaning up the CSVs. Many thanks Ben
Moz Pro | | atticus70 -
Why does open site explorer show me Chinese characters?
Hi there, When using open site explorer to check the anchor text for www.bookvictoriafalls.com I see Chinese characters as anchor text. However, when I do the same for www.bookvictoriafalls.com/ I see normal English anchor text. Coincidentally this domain has dropped from first page rankings to outside the top 50. Is this a spam issue? Open-Site-Explorer.png
Moz Pro | | Robbern0