Guides
Shape Help Center

CallRail Fields

Suggest Edits

Dimensions (93)

Account

NinjaCat System ID: call_rail_v2:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Agent Email

API Name: agent_email
NinjaCat System ID: call_rail_v2:DIM_agent_email
Data Type: text

Answered

API Name: answered
NinjaCat System ID: call_rail_v2:DIM_answered
Data Type: text

Business Phone Number

API Name: business_phone_number
NinjaCat System ID: call_rail_v2:DIM_business_phone_number
Data Type: text
Display As: phone_number

Call Duration

API Name: duration
NinjaCat System ID: call_rail_v2:DIM_call_duration_dim
Data Type: text

Call Highlights

API Name: call_highlights
NinjaCat System ID: call_rail_v2:DIM_call_highlights
Data Type: text

Call Summary

API Name: call_summary
NinjaCat System ID: call_rail_v2:DIM_call_summary
Data Type: text

call type

API Name: call_type
NinjaCat System ID: call_rail_v2:DIM_call_type
Data Type: text
Aggregates To: DIM_CALL_STATUS

campaign

API Name: campaign
NinjaCat System ID: call_rail_v2:DIM_campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Company Id

API Name: company_id
NinjaCat System ID: call_rail_v2:DIM_company_id
Data Type: text

Company Name

API Name: company_name
NinjaCat System ID: call_rail_v2:DIM_company_name
Data Type: text

Company Time Zone

API Name: company_time_zone
NinjaCat System ID: call_rail_v2:DIM_company_time_zone
Data Type: text

Created At

API Name: created_at
NinjaCat System ID: call_rail_v2:DIM_created_at
Data Type: text

Currency

NinjaCat System ID: call_rail_v2:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

customer city

API Name: customer_city
NinjaCat System ID: call_rail_v2:DIM_customer_city
Data Type: text
Aggregates To: DIM_CITY

Customer Country

API Name: customer_country
NinjaCat System ID: call_rail_v2:DIM_customer_country
Data Type: text

customer name

API Name: customer_name
NinjaCat System ID: call_rail_v2:DIM_customer_name
Data Type: text
Aggregates To: DIM_CALLER_NAME

customer phone number

API Name: customer_phone_number
NinjaCat System ID: call_rail_v2:DIM_customer_phone_number
Data Type: text
Display As: phone_number
Aggregates To: DIM_CALLER_NUMBER

customer state

API Name: customer_state
NinjaCat System ID: call_rail_v2:DIM_customer_state
Data Type: text
Aggregates To: DIM_STATE_PROVINCE

Data Source

NinjaCat System ID: call_rail_v2:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

Date

API Name: date
NinjaCat System ID: call_rail_v2:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: call_rail_v2:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: call_rail_v2:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

Device Type

API Name: device_type
NinjaCat System ID: call_rail_v2:DIM_device_type
Data Type: text

Direction

API Name: direction
NinjaCat System ID: call_rail_v2:DIM_direction
Data Type: text

External Id

NinjaCat System ID: call_rail_v2:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

Fbclid

API Name: fbclid
NinjaCat System ID: call_rail_v2:DIM_fbclid
Data Type: text

First Call

API Name: first_call
NinjaCat System ID: call_rail_v2:DIM_first_call
Data Type: text

First Touch

API Name: first_touch
NinjaCat System ID: call_rail_v2:DIM_first_touch
Data Type: text

Formatted Business Phone Number

API Name: formatted_business_phone_number
NinjaCat System ID: call_rail_v2:DIM_formatted_business_phone_number
Data Type: text

Formatted Call Type

API Name: formatted_call_type
NinjaCat System ID: call_rail_v2:DIM_formatted_call_type
Data Type: text

Formatted Customer Location

API Name: formatted_customer_location
NinjaCat System ID: call_rail_v2:DIM_formatted_customer_location
Data Type: text

Formatted Customer Name

API Name: formatted_customer_name
NinjaCat System ID: call_rail_v2:DIM_formatted_customer_name
Data Type: text

Formatted Customer Name Or Phone Number

API Name: formatted_customer_name_or_phone_number
NinjaCat System ID: call_rail_v2:DIM_formatted_customer_name_or_phone_number
Data Type: text

Formatted Customer Phone Number

API Name: formatted_customer_phone_number
NinjaCat System ID: call_rail_v2:DIM_formatted_customer_phone_number
Data Type: text

Formatted Duration

API Name: formatted_duration
NinjaCat System ID: call_rail_v2:DIM_formatted_duration
Data Type: text

