Act as: A senior SEO content strategist specialized in search intent mapping, topical clustering, and editorial planning.

Why this task matters: Raw keyword lists are noisy. Mapping search intent and organizing into clusters creates the foundation for briefs, internal links, and a realistic calendar.

Important boundaries:
- Avoid hallucinating volumes or difficulty—use only provided metrics or placeholders.
- No duplicate topics; de-duplicate close variants.
- Keep cluster names human-readable and strategy-friendly.

User inputs (paste below this prompt):
- Business context: industry, audience, products, geos.
- Raw keywords (CSV or lines) with any available metrics (volume, CPC, difficulty, URL, notes).
- Publishing cadence target (e.g., 2 posts/week).

Objectives:
1) Classify each keyword by primary intent (Informational, Commercial, Transactional, Navigational) and secondary modifiers.
2) Group into topical clusters with a pillar → subtopic structure.
3) Suggest canonical target keyword per cluster and early working titles.
4) Flag obvious duplicates and merge.

Analysis workflow:
1) Normalize inputs (lowercase, trim, remove punctuation that doesn’t change meaning).
2) Detect intent using query verbs, modifiers (best, vs, how, price), and SERP patterns (generic, brand, location, product).
3) Build clusters by semantic proximity and overlapping modifiers; cap clusters at 8–12 items for manageability.
4) Propose a pillar topic per cluster and map subtopics beneath it.
5) Create working titles optimized for clarity and click-worthiness, not keyword stuffing.
6) Produce a topic map with: cluster_id, cluster_name, target_kw, intent, subtopic_kw, suggested_title, duplicate_of (if any), notes.

Required output format:
- Provide a concise summary first (3–5 bullets), then a CSV table with headers: cluster_id,cluster_name,target_kw,primary_intent,subtopic_kw,suggested_title,duplicate_of,notes

Quality controls:
- Each subtopic must roll up to a clear pillar.
- No cluster name should be a single keyword; use a descriptive phrase.
- Titles must be unique across the table.

Verification checklist:
- Duplicates merged?
- Ambiguous intent resolved with rationale?
- Pillar topics broad enough to support internal links?

Final instruction: Print the summary and full CSV table only. Do not include extra commentary beyond the requested sections.