Supermetrics brings all your CallRail data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure17 metrics115 dimensionsSearch fields×CALL call_id Field label Call ID Field type dimension Data type string.text.value call_details_url Field label Call details link Field type dimension Data type string.text.url start_time Field label Call start time Field type dimension Data type string.text.value direction 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.value answered Field label Was answered Description Whether the call was answered Field type dimension Data type bool voicemail Field label Voicemail Description Whether the call ended with a voicemail (true) or not (false) Field type dimension Data type bool formatted_duration Field label Call duration (sec) Description The duration of the call in seconds Field type dimension Data type int.duration.seconds first_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 bool prior_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.value total_calls Field label Total calls Description The total number of calls received from a customer phone number Field type dimension Data type string.text.value speaker_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.json keywords_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.value call_highlights Field label Call highlights Description A list of relevant keywords automatically found in the call transcription Field type dimension Data type string.text.value business_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.phone source_name Field label Number name Description The name of the tracking number within CallRail Field type dimension Data type string.text.value agent_email Field label Agent email Description Email address for the user who answered the call, when applicable Field type dimension Data type string.text.email tracking_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.phone tracker_id Field label Tracker ID Field type dimension Data type string.text.value calls Field label Calls Description Total number of calls Field type metric Data type int.number.value answered_calls Field label Answered calls Description Number of calls that were answered Field type metric Data type int.number.value answer_rate Field label Answer rate Description Percentage of calls that were answered Field type metric Data type float.number.percentage missed_calls Field label Missed calls Description Number of missed calls Field type metric Data type int.number.value abandoned_calls Field label Abandoned calls Description Number of calls that lasted for less than 15 seconds Field type metric Data type int.number.value voicemail_calls Field label Voicemail calls Description Number of calls going to voicemail Field type metric Data type int.number.value first_time_callers Field label First time callers Description Number of calls that were answered Field type metric Data type int.number.value inbound_calls Field label Inbound calls Description Number of inbound calls Field type metric Data type int.number.value outbound_calls Field label Outbound calls Description Number of outbound calls Field type metric Data type int.number.value avg_duration Field label Avg. call duration (sec) Description Average duration of a call Field type metric Data type float.number.value duration Field label Total call duration (sec) Description Total duration of all calls Field type metric Data type int.duration.secondsCOMPANY company_id Field label Company ID Description The string id of the company the call belongs to Field type dimension Data type string.text.value company_name Field label Company name Description The name of the company the source belongs to Field type dimension Data type string.text.value company_time_zone Field label Company time zone Description The configure time zone of the company in CallRail Field type dimension Data type string.text.valueCUSTOMER formatted_customer_name Field label Customer name Description The customer’s name, as reported by Caller ID Field type dimension Data type string.text.value customer_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.city customer_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.region customer_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.twolettercode customer_phone_number Field label Customer phone number Description The customer’s phone number (in E.164 format) Field type dimension Data type string.text.phone device_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.valueDATASOURCE dataSourceName 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.json system_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.jsonFORM form_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.value form_url Field label Form URL Description The URL that the form was submitted to Field type dimension Data type string.text.url form_submissions Field label Form submissions Description Number of form submissions Field type metric Data type int.number.value first_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 DATA form_data Field label Form data Description Object that captures all of the form fields and values Field type dimension Data type string.text.json form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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.value form_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 SUBMISSION form_submission_id Field label Form submission ID Description Unique identifier for the form submission Field type dimension Data type string.text.value first_form Field label First-time form Description Indicates whether this is the first form submitted from a person Field type dimension Data type bool form_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.date form_submitted_time Field label Submitted time Description Server time when the form was submitted Field type dimension Data type string.text.valueLEAD lead_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.value good_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.value good_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.value leads Field label Leads Description Number of new leads Field type metric Data type int.number.value lead_rate Field label Lead rate Description Portion of first time callers marked as good leads Field type metric Data type float.number.percentagePROPERTIES note Field label Note Description Any text notes to associate with this call or form submission Field type dimension Data type string.text.value tags Field label Tags Description Any tags which have been applied to this call or form submission Field type dimension Data type string.text.value value Field label Value Description A number representing the value of this call or form submission Field type dimension Data type string.text.valueQUERY system_metadata.query_date_range_start Field label Start date Description The start date of the requested query Field type dimension Data type string.time.date system_metadata.query_date_range_end Field label End date Description The end date of the requested query Field type dimension Data type string.time.date system_metadata.query_timezone Field label Timezone Description The timezone that is supplied to the query Field type dimension Data type string.time.timezone system_metadata.query_filters Field label Filters Description All filters used in the query Field type dimension Data type string.text.json system_metadata.query_date_start Field label Start Description When the query was started Field type dimension Data type string.time.datetime system_metadata.query_date_end Field label End Description When the query completed Field type dimension Data type string.time.datetime system_metadata.query_duration Field label Duration Description The duration in seconds of the query Field type dimension Data type int.duration.seconds system_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.jsonRECORDING recording_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.url recording_duration Field label Recording duration (sec) Description The length in seconds of the recording, if available Field type dimension Data type string.text.url waveforms 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.valueSOURCE source Field label Source Description The marketing source that led to the phone call Field type dimension Data type string.text.value medium Field label Medium Description "PPC" or "Organic", available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value keywords 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.value referring_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.value referrer_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.value campaign Field label Campaign Description The name of the campaign the call belongs to Field type dimension Data type string.text.value landing_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.url last_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.url utm_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.value utm_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.value utm_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.value utm_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.value utm_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.value utma Field label Utma Description Google Analytics _utma value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value utmb Field label Utmb Description Google Analytics _utmb value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value utmc Field label Utmc Description Google Analytics _utmc value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value utmv Field label Utmv Description Google Analytics _utmv value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value utmz Field label Utmz Description Google Analytics _utmz value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value ga Field label Ga Description Google Universal Analytics _ga value, available for calls placed to Keyword (Session) trackers Field type dimension Data type string.text.value gclid 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.value fbclid 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.value referrer Field label Referrer Description Name of the referring entity, e.g. google_paid Field type dimension Data type string.text.valueTIME today 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.year yearOfWeek 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.year yearOfWeekIso 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.year yearMonth Field label Year & month Description Year and month, e.g. 2017|06 Field type dimension Data type string.time.yearmonth month Field label Month Description Month, e.g. 6 Field type dimension Data type string.time.month yearWeek 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.yearweek yearWeekIso 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.yearweekiso week Field label Week (Sun-Sat) Description US week number, e.g. 51 Field type dimension Data type string.time.week weekIso Field label Week (Mon-Sun) Description ISO week number, e.g. 51 Field type dimension Data type string.time.weekiso dayOfMonth Field label Day of month Description Day of month, e.g. 2 Field type dimension Data type string.time.dayofmonth dayOfWeekName 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.dayofweek dayOfWeekNameIso 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.dayofweekiso date Field label Date Description Date, e.g. 2017-01-31 Field type dimension Data type string.time.date hour Field label Hour Description Hour in a 24-hour clock, e.g. 18 Field type dimension Data type string.time.hourVALUE avg_value Field label Average value Description Average value of a call Field type metric Data type float.currency.value total_value Field label Total value Description Total value of all calls or form submissions Field type metric Data type float.currency.value