How Braze Uses Currents
Braze uses Currents! That’s right, we like our own product enough to use it in conjunction with a few of our partners.
We filter our data from our email and push campaigns into a business insights tool, Looker, but it takes an interesting route to get there. We use a slightly inverted version of the ETL (Extract, Transform, Load) methodology - we just switched up the order to ELT (Extract, Load, Transform)!
Step 1: Intake and Aggregate Event Data
After launching campaigns using any of our Engagement Tools (like campaigns or Canvas), we track event data using our own system as well as some from our email partners. Some of this data is aggregated and shown in the dashboard, but we were interested in diving deeper!
Step 2: Send Event Data to a Data Storage Partner
We set up Currents to send Braze event data to Amazon S3 for storage and extraction. Now, we know that you can use Athena to sit on top of S3 and run queries. It’s a great short-term solution. But we wanted (and recommend to you) a long-term solution using a Relational Database and a Business Intelligence/Analytics tool.
We think of S3 as our keys to the castle! It opens up the door to so many possibilities for moving, pivoting, and analyzing our data by transferring it where we need it to go. However, we are careful not to transform our data in S3, as we have a very specific structure for it.
Step 3: Transform Event Data with a Relational Database
From S3, we choose a warehouse (Snowflake, in our case). We transform it there, then move it to Looker, where we have blocks set up that will structure and organize our data.
Step 4: Use a BI Tool to Manipulate Your Data
Finally, we use a BI tool to analyze our data, turn it into charts and other visual tools, and more using Looker and Looker Blocks so we don’t have to ETL/ELT data every time it moves from Currents.
Check out the docs below to get more information on these and how you can use them to build your database!