Campaign Monitor

Campaign Monitor ETL connector for data replication

CampaignMonitor
Features
Details
Release Status
Released
Source API Version
2.0
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
campaignmonitor email
campaignmonitor password
Replication Type
Full Replication
Key based replication
Replication Key
DATE
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
​
Account
Countries
Campaigns
Bounce
Clients
TimeZone
Journeys
Reciepient
Lists
Templates
Segments
Rules
Subscribers
Transactional
Webhooks
Event
Integrate CampaignMonitor with Daton
1.Signin to Daton
2.Select CampaignMonitor from Integrations page
3.Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
4.Provide your CampaignMonitor email and password to authorize Daton to periodically extract data CampaignMonitor.
5.Post successful authentication you will be prompted to choose from the list of available tables
6.Then select all required fields for each table
7.Submit the integration
Workflow
1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2.Users would be able to edit/pause/re-activate/delete integration anytime
3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
CampaignMonitor Data
CampaignOpens
Purpose: Retrieves a paged result representing all subscribers who opened a given campaign, including the date/time and IP address from which they opened the campaign. When possible, the latitude, longitude, city, region, country code, and country name as geocoded from the IP address, are also returned. You have complete control over how results should be returned including page size, sort order and sort direction.
Source API Documentation https://www.campaignmonitor.com/api/campaigns/#campaign-opens​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
list_id
STRING
date
TIMESTAMP
ipaddress
STRING
latitude
STRING
longitude
STRING
city
STRING
region
STRING
country_code
STRING
country_name
STRING
ListDeletedSubscribers
Purpose: Contains a paged result representing all the deleted subscribers for a given list. This includes their email address, name, date deleted (in the client’s timezone) and any custom field data. You have complete control over how results should be returned including page sizes, sort order and sort direction.
Source API Documentation https://www.campaignmonitor.com/api/lists/#deleted-subscribers​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
name
STRING
date
TIMESTAMP
state
STRING
custom_fields
RECORD
reads_email_with
STRING
consent_to_track
STRING
ListActiveSubscribers
Purpose: Contains a paged result representing all the active subscribers for a given list. This includes their email address, name, date subscribed (in the client’s timezone), and any custom field data. You have complete control over how results should be returned including page sizes, sort order and sort direction.
Source API Documentation https://www.campaignmonitor.com/api/lists/#active-subscribers​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
name
STRING
date
TIMESTAMP
state
STRING
custom_fields
RECORD
reads_email_with
STRING
consent_to_track
STRING
ListBouncedSubscribers
Purpose: Contains a paged result representing all the bounced subscribers for a given list. This includes their email address, name, date bounced (in the client’s timezone), and any custom field data. You have complete control over how results should be returned including page sizes, sort order and sort direction.
Source API Documentation https://www.campaignmonitor.com/api/lists/#bounced-subscribers​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
name
STRING
date
TIMESTAMP
state
STRING
custom_fields
RECORD
reads_email_with
STRING
consent_to_track
STRING
ListUnconfirmedSubscribers
Purpose: Contains a paged result representing all the unconfirmed subscribers (those who have subscribed to a confirmed-opt-in list, but have not confirmed their subscription) for a given list. This includes their email address, name, date subscribed (in the client’s timezone), and any custom field data. You have complete control over how results should be returned including page sizes, sort order and sort direction.
Source API Documentation https://www.campaignmonitor.com/api/lists/#unconfirmed-subscribers​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
name
STRING
date
TIMESTAMP
state
STRING
custom_fields
RECORD
reads_email_with
STRING
consent_to_track
STRING
ListUnsubscribedSubscribers
Purpose: Contains a paged result representing all the unsubscribed subscribers for a given list. This includes their email address, name, date unsubscribed (in the client’s timezone), and any custom field data. You have complete control over how results should be returned including page sizes, sort order and sort direction.
Source API Documentation https://www.campaignmonitor.com/api/lists/#unsubscribed-subscribers​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
name
STRING
date
TIMESTAMP
state
STRING
custom_fields
RECORD
reads_email_with
STRING
consent_to_track
STRING
GettingSubscriberLists
Purpose: Returns all the subscriber lists that belong to that client, including the list name and ID.
Source API Documentation https://www.campaignmonitor.com/api/clients/#getting-subscriber-lists​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
list_id
STRING
name
STRING
GettingYourClients
Purpose: Gives you access to core account information such as the clients available in your account and helper procedures when creating a client including available countries, time zones and the current date and time in your account.
Source API Documentation https://www.campaignmonitor.com/api/account/​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
list_id
STRING
name
STRING
GettingJourneys
Purpose: Contains a list of all journeys belonging to a particular client. The results include journey ID, status, name, and the ID of the list the journey is attached to.
Source API Documentation https://www.campaignmonitor.com/api/journeys/​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
list_id
STRING
journey_id
STRING
name
STRING
status
STRING
ClientDetails
Purpose: Get the complete details for a client including their API key, access level, contact details and billing settings.
Source API Documentation https://www.campaignmonitor.com/api/clients/#getting-clients-details​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
api_key
STRING
basic_details
RECORD
billing_details
RECORD
CampaignSummaries
Purpose: Provides a basic summary of the results for any sent campaign such as the number of recipients, opens, clicks, unsubscribes, etc to date. Also includes the web version URL, and the public Worldview URL for the campaign.
Source API Documentation https://www.campaignmonitor.com/api/campaigns/#campaign-summary​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
recipients
NUMERIC
total_opened
NUMERIC
clicks
NUMERIC
unsubscribed
NUMERIC
bounced
NUMERIC
unique_opened
NUMERIC
spam_complaints
NUMERIC
web_version_url
STRING
web_version_text_url
STRING
world_view_url
STRING
forwards
NUMERIC
likes
NUMERIC
mentions
NUMERIC
CampaignClicks
Purpose: Retrieves a paged result representing all subscribers who clicked a link in a given campaign, including the date/time and IP address from which they clicked the link.
Source API Documentation https://www.campaignmonitor.com/api/campaigns/#campaign-clicks​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
url
STRING
list_id
STRING
date
TIMESTAMP
ip_address
STRING
latitude
STRING
longitude
STRING
city
STRING
region
STRING
country_code
STRING
country_name
STRING
CampaignBounces
Purpose: Retrieves a paged result representing all the subscribers who bounced for a given campaign, and the type of bounce (Hard = Hard Bounce, Soft = Soft Bounce).
Source API Documentation https://www.campaignmonitor.com/api/campaigns/#campaign-bounces​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
list_id
STRING
bounce_type
STRING
date
TIMESTAMP
reason
STRING
CampaignRecipients
Purpose: Retrieves a paged result representing all the subscribers that a given campaign was sent to. This includes their email address and the ID of the list they are a member of.
Source API Documentation https://www.campaignmonitor.com/api/campaigns/#campaign-recipients​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
email_address
STRING
list_id
STRING
JourneySummary
Purpose: Get a full summary of a journey, including the journey’s ID, name, trigger type and status as well as individual email statistics.
Source API Documentation https://www.campaignmonitor.com/api/journeys/#getting-journey-summary​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
journey_id
STRING
name
STRING
trigger_type
STRING
status
STRING
emails
RECORD
ListDetails
Purpose: A basic summary for each list in your account including the name, ID, type of list (single or confirmed opt-in), any custom unsubscribe and confirmation URLs you’ve specified, as well as the list’s unsubscribe setting.
Source API Documentation https://www.campaignmonitor.com/api/lists/#list-details​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
confirmed_optin
BOOLEAN
title
STRING
unsubscribe_page
STRING
unsubscribe_setting
STRING
list_id
STRING
confirmation_success_page
STRING
SegmentDetails
Purpose: Returns the name, list ID, segment ID and number of active subscribers within an existing segment as well as the current rules for that segment.
Source API Documentation https://www.campaignmonitor.com/api/segments/#getting-segments-details​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
active_subscribers
NUMERIC
rule_groups
RECORD
list_id
STRING
segment_id
STRING
title
STRING
GettingSegments
Purpose: Returns the name, list ID, segment ID and number of active subscribers within an existing segment as well as the current rules for that segment.
Source API Documentation https://www.campaignmonitor.com/api/segments/#getting-segments-details​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
list_id
STRING
segment_id
STRING
title
STRING

