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
-
Important news on Fresh Web Explorer
Hello Moz family, After much deliberation, Moz has arrived at the difficult decision to shift away from brand & keyword mentions monitoring as a standalone tool in Fresh Web Explorer. Though we believe in the value of this service for our users, we’ll no longer be supporting it in order to provide more innovative features that better suit the modern needs of SEOs. We will, however, continue to support existing features within the Pro platform that accomplish similar tasks, like link building, content planning, and mentions monitoring. We understand you might have a few questions and have compiled a list of common FAQs below. Within the answers, you will find a number of other resources to help you out. When is Moz sunsetting Fresh Web Explorer?
Moz Bar | | jacob.butler
Moz will be sunsetting Fresh Web Explorer on November 10, 2020. At that time, you will no longer be able to access this feature within Moz Pro. This means that there will no longer be the ability in your settings to opt into email alerts from Fresh Web Explorer as the email alerts will discontinue after this date as well. I used Fresh Web Explorer for brand and keyword monitoring across the web. How can I do that now? Though it’s not a direct replacement, setting Brand Rules within a Campaign allow a user to monitor specific keywords in the Link Opportunities section, much like Fresh Web Explorer. By monitoring the links that mention your tracked keywords, but do not link to them, you can easily reach out for link opportunities. It can also help you plan content strategies by understanding what is being discussed within the content of those pages. You can read more about Opportunities within Links here. I used Fresh Web Explorer for link building opportunities. How can I do that now? With Moz’s vast link index you can uncover valuable link prospects, create a solid strategy, and track your progress. Within Link Opportunities in a Campaign, you can understand the domains mentioning your tracked keywords (set within your Brand Rules), but not linking back to you. Link Intersect provides an analysis on who's linking to competitors, but not you, and can help users plan strategic link outreach. You can also use Link Tracking Lists to help track progress for link opportunities you’ve identified through unlinked mentions of your brand or your competitors. Our Keyword Explorer tool also includes a Mentions module. Mentions show you pages that contain the searched keyword and gives you a snapshot of the Page Title and URL. Within Mentions, understand a link’s Mention Authority score, which predicts the authority of the page using a proprietary algorithm, along with a combination of Moz metrics that take both the authority and influence of the page into account. Need help getting started with all of these similar features? Read more here. I used Fresh Web Explorer for content planning. How can I use Moz for that now? There are many ways you can plan your content strategy using Moz. For a high-level understanding of how Moz Pro can help you plan content, take a look at our Beginner’s Guide to Content Strategy here. Otherwise, one way you can understand what is being mentioned within your tracked keywords is through Opportunities in Links within a campaign. This feature helps you get a sense for what type of content is published on the web around your tracked keywords, branded or non-branded. You can then plan similar content as what’s being mentioned. For more information on how to set up Brand Rules in a Campaign, click here. I used Fresh Web Explorer for the email alerts to notify other stakeholders on keyword & brand mentions. Can I do that another way within Moz Pro? We recommend using our Custom Reports to email your stakeholders of tracked mentions on the web. You can set Brand Rules within your Campaign settings for branded or non-branded keywords you’d like to monitor. You can read more on how to set up Custom Reports here. The Moz Pro feature alternatives you suggested aren’t really a direct replacement. Why? We recognize that our feature suggestions are not a direct replacement for brand and keyword mentions monitoring. And, we also understand that this functionality is desired by many of our users. We will be exploring opportunities to include some of the Fresh Web Explorer functionality within future versions of Moz Pro. In the meantime, if you're looking for a direct replacement, we suggest checking out BuzzSumo. Their Monitoring feature provides you a one-stop-shop for monitoring your brand, keywords, and trends across the web. Do I need to do anything before the sunset on November 10, 2020? No. Fresh Web Explorer will simply disappear from the Moz Pro interface. No action is needed on your end. Once retired, you will no longer see the page within Moz Pro and you will no longer receive alert emails that were previously set up from the settings tab within an account. Do you have any content you can point me to that outlines the other ways in which I can find my brand’s mentions in Moz Pro? We sure do! Check out this fantastic Help Hub article that outlines all of the ways you might track, monitor, and analyze your brand’s mentions in Moz Pro. The features here include Keyword Explorer’s Mentions, Brand Rules, Link Opportunities in Links within a Campaign, Link Tracking Lists, and Custom Reports. If you have any questions, I'm happy to discuss more in the Q&A thread. Or, feel free to send an email to help@moz.com with any questions. Best,
Jacob Butler4 -
How do you delete keywords in bulk?
Hi, in the 'rankings' section of one of my campaigns, I want to delete almost 200 keywords. Is there a way to delete keywords in bulk please? The only way I can find is to individually select keywords to delete but this will take too long to do with almost 200 keywords. Thanks
Moz Bar | | NavnitBB0 -
Why keywords have zero data for UAE?
I have searched for food delivery keyword for the United Arab Emirates, EN, and AR. Monthly volume has no data whereas difficulty, organic and priority has figures. When I change the country to US; monthly volume has more data. Can you explain; how can I use your service?
Moz Bar | | Twenzy1 -
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 -
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 -
Confused by "Exact Keyword Used in Document Text at Least Once".
Hi, I am using the On-Page Grader to improve the SEO for certain keywords on certain pages. I have received the notification that the "Exact Keyword Used in Document Text at Least Once". Well from the looks of it I have already done this but I want to make sure that im checking the right thing. What does it mean when it says document text as I assumed it was text on the page but its not reading it as that. Any feedback would be appreciated
Moz Bar | | charlessimmons0 -
Has using Moz got me banned from Google search?
Dear fellow Mozzers, For the last couple of weeks when ever I do a google search I have to enter a captcha code. Now I hardly use google anymore which is annoying ! Then I went onto support.google.com and saw this: https://support.google.com/websearch/answer/86640?hl=en&ref_topic=3378866 "Automated traffic includes: Sending searches from a robot, computer program, automated service, or search scraper Using software that sends searches to Google to see how a website or webpage ranks on Google" Is Moz alone doing this? Thanks in advance for your response. Ash
Moz Bar | | -Ash-0 -
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