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
-
Moz keyword mention on-page counting errors
Hi. Moz is showing 18 mentions of the keyword 'street furniture' on this landing page https://www.broxap.com/street-furniture.html But I can only count 6 in total in the body copy and 13 if you include navigation links. This is the same on other pages too for that keyword. Does anyone know where it's counting these extra keywords from? I don't want to fall foul of keyword stuffing but as far as I can see we're not! Could Moz be miscalculating? Any help appreciated! Thanks Joe
Moz Bar | | iweb_agency0 -
Fresh Web Explorer: if you put a keyword in quotes, is it case sensitive?
For example, would a saved search for "racor fuel filter" capture mentions of "Racor fuel filter"? I'm really hoping I don't have to duplicate the keywords with the alternative capitalisations!! Many thanks Steve
Moz Bar | | swbaxter0 -
How do I pull a rankings report for a specific week in the past?
The date of the rankings I want is January 13th. I can see the individual keyword history in rank tracker, but I have to go each word. I'd like to just have that report to compare it to, since that is when a lot of our rankings changed. So I need that report to compare our future efforts with. Please advise and thank you! Ruben
Moz Bar | | KempRugeLawGroup0 -
Onpage Grader not Finding Keyword in URL
I've noticed that the Onpage Grader is not including my keyword in the URL when the keyword is in the domain. If I grade an inner page and the keyword is in the sub-directory, it finds it. Is this intentional? If so, why does the grader not include my keyword in the domain as Keyword in the URL?
Moz Bar | | Dino640 -
Keyword Difficulty Tool - Bulk Data of Specifics?
For the keyword difficulty tool, if I want to see the details, I have to click on the keyword in order to see the list of the competitors and their DA and RLRDs. Is there a way to download this list for all of the keywords and their DA and RLRDs? The only bulk I can download is the list of keywords in my difficulty tool list along with their Bing search volume and keyword difficulty %. Thanks!!!1
Moz Bar | | Titan5520 -
Tracking Across 3 Sub-directories on the Same Domain in Google Analytics
Hello everyone, I'm trying to track 3 sub-directories on the same domain. http://domain.com/1/http://domain.com/2/
Moz Bar | | vndflkvnlkzdfnv
http://domain.com/3/ Could someone help confirm this is the correct code for GA? var pageTracker = _gat._getTracker("UA-12345-1"); pageTracker.**_setCookiePath**("/1/"); pageTracker._trackPageview(); pageTracker.**_cookiePathCopy**("/2/"); pageTracker._trackPageview(); pageTracker.**_cookiePathCopy**("/3/"); Thanks in advance.0 -
Rank Tracker page shows only first 50 entries
On the Rank Tracker tool page, http://moz.com/researchtools/rank-tracker, when I hit the Next 25 it works the first time but none of the others. Trying to run a report and since we have more than 50 keywords I have to manually click on them to be checked.
Moz Bar | | HopeIndu0 -
Moz Analytics only working with Google Analytics?
Hi, My company uses Piwik for analytics. Do you know if there is a way to make the new Moz Analytics work with Piwik? Or if Piwik support will be provided at some point? Thanks! P.S. : I know it would be easier to switch to Google Analytics, but for many reasons we can't 😞
Moz Bar | | Xilopix0