Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Can you export a keyword rankings report with the keywords listed in order of ranking ?

Moz Pro

590

jlane9 last edited by

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.
1 Reply Last reply
Reply Quote 0
danatanseo last edited by

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
1 Reply Last reply
Reply Quote 3

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

How to Combine the Moz Keyword Difficulty Tool with Google Keyword Planner for LOCAL (city/town) Results

Hi there, I wish that Moz would show local (city/town) results in their Keyword Difficulty Tool. But they don't, so here's my question: I'm trying to rank for keywords "interior design" in a local geographic area in the US. When using Google KWP, I'm selecting all the towns I want to rank in, and searching against the keywords INTERIOR DESIGN. The search volume appears to be approx. 370 a month. What I'm not sure about is whether I should instead (or in addition to), be searching for INTERIOR DESIGN (CITY), and leaving the geographic selection as US. What is most accurate? OR...should I search for INTERIOR DESIGN (CITY) in Moz's Keyword tool? How do you guys do it?
Moz Pro | | lulu71

0
How can I create a keyword ranking report with a custom date range?

I need to see change since campaign inception, and would like the flexibility of other date ranges. (in a list form, not per keyword) Does Moz have a way to do this yet? This is the one feature I really need that Moz hasn't historically had. Can the API be modified for this? Would appreciate some feedback guys!
Moz Pro | | dspete

0
Can I rely on Keyword Difficulty tool?

I just ran into a problem that I hadn't expected. Testing the Keyword Difficulty I saw the results contained a result for a page that has Domain Authority=1 and Page Authority=1. As a result, Keyword Difficulty was reduced (compared to last month), which may actually be reversed if the site is crawled. Sadly, I didn't run the report on the figures as it was a small project. Questions: Can I rely on results shown by Keyword Difficulty? Are results where Domain Authority =1 are used to calculate Keyword Difficulty? If so, why is that? Is there any difference between a page that has received no links and a page that OSE/Mozscape has no link data for? The problem Using the Keyword Difficulty tool, I found swings of up to 14% in Keyword Difficulty (between Oct -Nov). Dr Pete may suggest that this is because of changes in Google's index ( http://www.seomoz.org/blog/a-week-in-the-life-of-3-keywords ). However, It would be helpful to have a figure for Keyword Difficulty that isn't affected by the gaps in the Mozscape data. The (bad) solution You can mirror something close to Keyword Difficulty using: =(Sum of Page Authorities + Sum of Domain Authorities )/20 Right now, I have resorted to manually calculating keyword difficulty. I use the SEOMoz Page Authority & Domain Authority figures and a quick splash of Excel SUMIF and COUNTIF. I find the results don't look as 'easy' when I can ignore results where the data is unknown (PageAuthority=1 & DomainAuthority = 1). Background Info One result I still have a report on is for the phrase [fixing your business puzzle] using US Results on Google. For the specific result, I found the additional information about the site: DNS lookup shows the domain was registered in 2010
Archive.org shows no records
OSE shows no data for the site
Site uses https
Google showing No links
Robots.txt file seems fine
No Sitemap.xml
Moz Pro | | Darroch

0
Local SEO Rankings Report Tools (based on several locations)?

Hi, Just a quick question. I am looking for a Rankings Report tool that allows a user to not only provide a list of Keywords, but also a list of Locations for which to check Google UK's ranking results. In practice, I would like to be able to enter 6 names of Towns next to my keyword list and get "localised results". Many thanks in advance, Cheers Greg
PS: first Q within the Q&A, so please apologise for any potential "stupid questions"
Moz Pro | | GregoryTK

1
On Page Ranking Tool Giving Weird Reports

My on page ranking tool is giving two entirely different reports for my website - I get one report for my domain name and a different report for the index.html even though essentially both of those pages are...well...the same. Not sure what's going on, hoping it's not an indication of a more serious issue? I appreciate any help!
Moz Pro | | Virage

0
SEOmoz campaign - keyword rankings...

Hi there, I have a quick question: Does it make a difference if I add keywords to a campaign with the '[' and ']' brackets included? I just realized that I had copy/pasted many of my keywords from the exported CSV from the Google AdWords Keyword Tool and I fear that the keyword rankings on SEOmoz might factor the brackets as part of the keywords themselves. Thanks in advance! Ben
Moz Pro | | BenHammer

0
Traffic reports

this may be a realy silly question to ask but when im trying to print off traffice report I can only see reports based on my keywords is their a way to show all traffic not just based on my keywords?
Moz Pro | | seoactivejames

0
Bing Not Complete in Ranking Report

Curious as to what the "FRI" image means under Bing on my Keyword Ranking reports? I saw this on Friday and assumed it hadn't crawled yet (as it was to set to crawl on Friday Jan 27, 2012) but here we are Monday AM and I'm still seeing the same thing. Glf4F.jpg
Moz Pro | | QueenSt

0