Use SEOmoz API in Google Docs Spreadsheet
-
Hi,
Has anyone made functions to get link metrics from SEOmoz API in Google docs spreadsheet?
- Page Authority
- Domain Authority
- Linking Root Domains
- Total Links
_Thanks to Tom Critchlow I got the social metrics, now I just need the ones from SEOmoz api. _
Any help would be sweet.
-
Hey, as promised - here's Ian's post about using the SEOmoz API with Google Docs:
http://www.conversationmarketing.com/2011/04/linkscape-google-spreadsheets.htm
-
Thanks, awesome work
-
I had a play with this (having been inspired by Tom's great SEO tools with spreadsheets article) I played around with Google docs and some of the sample code to query the SEOMoz API.
(BTW I don't think all the data you're looking for is available with the free API.)
I knocked together a google docs spreadsheet that does the query, hope you find it useful as a guide till someone (Messrs. Critchlow and Lurie?) posts something more user friendly.
To use it, make your own copy of the sheet, then:
- enter your member ID and secret key in the blue cells (D1 and F1) - you can get your info from www.seomoz.org/api
- type a number into B1 for the expiry interval,
- the search query should be self-explanatory (cells A4,B4 and C4)
As you'll see from the code, I'm no Google docs expert, but hopefully you'll see how the call gets put together.
-
Cool. Looking forward to it.
-
Hey - I've been working with Ian Lurie from Portent and he has a blog post on it's way that details how to do exactly this! Look out for it in the next week or so
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
-
Goal Totals in Google Analytics
How do I get a cumulative tally of all the goals reached in google analytics? I've been using the percentages currently, but I was wondering if there was an easier way. Thanks
Reporting & Analytics | | OOMDODigital0 -
Google not reading my canonical links
Hi All, New to SEOmoz but so far love it. My reports list tons of duplicate links and webmaster tools does as well. In fact it just updated last night and added several hundred more. I have the canonical tag on my products. Here is a product example page: http://www.stonehousecollection.com/card/funny-christmas-cards/KX296a.html Thank you for the help. Matt
Reporting & Analytics | | mker0 -
Registration tracking with Google Analytics
Hi everyone, I want to track user registrations with Google Analytics for a customer's website. The thing is after registration visitors are not directed to a specific page, so I can't set it as a goal. I thought of tracking submit button with event tracking, but that data would not be true as a visitor may click it more than once, and there's the login with facebook and twitter thing. Before convincig customer to create a registration confirmation page, I want to make sure there's no other way as they don't want to make any changes to the current website. Any ideas?
Reporting & Analytics | | ugurcanuzer0 -
Google Analytics underreporting
I have a site selling items, I use paypal buttons and get a report using ipn back from paypal telling me when I have sold a item. I also have a Google analytics event setup on the button, and one on the confirmation page.
Reporting & Analytics | | AlanMosley
For example in the last few days I have sold over 10 items from the website, but have only 2 events from the button and none from the confirmation page. The confirmation page depends on the user getting redirected back from PayPal so I can see that being upper reported, but there is no way you can buy without clicking the button.
I have the chrome addon from google to debug your analytics code and it fires every time.
The figures seem to report only about 20% of events over a long period of time. If it was not working at all, I could assume I have not set things up correctly but this is not the case, I get a regular flow of events but at about 205 of sales.
I am very disappointed with GA, seems a waste of time. anyone else had the same expirence?0 -
Google Analytics: Deleted Profile
Has anyone ever successfully managed to have a deleted GA profile restored? One of our client's profiles was deleted accidentally. I know the official line is it can't be restored, but...
Reporting & Analytics | | David_ODonnell0 -
Easiest way to get out of Google local results?
Odd one this, but what's the easiest way to remove a website from the Google local listings? Would removing all the Google map listings do the job? A client of ours is suffering massively since the Google update in the middle of last month. Previously they would appear no1 or no2 in the local results and normally 1 or 2 in the organic results. However, since the middle of last month any time they rank on the first page for a local result, their organic result has dropped massively to at least page 4. If I set my location as something different in google, say 100 miles away, they then rank well for the organic listings (obviously not appearing for local searches). When I change it back to my current location the organic listing is gone and they are back to ranking for the local. Since the middle of July the traffic from search engines has dropped about 65%. All the organic rankings remain as strong as ever just not in the areas where they want to get customers from!! The idea is to remove the local listing and get the organics reranking as the ctr on those is much much higher. On a side note, anyone else notice very poor ctr on google local listings? Maybe users feel they are adverts thanks
Reporting & Analytics | | ccgale0 -
List all URL's indexed by google
Hi all i need a list of all urls google has indexed from my site i want this in excel format or csv how do i go about getting this thanks in advance
Reporting & Analytics | | Will_Craig0 -
Editing Google Analytics eCommerce Javascript for Volusion
Does anyone know how to edit the ecommerce javascript with Volusion dynamic variables? I thought I did it correctly but none of the information got recorded in GA. It recorded that there was a transaction made but not info on the purchase price, order #, etc. This is the current code I am using: NOTE: In Volusions customer support center they provided this information: Where Order-Specific Information is Generated Order-specific information can be generated by JavaScript on the OrderFinished.asp page within Volusion. On this page, two JavaScript arrays will be initialized that advanced users may need to be aware of. The arrays and their contents are as follow:
Reporting & Analytics | | jhooley
Order Array Contents Order[0] = Order ID
Order[1] = Unused
Order[2] = Payment Amount
Order[3] = Affiliate Commisionable Value
Order[4] = Sales Tax
Order[5] = Total Shipping Cost
Order[6] = Billing City
Order[7] = Billing State
Order[8] = Billing Country OrderDetails Array Contents OrderDetails[X][0] = Order ID
OrderDetails[X][1] = Order Detail ID
OrderDetails[X][2] = Product Code
OrderDetails[X][3] = Product Name
OrderDetails[X][4] = (unused)
OrderDetails[X][5] = Product Price
OrderDetails[X][6] = Quantity Note that in the above example, X refers to a line item number (beginning from zero). Note that there can be multiple Order Details arrays - one for each item contained within an order. I'm a newbie at Analytics installation and could really use any help. Thanks!1