We’re really excited to announce a new partnership with Mode Analytics. Now you can easily hook Mode up to your Amplitude Redshift cluster to explore your raw event data and build powerful visualizations for your team.
If you aren’t familiar with Mode yet, it’s a SQL-based analytics tool that lets you query, visualize, and share data. Unlike some other BI tools that center around drag and drop interfaces, Mode is designed for analysts who want to explore data using SQL, the language they know and love.
It made complete sense to partner with Mode, since our missions are complementary: to help you explore your data and find insights. Both of our companies are built off the belief that pre-made dashboards and tools can only get you so far — at some point, you need to dig into your data to answer questions uniquely tailored to your company and product. That’s why Amplitude gives you full access to your raw data via Amazon Redshift, in addition to the out-of-the-box analytics dashboards. This gives you the flexibility to answer any question about user behavior you can think up — and now you can use Mode to make those investigations even more powerful.
Here are a few reasons we’re excited to partner with Mode:
- Mode keeps your analytical workflow organized in one place. Write SQL queries, explore results with built-in charting tools, and save everything under version control.
- It’s easy to turn ad hoc analyses into shareable internal tools. Reports live at URLs where results can be updated by anyone in your company at any time, regardless of their experience with SQL.
- No configuration needed. You’ll be writing SQL against your Amplitude data stored in Redshift within five minutes of signing up for Mode.
Two Playbooks, More Pre-built Queries
Mode has built some amazingly useful pre-built queries, which are housed in the Mode Playbook. With a few adjustments, you can tailor these queries to fit your Amplitude Redshift data schema. Once you’re using Mode, you can clone any of these queries and reports with a single click, make the necessary modifications to fit your data, and run the report!
On our end, we have the Amplitude Redshift Queries Playbook, which includes pages of queries and common use cases for understanding complex user behavior analytics. These are ready to go for your Amplitude data — all you have to do is input the event names relevant to your app. A great way to get started exploring your Amplitude data in Mode is to paste in some of these playbook queries start sharing them with your team.
Here’s one example from the Mode Playbook that we really like: the User Paths report. It’s somewhat similar to Event Flows in Amplitude and shows you the different sequences of events that users take in your app, but visualizes these paths in a totally different way. This report can be really useful if, for example, you have an ecommerce product and want to see what steps users take after they checkout their cart.
To make this partnership even more timely, this week we’re rolling out a re-structure of our Redshift schema, which should make queries faster than ever. We’re calling it Dynamic Dedicated Redshift — be on the lookout for a new blog post about it later this week!
To learn how to seamlessly hook up your Amplitude Redshift cluster to Mode, check out this quick and easy docs page.