Freshcaller Connector Reference
23 metrics50 dimensions
The Freshcaller connector exposes 73 fields (23 metrics, 50 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Freshcaller Fields
Freshcaller call_metrics fields
The call_metrics report of the Freshcaller connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| call_metrics__answering_speed | NUMERIC | call_metrics.answering_speed | call_metrics.answering_speed |
| call_metrics__answering_speed_unit | TEXT | call_metrics.answering_speed_unit | call_metrics.answering_speed_unit |
| call_metrics__bill_duration | NUMERIC | call_metrics.bill_duration | call_metrics.bill_duration |
| call_metrics__bill_duration_unit | TEXT | call_metrics.bill_duration_unit | call_metrics.bill_duration_unit |
| call_metrics__call_id | NUMERIC | call_metrics.call_id | call_metrics.call_id |
| call_metrics__call_work_time | NUMERIC | call_metrics.call_work_time | call_metrics.call_work_time |
| call_metrics__call_work_time_unit | TEXT | call_metrics.call_work_time_unit | call_metrics.call_work_time_unit |
| call_metrics__cost | NUMERIC | call_metrics.cost | call_metrics.cost |
| call_metrics__cost_unit | TEXT | call_metrics.cost_unit | call_metrics.cost_unit |
| call_metrics__created_time | TEXT | call_metrics.created_time | call_metrics.created_time |
| call_metrics__csat | OBJECT | call_metrics.csat | call_metrics.csat |
| call_metrics__hold_duration | NUMERIC | call_metrics.hold_duration | call_metrics.hold_duration |
| call_metrics__hold_duration_unit | TEXT | call_metrics.hold_duration_unit | call_metrics.hold_duration_unit |
| call_metrics__id | NUMERIC | call_metrics.id | call_metrics.id |
| call_metrics__ivr_time | NUMERIC | call_metrics.ivr_time | call_metrics.ivr_time |
| call_metrics__ivr_time_unit | TEXT | call_metrics.ivr_time_unit | call_metrics.ivr_time_unit |
| call_metrics__recording_duration | NUMERIC | call_metrics.recording_duration | call_metrics.recording_duration |
| call_metrics__recording_duration_unit | TEXT | call_metrics.recording_duration_unit | call_metrics.recording_duration_unit |
| call_metrics__tags | OBJECT | call_metrics.tags | call_metrics.tags |
| call_metrics__talk_time | NUMERIC | call_metrics.talk_time | call_metrics.talk_time |
| call_metrics__talk_time_unit | TEXT | call_metrics.talk_time_unit | call_metrics.talk_time_unit |
| call_metrics__total_ringing_time | NUMERIC | call_metrics.total_ringing_time | call_metrics.total_ringing_time |
| call_metrics__total_ringing_time_unit | TEXT | call_metrics.total_ringing_time_unit | call_metrics.total_ringing_time_unit |
| call_metrics__updated_time | TEXT | call_metrics.updated_time | call_metrics.updated_time |
Freshcaller calls fields
The calls report of the Freshcaller connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| calls__assigned_agent_id | NUMERIC | calls.assigned_agent_id | calls.assigned_agent_id |
| calls__assigned_agent_name | TEXT | calls.assigned_agent_name | calls.assigned_agent_name |
| calls__assigned_call_queue_id | NUMERIC | calls.assigned_call_queue_id | calls.assigned_call_queue_id |
| calls__assigned_call_queue_name | TEXT | calls.assigned_call_queue_name | calls.assigned_call_queue_name |
| calls__assigned_ivr_id | NUMERIC | calls.assigned_ivr_id | calls.assigned_ivr_id |
| calls__assigned_ivr_name | TEXT | calls.assigned_ivr_name | calls.assigned_ivr_name |
| calls__assigned_team_id | NUMERIC | calls.assigned_team_id | calls.assigned_team_id |
| calls__assigned_team_name | TEXT | calls.assigned_team_name | calls.assigned_team_name |
| calls__bill_duration | NUMERIC | calls.bill_duration | calls.bill_duration |
| calls__bill_duration_unit | TEXT | calls.bill_duration_unit | calls.bill_duration_unit |
| calls__call_notes | TEXT | calls.call_notes | calls.call_notes |
| calls__created_time | TEXT | calls.created_time | calls.created_time |
| calls__direction | TEXT | calls.direction | calls.direction |
| calls__id | NUMERIC | calls.id | calls.id |
| calls__integrated_resources | OBJECT | calls.integrated_resources | calls.integrated_resources |
| calls__parallel_call_groups | OBJECT | calls.parallel_call_groups | calls.parallel_call_groups |
| calls__parent_call_id | NUMERIC | calls.parent_call_id | calls.parent_call_id |
| calls__participants | OBJECT | calls.participants | calls.participants |
| calls__phone_number | TEXT | calls.phone_number | calls.phone_number |
| calls__phone_number_id | NUMERIC | calls.phone_number_id | calls.phone_number_id |
| calls__recording | OBJECT | calls.recording | calls.recording |
| calls__recording_to_redact | OBJECT | calls.recording_to_redact | calls.recording_to_redact |
| calls__root_call_id | NUMERIC | calls.root_call_id | calls.root_call_id |
| calls__updated_time | TEXT | calls.updated_time | calls.updated_time |
Freshcaller teams fields
The teams report of the Freshcaller connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| teams__description | TEXT | teams.description | teams.description |
| teams__id | NUMERIC | teams.id | teams.id |
| teams__name | TEXT | teams.name | teams.name |
| teams__omni_channel | BOOLEAN | teams.omni_channel | teams.omni_channel |
| teams__users | OBJECT | teams.users | teams.users |
Freshcaller users fields
The users report of the Freshcaller connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| users__confirmed | BOOLEAN | users.confirmed | users.confirmed |
| users__deleted | BOOLEAN | users.deleted | users.deleted |
| users__email | TEXT | users.email | users.email |
| users__id | TEXT | users.id | users.id |
| users__language | TEXT | users.language | users.language |
| users__last_call_time | TEXT | users.last_call_time | users.last_call_time |
| users__last_seen_time | TEXT | users.last_seen_time | users.last_seen_time |
| users__mobile_app_preference | NUMERIC | users.mobile_app_preference | users.mobile_app_preference |
| users__name | TEXT | users.name | users.name |
| users__phone | TEXT | users.phone | users.phone |
| users__preference | NUMERIC | users.preference | users.preference |
| users__role | TEXT | users.role | users.role |
| users__status | TEXT | users.status | users.status |
| users__teams | OBJECT | users.teams | users.teams |
| users__time_zone | TEXT | users.time_zone | users.time_zone |
Freshcaller other fields
The Freshcaller connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |
