Customer.io
Customer.io is an automated messaging platform.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | |
History mode | ||
Custom data | ||
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Customer.io setup guide to connect Customer.io with your destination using Fivetran connectors.
Schema information
This schema applies to all Customer.io connectors.
To zoom, open the ERD in a new window.Sync overview
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-sync
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