Can you export a keyword rankings report with the keywords listed in order of ranking ?
-
My keyword ranking report shows the results all jumbled.
I can put them in order when viewing the report online, but when I export it , the results go back to all jumbled rankings.
-
Hi Joseph,
While there's not a way to pull this data out of SEOMoz pre-sorted, this can easily be done by exporting this data into a CSV, electing your datafields and then formatting these as a table in Excel. Then you can simply click whatever header you want (i.e. Google US Rank) and sort from smallest to largest, numerically, then Voila! You have your keywords sorted in order.
Hope that helps!
Dana
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
-
Can check my site
can you please tell me what should I do with this site I trying a lot to solve its issues. the link is here https://alazharquranteaching.com/
Moz Pro | | saharali150 -
How do you explain this in this Keyword Difficulty Report?
Hello here, I am trying to understand how my site virtualsheetmusic.com can better compete for the keyword "sheet music download" where we used to be 3rd until a few months ago, and now we are at the 5th spot. But here is my specific question: I can't find an explanation why two of our competitors are ranked before us at the 3rd and 4th spot. Please, look at the attached image (very wide) which shows the Keyword Difficulty Report for this keyword. You can also download a PDF of it here below: http://www.virtualsheetmusic.com/storage/keyword-sheet-music-download.pdf We are at the 5th spot, and the two competitors highlighted in pink are the ones I am talking about: I am trying to understand why they are ranking better than us, despite our metrics look much better than theirs. In fact, if I look at the metrics in the report, I can't find an explanation to justify their outrank against us, so there must be something else that the report is missing. Any thoughts about this issue are very welcome! Thank you in advance for any help. Sincerely,
Moz Pro | | fablau
Fabrizio [keyword-sheet music download.jpg](http://www.virtualsheetmusic.com/storage/keyword-sheet music download.jpg)0 -
Ranking dropped significantly
We have been doing SEO optimization based on SEOMoz reco. However, our page ranking for key words dropped significantly last night.. We used to be on page 3 but now could not even found it on top 20 pages. Not sure what happened last night. I checked google webmaster tool but did not find anything. Can you help?
Moz Pro | | hisstory20010 -
Local Vs Organic Search Keyword Ranking
This isn't a question. It's a simple suggestion that I'm hoping will inspire a change at Seomoz. I love what this site does. What it helps us do as community. What it helps us achieve collectively. This suggestion is based on that love... I think we all can agree that the rankings between local reviews and organic reviews are very different beasts entirely. They should then be treated this way within the Seomoz data with separate reports. The vast majority of reputable small businesses don't care about national rankings, but would rather get to the top of the local charts with their 5-star reviews. Can you imagine the power of a report that is dedicated to helping you shape your client's results to achieve this? I like seeing the results of local in the keyword report, but we need a report dedicated to local search to make a difference in our rankings. With all of the recent chatter on local search, I'm surprised this isn't already available.
Moz Pro | | TheCTC0 -
How Can I see my competitors rankings?
Hi, I can see my ranking details but I can not see my competitors rankings. Seomoz is not updating their ranking and there is some problem in rank tracker as I refresh the ranking, but it says it doesn't update it. Why? Regards, Zeeshan
Moz Pro | | Shehryar0 -
Does the page authority data also considers the on page factors like the presence of keyword in the title,meta text, and keyword frequency ??
The moz difficulty score considers four factors for the top websites. are the on page factors included in the page authority data ?
Moz Pro | | iQuanti0 -
Top ranking with no SEO
I ran an SEOMoz keyword difficulty report for the term "interim CFO services" and found that all of the websites that ranked really well for that term have good page authority and domain authority scores and plenty of incoming links.....except 1. result #5 has a page and domain authority of 1 and no incoming links, however it's ranked #5 in google SERP for this highly competitive term. see screenshots: http://screencast.com/t/NJiOn8N4l http://screencast.com/t/x6tU1RhX4j Is this ranking based solely on the domain name being 100% relevant? Did they just get lucky and hit the google rankings jackpot? If this is the case, by the same logic I am trying achieve high rankings for the keyword "outsourced accounting firm" and purchased the domain name outsourcedaccountingfirm.com and am not even ranked in the top 50 with google for that keyword. (it's very new though) any feedback on either questions above would be greatly appreciated. Thanks!
Moz Pro | | texmeix0 -
Best Keyword Ranking Report Tool
What's the best keyword ranking report tool that anyone is using currently? I have used CuteRank (booo), Rank Tracker, SEOBook.com Rank Tracker, etc. Cost isn't an issue - I'm looking for a free or a paid tool. I need to be able to export resutls in PDF and Excel format. Thanks for the feedback!
Moz Pro | | ezclickmedia0