How can I export SEOmoz ranking reports to google spreadsheet
-
How can I export SEOmoz website rankings to Google Spreadsheet? I have applied other SEOmoz API's and Google Spreadsheet combos effectively but cannot find anything online for this.
I would like to display current ranking and ranking history for specific keywords in Google Spreadsheet and have them update automatically using the SEOmoz API.
-
Yes, that is what I am doing now but like to have it automated using triggers like explained at http://www.aleydasolis.com/en/search-engine-optimization/seo-dashboard-google-docs-seomoz-analytics/.
-
Not sure about the automatic updating part but if you access your rankings in your SEOmoz campaign you can export to PDF or CSV. You can export the whole rankings history to CSV if you want. It's at least a start.
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
-
Why do SEO agencies ask for access to our Google Search Console and Google Tag Manager?
What do they need GTM for? And what is the use case for setting up Google Search Console?
Intermediate & Advanced SEO | | NBJ_SM0 -
How Can I Displace a Quora Q&A in a Google Featured Snippet?
Hello all. I'm looking for ideas for displacing a Quora Q&A as the featured snippet in google search results. I rank organically for the target term (it's a branded term, "urban airship pricing") in results 1, 2, 3 and 4. The Quora Q&A ranks 5, but is still getting the featured snippet. The Quora question, which is from 2013, is negative - essentially "why does Urban Airship cost so much." It was posed / someone answered the question before we restructured pricing, and added a free starter edition, so the information in the answer is incorrect. It's causing issues for our sales teams, there's a fair amount of volume around this term for us, and worst of all, it's making me mad 😉 I've considered the tactics listed below, but would love to know if anyone's done this, and what free or low-lost tactics work/where to focus efforts. Thanks in advance for help! -Jessica Tactics I'm Considering (Are some or all worth doing? Better ideas?) Create a pricing FAQ page on my website to try give Google a short answer to a query related to pricing that it might feature instead of the Quora Q&A Get a lot of folks to downvote the Quora question (and upvote the short answer we added). Although I'm worried that "activity" on the question might actually make things worse not better in terms of its visibility. Buy paid Google Adwords for the term so the featured snippet isn't quite so starkly featured (we were buying for this term, looking into why our ads aren't showing up at the moment) Talk about pricing on sites like Product Hunt or others (other ideas?) to see if they'll rank highly enough to add more/better content to page 1 results. Contact Quora and let them know that this outdated question is being pulled into a featured snippet and see if they'll do something about it (remove it, etc.) Provide feedback to Google (using the link under the snippet) that "something is wrong" or "this isn't useful"
Intermediate & Advanced SEO | | jpoundstone0 -
Drop in Rankings
UPDATE* I temporarily removed the images from the page to check if rankings would come back and they did. So Google made a recent update in the Netherlands where they look at your page for adult content (pictures). For us it was breast augmentations, before and after pics. END Hey Guys, We have a site for plastic surgery in the Netherlands. We ranked on number 2 if someone searched for breast augmentation. But sinds 31 of januari our ranking dropped outside the top 50. I did not get a warning or an other message in Search Console. We have a lot of pictures on the website displaying before and after pictures. So you see breasts. Does anybody know if google rolled out an update where they look at photo's with audult content? We didnt do any linkbuilding or other black hat stuff. Kind regards, Ruud
Intermediate & Advanced SEO | | equipezorgbedrijven0 -
Nothing I Know About SEO can Explain these Rankings?
Hi all, I have a client who wants to rank more prominently for "plastic surgeon jupiter fl", a key term in his niche that attracts 11-50 searches per month (but these are potentially big ticket clients). If you look at the first page of results for that term, I can't make any sense of them. I've checked page speed, Google listing optimization, on-page SEO, link metrics etc. and there seems to be no correlation with good on-page SEO, quality links (or volume of links). Any thoughts?? I literally cannot explain why the #1 site shows 2 inbound links via Moz OSE and almost no on-page SEO to speak of while sites ranking page 2 have better on-page SEO, more links, higher quality links (from what I can tell) etc.
Intermediate & Advanced SEO | | RickyShockley0 -
Can we talk a bit more about cannibalisation? Will Google pick one page and disregard others.
Hi all. I work for an e-commerce site called TOAD Diaries and we've been building some landing pages recently. Our most generic page was for '2017 Diaries'. Take a look here. Initial results are encouraging as this page is ranking top page for a lot of 'long tail' search queries, e.g) '2017 diaries a4', '2017 diaries a5', '2017 diaries week to view' etc. Interesting it doesn't even rank top 50 for the 'head term'... '2017 diaries'. **And our home page outranks it for this search term. **Yet it seems clear that this page is considered relevant and quality by Google it ranks just fine for the long tails. Question: Does this mean Google 'chosen' our home page over the 2017-page landing page? And that's why the 2017-page effectively doesn't rank for it's 'head term'? (I can't see this as many times a website will rank multiple times such as amazon) But any thoughts would be greatly appreciated. Also, what would you do in this scenario? Work on home-page to try to push it up for that term and not worry about the landing page? Any suggestions or thoughts would be greatly appreciated. Hope that makes sense. Do shout if not. Thanks in advance. Isaac.
Intermediate & Advanced SEO | | isaac6630 -
I think Google Analytics is mis-reporting organic landing pages.
I have multiple clients whose Google Analytics accounts are showing me that some of the top performing organic landing pages (in terms of highest conversion rates) look like this: /cart.php /quote /checkout.php /finishorder.php /login.php In some cases, these pages are blocked by Robots.txt. In other cases they are not even indexed at all in Google. These pages are clearly part of the conversion process. A couple of them are links sent out when a cart is abandoned, etc. - is it possible they actually came in organically but then re-entered via one of these links which is what Google is calling the organic landing page? How is it possible that these pages would be the top performing landing pages for organic visitors?
Intermediate & Advanced SEO | | FPD_NYC0 -
Why does Google rank a product page rather than a category page?
Hi, everybody In the Moz ranking tool for one of our client's (the client sells sport equipment) account, there is a trend where more and more of their landing pages are product pages instead of category pages. The optimal landing page for the term "sleeping bag" is of course the sleeping bag category page, but Google is sending them to a product page for a specific sleeping bag.. What could be the critical factors that makes the product page more relevant than the category page as the landing page?
Intermediate & Advanced SEO | | Inevo0 -
How a press release can help with Google serp?
Hi, After publishing a press release, if that press release is on top position on Google News for the keyword, how will it effect the SERP for that website?
Intermediate & Advanced SEO | | purplar0