CallRail
Explore the interactive ERD
Table & Field Reference
form_submission
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
campaign | Unknown | |
customer_email | Unknown | |
customer_name | Unknown | |
customer_phone_number | Unknown | |
first_form | Unknown | |
form_url | Unknown | |
formatted_customer_name | Unknown | |
formatted_customer_phone_number | Unknown | |
keywords | Unknown | |
landing_page_url | Unknown | |
medium | Unknown | |
person_id | Unknown | |
referrer | Unknown | |
referring_url | Unknown | |
source | Unknown | |
submitted_at | Unknown | |
custom_** |
milestone
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
form_submission_id | Unknown | FK |
ad_position | Unknown | |
device | Unknown | |
event_date | Unknown | |
keywords | Unknown | |
landing | Unknown | |
landing_page_adgroup_id | Unknown | |
landing_page_campaign_id | Unknown | |
landing_page_creative | Unknown | |
landing_page_fbclid | Unknown | |
landing_page_gad_source | Unknown | |
landing_page_gbraid | Unknown | |
landing_page_gclid | Unknown | |
landing_page_network | Unknown | |
landing_page_placement | Unknown | |
match_type | Unknown | |
referrer | Unknown | |
referrer_url_param | Json | |
session_browser | Unknown | |
type | Unknown | |
utm_campaign | Unknown | |
utm_content | Unknown | |
utm_medium | Unknown | |
utm_source | Unknown |
summarized_call
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
account_id | Unknown | FK |
end_date | Unknown | |
start_date | Unknown | |
time_zone | Unknown | |
total_results_average_duration | Unknown | |
total_results_first_time_caller | Unknown | |
total_results_formatted_average_duration | Unknown | |
total_results_lead | Unknown | |
total_results_missed_call | Unknown | |
total_results_total_call | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
accepted | Unknown | |
created_at | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
name | Unknown | |
role | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
background_color | Unknown | |
color | Unknown | |
created_at | Unknown | |
name | Unknown | |
status | Unknown | |
tag_level | Unknown |
call
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
tracker_id | Unknown | FK |
agent_email | Unknown | |
answered | Unknown | |
business_phone_number | Unknown | |
campaign | Unknown | |
created_at | Unknown | |
customer_city | Unknown | |
customer_country | Unknown | |
customer_name | Unknown | |
customer_phone_number | Unknown | |
customer_state | Unknown | |
device_type | Unknown | |
direction | Unknown | |
duration | Unknown | |
first_call | Unknown | |
first_touch_ad_position | Unknown | |
first_touch_campaign | Unknown | |
first_touch_device | Unknown | |
first_touch_event_date | Unknown | |
first_touch_keywords | Unknown | |
first_touch_landing | Unknown | |
first_touch_landing_page_url_params | Unknown | |
first_touch_match_type | Unknown | |
first_touch_medium | Unknown | |
first_touch_referrer | Unknown | |
first_touch_referrer_url_params | Unknown | |
first_touch_session_browser | Unknown | |
first_touch_source | Unknown | |
first_touch_url_utm_params | Unknown | |
formatted_business_phone_number | Unknown | |
formatted_call_type | Unknown | |
formatted_customer_location | Unknown | |
formatted_customer_name | Unknown | |
formatted_customer_name_or_phone_number | Unknown | |
formatted_customer_phone_number | Unknown | |
formatted_duration | Unknown | |
formatted_tracking_phone_number | Unknown | |
formatted_tracking_source | Unknown | |
formatted_value | Unknown | |
ga | Unknown | |
gclid | Unknown | |
good_lead_call_id | Unknown | |
good_lead_call_time | Unknown | |
highlights | Json | |
keywords | Unknown | |
keywords_spotted | Json | |
landing_page_url | Unknown | |
last_requested_url | Unknown | |
last_touch_ad_position | Unknown | |
last_touch_campaign | Unknown | |
last_touch_device | Unknown | |
last_touch_event_date | Unknown | |
last_touch_keywords | Unknown | |
last_touch_landing | Unknown | |
last_touch_landing_page_url_params | Unknown | |
last_touch_match_type | Unknown | |
last_touch_medium | Unknown | |
last_touch_referrer | Unknown | |
last_touch_referrer_url_params | Unknown | |
last_touch_session_browser | Unknown | |
last_touch_source | Unknown | |
last_touch_url_utm_params | Unknown | |
lead_created_ad_position | Unknown | |
lead_created_campaign | Unknown | |
lead_created_device | Unknown | |
lead_created_event_date | Unknown | |
lead_created_keywords | Unknown | |
lead_created_landing | Unknown | |
lead_created_landing_page_url_params | Unknown | |
lead_created_match_type | Unknown | |
lead_created_medium | Unknown | |
lead_created_referrer | Unknown | |
lead_created_referrer_url_params | Unknown | |
lead_created_session_browser | Unknown | |
lead_created_source | Unknown | |
lead_created_url_utm_params | Unknown | |
lead_status | Unknown | |
medium | Unknown | |
note | Unknown | |
person_id | Unknown | |
prior_calls | Unknown | |
qualified_ad_position | Unknown | |
qualified_campaign | Unknown | |
qualified_device | Unknown | |
qualified_event_date | Unknown | |
qualified_keywords | Unknown | |
qualified_landing | Unknown | |
qualified_landing_page_url_params | Unknown | |
qualified_match_type | Unknown | |
qualified_medium | Unknown | |
qualified_referrer | Unknown | |
qualified_referrer_url_params | Unknown | |
qualified_session_browser | Unknown | |
qualified_source | Unknown | |
qualified_url_utm_params | Unknown | |
recording | Unknown | |
recording_duration | Unknown | |
recording_player | Unknown | |
referrer_domain | Unknown | |
referring_url | Unknown | |
sentiment | Unknown | |
session_uuid | Unknown | |
source | Unknown | |
source_name | Unknown | |
speaker_percent_agent | Unknown | |
speaker_percent_customer | Unknown | |
start_time | Unknown | |
summary | Unknown | |
tags | Json | |
timeline_url | Unknown | |
total_calls | Unknown | |
tracking_phone_number | Unknown | |
transcription | Unknown | |
type | Unknown | |
utm_campaign | Unknown | |
utm_content | Unknown | |
utm_medium | Unknown | |
utm_source | Unknown | |
utm_term | Unknown | |
value | Unknown | |
voice_assist_message | Json | |
voicemail | Unknown | |
zip_code | Json | |
custom_** | ||
keypad_entry_** |
notification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
tracker_id | Unknown | FK |
user_id | Unknown | FK |
agent_id | Unknown | |
alert_type | Unknown | |
call_enabled | Unknown | |
email | Unknown | |
name | Unknown | |
send_desktop | Unknown | |
send_email | Unknown | |
send_push | Unknown | |
sms_enabled | Unknown |
summary_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
user_id | Unknown | FK |
config_call_log | Unknown | |
config_summary_statistic | Unknown | |
config_top_keyword | Unknown | |
config_top_source | Unknown | |
frequency | Json | |
scope_id | Unknown | |
scope_name | Unknown | |
scope_type | Unknown |
outer_bound
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
validation_code | Unknown | |
verified | Unknown |
text_message_recent_message
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
text_message_id | Unknown | PKFK |
content | Unknown | |
created_at | Unknown | |
direction | Unknown |
text_message
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
initial_tracker_id | Unknown | FK |
company_time_zone | Unknown | |
current_tracker_id | Unknown | |
customer_name | Unknown | |
customer_phone_number | Unknown | |
formatted_current_tracking_number | Unknown | |
formatted_customer_name | Unknown | |
formatted_customer_phone_number | Unknown | |
formatted_initial_tracking_number | Unknown | |
last_message_at | Unknown | |
state | Unknown |
integration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
api_key | Unknown | |
state | Unknown | |
type | Unknown |
tracker_tracking_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tracker_id | Unknown | PKFK |
tracking_number | Unknown | FK |
tracker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
created_at | Unknown | |
disabled_at | Unknown | |
name | Unknown | |
sms_enabled | Unknown | |
sms_supported | Unknown | |
source_search_engine | Unknown | |
source_search_type | Unknown | |
source_type | Unknown | |
status | Unknown | |
tracking_number | Json | |
type | Unknown | |
whisper_message | Unknown | |
call_flow_** |
company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
call_score_enabled | Unknown | |
call_scribe_enabled | Unknown | |
created_at | Unknown | |
disabled_at | Unknown | |
dni_active | Unknown | |
form_capture | Unknown | |
keyword_spotting_enabled | Unknown | |
lead_scoring_enabled | Unknown | |
name | Unknown | |
script_url | Unknown | |
status | Unknown | |
swap_cookie_duration | Unknown | |
swap_exclude_jquery | Unknown | |
swap_landing_override | Unknown | |
swap_ppc_override | Unknown | |
time_zone | Unknown |
integration_trigger
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
integration_id | Unknown | FK |
call_type | Unknown | |
lead_status | Unknown | |
max_duration | Unknown | |
min_duration | Unknown | |
tracker_id | Json |
account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agency_in_trial | Unknown | |
brand_status | Unknown | |
created_at | Unknown | |
has_zuora_account | Unknown | |
hipaa_account | Unknown | |
name | Unknown | |
numeric_id | Unknown | |
outbound_recording_enabled | Unknown |