Data sources like Mailjet form a foundation for a data analytics stack that comprises three additional tiers: ETL (extract, transform, load) software, data warehouse, and business intelligence (BI) software.
Stitch provides a simple, powerful ETL service for businesses of all sizes. Signup is simple — you can be moving data from one or more sources to a data warehouse in five minutes.
The last few years have seen the emergence of cloud-native data warehouses like Amazon Redshift, Google BigQuery, Snowflake, and Microsoft Azure SQL Data Warehouse. Because they run on cloud infrastructure that scales quickly and cost-effectively to meet performance demands, they can handle transformation using the same hardware on which the data warehouse runs.
Finally, to unlock the value of your data, you can connect a BI or data visualization tool to your data warehouse and create reports that analyze data from multiple sources, which you can share via browser-based dashboards.
Let’s set up a three-tiered data analytics stack, starting with the data warehouse. If your organization generates business analytics reports, chances are you already have an account with one of these data warehouses, but if you don’t, choose one that meets your needs. If you choose Redshift, BigQuery, Snowflake, Azure SQL Data Warehouse, or one of the other destinations Stitch supports, you can also follow the setup steps for your data warehouse in the Stitch documentation.
The next step is setting up an ETL pipeline to move data from Mailjet and other data sources to the data warehouse. Stitch makes extracting data from a source and loading it into a data warehouse easy. To get started, visit Stitch’s signup page, enter your email address, then enter your name and a password.
Next, add Mailjet as an integration within Stitch. Click on the Mailjet icon to get started:
The next screen prompts for a name for the integration. This name will display on the Stitch Dashboard for the integration, and it’ll also be used to create the schema in your destination. Choose something descriptive but not too long.
When you click Save, Stitch will generate a webhook token URL:
Follow the instructions on the screen to paste the URL into Mailjet as an endpoint for the events you want to track. Once you save it, all future events of the types you’ve selected will be replicated to your data warehouse — but first you have to connect your data warehouse to Stitch as a destination.
Click Continue, then All Done, to get back to the Stitch dashboard. Scroll up to the top of the screen and click on Destination.
Suppose you’ve chosen an Amazon Redshift data warehouse. Click on the Redshift icon, enter your credentials, then click Check and Save.
Now all the pieces are in place, and your data is ready to flow.
When you visit your Stitch dashboard, you’ll see that your integration is marked Active, Continuously Replicated.
From the dashboard you can also add integrations from other data sources. The Stitch documentation walks through the process for each one.
The final stage of the process is connecting an analytics platform to your data warehouse. If you don’t already use BI software, you have dozens to choose from, including such popular options as Tableau, Microsoft Power BI, Google Data Studio, and Looker.
Now you have all the tools you need to see, for example, which customers need the most support or which are the most profitable, and you can tell whether you’ve been communicating with them at an optimal cadence or targeting ads at the best cohort.
That’s all there is to it. Using an ETL tool like Stitch to move data from Mailjet and other sources into a data warehouse lets you leverage the power of BI tools to correlate and report on all of your valuable data.
***
This post was written by Lee Schlesinger, Content Marketing Manager at Stitch.
