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
-
Accuracy of Moz Keyword Tool
I understand that no search tool is entirely accurate, but I'm seriously beginning to doubt the accuracy of the Moz keyword tool search volumes for keywords. For example: I entered "largest police departments" and it says 0-10 per month in the US, despite the fact that that term is directly responsible for 200 hits per day. Many alterations of that keyword come up with 0-10 or not determined. This is not a small error -- and it repeats over and over for other search terms that I have already ranked for in the US. It's gigantically inaccurate in a massive scale.
Moz Bar | | Luke_Proctor0 -
Does data-bind hurt SEO?
sleepcountry.ca uses Oracle Commerce Cloud which uses Knockout data-binds syntax to attach events to DOM elements like this (A <a id="s0207useresourcesinwidgets01"></a>Knockout custom binding named ‘widgetLocaleText’ - I am not familiar this technology stack): Same applies to H1 tag - you can't find H1 tag in Source. In short, the text binding causes the associated DOM element to display the text value of your parameter. Data binding is applied to all DOM elements on pages of sleepcountry.ca even that this technique doesn't pass W3C markup validation: Error: Element title must not be empty. MOZ reports that all H1 Tags are missing on ALL PAGES of the site. Same is reported by Semrush and other respected services. However, it seems like Google automatically adds tagging to all data-bind(ed) elements including Title! site:sleepcountry.ca I'm no expert in Oracle Commerce Cloud or Knockout, but I'm confused.
Moz Bar | | allagringaus
QUESTION: Does this data-bind hurt organic search and if it does, why Google still sees all TITLES while Moz and other services report it as a major problem - titles are missing. ? Thank you so much in advance! (I'm not an SEO expert but this problem might be related to my project)0 -
Is there a way to view difficulty for related keyword suggestions?
I'd really like to view the difficulty/organic CTR/priority of suggested related keywords without having to click on each individually - is there a way to do this?
Moz Bar | | avfundstack2 -
Keyword Explorer - Unable to complete searches for data?
Hey guys, I'm in the process of completing some keyword research using Keyword Explorer but every time I complete a search I'm told that explorer is unable to perform the search at this time and that I should refresh the page, or search with a new query. Is anyone else having this issue/had this problem in the past?
Moz Bar | | daniel-brooks0 -
Monthly Ranking Comparisons on Custom Reports
Hi, We run MONTHLY Moz custom reports that compares rankings from the previous month, but some of the data just doesn't make sense. As an example, in the previous month’s report our ranking for “keyword X” was #3, when we look at the current month’s report our ranking for “keyword X” is still #3, but it shows that it’s gone up by 3 positions. This position change is not true if you compare to the previous month’s report! How can we know what dates we are comparing against? All the best, Lee.
Moz Bar | | Webpresence0 -
On-Page Grader is not counting H2 and H3 Keywords
I used on-page grader in one of my webpages and it showed the limit of 15 keywords used. The problem is that it counted only when the keyword appears in the Title, URL, Meta Description, H1, Body and IMG ALT. If you take into account the H2 and H3 tags, the count will go to 22. Is there a problem with the On-Page Grader Tool or it's not a problem to go above 15 keywords if they are in H2 and H3? Here's the link for the page: http://www.tororadar.com.br/acoes/bbse3-bb-seguridade/cotacoes-bovespa Keyword: BBSE3 Thanks in advance.
Moz Bar | | Guilhermealvesc0 -
Keyword difficulty - benchmarks
hi, anyone know some good benchmarks? how many hours a certain keyword needs with what percentage? or how to really interpret the %? thanks, Walter
Moz Bar | | Walterman1 -
How to make sense of data for this keyword (Moz Keyword vs. Google KW Planner)
The keyword "auto immune disorder" has an avg monthly (local/US) search of 880 in Google KW Planner with "low" competition In Moz, the same keyword has an avg monthly (local/US) search of 5 with a KW difficulty of 71%. I realize that the competition in Google KWP is based on ads, but is there a discrepancy when the search volume is so different in Google vs. Moz/Bing? Based on the above data, it seems like it would make sense to do a Google Adword (high search volume, low competition) instead of trying to rank organically...am I on the right track here? Thanks!
Moz Bar | | lulu710