Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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
-
Location National vs. Country - Different Ranking
Why is the ranking for a keyword different for the locations National and for example Austria ... both should bring the ranking for the whole country, but often they are different?
Moz Bar | | Art-of-Artists0 -
Data Analysis Tool - No data found for this domain
For some reason, about a week ago, my clients website nolonger appears on the moz analysis tool ( www.movietrailersarea.org ) which it previously was. now i get the error "Bummer! No data found for this domain" and now nearly all traffic has also depleted.
Moz Bar | | Mike569
site is still indexed by google & robots isnt blocking any crawlers.
any idea?3 -
Crawling Problem : No-data Of My Site
Hey, Folks!! So It's Been More than a Month.And Moz is not crawling my website http://www.trickypedia.com/.I have seen Moz Last update I thought they will crawl my site but No results Disappointing. My Sites Domain Authority and Page Authority is still 1. But In other Seo Tools, they are Perfectly Crawling My Website. What Would Be the reason? Can anyone Please Explain.
Moz Bar | | seothatworks010 -
What is a Good Keyword Volume Score?
Hi All! Continuing my series of discussions about the various keyword scores we use here at Moz (previously: Keyword Difficulty & Keyword Opportunity)... Let's move on to Volume. Volume in Moz's tools is expressed in a range, e.g. Bartending Certification has volume of 201-500. These ranges correspond to data we have suggesting that in an average month, that keyword is searched for a minimum of X to a maximum of Y (where X-Y is the volume range). We use clickstream data as well as data from Google AdWords and then some PPC AdWords campaigns we run and have access to when we build the models for our volume data. As such, we've got very high confidence in these numbers -- 95%+ of the time, a given keyword's monthly search volume on Google will fall inside that range. If you want to see all the nitty gritty details, check out Russ Jones post on Moz's Keyword Volume and how we calculate it. As far as a "good" volume score -- higher is usually better, as it means more demand, but lots of keywords with low volume scores can also add up to strong traffic when combined, and they may be more relevant. Capturing exactly the audience you want that also wants you is what SEO is all about. p.s. When Keyword Explorer or Moz Pro gives you a "no data" or "unknown" volume number, it may just mean we haven't collected information from our clickstream providers or AdWords crawls, not that the keyword has no volume (though it sometimes means that, too, we just don't know yet). One way to verify - see if Google Suggest autofills it in when you type in the search box. If it does, that's usually a sign there's at least some volume (even if it's only a few searches a month).
Moz Bar | | randfish11 -
What is a Good Keyword Organic CTR Score?
Hi Folks! You might have seen my discussion on What Is a Good Keyword Difficulty Score, and this is a continuation of the same vein. Keyword Organic CTR is probably my favorite score we developed in Keyword Explorer and Moz Pro. It looks at the SERP features that appear in a set of results (e.g. an image block, AdWords ads, a featured snippet, or knowledge graph) and then calculates, using CTRs we built off our partnership with Jumpshot's clickstream data, what percent of searchers are likely to click on the organic, web results. For example, in a search query like Nuoc Cham Ingredients, you've got a featured snippet and then a "People Also Ask" feature above the web results, and thus, Keyword Explorer is giving me an Organic CTR Score of 64. This translates directly to an estimated 64% click-through rate to the web results. Compare that to a search query like Fabric Printed Off Grain, where there's a single SERP feature - just the "People Also Ask" box, and it's between the 6th and 7th result. In this case, Keyword Explorer shows an Organic CTR Score of 94, because we estimate that those PAAs are only taking 6% of the available clicks. There are two smart ways you should be using Organic CTR Score: As a way to modify the estimated volume and estimated value of ranking in the web results for a given keyword term/phrase (KW Explorer does this for you if you use the "Lists" and sort based on Potential, which factors in all the other scores, including volume, difficulty, and organic CTR) As a way to identify SEO opportunities outside the normal, organic web results in other SERP features (e.g. in the Nuoc Cham Ingredients SERPs, there's serious opportunity to take over that featured snippet and get some great traffic) OK, so all that said, what's actually a "good" Organic CTR score? Well... If you're doing classic, 10-blue-links style SEO only, 100 is what you want. But, if you're optimizing for SERP features, and you appear in a featured snippet or the image block or top stories or any of those others, you'd probably be very happy to find that CTR was going to those non-web-results sections, and scores in the 40s or 50s would be great (so long as you appear in the right features).
Moz Bar | | randfish12 -
Rank Tracker not Working.
That's all. It has not worked for last 3 days I believe. I use Google Chrome.
Moz Bar | | SammisBest0 -
Need a Reliable Free Bulk Keyword Rank Checker
I have 2,871 keywords that I need to check Google rank for on 4 separate domains. Does anyone know of any FREE tools or plugins available that will allow for this volume that wont get my IP banned by Google? Even the Moz Rank Checker only allows to enter 1 keyword at a time for up to 200 per day. Who would seriously enter in 200 keywords, one by one all day, every day?
Moz Bar | | dsinger0 -
How to bulk check the ranking for more than 800 domains?
I got a list of 800 domains that my company owns and I want to check every domain for it's SEO value. Some of these domains where never used, but I don't know which weren't used... Do you know a tool for this? Something where I can upload the list in excel?
Moz Bar | | Becki1230