CallRail data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CALLS

abandoned_calls
Display name Abandoned calls
Description Number of calls that lasted for less than 15 seconds
Field type metric
Data type int.number.value
agent_email
Display name Agent email
Description Email address for the user who answered the call, when applicable
Field type dimension
Data type string.text.email
answer_rate
Display name Answer rate
Description Percentage of calls that were answered. Calculated by: (Answered calls / Calls) * 100
Field type metric
Data type float.number.percentage
answered
Display name Was answered
Description Whether the call was answered
Field type dimension
Data type bool
answered_calls
Display name Answered calls
Description Number of calls that were answered
Field type metric
Data type int.number.value
avg_duration
Display name Avg. call duration (sec)
Description Average duration of a call in seconds. Calculated by: Total call duration (sec) / Calls
Field type metric
Data type float.number.value
avg_value
Display name Average value
Description Average value of a call. Calculated by: Total value / Calls
Field type metric
Data type float.currency.value
business_phone_number
Display name Business phone number
Description The phone number of the person or business who answered the call from the dialed tracking number
Field type dimension
Data type string.text.phone
call_details_url
Display name Call details link
Description URL to the specific details of the call based on the ID
Field type dimension
Data type string.text.url
call_highlights
Display name Call highlights
Description A list of relevant keywords automatically found in the call transcription
Field type dimension
Data type string.text.value
call_id
Display name Call ID
Description Unique identifier for the call
Field type dimension
Data type string.text.value
calls
Display name Calls
Description Total number of calls
Field type metric
Data type int.number.value
campaign
Display name Campaign
Description The name of the campaign the call belongs to
Field type dimension
Data type string.text.value
company_id
Display name Company ID
Description The string id of the company the call belongs to
Field type dimension
Data type string.text.value
company_name
Display name Company name
Description The name of the company the source belongs to
Field type dimension
Data type string.text.value
company_time_zone
Display name Company time zone
Description The configured time zone of the company in CallRail
Field type dimension
Data type string.text.value
customer_city
Display name Customer city
Description The customer’s city, based on the original assigned location of their phone number
Field type dimension
Data type string.geo.city
customer_country
Display name Customer country
Description The customer’s country, based on the area code of their phone number
Field type dimension
Data type string.geo.country.twolettercode
customer_phone_number
Display name Customer phone number
Description The customer’s phone number (in E.164 format)
Field type dimension
Data type string.text.phone
customer_state
Display name Customer state
Description The 2-character abbreviation for the customer’s state, based on the original assigned location of their phone number
Field type dimension
Data type string.geo.region
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
device_type
Display name Device type
Description Either mobile or desktop, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
direction
Display name Call direction
Description Whether the call was inbound (from a customer to you) or outbound (from you to a customer)
Field type dimension
Data type string.text.value
duration
Display name Total call duration (sec)
Description Total duration of all calls in seconds
Field type metric
Data type int.duration.seconds
fbclid
Display name Fbclid
Description fbclid as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
first_call
Display name First-time call
Description Whether or not the call is the caller’s first call to this company
Field type dimension
Data type bool
first_time_callers
Display name First time callers
Description Number of calls that were answered
Field type metric
Data type int.number.value
formatted_customer_name
Display name Customer name
Description The customer’s name, as reported by Caller ID
Field type dimension
Data type string.text.value
formatted_duration
Display name Call duration (sec)
Description The duration of the call in seconds
Field type dimension
Data type int.duration.seconds
ga
Display name Ga
Description Google Universal Analytics _ga value, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
gclid
Display name Gclid
Description gclid as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
good_lead_call_id
Display name Good lead call ID
Description If provided, the id of the call that was originally scored as a good lead
Field type dimension
Data type string.text.value
good_lead_call_time
Display name Good lead call time
Description If provided, the time of the call that was originally scored as a good lead
Field type dimension
Data type string.text.value
inbound_calls
Display name Inbound calls
Description Number of inbound calls
Field type metric
Data type int.number.value
keywords
Display name Keywords
Description The keywords the visitor searched for, if available for calls placed to Keyword (Session) trackers. Keywords only provided from paid ad sources
Field type dimension
Data type string.text.value
keywords_spotted
Display name Keywords spotted
Description Array of keywords spotted, each containing keyword with locations in seconds offset from beginning of recording
Field type dimension
Data type string.text.value
landing_page_url
Display name Landing page url
Description The URL the caller first landed on, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.url
last_requested_url
Display name Last requested url
Description The URL of the active page at the time the call was placed, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.url
lead_status
Display name Lead status
Description The current lead status of this caller (as of this call). One of good_lead, not_a_lead, previously_marked_good_lead, or null
Field type dimension
Data type string.text.value
medium
Display name Medium
Description "PPC" or "Organic", available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
missed_calls
Display name Missed calls
Description Number of missed calls
Field type metric
Data type int.number.value
note
Display name Note
Description Any text notes to associate with this call or form submission
Field type dimension
Data type string.text.value
outbound_calls
Display name Outbound calls
Description Number of outbound calls
Field type metric
Data type int.number.value
prior_calls
Display name Prior calls
Description 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
Field type dimension
Data type int.number.value
recording_duration
Display name Recording duration (sec)
Description The length in seconds of the recording, if available
Field type dimension
Data type string.text.url
recording_player
Display name Recording player URL
Description The URL for a stand-alone recording player for this call, if available
Field type dimension
Data type string.text.url
referrer_domain
Display name Referrer domain
Description The domain that referred the caller to your website, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
referring_url
Display name Referring url
Description The URL that referred the caller to your website, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
source
Display name Source
Description The marketing source that led to the phone call
Field type dimension
Data type string.text.value
source_name
Display name Number name
Description The name of the tracking number within CallRail
Field type dimension
Data type string.text.value
speaker_percent
Display name Speaker percent
Description A JSON object containing the values of the percentage of time spent talking by the Agent and Customer on a call
Field type dimension
Data type string.text.json
start_time
Display name Call start time
Description The date and time the call started in the current timezone
Field type dimension
Data type string.text.value
tags
Display name Tags
Description Any tags which have been applied to this call or form submission
Field type dimension
Data type string.text.value
total_calls
Display name Total calls
Description The total number of calls received from a customer phone number
Field type dimension
Data type string.text.value
total_value
Display name Total value
Description Total monetary value of all calls or form submissions
Field type metric
Data type float.currency.value
tracker_id
Display name Tracker ID
Description If provided, only return calls to this specific tracking number
Field type dimension
Data type string.text.value
tracking_phone_number
Display name Tracking phone number
Description The business’ tracking phone number for this call (in E.164 format)
Field type dimension
Data type string.text.phone
utm_campaign
Display name Utm campaign
Description utm_campaign as captured from the landing page parameter, or as specified in the configuration for Source Trackers
Field type dimension
Data type string.text.value
utm_content
Display name Utm content
Description utm_content as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
utm_medium
Display name Utm medium
Description utm_medium as captured from the landing page parameter, or as specified in the configuration for Source Trackers
Field type dimension
Data type string.text.value
utm_source
Display name Utm source
Description utm_source as captured from the landing page parameter for Session Trackers, or as specified in the configuration for Source Trackers
Field type dimension
Data type string.text.value
utm_term
Display name Utm term
Description utm_term as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
utma
Display name Utma
Description Google Analytics _utma value, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
utmb
Display name Utmb
Description Google Analytics _utmb value, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
utmc
Display name Utmc
Description Google Analytics _utmc value, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
utmv
Display name Utmv
Description Google Analytics _utmv value, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
utmz
Display name Utmz
Description Google Analytics _utmz value, available for calls placed to Keyword (Session) trackers
Field type dimension
Data type string.text.value
value
Display name Value
Description A number representing the value of this call or form submission
Field type dimension
Data type string.text.value
voicemail
Display name Voicemail
Description Whether the call ended with a voicemail (true) or not (false)
Field type dimension
Data type bool
voicemail_calls
Display name Voicemail calls
Description Number of calls going to voicemail
Field type metric
Data type int.number.value
waveforms
Display name Waveforms
Description Only present if the call was recorded. Contains the URLs of two images representing the volume of the call over time
Field type dimension
Data type string.text.value