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
-
Why do i get a difficulty and CTR score in keyword explorer when there is no min or max monthly volume on a search term?
why do i get a difficulty and CTR score in keyword explorer when there is no min or max monthly volume on a search term?
Moz Bar | | eezysee0 -
On-Page Grader giving wrong results for missing keyword in image Alt Attribute
I'm trying to optimize for the Keyword "River City Apartments" on this page: https://3fconstruction.net/case-studies/river-city-apartments-chicago-condo-deconversion-renovation/ When I use On-Page Grader to see how I'm doing it's telling me I'm missing the Keyword in the Image Alt Attribute. However, it's clearly in there. <strong>River City Apartments Aerial</strong> What am I missing?
Moz Bar | | Drew.Friestedt0 -
Keyword Explorer: Search by Domain Not Working?
We have tried Keyword Explorer for several websites today using the domain, subdomain and exact page option. None of these are returning keyword results. Is the tool currently broken? As a test we tried Amazon.com, see screenshot: JbWsaLi.png
Moz Bar | | SeanTheWebGuy0 -
Keyword Difficulty tool showing Google search volume or Bing?
Hi, I plugged in a bunch of keywords to know their search volume, chose Google from the drop down and then chose English from the next dropdown and clicked on Check dificulty. It shoes me "Bing Search Volume (Exact Match)" on top but shows the name of the keyword and "for Google CA" on the left. Is the search volume for Google? or Bing? and the difficulty as well? Google or Bing? "
Moz Bar | | SpaMedica0 -
Clarify "broad keyword usage in page title"
Hello Page grader has two different grades for page title that I want clarification on. There is "Broad Keyword Usage in Page Title" and "Exact Keyword Usage in Page Title". Googling around about and searching here I have found that "broad" seems to mean the keywords should be used throughout the page, rather than just in the title and header. Which makes sense as this is a kind of check to ensure the page IS about the keywords and not something unrelated. But what is meant by "broad" usage in the page title? This refers specifically to the page title and not the whole document. My best guess got me to this, given the keyword "Visit London Today"; "Come and visit London today" - exact match only "London - visit today" - broad match only "Visit London the city of dreams | visit London today" - matches both That could be complete nonsense, but basically is broad usage the use of keywords scattered in the page title? Thanks.
Moz Bar | | yolkcreative0 -
SEOMOZ On page ranking reports update
I've recently made a load of changes to improve the on page ranking report grades for my site. I was givena C grade for this page: http://www.katalysticevents.com/luxury-wedding-teepee-hire-about/ based on two key phrases Wedding Tipi and Wedding Teepeee. I've made all the changes as advised (excluding H1 tag) by the report but when I rereun the report it's picking up old page data and showing the same problems. Is there some kind of cache thing I'm missing here? The confusing thing is I made the same series of changes for this page: www.katalysticevents.com/luxury-marquee-hire-services/ for Luxury marquee and luxury marquee hire and the results are fine...I've got an A grade. Examples are things like ALT image attirbutes which don't seem to show up on the first page but are fine on the second page.
Moz Bar | | EdoubleD
The site is a Word press site and I'm using the "All in one SEO pack" plugin. Can anyone advise?0 -
Is there a way to do a mass lookup of Page Authority?
Meaning, is there a way I could look at the Page Authority for 50 pages all in one place? Or do I need to use the MozBar and go page by page? Just looking to save some time. Thanks.
Moz Bar | | JoshKimber0