Amazon Redshift to Klaviyo

dinmo logo

Use DinMo to create a data pipeline between your Amazon Redshift Data Warehouse and Klaviyo in less than 2 minutes.

How to use DinMo to connect Amazon Redshift to Klaviyo?

  • First step is to ensure that Amazon Redshift is already configured as a source in DinMo, and Klaviyo has been added as a destination.

  • Ensure that you have already created the segments that you wish to sync to Klaviyo in DinMo. If not, go to the Segments tab, click "New Segment," and create them one by one with the appropriate rules.

  • Navigate to the Activations tab, and click "New Activation" in the upper-right corner of the screen.

  • Select the type of segment you wish to activate - either conversions (called events) or audiences (called users).

  • Select the segment you wish to sync to Klaviyo, and specify the appropriate Klaviyo option before clicking “Continue”.

  • Then, select Klaviyo from the platform dropdown and click “Continue”.

  • Choose the ad account you wish to use.

  • If you want to change the activation name, fill in the corresponding field. You can also add a description to this activation.

  • Specify the external ID that should be used by Klaviyo to identify your contacts.

  • To map the fields for user segments, specify which properties of your segment correspond to the mail address, phone number, first name, and last name.

  • Under the Scheduling options, choose the time interval for syncing your segments to Klaviyo. A daily sync is sufficient for most use cases.

  • Click "Continue," and then click "Create" to finish.

Once the activation is created, it should start syncing immediately. Wait a few moments to ensure that the sync is successful.

That's it! You have successfully synced your Amazon Redshift data with Klaviyo in DinMo. If you face any issues, refer to DinMo's documentation or contact their support team for assistance.

SMS & Push

Share this article

Put your data in motion and get value everywhere

Related Tutorials

Related Tutorials

Put your data in motion and get value everywhere