2 of 4
Build the topic map
The bubble map is the headline chart. Each bubble is a topic: further right means more chats mention it, higher up means happier customers, and a bigger bubble means more chats.
Ask for it as an interactive page, so hovering a bubble shows its numbers.
Why it matters
One picture shows what to fix and what to promote. A big bubble low and to the right is a frequent pain point, the first thing to solve. A big bubble high up is something customers love, and a good message for marketing.
- 1
Ask for the bubble map.
PromptUsing chats.csv, build an interactive bubble chart: x = share of chats for each topic, y = average sentiment, bubble size = number of chats, colour by sales, support, product request or billing. Label every bubble and show the numbers on hover.A topic bubble map: share of chats against customer mood, sized by number of chats - 2
Mark the corners that matter.
PromptLabel the lower right "frequent and painful, fix first" and the upper right "frequent and loved". Make sure no labels overlap. - 3
Let people drill down.
PromptWhen I click a bubble, list its five most recent chats with the date, contact and a one-line summary.