Rank tracking in Excel via MOZ API?

[Juri.Rabiner]

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?

[DavidLee]

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

[Juri.Rabiner]

unbelievable, we re pushing 2014, and still i have to do this manually.

[icstars]

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.