Whether you’re a dev, a designer, or a salesperson, we want to see how you work. It shows your thinking, how you deal with a practical task, and your technical skills. We believe every test task should be done while respecting the candidate’s time and effort. Look at it like sending your demo to a record company. Show us your best work and how you work, so we can both see if it’s a good fit. If it is, we’ll be making music together in no time.
Our Test includes 3 different Tasks, please pay attention that Task 1 and Task 2 must be completed in writing. Please prepare them first, and send us a written version. After we check Task 1 and Task 2, we will ask you to prepare Task 3 and present it on the next interview round, so we will have some content for discussion with the next Interviewer.
Pick any format — presentation, Google Docs/Notion — anything that works best for you.
We believe 3 days is enough to find time, but not too long for us (and we don't expect that you will work on weekends).
Задание #1
Task 1. SQL - *written
Our services heavily rely on subscriptions, we have 2 types of subscriptions that cost $19.99 / year and $39.99 / year. All data are stored in 2 tables:
traffic - source & date of sessions
transactions - monetary transactions
You can get data here: ug_test
Tasks
- Prepare an SQL query to calculate the ARPU (Average Revenue Per User) by cohort based on the access (session) date
Requirements
Preferably please consider using ClickHouse SQL
Please provide us with resulting SQL, formatted, preferably in the separate SQL file
We want you to express your thinking while you build the query, please add comments
Задание #2
Task 2. Modeling - *written
We’re selling subscriptions and always experimenting with new prices. We had an experiment with 2 sets of prices (data Task 2 analyst Set 1 vs Set 2) and we want to launch another experiment with new prices (Set 3).
Tasks
Please copy the doc and fill in all yellow cells
You need to estimate first revenue (revenue we get from the first payment) for Set 1 and Set 2
You need to estimate overall cohort revenue (revenue for the whole lifetime) for Set 1 and Set 2
You need to model results for Set 3 based on results of the first experiment, is it possible to get 25% growth over Set 2? Why or why not?
Requirements
We need a link to the model with filled formulas
We want you to express your thinking while you prepared the model, please add comments
Задание #3
Task 3. Hypotheses*
We have several products: ultimate-guitar.com, Ultimate Guitar iOS and Android app, musescore.com, MuseScore iOS and Android app. Feel free to select any product you like or want to test. Please research the product you selected and provide 3-5 hypotheses how we can improve monetisation of the product you selected.
Tasks
Please specify the product you researched (ultimate-guitar.com, Ultimate Guitar iOS and Android app, musescore.com, MuseScore iOS and Android app)
Please describe your hypotheses about user behavior and provide a simplified model of how this will impact revenue
For each hypothesis please describe minimum version to be tested to find out unknowns in your simplified model
Requirements
- We understand that you don’t have any numbers, fee free to insert any, we’re looking at the way you think more than at how you can use Google Sheets to multiply numbers