CSV export of Open Site Explorer is incomplete.
-
I exported my back links report from the Open Site Explorer toolbar as a CSV but the file it showed was only about 400 urls. The tool bar is listing over 1,200 links, so at first I thought maybe it was only exporting one link for each unique domain, but it only lists 200 or so unique domains linking to my site. I know it will only export 10,000 urls, but obviously I'm significantly below this level.
Here is a link to a competitors site which is having the same issue.
http://www.opensiteexplorer.org/links?site=www.zoobooks.comListing about 900 links and only generating about 500 in the CSV report.Any help would be much appreciated.
-
Hi Brian,
So sorry that you didn't get a response before now. I've seen another report of this in Q&A as well. The help desk staff generally doesn't hang out in Q&A, which is why you didn't get an answer from them here. Can you please email them at [email protected] with this information and open a ticket so they can work on fixing this glitch? Thanks!
Martijn Scheybeler does report in the other question that
What "worked" for me was waiting for a minute and re trying to download the export. Most times the second attempt was successful. It's just a work around eventually.
I would also recommend reporting this to the Moz team so they will have more user data to solve this problem.
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
-
Escape commas in OSE csv export
Hi When I import an OSE Site Crawl .csv to Excel, the lines get messed up. This is due to commas within the crawled site: For instance, when there is a comma in the Meta Description field, it gets separated into two fields. Is there any way to escape this so that only the correct fields get separated? Thanks!
Moz Pro | | zeepartner1 -
Broken CSV files?
Hi, I have been downloading fiels from seoMOZ for quite a while and I keep getting broken CSV files. ON my Mac, I wrote a script that cleaned them out but I cannot (don't know how) do this on the Windows side. The problem is that some of the record lines get broken up mainly in the "Anchor Text" field (maybe the anchor text in question contained a return). This of course messes up my file when I open it in Excel. Is there a way get/open these files without having them messed up like this? P..S. I am also seeing problem with text encoding, I would like to see the anchor text that is being diaplayed on the referring site rather than its HTML/Unicode/UTF-8 code value. TIA, Michel
Moz Pro | | analysestc0 -
Best way to rank an E-commerce site fast? [GOOGLE]
Does anyone have experience in ranking E-commerce sites? I'm trying to rank 1000+ subcategorys and 300+ products. All less than 1k Exacts some are just 20ish some go up to 1k. I've used Traffic Travis all keywords are ranked as [Easy] along with the tools here. My competition have 0 backlinks to there sites. Some sites have PR1-4 (only 2-3 per SERP rest are 0 so should be quite easy. However I'm up against Amazon and Google shopping for the products. Anyways what would you guys recommend me do?
Moz Pro | | InkCartridgesFast0 -
Looking to Hire an SEO Expert for Travel Site
Hello Everyone, I hope this is OK to post here. I run a travel website and we operate tours abroad. We are slowly expanding after nearly 10 years in the field. I started the company from scratch and currently do my own website design and SEO work. However, over the last couple of years I've lost the SEO connection due to being so darn busy. I started account here with SEO Moz in order to get the ball rolling again. We continually rank high for keywords, publish superb content by great writers, and overall are doing fine. I would just like to ensure this keeps happening and that we have an expert on board to help us in sustainable organic SEO practices. What I'd like to do is hire an SEO expert to help with our site. It might be part time (10 or so hours per week, perhaps?) Anyhow, I would like if this person used SeoMoz and really had their fingers on the pulse of the SEO world. I want all white-hat SEO, help with page optimization, internal link structure, and help getting quality external links. I know that over optimization is something that is now on the forefront of SEO work, so of course keeping this in mind helps. I would like to be kept up to date (perhaps weekly overviews of data and how we are doing) and am willing to make changes as quickly as needed on the site. I would like to see how we rank with competitors and what we need to do to stay on top - for the long term (no short sighted decisions). I want to learn as we progress, not because I want to do the SEO work myself, I just enjoy knowing what is going on. I will not micromanage. I am too busy for that : ) I am not sure what amount SEO experts are paid, but I have a slightly flexible budget. I really want someone will communicate when needed and is thorough in their responses. Attention to detail is a must. I would prefer an SEO expert located in the US but who also knows how to access / think about markets abroad (Canada/UK/Australia). I suppose we can discuss pay once I have a shortlisted group. I am looking to hire and work with someone starting pretty much immediately (even in May). For starters, I suppose our budget might be $500 to $1500 per month. For the first month or so, we might offer payment on a stipend basis just so we can ensure whoever is hired is the perfect fit. It would be great if this person had worked on travel sites before or has at least traveled abroad a few times. But, no worries either way. Thanks so much! Thomas at [email protected]
Moz Pro | | journeybeyondtravel0 -
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 -
Page Rank and offline sites
I have a domain with PR6 according to the Historical Pagerank Checker. But that last PR was calculated 2 years ago. I brought the site back online a few days ago and have checked that many/most of the backlinks are still valid. It is now in the Google index but the Historical Pagerank Checker shows PR0. Will it get back its previous rank or something close to it? How long will it take?
Moz Pro | | DomainOptions0 -
OSE Linking Domains CSV Export Blank?
For some client domains, I've tried to do a CSV export from the OSE Linking Domains page, I get a CSV that contains the typical OSE header text, but no output records. Before I click the CSV link I always choose "show domains with links to All pages on the Root Domain". It doesn't happen with every domain I've tried this with, and when I've had the time/patience, some of the time if I try hours later, I get data. The problem though is I rarely have the luxury of running reports a second time during the audit cycle. Has anyone else experienced this? Is it a bug, or just an export fail due to system resources or something?
Moz Pro | | AlanBleiweiss0 -
Will Open Site Explorer ever show number of links over time?
OSE is an amazing tool, but do you guys at SEOmoz have any plans to develop it so we can track numbers of links over time. I need to demonstrate to clients how the link building is going, and this would be a great quick report to see how many links you found on a given day, month, year, etc. A bit like magesticSEO backlink history graph, but better 🙂
Moz Pro | | timwills0