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
-
Download of current keyword rankings WITHOUT historical data
Hi there, I would like to download the current keyword rankings within a campaign without the historical data i.e. I need only ONE row for each keyword. I read an earlier post that suggested setting the data parameters within the last update period but I can't do this on my MOZ interface - whatever I set the dates to, I still get multiple rows for each keyword. I guess there must be a way to do what I need but I can't see it! Please advise. Many thanks
Moz Bar | | colinking1 -
Google map listings not shown as a ranking keyword
is there a way to have the google map listings show on my report as a ranked keyword. one of my competitors show their rankings in the organic as well as whether they are listed in the map section.
Moz Bar | | dhanson241 -
Rank Tracker Tool Accurate?
Hi Everyone, Just wondering if you all have been noticing inaccurate information in the rank tracker tool. Many terms are showing not in top 50, yet when i search from random devices that have never accessed my website before i find the url to be in the top 50. Anyone experiencing similar issues and anyone have any ideas why the inconsistency? Thanks
Moz Bar | | Prime850 -
Why Moz Rank tracker's results are different from results search in browser?
I would like to perform a competitor rank analysis in Google.gr . I have noticed that the results from the rank tracker for Google.gr are different than the results in Google.gr from a machine located in Greece with no Google account logged in. Could you inform me why such a behavior occurs?
Moz Bar | | thmavri0 -
Bing search match vs google
With the keyword research on moz it reports on bing search volume - does anyone know if you should multiply this for google searches - ie if I'm looking at a keyword with 2500 bing searches what should I be considering google would be?
Moz Bar | | Wickedwildweb0 -
Is there a way to star or favorite a specific Q&A?
I know we can subscribe to Q&A's for updates, but is there any bookmarking type option within the Moz Community Q&A so I can star or favorite my questions in one area? Often I come across really great ideas/solutions in the Q&A, and it would be wonderful to quickly access all of my favorite q's/discussions in one area for later. Thanks mucho.
Moz Bar | | EEE31 -
Is there any tool that checks the rankings at any time I want?
My problem is that in Moz when I check ranking it shows me only on a weekly basis. Acording to MOZ I was on rank 11 yesterday. This is not what my SEO guy has sent me in his report. And usually he is right. Would be nice to have a ranking report for each day. What is the sense of a ranking tool if I don't know what happened between 2 ranking dates? How can I check that? Is there any rank history tool? Or a tool that will check in real time. The way I do it sometimes is to go on google.com/ncr to see the us version of google because I am in Europe. Rank tracker does not work for me at the moment. Get ranking button is inactive. My old keyword list has not been imported from SEOMOZ
Moz Bar | | Valentinopolus0