Formatted Tracking Phone Number

API Name: formatted_tracking_phone_number
NinjaCat System ID: call_rail_v2:DIM_formatted_tracking_phone_number
Data Type: text

Formatted Tracking Source

API Name: formatted_tracking_source
NinjaCat System ID: call_rail_v2:DIM_formatted_tracking_source
Data Type: text

Formatted Value

API Name: formatted_value
NinjaCat System ID: call_rail_v2:DIM_formatted_value
Data Type: text

Ga

API Name: ga
NinjaCat System ID: call_rail_v2:DIM_ga
Data Type: text

Gclid

API Name: gclid
NinjaCat System ID: call_rail_v2:DIM_gclid
Data Type: text

Good Lead Call Id

API Name: good_lead_call_id
NinjaCat System ID: call_rail_v2:DIM_good_lead_call_id
Data Type: text

Good Lead Call Time

API Name: good_lead_call_time
NinjaCat System ID: call_rail_v2:DIM_good_lead_call_time
Data Type: text

Hour Of Day

API Name: HOUR_OF_DAY
NinjaCat System ID: call_rail_v2:DIM_HOUR_OF_DAY
Data Type: integer
Aggregates To: DIM_HOUR_OF_DAY

Id

API Name: id
NinjaCat System ID: call_rail_v2:DIM_id
Data Type: text

Keypad Entries

API Name: keypad_entries
NinjaCat System ID: call_rail_v2:DIM_keypad_entries
Data Type: text

keywords

API Name: keywords
NinjaCat System ID: call_rail_v2:DIM_keywords
Data Type: text
Aggregates To: DIM_KEYWORDS

Landing Page Url

API Name: landing_page_url
NinjaCat System ID: call_rail_v2:DIM_landing_page_url
Data Type: text

Last Requested Url

API Name: last_requested_url
NinjaCat System ID: call_rail_v2:DIM_last_requested_url
Data Type: text

Last Touch

API Name: last_touch
NinjaCat System ID: call_rail_v2:DIM_last_touch
Data Type: text

Lead Created

API Name: lead_created
NinjaCat System ID: call_rail_v2:DIM_lead_created
Data Type: text

Lead Status

API Name: lead_status
NinjaCat System ID: call_rail_v2:DIM_lead_status
Data Type: text

Medium

API Name: medium
NinjaCat System ID: call_rail_v2:DIM_medium
Data Type: text

Milestones

API Name: milestones
NinjaCat System ID: call_rail_v2:DIM_milestones
Data Type: text

Month Of Year

NinjaCat System ID: call_rail_v2:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Msclkid

API Name: msclkid
NinjaCat System ID: call_rail_v2:DIM_msclkid
Data Type: text

Network

NinjaCat System ID: call_rail_v2:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Note

API Name: note
NinjaCat System ID: call_rail_v2:DIM_note
Data Type: text

Prior Calls

API Name: prior_calls
NinjaCat System ID: call_rail_v2:DIM_prior_calls
Data Type: text

Qualified

API Name: qualified
NinjaCat System ID: call_rail_v2:DIM_qualified
Data Type: text

Quarter

NinjaCat System ID: call_rail_v2:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

recording

API Name: recording
NinjaCat System ID: call_rail_v2:DIM_recording
Data Type: text
Display As: audio_url
Aggregates To: DIM_RECORDING_URL

Recording Duration

API Name: recording_duration
NinjaCat System ID: call_rail_v2:DIM_recording_duration
Data Type: text

Recording Player

API Name: recording_player
NinjaCat System ID: call_rail_v2:DIM_recording_player
Data Type: text

Referrer Domain

API Name: referrer_domain
NinjaCat System ID: call_rail_v2:DIM_referrer_domain
Data Type: text

Referring Url

API Name: referring_url
NinjaCat System ID: call_rail_v2:DIM_referring_url
Data Type: text

Row

NinjaCat System ID: call_rail_v2:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

Source

API Name: source
NinjaCat System ID: call_rail_v2:DIM_source
Data Type: text

Source Name

API Name: source_name
NinjaCat System ID: call_rail_v2:DIM_source_name
Data Type: text

Speaker Percent Agent

API Name: speaker_percent_agent
NinjaCat System ID: call_rail_v2:DIM_speaker_percent_agent
Data Type: decimal
Display As: percent

Speaker Percent Customer

API Name: speaker_percent_customer
NinjaCat System ID: call_rail_v2:DIM_speaker_percent_customer
Data Type: decimal
Display As: percent

