Spreadsheets are scary.
Nothing fills me with more dread than a blank spreadsheet with all its cells and rows staring back waiting to be filled with data. Luckily, Google Sheets lets us do some pretty amazing things to speed up the process of filling those cells and rows. We created a tool which helps do just that and we are sharing it.
For free? Yes, free.
This Google Apps Script will automagically take your boring spreadsheet full of URLs and fill it with beautiful MOZ data, specifically External Link Equity and Page Authority. If you don’t know what those are, click those links and learn a bit. Or, here is the TLDR from our own Kirk P. Gillam.
Page Authority: As defined by Moz is the ability of a page to rank in the Google search results. Moz’s Page Authority includes links, MozRank, and MozTrust, plus numerous other factors.
External Link Equity:Links with equity are those that pass some of their equity to the page they are linking to, thereby potentially helping the targeted page’s ability to increase its position in the search results.
How to use:
Download the script from Github using the link above or copy the raw contents of moz-page-authority.js directly into the Google Sheet script editor. The script editor can be found under the menu Tools -> Script editor. If you don’t have a MOZ account you will need one of those before proceeding. Don’t worry, that is free too. Once you have your MOZ account setup, you can setup the script.
There are five variables that need to be set before you run the script.
- accessID: You get this from MOZ
- secret: Also from MOZ
- rowOffset: The number of rows above your data. This allows you to have sheet titles and headers.
- pageAuthorityColumn: The column letter for Page Authority ex: ‘B’ or ‘AM’
- externalEquityLinksColumn: The column letter for Page Authority ex: ‘C’ or ‘AN’
There are some limitations to spoil our fun. This script is designed to work within the free MOZ API limits. It will only request ten URLs every eleven seconds. If you have a spreadsheet with a massive amount of URLs it may take some time to fetch all the data. Probably a good time to get a coffee. MOZ updates this data every few weeks so there is no need to refresh the data more often than say once a month.