Download of current keyword rankings WITHOUT historical data
-
Hi there,
I would like to download the current keyword rankings within a campaign without the historical data i.e. I need only ONE row for each keyword.
I read an earlier post that suggested setting the data parameters within the last update period but I can't do this on my MOZ interface - whatever I set the dates to, I still get multiple rows for each keyword.
I guess there must be a way to do what I need but I can't see it! Please advise.
Many thanks
-
Hi Joe,
You can select the date range in Campaign - Rankings located in the upper right-hand corner. Once you have your desired date range, just export the CSV and it will include all ranking collection dates in the specified range.
Hope that helps!
-
Hi - Thanks for posting!
Exporting a CSV of Rankings data from a campaign will always include at least 2 collection dates, unfortunately. This is to show a comparison/rate of change. A workaround would be to select "Last Week" from the date range and then just remove the older dated rows from the CSV. Hopefully, that helps to clarify, and sorry for any inconvenience that causes.
Best,
-
I might be a rookie - but I am looking for exactly what you get.
How do I get historical rankings by keyword?
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
-
Keyword explorer tool - keywords by domain functionality
Hi, We have issues with the new searching for keywords by root domain functionality in keyword explorer. We are based in Australia and need rankings for google.com.au, which is what we have set up within our MOZ campaign ranking reports. The explorer tool rankings are way off and not accurate for our site's actual rankings. Also, many of the top, high volume keywords that we are tracking and for which we rank on first page for are not even appearing when I do an explorer search using our root domain. Is the root domain functionality within keyword explorer providing results based on google.com rather than google.com.au? Does this mean that if we are outside the US that we can't use the tool as it is not accurate? Cheers, Damien
Moz Bar | | Devenish0 -
Bulk upload of keywords for rank track
Hi, In Moz - Can I bulk upload hundreds of keywords' spreadsheet to Moz in order to schedule a weekly email report tracking my rank? Please indicate the steps how. Many thanks. Katarina
Moz Bar | | Katarina-Borovska0 -
KW Explorer is Working to Disambiguate Keywords Google Merges Together
Hey gang, Russ Jones from Moz has been doing a ton of heavy lifting work to try to get around the new problem posed by Google AdWords recent change to merged-keyword volume data. But, we're fighting back against this obfuscation in Keyword Explorer. I'm sharing two emails (slightly edited) from Russ about what we're doing here: Introduction to the Problem: Google Adwords Keyword Planner is the primary source for keyword search volume (how often a keyword is searched monthly on Google) for much of the search marketing industry. While Google has grouped together highly-similar terms for a while (especially misspellings), in June of 2016 they dramatically increased this keyword-grouping. This means similar phrases like "keyword rank", "keyword ranking" and "keyword rankings" would all be reported as having the same, combined search volume, rather than their individual search volumes. If you were to take Google's numbers at face value, you might think there are 3,000 searches per month for these 3 terms, when in reality there is only 1,000, divided amongst the 3 terms. How we are addressing it: Moz's Keyword Explorer uses a blend of data sources, not just Keyword Planner, to build our volume metrics. This gives us a distinct advantage in that we can adjust the volume of words that deviate dramatically in one data set verses another. Take for example the phrases "keyword rank", "keyword ranking", and "keyword rankings". While Google Keyword Planner might report all of these as having 1,000 searches per month, Moz Keyword Explorer can detect that these numbers are significantly higher than what our models would predict given our other data sets. We can then adjust the volume accordingly. Moreover, given our huge keyword data set, we can also identify grouped phrases (like these 3) and divide the volume proportionally to what we see in our other data sets. Thus, we address the grouping problem from multiple directions. Here's email #2 from Russ, detailing more of how we're attacking this: I have been working pretty much non-stop on this keyword volume disambiguation problem (finding the real search volume of individual keywords when Google clumps several together). I think I have settled on a pretty good solution and am working on getting it all in. For example... Google Keyword Volume for the phrases "briefcase for women" and "briefcases for women" are both at 3600 because they have been lumped together. My disambiguation script says the singular (briefcase for women) should be 2731 and the plural should be 869. Google Trends roughly agrees with this, showing that the singular is searched more than 2x the plural: https://www.google.com/trends/explore#q=briefcase%20for%20women%2C%20briefcases%20for%20women&cmpt=q&tz=Etc%2FGMT%2B4 Basically, Keyword Explorer should already be providing some more accurate/segmented numbers than AdWords, and in the future, we'll get even better thanks to our clickstream data and our evolving models. Any questions, let us know!
Moz Bar | | randfish15 -
Keyword Difficulty tool showing Google search volume or Bing?
Hi, I plugged in a bunch of keywords to know their search volume, chose Google from the drop down and then chose English from the next dropdown and clicked on Check dificulty. It shoes me "Bing Search Volume (Exact Match)" on top but shows the name of the keyword and "for Google CA" on the left. Is the search volume for Google? or Bing? and the difficulty as well? Google or Bing? "
Moz Bar | | SpaMedica0 -
Anyone else seeing completely wrong metrics for rank tracker?
I'm really upset, I have used it to work on a spreadsheet with thousands of words and today I decided to check and a keyword we rank #1 for showed as not in top 50. This makes me very nervous.
Moz Bar | | Sika221 -
Rank tracker
Hello, Rank tracker is not working, It says submitting but nothing happens? Does anyone else have the same problem? Greetings, Maarten
Moz Bar | | FindFactory0