Is there an automated way to import Keyword Rank Tracker data in Google Data Studio?
-
I am creating an SEO Dashboard in Google Data Studio.
While it's easy to import data from Google Search Console, I have troubles in importing data from Mozzarellas tools.I thought about uploading a CSV file with the ranking to a Google Sheet Document, but I cannot find a way to do this at regular intervals with manual intervention.
-
The add-on only appears to import MozRank and link targeting information. Can you confirm that rank can be imported? Thanks!
-
To be honest I found Google Data Studio pretty horrible and was able to work much more easily with Microsoft's Power BI, though for corporations it's not free and the price-tag is steep
One feature that Power BI had was that, in addition to connecting to set platforms like Google Analytics, it could also connect to custom objects like an SQL database
If Google have been smart and kept up, I'd expect this to be a feature by now in Data Studio...
https://support.google.com/datastudio/answer/7020436?hl=en
Looks like I was right!
This could make your life really easy as long as your rank tracking supplier provides an API for their tool. You can make requests to the API and build your own SQL database of that same data for your own records. The server holding the SQL database would have to regularly run API-based tasks to pull the data from your ranking supplier, into itself
Once that was done, you could then just connect to your SQL database via GDS
- You'd need a developer to build the database and the tasks which updated it (API fetches)
- If your ranking supplier changed their API significantly you'd have to pay to get it updated
- You'd need to pay to host your database online somewhere
Other than that... Seems like a good solution. Sorry it's not super cheap and simple - though!
Even if your ranking supplier provides back-end exports only and no API, you can still do what you want. You'd just have to create a script that uses a headless browser to export the data and then push the CSV exports to your database. Again you'd assuredly need a developer's help! Using something like Python's Selenium or Windmill modules might be feasible
Hope that helps
-
I have not used it, but Supermetrics, an add-on for Google Sheets and Google Data Studio, has a Moz database connector. they have a free trial to see if it works out for you.
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
-
Monthly Keyword Volume Differences Keyword Research V's Campaign Rankings
Why are there differences in the keyword volume data, is this a UK only issue? Am I missing something? Within Keyword Research;
Moz Bar | | GrouchyKids
suspended ceiling systems swindon (0-10) Within Campaign Rankings:
suspended ceiling systems swindon (no data) It's not just one instance either its across multiple keywords.0 -
Can I retrieve city based keywords from Moz Keyword Explorer?
I was trying to take keywords based on cities, but could not find an option to set the city based target. Please help!
Moz Bar | | S-A-Marketing1 -
Crawling Problem : No-data Of My Site
Hey, Folks!! So It's Been More than a Month.And Moz is not crawling my website http://www.trickypedia.com/.I have seen Moz Last update I thought they will crawl my site but No results Disappointing. My Sites Domain Authority and Page Authority is still 1. But In other Seo Tools, they are Perfectly Crawling My Website. What Would Be the reason? Can anyone Please Explain.
Moz Bar | | seothatworks010 -
Lack of UK Keyword Volume Data In Moz
Is it just me or is there a considerable lack of keyword Volume data for UK Google search terms on Moz? I have 53 keywords and not a single one has any keyword volume data - these are not obscure terms and include the following as examples... leather satchel, leather laptop bag, satchels, leather bag, leather backpack, leather school satchel. Without this information aren't a lot of the services offered by Moz rather academic as it is impossible to know which terms are really worth targeting. What is the solution? I could use US data and hope it is similar but this seems close to a deal breaker for UK subscribers.
Moz Bar | | MrFrisbee0 -
Combined Countries in Keyword Explorer
Is there a way to view "all countries" in Keyword Explorer? I like being able to segment by country, when I need to, but I don't like having to pull multiple reports to get a combined view. It's more work and it eats up the number of queries I'm allowed to make per month.
Moz Bar | | vcj0 -
Understanding Keyword Explorer SERP Analysis
Hi Guys Based on the attached SERP analysis provided by Keyword Explorer, the term 'silver jewelry' appears to have a lot of potential; it has good search volume, high opportunity and potential scores; however when you look at the metrics associated with the top 3 competing sites, and the fact page 1 is dominated by major brands with equally good metrics, then a difficulty score of 26, meaning easy; seems a bit unrealistic. I would like to hear what others have to say, or am I missing something here. Regards Peter H96KVmH
Moz Bar | | SilverStar10 -
Keyword Explorer is Now Live; Ask Me Anything About It!
Howdy gang - as you probably saw, we launched our biggest new tool in Pro in many years today: https://moz.com/explorer If you're a Moz Pro subscriber, you've already got access. We went ahead and gave folks who were at $99/month before today 300 queries/month. If you're signing up new, $99/month doesn't have KW Explorer access, but the other levels - at $149/month and above, do (5,000+ queries/month). You can read the blog post here for lots of details, but if you have questions or product suggestions, please don't hesitate to ask!
Moz Bar | | randfish14 -
When Moz provides an on-page grade report card, what tells Moz which keyword to grade for?
I just started working with the on-page grader and of couse am particularly interested in fixing my pages with not so stellar grades. Can someone tell me how SEO Moz decides what keyword to grade a page for? I receive a report each week that tells me how many pages I have with A's, B's etc. But what tells Moz to grade a page for a particular keyword? Is it the first keyword listed in the meta description?
Moz Bar | | AliciaMarie0