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
-
Can Google Crawl & Index my Schema in CSR JavaScript
We currently only have one option for implementing our Schema. It is populated in the JSON which is rendered by JavaScript on the CLIENT side. I've heard tons of mixed reviews about if this will work or not. So, does anyone know for sure if this will or will not work. Also, how can I build a test to see if it does or does not work?
Intermediate & Advanced SEO | | MJTrevens0 -
Can you create town focused landing pages for a website without breaking Google guidelines?
I recently watched a webmaster video that said that town focused landing pages are seen as doorway pages if they only exist to capture search traffic. And then I read that just because you can sell your product/service in a certain area, doesn't mean you can have a page for it on your website. Is it possible to create town focused landing pages for a website without breaking Google guidelines?
Intermediate & Advanced SEO | | Silkstream1 -
Prioritise a page in Google/why is a well-optimised page not ranking
Hello I'm new to Moz Forums and was wondering if anyone out there could help with a query. My client has an ecommerce site selling a range of pet products, most of which have multiple items in the range for difference size animals i.e. [Product name] for small dog
Intermediate & Advanced SEO | | LauraSorrelle
[Product name] for medium dog
[Product name] for large dog
[Product name] for extra large dog I've got some really great rankings (top 3) for many keyword searches such as
'[product name] for dogs'
'[product name]' But these rankings are for individual product pages, meaning the user is taken to a small dog product page when they might have a large dog or visa versa. I felt it would be better for the users (and for conversions and bounce rates), if there was a group page which showed all products in the range which I could target keywords '[product name]', '[product name] for dogs'. The page would link through the the individual product pages. I created some group pages in autumn last year to trial this and, although they are well-optimised (score of 98 on Moz's optimisation tool), they are not ranking well. They are indexed, but way down the SERPs. The same group page format has been used for the PPC campaign and the difference to the retention/conversion of visitors is significant. Why are my group pages not ranking? Is it because my client's site already has good rankings for the target term and Google does not want to show another page of the site and muddy results?
Is there a way to prioritise the group page in Google's eyes? Or bring it to Google's attention? Any suggestions/advice welcome. Thanks in advance Laura0 -
How can a website have multiple pages of duplicate content - still rank?
Can you have a website with multiple pages of the exact same copy, (being different locations of a franchise business), and still be able to rank for each individual franchise? Is that possible?
Intermediate & Advanced SEO | | OhYeahSteve0 -
Ranking strangeness
Just wondering if anyone had come across this kind of scenario which I had/have with a client. Rebuilt/revamped site that has got problems with thin content we are looking to resolve. Rankings for the main keywords were ok on page 2 or 3 and being worked on. Two weeks ago ALL main keywords disappeared from ranking (category pages). The homepage took over and ranked ALL those keywords at #1! Bang -straight to top spot. However happy I was I find this disconcerting as there is a reasonable level of competition. Today homepage rankings in the main go and directories come back into the rankings at some good positions on page one. We still need to fix thin and duplicated content! I can justify the problems and swing with the category pages but the massive cross the board top position for the homepage has been pretty bizarre. Has anyone else had the experience where the homepage suddenly 'out-performs' in a big way?
Intermediate & Advanced SEO | | MickEdwards0 -
Google Places Listing Active In Two Seperate Google Places Accounts?
Hi is there any issues with having a google places listing in two seperate google places accounts. For example we have a client who cannot access their old google places account (ex-employee had their login details which they can't get) and want us to take control over the listing. If we click the "is this your listing" manage this page button - and claim the listing, will this transfer the listing to our control? Or will it create a duplicate? Are there any problems having the listing in different separate accounts. Is it a situation in which the last person who manages the listing takes control? And the listing automatically deactivates from the old account? Do all the images remain aswell? Thanks,
Intermediate & Advanced SEO | | MBASydney
Tom0 -
Why is my XML sitemap ranking on the first page of google for 100s of key words versus the actual relevant page?
I still need this question answerd and I know it's something I must have changed. But google is ranking my sitemap for 100s of key terms versus the actual page. It's great to be on the first page but not my site map...... Geeeez.....
Intermediate & Advanced SEO | | ursalesguru0 -
How Can I move a site higher in Google Places?
As we all know Google Local Business/Places now has significant real estate for many searches. What I find hard to understand is what makes the difference between the different positions. Is it solely based on the content in Google Places itself or is it regular ranking factors. I am (like everybody) on a hell for leather search to try and rank above my competition but having studied their Places information I do not think there is much I more I can do. Suggestions hat have actually worked for you?
Intermediate & Advanced SEO | | kdaly1000