Guides
Shape Help Center

ApexChat Fields

Suggest Edits

Dimensions (67)

Account

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

Active

API Name: active
NinjaCat System ID: apexchat:DIM_active
Data Type: text

Agent Specified City

API Name: agentSpecifiedCity
NinjaCat System ID: apexchat:DIM_agentSpecifiedCity
Data Type: text

Agent Specified State

API Name: agentSpecifiedState
NinjaCat System ID: apexchat:DIM_agentSpecifiedState
Data Type: text

Agent Specified Zip

API Name: agentSpecifiedZip
NinjaCat System ID: apexchat:DIM_agentSpecifiedZip
Data Type: text

Applied Rule Name

API Name: appliedRuleName
NinjaCat System ID: apexchat:DIM_appliedRuleName
Data Type: text

Billable Leads Start Date

API Name: startDate
NinjaCat System ID: apexchat:DIM_startDate
Data Type: text

Category Id

API Name: categoryId
NinjaCat System ID: apexchat:DIM_categoryId
Data Type: text

Chat Id

API Name: chatId
NinjaCat System ID: apexchat:DIM_chatId
Data Type: text

Company Created Date

API Name: companyCreatedOn
NinjaCat System ID: apexchat:DIM_companyCreatedOn
Data Type: text

Company Id

API Name: companyId
NinjaCat System ID: apexchat:DIM_companyId
Data Type: text

Company Key

API Name: companyKey
NinjaCat System ID: apexchat:DIM_companyKey
Data Type: text

Company Name

API Name: companyName
NinjaCat System ID: apexchat:DIM_companyName
Data Type: text

Country

API Name: countryCode
NinjaCat System ID: apexchat:DIM_countryCode
Data Type: text
Aggregates To: DIM_COUNTRY

Currency

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

Data Source

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

Date

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

Day Of Month

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

Day Of Week

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

Dealership Department Id

API Name: dealershipDepartment
NinjaCat System ID: apexchat:DIM_dealershipDepartment
Data Type: text

Dealership Department Name

API Name: dealershipDepartmentName
NinjaCat System ID: apexchat:DIM_dealershipDepartmentName
Data Type: text

Denied Date

API Name: deniedDate
NinjaCat System ID: apexchat:DIM_deniedDate
Data Type: text

Domain

API Name: domain
NinjaCat System ID: apexchat:DIM_domain
Data Type: text

End Date

API Name: endedOn
NinjaCat System ID: apexchat:DIM_endedOn
Data Type: text
Aggregates To: DIM_END_DATE

External Id

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

Group Name

API Name: groupName
NinjaCat System ID: apexchat:DIM_groupName
Data Type: text

Host Name

API Name: hostName
NinjaCat System ID: apexchat:DIM_hostName
Data Type: text

Is SMS

API Name: isSMS
NinjaCat System ID: apexchat:DIM_isSMS
Data Type: text

Keywords

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

Landing Referrer

API Name: landingReferrer
NinjaCat System ID: apexchat:DIM_landingReferrer
Data Type: text

Lead Change Reason

API Name: leadChangeReason
NinjaCat System ID: apexchat:DIM_leadChangeReason
Data Type: text

Lead Email

API Name: leadEmail
NinjaCat System ID: apexchat:DIM_leadEmail
Data Type: text

Lead Id

API Name: leadId
NinjaCat System ID: apexchat:DIM_leadId
Data Type: text

Lead Name

API Name: leadName
NinjaCat System ID: apexchat:DIM_leadName
Data Type: text

Lead Notes

API Name: leadNotes
NinjaCat System ID: apexchat:DIM_leadNotes
Data Type: text

Lead Phone

API Name: leadPhone
NinjaCat System ID: apexchat:DIM_leadPhone
Data Type: text

Lead Type Id

API Name: leadType
NinjaCat System ID: apexchat:DIM_leadType
Data Type: text

Location

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

Make

API Name: make
NinjaCat System ID: apexchat:DIM_make
Data Type: text

Model

API Name: model
NinjaCat System ID: apexchat:DIM_model
Data Type: text

Month Of Year

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

Network

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

Notification Error

API Name: notificationError
NinjaCat System ID: apexchat:DIM_notificationError
Data Type: text

Notification State

API Name: notificationState
NinjaCat System ID: apexchat:DIM_notificationState
Data Type: text

Original Referrer

API Name: originalReferrer
NinjaCat System ID: apexchat:DIM_originalReferrer
Data Type: text

Picked Up On Date

API Name: pickedUpOn
NinjaCat System ID: apexchat:DIM_pickedUpOn
Data Type: text

Processed By Customer

API Name: processedByCustomer
NinjaCat System ID: apexchat:DIM_processedByCustomer
Data Type: text

Quarter

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

Referral Accepted

API Name: referralAccepted
NinjaCat System ID: apexchat:DIM_referralAccepted
Data Type: text

Referred Date

API Name: referredDate
NinjaCat System ID: apexchat:DIM_referredDate
Data Type: text

