Customer.io is an automated cloud messaging platform for marketing automation that allows crafting and sending data-driven emails, push notifications, and SMS messages. Skyvia uses Customer.io App API.
Data integration: Skyvia supports importing data to and from Customer.io, exporting Customer.io data to CSV files, replicating Customer.io data to relational databases, and synchronizing Customer.io data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Customer.io backup.
Query: Skyvia Query supports Customer.io.
To establish a connection, you need to select your account region and specify your app API key.
Note that you cannot view an existing API key. If you don’t have one, you will need to create a new API Key.
To create a new API key open the page by the link above (sign in, if you aren’t signed in yet) and perform the following steps:
- Click Create App API Key.
- Enter the API Key Name, for example, Skyvia and select Workspace.
Click the Create App API Key button in the corresponding row of the App API Keys grid. The created API key is displayed.
- Copy and save your API Key. Note that this is the only time you can obtain it, and if you lose it, you will need to create a new one.
You need to specify the following parameters while creating a Customer.io connection:
Select the Account Region if you use a non-US region.
Enter your App API Key.
Custom attributes of the Customers object are available via the CustomersAttributes object.
Besides, some Customer.io objects can be accessed only via their parent objects. For example, to query CustomerSegments, CustomerMessages, or CustomerActivities, Shopify API requires the ID of the corresponding Customer (Skyvia uses the CioId field).
Skyvia does not require the ID of the parent object from the user. If you don’t specify the IDs of the parent objects (for example, in a filter), Skyvia queries all the parent object records first, takes their IDs, and then queries child object records for each parent object record. This allows querying child objects without knowing their parents, but this method takes much time and consumes many API calls. It uses at least one API call for every parent object record. Thus, working with child records can be slow.
Because of this, it is recommended to use filters on the parent object fields when querying data from such child objects. This reduces the number of parent object records, for which child object data must be queried.
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for the following objects: BroadcastActions, BroadcastMessages, Broadcasts, BroadcastTriggers, CampaignActions, Campaigns, Collections, CustomerMessages, Customers, Exports, Messages, NewsletterMessages, Newsletters, Snippets, TransactionalMessageDeliveries, TransactionalMessages.
Besides, the following objects have only the CreateDate field, and thus, replication with Incremental Updates detects only the new records, but not updates to existing records: BroadcastMessages, BroadcastTriggers, CustomerMessages, Customers, Messages, NewsletterMessages, TransactionalMessageDeliveries.
DML Operations Support
Skyvia supports the following DML operations for Customer.io objects:
|INSERT, UPDATE, DELETE||Collections, ReportingWebhooks|
Skyvia implements sending emails in Customer.io via stored procedures. Use the corresponding stored procedure to send emails with a template or without a template:
call SendTransactionalEmailWithTemplate(:TransactionalMessageId, :To, :Identifiers_Email, :Body, :Subject, :From, :MessageData, :SendAt, :Bcc, :FakeBcc, :ReplyTo, :Preheader, :PlaintextBody, :Attachments, :Headers, :DisableMessageRetention, :SendToUnsubscribed, :Tracked, :QueueDraft, :DisableCssPreprocessing);
call SendTransactionalEmailWithoutTemplate(:Body, :Subject, :From, :To, :Identifiers_Email, :MessageData, :SendAt, :Bcc, :FakeBcc, :ReplyTo, :Preheader, :PlaintextBody, :Attachments, :Headers, :DisableMessageRetention, :SendToUnsubscribed, :Tracked, :QueueDraft, :DisableCssPreprocessing);
Here is the list of parameters:
- TransactionalMessageId - the id of the transactional message that you want to use as the template.
- To - recipients’ email addresses, separated by commas. Can contain up to 15 recipients.
- Identifiers_Email - Identifies the person represented by your transactional message by email.
- Body - The body of the email message to send. For the SendTransactionalEmailWithTemplate procedure, it overrides the template body.
- Subject - The subject of the email message to send. For the SendTransactionalEmailWithTemplate procedure, it overrides the template subject.
- From - The address that your email is from. This address must be verified by Customer.io. You can include a display-friendly name in the format
Person <[email protected]>. For the SendTransactionalEmailWithTemplate procedure, it overrides the template from address.
- MessageData - An object containing the key-value pairs referenced using liquid in your message.
- SendAt - a timestamp to send the email message at, in unix timestamp format.
- Bcc - Blind copy message recipients. Supports multiple email addresses separated by commas. Can contain up to 15 email addresses.
- FakeBcc - If true, instead of sending true copies to BCC addresses, Customer.io sends a copy of the message with the subject line containing the recipient address(es).
- ReplyTo - The address that recipients can reply to if it needs to be different from the From address.
- Preheader - The block of preview text that users see next to, or underneath, the subject line in their inbox.
- PlaintextBody - You can use this parameter to override the automatically generated plaintext version of your message body.
- Attachments - A JSON dictionary of attachments with filenames as keys and base64-encoded file contents as values. The total size of all attachments must not exceed 2 MB. Some filetype extensions are restricted.
- Headers - An array of header JSON objects. Headers must be strings and cannot contain any non-ASCII characters or empty spaces. Some headers are reserved and cannot be overwritten.
- DisableMessageRetention - If true, the message body is not retained in the delivery history. For the SendTransactionalEmailWithTemplate procedure, this parameter overrides the corresponding template setting. The default value is false.
- SendToUnsubscribed - If true, the message is sent to unsubscribed recipients. For the SendTransactionalEmailWithTemplate procedure, this parameter overrides the corresponding template setting. The default value is true.
- Tracked - Enables tracking of email message opens and link clicks. The default value is false.
- QueueDraft - If true, the email message is held as a draft in Customer.io and is not sent directly to recipients. To send your message, go to the Deliveries and Drafts page.
- DisableCssPreprocessing - Disables CSS preprocessing. For the SendTransactionalEmailWithTemplate procedure, this parameter overrides the corresponding template setting. The default value is false.
Skyvia supports all the common actions for Customer.io.