Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| Hour | hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| CUSTOMER | Customer name | formatted_customer_name | dim | The customer’s name, as reported by Caller ID |
| Customer city | customer_city | dim | The customer’s city, based on the original assigned location of their phone number | |
| Customer state | customer_state | dim | The 2-character abbreviation for the customer’s state, based on the original assigned location of their phone number | |
| Customer country | customer_country | dim | The customer’s country, based on the area code of their phone number | |
| Customer phone number | customer_phone_number | dim | The customer’s phone number (in E.164 format) | |
| Device type | device_type | dim | Either mobile or desktop, available for calls placed to Keyword (Session) trackers | |
| CALL | Call ID | call_id | dim | |
| Call details link | call_details_url | dim | ||
| Call start time | start_time | dim | ||
| Call direction | direction | dim | Whether the call was inbound (from a customer to you) or outbound (from you to a customer) | |
| Was answered | answered | dim | Whether the call was answered | |
| Voicemail | voicemail | dim | Whether the call ended with a voicemail (true) or not (false) | |
| Call duration (sec) | formatted_duration | dim | The duration of the call in seconds | |
| First-time call | first_call | dim | Whether or not the call is the caller’s first call to this company | |
| Prior calls | prior_calls | dim | 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 | |
| Total calls | total_calls | dim | The total number of calls received from a customer phone number | |
| Speaker percent | speaker_percent | dim | A JSON object containing the values of the percentage of time spent talking by the Agent and Customer on a call | |
| Keywords spotted | keywords_spotted | dim | Array of keywords spotted, each containing keyword with locations in seconds offset from beginning of recording | |
| Call highlights | call_highlights | dim | A list of relevant keywords automatically found in the call transcription | |
| Business phone number | business_phone_number | dim | The phone number of the person or business who answered the call from the dialed tracking number | |
| Number name | source_name | dim | The name of the tracking number within CallRail | |
| Agent email | agent_email | dim | Email address for the user who answered the call, when applicable | |
| Tracking phone number | tracking_phone_number | dim | The business’ tracking phone number for this call (in E.164 format) | |
| Tracker ID | tracker_id | dim | ||
| RECORDING | Recording player URL | recording_player | dim | The URL for a stand-alone recording player for this call, if available |
| Recording duration (sec) | recording_duration | dim | The length in seconds of the recording, if available | |
| Waveforms | waveforms | dim | Only present if the call was recorded. Contains the URLs of two images representing the volume of the call over time | |
| PROPERTIES | Note | note | dim | Any text notes to associate with this call or form submission |
| Tags | tags | dim | Any tags which have been applied to this call or form submission | |
| Value | value | dim | A number representing the value of this call or form submission | |
| LEAD | Lead status | lead_status | dim | The current lead status of this caller (as of this call). One of good_lead, not_a_lead, previously_marked_good_lead, or null |
| Good lead call ID | good_lead_call_id | dim | If provided, the id of the call that was originally scored as a good lead | |
| Good lead call time | good_lead_call_time | dim | If provided, the time of the call that was originally scored as a good lead | |
| SOURCE | Source | source | dim | The marketing source that led to the phone call |
| Medium | medium | dim | "PPC" or "Organic", available for calls placed to Keyword (Session) trackers | |
| Keywords | keywords | dim | The keywords the visitor searched for, if available for calls placed to Keyword (Session) trackers. Keywords only provided from paid ad sources | |
| Referring url | referring_url | dim | The URL that referred the caller to your website, available for calls placed to Keyword (Session) trackers | |
| Referrer domain | referrer_domain | dim | The domain that referred the caller to your website, available for calls placed to Keyword (Session) trackers | |
| Campaign | campaign | dim | The name of the campaign the call belongs to | |
| Landing page url | landing_page_url | dim | The URL the caller first landed on, available for calls placed to Keyword (Session) trackers | |
| Last requested url | last_requested_url | dim | The URL of the active page at the time the call was placed, available for calls placed to Keyword (Session) trackers | |
| Utm source | utm_source | dim | utm_source as captured from the landing page parameter for Session Trackers, or as specified in the configuration for Source Trackers | |
| Utm medium | utm_medium | dim | utm_medium as captured from the landing page parameter, or as specified in the configuration for Source Trackers | |
| Utm term | utm_term | dim | utm_term as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers | |
| Utm content | utm_content | dim | utm_content as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers | |
| Utm campaign | utm_campaign | dim | utm_campaign as captured from the landing page parameter, or as specified in the configuration for Source Trackers | |
| Utma | utma | dim | Google Analytics _utma value, available for calls placed to Keyword (Session) trackers | |
| Utmb | utmb | dim | Google Analytics _utmb value, available for calls placed to Keyword (Session) trackers | |
| Utmc | utmc | dim | Google Analytics _utmc value, available for calls placed to Keyword (Session) trackers | |
| Utmv | utmv | dim | Google Analytics _utmv value, available for calls placed to Keyword (Session) trackers | |
| Utmz | utmz | dim | Google Analytics _utmz value, available for calls placed to Keyword (Session) trackers | |
| Ga | ga | dim | Google Universal Analytics _ga value, available for calls placed to Keyword (Session) trackers | |
| Gclid | gclid | dim | gclid as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers | |
| Fbclid | fbclid | dim | fbclid as captured from the landing page parameter, available for calls placed to Keyword (Session) trackers | |
| COMPANY | Company ID | company_id | dim | The string id of the company the call belongs to |
| Company name | company_name | dim | The name of the company the source belongs to | |
| Company time zone | company_time_zone | dim | The configure time zone of the company in CallRail | |
| CALL | Calls | calls | met | Total number of calls |
| Answered calls | answered_calls | met | Number of calls that were answered | |
| Answer rate | answer_rate | met | Percentage of calls that were answered | |
| Missed calls | missed_calls | met | Number of missed calls | |
| Abandoned calls | abandoned_calls | met | Number of calls that lasted for less than 15 seconds | |
| Voicemail calls | voicemail_calls | met | Number of calls going to voicemail | |
| First time callers | first_time_callers | met | Number of calls that were answered | |
| Inbound calls | inbound_calls | met | Number of inbound calls | |
| Outbound calls | outbound_calls | met | Number of outbound calls | |
| Avg. call duration (sec) | avg_duration | met | Average duration of a call | |
| Total call duration (sec) | duration | met | Total duration of all calls | |
| VALUE | Average value | avg_value | met | Average value of a call |
| Total value | total_value | met | Total value of all calls or form submissions | |
| LEAD | Leads | leads | met | Number of new leads |
| Lead rate | lead_rate | met | Portion of first time callers marked as good leads | |
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| Hour | hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| FORM | Form name | form_name | dim | The name of the Custom Form responsible for the form capture, where applicable |
| Form URL | form_url | dim | The URL that the form was submitted to | |
| FORM SUBMISSION | Form submission ID | form_submission_id | dim | Unique identifier for the form submission |
| First-time form | first_form | dim | Indicates whether this is the first form submitted from a person | |
| Submitted date | form_submitted_date | dim | Server date when the form was submitted, in Y-m-d format | |
| Submitted time | form_submitted_time | dim | Server time when the form was submitted | |
| FORM DATA | Form data | form_data | dim | Object that captures all of the form fields and values |
| Form data: 1st field name | form_data_name_1 | dim | Name of 1st field of the form | |
| Form data: 1st field value | form_data_value_1 | dim | Value of the 1st field of the form | |
| Form data: 2nd field name | form_data_name_2 | dim | Name of 2nd field of the form | |
| Form data: 2nd field value | form_data_value_2 | dim | Value of the 2nd field of the form | |
| Form data: 3rd field name | form_data_name_3 | dim | Name of 3rd field of the form | |
| Form data: 3rd field value | form_data_value_3 | dim | Value of the 3rd field of the form | |
| Form data: 4th field name | form_data_name_4 | dim | Name of 4th field of the form | |
| Form data: 4th field value | form_data_value_4 | dim | Value of the 4th field of the form | |
| Form data: 5th field name | form_data_name_5 | dim | Name of 5th field of the form | |
| Form data: 5th field value | form_data_value_5 | dim | Value of the 5th field of the form | |
| Form data: 6th field name | form_data_name_6 | dim | Name of 6th field of the form | |
| Form data: 6th field value | form_data_value_6 | dim | Value of the 6th field of the form | |
| Form data: 7th field name | form_data_name_7 | dim | Name of 7th field of the form | |
| Form data: 7th field value | form_data_value_7 | dim | Value of the 7th field of the form | |
| Form data: 8th field name | form_data_name_8 | dim | Name of 8th field of the form | |
| Form data: 8th field value | form_data_value_8 | dim | Value of the 8th field of the form | |
| Form data: 9th field name | form_data_name_9 | dim | Name of 9th field of the form | |
| Form data: 9th field value | form_data_value_9 | dim | Value of the 9th field of the form | |
| Form data: 10th field name | form_data_name_10 | dim | Name of 10th field of the form | |
| Form data: 10th field value | form_data_value_10 | dim | Value of the 10th field of the form | |
| Form data: 11th field name | form_data_name_11 | dim | Name of 11th field of the form | |
| Form data: 11th field value | form_data_value_11 | dim | Value of the 11th field of the form | |
| Form data: 12th field name | form_data_name_12 | dim | Name of 12th field of the form | |
| Form data: 12th field value | form_data_value_12 | dim | Value of the 12th field of the form | |
| PROPERTIES | Note | note | dim | Any text notes to associate with this call or form submission |
| Tags | tags | dim | Any tags which have been applied to this call or form submission | |
| Value | value | dim | A number representing the value of this call or form submission | |
| LEAD | Lead status | lead_status | dim | The current lead status of this caller (as of this call). One of good_lead, not_a_lead, previously_marked_good_lead, or null |
| SOURCE | Source | source | dim | The marketing source that led to the phone call |
| Medium | medium | dim | "PPC" or "Organic", available for calls placed to Keyword (Session) trackers | |
| Keywords | keywords | dim | The keywords the visitor searched for, if available for calls placed to Keyword (Session) trackers. Keywords only provided from paid ad sources | |
| Referring url | referring_url | dim | The URL that referred the caller to your website, available for calls placed to Keyword (Session) trackers | |
| Campaign | campaign | dim | The name of the campaign the call belongs to | |
| Landing page url | landing_page_url | dim | The URL the caller first landed on, available for calls placed to Keyword (Session) trackers | |
| Utm source | utm_source | dim | utm_source as captured from the landing page parameter for Session Trackers, or as specified in the configuration for Source Trackers | |
| Utm medium | utm_medium | dim | utm_medium as captured from the landing page parameter, or as specified in the configuration for Source Trackers | |
| Utm campaign | utm_campaign | dim | utm_campaign as captured from the landing page parameter, or as specified in the configuration for Source Trackers | |
| Referrer | referrer | dim | Name of the referring entity, e.g. google_paid | |
| FORM | Form submissions | form_submissions | met | Number of form submissions |
| First-time submissions | first_form_submissions | met | Number of times where a form is submitted and is the first form submitted from a person | |
| VALUE | Total value | total_value | met | Total value of all calls or form submissions |
| LEAD | Leads | leads | met | Number of new leads |