Full interactive version (D3 graph, entity tables, cluster drill-downs): open the diagnostic →. Key findings, summarized:
229 URLs pulled from the Yoast sitemap. 119 English indexable pages; the rest are Thai /th/ mirrors plus product/shop URLs. All existing-URL checks in this report run against the English set.
Central entity: Wine & Spirit Education. Central intent: “get professional wine, sake or sommelier education / certification in Bangkok”. Every cluster and CTA is organized to serve that intent with course products as the conversion layer.
wine 114 sake 53 horeca 33 corporate 8 retail 13 comparison 6 history 6 — six primary clusters plus comparison/history support pages. Pillars: Wine 101, Wine & Thai Food pairing, Types of Sake, How Sake Is Made, Sake Course Bangkok, Corporate Wine Tasting.
thin: 6 exists: 32 gap: 188 cannibal: 7
The separate gap matrix listed 313 missing topics mined from SERP demand. For this merged report it was deduplicated to 288 (see Appendix for the removal log). Gap topics by entity: Wine Courses (60) · Wine Tours (43) · Sake Education (97) · Sake Service (19) · Advanced Tasting (22) · Sake Courses (47).
7 rows flagged cannibal in the map (competing URLs targeting the same topic, e.g. Wine & Thai Food pillar vs. sake-section variant). They are marked cannibal in the master map and listed in the URL audit.
→ Open the Merged Master Map (233 mapped topics + 288 gap topics, live-URL linked)
→ Open the Appendix (dedupe log, URL audit, intra-matrix duplicate flags)