The Scenario
The content roadmap meeting is Thursday. The content strategist needs a concrete list of what topics a competitor is winning on before the team debates what to build next. Someone pulled the competitor's sitemap two weeks ago and it has 4,000 URLs — none of which are sorted by any signal that matters. What you actually want is the competitor's top 50 pages by Page Authority, so you can see where they have earned real editorial weight.
The bad version:
- Log into Moz Link Explorer and run a top-pages search for the competitor domain. You get a table in the UI.
- Export to CSV. Open in Excel. Realize the export has 12 columns you do not need and the PA column is fourth from the right. Trim, reformat.
- Now match this against your existing content calendar to identify gaps — a VLOOKUP across two worksheets where the URL format conventions do not quite match.
By Thursday you have a workbook that mostly works, you have explained it twice to colleagues who do not understand why the rows are sorted the way they are, and the original insight you were chasing has gotten buried under process.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Moz, pulls the top pages for any domain, and writes the results directly into your workbook — with whatever column layout you specify.
Get the top 50 pages from competitor.com using Moz and list each page URL and its Page Authority in this worksheet starting at row 2, sorted by Page Authority descending.
What You Get
- Column A fills with the top 50 page URLs from the competitor domain, sorted by Page Authority high to low.
- Column B fills with the Page Authority score for each URL.
- Rows start at row 2, leaving row 1 available for headers.
- URLs that rank but have no indexable Page Authority data are noted clearly rather than silently excluded.
What If the Data Is Not Quite Ready
You need top pages for multiple competitors, not just one
The roadmap meeting covers four competitor domains. You want one worksheet per domain.
For each domain in column A of the Competitors worksheet, fetch the top 20 pages from Moz and write each page URL and Page Authority into a separate worksheet named after the domain.
You want to cross-reference against your existing content URLs
Your editorial tracker is in the Content Calendar worksheet, with URLs in column B. You want to flag which competitor top pages you already cover.
Pull the top 50 pages from competitor.com using Moz and write each URL and Page Authority into columns A and B of this worksheet, then check each URL in column A against column B of the Content Calendar worksheet and mark column C with "Covered" or "Gap" for each.
The URLs need cleaning before the comparison works
Trailing slashes, mixed HTTP and HTTPS, and parameter strings are making the matching inconsistent.
Pull the top 50 pages from competitor.com using Moz, normalize each URL to HTTPS with no trailing slash and no query parameters, write them to column A with Page Authority in column B, then match against normalized URLs in the Content Calendar worksheet column B and mark column C with "Covered" or "Gap."
Full competitive content audit in a single prompt
You need the top 30 pages for three competitors, their PA scores, and a column flagging which ones target keywords already in your tracker.
For each domain in the list competitor1.com, competitor2.com, competitor3.com — pull the top 30 pages from Moz, write domain name to column A, page URL to column B, Page Authority to column C, then check each URL against the Keywords worksheet column D and mark column D with "In scope" or "Not targeted."
Running the research and the gap analysis as one operation means you arrive at Thursday's meeting with a finished artifact.
Try It
Get the 7-day free trial of SheetXAI and open your competitive research workbook, then ask it to pull the Moz top pages for whatever domain you are analyzing. The Moz integration is included in every SheetXAI plan. Also useful: bulk DA and Spam Score lookup and the full Moz integration overview.