The CSV export seems to have some linebreaks in it sometimes (e.g. in title column). That breaks excel import... any tips?
-
Example:
http://www.unav.es/alumni/actividades/enlaces.html,"Alumni | Agrupaciones territoriales | Club de montaña Alumni | Universidad de Navarra.",Kompass,39,81,2,10356,Yes,No,External,http://www.kompass.de/http://wikipedia.msn.de/wiki/Kompass_Karten, MSN Wikipedia - Kompass Karten,www.kompass.at,26,78,1,15883,No,No,External,http://www.kompass.de/
-
Is this an OSE (Open Site Explorer) export you're having issues with? If so I'd contact SEO Moz support.
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 Export to csv does not work
HI friends. For long time I cannot download csv reports for links. I need to export new spam links sort by spam score and compare to existing but export to csv button spins for ever and nothing happens
Moz Pro | | netcomsia0 -
Is BigCommerce a good CMS for Improving Search Visibility for our E-Commerce Business?
We have recently moved from Wordpress to BigCommerce and have noticed a decline in our Search Visibility score on MOZ. Following the recommendations of IT consultants, we were under the impression that moving to BigCommerce would significantly improve our Search Visibility. We were wondering if there is anyone out there who is currently using or have used BigCommerce and had similar issues? Any personal reviews/recommendations would be much appreciated! 🙂 Thanks!
Moz Pro | | lisakay0 -
Is Search Visibility actually weighted by search volume at all? Everyone seems to think so, but that seems completely wrong?
As I've been exploring Moz more, I've been looking into search visibility and what it actually represents. While searching for answers on Moz, I've seen several posts that all seem to think the search volume for keywords matters at all for the search visibility metric, and I'm wondering why anyone thinks that, when everything from Moz seems to indicate otherwise. https://moz.com/help/guides/moz-pro-overview/rankings/search-visibility describes the calculation as taking the CTR for each keyword, based on rank, summing those, and dividing by the number of keywords. This describes a simple, and completely unweighted by search volume, average. This means that if you are tracking 10 keywords, and rank #1 on 5 that have a search volume of 0-10, and are unranked on 5 that have a search volume of 70,801-118,000, that would generate exactly the same search visibility score as if you rank #1 on the 5 high volume, and are unranked on the 5 low volume. The above all makes search visibility look like a much less valuable metric than if it were appropriately weighted by volume, as well as potentially very misleading, since the % relates solely to the number of keywords in your analyzed segment, rather than to the % of search volume that you're obtaining (unless a) all of your keywords are the same rank, or b) all of your keywords have the same volume). Am I missing something, or is everyone just giving Moz way too much credit when it comes to the value of the search visibility metric?
Moz Pro | | JoelSharp1 -
Duplicate title on Crawl
Ok, this should hopefully be a simple one. Not sure if this is a Moz crawl issue of redirect issue. Moz is reporting duplicate title for www.site.co.uk , site.co.uk and www.site.co.uk/home.aspx is this a canonical change or a moz setting I need to get this number lower.
Moz Pro | | smartcow0 -
Rank tracking in Excel via MOZ API?
Hi there, i hope someone knows the solution to this problem. I created/ copied the "advanced Excel Keyword Analysis Report" that Dan Peskin was kind enough to share, you can find it here: http://moz.com/blog/how-to-build-an-advanced-keyword-analysis-report-in-excel. Now i m looking for a solution to rank my Keywords by using an API, preferably the MOZ API. My keywords are alligned in a column "Keword List", which will be regularly updated. Next to this column i would like to have a column with the corresponding rank. Is there a automatic solution, or do i have to do it manually?
Moz Pro | | Juri.Rabiner0 -
Missing Page Titles On The Comptetive Link Comparison Page
Hello, When I do a Link Analysis using the SEOmoz tools I have noticed that most of the pages listed on the Top Pages tab show [No Data] for page title. Any idea why that could be? The page source of those pages have one and only one <title>tag.</p> <p>Thanks!</p></title>
Moz Pro | | andersvin0 -
Excel tips or tricks for duplicate content madness?
Dearest SEO Friends, I'm working on a site that has over 2,400 instances of duplicate content (yikes!). I'm hoping somebody could offer some excel tips or tricks to managing my SEOMoz crawl diagnostics summary data file in a meaningful way, because right now this spreadsheet is not really helpful. Here's a hypothetical situation to describe why: Say we had three columns of duplicate content. The data is displayed thusly: | Column A | Column B | Column C URL A | URL B | URL C | In a perfect world, this is easy to understand. I want URL A to be the canonical. But unfortunately, the way my spreadsheet is populated, this ends up happening: | Column A | Column B | Column C URL A | URL B | URL C URL B | URL A | URL C URL C | URL A | URL B | Essentially all of these URLs would end up being called a canonical, thus rendering the effect of the tag ineffective. On a site with small errors, this has never been a problem, because I can just spot check my steps. But the site I'm working on has thousands of instances, making it really hard to identify or even scale these patterns accurately. This is particularly problematic as some of these URLs are identified as duplicates 50+ times! So my spreadsheet has well over 100K cells!!! Madness!!! Obviously, I can't go through manually. It would take me years to ensure the accuracy, and I'm assuming that's not really a scalable goal. Here's what I would love, but I'm not getting my hopes up. Does anyone know of a formulaic way that Excel could identify row matches and think - "oh! these are all the same rows of data, just mismatched. I'll kill off duplicate rows, so only one truly unique row of data exists for this particular set" ? Or some other work around that could help me with my duplicate content madness? Much appreciated, you Excel Gurus you!
Moz Pro | | FMLLC0 -
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