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
-
MozBar: Page Title (and other data) inconsistent with HTML
In using the MozBar Chrome extension, I have noticed that the data about a page that MozBar displays is sometimes inconsistent with the "head" tag in the HTML of the page. Am I misunderstanding where MozBar is getting the data it is displaying? Other SEO extensions like "META SEO inspector"do not display these inconsistencies. EupH5sG
Moz Bar | | clayjones0 -
Keyword Explorer how can I uncover all phrases relating to a single keyword?
From what I can see in Keyword Explorer you cannot enter a single keyword and uncover all search phrases that include this word. Or at least when I try to "Display keyword suggestions that" and select "only include keywords that contain all the query terms" and then enter a keyword. I cannot find a phrase in the list even when I can find it via a different search when if I type it directly.
Moz Bar | | GrouchyKids0 -
What is a Good Keyword Priority Score?
Howdy gang, This is my last discussion post in the series on keyword metrics in KW Explorer & Moz Pro (previously on Keyword Difficulty, Opportunity, & Volume). In this one, let's chat about the "Priority Score," a feature you'll find in Keyword Explorer on any lists you build. Priority was conceived to help aggregate all the other metrics - Difficulty, Opportunity, Volume, and (if you choose to use it) Importance. We wanted to create an easy way to sort keywords so the cream would rise to the top -- cream in this case being keywords with low difficulty, high opportunity, strong volume, and high importance (again, if you choose to use it). Thus, when it comes to Priority Score, there's no particular number you should necessarily seek out, but higher is better. When you get into the ranges of 80+ (which is quite rare, Single Malt Scotch is one of the few examples I could find, and only because it's volume is so high and there's only a couple SERP features), you're generally talking about keywords with high demand (lots of monthly searches), the difficulty isn't too crazy (a website in the 55-80 DA range might have a shot), and the CTR Opportunity is decently strong (usually not too many SERP features that take clicks and attention away from the organic web results). Below that score range, you're usually finding keywords where one or more of those isn't true -- there's either lower volume, heavier competition, or lots of SERP features with the accompanying lower estimated CTR. When you're building KW lists, my view is that there's no "good" or "bad" Priority scores, only relative scores. Priority should be used to help you determine which terms and phrases to target first -- it's like a cheat code to unlock the low hanging fruit. If you build large lists of 50-100 or more keywords, Priority is a powerful and easy way to sort. It becomes even more useful if you use the Importance score to help add an estimation of value to you/your business/your client in to the mix. In that case, Importance can cut Priority by up to 2/3rds (if you set it at 1) or raise it by a little more than 3X (if you set it at 10). This is hyper-useful to nudge keywords with middling scores up if they're super-important to your marketing efforts. Look forward to your feedback, and thanks for checking these out!
Moz Bar | | randfish8 -
"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 -
Does Moz's keyword tool pull data from your IP address?
Does anyone know how Moz's keyword tool pulls their keyword ranks? Do they take it based off of the IP (history and cookies) that is being used? I am trying to find a way to collect keyword data that is neutral and not based off of my previous searches, etc. TIA
Moz Bar | | ReviveMedia0 -
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 -
Connect to Google Analytics problem (Moz Analytics)
Hello - I recently received the Beta invite to Moz Analytics (very excited). I set up the campaign for our primary site and entered our Google Analytics profile - however, Moz does not seem to accept the profile when I click the "Save" button. All of our profiles are listed w/in the drop-down menu, but after selecting the profile we wish to link/connect to - nothing happens. So we're not receiving any stats w/in Moz from our GA acct. Please help. I'm really anxious to begin delving into Moz Analytics! Thanks
Moz Bar | | ryankish0 -
Keyword Difficulty Showing ONLY Bing Search Volume (Exact Match)
Hi I am using the "Keyword Difficulty" tool and selecting "Google US". But the report that gets generated shows "Bing Search Volume (Exact Match). Is there any way to get "Google Search Volume (Exact Match)" being shown in the report? Regards
Moz Bar | | rholt0