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
-
Unsolved Make Moz reindex the pages for keywords
Hi Moz says we're 18th for a phrase but that's for the page /himonsia-generators because that was the highest ranking page. If you search now for "heavy range generators" we're jumping between 10-12th position but it's for the page /products/generators - which is correct. How can I make Moz "Reindex" the pages?
Moz Pro | | RichardAskew0 -
Looking for some help to train corporation on MOZ?
Short term. Basically helping a company train internal SEO people from round the globe. Involves time and fee to create your training plus several 4 hour sessions and possible follow up consulting. Pays well. Email me at ablanco@infusion.com. Thanks Al Blanco
Moz Pro | | InfusionAdmin0 -
MOZ Pro - Page Grader Queries
Greetings! I started a new position last week and the extremely supportive director promised to give me anything I required to make my job easier. Of course, my first port of call was MOZ Pro. Having never used MOZ Pro before, I've just been getting to grips with it, fixing any pressing issues and giving the whole site a general SEO health check. A few fairly major issues have been flagged, which I'm in the process of fixing, and I'm currently putting our main landing pages through the MOZ Page Grader. After a little bit of tinkering, our iPhone 6 cases page has been graded B for the term 'iPhone 6 cases', but I have a few queries/concerns regarding some of the suggested fixes: **Avoid keyword stuffing in document **- The term 'iphone 6 cases' only appears thrice in the body, so it can't be that? The term, however, appears 23 times in the page's img alt tags. Could this be the issue? This is an ecommerce site that sells iPhone 6 cases, so the img alt tags are bound to contain that keyword. Each img alt tag is unique, so I don't really know what I can do here? "Show details for YouSave iPhone 6 0.6mm Clear Gel Case" is the example of the img alt tag of one of the products on that page, surely I can't remove the words 'iPhone 6 case'? Avoid too many internal links - MOZ suggests keeping the internal links to below 100 or, at a minimum, less than 100 links on the main navigation menu. I haven't counted, but I'd guess that page has more than 100 links, but not too many on the navigation menu. To me, this looks like a standard ecommerce page, with links to products and different pages via the top and bottom menus. Would I improve visibility if I reduced the amount of links by, say, reducing the number of products on the page? We currently have it set to 36, but can easily be reduced. Only One Canonical URL - We've put a fix in place for this issue and are just waiting for it to go live. For some reason rel=canonical tags have been duplicated on the majority of the pages. Like I say, this is being remedied, but I just wondered whether a duplicate tag negatively affect the page's visibility? The tags are identical and just point to the page they're on. I think that's about it for now! Thanks in advance and keep up the good work! Cheers, Lewis (Andrew is the name of the director) UPDATE Now I've sorted the rel=canonical issue, the pages are being graded A but still with the first two suggestions above.
Moz Pro | | PeaSoupDigital0 -
How you can manipulate your MOZ DA
I have become frustrated at MOZ in the last few months, none of my backlinks have made it into the index. Old back links. Long story short, I figured out the issue and I figured out how anyone can manipulate their DA. I wrote a blog post about it here, http://blog.dh42.com/manipulate-moz/
Moz Pro | | LesleyPaone1 -
Has the Hummingbird Changes Effected the accuracy of MOZ?
Hello, I am new to the forum. Can anyone tell me if the recent Hummingbird Changes have effected the accuracy of MOZ? Specifically, keyword comparison of competition. Thanks, Derek
Moz Pro | | Chris81980 -
When is rank tracker going to work
has anyone heard when rank tracker under the research tools is going to be working, been a very long time. I use this tool to check on the progress of sites, I know that it is in the campaigns per week but i want the tool under the research tools and feel a bit let down by semoz over this
Moz Pro | | ClaireH-1848860 -
Moz Trust
I saw a severe drop in MozTrust for multiple sites I am working on. We have added some links this month, but would be considered 'spammy' or to be low quality. No other links appear to have been lost / removed. If we had some very high quality links before and have added some mid-level links can this be what is causing the drop? From the description on SEOmoz, it seemed to me that trust could only go up as links were added. It appears that I am missing something.
Moz Pro | | DigitalDiameter0 -
Are the Ranking Changes on SEOmoz ranking reports weekly or life of the keyword?
I am referring to the area where it says ranking changes and where it has a green and a red arrow for improved and declined.
Moz Pro | | JGar-2203710