Klaviyo

klaviyo is an email platform powered by data built for commerce and web businesses klaviyo makes it easy for ecommerce marketers to target, personalize, measure and optimize email and facebook campaigns datalakehouse io provides the best data synchronization process from klaviyo, into your data warehouse or data lake storage so that you can integrate with your other data sources instructions (basic connection setup) using the form please complete the following basic steps enter a name or alias for this connection, in the ' name/alias ' field, that is unique from other connectors enter in the ' target schema prefix ' field, a name that will be unique in your data cloud destination where you wish to land the data enter the klaviyo api key follow the steps here to create api key docid\ zzb8rkr5xpsx7ok0ge5mw in klaviyo click the authorize your account button replicated entities we incrementally sync the following tables based on the sync frequency you set for your connector the table names match the name of the api endpoints available via klaviyo campaign message campaign message template catalog category catalog item catalog variant coupon coupon code event event metric event profile flow image lists list profile list tag metric profile profile global exclusion profile list exclusion segment segment profile segment tag tag tag group template we perform a weekly re import of the above tables (except event) to infer deletes we sync the campaign and it's child tables using non incremental endpoints we re import these tables once a day irrespective of the sync frequency you set by default, we sync events associated with both active and deleted profiles in klaviyo however, you can choose to only sync active profile events in the connector setup form event tracking klaviyo has standard email and web tracking events email event includes bounced email clicked email dropped email marked email as spam opened email received email subscribed to list unsubscribed unsubscribed from list updated email preferences web tracking events come when you add web tracking to the site it includes active on site viewed product issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com faq