This Analytics Edge wizard returns metrics for many URLs on a subdomain you specify. [Paid Moz API access required]
Enter the link URL (e.g. moz.com/blog) and select the sort and filter options.If you want more than the default 25 rows, enter a limit number.
You can get the URL from a worksheet cell by clicking the button and selecting the cell.
Click image to enlarge
On the Fields tab, select the fields desired from the left side list.
Metrics can be added by double-clicking in the list, or by selecting and clicking the >> button. Drag-and-drop to reorder the list of selected metrics.