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 |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID | |
| account_name | TEXT | Account name | Account name | |
| calls__agent_email | TEXT | calls.agent_email | Email address for the user who answered the call, when applicable. | calls |
| calls__answered | BOOLEAN | calls.answered | Whether the call was answered (true) or not answered (false). | calls |
| 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 |
| calls__call_highlights | TEXT | calls.call_highlights | A list of relevant keywords automatically found in the call transcription. | calls |
| calls__call_type | TEXT | calls.call_type | The type of call. One of abandonded, answered, in_progress, missed, outbound, voicemail, or voicemail_transcription. | calls |
| calls__campaign | TEXT | calls.campaign | The name of the campaign the call belongs to. | calls |
| calls__company_id | TEXT | calls.company_id | The string id of the company the call belongs to. | calls |
| calls__company_name | TEXT | calls.company_name | The name of the company the source belongs to . | calls |
| calls__company_time_zone | TEXT | calls.company_time_zone | The configure time zone of the company in CallRail. | calls |
| 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 |
| calls__customer_city | CITY | calls.customer_city | The customer’s city, based on the original assigned location of their phone number. | calls |
| calls__customer_country | COUNTRY | calls.customer_country | The customer’s country, based on the area code of their phone number. | calls |
| calls__customer_name | TEXT | calls.customer_name | The customer’s name, as reported by Caller ID. | calls |
| calls__customer_phone_number | TEXT | calls.customer_phone_number | The customer’s phone number (in E.164 format). | calls |
| 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 |
| calls__device_type | TEXT | calls.device_type | Either mobile or desktop, available for calls placed to Website (Session) trackers. | calls |
| calls__direction | TEXT | calls.direction | Whether the call was inbound (from a customer to you) or outbound (from you to a customer). | calls |
| calls__duration | NUMERIC | calls.duration | The duration of the call in seconds. | calls |
| calls__fbclid | TEXT | calls.fbclid | fbclid as captured from the landing page parameter, available for calls placed to Website (Session) trackers. | calls |
| calls__first_call | BOOLEAN | calls.first_call | Whether or not the call is the caller’s first call to this company. | calls |
| 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 |
| calls__formatted_call_type | TEXT | calls.formatted_call_type | The type of call, formatted for display. | calls |
| calls__formatted_customer_location | TEXT | calls.formatted_customer_location | The customer’s city and state formatted for display. | calls |
| calls__formatted_customer_name | TEXT | calls.formatted_customer_name | The customer’s name with certain values stylized for display. | calls |
| 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 |
| calls__formatted_customer_phone_number | TEXT | calls.formatted_customer_phone_number | The customer’s phone number formatted for display. | calls |
| calls__formatted_duration | TEXT | calls.formatted_duration | The duration of the call formatted for display. | calls |
| calls__formatted_tracking_phone_number | TEXT | calls.formatted_tracking_phone_number | The business’ tracking phone number for this call formatted for display. | calls |
| calls__formatted_tracking_source | TEXT | calls.formatted_tracking_source | The name of the call source formatted for display. | calls |
| 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 |
| calls__ga | TEXT | calls.ga | Google Universal Analytics _ga value, available for calls placed to Website (Session) trackers. | calls |
| 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 |
| 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 |
| 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 |
| calls__id | TEXT | calls.id | Unique identifier for the call. | calls |
| 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 |
| 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 |
| calls__keywords_spotted | TEXT | calls.keywords_spotted | Array of keywords spotted, each containing keyword with locations in seconds offset from beginning of recording. | calls |
| 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 |
| 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. | calls |
| 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 |
| calls__medium | TEXT | calls.medium | The medium associated with the call. Most commonly “PPC”, “direct”, or “Organic”. | calls |
| calls__msclkid | TEXT | calls.msclkid | msclkid as captured from the landing page parameter, available for calls placed to Website (Session) Trackers. | calls |
| calls__note | TEXT | calls.note | Any text notes to associate with this call. | calls |
| calls__person_id | TEXT | calls.person_id | Unique identifier for the lead associated with the phone call. | calls |
| 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 |
| calls__recording | TEXT | calls.recording | A URL pointing to the calls/recording api endpoint. | calls |
| calls__recording_duration | NUMERIC | calls.recording_duration | The length in seconds of the recording, if available. | calls |
| calls__recording_player | TEXT | calls.recording_player | The URL for a stand-alone recording player for this call, if available. | calls |
| 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 |
| 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 |
| calls__source | TEXT | calls.source | The marketing source that led to the phone call. | calls |
| calls__source_name | TEXT | calls.source_name | The name of the tracking number within CallRail. | calls |
| 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 |
| 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 |
| calls__tags | TEXT | calls.tags | Any tags which have been applied to this call. | calls |
| 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 |
| calls__total_calls | NUMERIC | calls.total_calls | The total number of calls received from a customer phone number. | calls |
| calls__tracker_id | TEXT | calls.tracker_id | If provided, only return calls to this specific tracking number. | calls |
| calls__tracking_phone_number | TEXT | calls.tracking_phone_number | The business’ tracking phone number for this call (in E.164 format). | calls |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| calls__utma | TEXT | calls.utma | Google Analytics _utma value, available for calls placed to Website (Session) trackers. | calls |
| calls__utmb | TEXT | calls.utmb | Google Analytics _utmb value, available for calls placed to Website (Session) trackers. | calls |
| calls__utmc | TEXT | calls.utmc | Google Analytics _utmc value, available for calls placed to Website (Session) trackers. | calls |
| calls__utmv | TEXT | calls.utmv | Google Analytics _utmv value, available for calls placed to Website (Session) trackers. | calls |
| calls__utmz | TEXT | calls.utmz | Google Analytics _utmz value, available for calls placed to Website (Session) trackers. | calls |
| calls__value | TEXT | calls.value | A number representing the monetary value of this call. | calls |
| calls__voicemail | BOOLEAN | calls.voicemail | Whether the call ended with a voicemail (true) or not (false). | calls |
| 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 |
| 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. | calls |
| companies__callscore_enabled | BOOLEAN | companies.callscore_enabled | Whether or not the company has CallScore enabled. See CallScore. | companies |
| companies__callscribe_enabled | BOOLEAN | companies.callscribe_enabled | Whether or not the company has Transcripts and Call Highlights enabled. See Transcripts and Call Highlights. | companies |
| companies__created_at | TEXT | companies.created_at | The date and time the company was created in UTC (ISO 8601 format). | companies |
| 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 |
| 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 |
| companies__form_capture | BOOLEAN | companies.form_capture | Indicates whether the company has the external form capture feature enabled. | companies |
| companies__id | TEXT | companies.id | Unique identifier for the company. | companies |
| 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 |
| companies__lead_scoring_enabled | BOOLEAN | companies.lead_scoring_enabled | Whether or not the company has manual lead scoring enabled. | companies |
| companies__name | TEXT | companies.name | Name of the company. | companies |
| companies__script_url | TEXT | companies.script_url | The URL for the CallRail tracking script for this company. See Installing the JavaScript Snippet. | companies |
| companies__status | TEXT | companies.status | Indicates whether the company is currently “active” or “disabled”. | companies |
| 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 |
| 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 |
| 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 |
| companies__swap_ppc_override | TEXT | companies.swap_ppc_override | Option to override the original source when a visitor arrives via PPC. | companies |
| companies__time_zone | TEXT | companies.time_zone | Time Zone configured for this company. | companies |
| conversations__company_id | TEXT | conversations.company_id | An ID indicating which company the message belongs to. | conversations |
| conversations__company_name | TEXT | conversations.company_name | conversations.company_name | conversations |
| conversations__company_time_zone | TEXT | conversations.company_time_zone | The timezone of the company associated with the conversation. | conversations |
| conversations__current_tracker_id | TEXT | conversations.current_tracker_id | Unique identifier for the tracking number used most recently in the conversation. | conversations |
| conversations__current_tracking_number | TEXT | conversations.current_tracking_number | The tracking phone number used in the most recent conversation (in E.164 format). | conversations |
| conversations__customer_name | TEXT | conversations.customer_name | The customer’s name | conversations |
| conversations__customer_phone_number | TEXT | conversations.customer_phone_number | The customer’s phone number (in E.164 format). | conversations |
| conversations__formatted_current_tracking_number | TEXT | conversations.formatted_current_tracking_number | The current_tracking_number formatted for display. | conversations |
| conversations__formatted_customer_name | TEXT | conversations.formatted_customer_name | The name or the customer, formatted for display. | conversations |
| conversations__formatted_customer_phone_number | TEXT | conversations.formatted_customer_phone_number | The phone number of the customer, formatted for display. | conversations |
| conversations__formatted_initial_tracking_number | TEXT | conversations.formatted_initial_tracking_number | The initial_tracking_number formatted for display. | conversations |
| conversations__id | TEXT | conversations.id | Unique alphanumeric identifier for the text conversation. | conversations |
| conversations__initial_tracker_id | TEXT | conversations.initial_tracker_id | Unique identifier for the tracking number used to start the conversation. | conversations |
| conversations__initial_tracking_number | TEXT | conversations.initial_tracking_number | The tracking phone number used to start the conversation (in E.164 format). | conversations |
| 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 |
| conversations__lead_status | TEXT | conversations.lead_status | The current lead status for the text conversation. One of previously_marked_good_lead, or null. | conversations |
| conversations__recent_messages | TEXT | conversations.recent_messages | JSON array containing up to two previous text messages in the current conversation. | conversations |
| conversations__state | TEXT | conversations.state | Whether or not the conversation is active or archived in CallRail. One of “active” or “archived”. | 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 | |
| date | DATE | Date | The Date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| users__companies | TEXT | users.companies | A list of the companies the user has access to, including the id and name. | users |
| users__created_at | TEXT | users.created_at | The date and time the user was created in UTC (ISO 8601 format). | users |
| users__email | TEXT | users.email | The email address associated with this user. | users |
| users__first_name | TEXT | users.first_name | The user’s first name. | users |
| users__id | TEXT | users.id | Unique identifier for the user. | users |
| users__last_name | TEXT | users.last_name | The user’s last name. | users |
| users__name | TEXT | users.name | Full name of the user formatted for display. | users |
| users__role | TEXT | users.role | The user’s permission within this CallRail account. One of “admin”, “reporting”, or “manager”. | users |
| 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_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 |