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 Regarding Moz API token password update
Hi, In March we have updated password for MOZ API and used in our application it worked, but currently the updated password is not working and in the MOZ site the old password is shown and its active. We are using Legacy username and password.
API | | NickAndrews
We see that 5 tokens can be added for API, if we add 2 tokens both will be active.
We are currently using free services. Please help us resolve this issue.0 -
API v1 still gets new data?
Hello! Do the v1 API endpoints provide fresh data, or do I need to use the v2 endpoints for fresh data? According to the v1 API docs "This guide outlines the endpoints for now archived Mozscape API endpoints." Does this mean that the v1 API only serves archived data? Thanks!
API | | peterkovacs0 -
Does Moz DotBor crawler is the slowest than earlier?
I have these websites https://www.interessanter.com/ and https://www.techniken.net/ I managed to create quality links and reach Ahrefs DR 46 and even TF 20 in a few months, but on my server logs, I haven´t seen any DOT bot logs. It only crawls you if you are linked to a very high DA site now? To be honest I placed here those links ask in order to see if that helps. I remember that last year it wasn't like that. If someone can point me in the right direction to increase DA and PA I will really appreciate it. THANKS!
API | | albertomr0 -
Can links tracking lists help to crawl high authority backlinks by Moz?
My backlinks are not crawling by Moz yet after creating them four months ago. I have just added them in the links tracking lists now. May these links tracking lists help to crawl these backlinks by Moz? I have created same backlinks for my another site. But it has crawled by Moz within 10 days. This site is EditorialGE. But the same backlinks of my another sites are not crawled my Moz yet. Even my guest posts' links are not crawled by Moz yet which are created about two months ago. So, I have submitted them to links tracking list. Can links tracking lists help to crawl those high authority relevant backlinks ba Moz? Please let me know.
API | | Groupespr2 -
How can I get "Date First Seen","Date Last Seen" and "Date Lost" from the API?
"Date First Seen","Date Last Seen" and "Date Lost"Â are columns in the CSV exported from LinkExplorer's Inbound Links page. How do I get that data from the API?
API | | StevePoul1 -
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 -
API - Internal Links to page and related metrics
Hi dear moz Team! Currently I´m building a Java application accessing your API. But there are some metrics I urgently need which I can´t get out of the API until now: The total number of internal links to a page The total number of internal links to a page with partial anchor text match MozRank passed by all internal links w. part. match anchor text (would be nice) For example, if I try this by your links endpoint, my idea was: http://lsapi.seomoz.com/linkscape/links/http%3A%2F%2Fwww.jetztspielen.de%2F?AccessID=..
API | | pollierer
&Expires=..
&Signature=..
&Scope=domain_to_page
&Filter=internal
&Sort=domain_authority
&SourceCols=4 (or any other value)
&SourceDomain=www.jetztspielen.de
&Offset=0
&Limit=50 If I try this, the API says: {"status": "400", "error_message": "Cannot set a source domain when filtering for internal links."} Is there any way to get the data I need by your API endpoints? I´m currently writing my master thesis and it is very important to me to solve this somehow. Thank you very much in advance! Best, Andreas Pollierer1 -
I REALLY need some help with Moz Reporting
Hey Moz Community, I really need someone to help me with Moz reporting. Let's say I have 10 websites on my campaign dashboard. Is there an API or settings in campaign where I can generate a Moz report that has all 10 campaigns into one high level report? Right now I can generate 1 report per 1 website and the plan is to make it more easier to digest the information and have all the information for all 10 campaigns in just 1 report. Is that even possible? Thank you in advance!
API | | Josh.B0