Turn your Semrush, Ahrefs, or GSC export into a campaign strategy
Import a CSV or XLSX keyword export from any SEO platform. beserp auto-maps the columns, clusters semantically related queries, surfaces modifier patterns, and generates page-level recommendations — no spreadsheet cleanup needed.
How it works
1. Upload your keyword export (CSV/XLSX).
2. Confirm the auto-detected column mapping.
3. Get clusters, modifiers, and strategy recommendations.
Analyze datasets now. Select a project only when you want to save and hand off into briefs.
Keyword Intelligence is available in free mode. Project selection only unlocks saved datasets, history, and Content Brief handoff.
What happens next
Use this workflow to move from diagnosis into the next reusable step instead of treating the output as a one-off result.
Import a keyword dataset
Upload the file, confirm the schema, and move into strategy analysis.
Free mode analyzes the dataset without saving it.
Saved datasets
Project mode keeps normalized datasets and strategy runs so the team can revisit and operationalize them later.
No saved keyword datasets yet
Import a dataset, confirm the mapping, and run the analysis above to create the first reusable saved workspace.
About this tool
Keyword Intelligence
Turn a flat keyword export into a clustered content plan with intent, page-type, and priority — in under a minute, free.
Most SEO teams already export keyword data from Semrush, Ahrefs, Moz, or Google Keyword Planner — and then stare at it. Keyword Intelligence takes that CSV, groups the keywords into semantic clusters, classifies each cluster by search intent, suggests the right page type for each topic, and ranks the clusters by priority score. The output is a content plan you can hand to a writer or pipe into a content brief, not another spreadsheet.
How it works
- 1
Upload any keyword export
CSV or XLSX from Semrush, Ahrefs, Moz, Google Keyword Planner, Google Search Console, or a manual list. Column mapping is automatic — keyword, volume, difficulty, CPC, intent.
- 2
Semantic clustering
Keywords are grouped by topical similarity using embeddings, not just lexical overlap. "best protein powder" and "top whey supplements" land in the same cluster even with no shared words.
- 3
Intent classification
Each cluster gets a dominant intent label — informational, commercial, transactional, navigational, or mixed — based on the SERP-style language signals across its keywords.
- 4
Page type + priority recommendations
Pillar, listicle, comparison, glossary, landing page, or product page — paired with a priority score that combines volume, intent strength, and difficulty.
- 5
Hand off to execution
Export the cluster plan as a content calendar (CSV or .ics for Google/Apple/Outlook), or send a recommendation directly into a paid project as a content brief.
Who uses this
- In-house SEO teams turning a quarterly keyword research dump into an editorial calendar.
- Freelance SEOs running a discovery audit for a new client.
- Content marketers who want intent-grouped briefs without re-running keyword tools.
- Agencies deduplicating cannibalisation risk across overlapping keyword sets.
- Founders sanity-checking which topics deserve a pillar page versus a blog post.
- Anyone building topical authority who wants the cluster boundaries spelled out.
Frequently asked questions
Is Keyword Intelligence really free, or is it a trial?
Free, no signup, no credit card. Upload your CSV, get clusters and recommendations back. Optional paid features (saving the dataset to a project, recurring refreshes, content-brief handoff) live behind the paid workspace, but the core clustering and strategy output is unmetered.
What keyword tools does it accept exports from?
Semrush, Ahrefs, Moz, Google Keyword Planner, Google Search Console (Performance export), Surfer, Lowfruits, KeywordsPeopleUse, and any plain CSV with a "keyword" column. The importer auto-detects volume, difficulty, CPC, and intent columns when present, and works with rows-only data when not.
How is this different from Ahrefs or Semrush keyword grouping?
Ahrefs and Semrush group lexically — keywords sharing words land together. Keyword Intelligence groups by meaning, so cross-vocabulary clusters (e.g. "running shoes for flat feet" + "best trainers for fallen arches") sit in the same bucket. It also adds intent classification, page-type recommendations, and priority scoring on top of the clusters, which most keyword tools do not.
Can it cluster a 10,000-keyword export?
Yes. The clustering pipeline batches large datasets and returns the cluster summary plus per-keyword assignments. For very large lists, the recommendation table focuses on the top-priority clusters by volume and gap; the underlying assignments are still available for download.
How does it decide search intent?
For each cluster, the dominant intent is inferred from the language patterns of the keywords themselves (e.g. "best", "vs", "review" → commercial; "buy", "price" → transactional; "how", "what is" → informational) and the SERP-style signals where available. Mixed-intent clusters are flagged so you can split them.
What is a "priority score"?
A 0–100 score that blends total search volume, dominant intent strength (transactional > commercial > informational, weighted by your buyer-journey context), and inverse difficulty. Higher scores are clusters where the upside is high and the route to ranking is clearest.
Will my keyword data be saved or shared?
No. The free tool is stateless — your CSV is processed in memory to produce the cluster output and is not persisted. Saving runs to a project (so you can compare across time, hand off to a content brief, etc.) is opt-in and lives behind the paid workspace.
Can I export the clusters to a content calendar?
Yes. Once recommendations are produced, the "Build content calendar" toggle on the recommendations panel lets you export the plan as a CSV (Notion / ClickUp / Asana / Sheets) or as an .ics calendar (Google Calendar / Apple Calendar / Outlook), with publish dates spaced across your chosen cadence — twice weekly, weekly, biweekly, or monthly.
Related
Competitor Benchmarking →
Compare your domain against any competitor — authority gaps, keyword overlaps, content themes.
Competitor Keywords →
Pull the top 100 keywords any competitor ranks for, by position bucket and intent.
Site Audit →
Free crawl-based audit covering on-page, technical, and content signals.
Learn: How to brief writers for non-commodity content →
Editorial guide on building content that competitors and AI search cannot easily replace.