Is there an automated way to import Keyword Rank Tracker data in Google Data Studio?

[Lvet]

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.

[BIGYAM]

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.

[effectdigital]

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

1. You'd need a developer to build the database and the tasks which updated it (API fetches)
2. If your ranking supplier changed their API significantly you'd have to pay to get it updated
3. 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

[Warren.Wittman]

The add-on only appears to import MozRank and link targeting information. Can you confirm that rank can be imported? Thanks!