Guides
Shape Help Center

Marchex Edge Fields

Suggest Edits

Dimensions (82)

Abandoned Status

API Name: abandoned_status
NinjaCat System ID: marchex_edge:DIM_abandoned_status
Data Type: text

Account

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

Answer Status

API Name: answer_status
NinjaCat System ID: marchex_edge:DIM_answer_status
Data Type: text

Answer Status Id

API Name: answer_status_id
NinjaCat System ID: marchex_edge:DIM_answer_status_id
Data Type: text

Answer Time

API Name: answer_time
NinjaCat System ID: marchex_edge:DIM_answer_time
Data Type: datetime
Display As: date_time

Answer Time Utc

API Name: answer_time_utc
NinjaCat System ID: marchex_edge:DIM_answer_time_utc
Data Type: datetime
Display As: date_time

Billing Group Id

API Name: billing_group_id
NinjaCat System ID: marchex_edge:DIM_billing_group_id
Data Type: text

Billing Group Name

API Name: billing_group_name
NinjaCat System ID: marchex_edge:DIM_billing_group_name
Data Type: text

Call Duration

API Name: call_duration
NinjaCat System ID: marchex_edge:DIM_call_duration_dim
Data Type: text

Caller Address

API Name: caller_address
NinjaCat System ID: marchex_edge:DIM_caller_address
Data Type: text

caller city

API Name: caller_city
NinjaCat System ID: marchex_edge:DIM_caller_city
Data Type: text
Aggregates To: DIM_CITY

Caller Country

API Name: caller_country
NinjaCat System ID: marchex_edge:DIM_caller_country
Data Type: text

Caller Identity

API Name: caller_identity
NinjaCat System ID: marchex_edge:DIM_caller_identity
Data Type: text

Caller Latitude

API Name: caller_latitude
NinjaCat System ID: marchex_edge:DIM_caller_latitude
Data Type: text

Caller Longitude

API Name: caller_longitude
NinjaCat System ID: marchex_edge:DIM_caller_longitude
Data Type: text

caller name

API Name: caller_name
NinjaCat System ID: marchex_edge:DIM_caller_name
Data Type: text
Aggregates To: DIM_CALLER_NAME

caller number

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

caller state

API Name: caller_state
NinjaCat System ID: marchex_edge:DIM_caller_state
Data Type: text
Aggregates To: DIM_STATE_PROVINCE

Caller Type

API Name: caller_type
NinjaCat System ID: marchex_edge:DIM_caller_type
Data Type: text

caller zip code

API Name: caller_zip_code
NinjaCat System ID: marchex_edge:DIM_caller_zip_code
Data Type: text
Aggregates To: DIM_POSTAL_CODE

Call Record File

API Name: call_record_file
NinjaCat System ID: marchex_edge:DIM_call_record_file
Data Type: text

Call Record Redaction

API Name: call_record_redaction
NinjaCat System ID: marchex_edge:DIM_call_record_redaction
Data Type: text

Call Summary

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

Call Type

API Name: call_type
NinjaCat System ID: marchex_edge:DIM_call_type
Data Type: text

Call Type Id

API Name: call_type_id
NinjaCat System ID: marchex_edge:DIM_call_type_id
Data Type: text

Currency

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

Current Customer Status

API Name: current_customer_status
NinjaCat System ID: marchex_edge:DIM_current_customer_status
Data Type: text

Data Source

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

Date

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

Day Of Month

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

Day Of Week

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

End Time

API Name: end_time
NinjaCat System ID: marchex_edge:DIM_end_time
Data Type: datetime
Display As: date_time

End Time Utc

API Name: end_time_utc
NinjaCat System ID: marchex_edge:DIM_end_time_utc
Data Type: datetime
Display As: date_time

External Id

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

Gclid

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

Group Id

API Name: group_id
NinjaCat System ID: marchex_edge:DIM_group_id
Data Type: text

Group Name

API Name: group_name
NinjaCat System ID: marchex_edge:DIM_group_name
Data Type: text

Group Owner Id

API Name: group_owner_id
NinjaCat System ID: marchex_edge:DIM_group_owner_id
Data Type: text

Group Owner Name

API Name: group_owner_name
NinjaCat System ID: marchex_edge:DIM_group_owner_name
Data Type: text

Hour Of Day

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

Id

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

Landing Page Url

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

Lead Status

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

Month Of Year

NinjaCat System ID: marchex_edge: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: marchex_edge:DIM_msclkid
Data Type: text

Network

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

Number Id

