undefined
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
    • SEO Q&A
    • Webinars, Whitepapers, & Guides
  • Blog
  • Why Moz
    • Agency Solutions
    • Enterprise Solutions
    • Small Business Solutions
    • Case Studies
    • 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.

    NEW Keyword Suggestions by Topic
    Moz Pro

    NEW Keyword Suggestions by Topic

    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.

    • SEO Q&A

      Insights & discussions from an SEO community of 500,000+.

    Unlock flexible pricing & new endpoints
    Moz API

    Unlock flexible pricing & new endpoints

    Find your plan
  • Blog
  • Why Moz
    • 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.

    • Case Studies

      Explore how Moz drives ROI with a proven track record of success.

    • 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
  • 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
2.4k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as question
Log in to reply
This topic has been deleted. Only users with question management privileges can see it.
  • Lvet
    Lvet Subscriber last edited by Oct 25, 2018, 11:22 AM

    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 Jan 8, 2020, 4:05 PM Jan 8, 2020, 4:05 PM

      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 Oct 26, 2018, 10:35 AM Oct 26, 2018, 10:35 AM

        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 Oct 25, 2018, 1:37 PM Oct 25, 2018, 1:36 PM

          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
          1 out of 4
          • First post
            1/4
            Last post

          Got a burning SEO question?

          Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.


          Start my free trial


          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

          • frekwency

            Get keyword volume by US State

            I'm trying to get keyword search volume per US state & not just country. I found an article on this but it's over 7 years old... https://moz.com/community/q/tool-for-local-keyword-research-by-us-state Am I blind and completely missing it? Is there a way I can do this? Thanks, everyone!

            Moz Bar | Jul 26, 2019, 4:10 AM | frekwency
            0
          • 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 | Jan 11, 2019, 9:38 AM | Twenzy
            1
          • KanikaG

            Keyword Ranking Report is Different than Real Result on Google

            Hi Guys,
            I am getting MOZ reports on a few keywords and that is good But when My client search for the same keywords he doesn't get the same rank, not even on that page. Let me explain in more details:
            I have a keyword that shows on rank #5 in Google Mobile for a Local location for the current week. The client is from the same location as well. But when client search for that keyword from his mobile he doesn't get the keyword listed on that page, not even on other pages. I checked with other online keyword rank checker tool and all are showing the result similar to the Moz ranking report. It's really frustrating for my client. Google analytics shows that mobile users and organic reach are increasing so I am sure MOZ and other tools are showing us correct result. What could be the possible reason that he is not getting the same result as showing by MOZ? I am not from his location so how can I check the keyword result for the selected city using MOZ that is accurate? Any help would be highly appreciated. Please help. Thanks

            Moz Bar | Apr 29, 2024, 12:13 PM | KanikaG
            1
          • randfish

            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 | Jul 2, 2020, 5:55 PM | randfish
            8
          • russellbrown

            Keywords Score Meter

            Hi Moz, I am using the keywords difficulty tool from your site and find it is quite useful 🙂 I research the community and find the data should be interpreted in the following way. But when I did a quick research for one keyword. The tool bar gives me a data of 22% showing in Yellow and says the keyword is competitive when I hover my mouse. Should this be **Blue **and easy to rank keyword based on the score? Which one should I believe? Sub 30 - (Blue) Low hanging fruit you can take advantage of. 30 - 35 (Green) Fairly easy with good on page and some quality anchored links. 35 - 40 - (Yellow) Will take a bit more work but still in reach may require, good on-site SEO and a solid link profile. 40 - 50 (Orange) Domain authority plays a much more pivotal role so it may take longer to rank for. 50+ (Red) All about resources. Onsite SEO needs to be totally nailed, including internal linking/ topic modelling etc. a strong & diverse link profile with good social signals and ... time. Thanks in advance. ThAqoa5.png OC8xIzP.png

            Moz Bar | Jul 13, 2015, 7:01 PM | russellbrown
            0
          • -Ash-

            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 | Mar 26, 2015, 11:26 AM | -Ash-
            0
          • dsinger

            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 | Jan 29, 2014, 2:04 PM | dsinger
            0
          • Becki123

            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 | Dec 1, 2013, 8:40 PM | Becki123
            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
          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.