Csv download from open site explorer
-
After I run a report in Open Site explorer and download the csv, the bar says it processing # of 10,000 links, when the report is done and i open it there are only 450 links
-
I have been running reports on linking root domains to compare with competitor sites.
In all cases the report download only contains a small subset of the report results.
As the results are linking root domains they should all be unique I think? So for example if there are 1,500 linking root domains in the report why are there only 400 (exact number) when I download?
For a competitor site there are 3000+ linking root domains and in the download only 300 (exact number)
The exact numbers are suspicious and suggest some kind of culling of the full report but I cannot see why this is. How can I download all of the linking root domains?
-
Good explanation Matt.
-
There are two reasons you see fewer than 10,000 results.
1) The LSAPI has a max requests of 10,000 but your actual number of results will be the "Total Links" number when you first run your OSE search. So that part is "Max" 10,000 not necessarily what you're getting. Let's say your total results are 2500. Assuming unique domains, you'll get an export of 2500.
- On the other hand, you see 2500 in the search but only get 450 but when you export.: OSE only reports the top 25 results from each external domain so if you have 500 from one domain, you're going to "lose" 475 results when you export. Do that for a few domains and 2500 quickly becomes 500, etc.
Make sense on both parts?
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
-
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 -
I am trying to find inbound links for one of my site urls. My question is does SEOMoz able to track all internal links as the Open Site Explorer shows 0 internal links?
It shows 0 internal links when I am pretty sure we have multiple internal links.Should we use absolute urls or relative urls for internal links?
Moz Pro | | SulekhaUSLLC0 -
Big changes in site titles
So as I pour though some of the diagnostics data for over 100,000 pages of my site I see thousands of page title that "could" be changed. Could this cause some lost traffic for a while due to the big changes?
Moz Pro | | dvduval0 -
Usable to set up campaign because site cannot be
I don't understand this message. i never had problems with other sites and now I get problems with this message when trying to set a campaign twice for 2 different sites. I received the same message twice. What do I do? Help! We have detected that the root domain xxxxxxxxxxxxxxxxxxxx does not respond to web requests. Using this domain, we will be unable to crawl your site or present accurate SERP information. Thanks.
Moz Pro | | mcuneo0 -
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 -
Alexa Ranking Sites
I found these two sites giving my competitor link juice: http://www.webnamelist.com/alexa/Alexa_186.html http://www.list-of-domains.org/alexa/Alexa_185.html I have seen these sites before and I just dont get why they are authoritative. The funny thing is I did a search for my competitors link on the page and its not showing up, is this a problem in site explorer? Why is site explorer mentioning these sites as my competitions best links when these links do not exist on their site?
Moz Pro | | SEODinosaur0 -
Fetch googlebot for sites you don't own?
I've used the "fetch as googlebot" tool in Google webmaster tools to submit links from my site, but I was wondering if there was any type of tool or submission process like this for submitting links from other sites that you do not own? The reason I ask is, I worked for several months to get a website to accept my link as part of their dealer locator tool. The link to my site was published a few months ago, however I don't think google has found it and the reason could be because you have to type in your zip code to get the link to appear. This is the website that I am referencing: http://www.ranchhand.com/dealers.php?zip=78070&radius=20 (my website is www.rangeroffroad.com) Is there any way for Google to index the link? Any ideas?
Moz Pro | | texmeix0 -
My Campaign just picked up the .com.au site and is showing data
I've got a campaign set up here in SEOmoz and it appears that it just started picking up data for a site that is not mine. Our site is examplesite.com and i noticed that SEOmoz has begun including examplesite.com.au and is showing 20,000 302's from this site. The .com.au site is in no way related to our business and should not be tracked in our campaign. Has this happened to anyone else?
Moz Pro | | WP_SEO0