![]() You'll go through several steps to create an account, select your cloud url, and add payment information (you can cancel at any time in the trial). Simply go to and create a Metabase Cloud account by clicking Get Metabase and selecting to start a free trial: To get you started, we'll us Metabase cloud (which comes with a 14 day trial) in this tutorial. Or, you can pay to use the hosted version of Metabase - known as Metabase cloud. With an Open Source license, you can choose to install Metabase for free if you wish. You'll be provided with credentials for you new database: Step 4: Sequin will immediately provision you a Postgres database and begin syncing all your Stripe data to it (if you're using a TEST API key, then Sequin will only sync your TEST data for free, forever). Then, in the destination section, select to have a New Sequin database generated. Step 3: You'll be prompted to enter your Stripe API key. Step 2: Connect your Stripe account to Sequin by going through the tutorial or clicking the Add database button and selecting Stripe. Step 1: Create or Login to your Sequin account. 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. Real-time subscription revenue analytics in Metabase
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |