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
-
Does data-bind hurt SEO?
sleepcountry.ca uses Oracle Commerce Cloud which uses Knockout data-binds syntax to attach events to DOM elements like this (A <a id="s0207useresourcesinwidgets01"></a>Knockout custom binding named ‘widgetLocaleText’ - I am not familiar this technology stack): Same applies to H1 tag - you can't find H1 tag in Source. In short, the text binding causes the associated DOM element to display the text value of your parameter. Data binding is applied to all DOM elements on pages of sleepcountry.ca even that this technique doesn't pass W3C markup validation: Error: Element title must not be empty. MOZ reports that all H1 Tags are missing on ALL PAGES of the site. Same is reported by Semrush and other respected services. However, it seems like Google automatically adds tagging to all data-bind(ed) elements including Title! site:sleepcountry.ca I'm no expert in Oracle Commerce Cloud or Knockout, but I'm confused.
Moz Bar | | allagringaus
QUESTION: Does this data-bind hurt organic search and if it does, why Google still sees all TITLES while Moz and other services report it as a major problem - titles are missing. ? Thank you so much in advance! (I'm not an SEO expert but this problem might be related to my project)0 -
Problem with Keyword Explorer?
Is anyone else having an issue Keyword Explorer? I'm added keywords to lists but there are a couple of problems: The metrics are taking a long time to come through. I.e: at least 10-15 minutes When I try to export my keyword list a completely different keyword export appears When I try to refresh the explorer, my keywords are removed from the list and replaced some keywords/phrases that are completely unrelated Any insight would be appreciated 🙂
Moz Bar | | daniel-brooks0 -
Reworked the keyword strategy - affect on reports
Hello, We're ditching our current keyword strategy and starting over. The reports have been running for about 3 months though. Will our ranking reports factor in those keywords that have been removed? We really only want to see where are campaign is from the new starting point. Or, do I just need to narrow the time frame on my reports. Any advice is appreciated! Thanks!
Moz Bar | | craig_mozbot0 -
How non-US Moz customers will use Keyword Explorer after the Keyword Difficulty tool is retired?
The new Moz Keyword Explorer looks good but its search volume is US based and completely useless for non-US websites. This is from Rand's post: "while the tool can search any Google domain in any country, the volume numbers will always be for US-volume. In the future, we hope to add volume data for other geos as well." In the Keyword Difficulty tool, Moz shows Google search volume data, which is similar to what I see in the Google Keyword Planner and Google Search Console. For example, keyword X in the Australian search market has 6-7k searches in the Google Keyword Planner and 8k searches in Moz. The very same keyword has 118k-300k search volume in the new Keyword Explorer! Obviously this new search volume is not useful in the Australian market. I often used the Keyword Difficulty tool to identify new keyword opportunities but what can I do to complete the same tasks after they retire the tool?
Moz Bar | | Gyorgy.B2 -
Is Keyword Difficulty tool algorithm changed ?
I'm very confused about this. From today, I realized that your algorithm for this tool changed. For example, I have search KC for this keyword before: suitcases for kids has KC is 23. But today I checked it again and it's 43. How can I deal with this new data? Is KC is good for determine that a keyword is easy to rank for ?
Moz Bar | | trungbq060 -
Keyword Rankings vs. Rank Tracker research tool
I have a campaign tracking several keywords. On my Keyword Rankings report I'm not in the top 50 for anything. When I use the Rank Tracker tool, my rankings are quite high (I have 2 in the top 5). When I use the Rank Tracker tool I've noticed that I'm able to point to specific URLs on my website (not the main page). When looking on my Keyword Rankings report, the URL is usually empty. So what am I missing? Have I configured something incorrectly? Can I update the URLs on the Keyword Rankings report so the rankings will be reflective of the Rank Tracker tool? OSQdLmb nMnOQim
Moz Bar | | roywest630 -
Keyword Rankings vs Rank Tracker
Hello, I have a question, what is the difference between these tools? I thought both are the same, just that you can see you competitors ranks on the keyword rankings... The keyword rankings tool is telling me that my competitor is ranking in some keywords.. If I go to the rank tracker tool and type the keyword and competitor url it gives me that that keyword is not in the top 50, when keyword ranking is giving me position #3 I am using in both the same Search Engine with the same country (Google Mexico) Thank you
Moz Bar | | pixelarmx0 -
Keyword Difficulty Tool limit?
Is anyone else having trouble getting results from the Keyword Difficulty Tool today? I submitted 20 keywords for basic analysis, and it has been pending for almost an hour. I restarted my machine, logged in and out - no change. I pulled a few hundred keywords successfully yesterday. Does anyone know if there is a limit to keywords pulled within a 24-hour timeframe? Thanks!
Moz Bar | | Allie_Williams0