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
-
Filer Keyword Suggestions By Difficulty Score
When I use the keyword tool, I'd like to be able to set the suggestions list to only show keywords below a certain a level of difficulty score. I know that I can click on a word to see it's difficulty score but that process is tedious. It doesn't seem like there is a direct way to do this. Has anyone developed an efficient indirect process for this? Has MOZ given any thought to including a filter for Difficulty score similar to the filter available for monthly volume?
Feature Requests | | Brandonrenfro0 -
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 -
In Moz's Keyword Explorer/Explore By Site, Can I Exclude a Keyword From the Results?
Hypothetical question - Let's say I sell tax preparation software and I want to see the keywords that "turbotax.com" ranks highest for. Based on that list I might want to optimize for similar keywords on my site. But if I use Keyword Explorer, select "Root Domain", and enter "turbotax.com" as the root domain, the first 200 or so keywords in the list have the word "turbo". None of those interest me. Can I exclude certain keywords (like "turbo") from the list? Thanks.
Feature Requests | | CurtisB0 -
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 -
Is there any way to filter by relevancy first and then volume second? Right now I just export the results of keyword explorer and do it offline. It would be great if I could do it online
I'm trying to filter the results of a keyword search in keyword explorer by relevancy first and volume second. But the minute I select volume the relevancy is completely lost. I know I can export them and manipulate it in excel but is there a feature that allows me to do this in Moz?
Feature Requests | | Anerudh0 -
Is it possible to view keyword rankings over the past 13 months?
The keyword rankings bar graph is a great visual representation to provide clients, but most clients like to see the past 13 months (vs. 12 months) so they can compare the current month to last year. It'd be great if the latest [monthly] keyword rankings showed all the way back to the same month last year (Ex. If I was looking at the keyword rankings for December 2015, all the way back to December 2014 would be graphed out.)
Feature Requests | | ZeroGravityMarketing0 -
Moz Weekly Keyword Ranking Received seems inaccurate - Australia
Hi, We have so many website being tracked in Google AU and we see too much ranking change ( both positive and negative ) but all inaccurate from MOZ. Our Manual Testing result matched correctly with Google where as moz results inaccurate. Is there anything happening . Our Website: http://www.gardenshed.com.au/ E.g : Garden shed - Moz Reported Rank #4 - Actual Rank : 11 Garden sheds - Moz Reported Rank #7 - Actual Rank : 23 similarly for all other projects .
Feature Requests | | emarketexperts0 -
Can Moz Reports Data be exported in Excel
Hi there, The moz reports are exported into PDF at the moment. Is there a way to export the data into excel? Thanks
Feature Requests | | Jacky.Bizcover0