Menu
 

Send Data to a Data Warehouse with Stitch

Stitch makes it easy to combine data from multiple sources in order to load the data in to a data warehouse (like Amazon Redshift, Google Bigquery, Panoply, or Postgres). If you have marketing campaigns where Customer.io is just one piece of the puzzle, a data warehouse lets you combine data from all your systems in order to get a complete picture of performance.

These steps assumes you already have a Stitch account and have your data warehouse connected to Stitch.

We’ll leverage the Customer.io Email Webhooks to send email performance data to a data warehouse using Stitch. 

Generate a URL

In your Stitch account, click “Add an integration” and select “Customer.io”.

Give it a name like “Customer.io Performance” and click “Save”. You should now see a URL that you can copy. 

Update your webhook endpoint

In your Customer.io account, click on “Integrations”. Under “Streaming Data Out”, click on the “Get Started” button next to Email Activity Webhook.

Paste the link you got from Stitch in to the “Endpoint” and click “Update”. To verify it’s working, you can click “Test”. 

Confirm your data is received

Back in your Stitch account, take a look at the details for your new Customer.io integration. Within a few minutes you should see that Stitch has received data and is preparing to load it in to your data warehouse.

And that’s it! Data is synced automatically. 

We’d love to know how you’re using a data warehouse with Customer.io and how we can better help. Send us an email to win@customer.io and let us know.