TimelinesAI
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. 1

    Ask for the bubble map.

    Prompt
    Using 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. 2

    Mark the corners that matter.

    Prompt
    Label the lower right "frequent and painful, fix first" and the upper right "frequent and loved". Make sure no labels overlap.
  3. 3

    Let people drill down.

    Prompt
    When I click a bubble, list its five most recent chats with the date, contact and a one-line summary.