CallRail Connector Reference

5 metrics165 dimensions

Fields

The CallRail connector exposes 170 fields (5 metrics, 165 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

CallRail Fields

CallRail calls fields

The calls report of the CallRail connector includes 74 fields.

CallRail calls fields (calls__agent_email to calls__last_requested_url)

ID	Type	Name	Description
calls__agent_email	TEXT	calls.agent_email	Email address for the user who answered the call, when applicable.
calls__answered	BOOLEAN	calls.answered	Whether the call was answered (true) or not answered (false).
calls__business_phone_number	TEXT	calls.business_phone_number	The phone number of the person or business who answered the call from the dialed tracking number.
calls__call_highlights	TEXT	calls.call_highlights	A list of relevant keywords automatically found in the call transcription.
calls__call_type	TEXT	calls.call_type	The type of call. One of abandonded, answered, in_progress, missed, outbound, voicemail, or voicemail_transcription.
calls__campaign	TEXT	calls.campaign	The name of the campaign the call belongs to.
calls__company_id	TEXT	calls.company_id	The string id of the company the call belongs to.
calls__company_name	TEXT	calls.company_name	The name of the company the source belongs to .
calls__company_time_zone	TEXT	calls.company_time_zone	The configure time zone of the company in CallRail.
calls__created_at	TIMESTAMP	calls.created_at	The date and time the call was created in the current timezone (ISO 8601 format) with an offset.
calls__customer_city	CITY	calls.customer_city	The customer’s city, based on the original assigned location of their phone number.
calls__customer_country	COUNTRY	calls.customer_country	The customer’s country, based on the area code of their phone number.
calls__customer_name	TEXT	calls.customer_name	The customer’s name, as reported by Caller ID.
calls__customer_phone_number	TEXT	calls.customer_phone_number	The customer’s phone number (in E.164 format).
calls__customer_state	TEXT	calls.customer_state	The 2-character abbreviation for the customer’s state, based on the original assigned location of their phone number.
calls__device_type	TEXT	calls.device_type	Either mobile or desktop, available for calls placed to Website (Session) trackers.
calls__direction	TEXT	calls.direction	Whether the call was inbound (from a customer to you) or outbound (from you to a customer).
calls__duration	NUMERIC	calls.duration	The duration of the call in seconds.
calls__fbclid	TEXT	calls.fbclid	fbclid as captured from the landing page parameter, available for calls placed to Website (Session) trackers.
calls__first_call	BOOLEAN	calls.first_call	Whether or not the call is the caller’s first call to this company.
calls__formatted_business_phone_number	TEXT	calls.formatted_business_phone_number	The phone number of the person or business who answered the call from the dialed tracking number, formatted for display.
calls__formatted_call_type	TEXT	calls.formatted_call_type	The type of call, formatted for display.
calls__formatted_customer_location	TEXT	calls.formatted_customer_location	The customer’s city and state formatted for display.
calls__formatted_customer_name	TEXT	calls.formatted_customer_name	The customer’s name with certain values stylized for display.
calls__formatted_customer_name_or_phone_number	TEXT	calls.formatted_customer_name_or_phone_number	The name or phone number of the customer as reported by Caller ID, formatted for display.
calls__formatted_customer_phone_number	TEXT	calls.formatted_customer_phone_number	The customer’s phone number formatted for display.
calls__formatted_duration	TEXT	calls.formatted_duration	The duration of the call formatted for display.
calls__formatted_tracking_phone_number	TEXT	calls.formatted_tracking_phone_number	The business’ tracking phone number for this call formatted for display.
calls__formatted_tracking_source	TEXT	calls.formatted_tracking_source	The name of the call source formatted for display.
calls__formatted_value	TEXT	calls.formatted_value	The value of the call assigned via the CallRail dashboard, formatted as currency or “–” if not set.
calls__ga	TEXT	calls.ga	Google Universal Analytics _ga value, available for calls placed to Website (Session) trackers.
calls__gclid	TEXT	calls.gclid	gclid as captured from the landing page parameter, available for calls placed to Website (Session) trackers. This is also available for calls from Google Ads call assets (formerly called extensions) and call-only ads through the use of our Google Ads Call Details Forwarding integration.
calls__good_lead_call_id	TEXT	calls.good_lead_call_id	If provided, the id of the call that was originally scored as a good lead.
calls__good_lead_call_time	TIMESTAMP	calls.good_lead_call_time	If provided, the time of the call that was originally scored as a good lead.
calls__id	TEXT	calls.id	Unique identifier for the call.
calls__keypad_entries	TEXT	calls.keypad_entries	A list of key-value pairs containing each number entered by the caller as part of a call flow. Each item includes the name given to the keypad entry step in the call flow and the numbers entered by the caller in the keypad entry step of the call flow. { "name": "Account Number", "value": "1234" }
calls__keywords	TEXT	calls.keywords	The keywords the visitor searched for, if available for calls placed to Website (Session) trackers. Keywords only provided from paid ad sources.
calls__keywords_spotted	TEXT	calls.keywords_spotted	Array of keywords spotted, each containing keyword with locations in seconds offset from beginning of recording.
calls__landing_page_url	TEXT	calls.landing_page_url	The URL the caller first landed on, available for calls placed to Website (Session) trackers.
calls__last_requested_url	TEXT	calls.last_requested_url	The URL of the active page at the time the call was placed, available for calls placed to Website (Session) trackers.

CallRail calls fields (calls__lead_status to calls__zip_code)

ID	Type	Name	Description
calls__lead_status	TEXT	calls.lead_status	The current lead status of this caller (as of this call). One of good_lead, not_a_lead, previously_marked_good_lead, or null.
calls__medium	TEXT	calls.medium	The medium associated with the call. Most commonly “PPC”, “direct”, or “Organic”.
calls__msclkid	TEXT	calls.msclkid	msclkid as captured from the landing page parameter, available for calls placed to Website (Session) Trackers.
calls__note	TEXT	calls.note	Any text notes to associate with this call.
calls__person_id	TEXT	calls.person_id	Unique identifier for the lead associated with the phone call.
calls__prior_calls	NUMERIC	calls.prior_calls	The number of times this company received a call from this customer prior to this call. If this is the first call from the customer, prior_calls will be 0.
calls__recording	TEXT	calls.recording	A URL pointing to the calls/recording api endpoint.
calls__recording_duration	NUMERIC	calls.recording_duration	The length in seconds of the recording, if available.
calls__recording_player	TEXT	calls.recording_player	The URL for a stand-alone recording player for this call, if available.
calls__referrer_domain	TEXT	calls.referrer_domain	The domain that referred the caller to your website, available for calls placed to Website (Session) trackers.
calls__referring_url	TEXT	calls.referring_url	The URL that referred the caller to your website, available for calls placed to Website (Session) trackers.
calls__source	TEXT	calls.source	The marketing source that led to the phone call.
calls__source_name	TEXT	calls.source_name	The name of the tracking number within CallRail.
calls__speaker_percent	TEXT	calls.speaker_percent	A JSON object containing the values of the percentage of time spent talking by the Agent and Customer on a call.
calls__start_time	TIMESTAMP	calls.start_time	The date and time the call started in the current timezone (ISO 8601 format) with an offset.
calls__tags	TEXT	calls.tags	Any tags which have been applied to this call.
calls__timeline_url	TEXT	calls.timeline_url	A link to the lead’s timeline, which displays the web sessions and touchpoints a caller had on your website before, during, and after calling your business. For more information, see our support article on Caller Timelines.
calls__total_calls	NUMERIC	calls.total_calls	The total number of calls received from a customer phone number.
calls__tracker_id	TEXT	calls.tracker_id	If provided, only return calls to this specific tracking number.
calls__tracking_phone_number	TEXT	calls.tracking_phone_number	The business’ tracking phone number for this call (in E.164 format).
calls__utm_campaign	TEXT	calls.utm_campaign	utm_campaign as captured from the landing page parameter, or as specified in the configuration for Source Trackers.
calls__utm_content	TEXT	calls.utm_content	utm_content as captured from the landing page parameter, available for calls placed to Website (Session) trackers.
calls__utm_medium	TEXT	calls.utm_medium	utm_medium as captured from the landing page parameter for Website (Session) Trackers, or as specified in the configuration for Source Trackers.
calls__utm_source	TEXT	calls.utm_source	utm_source as captured from the landing page parameter for Website (Session) Trackers, or as specified in the configuration for Source Trackers.
calls__utm_term	TEXT	calls.utm_term	utm_term as captured from the landing page parameter, available for calls placed to Website (Session) trackers.
calls__utma	TEXT	calls.utma	Google Analytics _utma value, available for calls placed to Website (Session) trackers.
calls__utmb	TEXT	calls.utmb	Google Analytics _utmb value, available for calls placed to Website (Session) trackers.
calls__utmc	TEXT	calls.utmc	Google Analytics _utmc value, available for calls placed to Website (Session) trackers.
calls__utmv	TEXT	calls.utmv	Google Analytics _utmv value, available for calls placed to Website (Session) trackers.
calls__utmz	TEXT	calls.utmz	Google Analytics _utmz value, available for calls placed to Website (Session) trackers.
calls__value	TEXT	calls.value	A number representing the monetary value of this call.
calls__voicemail	BOOLEAN	calls.voicemail	Whether the call ended with a voicemail (true) or not (false).
calls__waveforms	TEXT	calls.waveforms	Only present if the call was recorded. Contains the URLs of two images representing the volume of the call over time.
calls__zip_code	TEXT	calls.zip_code	A list of each zip code entered by the caller as part of the geo-routing step of a call flow. See our support article for more information.

CallRail companies fields

The companies report of the CallRail connector includes 17 fields.

ID	Type	Name	Description
companies__callscore_enabled	BOOLEAN	companies.callscore_enabled	Whether or not the company has CallScore enabled. See CallScore.
companies__callscribe_enabled	BOOLEAN	companies.callscribe_enabled	Whether or not the company has Transcripts and Call Highlights enabled. See Transcripts and Call Highlights.
companies__created_at	TEXT	companies.created_at	The date and time the company was created in UTC (ISO 8601 format).
companies__disabled_at	TEXT	companies.disabled_at	The date and time the company was disabled in UTC (ISO 8601 format). If the company is still enabled, this value will be null.
companies__dni_active	BOOLEAN	companies.dni_active	Whether or not the company has the Javascript Snippet enabled. This field will be null if the Javascript Snippet has never been installed. See Installing the JavaScript Snippet.
companies__form_capture	BOOLEAN	companies.form_capture	Indicates whether the company has the external form capture feature enabled.
companies__id	TEXT	companies.id	Unique identifier for the company.
companies__keyword_spotting_enabled	BOOLEAN	companies.keyword_spotting_enabled	(Deprecated) Indicates whether the company had the Keyword Spotting feature enabled. This field is returned for compatibility purposes but has no effect. It’s been replaced, see Automation Rules.
companies__lead_scoring_enabled	BOOLEAN	companies.lead_scoring_enabled	Whether or not the company has manual lead scoring enabled.
companies__name	TEXT	companies.name	Name of the company.
companies__script_url	TEXT	companies.script_url	The URL for the CallRail tracking script for this company. See Installing the JavaScript Snippet.
companies__status	TEXT	companies.status	Indicates whether the company is currently “active” or “disabled”.
companies__swap_cookie_duration	NUMERIC	companies.swap_cookie_duration	Maximum cookie duration length. Each time a visitor browses the website, their cookie expiration dates will be updated according to this value. Visitors who clear their cookies, return after the cookie expires, or use a different web browser will be treated as new visitors. A maximum duration of 6 months is allowed.
companies__swap_exclude_jquery	TEXT	companies.swap_exclude_jquery	(Deprecated) CallRail’s DNI script no longer requires jQuery; this field is returned for compatibility purposes but has no effect.
companies__swap_landing_override	TEXT	companies.swap_landing_override	Option to override the original source when a visitor arrives on a landing page containing a given param.
companies__swap_ppc_override	TEXT	companies.swap_ppc_override	Option to override the original source when a visitor arrives via PPC.
companies__time_zone	TEXT	companies.time_zone	Time Zone configured for this company.

CallRail conversations fields

The conversations report of the CallRail connector includes 19 fields.

ID	Type	Name	Description
conversations__company_id	TEXT	conversations.company_id	An ID indicating which company the message belongs to.
conversations__company_name	TEXT	conversations.company_name	conversations.company_name
conversations__company_time_zone	TEXT	conversations.company_time_zone	The timezone of the company associated with the conversation.
conversations__current_tracker_id	TEXT	conversations.current_tracker_id	Unique identifier for the tracking number used most recently in the conversation.
conversations__current_tracking_number	TEXT	conversations.current_tracking_number	The tracking phone number used in the most recent conversation (in E.164 format).
conversations__customer_name	TEXT	conversations.customer_name	The customer’s name
conversations__customer_phone_number	TEXT	conversations.customer_phone_number	The customer’s phone number (in E.164 format).
conversations__formatted_current_tracking_number	TEXT	conversations.formatted_current_tracking_number	The current_tracking_number formatted for display.
conversations__formatted_customer_name	TEXT	conversations.formatted_customer_name	The name or the customer, formatted for display.
conversations__formatted_customer_phone_number	TEXT	conversations.formatted_customer_phone_number	The phone number of the customer, formatted for display.
conversations__formatted_initial_tracking_number	TEXT	conversations.formatted_initial_tracking_number	The initial_tracking_number formatted for display.
conversations__id	TEXT	conversations.id	Unique alphanumeric identifier for the text conversation.
conversations__initial_tracker_id	TEXT	conversations.initial_tracker_id	Unique identifier for the tracking number used to start the conversation.
conversations__initial_tracking_number	TEXT	conversations.initial_tracking_number	The tracking phone number used to start the conversation (in E.164 format).
conversations__last_message_at	TEXT	conversations.last_message_at	The date and time the text was received or sent in UTC, in ISO 8601 format.
conversations__lead_status	TEXT	conversations.lead_status	The current lead status for the text conversation. One of previously_marked_good_lead, or null.
conversations__recent_messages	TEXT	conversations.recent_messages	JSON array containing up to two previous text messages in the current conversation.
conversations__state	TEXT	conversations.state	Whether or not the conversation is active or archived in CallRail. One of “active” or “archived”.
conversations__tracker_name	TEXT	conversations.tracker_name	conversations.tracker_name

CallRail form_submissions fields

The form_submissions report of the CallRail connector includes 31 fields.

ID	Type	Name	Description
form_submissions__campaign	TEXT	form_submissions.campaign	The name of the campaign the form submission belongs to.
form_submissions__company_id	TEXT	form_submissions.company_id	The string id of the company the form submission belongs to.
form_submissions__company_name	TEXT	form_submissions.company_name	The name of the company the form submission belongs to.
form_submissions__customer_email	TEXT	form_submissions.customer_email	The customer's email address, as captured from the form submission.
form_submissions__customer_name	TEXT	form_submissions.customer_name	The customer's name, as captured from the form submission.
form_submissions__customer_phone_number	TEXT	form_submissions.customer_phone_number	The customer's phone number (in E.164 format).
form_submissions__first_form	BOOLEAN	form_submissions.first_form	Whether or not this is the customer's first form submission to this company.
form_submissions__form_data	TEXT	form_submissions.form_data	The submitted form contents as a JSON object of field name/value pairs.
form_submissions__form_name	TEXT	form_submissions.form_name	The name of the submitted form.
form_submissions__form_url	TEXT	form_submissions.form_url	The URL of the page where the form was submitted.
form_submissions__formatted_customer_name	TEXT	form_submissions.formatted_customer_name	The customer's name formatted for display.
form_submissions__formatted_customer_phone_number	TEXT	form_submissions.formatted_customer_phone_number	The customer's phone number formatted for display.
form_submissions__id	TEXT	form_submissions.id	Unique identifier for the form submission.
form_submissions__keywords	TEXT	form_submissions.keywords	The keywords the visitor searched for, if available. Keywords only provided from paid ad sources.
form_submissions__landing_page_url	TEXT	form_submissions.landing_page_url	The URL the visitor first landed on before submitting the form.
form_submissions__lead_status	TEXT	form_submissions.lead_status	The current lead status for the form submission. One of good_lead, not_a_lead, or not_scored.
form_submissions__medium	TEXT	form_submissions.medium	The medium associated with the form submission. Most commonly “PPC”, “direct”, or “Organic”.
form_submissions__milestones	TEXT	form_submissions.milestones	A JSON object describing the attribution for each of the lead's milestones (first touch, lead created, qualified, last touch).
form_submissions__note	TEXT	form_submissions.note	Any text notes associated with this form submission.
form_submissions__person_email	TEXT	form_submissions.person_email	The email address of the lead associated with the form submission.
form_submissions__person_id	TEXT	form_submissions.person_id	Unique identifier for the lead associated with the form submission.
form_submissions__referrer	TEXT	form_submissions.referrer	The referrer that led the visitor to your website.
form_submissions__referring_url	TEXT	form_submissions.referring_url	The URL that referred the visitor to your website.
form_submissions__source	TEXT	form_submissions.source	The marketing source that led to the form submission.
form_submissions__submitted_at	TIMESTAMP	form_submissions.submitted_at	The date and time the form was submitted in the current timezone (ISO 8601 format) with an offset.
form_submissions__tags	TEXT	form_submissions.tags	Any tags which have been applied to this form submission.
form_submissions__timeline_url	TEXT	form_submissions.timeline_url	A link to the lead's timeline, which displays the web sessions and touchpoints the lead had on your website.
form_submissions__utm_campaign	TEXT	form_submissions.utm_campaign	utm_campaign as captured from the landing page parameter.
form_submissions__utm_medium	TEXT	form_submissions.utm_medium	utm_medium as captured from the landing page parameter.
form_submissions__utm_source	TEXT	form_submissions.utm_source	utm_source as captured from the landing page parameter.
form_submissions__value	TEXT	form_submissions.value	A number representing the monetary value of this form submission.

CallRail users fields

The users report of the CallRail connector includes 8 fields.

ID	Type	Name	Description
users__companies	TEXT	users.companies	A list of the companies the user has access to, including the id and name.
users__created_at	TEXT	users.created_at	The date and time the user was created in UTC (ISO 8601 format).
users__email	TEXT	users.email	The email address associated with this user.
users__first_name	TEXT	users.first_name	The user’s first name.
users__id	TEXT	users.id	Unique identifier for the user.
users__last_name	TEXT	users.last_name	The user’s last name.
users__name	TEXT	users.name	Full name of the user formatted for display.
users__role	TEXT	users.role	The user’s permission within this CallRail account. One of “admin”, “reporting”, or “manager”.

CallRail other fields

The CallRail connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Account ID
account_name	TEXT	Account name	Account name
data_fetched_at	TIMESTAMP	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
date	DATE	Date	The Date
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors