top of page

SQL

The code is used to answer part 2 of the use case.

​

The technical piece was done in Snowflake using a new database schema called STRIPE.PUBLIC.CONVERSIONS

1 

Visits by Browser

This query adjusts the `week_date` in the `CONVERSIONS` table, then calculates the total visits and overall conversion rate for each browser, and sorts the results by the total number of visits in descending order.

DOWNLOAD PDF

2

Rank each country by Conversion Rate

This SQL query adjusts week dates, calculates weekly conversion rates for each country, and ranks countries by these rates each week, with ties broken by the number of conversions.

DOWNLOAD PDF
Untitled.jpg

Snowflake

Set up

bottom of page