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
Signin to Daton
Select CampaignMonitor from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your CampaignMonitor email and password to authorize Daton to periodically extract data CampaignMonitor.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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 |
Last updated