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

CallRail Field Reference

Fields

ID	Type	Name	Description	Report
calls__agent_email	TEXT	calls.agent_email	calls.agent_email	calls
calls__answered	BOOLEAN	calls.answered	calls.answered	calls
calls__business_phone_number	TEXT	calls.business_phone_number	calls.business_phone_number	calls
calls__call_highlights	OBJECT	calls.call_highlights	calls.call_highlights	calls
calls__call_type	TEXT	calls.call_type	calls.call_type	calls
calls__campaign	TEXT	calls.campaign	calls.campaign	calls
calls__company_id	TEXT	calls.company_id	calls.company_id	calls
calls__company_name	TEXT	calls.company_name	calls.company_name	calls
calls__company_time_zone	TEXT	calls.company_time_zone	calls.company_time_zone	calls
calls__created_at	TEXT	calls.created_at	calls.created_at	calls
calls__customer_city	TEXT	calls.customer_city	calls.customer_city	calls
calls__customer_country	TEXT	calls.customer_country	calls.customer_country	calls
calls__customer_name	TEXT	calls.customer_name	calls.customer_name	calls
calls__customer_phone_number	TEXT	calls.customer_phone_number	calls.customer_phone_number	calls
calls__customer_state	TEXT	calls.customer_state	calls.customer_state	calls
calls__device_type	TEXT	calls.device_type	calls.device_type	calls
calls__direction	TEXT	calls.direction	calls.direction	calls
calls__duration	NUMERIC	calls.duration	calls.duration	calls
calls__fbclid	TEXT	calls.fbclid	calls.fbclid	calls
calls__first_call	BOOLEAN	calls.first_call	calls.first_call	calls
calls__formatted_business_phone_number	TEXT	calls.formatted_business_phone_number	calls.formatted_business_phone_number	calls
calls__formatted_call_type	TEXT	calls.formatted_call_type	calls.formatted_call_type	calls
calls__formatted_customer_location	TEXT	calls.formatted_customer_location	calls.formatted_customer_location	calls
calls__formatted_customer_name	TEXT	calls.formatted_customer_name	calls.formatted_customer_name	calls
calls__formatted_customer_name_or_phone_number	TEXT	calls.formatted_customer_name_or_phone_number	calls.formatted_customer_name_or_phone_number	calls
calls__formatted_customer_phone_number	TEXT	calls.formatted_customer_phone_number	calls.formatted_customer_phone_number	calls
calls__formatted_duration	TEXT	calls.formatted_duration	calls.formatted_duration	calls
calls__formatted_tracking_phone_number	TEXT	calls.formatted_tracking_phone_number	calls.formatted_tracking_phone_number	calls
calls__formatted_tracking_source	TEXT	calls.formatted_tracking_source	calls.formatted_tracking_source	calls
calls__formatted_value	TEXT	calls.formatted_value	calls.formatted_value	calls
calls__ga	TEXT	calls.ga	calls.ga	calls
calls__gclid	TEXT	calls.gclid	calls.gclid	calls
calls__good_lead_call_id	TEXT	calls.good_lead_call_id	calls.good_lead_call_id	calls
calls__good_lead_call_time	TEXT	calls.good_lead_call_time	calls.good_lead_call_time	calls
calls__id	TEXT	calls.id	calls.id	calls
calls__keypad_entries	TEXT	calls.keypad_entries	calls.keypad_entries	calls
calls__keywords	TEXT	calls.keywords	calls.keywords	calls
calls__keywords_spotted	OBJECT	calls.keywords_spotted	calls.keywords_spotted	calls
calls__landing_page_url	TEXT	calls.landing_page_url	calls.landing_page_url	calls
calls__last_requested_url	TEXT	calls.last_requested_url	calls.last_requested_url	calls
calls__lead_status	TEXT	calls.lead_status	calls.lead_status	calls
calls__medium	TEXT	calls.medium	calls.medium	calls
calls__msclkid	TEXT	calls.msclkid	calls.msclkid	calls
calls__note	TEXT	calls.note	calls.note	calls
calls__prior_calls	NUMERIC	calls.prior_calls	calls.prior_calls	calls
calls__recording	TEXT	calls.recording	calls.recording	calls
calls__recording_duration	NUMERIC	calls.recording_duration	calls.recording_duration	calls
calls__recording_player	TEXT	calls.recording_player	calls.recording_player	calls
calls__referrer_domain	TEXT	calls.referrer_domain	calls.referrer_domain	calls
calls__referring_url	TEXT	calls.referring_url	calls.referring_url	calls
calls__source	TEXT	calls.source	calls.source	calls
calls__source_name	TEXT	calls.source_name	calls.source_name	calls
calls__speaker_percent	OBJECT	calls.speaker_percent	calls.speaker_percent	calls
calls__start_time	TEXT	calls.start_time	calls.start_time	calls
calls__tags	OBJECT	calls.tags	calls.tags	calls
calls__timeline_url	TEXT	calls.timeline_url	calls.timeline_url	calls
calls__total_calls	NUMERIC	calls.total_calls	calls.total_calls	calls
calls__tracker_id	TEXT	calls.tracker_id	calls.tracker_id	calls
calls__tracking_phone_number	TEXT	calls.tracking_phone_number	calls.tracking_phone_number	calls
calls__utm_campaign	TEXT	calls.utm_campaign	calls.utm_campaign	calls
calls__utm_content	TEXT	calls.utm_content	calls.utm_content	calls
calls__utm_medium	TEXT	calls.utm_medium	calls.utm_medium	calls
calls__utm_source	TEXT	calls.utm_source	calls.utm_source	calls
calls__utm_term	TEXT	calls.utm_term	calls.utm_term	calls
calls__utma	TEXT	calls.utma	calls.utma	calls
calls__utmb	TEXT	calls.utmb	calls.utmb	calls
calls__utmc	TEXT	calls.utmc	calls.utmc	calls
calls__utmv	TEXT	calls.utmv	calls.utmv	calls
calls__utmz	TEXT	calls.utmz	calls.utmz	calls
calls__value	TEXT	calls.value	calls.value	calls
calls__voicemail	BOOLEAN	calls.voicemail	calls.voicemail	calls
calls__waveforms	OBJECT	calls.waveforms	calls.waveforms	calls
companies__callscore_enabled	BOOLEAN	companies.callscore_enabled	companies.callscore_enabled	companies
companies__callscribe_enabled	BOOLEAN	companies.callscribe_enabled	companies.callscribe_enabled	companies
companies__created_at	TEXT	companies.created_at	companies.created_at	companies
companies__disabled_at	TEXT	companies.disabled_at	companies.disabled_at	companies
companies__dni_active	BOOLEAN	companies.dni_active	companies.dni_active	companies
companies__form_capture	BOOLEAN	companies.form_capture	companies.form_capture	companies
companies__id	TEXT	companies.id	companies.id	companies
companies__keyword_spotting_enabled	BOOLEAN	companies.keyword_spotting_enabled	companies.keyword_spotting_enabled	companies
companies__lead_scoring_enabled	BOOLEAN	companies.lead_scoring_enabled	companies.lead_scoring_enabled	companies
companies__name	TEXT	companies.name	companies.name	companies
companies__script_url	TEXT	companies.script_url	companies.script_url	companies
companies__status	TEXT	companies.status	companies.status	companies
companies__swap_cookie_duration	NUMERIC	companies.swap_cookie_duration	companies.swap_cookie_duration	companies
companies__swap_exclude_jquery	TEXT	companies.swap_exclude_jquery	companies.swap_exclude_jquery	companies
companies__swap_landing_override	TEXT	companies.swap_landing_override	companies.swap_landing_override	companies
companies__swap_ppc_override	TEXT	companies.swap_ppc_override	companies.swap_ppc_override	companies
companies__time_zone	TEXT	companies.time_zone	companies.time_zone	companies
conversations__company_id	TEXT	conversations.company_id	conversations.company_id	conversations
conversations__company_name	TEXT	conversations.company_name	conversations.company_name	conversations
conversations__company_time_zone	TEXT	conversations.company_time_zone	conversations.company_time_zone	conversations
conversations__current_tracker_id	TEXT	conversations.current_tracker_id	conversations.current_tracker_id	conversations
conversations__current_tracking_number	TEXT	conversations.current_tracking_number	conversations.current_tracking_number	conversations
conversations__customer_name	TEXT	conversations.customer_name	conversations.customer_name	conversations
conversations__customer_phone_number	TEXT	conversations.customer_phone_number	conversations.customer_phone_number	conversations
conversations__formatted_current_tracking_number	TEXT	conversations.formatted_current_tracking_number	conversations.formatted_current_tracking_number	conversations
conversations__formatted_customer_name	TEXT	conversations.formatted_customer_name	conversations.formatted_customer_name	conversations
conversations__formatted_customer_phone_number	TEXT	conversations.formatted_customer_phone_number	conversations.formatted_customer_phone_number	conversations
conversations__formatted_initial_tracking_number	TEXT	conversations.formatted_initial_tracking_number	conversations.formatted_initial_tracking_number	conversations
conversations__id	TEXT	conversations.id	conversations.id	conversations
conversations__initial_tracker_id	TEXT	conversations.initial_tracker_id	conversations.initial_tracker_id	conversations
conversations__initial_tracking_number	TEXT	conversations.initial_tracking_number	conversations.initial_tracking_number	conversations
conversations__last_message_at	TEXT	conversations.last_message_at	conversations.last_message_at	conversations
conversations__recent_messages	OBJECT	conversations.recent_messages	conversations.recent_messages	conversations
conversations__state	TEXT	conversations.state	conversations.state	conversations
conversations__tracker_name	TEXT	conversations.tracker_name	conversations.tracker_name	conversations
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
today	DATE	Today	Today's date
users__accepted	BOOLEAN	users.accepted	users.accepted	users
users__created_at	TEXT	users.created_at	users.created_at	users
users__email	TEXT	users.email	users.email	users
users__first_name	TEXT	users.first_name	users.first_name	users
users__id	TEXT	users.id	users.id	users
users__last_name	TEXT	users.last_name	users.last_name	users
users__name	TEXT	users.name	users.name	users
users__role	TEXT	users.role	users.role	users