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
-
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 -
Keyword Ranking Report is Different than Real Result on Google
Hi Guys,
Moz Bar | | KanikaG
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. Thanks1 -
Problem with Keyword Explorer?
Is anyone else having an issue Keyword Explorer? I'm added keywords to lists but there are a couple of problems: The metrics are taking a long time to come through. I.e: at least 10-15 minutes When I try to export my keyword list a completely different keyword export appears When I try to refresh the explorer, my keywords are removed from the list and replaced some keywords/phrases that are completely unrelated Any insight would be appreciated 🙂
Moz Bar | | daniel-brooks0 -
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 -
What does it mean when Moz KW explorer returns a negative keyword difficulty score (eg -2)?
I recently did a keyowrd difficulty lookup in Moz keyword explorer as usual and for the first time a saw several (out of 100s) of negative keyowrd scores (generally -2). Is this a bug, what does it mean?
Moz Bar | | FlagshipCons1 -
Keyword used 1448 times ? for a Chinese page
Hi, I tested my page grade here : https://moz.com/researchtools/on_page_grader_reports/1269197 Keyword : "專案管理軟體" , which means "Project Management Software" in Traditional Chinese. URL: http://helpmecloud.com/clarizen-introduction.html But the On Page Grader told me "We found this keyword used 1448 times." I think the result is wrong, I guess you calculated all Chinese letters separately. Am I right ? How can I get a correct grade for my page ? Thansk for help! William
Moz Bar | | Helpmecloud0 -
Google Analytics keeps disconnecting, requires "Reauthorization"
I have many campaigns connected to our Google Analytics account (all websites in same GA account) but I keep getting the message "Our connection to your Google Analytics account was lost. Don't worry, you won't lose any data. Please reauthorize now.". I go through the motions of "reauthorizing" and it tells me I'm successful. Minutes later it gives me the same message. I even keep my GA account logged in on the same computer, trying to avoid this. As a result, I'm not getting my Analytics data in my campaign. Help!
Moz Bar | | TotalMarketExposure0 -
Delete On Page Reports, Modify Keywords
Hi, I tried modifying the incorrect keyword assignments for my pages but there is no pencil icon. I also tried deleting the incorrect reports and redoing them but the incorrect OP reports are not deleted and the new reports are not saved when I refresh I tried following the instructions here http://moz.com/help/guides/search-overview/on-page-optimization/manage-page-grades but they didn't work. Thanks
Moz Bar | | xvpn9020