Export CSAT Dynamics and Interaction Intensity Dynamics values into separate columns
Update report export for CSAT Dynamics and Interaction Intensity Dynamics.
Currently, each summary is exported into a single Excel cell as a structured JSON-like value containing multiple individual metrics.
For analytical purposes, each value inside these summaries should be exported into its own separate column.
Current Behavior
CSAT Dynamics is exported as one column containing multiple values, for example:
enter_CSATexit_CSATpeak_CSATother available CSAT Dynamics values
Interaction Intensity Dynamics is also exported as one column containing multiple values, for example:
enter_intensityexit_intensitypeak_intensityintensity_indicators
This makes further calculations and correlation analysis in Excel significantly more difficult.
Expected Behavior
Each individual metric contained in CSAT Dynamics and Interaction Intensity Dynamics should be exported as a separate report column.
Example structure:
CSAT Dynamics
CSAT Dynamics - Enter CSATCSAT Dynamics - Exit CSATCSAT Dynamics - Peak CSATseparate columns for other available CSAT Dynamics fields
Interaction Intensity Dynamics
Interaction Intensity Dynamics - Enter IntensityInteraction Intensity Dynamics - Exit IntensityInteraction Intensity Dynamics - Peak IntensityInteraction Intensity Dynamics - Intensity Indicators
The values should no longer require parsing a JSON structure from a single Excel cell.
Expected Result
Instead of:
CSAT Dynamics | Interaction Intensity Dynamics
containing structured data inside individual cells, the export should provide flat analytical columns that can be immediately used for:
formulas;
correlation analysis;
filtering;
pivot tables;
external reporting.
Acceptance Criteria
Each CSAT Dynamics metric is exported into a separate column.
Each Interaction Intensity Dynamics metric is exported into a separate column.
Add a dedicated column to the report export - only if data present
Values correspond to the correct conversation.
Numeric values are exported as numeric values where applicable.
Text values, such as intensity indicators, are exported into dedicated text columns.
Missing values follow the existing export behavior for empty data.
Exported fields can be used directly in Excel calculations without additional JSON parsing.
Existing report filters and selected date ranges continue to apply to the exported data.
Log in to comment and vote
Comments1
John
Sep 14
Need to clarify, why it didnt move to Done, once linked Issue in Github marked as Done/Merged