start time

API Name: start_time
NinjaCat System ID: call_rail_v2:DIM_start_time
Data Type: datetime
Display As: date_time
Aggregates To: DIM_CALL_TIME

System Account ID

NinjaCat System ID: call_rail_v2:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Tags

API Name: tags
NinjaCat System ID: call_rail_v2:DIM_tags
Data Type: text

Timeline Url

API Name: timeline_url
NinjaCat System ID: call_rail_v2:DIM_timeline_url
Data Type: text

Total Calls

API Name: total_calls
NinjaCat System ID: call_rail_v2:DIM_total_calls
Data Type: text

Tracker Id

API Name: tracker_id
NinjaCat System ID: call_rail_v2:DIM_tracker_id
Data Type: text

tracking phone number

API Name: tracking_phone_number
NinjaCat System ID: call_rail_v2:DIM_tracking_phone_number
Data Type: text
Display As: phone_number
Aggregates To: DIM_TRACKING_NUMBER

Utma

API Name: utma
NinjaCat System ID: call_rail_v2:DIM_utma
Data Type: text

Utmb

API Name: utmb
NinjaCat System ID: call_rail_v2:DIM_utmb
Data Type: text

Utmc

API Name: utmc
NinjaCat System ID: call_rail_v2:DIM_utmc
Data Type: text

Utm Campaign

API Name: utm_campaign
NinjaCat System ID: call_rail_v2:DIM_utm_campaign
Data Type: text

Utm Content

API Name: utm_content
NinjaCat System ID: call_rail_v2:DIM_utm_content
Data Type: text

Utm Medium

API Name: utm_medium
NinjaCat System ID: call_rail_v2:DIM_utm_medium
Data Type: text

Utm Source

API Name: utm_source
NinjaCat System ID: call_rail_v2:DIM_utm_source
Data Type: text

Utm Term

API Name: utm_term
NinjaCat System ID: call_rail_v2:DIM_utm_term
Data Type: text

Utmv

API Name: utmv
NinjaCat System ID: call_rail_v2:DIM_utmv
Data Type: text

Utmz

API Name: utmz
NinjaCat System ID: call_rail_v2:DIM_utmz
Data Type: text

Value

API Name: value
NinjaCat System ID: call_rail_v2:DIM_value
Data Type: text

Voicemail

API Name: voicemail
NinjaCat System ID: call_rail_v2:DIM_voicemail
Data Type: text

Waveforms

API Name: waveforms
NinjaCat System ID: call_rail_v2:DIM_waveforms
Data Type: text

Week Of Year

NinjaCat System ID: call_rail_v2:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: call_rail_v2:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (12)

Answered Calls

API Name: answered_call_count
NinjaCat System ID: call_rail_v2:MET_answered_call_count
Data Type: integer
Aggregates To: MET_ANSWERED_CALLS

Calls

API Name: call_count
NinjaCat System ID: call_rail_v2:MET_call_count
Data Type: integer
Aggregates To: MET_CALLS

Conversion by Duration

API Name: is_conversion_duration
NinjaCat System ID: call_rail_v2:MET_is_conversion_duration
Data Type: integer

Conversions

API Name: conversion_count
NinjaCat System ID: call_rail_v2:MET_conversion_count
Data Type: integer
Aggregates To: MET_CONVERSIONS

Count (Unique Dimensions)

NinjaCat System ID: call_rail_v2:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

Current Customers

API Name: current_customer_count
NinjaCat System ID: call_rail_v2:MET_current_customer_count
Data Type: integer

Duration

API Name: duration
NinjaCat System ID: call_rail_v2:MET_duration
Data Type: integer
Aggregates To: MET_CALL_DURATION

Leads

API Name: lead_count
NinjaCat System ID: call_rail_v2:MET_lead_count
Data Type: integer

Missed Call %

NinjaCat System ID: call_rail_v2:MET_MISSED_CALL_PCT
Data Type: decimal
Display As: percent
Formula: call_rail_v2:MET_missed_count / call_rail_v2:MET_call_count

Missed Calls

API Name: missed_count
NinjaCat System ID: call_rail_v2:MET_missed_count
Data Type: integer
Aggregates To: MET_MISSED_CALLS

Unique Caller

API Name: is_nc_unique_caller
NinjaCat System ID: call_rail_v2:MET_is_nc_unique_caller
Data Type: integer

Voicemails

API Name: voicemail_count
NinjaCat System ID: call_rail_v2:MET_voicemail_count
Data Type: integer

Updated 6 months ago