Alternatives to Supermetrics to get Moz metrics into Google Sheets?
-
Hi,
Interested in getting Moz API metrics into Google Sheets on an automated scheduled.
Supermetrics can do this, but I am curious to know if there are any alternatives, free or paid.
Thanks!
-
Hopefully one of our community members can chime in with programs that have worked for them.
-
Hi Tawny,
Thanks. As I said, Supermetrics for Google Drive does this, but at $600/year I thought I would ask the community if there are any free or cheaper options first.
There was a tool that Chris Le created (and mentioned here on the Moz blog: https://moz.com/ugc/updated-tool-seomoz-api-data-for-google-docs), however I can't get the thing to actually work!!
-
Hey there! Tawny from Moz's Customer Support team here.
I don't know of any programs that could get our Mozscape API metrics into Google Sheets for you, but perhaps one of our many friendly and knowledgeable community members has some leads 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 Does Anyone use DashThis API with MOZ?
Hi Team
API | | SkyrailCairns
Looking to share MOZ API credentials with DashThis - They provide an all in one reporting solution for all aspects of digital marketing.
Does anyone use DashThis?0 -
Is there a way to connect to MOZ Pro data via Tableau?
Looking to automate reporting data from MOZ Pro. Specifically, site audit and keyword ranking data. Would like to connect to MOZ Pro backend via Tableau. Not seeing an obvious way to do this. Any guidance?
API | | jevons0 -
Have Questions about the Jan. 27th Mozscape Index Update? Get Answers Here!
Howdy y'all. I wanted to give a brief update (not quite worthy of a blog post, but more than would fit in a tweet) about the latest Mozscape index update. On January 27th, we released our largest web index ever, with 285 Billion unique URLs, and 1.25 Trillion links. Our previous index was also a record at 217 Billion pages, but this one is another 30% bigger. That's all good news - it means more links that you're seeking are likely to be in this index, and link counts, on average, will go up. There are two oddities about this index, however, that I should share: The first is that we broke one particular view of data - 301'ing links sorted by Page Authority doesn't work in this index, so we've defaulted to sorting 301s by Domain Authority. That should be fixed in the next index, and from our analytics, doesn't appear to be a hugely popular view, so it shouldn't affect many folks (you can always export to CSV and re-sort by PA in Excel if you need, too - note that if you have more than 10K links, OSE will only export the first 10K, so if you need more data, check out the API). The second is that we crawled a massively more diverse set of root domains than ever before. Whereas our previous index topped out at 192 million root domains, this latest one has 362 million (almost 1.9X as many unique, new domains we haven't crawled before). This means that DA and PA scores may fluctuate more than usual, as link diversity are big parts of those calculations and we've crawled a much larger swath of the deep, dark corners of the web (and non-US/non-.com domains, too). It also means that, for many of the big, more important sites on the web, we are crawling a little less deeply than we have in the past (the index grew by ~31% while the root domains grew by ~88%). Often, those deep pages on large sites do more internal than external linking, so this might not have a big impact, but it could depend on your field/niche and where your links come from. As always, my best suggestion is to make sure to compare your link data against your competition - that's a great way to see how relative changes are occurring and whether, generally speaking, you're losing or gaining ground in your field. If you have specific questions, feel free to leave them and I'll do my best to answer in a timely fashion. Thanks much! p.s. You can always find information about our index updates here.
API | | randfish8 -
Top Pages metrics in OSE
Not sure if this is an API question or a feature request, but wondering if other folks had a way to do this: In OSE there is the dashboard for a specific URL that is entered into the search bar, giving you metrics at a glance on it. But I often find myself going to the Top Pages tab to get a sense of the domain as a whole. First off, wouldn't it be nice/is there a way to build my own "dashboard" based on info from that section? Specifically, I'd love to see at a glance the number of "top pages" that exist (many websites are well under the 10,000 page limit for this section, but there's no quick glance metric showing that) One thing that would be very handy for me would be a breakdown of HTTP Status info across the whole domain, as being able to see the raw total of different statuses (and the percentages of each based on the total number of pages) would be really helpful, giving me a sense if I should dig into any issues before exporting the list to CSV. I've found myself needing this type of info for multiple domains at once, so what would be REALLY cool would be a Google Doc where I could paste in different domains in one column, and this info being returned in other columns. I've searched through the Q&A and didn't find anything like this, and I didn't know how easy/hard any of this would be to do, but I was wondering if anyone else had a sense of how to solve this problem and how feasible it would be to tackle it. Thanks!
API | | John-E-Turner0 -
Cannot get the API to work when using an EC2 server
Hi I've created a script that I'd like to use to check a list of domains using the Moz API. It works totally fine on my local machine. However, when I run it from my EC2 instance, it fails every time. To be specific, the response is always empty (the response is an empty json array) when the request is sent from EC2. Is, for some reason, EC2 blocked by the Moz API? Many thanks for your help, Andrew
API | | csandrew0 -
Google Analytics keeps poping up that i need to re-authorize.
Moz & GA were playing nice, now their not... everytime i login to my dashboard i see the " you need to re-link your moz & GA" message near the top of the page. it links up fine, i press the i accept button, i get the green all went well now its linked button... may se a gap blah blah, then if i refresh or do anything in moz i see the red banner telling me i need to re-link moz.... any help here?
API | | EarGear0
