• seohunters9

        See all notifications

        Skip to content
        Moz logo Menu open Menu close
        • Products
          • Moz Pro
          • Moz Pro Home
          • Moz Local
          • Moz Local Home
          • STAT
          • Moz API
          • Moz API Home
          • Compare SEO Products
          • Moz Data
        • Free SEO Tools
          • Domain Analysis
          • Keyword Explorer
          • Link Explorer
          • Competitive Research
          • MozBar
          • More Free SEO Tools
        • Learn SEO
          • Beginner's Guide to SEO
          • SEO Learning Center
          • Moz Academy
          • MozCon
          • Webinars, Whitepapers, & Guides
        • Blog
        • Why Moz
          • Digital Marketers
          • Agency Solutions
          • Enterprise Solutions
          • Small Business Solutions
          • The Moz Story
          • New Releases
        • Log in
        • Log out
        • Products
          • Moz Pro

            Your all-in-one suite of SEO essentials.

          • Moz Local

            Raise your local SEO visibility with complete local SEO management.

          • STAT

            SERP tracking and analytics for enterprise SEO experts.

          • Moz API

            Power your SEO with our index of over 44 trillion links.

          • Compare SEO Products

            See which Moz SEO solution best meets your business needs.

          • Moz Data

            Power your SEO strategy & AI models with custom data solutions.

          Let your business shine with Listings AI
          Moz Local

          Let your business shine with Listings AI

          Learn more
        • Free SEO Tools
          • Domain Analysis

            Get top competitive SEO metrics like DA, top pages and more.

          • Keyword Explorer

            Find traffic-driving keywords with our 1.25 billion+ keyword index.

          • Link Explorer

            Explore over 40 trillion links for powerful backlink data.

          • Competitive Research

            Uncover valuable insights on your organic search competitors.

          • MozBar

            See top SEO metrics for free as you browse the web.

          • More Free SEO Tools

            Explore all the free SEO tools Moz has to offer.

          NEW Keyword Suggestions by Topic
          Moz Pro

          NEW Keyword Suggestions by Topic

          Learn more
        • Learn SEO
          • Beginner's Guide to SEO

            The #1 most popular introduction to SEO, trusted by millions.

          • SEO Learning Center

            Broaden your knowledge with SEO resources for all skill levels.

          • On-Demand Webinars

            Learn modern SEO best practices from industry experts.

          • How-To Guides

            Step-by-step guides to search success from the authority on SEO.

          • Moz Academy

            Upskill and get certified with on-demand courses & certifications.

          • MozCon

            Save on Early Bird tickets and join us in London or New York City

          Unlock flexible pricing & new endpoints
          Moz API

          Unlock flexible pricing & new endpoints

          Find your plan
        • Blog
        • Why Moz
          • Digital Marketers

            Simplify SEO tasks to save time and grow your traffic.

          • Small Business Solutions

            Uncover insights to make smarter marketing decisions in less time.

          • Agency Solutions

            Earn & keep valuable clients with unparalleled data & insights.

          • Enterprise Solutions

            Gain a competitive edge in the ever-changing world of search.

          • The Moz Story

            Moz was the first & remains the most trusted SEO company.

          • New Releases

            Get the scoop on the latest and greatest from Moz.

          Surface actionable competitive intel
          New Feature

          Surface actionable competitive intel

          Learn More
        • Log in
          • Moz Pro
          • Moz Local
          • Moz Local Dashboard
          • Moz API
          • Moz API Dashboard
          • Moz Academy
        • Avatar
          • Moz Home
          • Notifications
          • Account & Billing
          • Manage Users
          • Community Profile
          • My Q&A
          • My Videos
          • Log Out

        The Moz Q&A Forum

        • Forum
        • Questions
        • My Q&A
        • Users
        • Ask the Community

        Welcome to the Q&A Forum

        Browse the forum for helpful insights and fresh discussions about all things SEO.

        1. Home
        2. Moz Tools
        3. Moz Bar
        4. Is there an automated way to import Keyword Rank Tracker data in Google Data Studio?

        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?

        Moz Bar
        4
        4
        2374
        Loading More Posts
        • Watching

          Notify me of new replies.
          Show question in unread.

        • Not Watching

          Do not notify me of new replies.
          Show question in unread if category is not ignored.

        • Ignoring

          Do not notify me of new replies.
          Do not show question in unread.

        • Oldest to Newest
        • Newest to Oldest
        • Most Votes
        Reply
        • Reply as question
        Locked
        This topic has been deleted. Only users with question management privileges can see it.
        • Lvet
          Lvet Subscriber last edited by

          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.

          1 Reply Last reply Reply Quote 0
          • Warren.Wittman
            Warren.Wittman Subscriber last edited by

            The add-on only appears to import MozRank and link targeting information. Can you confirm that rank can be imported? Thanks!

            1 Reply Last reply Reply Quote 0
            • effectdigital
              effectdigital last edited by

              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

              1. You'd need a developer to build the database and the tasks which updated it (API fetches)
              2. If your ranking supplier changed their API significantly you'd have to pay to get it updated
              3. 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

              1 Reply Last reply Reply Quote 1
              • BIGYAM
                BIGYAM last edited by

                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.

                1 Reply Last reply Reply Quote 1
                • 1 / 1
                • First post
                  Last post

                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.

                • See all categories

                Related Questions

                • jacob.butler

                  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 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 [email protected] with any questions. Best, 
                  Jacob Butler

                  Moz Bar | | jacob.butler
                  4
                • Twenzy

                  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 | | Twenzy
                  1
                • RickyShockley

                  Are we actually getting accurate data on keyword volumes from Moz (or other sources)?

                  I have a client who does patio furniture repair and restoration. When performing keyword research in Moz for terms like "patio furniture repair" I see that only 11-50 people in the entire US are searching for this term according to the Moz data. However, running an Adwords campaign currently and our top keyword is the phrase match for "patio furniture repair" which has generated over 100 clicks in just a couple of months in ONE county. Is there a better way to research more accurate results on search volume estimates? This makes organic SEO and keyword targeting hard! Thanks, Ricky

                  Moz Bar | | RickyShockley
                  1
                • randfish

                  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 | | randfish
                  11
                • A_Q

                  Is Keyword Explorer now providing search volume by country?

                  I think Keyword Explorer was only providing search volume data for the US (whereas difficulty and opportunity were available at a country level) but recently I've started to see differences between the US volume data and the UK (see examples attached). Does this mean Keyword Explorer is now providing accurate volume data for the UK and other countries? DEIKsVJ 5kels

                  Moz Bar | | A_Q
                  0
                • _nitman

                  How to upload the bulk Keywords with Tags in MOZ Rank Tracker Tool?

                  Trying to upload multiple keywords at a time with their different Tags. But here i can upload the keyword one by one also i am not able to associate tags with the keyword.

                  Moz Bar | | _nitman
                  2
                • bkuhn1

                  Does Moz have a Hashtag tracker?

                  If not, why not? And what are you using?

                  Moz Bar | | bkuhn1
                  0
                • ejunxion

                  Is a higher or lower score better in keyword ranking

                  I know this is a weird question, I think I have confused myself with different keyword tools. So if you get a score of 10 for your keyword, should you aim to be closer to 1 or 50?

                  Moz Bar | | ejunxion
                  0

                Get started with Moz Pro!

                Unlock the power of advanced SEO tools and data-driven insights.

                Start my free trial
                Products
                • Moz Pro
                • Moz Local
                • Moz API
                • Moz Data
                • STAT
                • Product Updates
                Moz Solutions
                • SMB Solutions
                • Agency Solutions
                • Enterprise Solutions
                • Digital Marketers
                Free SEO Tools
                • Domain Authority Checker
                • Link Explorer
                • Keyword Explorer
                • Competitive Research
                • Brand Authority Checker
                • Local Citation Checker
                • MozBar Extension
                • MozCast
                Resources
                • Blog
                • SEO Learning Center
                • Help Hub
                • Beginner's Guide to SEO
                • How-to Guides
                • Moz Academy
                • API Docs
                About Moz
                • About
                • Team
                • Careers
                • Contact
                Why Moz
                • Case Studies
                • Testimonials
                Get Involved
                • Become an Affiliate
                • MozCon
                • Webinars
                • Practical Marketer Series
                • MozPod
                Connect with us

                Contact the Help team

                Join our newsletter
                Moz logo
                © 2021 - 2025 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
                • Accessibility
                • Terms of Use
                • Privacy

                Looks like your connection to Moz was lost, please wait while we try to reconnect.