Is there an API to download keyword data?
-
Howdy fellow Mozzers,
We're tracking a client's keyword rankings in one of our campaigns and want to export that data on a regular basis to display in Tableau. Tableau let's us quickly match up different data sources and create visuals with the data. It's useful for marrying different data sources that don't normally talk to each other.
We know we can pull keyword tracking data manually, but we're hoping there's an API or scheduler that we can use to download the data automatically. Automating the process would be super helpful.
Thank you!
-
Thanks Lisa. I took the survey as well. One feature request:
Keyword volume over time is hard to get. It does not seem to be well covered in the market. Many of us need this to account for seasonality and time sensitive data like release cycles for media like news, movies, books, music, etc. Google updates their keyword volume on a very delayed basis, so it's not very useful for time sensitive areas.
Just a suggestion.
Thanks.
-
Hi Brett,
I was also looking for a way to automate the extracting of keyword data from Moz some time ago and hit the same wall. I have found a work around for it, which is far from ideal but does save quite some time. I have written an R script that uses Selenium to access Moz, authenticate and then get the URL that produces the .csv export. For example mine looks like this:
This makes the data available in my R session and then I can do pretty much everything I want with it. It is not an API so you won't be able to get the data straight into Tableau but you can save it somewhere and then just import the file. The script execution can be scheduled using Windows Task Scheduler if necessary. If you think this is something that may work for you, then I would be happy to share parts of the script.
-
I've taken the survey, but you may want to add another field asking for feedback on specific features. 2016 saw a lot of companies bring Business Intelligence in house with data display platforms taking a leading role in creating stories from data. Because of this my clients are a little more aware and want to do a lot more with data - which means I'm more critical of the data I can GET from an API.
It would be excellent if I could create an index of my keywords and the pages that are ranking, so I could identify which pages are ranking highly, and compare to the pages that are ranking low. Right now I don't have a method of compiling all the URLs that are ranking, or displaying which ones are hovering around position 11-13, which is low hanging fruit to bump onto page 1.
Most APIs don't offer the ability to draw out that information, which I could then create visuals and tables with. It would put Moz ahead of the competition to make more data points available via API.
-
Thanks Lisa, I appreciate the clarity!
-
Hi Brett,
Thanks for reaching out about this! We don't currently have a way to automate the keyword tracking data collection process and the data must be pulled manually.
I know that we have a lot of ideas for the future of our keyword tracking and an API is definitely on our wish list, but I'm not sure whether this would be used for campaign-like tracking. I'll make sure to bring this up with the Moz Pro product team again as something that would definitely be appreciated by our customers.
There is also survey you can take to register your interest in a keyword API and tell us what kinds of things you're looking for: https://www.surveymonkey.com/r/YZ58JVH
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
-
Moz Keyword Explorer - Explore by Folder
When using Moz Keyword Explorer to search for my ranking keywords is there any way to see the ranking keywords for a directory or folder on a site? For example: if a blog is located at a subdomain, I can see all the ranking keywords for the blog by selecting subdomain and searching for https://blog.example.com. However, I would like to be able to search for all of a blog's ranking keywords if the blog URL is something like https://example.com/blog/ instead. If this is not feature, can I request its addition? Thank you!
Feature Requests | | LEAP_US_Marketing1 -
Page Authority should get data from non AMP page
If you compare your scores with others sites when tracking a keyword and you or someone else has implemented AMP the score is a 1. It would be better to get the PA from the canonical reference. See screen shot for an example. Does anyone else agree? Can this be developed? cJp9J
Feature Requests | | dmcubed0 -
Feature request for Keyword Explorer
I posted this suggestion as a comment to a recent Moz blog post, but I thought I would add it here as well. I'm really digging the new Venn diagram view in Keyword Explorer and the ability to easily switch between various combinations of competitors. One feature that would be REALLY helpful (in addition to expanding to other countries) would be the ability to filter the keyword lists by specific strings. An obvious use case for that would be to filter out brand names -- I want to see how the comparisons look with non-branded keywords only. Another use case: Let's say I and my competitors have multiple product categories in common. It would be helpful if I could filter on some of the major head terms representing each of those product categories separately.
Feature Requests | | John_Mosier0 -
How long to see Keyword Opportunities results?
Hello! I am VERY new to using Moz Pro (and SEO in general) and my initial use is to find find keyword opportunities within a specific industry by comparing my clients' site to their top 3 competitors' sites. I have an initial list of keywords from my clients site (I've been tracking it for a week) but have not gotten any results from the competitors I'm tracking. How long does it take to see these keyword opportunities? My immediate goal (at this point): Supply my client a keyword audit of 30 keywords within their industry. Any suggestions on how to do this? Maybe I'm not going about it the right way? Or, do I just have to wait until the other sites I'm tracking populate data? Thank you for your help/advice! -SEO Newbie
Feature Requests | | Mbeas221 -
Including "Volume" on the Tracked Keywords Overview Page in Moz Pro
I've searched Q&A but I did not see where this question has been asked before, so hopefully I'm not repeating a question that has already been asked (and answered). For the past couple of years I have been using Conductor Searchlight as our SEO toolset, however recently I have made the decision to switch to Moz Pro. My question is regarding the Tracked Keywords Overview Page. In the current display, the Overview Page shows Keyword, Location, Universal Results, Rank, URL and Optimize. Has there every been any consideration to also include Volume? One of the nice features of CS Keyword Overview page was that I was able to view the rank of all my keywords, and the volume of each, at the same time. We currently track 275 keywords. Some keywords are obviously more important than others. The CS Overview Page allowed me to quickly scan through the list of keywords, see the ones that were within striking distance of page one (by rank), and since I could also see the volume at the same time, it also allowed me to prioritize which keyword to focus on. If two keywords were both ranked "11", but one had triple of volume of the other, it makes sense to focus on the one with the greater volume. From Moz's Tracked Keywords Overview Page I can drill down and get the "Volume" information that I'm looking for (and lots of other really good information), but I have to do it for each individual keyword. Moz Pro is a great SEO tool and the information available is amazing. The switch from CS has been an easy one, but CS did have some features that I liked, and being able to see both rank and volume on the Overview Page was one them. Any information, suggestions, or work-arounds regarding my question is appreciated. Regards Scott
Feature Requests | | WScottDuncan0 -
Will the Moz Keyword Explorer Tool (which I LOVE BTW) some day allow you to see search result figures broken down by location?
I know this is a long shot, but are there plans to eventually filter keyword volumes by location like the Google AdWords tool does today? Or is that never going to happen? Assuming not, are there other recommended avenues for teasing out keyword volumes of a local vicinity? I work for a health system, so nearly all of our customers are local. So I always feel like I have to guess on words like "urgent care" since obviously I'm not trying to rank nationally, but often people do not use a geo modifier term when searching.
Feature Requests | | Patrick_at_Nebraska_Medicine0 -
Is there a way to schedule automatic weekly .csv reports for the Tracked Keywords Overview?
Using The Custom Reports tool, I only managed to get PDF reports. It would be useful to automatically receive .csv reports by email. Any idea how?
Feature Requests | | Digital-Sun0 -
Way to track public's use of keywords over time in MOZ?
I apologize for the basic question but is there a way to track within MOZ the public's use of my keywords over time? My traffic understandably goes down certain times of the year -- holidays, vacation season, back to school, etc. What I want to see is whether my share of the traffic available is staying steady, slipping or even increasing. Sometimes I'll see a big spike in traffic that I suspect is related more to a general increase in traffic in my keywords than anything else. Thanks for any help.
Feature Requests | | NCCompLawyer0