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.
DATA DESCRIPTION:
We are provided with the following 3 datasets:
- 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`
- Countries – maps merchants to countries
- Industries – maps merchants to industries
TASK:
- 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
