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
-
How can I limit the impact of Google's mobile friendly updates on keyword rankings?
Hi everyone, I have a client on a monthly SEO package that is taking a hard hit in the rankings as their website is not mobile friendly. We are currently building a new website for them that will be fully responsive, but face the predicament of how to keep the current site performing relatively well in the rankings in the meantime. The site is generally well optimised and we always follow SEO best practices, so we've hit a bit of a stumbling block as to how to limit any negative impact the mobile friendly updates have on the site. Does anyone have any suggestions for damage limitation? Any help will be greatly appreciated. Thanks.
Moz Pro | | keyzo0 -
How can i download more than 10 reports per day (in Excel)? Thanks!
I am using Followerwonk to analyze twitter following. When I tried to download data into Excel files, i realized that there is a limit of 10 downloads per day. Can Moz allow more than 10 downloads per day on a special request? Thanks
Moz Pro | | rajansingh960 -
Rankings reporting showing inaccurate improve/decline/unchanged numbers
Our rankings report is showing inaccurate numbers for the improved, declined, and unchanged summary, both in the email and on the site. According to the added up numbers, we have 315 keywords in the campaign, but that's not possible as we only have 172 set up for it. The total for this section is correct, it just doesn't add up.
Moz Pro | | tncomseo0 -
Ranking Tool
We are considering purchasing your complete suite. Our question is regarding your Ranking Tool. We currently subscribe to Market Samurai and they provide us with keyword ranking abilities tied to our internal pages. Our domain, www.wklaw.com has hundreds of internal pages. (86 areas of law, each with 5 pages). will your ranking tool match our keywords to our internal pages? or does it only provide us ranks for the main domain? Thank you.
Moz Pro | | Wallin_Klarich0 -
Question About Moz Reports
Hey guys Is it possible to change the date/time that SEOmoz runs its ranking reports? I put together ranking reports each Monday which I need to feedback to the business and it would be good if I could schedule these for late Sunday or early Monday mornings for me coming in to the office.
Moz Pro | | EwanFisher0 -
SEOMoz Keyword Limit
I am trying to add keywords to my SEOMoz campaign and it says I have reached my 300 KW limit eventhough I have only added 1 word! Any suggestions? uwt2V
Moz Pro | | theLotter0 -
SEOMOZ reports the statistics.
SEOMOZ reports the Statistics, but where do i manage & improve??? Simply Statistics is all about SEOMOZ??
Moz Pro | | webicers0 -
If my keywords aren't driving any traffic to my site, why am I still ranking for them?
In several of our campaigns we have watched our keywords steadily climb the rankings without ever registering so much as a blip in the traffic data column. If these keywords aren't driving any traffic to our site, how are we still ranking for them?
Moz Pro | | MackenzieFogelson0