You can access each of the following tools by hovering your mouse over the download icon in the bottom right-hand corner of the screen. Each of the tools will give you the option to download as a regular Excel file (.xlsx) or as a CSV file. The CSV versions will not allow for multiple sheets in one file or auto applied color scales.
Top Concept Match Counts: This output identifies the most important concepts in the data set or in a particular subset. You have the option to specify the number of top concepts that you would like. For each concept, the file contains columns for:
- Relevance Ranking: displays rank of how important or relevant to understanding a concept is in the dataset
- Exact Matches: how many times that specific concept appeared as is
- Conceptual Matches: how many times the most closely related concepts appeared
- Total Matches: the sum of the concept's exact and conceptual matches
- Percent of All Documents: in what percentage of the total number of documents in the project does the exact, conceptual, or total matches appear
A stacked bar chart is shown on the following sheet for each list of top concepts. Concepts are ranked by relevance to the data set from top to bottom and are depicted by their total match counts, with exact matches broken out in blue and conceptual matches in red.
Topic Match Counts: This output is just like the Top Concepts output but it calculates for the topics that you have already saved. Topics will appear in the file and in the charts in the same order that you have arranged the topics on your project page.
Topic Timelines: Click this option to download a file that contains the association between each of the topics you have created and time periods based on any dates provided in your data set. You are presented the option to view association scores for various intervals of time (hours, days, months, years) or on the individual document level. The data in this spreadsheet is what generates the topic timelines that display when you click Show Timelines in the bottom left-hand corner of the Concept Cloud panel.
Since the Show Timelines feature graphs the data in this file automatically for you, you may find that you rarely use the Download Topic Timelines tool. This tool is most useful if/when you want to create your own topic timeline graphs.
Topic-Topic Associations: This output displays the association scores between all the topics you have created in a project to one another. The Excel version of this download will be a file with three sheets.
In the first sheet, the full set of associations is shown for every topic in one table. Topics are displayed in the first column and the first row of the sheet. Color scales are applied to help you more quickly identify insightful and relevant connections between the different topics you have created.
On the second sheet, a horizontal bar chart is provided for each topic. Each chart displays the association between the topic in the chart title and all other topics.
On the third sheet, a diced and pre-sorted version of the full topic-topic association table is given. Every two columns represents one topic and a ranked order of the other topics based on their association score. This view provides a simpler way to explore single terms.
See articles on association scores and interpreting/analyzing topic-topic associations for additional information.
Topic-Subset Associations: Click this option to download a file that displays the association scores between all the topics and subsets within a project.
The top row of the spreadsheet includes the column headers Subset, Document Count, and all of the topics that have been created within the project. The first column of the spreadsheet contains a list of all the subsets within your project. The second column shows the number of documents within each corresponding subset. The third and subsequent columns display the association scores between each subset and the topic in that column. This tool enables you to identify possible trends or differences across the various subsets in your data set.