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?
-
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
-
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 -
Crawling Problem : No-data Of My Site
Hey, Folks!! So It's Been More than a Month.And Moz is not crawling my website http://www.trickypedia.com/.I have seen Moz Last update I thought they will crawl my site but No results Disappointing. My Sites Domain Authority and Page Authority is still 1. But In other Seo Tools, they are Perfectly Crawling My Website. What Would Be the reason? Can anyone Please Explain.
Moz Bar | | seothatworks010 -
Confused by "Exact Keyword Used in Document Text at Least Once".
Hi, I am using the On-Page Grader to improve the SEO for certain keywords on certain pages. I have received the notification that the "Exact Keyword Used in Document Text at Least Once". Well from the looks of it I have already done this but I want to make sure that im checking the right thing. What does it mean when it says document text as I assumed it was text on the page but its not reading it as that. Any feedback would be appreciated
Moz Bar | | charlessimmons0 -
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_Q0 -
Keyword Explorer is Now Live; Ask Me Anything About It!
Howdy gang - as you probably saw, we launched our biggest new tool in Pro in many years today: https://moz.com/explorer If you're a Moz Pro subscriber, you've already got access. We went ahead and gave folks who were at $99/month before today 300 queries/month. If you're signing up new, $99/month doesn't have KW Explorer access, but the other levels - at $149/month and above, do (5,000+ queries/month). You can read the blog post here for lots of details, but if you have questions or product suggestions, please don't hesitate to ask!
Moz Bar | | randfish14 -
Should I exclude prepositions in tracked keywords of moz analytics?
I'm new to Moz. Just set up my trial campaign, and it had suggested many keywords. Many of the phrases that were suggested do not contain prepositions. For example, instead of something like "sporting good stores in Chicago" it suggested "sporting good stores Chicago" Today, I looked at the on-page optimization suggestions, which are (of course) suggesting that I remove prepositions from my page to rank well. Well, as you know, that is unnatural to the reader. But I suspect people are searching in higher volume, leaving the prepositions out. I know that if I were to search for a sporting goods store in Chicago, I would probably leave out "in." What should I do? Should I remove all the suggested keywords, and make them readable (which people are less like using in their search?) Do I go back to all my pages and try to optimize it for a keyword that is natural, but does not include a preposition (such as Chicago sporting goods stores) or should I be doing something else?
Moz Bar | | osaka731 -
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 | | -Ash-0 -
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 | | Becki1230