The Scenario
A link-building specialist has just kicked off a new client campaign with a target of thirty editorial placements in the next sixty days. The client is in a competitive vertical and the brief is clear: quality over quantity, only the most impactful editorial pages. The specialist's usual approach is to start from the Moz global top pages index — the 100 highest Page Authority URLs in the entire web — and work down from there. The list changes as Moz updates its index, and last month's pull is already stale.
The bad version:
- Navigate to the Moz global top pages section. Pull up the table. The UI shows 25 results per page — click through to page 4 to get the first 100.
- Export to CSV. Notice the CSV does not include the root domain as a separate column, just the full URL. You need the root domain for the outreach tool's domain dedup logic.
- Open in Excel. Write a formula to extract root domains from URLs. Spend fifteen minutes debugging the edge cases — subdomains, country-code TLDs, paths that start with a numeric string.
By the time the list is clean enough to use, you have used up the better part of your Tuesday morning on data prep instead of prospecting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It queries Moz for the global top pages, extracts the fields you need, and writes them to your workbook in immediately usable format.
Fetch the top 100 globally ranked pages from Moz by Page Authority and write each URL and its Page Authority score to this worksheet.
What You Get
- Column A fills with the top 100 page URLs from Moz's global index, ordered by Page Authority high to low.
- Column B fills with the Page Authority score (0–100) for each URL.
- Results reflect the current Moz index at the time of the pull.
What If the Data Is Not Quite Ready
You also need the root domain as a separate column
The outreach tool requires a domain column for deduplication.
Fetch the top 100 globally ranked pages from Moz by Page Authority, write page URL to column A, Page Authority to column B, and the root domain extracted from the URL to column C.
You want to filter out certain domain categories before using the list
Homepage URLs for social platforms and search engines dominate the top of the global index. You want to exclude them.
Pull the top 200 global pages from Moz by Page Authority, write URL and PA to columns A and B, then remove any row where the URL's root domain is in this exclusion list: google.com, youtube.com, facebook.com, twitter.com, linkedin.com, reddit.com, wikipedia.org.
You need to cross-reference against pages you have already pitched
Your pitched-pages tracker is in column A of the Previous Outreach worksheet. You want to see which global top pages are already in your history.
Fetch the top 100 global pages from Moz by Page Authority and write URL and PA to columns A and B. Then check each URL in column A against column A of the Previous Outreach worksheet and mark column C with "Pitched" or "New."
Build the full prospecting shortlist in one shot
Top 150 pages, domain extracted, social/search exclusions removed, already-pitched rows flagged, sorted by PA.
Pull the top 150 global pages from Moz by Page Authority, write URL to column A, PA to column B, and extracted root domain to column C. Remove rows where the root domain is in this list: google.com, youtube.com, facebook.com, twitter.com, linkedin.com, reddit.com, wikipedia.org. Check column A against column A of the Previous Outreach worksheet and mark column D with "Pitched" or "New." Sort remaining rows by PA descending.
Pull, extract, filter, cross-reference — all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your link-building workbook, then ask it to pull the Moz global top pages directly into your prospecting tracker. The Moz integration is included in every SheetXAI plan. Also useful: global top domains for domain-level prospecting and the full Moz integration overview.