Kustomer

Kustomer is a software platform for customer experience, service, and support integrated with a number of sources to give support staff a complete picture of a customer when they contact the company.

Features

Setup guide

Follow our step-by-step Kustomer setup guide to connect Kustomer with your destination using Fivetran connectors.

Schema information

This schema applies to all Kustomer connections created on or after August 01, 2022.

This schema applies to all Kustomer connectors created before August 01, 2022.

To zoom, open ERD in new window

Sync overview

To capture new records and updates, we incrementally sync the following tables and their child tables:

• CONVERSATIONS

• CUSTOMERS

• KOBJECTS

• MESSAGES

• NOTES

  NOTE: KObjects are custom objects. For every KObject type, we create a separate custom table KOBJECT_{klassName}.

To capture updates and deletes, we re-import the following tables once every day:

• ASSISTANTS
• BRANDS
• CARDS
• COMPANIES
• CUSTOM ATTRIBUTE META
• NOTIFICATIONS
• QUEUES
• SHORTCUTS
• SLA
• SNOOZES
• TAGS
• TEAMQUEUES
• TEAMS
• USERS

Custom data

We support custom data for the following tables:

• CARD_CONTEXT
• COMPANY
• CONVERSATION
• CONVERSATION_HISTORY
• CREATED_BY_TEAM
• CUSTOMER
• KOBJECT
• MESSAGE
• MESSAGE_ATTACHMENT
• TEAM_MEMBER
• USER_ROLE
• All postfix tables

Postfix tables

We support custom data for all postfix tables. Some of the tables are:

• ASSIGNED_TEAM
• ASSIGNED_USER
• CHANNEL
• EMAIL
• EXTERNAL_ID
• LOCATION
• PHONE
• SOCIAL
• TAG
• TEAM_MENTION
• URL
• USER_MENTION

For each postfix, we create a table in the format {main_entity}_{postfix}.

Sync note

If you exclude child tables from the sync and later want to sync the tables, perform a full re-sync to backfill the data in the child tables.

Kustomer API usage

The default Kustomer API usage limit of a connector is 90%. You can use our REST API to configure the usage between 25% - 90%.

Limitation

Kustomer's API rate limits apply based on your subscription plan.