Edit on GitHub
Customer.io link
Customer.io is an automated messaging platform.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables |
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Table level. A table re-sync includes all the associated child tables. |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Customer.io setup guide to connect Customer.io with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Customer.io connectors.
To zoom, open the ERD in a new window.Sync overviewlink
We re-import the following tables once a day:
SEGMENT
SEGMENT_TAG
SEGMENT_DEPENDENCY_CAMPAIGN
SEGMENT_DEPENDENCY_SENT_NEWSLETTER
SEGMENT_DEPENDENCY_DRAFT_NEWSLETTER
SEGMENT_MEMBER
We also re-import the MESSAGE
table once a week to capture updates and deletes.
Webhook MAR usage during a historical re-synclink
During a historical re-sync, all webhook tables in the connector will increase your paid MAR usage. Pricing for all other tables adheres to our incremental pricing strategy.
Below are the webhook tables within our schema:
CUSTOMER_EVENT
EMAIL_EVENT
SMS_EVENT
PUSH_NOTIFICATION_EVENT
IN_APP_MESSAGE_EVENT
SLACK_EVENT
WEBHOOK_EVENT