The Scenario
You are a content ops manager at a mid-size company. Leadership has asked for a content pruning and consolidation project: find underperforming pages, pages that lost visibility, and pages that have never broken through. You need every page currently ranking in Google's top 100 for your domain, with estimated organic traffic, number of ranking keywords, and the top keyword per URL.
The domain is in cell A1 of the Domains tab. The project kickoff is Monday. Today is Thursday.
The bad version of this project:
- You open Semrush and pull the Organic Pages report for your domain
- The report has 847 pages and exports with 12 columns you do not need
- You download the CSV, delete unwanted columns, reorder the ones you keep
- You realize "top keyword" is not a column in the export — it requires a separate click per row
- You manually note the top keyword for your top 50 pages
- You go into Monday's kickoff with data for 50 pages instead of 847.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the domain from cell A1 and pulls the full organic pages report from Semrush, writing only the columns you need into the workbook.
Open the SheetXAI sidebar and type:
Fetch the Semrush organic pages report for the domain in cell A1 of the Domains tab and write each ranking URL, its estimated traffic, keyword count, and top keyword into columns A through D on a new tab called Pages. Include all pages currently ranking in the top 100.
SheetXAI pulls the full pages report and writes exactly the four columns you asked for, one row per ranking URL.
What You Get
A Pages tab with:
- Column A — URL — the ranking page's full URL
- Column B — EstimatedTraffic — monthly organic traffic estimate from Semrush
- Column C — KeywordCount — number of keywords this URL ranks for
- Column D — TopKeyword — the keyword driving the most traffic to this URL
Sort by EstimatedTraffic descending. Your top 20 pages drive the bulk of organic traffic. The pages at the bottom with KeywordCount of 1 and EstimatedTraffic under 10 are your pruning candidates.
What If the Data Is Not Quite Ready
Content audits need segmentation before they are actionable.
When you want to separate blog posts from product and category pages
Your workbook has mixed content types and you want to analyze them separately.
Fetch the Semrush organic pages report for the domain in A1. Write URL, estimated traffic, keyword count, and top keyword into columns A through D on the Pages tab. Then in column E, categorize each URL: "Blog" if the URL contains /blog/, "Product" if it contains /products/, "Category" if it contains /category/, and "Other" for everything else. Sort by ContentType then EstimatedTraffic descending.
When you want to flag pages with very few keywords but meaningful traffic
A page ranking for only 1–2 keywords but generating significant traffic is a consolidation risk.
After pulling the organic pages report, add a Risk column: "Single-Keyword Risk" for any URL with keyword count of 1–2 and estimated traffic above 200. "Thin" for any URL with keyword count above 5 but estimated traffic below 20. Leave the rest blank.
When you want to pull pages for multiple domains to compare content depth
You want to compare your organic pages inventory against one competitor.
Fetch the Semrush organic pages report for each domain in column A of the Domains tab. Write URL, estimated traffic, keyword count, and top keyword into new rows on a Pages tab with a Domain column. After building the tab, count total ranking pages per domain and write the summary at the top.
When the full content audit needs pages data, risk flags, and pruning recommendations in one pass
The content team needs to start acting Monday morning.
Fetch the Semrush organic pages report for the domain in A1 and write URL, estimated traffic, keyword count, and top keyword into columns A through D on the Pages tab. Categorize each URL by section in column E. Flag "Prune" in column F for any URL with estimated traffic below 5 and keyword count of 1. Flag "Consolidate" for URLs with estimated traffic below 20 but keyword count above 10. Sort by Flag then EstimatedTraffic descending.
The pattern: the data pull, the risk flagging, and the action recommendation all come from one prompt.
Try It
Get the 7-day free trial of SheetXAI and put any domain in cell A1 of any Excel workbook, then ask it to pull the organic pages report from Semrush. The Semrush integration is included in every SheetXAI plan. For a related workflow, see how to map the geographic distribution of referring domains in Excel or the Semrush in Excel overview.