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
-
Unsolved Mistake on keyword stuffing detection(in my view)
Hello!
Moz Bar | | Seoman45
In Mozbar, optimization factors
"Avoid Keyword Stuffing in Document"
If a blog (or any other page) publishes an article, and that article attracts a considerable number of questions, it is inevitable to prevent repeating the keyword on that page. In other words, using keywords by users in comments should not be considered as "Keyword Stuffing". In my view, if this is true, you need to optimize the detection of "Keyword Stuffing".
By the way, thanks for the valuable service and tools for SEO.
Best regards,
Abbas0 -
Keyword Explorer how can I uncover all phrases relating to a single keyword?
From what I can see in Keyword Explorer you cannot enter a single keyword and uncover all search phrases that include this word. Or at least when I try to "Display keyword suggestions that" and select "only include keywords that contain all the query terms" and then enter a keyword. I cannot find a phrase in the list even when I can find it via a different search when if I type it directly.
Moz Bar | | GrouchyKids0 -
During my keyword research
Hello, Is it normal that I find keyword in bolded in the search results that don't appear in keyword explorer when I do the my keyword research ? Thank you,
Moz Bar | | seoanalytics0 -
Label existing keywords
I have keywords that were added without a label that I would now like to associate with an existing label. I don't want to lose my tracking data by deleting them and re-adding. Is there a way to easily label them with an existing label?
Moz Bar | | AppliedMarketingScience2 -
Rankings and visibility fluctuating wildly from week to week
I have 1 campaign (out of 9) that has it's ranking fluctuating wildly from week to week - and in the past 3 weeks, it's tanked, and the next week come back, and this week, tanked again (what I mean by that is Keyphrases ranking #1 dropping to +51 - I had over 20 keyphrases (both local and universal) that were ranked in the top 10 (many in the top 3) that are now at 18 or higher. I have not changed anything on the website in the last 3 weeks, but I've been working with Yoast SEO Pro to add in metadata, titles etc. The content, managed by the marketing manager, is basically unchanged. Help!!! This is the second time this has happened and our top competitor went from where we are now to #1 - We've been flipflopping week after week. Not good. I have also been getting an increased # of 803 and 804 crawl errors. Jon with Moz added me to the next beta cohort, but I can't imagine that this has anything to do with Google ranking. I have 2 campaigns experiencing a high number of 803-804 crawl errors but only this one with the dramatic ranking and visibility swings. mccdental.com is the domain for the campaign. I appreciate any insight. Newish client - NOT good.
Moz Bar | | chill9860 -
Location specific MOZ Ranking changes - How to track them
Hi All, I have asked this question before here but haven't got any convincing answers. And now I am starting to see this in couple of my other projects . I'm not sure how many facing similar issue like mine but its bit tricky. Our company is based in Melbourne,Australia and we set MOZ campaign setting to google.com.au . The weekly moz ranking for one of the client keyword showed as Position Rank#29. But when I Checked Manually it is Ranking #3. So why does the moz show as 29 ? **Keyword: **car exhaust Website: www.professionalexhaust.com.au To Replicate, I set the google search to google.com.au and on Search Tools I changed location as **Australia ( by default its set to Melbourne ). **When I did search now my result came in Page 3 - No.29 rank. Note: By default the Google browser picks the location as Melbourne and gives localized result which is not tracked by MOZ. Now how do I track this in Moz to show localized ranking results which my customer see. I cant report this ranking to client, else I have to do a manual report which is time consuming . Note : This is Tested in InCognito mode with all cache cleared.
Moz Bar | | emarketexperts0 -
Connect to Google Analytics problem (Moz Analytics)
Hello - I recently received the Beta invite to Moz Analytics (very excited). I set up the campaign for our primary site and entered our Google Analytics profile - however, Moz does not seem to accept the profile when I click the "Save" button. All of our profiles are listed w/in the drop-down menu, but after selecting the profile we wish to link/connect to - nothing happens. So we're not receiving any stats w/in Moz from our GA acct. Please help. I'm really anxious to begin delving into Moz Analytics! Thanks
Moz Bar | | ryankish0 -
When Moz provides an on-page grade report card, what tells Moz which keyword to grade for?
I just started working with the on-page grader and of couse am particularly interested in fixing my pages with not so stellar grades. Can someone tell me how SEO Moz decides what keyword to grade a page for? I receive a report each week that tells me how many pages I have with A's, B's etc. But what tells Moz to grade a page for a particular keyword? Is it the first keyword listed in the meta description?
Moz Bar | | AliciaMarie0