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
-
Thanks Keri,
I think this might be user error!
The problem only seems to occur if I import the CSV into an exisiting Excel spreadsheet. If I directly open the same CSV in Excel then it formats as expected.
So my mistake it seems. Sorry for wasting anyone's time!
Ben
-
This sounds like something that the help desk should know about so they can fix it on their end. Could you please each send them an email at help@seomoz.org with the details and maybe a sample CSV?
Thanks so much, and sorry for the troubles.
-
Hi Ben,
I have the same problem, I think it can be the commas, but the way I choose to solve it is open it in numbers with a macbook pro...
If somebody know how to solve these problems, please respond to this post!
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
-
How reliable are the external link metrics found in the Open Site Explorer research tool?
I have noticed huge discrepancies with the external link metrics of one of the websites that I have been tracking since the launch of the website. Shortly after launch I captured a screenshot of the external link metrics to the website to track the progress. As I look at the same Open Site Explorer metrics now (2 months later) it has increased by 900% which is very inconsistent with the amount of link building done for the client. Thanks!
Moz Pro | | michaeleagar0 -
Can I export reports as CSV when signed up for pro trial account?
I've signed up for a trial pro account, yet when i try and export a report as a CSV i'm unable. Is this feature disabled for trial accounts? Many thanks, C
Moz Pro | | councilflat0 -
Old Incoming Links Redirected to new pages are not Being Factored on the Open Site Explorer
Hi, My website has been online since 1994. We have old links pointing to pages that no longer exist so what we have done is to create redirects to the specific page where the content is being displayed now. However, when we use the Open Site Explorer, the linking root domains do not show those sites that contain old links pointing to our domain. One good example of this one is: dmoz.org. Am I improperly handling the redirects? Or, what do I have to do so that old links that are being redirected to the new pages where the information is are accounted when calculating domain authority and trust? Thanks, Alex
Moz Pro | | costarica.com0 -
Why has my OSE csv report been finalizing for 3 days?
Hi guys, My CSV report has been finalizing for 3 days. Is that right? I read some posts from last year when there was a backlog Is that happening again. Can someone have a look at that please? Many thanks.
Moz Pro | | Rosewood0 -
Open site explorer showing zero backlinks
My new website: http://www.thelifesciencesreport.com/ is showing zero backlinks in Internet Explorer and I know of dozens that have posted our links: to name a few: http://www.pharmainfo.net/merck-news/02/10/2012/platform-technologies-promise-big-payoffs-juan-sanchez http://www.ibtimes.com/articles/296320/20120210/pharmaceuticals-pharma-medicine-platform-technologies-neurobiology-parkinsons-disease.htm http://www.google.com/finance/company_news?q=NYSE:MRK#
Moz Pro | | StreetwiseReports
http://www.businessinsider.com/platform-technologies-promise-big-payoffs-juan-sanchez-2012-2 http://www.traderwise.com/content/platform-technologies-promise-big-payoffs-juan-sanchez http://silverspotprice.com/
http://www.ihavenet.com/merck.html http://www.wallstreetwindow.com/aggregator/categories/1 any reason this is happening?0 -
SEOMoz SERP Overlay Vs. Opensite Explorer
This may be a simple answer, but when I search for a term and see a website on the SERP, the SEOMoz tool bar shows link data beneath the link. For this site in particular, it shows 300+ links for the root domain and for the page, it shows 8 links. When I put that website in opensite explorer, it shows the same data for the "Page" stats (8 links from 3 root domains), but nowhere can I find where the 315 links from 4 domains comes from. So my questions is why do those links show in the SERP overlay, but not in OSE? il5y9.png
Moz Pro | | GetFoundFirst0 -
Problems with OSE downloads
Ordered 5 reports last 24 hours, none received. Anyone else with this problem ? I do expect better from an expensive subscription. C'mon Moz, fix this new OSE report system please.
Moz Pro | | blocker04082 -
Certain Domains no longer recognised by open site explorer
Afternoon everyone (well, it is for me), We've been tracking the linking root domains to our domain for around 6 months now, alongside tracking these domains we have also been engaging in linking building activities. Our initial activities worked quite well with linking domains rising from around 620 to 720 in 3 months. However, recently we have seen those numbers begin to fall away, in many cases it is because certain domains have stopped linking to us, have become no=follow sites or have been archived. But, in some cases we can see the link is still there, and is being registered by other tools such as yahoo or webmaster tools. My question is really, does anyone have a way of working out why a link, that was in the past being registered by open site explorer, is no longer registering and presumably no longer passing over juice to help with domain authority. What kind of signals should i be looking for to tackle a 'decaying' link? Looking forward to hear your thoughts!
Moz Pro | | NigelJ0