Customer.io

Customer.io ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	customerio site id customerio secret apikey
Replication Type	Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	24 hrs

##Tables/Apis supported
Customers	Segements
Newsletters	Campaigns

Integrate Customerio with Daton

1. Signin to Daton

2. Select Customerio 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 site id and secret apikey from your customerio account to authorize Daton to periodically extract data from customerio.

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

Tables

Customers

Purpose: Returns all the customers associated with the account.

Source-Api documentation https://customer.io/docs/api/

Fields

Name	Target Datatype
email	String
id	String

Segments

Purpose: Retrieving segments via the API returns information regarding your Customer.io segments. Source-Api documentation https://customer.io/docs/api/

Fields

Name	Target Datatype
id	Numeric
deduplicate_id	String
name	String
description	String
state	String
progress	String
type	String

Newsletters

Purpose:Retrieving newsletters via the API returns information regarding your Customer.io newsletters. Source-Api documentation https://customer.io/docs/api/

Fields

Name	Target Datatype
id	Numeric
deduplicate_id	String
msg_template_ids	String
content_ids	String
name	String
sent_at	String
created	Numeric
updated	Numeric

Campaigns

purpose:Retrieving campaigns via the API returns information regarding your Customer.io campaigns. Source_Api documentation https://customer.io/docs/api/

Fields

Name	Target Datatype
id	Numeric
deduplicate_id	String
name	String
type	String
created	Numeric
updated	Numeric
active	Boolean
actions	Record
msg_templates	Record
first_started	Numeric
created_by	String
tags	String