The Export page downloads a messenger's conversations, and its tickets when ticketing is on, as CSV files you can open in Excel, Google Sheets or a BI tool. Open a messenger and click Export in its sidebar, just below Reports.
Anyone who can see Reports can use Export: the Owner, Admin, User and Reports roles.
Each file has its own card with its own period. Choose Last 7 days, Last 30 days (the default), Last 90 days or Last 12 months, then click Download CSV.
One row for every conversation started in the period with a question or a reply. Conversations opened without either, such as a proactive message that was opened and closed, are left out. If you've chosen to leave out your team's testing in Reports, it's left out here too.
| Columns | What they contain |
|---|---|
conversation_id, started_utc, status | Which conversation, when it started and whether it's open, snoozed or closed |
handled_by, assignee | Who had it (the AI, waiting, or a person) and the teammate it was assigned to |
outcome | How it ended: ai_confirmed, ai_assumed, human_handled, team_started, missed, waiting or other |
ai_answers, ai_no_answers | How many times the AI answered, and how many questions it couldn't answer |
handed_off_utc, handoff_reason | When and why it was handed to your team |
first_human_reply_utc, first_response_seconds | The first reply from a person and how long after the handoff it came |
closed_utc, time_to_close_seconds | When it closed and how long it was open |
rating, rating_comment | The customer's rating (1 to 5) and comment |
start_page, proactive_message | The page it started on and the proactive message it replied to |
country, channel, device, visitor_type | Where the customer was, how they reached you (website, email, WhatsApp), their device, and whether they were verified, identified or anonymous |
visitor_messages, team_replies | How many messages the customer sent and how many replies your team sent |
follow_up_rule, follow_up_details | The question rule that collected follow-up details, and the details as "Label: value; Label: value" |
The Tickets card appears when ticketing is on. It downloads one row for every ticket opened in the period, open ones first and the longest open first, with the columns number, subject, customer, account, status, priority, type, assignee, opened, closed, open_hours, overdue and rating.
To export just the tickets in a view, with its filters, use Export on the ticket table in the inbox. See Working with Tickets.
The files are UTF-8 CSV, which Excel opens directly. A value that starts with a character a spreadsheet would read as a formula (such as =, +, - or @) begins with an apostrophe, so text a customer typed can't run as a formula. How long conversations are kept depends on your data retention setting, so older periods only include what's still stored.