Callrail

Tables in the Callrail connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	companies	17		Full Refresh, Incremental		API Reference
2	calls	72				API Reference
3	conversations	18
4	users	8		Full Refresh, Incremental		API Reference

Table: companies

No	Column Name	Type	Notes
1	keyword_spotting_enabled	BOOLEAN
2	form_capture	BOOLEAN
3	swap_ppc_override	VARCHAR
4	disabled_at	VARCHAR
5	swap_cookie_duration	INTEGER
6	lead_scoring_enabled	BOOLEAN
7	created_at	VARCHAR
8	time_zone	VARCHAR
9	script_url	VARCHAR
10	swap_landing_override	VARCHAR
11	dni_active	BOOLEAN
12	callscore_enabled	BOOLEAN
13	name	VARCHAR
14	id	VARCHAR
15	swap_exclude_jquery	VARCHAR
16	callscribe_enabled	BOOLEAN
17	status	VARCHAR

Table: calls

No	Column Name	Type	Notes
1	good_lead_call_id	VARCHAR
2	formatted_call_type	VARCHAR
3	good_lead_call_time	VARCHAR
4	customer_phone_number	VARCHAR
5	customer_country	VARCHAR
6	keywords	VARCHAR
7	call_highlights	VARCHAR
8	utm_medium	VARCHAR
9	device_type	VARCHAR
10	source	VARCHAR
11	keypad_entries	VARCHAR
12	tracking_phone_number	VARCHAR
13	formatted_duration	VARCHAR
14	business_phone_number	VARCHAR
15	prior_calls	INTEGER
16	formatted_tracking_source	VARCHAR
17	id	VARCHAR
18	landing_page_url	VARCHAR
19	timeline_url	VARCHAR
20	customer_city	VARCHAR
21	fbclid	VARCHAR
22	lead_status	VARCHAR
23	referring_url	VARCHAR
24	voicemail	BOOLEAN
25	utm_campaign	VARCHAR
26	formatted_customer_name	VARCHAR
27	last_requested_url	VARCHAR
28	tags	VARCHAR
29	start_time	VARCHAR
30	total_calls	INTEGER
31	formatted_business_phone_number	VARCHAR
32	recording_player	VARCHAR
33	company_name	VARCHAR
34	campaign	VARCHAR
35	utmz	VARCHAR
36	formatted_value	VARCHAR
37	waveforms	VARCHAR
38	msclkid	VARCHAR
39	speaker_percent	VARCHAR
40	utmv	VARCHAR
41	formatted_customer_name_or_phone_number	VARCHAR
42	utm_source	VARCHAR
43	formatted_customer_location	VARCHAR
44	note	VARCHAR
45	utmb	VARCHAR
46	utmc	VARCHAR
47	keywords_spotted	VARCHAR
48	agent_email	VARCHAR
49	utma	VARCHAR
50	recording	VARCHAR
51	created_at	VARCHAR
52	formatted_tracking_phone_number	VARCHAR
53	medium	VARCHAR
54	duration	INTEGER
55	referrer_domain	VARCHAR
56	ga	VARCHAR
57	call_type	VARCHAR
58	value	VARCHAR
59	source_name	VARCHAR
60	direction	VARCHAR
61	utm_content	VARCHAR
62	answered	BOOLEAN
63	customer_state	VARCHAR
64	company_id	VARCHAR
65	formatted_customer_phone_number	VARCHAR
66	first_call	BOOLEAN
67	utm_term	VARCHAR
68	gclid	VARCHAR
69	recording_duration	INTEGER
70	tracker_id	VARCHAR
71	company_time_zone	VARCHAR
72	customer_name	VARCHAR

Table: conversations

No	Column Name	Type	Notes
1	formatted_initial_tracking_number	VARCHAR
2	customer_phone_number	VARCHAR
3	formatted_customer_phone_number	VARCHAR
4	company_id	VARCHAR
5	formatted_customer_name	VARCHAR
6	initial_tracker_id	VARCHAR
7	initial_tracking_number	VARCHAR
8	recent_messages	VARCHAR
9	current_tracking_number	VARCHAR
10	current_tracker_id	VARCHAR
11	formatted_current_tracking_number	VARCHAR
12	company_time_zone	VARCHAR
13	company_name	VARCHAR
14	last_message_at	VARCHAR
15	tracker_name	VARCHAR
16	id	VARCHAR
17	customer_name	VARCHAR
18	state	VARCHAR

Table: users

No	Column Name	Type	Notes
1	role	VARCHAR
2	name	VARCHAR
3	created_at	VARCHAR
4	last_name	VARCHAR
5	accepted	BOOLEAN
6	id	VARCHAR
7	first_name	VARCHAR
8	email	VARCHAR

External Resources

• Text Messages

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.