Calendly V2

Capsule CRM

Last modified 2yr ago

Features	Details
Release Status	Released
Source API Version	2.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	campaignmonitor email campaignmonitor password
Replication Type	Full Replication Key based replication
Replication Key	DATE
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Account	Countries
Campaigns	Bounce
Clients	TimeZone
Journeys	Reciepient
Lists	Templates
Segments	Rules
Subscribers	Transactional
Webhooks	Event

Name	Target Datatype
email_address	STRING
list_id	STRING
date	TIMESTAMP
ipaddress	STRING
latitude	STRING
longitude	STRING
city	STRING
region	STRING
country_code	STRING
country_name	STRING

Name	Target Datatype
api_key	STRING
basic_details	RECORD
billing_details	RECORD

Name	Target Datatype
recipients	NUMERIC
total_opened	NUMERIC
clicks	NUMERIC
unsubscribed	NUMERIC
bounced	NUMERIC
unique_opened	NUMERIC
spam_complaints	NUMERIC
web_version_url	STRING
web_version_text_url	STRING
world_view_url	STRING
forwards	NUMERIC
likes	NUMERIC
mentions	NUMERIC

Name	Target Datatype
journey_id	STRING
name	STRING
trigger_type	STRING
status	STRING
emails	RECORD

Name	Target Datatype
confirmed_optin	BOOLEAN
title	STRING
unsubscribe_page	STRING
unsubscribe_setting	STRING
list_id	STRING
confirmation_success_page	STRING

Name	Target Datatype
active_subscribers	NUMERIC
rule_groups	RECORD
list_id	STRING
segment_id	STRING
title	STRING