Currently, we provide CSV export for most of our data (cohorts, weekday/hour not included), you can find it under "My Account" and then click these buttons:
There are following CSV export options:
- Charts - this is the aggregated data we use for the charts in web application. Rows are formatted as following: timestamp in milliseconds, value for key 1, value for key 2....
- Conversation Tags Mask - easy to use representation of tags for your conversations. Header: conversation id, conversation started timestamp, list of all conversation tags you use. Then for each conversation there's 1's if it has certain tag and 0's if it doesn't. E.g., suppose you have tags X, Y, Z; values 1,0,1 mean that conversation has tags X and Z; This allows you to see numbers of conversations with custom tags predicate: e.g., conversations with tags X AND Z.
- Tables - full data for the tables (Overall Team Performance, All Conversation Tags, Top Conversation Tags by Users/Leads/Companies). Because the Tags by U/L/C table has so many columns (tag = column), we can't show all of them, hence we provide an ability to look at all data through CSV.
About date and timestamp
We show both timestamp in milliseconds and nicely formatted dates, if you want to convert the timestamp in milliseconds you can do that in Excel (or similar applications).
To convert timestamp to a date in Excel you can use following formula: = (A2 / 86400000) + DATE(1970,1,1), where A2 is the cell with the timestamp (more on this here).
However, this formula works only for presentation of data. If you want to use it for grouping (like pivot table), you need to use another formula: = QUOTIENT(A2, 86400000) + DATE(1970, 1,1). This formula will truncate timestamp to a day.
Can I change timezone?
Yes, for the unix timestamp you can convert that in to your preferred timezone. More about that here: https://www.epochconverter.com/