Rd station marketing

Prerequisites

• An RD Station account
• A callback URL to receive the first account credential (can be done using localhost)
• client_id and client_secret credentials. Access this link to register a new application and start the authentication flow.

Tables in the Rd station marketing connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	emails	13		Full Refresh	update_time
2	analytics_conversions	8
3	segmentations	7		Full Refresh	update_time
4	landing_pages	8		Full Refresh	update_time
5	popups	7
6	analytics_emails	15
7	analytics_funnel	6
8	workflows	6
9	analytics_workflow_emails_statistics	19
10	fields	8
11	embeddables	6

Table: emails

No	Column Name	Type	Notes
1	sending_is_imminent	BOOLEAN
2	send_at	VARCHAR
3	created_at	VARCHAR
4	type	VARCHAR
5	is_predictive_sending	BOOLEAN
6	leads_count	INTEGER
7	updated_at	VARCHAR
8	component_template_id	VARCHAR
9	name	VARCHAR
10	id	INTEGER
11	campaign_id	INTEGER
12	behavior_score_info	VARCHAR
13	status	VARCHAR

Table: analytics_conversions

No	Column Name	Type	Notes
1	asset_created_at	VARCHAR
2	asset_identifier	VARCHAR
3	asset_type	VARCHAR
4	conversion_count	INTEGER
5	asset_id	INTEGER
6	conversion_rate	DOUBLE
7	asset_updated_at	VARCHAR
8	visits_count	INTEGER

Table: segmentations

No	Column Name	Type	Notes
1	standard	BOOLEAN
2	updated_at	VARCHAR
3	process_status	VARCHAR
4	name	VARCHAR
5	created_at	VARCHAR
6	links	VARCHAR
7	id	INTEGER

Table: landing_pages

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	conversion_identifier	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER
5	title	VARCHAR
6	had_experiment	BOOLEAN
7	has_active_experiment	BOOLEAN
8	status	VARCHAR

Table: popups

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	conversion_identifier	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER
5	trigger	VARCHAR
6	title	VARCHAR
7	status	VARCHAR

Table: analytics_emails

No	Column Name	Type	Notes
1	email_delivered_count	INTEGER
2	email_bounced_count	INTEGER
3	email_unsubscribed_count	INTEGER
4	email_spam_reported_rate	DOUBLE
5	send_at	VARCHAR
6	email_opened_count	INTEGER
7	contacts_count	INTEGER
8	email_clicked_count	INTEGER
9	campaign_name	VARCHAR
10	email_delivered_rate	DOUBLE
11	email_opened_rate	DOUBLE
12	email_dropped_count	INTEGER
13	email_clicked_rate	DOUBLE
14	email_spam_reported_count	INTEGER
15	campaign_id	INTEGER

Table: analytics_funnel

No	Column Name	Type	Notes
1	qualified_contacts_count	INTEGER
2	reference_day	VARCHAR
3	visitors_count	INTEGER
4	sales_count	INTEGER
5	contacts_count	INTEGER
6	opportunities_count	INTEGER

Table: workflows

No	Column Name	Type	Notes
1	user_email_created	VARCHAR
2	updated_at	VARCHAR
3	name	VARCHAR
4	user_email_updated	VARCHAR
5	created_at	VARCHAR
6	id	VARCHAR

Table: analytics_workflow_emails_statistics

No	Column Name	Type	Notes
1	email_delivered_count	INTEGER
2	workflow_id	VARCHAR
3	count_processed	INTEGER
4	email_opened_unique_count	INTEGER
5	email_unsubscribed_count	INTEGER
6	workflow_name	VARCHAR
7	email_spam_reported_rate	DOUBLE
8	created_at	VARCHAR
9	workflow_action_id	VARCHAR
10	contacts_count	INTEGER
11	updated_at	VARCHAR
12	email_delivered_rate	DOUBLE
13	email_bounced_unique_count	INTEGER
14	email_opened_rate	DOUBLE
15	email_name	VARCHAR
16	email_dropped_count	INTEGER
17	email_clicked_rate	DOUBLE
18	email_spam_reported_count	INTEGER
19	email_clicked_unique_count	INTEGER

Table: fields

No	Column Name	Type	Notes
1	custom_field	BOOLEAN
2	presentation_type	VARCHAR
3	name	VARCHAR
4	data_type	VARCHAR
5	label	VARCHAR
6	uuid	VARCHAR
7	validation_rules	VARCHAR
8	api_identifier	VARCHAR

Table: embeddables

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	conversion_identifier	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER
5	title	VARCHAR
6	status	VARCHAR

External Resources

• This Link
• Api Request Limit

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.