With your Stripe API key created, you can now setup Sequin to replicate Stripe to a Postgres database: Step 3: Finally, click the Create Key button and keep this new restricted API key handy as you move on to set up Sequin. You can get more details by reading Sequin's reference for Stripe. Then provide this new key with the following permissions: Step 2: Give your key a name (something like "sequin" will do just fine). Note: If you want to use a test API key, ensure you have the View test data switch turned on while generating the API key. Then click the + Create restricted key button. Step 1: Navigate to the Stripe API keys page by selecting Developers in the left navigation and clicking API keys. As a best practice, we recommend providing Sequin with a restricted API key. Sequin requires an API key to sync all your Stripe data in real-time. Repeat the process by creating a couple more customers with recurring subscriptions. To do so, click the Actions button on the customer page and select Create Subscription: Step 3: Finally, create a new customer with a subscription to the product you just created. Double check that the product is configured to be Recurring: Step 2: Create a recurring product by going to the product page, clicking + Add Product, and filling out the form to create a new product. Step 1: Login to your Stripe dashboard and put your account into TEST MODE by flipping the View test data switch. To get going, add a couple test subscriptions to your Stripe account: If you don't have any active subscriptions in your LIVE Stripe account, you can easily add some fake ones in your TEST account: Create test subscriptions You'll need a Stripe account that contains some active subscriptions data. But what makes Metabase great for this tutorial is that it is open source and offers a free plan. Metabase is a powerful, flexible, BI platform with first class support for Postgres.Īs mentioned earlier, you can use virtually any BI platform under the sun with your Sequin database. This means you can match customer behavior with revenue to create metrics tailored to your business. You can use the tools your team is already familiar with.Īnd finally, you have the option to sync your Stripe data to a schema in an existing Postgres database, so you can query across your core data sets and Stripe with ease. Third, you get the credentials to your Sequin postgres database, so you can connect your Stripe data to virtually any BI tool you can think of. Second, all your data is synced in real-time (unlike the 24 hour delay in Stripe Sigma or other ETLs) so you can analyze your financial data as it changes every second. You aren't locked in to any prebuilt metrics or visualizations that don't work for your business. You can query any table or column as you please. There are a couple benefits.įirst, you can use SQL to work with your data. Sequin enables you to work with up-to-the-second Stripe data in a Postgres database. To get started, this tutorial shows you how to build a real-time revenue dashboard using SQL with Metabase. For business operations, finance, data analysts, and product managers this means you can analyze and work with your Stripe data in completely new ways using the tools and SQL you already know. Sequin replicates all your Stripe data to a Postgres database in real-time. Unless otherwise noted, all files © 2022 Metabase, Inc.Real-time subscription revenue analytics in Metabase This repository contains the source code for both the Open Source edition of Metabase, released under the AGPL, as well as the (), which are released under the Metabase Commercial Software License. Provide a specialized customer lookup application for the people in your company.Ĭheck out our guide, (). Export subsets of your users to third party marketing automation software. Metabase also allows you to hit our Query API directly from Javascript to integrate the simple analytics we provide with your own application or third party services to do things like: See which translations are available and help contribute to internationalization using our project over at (). We want Metabase to be available in as many languages as possible. To get started with a development installation of the Metabase, check out our (). Set up () to have Metabase notify you when your data changes. Send data to Slack or email on a schedule with (). Define canonical () for your team to use. Create () that clean up, annotate, and/or combine raw tables. Build handsome, interactive () with filters, auto-refresh, fullscreen, and custom click behavior. Let anyone on your team () without knowing SQL. !(docs/images/metabase-product-screenshot.svg) () is the easy, open-source way for everyone in your company to ask questions and learn from data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |