How to export your results

For your filtered results, you can click "Export to CSV" to reveal your exporting options. 

You have a choice of a detailed export – "Export metadata and all analytics" – or a lighter version – "Export current view". 

All exports are downloaded as a compressed file that contains the requested export in CSV format. If the results exported come from different datasets, each one will be a separate file.

How do the different export types compare?

I have exported a subset of my data that contains data related to "towel". Here’s a sample of how this analysis has been translated into different export types. 

Since I have the filter on, only the results that include the Topic "towel" will be exported. If you'd like to export all the results, ensure there are no active filters of any kind.

Export metadata and all analytics

This export type contains all the data uploaded in the first part, followed by the detected analytics. This type of export is ideal for reconstructing the full analysis since it's a flat model of the analytics results displayed in the application. The unique IDs map out the links between the data. 

Here's an overview of the exported analytics. For the purposes of showing the CSV screenshots I used Excel. 

The exported file begins with the original data uploaded, followed by the columns made by the system containing the analysis.

statement_id - Assigns a unique identification number (per customer organization) whenever the same statements appears. A statement is formed of the same Topic (singular/plural) and Indicator. 

statement_expression - Reproduces the section from the original record in which the result appears. 

language - The detected language for this record is indicated through the language two-letter ISO code

statement_topic - Shows the identified Topic in its exact form, as mentioned by the customer.

statement_indicator - Shows the identified Indicator in its exact form, as mentioned by the customer.

nb_indicated_records - Displays number of records in which this statement and all its variations (Issue) shows up.

polarity - Identifies the sentiment or opinion expressed by the customer

(Praise, Problem, Suggestion or Question).

group_repr_topic - Is the Topic representative for that group, meaning the group is displayed using this term. Read more about groups here.  

group_repr_indicator - Is the Indicator representative for that group, meaning the group is displayed using this term. Read more about groups here.  

group_id - Assigns a unique identification number (per customer organization) whenever the same statement group (Issue) appears.  

Export Current View

Selecting "Export Current View" gives a very broad overview, ideal for simple graphs and charts. This type of export adapts depending on the way the results are displayed: as Issues, Topics or Indicators.

Export Current View - as Issues

group_id - Assigns a unique identification number (per customer organization) whenever the same statement group (Issue) appears. 

group_repr_expression - Reproduces the section from the original record in which the Issue appears. 

praises_count - A count of all the instances where this Issue appears as a Praise.

problems_count - A count of all the instances where this Issue appears as a Problem.

questions_count - A count of all the instances where this Issue appears as a Question. 

suggestions_count - A count of all the instances where this Issue appears as a Suggestion.

trend - Reports if there's been a rising or falling trend associated with this Issue.

Export Current View - as Topics

topic_label - Shows the Topic labels for the results selected. Since I originally applied a filter to see only results containing the Topic “towel”, we only have one Topic. 

praises_count - A count of all the instances where “towel” appears as a Topic in a Praise.

problems_count - A count of all the instances where "towel" appears as a Topic in a Problem.

questions_count - A count of all the instances where "towel" appears as a Topic in a Question. 

suggestions_count - A count of all the instances where "towel" appears as a Topic in 

a Suggestion.

current_count - A count of all the instances where the Indicator appears. 

trend - Reports if there’s been a rising or falling frequency trend with the Topic “towel” and the associated Indicator.

Export Current View - as Indicators

indicator_label -  The Indicator associated with the Topic "towel" is indicated in this column.

praises_count - A count of all the instances where the Indicator appears as a Praise.

problems_count - A count of all the instances where the Indicator appears as a Problem.

questions_count - A count of all the instances where the Indicator appears as a Question. 

suggestions_count - A count of all the instances where the Indicator appears as a Suggestion.

current_count - A count of all the instances where the Indicator appears. 

trend - Reports if there’s been a rising or falling frequency trend with the Topic "towel" and the associated Indicator.

Using Exports for Visualizations

Having your results in CSV can be very useful for making visualizations. While advanced users might use Tableau to make interactive visualizations, even less sophisticated users can have great results using Google Studio, Excel or a simple word cloud tool.   

Here are some example graphs made with Keatext exported data and Tableau by a professional designer. 

Did this answer your question?