Guides
Shape Help Center

CallTrackingMetrics Fields

Suggest Edits

Dimensions (77)

Account

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

Account Id

API Name: account_id
NinjaCat System ID: call_tracking_metrics_v2:DIM_account_id
Data Type: text

Agent Insights

API Name: agent_insights
NinjaCat System ID: call_tracking_metrics_v2:DIM_agent_insights
Data Type: text

Alternative Number

API Name: alternative_number
NinjaCat System ID: call_tracking_metrics_v2:DIM_alternative_number
Data Type: text
Display As: phone_number

Billed At

API Name: billed_at
NinjaCat System ID: call_tracking_metrics_v2:DIM_billed_at
Data Type: text

Business Label

API Name: business_label
NinjaCat System ID: call_tracking_metrics_v2:DIM_business_label
Data Type: text

Business Number

API Name: business_number
NinjaCat System ID: call_tracking_metrics_v2:DIM_business_number
Data Type: text
Display As: phone_number

Called At

API Name: called_at
NinjaCat System ID: call_tracking_metrics_v2:DIM_called_at
Data Type: datetime
Display As: date_time
Aggregates To: DIM_CALL_TIME

Caller Number

API Name: caller_number
NinjaCat System ID: call_tracking_metrics_v2:DIM_name
Data Type: text
Display As: phone_number
Aggregates To: DIM_CALLER_NUMBER

Call Status

API Name: audio
NinjaCat System ID: call_tracking_metrics_v2:DIM_audio
Data Type: text
Display As: audio_url
Aggregates To: DIM_RECORDING_URL

Call Status

API Name: call_status
NinjaCat System ID: call_tracking_metrics_v2:DIM_call_status
Data Type: text
Aggregates To: DIM_CALL_STATUS

Carrier

API Name: carrier
NinjaCat System ID: call_tracking_metrics_v2:DIM_carrier
Data Type: text

City

API Name: city
NinjaCat System ID: call_tracking_metrics_v2:DIM_city
Data Type: text
Aggregates To: DIM_CITY

Cnam

API Name: cnam
NinjaCat System ID: call_tracking_metrics_v2:DIM_cnam
Data Type: text

Contact Number

API Name: contact_number
NinjaCat System ID: call_tracking_metrics_v2:DIM_contact_number
Data Type: text
Display As: phone_number

Country

API Name: country
NinjaCat System ID: call_tracking_metrics_v2:DIM_country
Data Type: text

Currency

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

Dail Status

API Name: dial_status
NinjaCat System ID: call_tracking_metrics_v2:DIM_dial_status
Data Type: text

Data Source

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

Date

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

Day Of Month

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

Day Of Week

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

Direction

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

duration

API Name: duration
NinjaCat System ID: call_tracking_metrics_v2:DIM_duration
Data Type: text

Email

API Name: email
NinjaCat System ID: call_tracking_metrics_v2:DIM_email
Data Type: text

Excluded

API Name: excluded
NinjaCat System ID: call_tracking_metrics_v2:DIM_excluded
Data Type: text

Extended Lookup On

API Name: extended_lookup_on
NinjaCat System ID: call_tracking_metrics_v2:DIM_extended_lookup_on
Data Type: text

External Id

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

Ga Cid

API Name: ga_cid
NinjaCat System ID: call_tracking_metrics_v2:DIM_ga_cid
Data Type: text

Ga Events

API Name: ga_events
NinjaCat System ID: call_tracking_metrics_v2:DIM_ga_events
Data Type: text

Hour Of Day

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

Id

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

Indexed At

API Name: indexed_at
NinjaCat System ID: call_tracking_metrics_v2:DIM_indexed_at
Data Type: text

Is New Caller

API Name: is_new_caller
NinjaCat System ID: call_tracking_metrics_v2:DIM_is_new_caller
Data Type: text

Latitude

API Name: latitude
NinjaCat System ID: call_tracking_metrics_v2:DIM_latitude
Data Type: decimal
Display As: float
Aggregates To: DIM_LATITUDE

Left Talk Time

API Name: left_talk_time
NinjaCat System ID: call_tracking_metrics_v2:DIM_left_talk_time
Data Type: text

Likelihood

API Name: likelihood
NinjaCat System ID: call_tracking_metrics_v2:DIM_likelihood
Data Type: text

Location

API Name: location
NinjaCat System ID: call_tracking_metrics_v2:DIM_location
Data Type: text

Longitude

API Name: longitude
NinjaCat System ID: call_tracking_metrics_v2:DIM_longitude
Data Type: decimal
Display As: float
Aggregates To: DIM_LONGITUDE

Month Of Year

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

Network

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

Paid Campaign

API Name: paid_campaign
NinjaCat System ID: call_tracking_metrics_v2:DIM_paid_campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Paid Keyword

API Name: paid_keyword
NinjaCat System ID: call_tracking_metrics_v2:DIM_paid_keyword
Data Type: text
Aggregates To: DIM_KEYWORDS

Paid Medium

