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 -
Issue with Keyword List Export
I am having an issue with the Keyword list export. I exported a keyword list, then went back in a made changes to the list (deleted keywords, changed priority, etc). Then when I re-export the list it still downloads the original list. For instance, I had a keyword list of 120 keywords. I exported it. Then I reduced the list to 30 keywords. Now when I export that list it is still the original 120 keywords. Any one else having this issue? Is there a way to fix this?
Moz Bar | | Sundaram1 -
Keyword explorer tool - keywords by domain functionality
Hi, We have issues with the new searching for keywords by root domain functionality in keyword explorer. We are based in Australia and need rankings for google.com.au, which is what we have set up within our MOZ campaign ranking reports. The explorer tool rankings are way off and not accurate for our site's actual rankings. Also, many of the top, high volume keywords that we are tracking and for which we rank on first page for are not even appearing when I do an explorer search using our root domain. Is the root domain functionality within keyword explorer providing results based on google.com rather than google.com.au? Does this mean that if we are outside the US that we can't use the tool as it is not accurate? Cheers, Damien
Moz Bar | | Devenish0 -
Keyword research in Moz - Am I missing something?…
I'm fairly new at SEO and am still trying out MOZ. I'm finding myself wishing that Moz had a broader set of tools for keyword research, but am wondering if maybe I'm just missing something. Am I correct in saying that there is no place within Moz that you can get keyword ideas, select/organize keywords, find new/related keywords? I've appreciated the keyword difficulty tool and have played around with Moz Analytics keyword tracking, but these don't help with the broader keyword research aspect. The various tutorials talk about using Google AdWords Keyword Planner and other tools to do that job. But with all that Moz can do, it just seems backwards to do lots of copying-pasting from other tools into Moz, or to have to rely on old excel spreadsheets to organize keywords. It seems that life would be much easier if Moz would be able to pull that kind of external research information in, like Raven does. That way you do most of your research within Moz – allowing you to organize/evaluate potential keywords BEFORE choosing the ones you would like to test for difficulty or track. That way you could simply select the desired keywords and add them to your tracked list. The way it is now, even the one research tool that Moz does have (keyword difficulty) does not allow for an easy way to track or manage a chosen set of keywords. For example, after doing some keyword difficulty analysis, I've chose 5 keywords. To add these 5 to the tracked keywords in a specific campaign I can't just select them and say "track keywords > in xxx campaign". From what I've understood, I must copy-and-paste them into the manage keyword section of the desired campaign. To me this all feels a bit awkward. But since I'm new at this, maybe I'm just missing something? Or maybe it's unrealistic to expect a single tool to address all my SEO needs?
Moz Bar | | Mike_E0 -
Rank tracker
Hello, Rank tracker is not working, It says submitting but nothing happens? Does anyone else have the same problem? Greetings, Maarten
Moz Bar | | FindFactory0 -
Does moz Ranking report canadian rankings?
Hi I would like to know Moz rankings can report canadian ranking or does it just focuses on US market search engines only? If it does also focuses on the canadian market, how do you set it up? Thanks
Moz Bar | | Ideas-Money-Art0 -
Unsure on Keyword Difficulty Tool
Hi all. I am just using the Keyword Difficulty tool for the first time really, in the Research Tools section. Just finding my way around and was wondering why when i enter my keywords for analysis and select Google, UK as my search engine parameters i get BING local and global search volume rather than Google? Many thanks in advance, any help is appreciated 🙂
Moz Bar | | K-Taz0