The Scenario
You run a content team at a B2B SaaS company. Someone on the leadership team forwarded you a Slack message: "We published 60 new posts last quarter. Which ones are actually working?" The question came in at 4 PM. The all-hands is tomorrow morning.
You know the answer lives in Search Console. You've got page-level data going back six months. What you don't have is a clean way to surface it. The Search Console Pages view shows you the top 1,000 URLs. You can see which ones are stuck below position 20. But getting all 200+ URLs you published last quarter into a sortable, color-coded Excel workbook — with clicks, impressions, and positions alongside them — isn't a five-minute job.
The bad version:
- Export the Pages CSV from Search Console for the last 60 days, open it in Excel, then cross-reference it against your content inventory workbook by hand.
- Spend 30 minutes on VLOOKUP formulas to match URLs between two worksheets with inconsistent formatting — some with trailing slashes, some without.
- Build a conditional flag column manually so the underperformers stand out, only to realize the meeting starts in 20 minutes.
This is supposed to be a content strategy conversation. Instead you're doing URL string normalization.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Excel workbook and connects to Google Search Console through a built-in integration. Tell it what data you need and where to put it.
Your content inventory is already in the workbook — URL in column A, publish date in column B of the "Inventory" worksheet. Then paste this:
Fetch page-level search performance from Search Console for my site for last month and populate my Excel workbook with URL, clicks, impressions, and position — flag any URL with over 1,000 impressions but under 2% CTR in a column called "Opportunity"
What You Get
- One row per URL, sorted by impressions, highest first.
- Columns: URL, Clicks, Impressions, CTR, Average Position, Opportunity Flag.
- The Opportunity column reads "Opportunity" for URLs crossing both thresholds, blank otherwise.
- URLs in your inventory that returned no Search Console data appear with zero values — not missing rows.
- The sort means the buried high-impression pages surface immediately, no pivot table needed.
What If the Data Is Not Quite Ready
Your content inventory uses a different URL format than Search Console reports
Fetch page-level Search Console performance for my site for the last 60 days, write it to the "Page Data" worksheet, then normalize all URLs by stripping trailing slashes and forcing lowercase before matching against column A of my "Inventory" worksheet
You want separate ranges for top performers and underperformers
Pull page-level performance from Search Console for the last 60 days for my site, sort by clicks descending, write the top 20 by clicks into rows 2–21 of my "Top Pages" worksheet, and write any page with under 50 clicks but over 500 impressions into a separate range starting at row 25 labeled "Needs Work"
You need to filter to a specific subfolder only
Get Search Console page performance for the last 60 days for all URLs on my site that start with /blog/, sorted by impressions descending, and write the results into columns A through E of my "Blog Performance" worksheet
The full cleanup and analysis in one pass
Pull 60-day page-level data from Search Console for my site, write it into my "Page Analysis" worksheet, flag each row as "Rank" (position ≤ 10), "Trending" (position 11–20, impressions > 500), or "Buried" (position > 20), then calculate average CTR for each category and write the summary starting at row 200
One prompt gets the data, applies the tiering logic, and writes the summary.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you track your published content. Ask it to pull page-level Search Console data matched against your content inventory so the "what's working?" question has an answer before the all-hands starts. See also the hub overview for other Search Console workflows available in Excel.