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
-
Keyword Count Incorrect In On Page Grader
Hi, I have found that on one site I am working on seems to have issues when i run it through the on page grader. The problem is that it is saying I am showing the main keyword 24 times in the body, but actually it is 12 times. Could there be a problem on the website that is showing something I cant see, or is this a known issue. Thanks
Moz Bar | | DaleZon0 -
Hald the keywords in my keyword list say "Gethering Metrics". How do I get that to complete?
I'vwe waited about three hours, with no change. Why does this happen — is it something I did? Will those metrics ever be gathered? Or do I need to re-do buildingthe list all over again? And how can I be sure it will be any dirfferent?
Moz Bar | | btreloar0 -
Keyword Stuffing Count Differs to Source Code
Moz's on page grader counts 33 instances of a keyword however, when looking into the source code I only find 8. I have checked if capitalization affects the find feature when viewing the source code and it doesn't. Has anyone else come across this issue and found an explanation?
Moz Bar | | Worship_Digital0 -
Is there a way to track mobile rankings vs desktop rankings in Moz?
With the new release of Google's mobile algorithm we want to start tracking keywords mobile vs desktop. Any suggestions?
Moz Bar | | TicketCity3 -
I'm checking keyword difficulty for two different sites. Would love to view the results by site instead of just one large list. Is that possible? Or would it just be easier to keep the lists separate in Excel and just import when I want an updated report?
I have keyword lists for two sites. Is there a way to label them in the keyword difficulty tool (List A, List B) so I can just view results for a particular site? Or do I need to run the report with List A, export results, delete those keywords, then run the report for List B?
Moz Bar | | JohnNovakLV0 -
Ambiguities In The MozBar Keyword Difficulty Checker
Hi, This is more of an observation rather than a real issue. But I noticed that when I check a keyword difficulty in Google by pressing the button that appears I get a different % result to the same keyword placed in the campaign. I suspect that it is something to do with being in the UK, however, If for instance I go to google.co.uk and place in the search bar IT support company Portsmouth I get the result 44% appear but in the keyword difficulty tool I get the result 34%. It seems to do this on all the keywords I have checked. I also checked both US and UK results in the campaign but neither of these came up within the 10% difference of the toolbar. Like I mentioned though, not a criticism, just an observation, its still a very handy little tool. EDIT 06/18/14: I thought I would just add that I am now getting some seriously odd results. For instance, if I put in the keyword 'hairy blue widgets for sale in Outer Mongolia' it returns a difficulty level of 71% ??? Thanks
Moz Bar | | southcoasthost0 -
On Page Grader Returning Large # of Keywords
When using the on-page grader the results show the below for a page with a specific keyword in the body only 5 times : We found this keyword used 1100 times. Any Idea why this would be showing such a high number? The keywords are in Thai language but there is a space before and after the keyword. Thanks.
Moz Bar | | brettjohn670 -
Moz Rank Tracker - showing deleted subdomains results for entered keywords
We have recently deleted subdomains because they were causing duplicate page errors but now the Moz rank tracker is showing the subdomain key word results even instead of the exact url we entered. So for example wine cellar is showing up for a deleted subdomain (winecellar.vigilantinc.com) instead of the entered exact url of (vigilantinc.com/winecellars/) Please advise. Thanks!
Moz Bar | | KristyFord0