Artem Zadvoryanskiy

Data Analyst

Artem Zadvoryanskiy

Data Analyst

Stripe – Payout Behavior of Stripe Connect Platforms

  • Created By: Artem Zadvoryanskiy
  • Date: 12/27/2018
  • Client: Stripe

Stripe Connect is a product that allows platform businesses to pay out money to other businesses all over the world. In this project, we will analyze the payout behavior of Stripe platforms. A platform is a Stripe user that enables other businesses to process payments with Stripe.


We are provided with the following 3 datasets:

  1. Payouts – has daily payout amounts (in cents) from platforms to recipients. Both platforms and recipients are represented by a merchant id. In the dataset, the platform merchant is specified by `platform_id` and the recipient is specified by `recipient_id`
  2. Countries – maps merchants to countries
  3. Industries – maps merchants to industries


  • Provide an estimate for the amount of money Stripe should expect to be paid out to each country on Jan. 1, 2019 
  • In 2019, Stripe is expecting to have 15 platforms from the Education industry, 5 from Hotels, Restaurants & Leisure and 40 from Food & Beverage. How much total daily payout volume Stripe can expect to see? 

APPENDIX 1: Weekly Transactions and Payout Amount

APPENDIX 2: Total Payouts by Weekday

APPENDIX 3: Expected Payouts on Jan. 1, 2019 by Country

APPENDIX 4: Total Payouts by Platform Industry

APPENDIX 5: Average Daily Payouts by Industry YoY