Table 2: topic_analysis.analytics_data

The data in this table duplicate from public.generated_analytics_data, which facilitate developers to find required data from the same database schema.

Field	Type	Description

Field	Type	Description
filename	String	Filename indicates a unique identification of call
agentid	String	The ID that can be use to retrieve agent’s information
agentgender	String	An agent gender
userid	String	The ID of a user or client
clientgender	String	A client gender
duration	Decimal	Call duration stored in minutes
datetime	Date/Time	The date and time the data have been recorded
wordcount	Integer	Number of words in the transciption, including agent and client
url	String	Location of the file in Wordbench
company	String	Name of the company who owns a record data
organisation	String	Group of a company that helps to scope record data
folder	String	The Folder field that store data in Wordbench.
insert_time	Date/Time	The date and time that data has been written into this table