Referred To

API Name: referredTo
NinjaCat System ID: apexchat:DIM_referredTo
Data Type: text

Referrer

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

Region Id

API Name: regionId
NinjaCat System ID: apexchat:DIM_regionId
Data Type: text

Region Name

API Name: regionName
NinjaCat System ID: apexchat:DIM_regionName
Data Type: text
Aggregates To: DIM_REGION_NAME

Requested Lead Type

API Name: requestedLeadType
NinjaCat System ID: apexchat:DIM_requestedLeadType
Data Type: text

Row

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

Send By User Type

API Name: sentByUserType
NinjaCat System ID: apexchat:DIM_sentByUserType
Data Type: text

Sent By

API Name: sentBy
NinjaCat System ID: apexchat:DIM_sentBy
Data Type: text

Special Instructions

API Name: specialInstructions
NinjaCat System ID: apexchat:DIM_specialInstructions
Data Type: text

System Account ID

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

Transcript

NinjaCat System ID: apexchat:DIM_Transcript
Data Type: text
Display As: apexchat_transcript

Transcript Array

API Name: transcriptText
NinjaCat System ID: apexchat:DIM_transcriptText
Data Type: text

Used

API Name: used
NinjaCat System ID: apexchat:DIM_used
Data Type: text

Username

API Name: username
NinjaCat System ID: apexchat:DIM_username
Data Type: text

Week Of Year

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

Year

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

Year

API Name: year
NinjaCat System ID: apexchat:DIM_year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (28)

Agent Leads

API Name: agentLeads
NinjaCat System ID: apexchat:MET_agentLeads
Data Type: integer

Attempted Call Count

API Name: attemptedCallCount
NinjaCat System ID: apexchat:MET_attemptedCallCount
Data Type: integer

Attempted Calls

API Name: attemptedCalls
NinjaCat System ID: apexchat:MET_attemptedCalls
Data Type: integer

Billable Leads

API Name: billableLeads
NinjaCat System ID: apexchat:MET_billableLeads
Data Type: integer

Chat Count

API Name: chatCount
NinjaCat System ID: apexchat:MET_chatCount
Data Type: integer

Chats

API Name: chats
NinjaCat System ID: apexchat:MET_chats
Data Type: integer

Company Secure Leads

API Name: companySecureLeads
NinjaCat System ID: apexchat:MET_companySecureLeads
Data Type: integer

Completed Call Count

API Name: completedCallCount
NinjaCat System ID: apexchat:MET_completedCallCount
Data Type: integer

Completed Calls

API Name: completedCalls
NinjaCat System ID: apexchat:MET_completedCalls
Data Type: integer

Count (Unique Dimensions)

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

Denied

API Name: denied
NinjaCat System ID: apexchat:MET_denied
Data Type: integer

From Lead

API Name: chatLead
NinjaCat System ID: apexchat:MET_chatLead
Data Type: integer

Invited Visitors

API Name: invitedVisitors
NinjaCat System ID: apexchat:MET_invitedVisitors
Data Type: integer

Lead Count

API Name: leadCount
NinjaCat System ID: apexchat:MET_leadCount
Data Type: integer

Leads

API Name: leads
NinjaCat System ID: apexchat:MET_leads
Data Type: integer
Aggregates To: MET_LEADS

Operator Leads

API Name: operatorLeads
NinjaCat System ID: apexchat:MET_operatorLeads
Data Type: integer

Other Leads

API Name: otherLeads
NinjaCat System ID: apexchat:MET_otherLeads
Data Type: integer

Phone Chats

API Name: phoneChats
NinjaCat System ID: apexchat:MET_phoneChats
Data Type: integer

Phone Leads

API Name: phoneLeads
NinjaCat System ID: apexchat:MET_phoneLeads
Data Type: integer

Phone Visits

API Name: phoneVisits
NinjaCat System ID: apexchat:MET_phoneVisits
Data Type: integer

Referral Application Fee

API Name: referralApplicationFee
NinjaCat System ID: apexchat:MET_referralApplicationFee
Data Type: decimal
Display As: currency

Referral Cost

API Name: referralCost
NinjaCat System ID: apexchat:MET_referralCost
Data Type: decimal
Display As: currency

Referrals

API Name: referrals
NinjaCat System ID: apexchat:MET_referrals
Data Type: integer

Service Leads

API Name: serviceLeads
NinjaCat System ID: apexchat:MET_serviceLeads
Data Type: integer

Tablet Chats

API Name: tabletChats
NinjaCat System ID: apexchat:MET_tabletChats
Data Type: integer

Tablet Leads

API Name: tabletLeads
NinjaCat System ID: apexchat:MET_tabletLeads
Data Type: integer

Tablet Visits

API Name: tabletVisits
NinjaCat System ID: apexchat:MET_tabletVisits
Data Type: integer

Visits

API Name: visits
NinjaCat System ID: apexchat:MET_visits
Data Type: integer
Aggregates To: MET_VISITS

Updated 6 months ago