Supermetrics brings all your CallRail data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure17 metrics115 dimensionsSearch fields×CALLcall_id Field label Call ID Description Unique identifier for the call Field type dimension Data type string.text.valuecall_details_url Field label Call details link Description URL to the specific details of the call based on the ID Field type dimension Data type string.text.urlstart_time Field label Call start time Description The date and time the call started in the current timezone Field type dimension Data type string.text.valuedirection Field label 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.valueanswered Field label Was answered Description Whether the call was answered Field type dimension Data type boolvoicemail Field label Voicemail Description Whether the call ended with a voicemail (true) or not (false) Field type dimension Data type boolformatted_duration Field label Call duration (sec) Description The duration of the call in seconds Field type dimension Data type int.duration.secondsfirst_call Field label First-time call Description Whether or not the call is the caller’s first call to this company Field type dimension Data type boolprior_calls Field label 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.valuetotal_calls Field label Total calls Description The total number of calls received from a customer phone number Field type dimension Data type string.text.valuespeaker_percent Field label 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.jsonkeywords_spotted Field label 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.valuecall_highlights Field label Call highlights Description A list of relevant keywords automatically found in the call transcription Field type dimension Data type string.text.valuebusiness_phone_number Field label 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.phonesource_name Field label Number name Description The name of the tracking number within CallRail Field type dimension Data type string.text.valueagent_email Field label Agent email Description Email address for the user who answered the call, when applicable Field type dimension Data type string.text.emailtracking_phone_number Field label Tracking phone number Description The business’ tracking phone number for this call (in E.164 format) Field type dimension Data type string.text.phonetracker_id Field label Tracker ID Description If provided, only return calls to this specific tracking number Field type dimension Data type string.text.valuecalls Field label Calls Description Total number of calls Field type metric Data type int.number.valueanswered_calls Field label Answered calls Description Number of calls that were answered Field type metric Data type int.number.valueanswer_rate Field label Answer rate Description Percentage of calls that were answered. Calculated by: (Answered calls / Calls) * 100 Field type metric Data type float.number.percentagemissed_calls Field label Missed calls Description Number of missed calls Field type metric Data type int.number.valueabandoned_calls Field label Abandoned calls Description Number of calls that lasted for less than 15 seconds Field type metric Data type int.number.valuevoicemail_calls Field label Voicemail calls Description Number of calls going to voicemail Field type metric Data type int.number.valuefirst_time_callers Field label First time callers Description Number of calls that were answered Field type metric Data type int.number.valueinbound_calls Field label Inbound calls Description Number of inbound calls Field type metric Data type int.number.valueoutbound_calls Field label Outbound calls Description Number of outbound calls Field type metric Data type int.number.valueavg_duration Field label 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.valueduration Field label Total call duration (sec) Description Total duration of all calls in seconds Field type metric Data type int.duration.secondsCOMPANYcompany_id Field label Company ID Description The string id of the company the call belongs to Field type dimension Data type string.text.valuecompany_name Field label Company name Description The name of the company the source belongs to Field type dimension Data type string.text.valuecompany_time_zone Field label Company time zone Description The configured time zone of the company in CallRail Field type dimension Data type string.text.valueCUSTOMERformatted_customer_name Field label Customer name Description The customer’s name, as reported by Caller ID Field type dimension Data type string.text.valuecustomer_city Field label Customer city Description The customer’s city, based on the original assigned location of their phone number Field type dimension Data type string.geo.citycustomer_state Field label 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.regioncustomer_country Field label Customer country Description The customer’s country, based on the area code of their phone number Field type dimension Data type string.geo.country.twolettercodecustomer_phone_number Field label Customer phone number Description The customer’s phone number (in E.164 format) Field type dimension Data type string.text.phonedevice_type Field label Device type Description Either mobile or desktop, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valueDATASOURCEdataSourceName Field label Data source Description The name of the source for this data, as listed on supermetrics.com/docs Field type dimension Data type string.text.value Destinations API, Data warehouse system_metadata.data_source_logins Field label Data source logins Description The data source login accounts that were used to authenticate against the data source Field type dimension Data type string.text.jsonsystem_metadata.data_source_login_owners Field label Data source login owners Description The Supermetrics users that created the data source login connections Field type dimension Data type string.text.jsonFORMform_name Field label Form name Description The name of the Custom Form responsible for the form capture, where applicable Field type dimension Data type string.text.valueform_url Field label Form URL Description The URL that the form was submitted to Field type dimension Data type string.text.urlform_submissions Field label Form submissions Description Number of form submissions Field type metric Data type int.number.valuefirst_form_submissions Field label First-time submissions Description Number of times where a form is submitted and is the first form submitted from a person Field type metric Data type int.number.valueFORM DATAform_data Field label Form data Description Object that captures all of the form fields and values Field type dimension Data type string.text.jsonform_data_name_1 Field label Form data: 1st field name Description Name of 1st field of the form Field type dimension Data type string.text.valueform_data_value_1 Field label Form data: 1st field value Description Value of the 1st field of the form Field type dimension Data type string.text.valueform_data_name_2 Field label Form data: 2nd field name Description Name of 2nd field of the form Field type dimension Data type string.text.valueform_data_value_2 Field label Form data: 2nd field value Description Value of the 2nd field of the form Field type dimension Data type string.text.valueform_data_name_3 Field label Form data: 3rd field name Description Name of 3rd field of the form Field type dimension Data type string.text.valueform_data_value_3 Field label Form data: 3rd field value Description Value of the 3rd field of the form Field type dimension Data type string.text.valueform_data_name_4 Field label Form data: 4th field name Description Name of 4th field of the form Field type dimension Data type string.text.valueform_data_value_4 Field label Form data: 4th field value Description Value of the 4th field of the form Field type dimension Data type string.text.valueform_data_name_5 Field label Form data: 5th field name Description Name of 5th field of the form Field type dimension Data type string.text.valueform_data_value_5 Field label Form data: 5th field value Description Value of the 5th field of the form Field type dimension Data type string.text.valueform_data_name_6 Field label Form data: 6th field name Description Name of 6th field of the form Field type dimension Data type string.text.valueform_data_value_6 Field label Form data: 6th field value Description Value of the 6th field of the form Field type dimension Data type string.text.valueform_data_name_7 Field label Form data: 7th field name Description Name of 7th field of the form Field type dimension Data type string.text.valueform_data_value_7 Field label Form data: 7th field value Description Value of the 7th field of the form Field type dimension Data type string.text.valueform_data_name_8 Field label Form data: 8th field name Description Name of 8th field of the form Field type dimension Data type string.text.valueform_data_value_8 Field label Form data: 8th field value Description Value of the 8th field of the form Field type dimension Data type string.text.valueform_data_name_9 Field label Form data: 9th field name Description Name of 9th field of the form Field type dimension Data type string.text.valueform_data_value_9 Field label Form data: 9th field value Description Value of the 9th field of the form Field type dimension Data type string.text.valueform_data_name_10 Field label Form data: 10th field name Description Name of 10th field of the form Field type dimension Data type string.text.valueform_data_value_10 Field label Form data: 10th field value Description Value of the 10th field of the form Field type dimension Data type string.text.valueform_data_name_11 Field label Form data: 11th field name Description Name of 11th field of the form Field type dimension Data type string.text.valueform_data_value_11 Field label Form data: 11th field value Description Value of the 11th field of the form Field type dimension Data type string.text.valueform_data_name_12 Field label Form data: 12th field name Description Name of 12th field of the form Field type dimension Data type string.text.valueform_data_value_12 Field label Form data: 12th field value Description Value of the 12th field of the form Field type dimension Data type string.text.valueFORM SUBMISSIONform_submission_id Field label Form submission ID Description Unique identifier for the form submission Field type dimension Data type string.text.valuefirst_form Field label First-time form Description Indicates whether this is the first form submitted from a person Field type dimension Data type boolform_submitted_date Field label Submitted date Description Server date when the form was submitted, in Y-m-d format Field type dimension Data type string.time.dateform_submitted_time Field label Submitted time Description Server time when the form was submitted Field type dimension Data type string.text.valueLEADlead_status Field label 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.valuegood_lead_call_id Field label 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.valuegood_lead_call_time Field label 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.valueleads Field label Leads Description Number of new leads, based on being scored as a good lead Field type metric Data type int.number.valuelead_rate Field label Lead rate Description Portion of first time callers marked as good leads. Calculated by: (Leads / First time callers) * 100 Field type metric Data type float.number.percentagePROPERTIESnote Field label Note Description Any text notes to associate with this call or form submission Field type dimension Data type string.text.valuetags Field label Tags Description Any tags which have been applied to this call or form submission Field type dimension Data type string.text.valuevalue Field label Value Description A number representing the value of this call or form submission Field type dimension Data type string.text.valueQUERYsystem_metadata.query_date_range_start Field label Start date Description The start date of the requested query Field type dimension Data type string.time.datesystem_metadata.query_date_range_end Field label End date Description The end date of the requested query Field type dimension Data type string.time.datesystem_metadata.query_timezone Field label Timezone Description The timezone that is supplied to the query Field type dimension Data type string.time.timezonesystem_metadata.query_filters Field label Filters Description All filters used in the query Field type dimension Data type string.text.jsonsystem_metadata.query_date_start Field label Start Description When the query was started Field type dimension Data type string.time.datetimesystem_metadata.query_date_end Field label End Description When the query completed Field type dimension Data type string.time.datetimesystem_metadata.query_duration Field label Duration Description The duration in seconds of the query Field type dimension Data type int.duration.secondssystem_metadata.query_accounts Field label Accounts Description A list of accounts of which the data was pulled from Field type dimension Data type string.text.jsonRECORDINGrecording_player Field label Recording player URL Description The URL for a stand-alone recording player for this call, if available Field type dimension Data type string.text.urlrecording_duration Field label Recording duration (sec) Description The length in seconds of the recording, if available Field type dimension Data type string.text.urlwaveforms Field label 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.valueSOURCEsource Field label Source Description The marketing source that led to the phone call Field type dimension Data type string.text.valuemedium Field label Medium Description "PPC" or "Organic", available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valuekeywords Field label 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.valuereferring_url Field label 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.valuereferrer_domain Field label 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.valuecampaign Field label Campaign Description The name of the campaign the call belongs to Field type dimension Data type string.text.valuelanding_page_url Field label 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.urllast_requested_url Field label 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.urlutm_source Field label 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.valueutm_medium Field label 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.valueutm_term Field label 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.valueutm_content Field label 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.valueutm_campaign Field label 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.valueutma Field label Utma Description Google Analytics _utma value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valueutmb Field label Utmb Description Google Analytics _utmb value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valueutmc Field label Utmc Description Google Analytics _utmc value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valueutmv Field label Utmv Description Google Analytics _utmv value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valueutmz Field label Utmz Description Google Analytics _utmz value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valuega Field label Ga Description Google Universal Analytics _ga value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.valuegclid Field label 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.valuefbclid Field label 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.valuereferrer Field label Referrer Description Name of the referring entity, e.g. google_paid Field type dimension Data type string.text.valueTIMEtoday Field label Today Description Today's date, e.g. 2017-01-31 Field type dimension Data type string.time.date Destinations API, Data warehouse year Field label Year Description Year, e.g. 2017 Field type dimension Data type string.time.yearyearofweek Field label Year of week (Sun-Sat) Description Year of week for US-style Sunday-Saturday weeks, e.g. 2017 Field type dimension Data type string.time.yearyearofweekiso Field label Year of week (Mon-Sun) Description Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 Field type dimension Data type string.time.yearyearmonth Field label Year & month Description Year and month, e.g. 2017|06 Field type dimension Data type string.time.yearmonthmonth Field label Month Description Month, e.g. 6 Field type dimension Data type string.time.monthyearweek Field label Year & week (Sun-Sat) Description Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 Field type dimension Data type string.time.yearweekyearweekiso Field label Year & week (Mon-Sun) Description Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 Field type dimension Data type string.time.yearweekisoweek Field label Week (Sat-Sun) Description US week number, e.g. 51 Field type dimension Data type string.time.weekweekiso Field label Week (Mon-Sun) Description ISO week number, e.g. 51 Field type dimension Data type string.time.weekisodayofmonth Field label Day of month Description Day of month, e.g. 2 Field type dimension Data type string.time.dayofmonthdayofweekname Field label Day of week (Sun-Sat) Description Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday Field type dimension Data type string.time.dayofweekdayofweeknameiso Field label Day of week (Mon-Sun) Description Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday Field type dimension Data type string.time.dayofweekisodate Field label Date Description Date, e.g. 2017-01-31 Field type dimension Data type string.time.datehour Field label Hour Description Hour in a 24-hour clock, e.g. 18 Field type dimension Data type string.time.hourVALUEavg_value Field label Average value Description Average value of a call. Calculated by: Total value / Calls Field type metric Data type float.currency.valuetotal_value Field label Total value Description Total monetary value of all calls or form submissions Field type metric Data type float.currency.value