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