100 Best Claude Excel Data Analysis Prompts for SEO Agencies

Direct Answer

The best Claude prompts for Excel data analysis for SEO agencies are detailed, role-based tasks that transform Excel data into actionable insights, dashboards, and reports. They are designed to be copyable, specific, and reusable, providing placeholders and constraints to ensure consistent outputs. This collection helps SEO teams audit, optimize, and report with Claude across many data scenarios.

Introduction

This page is a practical prompt library focused on Excel data analysis for SEO agencies. It provides a curated list of Claude prompts that turn Excel data into concrete SEO insights, reports, and actions.

Designed for SEO professionals, data analysts, and agency teams, these prompts enable faster data-to-decision work without needing to invent missing context each time.

How to Use These Claude Prompts

• Replace placeholders like [Month], [Keyword], [Page] to fit your dataset and goals.
• Add constraints and formatting requests to tailor the output for client-ready reports.
• Ask for outputs in plain-text tables or bullet points suitable for paste into dashboards or documents.
• Request multiple outputs per prompt when you need both a summary and a detailed breakdown.
• Verify outputs against the source data to ensure alignment and catch any anomalies.

100 Best Claude Excel Data Analysis Prompts for SEO Agencies

1. Top keywords by source: You are an SEO data analyst. Task: produce a ranked list of top keywords by source channel from given Excel columns Keyword, Source, Impressions, Clicks, and CTR. Context: dataset contains multiple campaigns across months. Output: a clean table showing rank, keyword, source, impressions, clicks, CTR, and a one-line takeaway per keyword. Constraints: exclude branded keywords, use at most two decimal places for CTR, provide total impressions and clicks at bottom. Format: plain-text table suitable for paste into client report.
2. Traffic by page segment: You are an SEO data analyst. Task: summarize organic traffic by page category from Excel columns Page, PageViews, Sessions, Conversions, and Revenue. Context: page categories reflect site taxonomy. Output: bullet list with one-sentence insight per page category and a two-sentence overall conclusion. Constraints: include per-category percentage of total traffic, avoid external data. Format: plain text with bullet points.
3. SERP feature impact: You are an SEO data analyst. Task: assess impact of SERP features on traffic using columns Query, SERPFeature, Impressions, Clicks, Position. Context: compare features like Featured Snippet, People Also Ask, and Rich Cards. Output: table with feature, impressions, clicks, CTR, average position, and a two-sentence interpretation. Constraints: group similar features, maintain at most 7 rows. Format: plain-text table.
4. Backlink quality score: You are an SEO data analyst. Task: compute a simple backlink quality score from an Excel row with columns Domain, DA, ReferringDomains, Anchors. Context: weights: DA 0.4, ReferringDomains 0.4, Anchors 0.2. Output: a score between 0 and 100, ranking, and a one-line action. Constraints: clamp scores to 0-100. Format: plain-text results.
5. Content gaps finder: You are an SEO data analyst. Task: identify content gaps using a keyword list in Column A and current content topics in Column B. Context: aim to find high-potential topics not covered. Output: four topic ideas with rationale, guess a potential page URL, and suggested primary keyword. Constraints: show expected monthly search volume ranges using placeholders [low], [mid], [high] instead of real data. Format: plain-text bullet list.
6. Competitor ranking delta: You are an SEO data analyst. Task: compute ranking deltas between two competitors across a list of queries. Context: provide per-query delta and a summary trend. Output: two-column table (Query, DeltaRank) and a 3-sentence overall trend. Constraints: negative means competitor overtook. Format: plain-text table.
7. Cohort performance: You are an SEO data analyst. Task: analyze cohort performance by acquisition date in Excel with columns Cohort, Impressions, Clicks, Conversions, Revenue. Context: cohort-based insights for marketing teams. Output: cohort matrix with key metrics and a one-line recommendation per cohort. Constraints: round conversions and revenue to nearest whole number. Format: plain-text blocks.
8. Traffic forecast model: You are an SEO data analyst. Task: build a simple Excel-based forecast using historical monthly data in Columns Month, Impressions, Clicks, Conversions, Revenue. Context: use naive forecast with a trend adjustment. Output: forecast table for the next six months and a one-paragraph explanation. Constraints: avoid overfitting, include confidence note. Format: plain-text table.
9. On-page optimization score: You are an SEO data analyst. Task: compute an on-page optimization score from Excel columns Page, TitleLength, H1Count, MetaDescriptionLength, ImageAltCount. Context: normalize to 0-100. Output: table of pages with score and a 1-line optimization tip per page. Constraints: exclude non-content pages. Format: plain-text table.
10. Traffic vs spend: You are an SEO data analyst. Task: analyze the relationship between ad spend and organic traffic using columns Spend, Impressions, OrganicTraffic, Revenue. Context: determine ROI-neutral, ROI-positive, ROI-negative segments. Output: summary plus a scatter-like text chart. Constraints: use simple counts for segments. Format: plain-text summary.
11. Anchor text distribution: You are an SEO data analyst. Task: report distribution of anchor text types from a dataset with AnchorType and Count. Context: identify over-optimization risk. Output: pie-like text breakdown and a recommended anchor mix target. Constraints: provide safe anchor guidance without giving exact percentages beyond reasonable. Format: plain-text.
12. Top landing pages: You are an SEO data analyst. Task: list top landing pages by sessions from columns Page, Sessions, Conversions, Revenue. Context: prioritize pages with high conversions. Output: ordered list with page URL, sessions, conversions, revenue, and a one-line takeaway per page. Constraints: show top five pages.
13. Keyword difficulty map: You are an SEO data analyst. Task: create a difficulty map from a dataset with Keyword, KD, Impressions, Clicks, Conversions. Context: categorize KD into easy, medium, hard. Output: table with keyword, KD, category, impressions, CTR, recommendation. Constraints: keep to 12 rows. Format: plain-text table.
14. Seasonal trend analyzer: You are an SEO data analyst. Task: detect seasonal patterns in monthly keyword data with Columns Keyword, Month, Impressions, Clicks. Context: identify peak months. Output: seasonal report per keyword and a 1-line yearly takeaway. Constraints: ignore out-of-sample months. Format: plain-text.
15. Cumulative impact: You are an SEO data analyst. Task: compute cumulative impressions and clicks over time for a given keyword set. Context: show growth trajectory. Output: timeline with cumulative metrics and a one-line insight. Constraints: ensure correct cumulative totals. Format: plain-text.
16. ROI by campaign: You are an SEO data analyst. Task: evaluate ROI by campaign using columns Campaign, Revenue, Cost, Impressions, Clicks. Context: rank campaigns by ROI. Output: table with ROI percent, revenue, cost, and a one-line action per campaign. Constraints: declare ties clearly.
17. Top performing pages by CTR: You are an SEO data analyst. Task: identify pages with highest CTR from Page, Impressions, Clicks, CTR. Context: avoid pages with very low impressions. Output: list of pages with metrics and a one-sentence takeaway per page. Constraints: show at least five pages if available. Format: plain-text.
18. Indexing issues detector: You are an SEO data analyst. Task: flag indexing issues from a dataset with Page, IndexStatus, CrawlErrors. Context: produce actionable fixes. Output: table of problematic pages and recommended fixes. Constraints: group by issue type. Format: plain-text.
19. Internal link map: You are an SEO data analyst. Task: generate a concise internal linking map from a CSV with Page, InternalLinks, PagePriority. Context: improve crawl depth and relevance. Output: bullets per page showing top internal links and rationale. Constraints: limit to 20 pages. Format: plain-text.
20. Content freshness score: You are an SEO data analyst. Task: compute content freshness scores from LastUpdatedDate, PageViews, SocialShares. Context: identify pages needing updates. Output: table with score and recommended update type. Constraints: use 0-100 scale. Format: plain-text.
21. International SEO gaps: You are an SEO data analyst. Task: compare country-specific traffic from columns Country, Sessions, Conversions. Context: spot international growth opportunities. Output: table with country, sessions, conversions, recommended actions. Constraints: exclude undefined countries. Format: plain-text.
22. Schema impact check: You are an SEO data analyst. Task: assess schema impact by comparing pages with and without schema using metrics in Columns Page, SchemaPresent, Impressions, Clicks. Context: summarize potential lift. Output: table and a one-liner conclusion. Constraints: consider only pages with at least 100 impressions. Format: plain-text.
23. Product page performance: You are an SEO data analyst. Task: evaluate product page SEO metrics from a dataset with ProductID, Impressions, Clicks, Conversions, Revenue. Context: identify underperforming SKUs. Output: list of underperformers with suggested optimizations. Constraints: include at least three items. Format: plain-text.
24. Meta description QA: You are an SEO data analyst. Task: audit meta descriptions against page topics using Title and MetaDescription fields. Context: score relevance and length. Output: per-page QA notes and a quick fix list. Constraints: keep descriptions within guidelines. Format: plain-text.
25. URL structure audit: You are an SEO data analyst. Task: audit URL structure from a dataset with URL, PathDepth, Status. Context: recommend structure improvements. Output: table of URLs and recommended changes. Constraints: avoid longer than four path segments. Format: plain-text.
26. CTR uplift plan: You are an SEO data analyst. Task: design a plan to uplift CTR for a target set of keywords with current CTR and position. Context: propose three experiments with expected lift. Output: plan with experiment name, action, success metric. Constraints: time-bound. Format: plain-text.
27. Content revamp checklist: You are an SEO data analyst. Task: produce a revamp checklist for a content group using keyword relevance, user intent, and internal linking. Context: ensure comprehensive coverage. Output: checklist items with owners and due dates. Constraints: limit to 15 items. Format: plain-text.
28. Seasonal content calendar: You are an SEO data analyst. Task: propose a seasonal content calendar from historical data showing months with high search volume. Context: align with campaigns. Output: monthly content ideas with rationale and target keywords. Constraints: avoid overlapping topics. Format: plain-text.
29. Anchor text risk alert: You are an SEO data analyst. Task: detect over-optimized anchor text risks using a dataset with AnchorText, Type, Count. Context: warn if any type exceeds safe thresholds. Output: alert list with recommended diversification. Constraints: provide concrete thresholds. Format: plain-text.
30. Link velocity report: You are an SEO data analyst. Task: report link velocity trends from Date, NewLinks, LostLinks, Domain. Context: benchmark against target velocity. Output: trend lines in text and a one-sentence takeaway per domain. Constraints: aggregate to domain level. Format: plain-text.
31. Site health score: You are an SEO data analyst. Task: compute a site health score from multiple signals: speed, mobile usability, crawl errors. Context: produce a dashboard-ready score 0-100. Output: per-site score with 3 recommended fixes. Constraints: keep explanation brief. Format: plain-text.
32. Keyword overlap matrix: You are an SEO data analyst. Task: create an overlap matrix for two keyword sets A and B with KD, Volume, CPC. Context: identify opportunities for consolidation. Output: matrix table of overlap counts and a suggested migration plan. Constraints: limit to 16 keywords per set. Format: plain-text.
33. Image SEO audit: You are an SEO data analyst. Task: audit image alt text coverage from a dataset with Image, AltText, AltMissing. Context: ensure accessibility and SEO. Output: list of pages with missing alt text and suggested replacements. Constraints: provide upgrade path for 5 items minimum. Format: plain-text.
34. Log file insights: You are an SEO data analyst. Task: extract insights from a CSV log of crawling activity with URL, Status, Time. Context: highlight crawl bottlenecks. Output: prioritized list of issues and fixes. Constraints: be concrete. Format: plain-text.
35. Core web vitals snapshot: You are an SEO data analyst. Task: summarize Core Web Vitals data by page. Context: identify slow pages and optimization steps. Output: table with LCP, CLS, FID, and recommended optimizations. Constraints: actionable items only. Format: plain-text.
36. Conversion path analysis: You are an SEO data analyst. Task: map user journeys from landing pages to conversions using columns Page, Step, ConversionValue. Context: find drop-off points. Output: funnel steps with drop-off percentages and fixes. Constraints: keep it to five steps max. Format: plain-text.
37. Seasonal keyword clusters: You are an SEO data analyst. Task: cluster keywords by seasonality using Month and Keyword. Context: create five clusters. Output: list of clusters with representative keywords and rationale. Constraints: 5 clusters max. Format: plain-text.
38. Content freshness prompts: You are an SEO data analyst. Task: generate prompts to remind editors about updating evergreen content based on page performance. Context: tailor to audience. Output: five reminder prompts with due dates and owners. Constraints: use non-ambiguous language. Format: plain-text.
39. Competitor backlink gaps: You are an SEO data analyst. Task: compare your backlink profile to a competitor using Domain, DA, ReferringDomains, Anchors. Context: identify growth opportunities. Output: list of gap targets and proposed outreach types. Constraints: ensure realism. Format: plain-text.
40. Content silo map: You are an SEO data analyst. Task: draft a content silo map for a topic using internal links and parent-child pages. Context: improve topical authority. Output: outline with 4-6 silos and example pages. Constraints: keep it concise. Format: plain-text.
41. Keyword intent shift: You are an SEO data analyst. Task: detect shifts in user intent for a keyword set over months using Month, Keyword, Intent. Context: adjust content plan. Output: table with intent label changes and recommended actions. Constraints: two actions per keyword max. Format: plain-text.
42. PPC vs organic lift: You are an SEO data analyst. Task: compare paid and organic lift for a set of keywords using Columns Keyword, PaidImpressions, OrganicImpressions, Conversions. Context: evaluate synergy. Output: comparative chart and takeaways. Constraints: limit to 10 keywords. Format: plain-text.
43. Local SEO auditor: You are an SEO data analyst. Task: audit local SEO signals from a dataset with City, Rankings, Reviews, NAPConsistency. Context: produce a local action list. Output: high-priority issues and fixes per city. Constraints: at least three cities. Format: plain-text.
44. Canonicalization check: You are an SEO data analyst. Task: verify canonical status from dataset with URL, CanonicalURL, DuplicateCount. Context: reduce duplicates. Output: list of canonical issues and recommended fixes. Constraints: prioritize pages with duplicates. Format: plain-text.
45. Event tracking plan: You are an SEO data analyst. Task: design an event tracking plan in Excel for key actions with EventName, Page, Category, Label. Context: enable richer analytics. Output: plan with at least four events and justification. Constraints: ensure consistency. Format: plain-text.
46. Content ROI calculator: You are an SEO data analyst. Task: build a simple ROI calculator for content assets with Revenue, Cost, Traffic. Context: compute ROI per asset. Output: a table with ROI percent and suggested optimization. Constraints: round ROI to nearest whole percent. Format: plain-text.
47. URL keyword mapping: You are an SEO data analyst. Task: map URLs to primary keywords using URL and Keyword. Context: support internal linking strategy. Output: mapping table and a 1-sentence rationale per URL. Constraints: keep to 50 mappings max. Format: plain-text.
48. Non-brand search focus: You are an SEO data analyst. Task: isolate non-brand keywords from a mix with BrandColumn, Keywords, Impressions, Clicks. Context: reduce brand bias. Output: list of top non-brand keywords and recommended content angles. Constraints: exclude branded queries. Format: plain-text.
49. Content duplication detector: You are an SEO data analyst. Task: identify duplicate content pages using Page, ContentHash, URL. Context: propose consolidation. Output: duplicates list with suggested canonical pages. Constraints: limit to five clusters. Format: plain-text.
50. Topic authority score: You are an SEO data analyst. Task: compute topic authority from a set of related keywords with Volume and KD. Context: determine strongest topics. Output: table with topic, score, recommended focus. Constraints: 0-100 scale. Format: plain-text.
51. Markdown-ready report: You are an SEO data analyst. Task: generate a compact, markdown-ready SEO report for a client using data from Excel columns provided. Context: produce executive summary and 5 findings. Output: plain-text but formatted for markdown export. Constraints: keep under 800 words. Format: plain-text.
52. Schema suggestion list: You are an SEO data analyst. Task: propose a set of schema types for a site given key pages and content types. Context: align with content. Output: list of pages with recommended schema types and properties. Constraints: no code. Format: plain-text.
53. Page speed by device: You are an SEO data analyst. Task: compare page speed metrics by device category in a dataset with Device, LCP, CLS, TBT. Context: identify device-specific optimizations. Output: table with device, scores, and suggested fixes. Constraints: provide actionable items. Format: plain-text.
54. Content localization plan: You are an SEO data analyst. Task: build a localization plan for international pages using country data and translations. Context: maintain consistency. Output: plan with 4 localization steps and owners. Constraints: include timeline. Format: plain-text.
55. Footnotes and citations: You are an SEO data analyst. Task: ensure proper attribution by listing pages with external citations in content. Context: avoid citation drift. Output: audit table with page, citations, and fix notes. Constraints: keep to five items. Format: plain-text.
56. Link prospecting list: You are an SEO data analyst. Task: generate a prospecting list for link building based on niche keywords and domain authority ranges. Context: supply outreach-ready targets. Output: list of domains with outreach angle and contact method. Constraints: verify relevance. Format: plain-text.
57. Content asset catalog: You are an SEO data analyst. Task: catalog content assets with assetID, topic, lastUpdated, traffic. Context: create a searchable inventory. Output: catalog entries with a one-line value proposition per asset. Constraints: include at least 12 items. Format: plain-text.
58. Internal link health: You are an SEO data analyst. Task: audit internal links for broken paths using Page, LinkPath, Status. Context: fix critical 404s. Output: list of broken links and fixes. Constraints: prioritize high-traffic pages. Format: plain-text.
59. Content performance by format: You are an SEO data analyst. Task: compare performance by content format (article, guide, infographic) using Type, Impressions, Clicks, Conversions. Context: identify best formats. Output: table with format and KPIs plus a 1-line conclusion. Constraints: limit to four formats. Format: plain-text.
60. Ecommerce SEO quick wins: You are an SEO data analyst. Task: identify quick wins for ecommerce pages using product pages, category pages, and blog posts. Context: prioritize high-ROI tasks. Output: list of five actions with expected impact. Constraints: actionable and realistic. Format: plain-text.
61. Content calendar prompts: You are an SEO data analyst. Task: generate a prompts-only calendar for content teams focusing on Excel-driven analysis tasks. Context: align with quarterly goals. Output: 6 prompts with due dates and owners. Constraints: avoid overlaps. Format: plain-text.
62. Low-competition keywords: You are an SEO data analyst. Task: identify low competition keywords with high potential using KD and Volume. Context: new content ideas. Output: list of five keywords and suggested angles. Constraints: keep competitive score realistic. Format: plain-text.
63. Rank tracking schedule: You are an SEO data analyst. Task: create a rank-tracking schedule from data with Date, Query, Position. Context: track changes over time. Output: schedule with update cadence and responsible person. Constraints: default weekly unless stated. Format: plain-text.
64. ROI heatmap: You are an SEO data analyst. Task: produce a heatmap-like textual representation of ROI by campaign and month. Context: quick visual cues for leadership. Output: table with ROI color-coded via text labels. Constraints: avoid actual colors, use labels like High, Medium, Low. Format: plain-text.
65. SERP position trends: You are an SEO data analyst. Task: chart SERP positions over time for a keyword set using Date, Position. Context: identify volatility. Output: trend summary and bullet highlights. Constraints: include at least 6 time points. Format: plain-text.
66. Search intent scoring: You are an SEO data analyst. Task: assign intent scores to a keyword list using columns Keyword, Intent, Score. Context: guide content creation. Output: list of keywords with scores and recommended next actions. Constraints: scores 0-100. Format: plain-text.
67. Content curation prompts: You are an SEO data analyst. Task: generate prompts to curate external SEO content wrapped around internal assets with recommended sharing angles. Context: amplify reach. Output: five prompts with target audiences and formats. Constraints: avoid plagiarism risk. Format: plain-text.
68. Topic clustering map: You are an SEO data analyst. Task: produce a topic clustering map from related keywords into 5 clusters. Context: build silo strategy. Output: cluster names with representative keywords. Constraints: max 5 clusters. Format: plain-text.
69. Competition moat plan: You are an SEO data analyst. Task: design a plan to build competitive moats around core topics using content, links, and technicals. Context: sustainable advantage. Output: 4 strategic moves with metrics. Constraints: concise. Format: plain-text.
70. GSC data summary: You are an SEO data analyst. Task: summarize Google Search Console metrics for selected pages. Context: extract actionable insights. Output: page-level summary with impressions, clicks, CTR, position. Constraints: limit to 10 pages. Format: plain-text.
71. Identifying low-hanging pages: You are an SEO data analyst. Task: identify pages with high potential but currently underperforming using fields like Impressions, Clicks, Conversions. Context: quick wins. Output: list of pages with recommended optimizations. Constraints: five items minimum. Format: plain-text.
72. Content topic map: You are an SEO data analyst. Task: map content topics to audience personas using Persona, Topic, Needs. Context: tailor content. Output: table with topic, persona, needs, recommended format. Constraints: five rows min. Format: plain-text.
73. Blog to page migration plan: You are an SEO data analyst. Task: plan a safe blog-to-page migration with a list of URLs and redirects. Context: preserve equity. Output: migration steps and validation checklist. Constraints: do not break internal links. Format: plain-text.
74. Keyword cannibalization fix: You are an SEO data analyst. Task: detect cannibalization among keywords mapping to pages. Context: propose consolidation strategy. Output: pairs of cannibalizing keywords with recommended target pages. Constraints: provide at least three pairs. Format: plain-text.
75. Image performance report: You are an SEO data analyst. Task: analyze image optimization impact on page performance using Impressions, Clicks, and LCP. Context: propose image optimizations. Output: per-page recommendations and expected impact. Constraints: keep to five items. Format: plain-text.
76. Conversion rate lift scenarios: You are an SEO data analyst. Task: create scenarios for improving conversion rate from a given funnel. Context: plausible ranges for uplift. Output: scenario name, actions, expected uplift, risk notes. Constraints: 3 scenarios minimum. Format: plain-text.
77. Audit trail generator: You are an SEO data analyst. Task: generate an audit trail for SEO changes with date, page, change, outcome. Context: accountability. Output: a simple table showing change history and results. Constraints: five or more entries. Format: plain-text.
78. Content performance dashboard: You are an SEO data analyst. Task: describe a dashboard layout for Excel to visualize key SEO metrics. Context: stakeholder-friendly. Output: list of dashboard components and data sources. Constraints: concise. Format: plain-text.
79. Competitor snippet analysis: You are an SEO data analyst. Task: analyze competitor snippets for improvement ideas using sample SERP data. Context: extract patterns. Output: list of 6 patterns with practical implementation tips. Constraints: no sensitive data. Format: plain-text.
80. Local ranking map: You are an SEO data analyst. Task: map local rankings by city using a dataset with City, Rank, Volume. Context: identify top markets. Output: map-like list with city and rank and suggested actions. Constraints: five cities min. Format: plain-text.
81. Content performance by device: You are an SEO data analyst. Task: compare content performance by device type using Device, Sessions, Conversions. Context: inform responsive design decisions. Output: table with device and KPIs plus a one-line takeaway. Constraints: ensure data quality. Format: plain-text.
82. Keyword trend alerts: You are an SEO data analyst. Task: set up alert prompts for keyword trends via Excel data changes. Context: proactive optimization. Output: five alert prompts with thresholds and owners. Constraints: actionable. Format: plain-text.
83. Content localization quality: You are an SEO data analyst. Task: assess localization quality for translated pages using Language, TranslationQuality, Traffic. Context: maintain user experience. Output: score and three improvement steps per page. Constraints: 5 items min. Format: plain-text.
84. Website health sprint: You are an SEO data analyst. Task: plan a two-week sprint to improve site health metrics. Context: actionable steps. Output: sprint backlog with tasks, owners, and success criteria. Constraints: prioritize high-impact items. Format: plain-text.
85. Product taxonomy mapping: You are an SEO data analyst. Task: map product taxonomy to SEO-friendly URLs and keywords. Context: improve navigation and rankings. Output: mapping table and quick wins list. Constraints: five items min. Format: plain-text.
86. Outreach-ready targets: You are an SEO data analyst. Task: prepare outreach-ready targets with relevance metrics and email angles. Context: streamline link-building. Output: list of domains with outreach script suggestions. Constraints: verify relevance. Format: plain-text.
87. Content aging risk: You are an SEO data analyst. Task: assess risk of aging content on key topics using freshness and engagement metrics. Context: decide aging strategy. Output: prioritized list of pages and actions. Constraints: five items min. Format: plain-text.
88. SERP feature optimizer: You are an SEO data analyst. Task: propose optimizations to capture SERP features for target queries. Context: include titles, structured data, and snippets. Output: 4 concrete optimizations with expected impact notes. Constraints: none. Format: plain-text.
89. Content reuse plan: You are an SEO data analyst. Task: plan how to reuse existing assets into new formats (video, infographic) using assets, topics, and audience. Context: maximize value. Output: 4 reuse ideas with steps. Constraints: feasible. Format: plain-text.
90. Keyword PR boost: You are an SEO data analyst. Task: identify PR-worthy keyword-driven angles from data with Volume and Potential. Context: generate press-ready ideas. Output: list of five ideas with angle and target outlet. Constraints: realistic. Format: plain-text.
91. Index coverage explorer: You are an SEO data analyst. Task: explore index coverage issues by URL, Status, and IndexingDate. Context: optimize indexation. Output: issues and fixes per category. Constraints: four categories min. Format: plain-text.
92. Content effectiveness ratio: You are an SEO data analyst. Task: compute a content effectiveness ratio from traffic, engagement, and conversions. Context: compare assets. Output: table with ratio and interpretation line. Constraints: provide at least six items. Format: plain-text.
93. Voice search prompts: You are an SEO data analyst. Task: design prompts to analyze voice-search related queries from keyboard data. Context: adapt content for voice. Output: five prompts with intended outputs. Constraints: practical. Format: plain-text.
94. Content performance by cohort: You are an SEO data analyst. Task: compare content performance by publication cohort. Context: identify evergreen performers. Output: table by cohort with KPIs and action. Constraints: five cohorts min. Format: plain-text.
95. Product page SEO copy: You are an SEO data analyst. Task: generate optimized product page copy ideas based on keyword data and benefits. Context: convert more visitors. Output: five headline and meta description options per product. Constraints: avoid duplication. Format: plain-text.
96. Crawl budget optimizer: You are an SEO data analyst. Task: propose crawl budget optimization actions using crawl rate, pages crawled, and errors. Context: improve crawl efficiency. Output: prioritized action list with impact. Constraints: five items max. Format: plain-text.
97. External link quality check: You are an SEO data analyst. Task: assess external links quality by domain authority and trust signals. Context: identify risky links. Output: risk list with recommended disavow or outreach actions. Constraints: be precise. Format: plain-text.
98. Customer journey mapping: You are an SEO data analyst. Task: map customer journey segments to SEO touchpoints using Segment, Touchpoint, Conversion. Context: optimize content path. Output: journey map with recommended pages. Constraints: five segments min. Format: plain-text.
99. Content localization checklist: You are an SEO data analyst. Task: produce a localization checklist for new markets including language, currency, date formats, and legal pages. Context: scale globally. Output: 15 checklist items with owners. Constraints: none. Format: plain-text.
100. Final QA pass: You are an SEO data analyst. Task: perform a final QA pass on an Excel SEO report, checking data integrity, consistency, and formatting. Context: deliver client-ready deliverable. Output: QA notes and sign-off statement. Constraints: concise. Format: plain-text.

