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
-
Unsolved Did Moz Bar change to have no Keyword capabilities?
I'm trying to use it during SEO training over here and the KW button goes to a "Get Page Optimization Score with MozBar Premium - Try Free", with a link that takes you to: https://hsinfo.moz.com/mozpro/mozbar/lander?utm_medium=cpc&utm_source=google&utm_campaign=Brand | NA&utm_adgroup=Brand - MozBar&utm_term=mozbar&gclid=CjwKCAjwxOCRBhA8EiwA0X8hi4Tx1YaOVwzWZaCGmzmYdBO4JEON8YlRMw52stp2AyfEBbH4uWDnARoCum0QAvD_BwE? Didn't this used to accept keywords and allow keyword checking? My training materials have the KW button behaving like this: [1] Do Keyword Research in MozBar.
Moz Bar | | EricaJorgensen
1. Click the icon with KW and a magnifying glass.
2. Enter a term related to your subject. For example, "cyber security".
There is a section telling you the keyword score, the relevancy to your page, and giving you optimizations that you can make to the page regarding this term.... Thus, I feel sure KW had useful and free features and not a button for a trial and paid Moz Bar Premium account. What is the pricing for this feature now? Or am I missing something? Thanks,
Tracy!0 -
How accurate is Moz Rank Tracker tool? It's showing different results than a Google incognito search.
I have a keyword/url combo with Moz Rank Tracker showing 3 spots above what a Google Incognito search showed. I performed my Google Incognito search based on these suggestions: https://moz.com/community/q/best-and-easiest-google-depersonalization-method Is the Moz Rank Tracker tool off?
Moz Bar | | chiefmoz1 -
Moz Rankings vs DuckDuckGo
Hello, So we have a client that’s only interested in a handful of keywords. We would like track his rankings through a Moz Campaign but he currently uses Duck Duck Go to check them. Strictly from an accuracy perspective (and not necessarily added features like Mobile Rankings) is there any arguments we could use to convert them to Moz? If not we will let them know but any input would be appreciated. Looking forward to hearing from all of you! Thank you in advance for the help. Best,
Moz Bar | | Ben-R0 -
Confused by "Exact Keyword Used in Document Text at Least Once".
Hi, I am using the On-Page Grader to improve the SEO for certain keywords on certain pages. I have received the notification that the "Exact Keyword Used in Document Text at Least Once". Well from the looks of it I have already done this but I want to make sure that im checking the right thing. What does it mean when it says document text as I assumed it was text on the page but its not reading it as that. Any feedback would be appreciated
Moz Bar | | charlessimmons0 -
"Keywords Showing" total doesn't match "Tracked Keywords" total
My "Tracked Keywords" total under "Add & Manage Keywords" does not match the total for "Keywords Showing" on the main "Rankings" tab. Why is there a difference? For example, I have 453 tracked keywords attached to my campaign, but under the "Tracked Keywords Overview," there are only 254 listed. I'm sure there's a simple explanation but I can't find it anywhere!
Moz Bar | | MSoleski0 -
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 -
Keyword difficulty - benchmarks
hi, anyone know some good benchmarks? how many hours a certain keyword needs with what percentage? or how to really interpret the %? thanks, Walter
Moz Bar | | Walterman1 -
MOZ Onpage grade and Google ranking.
I have found for years that there is not necessarily any connection between the onpage given by Moz and the SEO ranking. "F" page can be #1 in Google for long periods of time, and "A" pages can be unranked. I do not see the consistency, so I am unsure how much time to spend optimizing as suggested. I know there are many factors in rankings, but I just wanted to point out that this lack of consistency makes me hesitate to make changes to well-ranking pages -- especially with algorithm changes happening all the time. It seems that everything is considered over-optimization of late, even if it is all natural language. It is hard to NOT use words or synonyms sometimes on pages, for example... Thank you for your great product. I just want to know how my time to spend on this matter or turn my attention to off-page factors where the inconsistency is hard to figure out.
Moz Bar | | gheh20130