Windsor brings all your Freshcaller data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Freshcaller Field Reference

Fields

ID	Type	Name	Description	Report
call_metrics__answering_speed	NUMERIC	call_metrics.answering_speed	call_metrics.answering_speed	call_metrics
call_metrics__answering_speed_unit	TEXT	call_metrics.answering_speed_unit	call_metrics.answering_speed_unit	call_metrics
call_metrics__bill_duration	NUMERIC	call_metrics.bill_duration	call_metrics.bill_duration	call_metrics
call_metrics__bill_duration_unit	TEXT	call_metrics.bill_duration_unit	call_metrics.bill_duration_unit	call_metrics
call_metrics__call_id	NUMERIC	call_metrics.call_id	call_metrics.call_id	call_metrics
call_metrics__call_work_time	NUMERIC	call_metrics.call_work_time	call_metrics.call_work_time	call_metrics
call_metrics__call_work_time_unit	TEXT	call_metrics.call_work_time_unit	call_metrics.call_work_time_unit	call_metrics
call_metrics__cost	NUMERIC	call_metrics.cost	call_metrics.cost	call_metrics
call_metrics__cost_unit	TEXT	call_metrics.cost_unit	call_metrics.cost_unit	call_metrics
call_metrics__created_time	TEXT	call_metrics.created_time	call_metrics.created_time	call_metrics
call_metrics__csat	OBJECT	call_metrics.csat	call_metrics.csat	call_metrics
call_metrics__hold_duration	NUMERIC	call_metrics.hold_duration	call_metrics.hold_duration	call_metrics
call_metrics__hold_duration_unit	TEXT	call_metrics.hold_duration_unit	call_metrics.hold_duration_unit	call_metrics
call_metrics__id	NUMERIC	call_metrics.id	call_metrics.id	call_metrics
call_metrics__ivr_time	NUMERIC	call_metrics.ivr_time	call_metrics.ivr_time	call_metrics
call_metrics__ivr_time_unit	TEXT	call_metrics.ivr_time_unit	call_metrics.ivr_time_unit	call_metrics
call_metrics__recording_duration	NUMERIC	call_metrics.recording_duration	call_metrics.recording_duration	call_metrics
call_metrics__recording_duration_unit	TEXT	call_metrics.recording_duration_unit	call_metrics.recording_duration_unit	call_metrics
call_metrics__tags	OBJECT	call_metrics.tags	call_metrics.tags	call_metrics
call_metrics__talk_time	NUMERIC	call_metrics.talk_time	call_metrics.talk_time	call_metrics
call_metrics__talk_time_unit	TEXT	call_metrics.talk_time_unit	call_metrics.talk_time_unit	call_metrics
call_metrics__total_ringing_time	NUMERIC	call_metrics.total_ringing_time	call_metrics.total_ringing_time	call_metrics
call_metrics__total_ringing_time_unit	TEXT	call_metrics.total_ringing_time_unit	call_metrics.total_ringing_time_unit	call_metrics
call_metrics__updated_time	TEXT	call_metrics.updated_time	call_metrics.updated_time	call_metrics
calls__assigned_agent_id	NUMERIC	calls.assigned_agent_id	calls.assigned_agent_id	calls
calls__assigned_agent_name	TEXT	calls.assigned_agent_name	calls.assigned_agent_name	calls
calls__assigned_call_queue_id	NUMERIC	calls.assigned_call_queue_id	calls.assigned_call_queue_id	calls
calls__assigned_call_queue_name	TEXT	calls.assigned_call_queue_name	calls.assigned_call_queue_name	calls
calls__assigned_ivr_id	NUMERIC	calls.assigned_ivr_id	calls.assigned_ivr_id	calls
calls__assigned_ivr_name	TEXT	calls.assigned_ivr_name	calls.assigned_ivr_name	calls
calls__assigned_team_id	NUMERIC	calls.assigned_team_id	calls.assigned_team_id	calls
calls__assigned_team_name	TEXT	calls.assigned_team_name	calls.assigned_team_name	calls
calls__bill_duration	NUMERIC	calls.bill_duration	calls.bill_duration	calls
calls__bill_duration_unit	TEXT	calls.bill_duration_unit	calls.bill_duration_unit	calls
calls__call_notes	TEXT	calls.call_notes	calls.call_notes	calls
calls__created_time	TEXT	calls.created_time	calls.created_time	calls
calls__direction	TEXT	calls.direction	calls.direction	calls
calls__id	NUMERIC	calls.id	calls.id	calls
calls__integrated_resources	OBJECT	calls.integrated_resources	calls.integrated_resources	calls
calls__parallel_call_groups	OBJECT	calls.parallel_call_groups	calls.parallel_call_groups	calls
calls__parent_call_id	NUMERIC	calls.parent_call_id	calls.parent_call_id	calls
calls__participants	OBJECT	calls.participants	calls.participants	calls
calls__phone_number	TEXT	calls.phone_number	calls.phone_number	calls
calls__phone_number_id	NUMERIC	calls.phone_number_id	calls.phone_number_id	calls
calls__recording	OBJECT	calls.recording	calls.recording	calls
calls__recording_to_redact	OBJECT	calls.recording_to_redact	calls.recording_to_redact	calls
calls__root_call_id	NUMERIC	calls.root_call_id	calls.root_call_id	calls
calls__updated_time	TEXT	calls.updated_time	calls.updated_time	calls
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
source	TEXT	Source	The name of the Windsor connector returning the row
teams__description	TEXT	teams.description	teams.description	teams
teams__id	NUMERIC	teams.id	teams.id	teams
teams__name	TEXT	teams.name	teams.name	teams
teams__omni_channel	BOOLEAN	teams.omni_channel	teams.omni_channel	teams
teams__users	OBJECT	teams.users	teams.users	teams
today	DATE	Today	Today's date
users__confirmed	BOOLEAN	users.confirmed	users.confirmed	users
users__deleted	BOOLEAN	users.deleted	users.deleted	users
users__email	TEXT	users.email	users.email	users
users__id	TEXT	users.id	users.id	users
users__language	TEXT	users.language	users.language	users
users__last_call_time	TEXT	users.last_call_time	users.last_call_time	users
users__last_seen_time	TEXT	users.last_seen_time	users.last_seen_time	users
users__mobile_app_preference	NUMERIC	users.mobile_app_preference	users.mobile_app_preference	users
users__name	TEXT	users.name	users.name	users
users__phone	TEXT	users.phone	users.phone	users
users__preference	NUMERIC	users.preference	users.preference	users
users__role	TEXT	users.role	users.role	users
users__status	TEXT	users.status	users.status	users
users__teams	OBJECT	users.teams	users.teams	users
users__time_zone	TEXT	users.time_zone	users.time_zone	users