API Name: paid_medium
NinjaCat System ID: call_tracking_metrics_v2:DIM_paid_medium
Data Type: text

Paid Source

API Name: paid_source
NinjaCat System ID: call_tracking_metrics_v2:DIM_paid_source
Data Type: text

Parent Id

API Name: parent_id
NinjaCat System ID: call_tracking_metrics_v2:DIM_parent_id
Data Type: text

Quarter

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

Receiving Number Id

API Name: receiving_number_id
NinjaCat System ID: call_tracking_metrics_v2:DIM_receiving_number_id
Data Type: text

Receiving Number Sid

API Name: receiving_number_sid
NinjaCat System ID: call_tracking_metrics_v2:DIM_receiving_number_sid
Data Type: text

Redacted

API Name: redacted
NinjaCat System ID: call_tracking_metrics_v2:DIM_redacted
Data Type: text

Referrer

API Name: referrer
NinjaCat System ID: call_tracking_metrics_v2:DIM_referrer
Data Type: text

Right Talk Time

API Name: right_talk_time
NinjaCat System ID: call_tracking_metrics_v2:DIM_right_talk_time
Data Type: text

Row

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

Search

API Name: search
NinjaCat System ID: call_tracking_metrics_v2:DIM_search
Data Type: text

Sid

API Name: sid
NinjaCat System ID: call_tracking_metrics_v2:DIM_sid
Data Type: text

Source

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

Source Id

API Name: source_id
NinjaCat System ID: call_tracking_metrics_v2:DIM_source_id
Data Type: text

Source Sid

API Name: source_sid
NinjaCat System ID: call_tracking_metrics_v2:DIM_source_sid
Data Type: text

Spam Risk

API Name: spam_risk
NinjaCat System ID: call_tracking_metrics_v2:DIM_spam_risk
Data Type: text

Spam Score

API Name: spam_score
NinjaCat System ID: call_tracking_metrics_v2:DIM_spam_score
Data Type: text

State

API Name: state
NinjaCat System ID: call_tracking_metrics_v2:DIM_state
Data Type: text
Aggregates To: DIM_STATE_PROVINCE

Status

API Name: status
NinjaCat System ID: call_tracking_metrics_v2:DIM_status
Data Type: text

Street

API Name: street
NinjaCat System ID: call_tracking_metrics_v2:DIM_street
Data Type: text

System Account ID

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

Tags

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

Tgid

API Name: tgid
NinjaCat System ID: call_tracking_metrics_v2:DIM_tgid
Data Type: text

Tracking Label

API Name: tracking_label
NinjaCat System ID: call_tracking_metrics_v2:DIM_tracking_label
Data Type: text

Tracking Number

API Name: tracking_number
NinjaCat System ID: call_tracking_metrics_v2:DIM_tracking_number
Data Type: text
Display As: phone_number
Aggregates To: DIM_TRACKING_NUMBER

Tracking Number Bare

API Name: tracking_number_bare
NinjaCat System ID: call_tracking_metrics_v2:DIM_tracking_number_bare
Data Type: text

Tracking Number Id

API Name: tracking_number_id
NinjaCat System ID: call_tracking_metrics_v2:DIM_tracking_number_id
Data Type: text

Tracking Number Sid

API Name: tracking_number_sid
NinjaCat System ID: call_tracking_metrics_v2:DIM_tracking_number_sid
Data Type: text

Unix Time

API Name: unix_time
NinjaCat System ID: call_tracking_metrics_v2:DIM_unix_time
Data Type: text

Visitor

API Name: visitor
NinjaCat System ID: call_tracking_metrics_v2:DIM_visitor
Data Type: text

Visitor Sid

API Name: visitor_sid
NinjaCat System ID: call_tracking_metrics_v2:DIM_visitor_sid
Data Type: text

Week Of Year

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

Year

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

Zip/Postal Code

API Name: postal_code
NinjaCat System ID: call_tracking_metrics_v2:DIM_postal_code
Data Type: text
Aggregates To: DIM_POSTAL_CODE

Metrics (14)

Answered Calls

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

Billed Amount

API Name: billed_amount
NinjaCat System ID: call_tracking_metrics_v2:MET_billed_amount
Data Type: integer
Aggregates To: MET_COST

Calls

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

Conversion by Duration

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

Conversions

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

Count (Unique Dimensions)

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

Duration

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

Hold Time

API Name: hold_time
NinjaCat System ID: call_tracking_metrics_v2:MET_hold_time
Data Type: text
Display As: time

Missed Call %

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

Missed Calls

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

Ring Time

API Name: ring_time
NinjaCat System ID: call_tracking_metrics_v2:MET_ring_time
Data Type: text
Display As: time

Talk Time

API Name: talk_time
NinjaCat System ID: call_tracking_metrics_v2:MET_talk_time
Data Type: text
Display As: time

Unique Caller

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

Wait Time

API Name: wait_time
NinjaCat System ID: call_tracking_metrics_v2:MET_wait_time
Data Type: text
Display As: time

Updated 6 months ago