For the Sari Coffee online store, keywords were extracted from Search Console data and about 700 Google autocomplete suggestions, then grouped and prioritized to decide which phrases each store page and article should target.
Method
Real Search Console queries were combined with Google’s autocomplete suggestions and clustered by search intent (transactional, informational, comparison) and topic. Since Sari Coffee is an online-only store, local phrases were set aside to focus on nationwide searches.
Deliverables
A seven-sheet Excel workbook and an interactive report with keyword clusters, a target page for each cluster, content opportunities and an implementation priority for each part.
Features
- Analysis of real Search Console queries
- About 700 Google autocomplete suggestions collected
- Clustering by topic and search intent
- Keywords mapped to product and category pages
- Article topic ideas and a content map
- Prioritization by opportunity and difficulty