API Name: number_id
NinjaCat System ID: marchex_edge:DIM_number_id
Data Type: text

Number Pool Id

API Name: number_pool_id
NinjaCat System ID: marchex_edge:DIM_number_pool_id
Data Type: text

Opportunity Status

API Name: opportunity_status
NinjaCat System ID: marchex_edge:DIM_opportunity_status
Data Type: text

Organization Id

API Name: organization_id
NinjaCat System ID: marchex_edge:DIM_organization_id
Data Type: text

Quarter

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

Referrer Url

API Name: referrer_url
NinjaCat System ID: marchex_edge:DIM_referrer_url
Data Type: text

Registered Dnc

API Name: registered_DNC
NinjaCat System ID: marchex_edge:DIM_registered_DNC
Data Type: text

Ring Duration

API Name: ring_duration
NinjaCat System ID: marchex_edge:DIM_ring_duration_dim
Data Type: text

Routing Keypress

API Name: routing_keypress
NinjaCat System ID: marchex_edge:DIM_routing_keypress
Data Type: text

Row

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

Rule Description

API Name: rule_description
NinjaCat System ID: marchex_edge:DIM_rule_description
Data Type: text

Rule Id

API Name: rule_id
NinjaCat System ID: marchex_edge:DIM_rule_id
Data Type: text

Segment Name

API Name: segment_name
NinjaCat System ID: marchex_edge:DIM_segment_name
Data Type: text

Session Id

API Name: session_id
NinjaCat System ID: marchex_edge:DIM_session_id
Data Type: text

Session Identifier

API Name: session_identifier
NinjaCat System ID: marchex_edge:DIM_session_identifier
Data Type: text

start time

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

Start Time Utc

API Name: start_time_utc
NinjaCat System ID: marchex_edge:DIM_start_time_utc
Data Type: datetime
Display As: date_time

status

API Name: status
NinjaCat System ID: marchex_edge:DIM_status
Data Type: text
Aggregates To: DIM_CALL_STATUS

Study Name

API Name: study_name
NinjaCat System ID: marchex_edge:DIM_study_name
Data Type: text

System Account ID

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

Telemarketer Status

API Name: telemarketer_status
NinjaCat System ID: marchex_edge:DIM_telemarketer_status
Data Type: text

Termination Number

API Name: termination_number
NinjaCat System ID: marchex_edge:DIM_termination_number
Data Type: text
Display As: phone_number

Time Zone Id

API Name: time_zone_id
NinjaCat System ID: marchex_edge:DIM_time_zone_id
Data Type: text

Time Zone Name

API Name: time_zone_name
NinjaCat System ID: marchex_edge:DIM_time_zone_name
Data Type: text

tracking number

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

Transcript

API Name: transcript
NinjaCat System ID: marchex_edge:DIM_transcript
Data Type: text

utm campaign

API Name: utm_campaign
NinjaCat System ID: marchex_edge:DIM_utm_campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Utm Content

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

Utm Medium

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

Utm Source

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

utm term

API Name: utm_term
NinjaCat System ID: marchex_edge:DIM_utm_term
Data Type: text
Aggregates To: DIM_KEYWORDS

voice link

API Name: voice_link
NinjaCat System ID: marchex_edge:DIM_voice_link
Data Type: text
Display As: audio_url
Aggregates To: DIM_RECORDING_URL

Voicemail Status

API Name: voicemail_status
NinjaCat System ID: marchex_edge:DIM_voicemail_status
Data Type: text

Wbraid

API Name: wbraid
NinjaCat System ID: marchex_edge:DIM_wbraid
Data Type: text

Week Of Year

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

Year

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

Metrics (13)

Answered Calls

API Name: answered_call_count
NinjaCat System ID: marchex_edge:MET_answered_call_count
Data Type: integer

Call Duration

API Name: call_duration
NinjaCat System ID: marchex_edge:MET_call_duration
Data Type: text
Display As: time

Calls

API Name: call_count
NinjaCat System ID: marchex_edge:MET_call_count
Data Type: integer

Conversion by Duration

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

Conversions

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

Count (Unique Dimensions)

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

Current Customers

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

Leads

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

Missed Call %

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

Missed Calls

API Name: missed_count
NinjaCat System ID: marchex_edge:MET_missed_count
Data Type: integer

Ring Duration

API Name: ring_duration
NinjaCat System ID: marchex_edge:MET_ring_duration
Data Type: text
Display As: time

Unique Caller

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

Voicemails

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

Updated 6 months ago