Introduction

Datasources and destinations

Fields listing for CallRail

Account ID
Unique identifier for the account.
Field IDaccount/id
TypeTEXT
Data Typedimension
Account Name
Name of the account.
Field IDaccount/name
TypeTEXT
Data Typedimension
Account Outbound Recording Enabled
Whether or not the account has recording enabled for outbound calls placed via the CallRail web application.
Field IDaccount/outbound_recording_enabled
TypeBOOLEAN
Data Typedimension
Account Is HIPAA
Whether or not the account is a HIPAA account.
Field IDaccount/hipaa_account
TypeBOOLEAN
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Call Answered
Whether the call was answered (true) or not answered (false).
Field IDcall/answered
TypeBOOLEAN
Data Typedimension
Call Business Phone Number
The phone number of the person or business who answered the call from the dialed tracking number.
Field IDcall/business_phone_number
TypeTEXT
Data Typedimension
Call Customer City
The customer’s city, based on the original assigned location of their phone number.
Field IDcall/customer_city
TypeTEXT
Data Typedimension
Call Customer Country
The customer’s country, based on the area code of their phone number.
Field IDcall/customer_country
TypeTEXT
Data Typedimension
Call Customer Name
The customer’s name, as reported by Caller ID.
Field IDcall/customer_name
TypeTEXT
Data Typedimension
Call Customer Phone Number
The customer’s phone number (in E.164 format).
Field IDcall/customer_phone_number
TypeTEXT
Data Typedimension
Call Customer State
The 2-character abbreviation for the customer’s state, based on the original assigned location of their phone number.
Field IDcall/customer_state
TypeTEXT
Data Typedimension
Call Direction
Whether the call was inbound (from a customer to you) or outbound (from you to a customer).
Field IDcall/direction
TypeTEXT
Data Typedimension
Call Duration
The duration of the call in seconds.
Field IDcall/duration
TypeNUMBER
Data Typedimension
Call ID
Unique identifier for the call.
Field IDcall/id
TypeTEXT
Data Typedimension
Call Recording
A URL pointing to the calls/recording api endpoint.
Field IDcall/recording
TypeTEXT
Data Typedimension
Call Recording Duration
The length in seconds of the recording, if available.
Field IDcall/recording_duration
TypeNUMBER
Data Typedimension
Call Recording Player
The URL for a stand-alone recording player for this call, if available.
Field IDcall/recording_player
TypeTEXT
Data Typedimension
Call Start Time
The date and time the call started in the current timezone (ISO 8601 format) with an offset.
Field IDcall/start_time
TypeYEAR_MONTH_DAY
Data Typedimension
Call Tracking Phone Number
The business’ tracking phone number for this call (in E.164 format).
Field IDcall/tracking_phone_number
TypeTEXT
Data Typedimension
Call Voicemail
Whether the call ended with a voicemail (true) or not (false).
Field IDcall/voicemail
TypeBOOLEAN
Data Typedimension
Call Type
The type of call. One of abandoned, answered, in_progress, missed, outbound, voicemail, or voicemail_transcription.
Field IDcall/call_type
TypeTEXT
Data Typedimension
Call Created At
The date and time the call was created in the current timezone (ISO 8601 format) with an offset.
Field IDcall/created_at
TypeYEAR_MONTH_DAY
Data Typedimension
Call Device Type
Either mobile or desktop, available for calls placed to Website (Session) trackers.
Field IDcall/device_type
TypeTEXT
Data Typedimension
Call First Call
Whether or not the call is the caller’s first call to this company.
Field IDcall/first_call
TypeBOOLEAN
Data Typedimension
Call
The type of call, formatted for display.
Field IDcall/formatted_call_type
TypeTEXT
Data Typedimension
Call 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.
Field IDcall/prior_calls
TypeNUMBER
Data Typedimension
Good Lead Call ID
If provided, the id of the call that was originally scored as a good lead.
Field IDcall/good_lead_call_id
TypeNUMBER
Data Typedimension
Good Lead Call Time
If provided, the time of the call that was originally scored as a good lead.
Field IDcall/good_lead_call_time
TypeTEXT
Data Typedimension
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.
Field IDcall/lead_status
TypeTEXT
Data Typedimension
Call Note
Any text notes to associate with this call.
Field IDcall/note
TypeTEXT
Data Typedimension
Call Source
The marketing source that led to the phone call.
Field IDcall/source
TypeTEXT
Data Typedimension
Call Source Name
The name of the tracking number within CallRail.
Field IDcall/source_name
TypeTEXT
Data Typedimension
Call Tags
Any tags which have been applied to this call.
Field IDcall/tags
TypeTEXT
Data Typedimension
Call Total
The total number of calls received from a customer phone number.
Field IDcall/total_calls
TypeNUMBER
Data Typedimension
Call Value
A number representing the value of this call.
Field IDcall/value
TypeTEXT
Data Typedimension
Call Waveforms
Only present if the call was recorded. Contains the URLs of two images representing the volume of the call over time.
Field IDcall/waveforms
TypeTEXT
Data Typedimension
Call Tracker ID
If provided, only return calls to this specific tracking number.
Field IDcall/tracker_id
TypeTEXT
Data Typedimension
Call Speaker Percent
A JSON object containing the values of the percentage of time spent talking by the Agent and Customer on a call.
Field IDcall/speaker_percent
TypeTEXT
Data Typedimension
Call Keywords
The keywords the visitor searched for, if available for calls placed to Website (Session) trackers. Keywords only provided from paid ad sources.
Field IDcall/keywords
TypeTEXT
Data Typedimension
Call Medium
The medium associated with the call. Most commonly “PPC”, “direct”, or “Organic”.
Field IDcall/medium
TypeTEXT
Data Typedimension
Call Campaign
The name of the campaign the call belongs to.
Field IDcall/campaign
TypeTEXT
Data Typedimension
Call Referring URL
The URL that referred the caller to your website, available for calls placed to Website (Session) trackers.
Field IDcall/referring_url
TypeTEXT
Data Typedimension
Call Landing Page URL
The URL the caller first landed on, available for calls placed to Website (Session) trackers.
Field IDcall/landing_page_url
TypeTEXT
Data Typedimension
Call Last Requested URL
The URL of the active page at the time the call was placed, available for calls placed to Website (Session) trackers.
Field IDcall/last_requested_url
TypeTEXT
Data Typedimension
Call Referrer Domain
The domain that referred the caller to your website, available for calls placed to Website (Session) trackers.
Field IDcall/referrer_domain
TypeTEXT
Data Typedimension
Call UTM Source
utm_source as captured from the landing page parameter for Website (Session) Trackers, or as specified in the configuration for Source Trackers.
Field IDcall/utm_source
TypeTEXT
Data Typedimension
Call UTM Medium
utm_medium as captured from the landing page parameter for Website (Session) Trackers, or as specified in the configuration for Source Trackers.
Field IDcall/utm_medium
TypeTEXT
Data Typedimension
Call UTM Term
utm_term as captured from the landing page parameter, available for calls placed to Website (Session) trackers.
Field IDcall/utm_term
TypeTEXT
Data Typedimension
Call UTM Content
utm_content as captured from the landing page parameter, available for calls placed to Website (Session) trackers.
Field IDcall/utm_content
TypeTEXT
Data Typedimension
Call UTM Campaign
utm_campaign as captured from the landing page parameter, or as specified in the configuration for Source Trackers.
Field IDcall/utm_campaign
TypeTEXT
Data Typedimension
Call UTMA
Google Analytics _utma value, available for calls placed to Website (Session) trackers.
Field IDcall/utma
TypeTEXT
Data Typedimension
Call UTMB
Google Analytics _utmb value, available for calls placed to Website (Session) trackers.
Field IDcall/utmb
TypeTEXT
Data Typedimension
Call UTMC
Google Analytics _utmc value, available for calls placed to Website (Session) trackers.
Field IDcall/utmc
TypeTEXT
Data Typedimension
Call UTMV
Google Analytics _utmv value, available for calls placed to Website (Session) trackers.
Field IDcall/utmv
TypeTEXT
Data Typedimension
Call UTMZ
Google Analytics _utmz value, available for calls placed to Website (Session) trackers.
Field IDcall/utmz
TypeTEXT
Data Typedimension
Call GA
Google Universal Analytics _ga value, available for calls placed to Website (Session) trackers
Field IDcall/ga
TypeTEXT
Data Typedimension
Call 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.
Field IDcall/gclid
TypeTEXT
Data Typedimension
Call Fbclid
fbclid as captured from the landing page parameter, available for calls placed to Website (Session) trackers.
Field IDcall/fbclid
TypeTEXT
Data Typedimension
Call Msclkid
msclkid as captured from the landing page parameter, available for calls placed to Website (Session) Trackers.
Field IDcall/msclkid
TypeTEXT
Data Typedimension
Call Keywords Spotted
Array of keywords spotted, each containing keyword with locations in seconds offset from beginning of recording.
Field IDcall/keywords_spotted
TypeTEXT
Data Typedimension
Call Highlights
A list of relevant keywords automatically found in the call transcription.
Field IDcall/call_highlights
TypeTEXT
Data Typedimension
Call Summary
Three to five sentences that summarizes the contents of the call. This is available when the call is over 30 seconds, for customers with a subscription to a Premium Converation Intelligence plan.
Field IDcall/call_summary
TypeTEXT
Data Typedimension
Call Agent Email
Email address for the user who answered the call, when applicable.
Field IDcall/agent_email
TypeTEXT
Data Typedimension
Company ID
Unique identifier for the company.
Field IDcompany/id
TypeTEXT
Data Typedimension
Company Name
Name of the company.
Field IDcompany/name
TypeTEXT
Data Typedimension
Company Status
Indicates whether the company is currently “active” or “disabled”.
Field IDcompany/status
TypeTEXT
Data Typedimension
Company Time Zone
Time Zone configured for this company.
Field IDcompany/time_zone
TypeTEXT
Data Typedimension
Company Created At
The date and time the company was created in UTC (ISO 8601 format).
Field IDcompany/created_at
TypeTEXT
Data Typedimension
Company 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.
Field IDcompany/disabled_at
TypeTEXT
Data Typedimension
Company 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.
Field IDcompany/dni_active
TypeBOOLEAN
Data Typedimension
Company Script URL
The URL for the CallRail tracking script for this company.
Field IDcompany/script_url
TypeTEXT
Data Typedimension
Company Callscore Enabled
Whether or not the company has CallScore enabled.
Field IDcompany/callscore_enabled
TypeBOOLEAN
Data Typedimension
Company Lead Scoring Enabled
Whether or not the company has manual lead scoring enabled.
Field IDcompany/lead_scoring_enabled
TypeBOOLEAN
Data Typedimension
Company Swap PPC Override
Option to override the original source when a visitor arrives via PPC.
Field IDcompany/swap_ppc_override
TypeBOOLEAN
Data Typedimension
Company Swap Landing Override
Option to override the original source when a visitor arrives on a landing page containing a given param.
Field IDcompany/swap_landing_override
TypeTEXT
Data Typedimension
Company Swap Cookie Duration
Cookie duration length in number of days (30, 60, 90, or 365.) Visitors who clear their cookies, return after the cookie expires, or use a different web browser will be treated as new visitors.
Field IDcompany/swap_cookie_duration
TypeNUMBER
Data Typedimension
Company Callscribe Enabled
Whether or not the company has Transcripts and Call Highlights enabled.
Field IDcompany/callscribe_enabled
TypeBOOLEAN
Data Typedimension
Company Form Capture
Indicates whether the company has the external form capture feature enabled.
Field IDcompany/form_capture
TypeBOOLEAN
Data Typedimension
Tag ID
Unique identifier for the Tag object.
Field IDtag/id
TypeNUMBER
Data Typedimension
Tag Name
The name of the tag formatted for display.
Field IDtag/name
TypeTEXT
Data Typedimension
Tag Level
Indicates whether the tag is at the account level or the company level.
Field IDtag/tag_level
TypeTEXT
Data Typedimension
Tag Color
The name reference from the available colors.
Field IDtag/color
TypeTEXT
Data Typedimension
Tag Background Color
The name reference from the available colors.
Field IDtag/background_color
TypeTEXT
Data Typedimension
Tag Status
Indicates whether the tag is currently “enabled” or “disabled”.
Field IDtag/status
TypeTEXT
Data Typedimension
Tag Created At
The date and time the tag was created in the current timezone (ISO 8601 format) with an offset.
Field IDtag/created_at
TypeTEXT
Data Typedimension
Form Submission ID
Unique identifier for the form submission.
Field IDform_submission/id
TypeTEXT
Data Typedimension
Form URL
The URL that the form was submitted to
Field IDform_submission/form_url
TypeTEXT
Data Typedimension
Form Submission Landing Page URL
The URL that the user landed on from the referring entity
Field IDform_submission/landing_page_url
TypeTEXT
Data Typedimension
Form Submission Referrer
Name of the referring entity, e.g. google_paid.
Field IDform_submission/referrer
TypeTEXT
Data Typedimension
Form Submission Referring URL
URL for the referring entity
Field IDform_submission/referring_url
TypeTEXT
Data Typedimension
Form Submission Submitted At
Server time when the form was submitted. This is assigned by the CallRail app.
Field IDform_submission/submitted_at
TypeYEAR_MONTH_DAY
Data Typedimension
Form Submission First Form
Indicates whether this is the first form submitted from a person.
Field IDform_submission/first_form
TypeBOOLEAN
Data Typedimension
Form Submission Customer Phone Number
The customer’s phone number (in E.164 format).
Field IDform_submission/customer_phone_number
TypeTEXT
Data Typedimension
Form Submission Customer Name
The customer’s name, as reported by Caller ID.
Field IDform_submission/customer_name
TypeTEXT
Data Typedimension
Form Submission Source
The marketing source that led to the form submission.
Field IDform_submission/source
TypeTEXT
Data Typedimension
Form Submission Keywords
The keywords the visitor searched for. Keywords only provided from paid ad sources.
Field IDform_submission/keywords
TypeTEXT
Data Typedimension
Form Submission Campaign
The name of the campaign the form submission belongs to.
Field IDform_submission/campaign
TypeTEXT
Data Typedimension
Form Submission Medium
“PPC” or “Organic”.
Field IDform_submission/medium
TypeTEXT
Data Typedimension
Form Submission Lead Status
The current lead status for the form submission. One of good_lead, not_a_lead, previously_marked_good_lead, or null.
Field IDform_submission/lead_status
TypeTEXT
Data Typedimension
Form Submission Value
Indicates whether the form has a monetary value associated with it.
Field IDform_submission/value
TypeNUMBER
Data Typedimension
Form Submission Note
Note associated with the form submission.
Field IDform_submission/note
TypeTEXT
Data Typedimension
Form Submission Tags
Array of tags that have been applied to the form submission.
Field IDform_submission/tags
TypeTEXT
Data Typedimension
Form Submission UTM Source
utm_source as captured from the landing page parameter.
Field IDform_submission/utm_source
TypeTEXT
Data Typedimension
Form Submission UTM Medium
utm_medium as captured from the landing page parameter.
Field IDform_submission/utm_medium
TypeTEXT
Data Typedimension
Form Submission UTM Campaign
utm_campaign as captured from the landing page parameter.
Field IDform_submission/utm_campaign
TypeTEXT
Data Typedimension
Form Name
The name of the Custom Form responsible for the form capture, where applicable.
Field IDform_submission/form_name
TypeTEXT
Data Typedimension
Form Submission Timeline URL
A link to the lead’s timeline, which displays the web sessions and touchpoints a lead had on your website before, during, and after submitting a form.
Field IDform_submission/timeline_url
TypeTEXT
Data Typedimension
Form data: 1st field name
The name of the first field in the form
Field IDform_submission/form_data_name_1
TypeTEXT
Data Typedimension
Form data: 1st field value
The value of the first field in the form
Field IDform_submission/form_data_value_1
TypeTEXT
Data Typedimension
Form data: 2nd field name
The name of the second field in the form
Field IDform_submission/form_data_name_2
TypeTEXT
Data Typedimension
Form data: 2nd field value
The value of the second field in the form
Field IDform_submission/form_data_value_2
TypeTEXT
Data Typedimension
Form data: 3rd field name
The name of the third field in the form
Field IDform_submission/form_data_name_3
TypeTEXT
Data Typedimension
Form data: 3rd field value
The value of the third field in the form
Field IDform_submission/form_data_value_3
TypeTEXT
Data Typedimension
Form data: 4th field name
The name of the fourth field in the form
Field IDform_submission/form_data_name_4
TypeTEXT
Data Typedimension
Form data: 4th field value
The value of the fourth field in the form
Field IDform_submission/form_data_value_4
TypeTEXT
Data Typedimension
Form data: 5th field name
The name of the fifth field in the form
Field IDform_submission/form_data_name_5
TypeTEXT
Data Typedimension
Form data: 5th field value
The value of the fifth field in the form
Field IDform_submission/form_data_value_5
TypeTEXT
Data Typedimension
Form data: 6th field name
The name of the sixth field in the form
Field IDform_submission/form_data_name_6
TypeTEXT
Data Typedimension
Form data: 6th field value
The value of the sixth field in the form
Field IDform_submission/form_data_value_6
TypeTEXT
Data Typedimension
Form data: 7th field name
The name of the seventh field in the form
Field IDform_submission/form_data_name_7
TypeTEXT
Data Typedimension
Form data: 7th field value
The value of the seventh field in the form
Field IDform_submission/form_data_value_7
TypeTEXT
Data Typedimension
Form data: 8th field name
The name of the eighth field in the form
Field IDform_submission/form_data_name_8
TypeTEXT
Data Typedimension
Form data: 8th field value
The value of the eighth field in the form
Field IDform_submission/form_data_value_8
TypeTEXT
Data Typedimension
Form data: 9th field name
The name of the ninth field in the form
Field IDform_submission/form_data_name_9
TypeTEXT
Data Typedimension
Form data: 9th field value
The value of the ninth field in the form
Field IDform_submission/form_data_value_9
TypeTEXT
Data Typedimension
Form data: 10th field name
The name of the tenth field in the form
Field IDform_submission/form_data_name_10
TypeTEXT
Data Typedimension
Form data: 10th field value
The value of the tenth field in the form
Field IDform_submission/form_data_value_10
TypeTEXT
Data Typedimension
Form data: 11th field name
The name of the eleventh field in the form
Field IDform_submission/form_data_name_11
TypeTEXT
Data Typedimension
Form data: 11th field value
The value of the eleventh field in the form
Field IDform_submission/form_data_value_11
TypeTEXT
Data Typedimension
Form data: 12th field name
The name of the twelfth field in the form
Field IDform_submission/form_data_name_12
TypeTEXT
Data Typedimension
Form data: 12th field value
The value of the twelfth field in the form
Field IDform_submission/form_data_value_12
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension
Form submissions
Number of form submissions
Field IDform_submissions
TypeNUMBER
Data Typemetric
First Form submissions
Number of times where a form is submitted and is the first form submitted from a person
Field IDfirst_form_submissions
TypeNUMBER
Data Typemetric
Calls
Total number of calls
Field IDcalls
TypeNUMBER
Data Typemetric
Call Answered Integer
Call answered integer
Field IDfirst_time_callers
TypeNUMBER
Data Typemetric
Call Answer rate
Percentage of calls that were answered
Field IDcall_answer_rate
TypeNUMBER
Data Typemetric
Call Missed
Number of missed calls
Field IDis_missed_calls
TypeBOOLEAN
Data Typemetric
Total Call Missed
Number of missed calls
Field IDmissed_calls
TypeNUMBER
Data Typemetric
Call Abandoned
Number of calls that lasted for less than 15 seconds
Field IDis_abandoned_calls
TypeBOOLEAN
Data Typemetric
Total Call Abandoned
Number of calls that lasted for less than 15 seconds
Field IDabandoned_calls
TypeNUMBER
Data Typemetric
Total Call Voicemail
Number of calls going to voicemail integer
Field IDvoicemail_calls
TypeNUMBER
Data Typemetric
Calls Inbound
Is inbound call boolean
Field IDis_inbound_calls
TypeBOOLEAN
Data Typemetric
Total Calls Inbound
Number of inbound calls
Field IDinbound_calls
TypeNUMBER
Data Typemetric
Calls Outbound
Is outbound calls boolean
Field IDis_outbound_calls
TypeBOOLEAN
Data Typemetric
Total Calls Outbound
Number of outbound calls
Field IDoutbound_calls
TypeNUMBER
Data Typemetric
Calls AVG Duration
Average duration of a call
Field IDavg_duration
TypeNUMBER
Data Typemetric
Call Total Duration (sec)
Total duration of all calls in second.
Field IDduration
TypeNUMBER
Data Typemetric
Good Lead and First Time Caller Number
Good lead and first time caller number
Field IDgood_lead_and_first_time_number
TypeNUMBER
Data Typemetric
Leads
Number of new leads
Field IDleads
TypeNUMBER
Data Typemetric
Good Lead Rate
Portion of first time callers marked as good leads
Field IDlead_rate
TypeNUMBER
Data Typemetric