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?
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
-
Ranking now showing on google
So. its kind of weird. on my campaign keywords tracking I now have 4 keywords that my client site is being ranked for. (on Monday it was 2) however on Monday and now too. I cannot find my website when I try and search that keyword manually. i understand that Moz does not update and search every keyword every day but even after a few days now. also the rank tracker show different results for same keywords and these results too seems not accurate what am i missing?
Moz Bar | | SharonEKG0 -
Does Organic CTR from Keyword Explorer show percentage of 1st position clicks? If not, how to calculate?
I have two questions about the Organic CTR number from the Moz Keyword Explorer tool. I have read through the description here, but it is not very clear on what I need to know: https://moz.com/community/q/what-is-a-good-keyword-opportunity-score Does it calculate the percent of searchers that are likely to click on ANY of links from page one of the traditional organic search results? Or does it calculate the percent of searchers that are likely to click on the NUMBER 1 position of the traditional organic search results? I suspect the answer will be that it calculates the percentage of clicks for any of the traditional organic search results from page one. Which leads me to question two... I'm trying to calculate the estimated search traffic from each keyword if there was a number 1 ranking. And if the Organic CTR shows the percentage of clicks going to any of the traditional organic search results I need to add a modifier to my formula which will calculate how many clicks the number 1 ranking receives. So I think the formula would will look something like this: Monthly website traffic from keyword = monthly search traffic * Organic CTR * Number 1 Position CTR. In this case, what would I use for the "Number 1 Position CTR" modifier?
Moz Bar | | elementpaints0 -
What is a Good Keyword Volume Score?
Hi All! Continuing my series of discussions about the various keyword scores we use here at Moz (previously: Keyword Difficulty & Keyword Opportunity)... Let's move on to Volume. Volume in Moz's tools is expressed in a range, e.g. Bartending Certification has volume of 201-500. These ranges correspond to data we have suggesting that in an average month, that keyword is searched for a minimum of X to a maximum of Y (where X-Y is the volume range). We use clickstream data as well as data from Google AdWords and then some PPC AdWords campaigns we run and have access to when we build the models for our volume data. As such, we've got very high confidence in these numbers -- 95%+ of the time, a given keyword's monthly search volume on Google will fall inside that range. If you want to see all the nitty gritty details, check out Russ Jones post on Moz's Keyword Volume and how we calculate it. As far as a "good" volume score -- higher is usually better, as it means more demand, but lots of keywords with low volume scores can also add up to strong traffic when combined, and they may be more relevant. Capturing exactly the audience you want that also wants you is what SEO is all about. p.s. When Keyword Explorer or Moz Pro gives you a "no data" or "unknown" volume number, it may just mean we haven't collected information from our clickstream providers or AdWords crawls, not that the keyword has no volume (though it sometimes means that, too, we just don't know yet). One way to verify - see if Google Suggest autofills it in when you type in the search box. If it does, that's usually a sign there's at least some volume (even if it's only a few searches a month).
Moz Bar | | randfish11 -
Keyword used 2389 times in page
in the "on page grader" tool I get that the keyword appears 2389 times. I'ave searched for it in the developer console, thinking it might be due to invalid HTML - but the number it's appearance is no near to 2389. Can any one help me figure out why is this so? the page is http://naamanewman.co.il/photosGalleryID.aspx?id=34
Moz Bar | | digitalalchemy
keyword "שמלות כלה נפוחות" (hebrew) QDQW4xw.png0 -
Why isn't the Moz bar data populating for Yahoo sites?
The Moz bar isn't populating information for Yahoo homepage or it's verticals (i.e. homes, autos, finance, etc.), but I can get this data for other portals like AOL or MSN. I'm specifically looking for PA, mR, and DA information, but instead I get a generic "Search Profile" bar with no page/site-specific data.
Moz Bar | | AllieBell
Is there a reason Open Site Explorer data isn't populating for this particular portal?0 -
On-Page Grader is not counting H2 and H3 Keywords
I used on-page grader in one of my webpages and it showed the limit of 15 keywords used. The problem is that it counted only when the keyword appears in the Title, URL, Meta Description, H1, Body and IMG ALT. If you take into account the H2 and H3 tags, the count will go to 22. Is there a problem with the On-Page Grader Tool or it's not a problem to go above 15 keywords if they are in H2 and H3? Here's the link for the page: http://www.tororadar.com.br/acoes/bbse3-bb-seguridade/cotacoes-bovespa Keyword: BBSE3 Thanks in advance.
Moz Bar | | Guilhermealvesc0 -
Bulk keyword upload feature for Rank Tracker?
Is there a quick way to bulk upload a bunch of keywords to Rank Tracker without having to add one at a time? Also, once I get them in there, will they be there each day? Thanks!
Moz Bar | | Ibro0 -
Rank Checker and Keyword Difficulty
This is the only time I have seen this but the rank checker shows a keyword ranking #2 but the keyword difficulty tool does show the url ranking anywhere on the first page. I have some ideas as to why this may be happening but I am wondering if anyone actually knows?? Keyword: motion capture url: www.organicmotion.com/motion-capture
Moz Bar | | JBeaton0