3 of 4
Add the heatmap, funnel and mood
Three more charts complete the picture: when customers write, where leads drop off, and whether mood is getting better.
Ask for them one at a time. It's easier to check each chart before the next one goes in.
Why it matters
Together the four charts answer the questions a manager asks every month: what customers want, when to staff the inbox, where deals are lost and whether things are improving. Each one points to a decision, not just a number.
- 1
Add the heatmap.
PromptFrom messages.jsonl, add a heatmap of customer messages by weekday and hour. Darker means busier. Show the count on hover and write the busiest window under the chart.A heatmap of customer messages by weekday and hour - 2
Add the funnel.
PromptAdd a funnel from the stage column: leads, qualified, demo, proposal and won. Show the count at each step and the percentage that moves on.A lead funnel built from the stage column - 3
Add the mood trend.
PromptAdd a daily line of average sentiment on a 0 to 100 scale. Mark the day we shipped the invoice fix and label today's value.Daily customer mood with a key moment marked - 4
Put it all on one page.
PromptPut all four charts on one page with four headline numbers at the top: messages analysed, active chats, median first reply and pipeline found in chats. Animate the charts as the page loads.Before you share it, ask: “Do the totals in each chart match chats.csv?” The assistant recounts from the file and fixes any chart that's off.