Rank tracking in Excel via MOZ API?
-
Hi there,
i hope someone knows the solution to this problem.
I created/ copied the "advanced Excel Keyword Analysis Report" that Dan Peskin was kind enough to share, you can find it here: http://moz.com/blog/how-to-build-an-advanced-keyword-analysis-report-in-excel.
Now i m looking for a solution to rank my Keywords by using an API, preferably the MOZ API. My keywords are alligned in a column "Keword List", which will be regularly updated. Next to this column i would like to have a column with the corresponding rank.
Is there a automatic solution, or do i have to do it manually?
-
Hey everyone!
Unfortunately right now our API can only provide site specific data as we indicate on apiwiki.moz.com. We may look into providing an API that would pull campaign data that may or may not include rankings and to help our product team obtain feedback on what you would like to see, I highly encourage everyone interested to post and update a request on our feature request forum: https://seomoz.zendesk.com/forums/293194-seomoz-pro-feature-requests
-
unbelievable, we re pushing 2014, and still i have to do this manually.
-
we desperately want this too. as of february it was not available - https://seomoz.zendesk.com/entries/23150181-Client-Keyword-Ranking-Report-API
given the loss of seeing what google keywords are bringing people to a site, it makes monitoring ranking history by campaign that much more important. moz please expose this data in the api.
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
-
A question on keywords that rank 51+
Good afternoon everyone. I wanted to pose a question to the group about keywords and the "on-page optimization - grade a page tool." I have a list of keywords that I am trying to rank for. Some of them are not ranked in the top 50, so on the keyword ranking tool it gives you the 51+ message in the rank column. For the items that are ranked I can try to improve them by looking at grade a page and typing in the URL and keyword. It will then give me a score and suggestions on how to improve it. With that being said, is there an easy way to find out which pages I should be optimizing those keywords which rank at 51+ for, besides typing the keywords in Google and seeing what URL it associates with the specific keyword? I hope the question above is clear.
Moz Pro | | trumpfinc0 -
What exactly is Moz Analytics?
I've taken a look at this page - http://moz.com/products/tour and I'm trying to determine if Moz Analytics is live yet? I don't think it is, just wanted to make sure. Because right now I'm just seeing all the same tools as we've always had + Fresh Web Explorer. Anyways, let me know if I'm missing something.
Moz Pro | | CAndrew14.1 -
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 -
Loss of Google AdWords API
Since August, we've had intermittent access to the Google Adwords API. Like others in this space, they've let us know that our access has been revoked. We've been working to restore this access, but unfortunately, we have not been able to do so. In the meantime we are working hard to find a suitable replacement that is both stable and a good fit for our customers’ needs. We wanted to let our PRO members know, first to apologize, and second to explain how this has impacted your PRO access. We understand how important it is to have all your keyword data in one place, and we're sorry for any disruptions you've experienced from not having this data source in our app.We do want to clarify that this change does not affect your data from Google Analytics. The products affected by this change are our **Keyword Analysis tool and the keyword details and **keyword analysis pages within our web app. We removed this keyword query volume data within PRO a little earlier this year. You can still generate reports, but the metrics previously pulled from the Google Adwords data source is no longer there.The good news is, we don't actually use the Google AdWords data in our calculation of keyword difficulty, so these reports are still 100% accurate—they're just missing the information we usually pull from the API, which you can find on the Google AdWords Keyword Tool here. We're so sorry about this, and understand how frustrating the loss of this data is. We're hoping to have an alternative data source soon, and we will keep you posted as we make progress. Please feel free to comment, ask questions, and get help by replying to this post. Thank you!
Moz Pro | | AaronWheeler7 -
Article Directory Page Rank 7
Hi Guys, Would I be correct in my assumption that if I submitted articles to this directory: www . thefreelibrary.com I would recieve a link back to my site of PR7. Could this be correct? Any help with this and any information on Article Directories worth submitting in would be great. Thank for looking, Craig
Moz Pro | | fenwaymedia1 -
Google rankings dropped for some keywords
http://www.funktiongolf.co.uk uk google Our site ranked well for these words funky golf trendy golf clothes Now these keywords do no rank at all for my website. I have not been penalised by google as i emailed them. The only thing I did was add best seller products to my main page. Now my about us page ranks far higher than my index page Please Help
Moz Pro | | funktiongolf0 -
Ranking Tracking Internal Folders
We would like to track the rankings for an internal site. The website runs inside a big corporate website, url example www.domain.com/za/. How can we effectively track the rankings of only the website inside the folder? There is currently no sub domain setup for this site. Any advice would be appreciated.
Moz Pro | | DeloitteSA0 -
Cant understand Seo moz analysis
Did a semoz analysis of site www.1stclassdriving.co.uk and it came up with 484 pages with duplicate titles and 484 with duplicate content. Also gave me a 531st ranking for search term "Driving Lessons" (with many smaller schools with better rankings)- so I think that I may have a problem 1-Duplicate titles - I have many area pages - one for each of the post codes that we cover (some 40 odd) Each page is titled "Driving Lessons in "xxx" where xxx is the area.
Moz Pro | | Brian_Worger
Plus each Instructor has their own page which is tiled "Driving Lessons in xxx" where xxx is the more local towns/areas covered.
Is this the use of the term Driving Lessons xxx on each page the problem? The report doesnt seem to make this clear -it simply lists each page on the site 2- Duplicate content puzzles me as the content does differ although each instructor page has probably 80% content derived from a master page. Attach screenshot - hope someone can help Many thanx Brian0