Best Practices

• Use a consistent data schema across prompts to simplify reuse.
• Store prompts with a short description and the dataset context for future use.
• Limit outputs to human-readable formats first, then export to dashboards or sheets.
• Incorporate validation steps in prompts to catch out-of-range values or duplicates.
• Regularly refresh data inputs to keep prompts relevant to current SEO goals.

Common Mistakes to Avoid

• Using vague goals or missing context behind the data leading to generic results.
• Overloading prompts with too many tasks, making outputs hard to parse.
• Failing to specify required output formats, causing inconsistent results.
• Not validating Claude outputs against raw data, which can hide data errors.
• Ignoring data quality issues such as missing values affecting results.

FAQ

What makes these Claude prompts effective for Excel SEO data analysis?

They are role-based, specify the task, provide dataset context, demand concrete outputs, and enforce constraints to keep results actionable.

How should I adapt prompts to my own Excel dataset?

Replace placeholders with your column names, dataset name, and goals. Add or remove constraints to match your reporting standards.

Can these prompts be used for client reports directly?

Yes, many prompts produce plain-text tables and concise insights suitable for client-facing PDFs or dashboards.

What if my dataset has more than the typical columns?

Add or adjust columns in the prompt context, and ask Claude to handle dynamic columns or provide a fallback when a column is missing.

How do I ensure accuracy in Claude outputs?

Cross-check Claude outputs with the raw Excel data and run spot checks on a sample of results.

How often should I run these prompts in a workflow?

Use them after key data refreshes—monthly for ongoing campaigns and weekly for time-sensitive reporting.