Role: Analytics Manager

Job Description 

Based in: Mumbai

Reporting to: Head of Analytics

Experience Required: 4+ Years of Experience

What would you need to do? (Role and Responsibilities)

  • Work with Game Designers and product managers to refine game-play and economy throughout the production cycle
  • Play competitor games, analyse them and suggest features we could add to our games.
  • Use data to help guide the team on pricing in-game items, balancing and other adjustments to game-play to increase LTV & Retention
  • Use the power of analysis to make a dramatic shift in the business Key Performance Indicators using strong recommendations and tell stories with numbers
  • Drive the “Analytics” function for products assigned
  • Create & interpret meaningful insights and suggestions for products based on the data collected & reported
  • Represent data, reports and insights in a manner that allows Product Managers to understand the performance of their games, with a focus on improving 3 things:  Downloads, Engagement and Monetization

 Who could you be? Background and Experience:

  • Extensive work experience as an Analytics Manager, in analyzing digital data
  • Experience working in an Apps company or a Mobile Games Company, in an Analytics function (preferable)
  • An e-commerce data specialist  /  Analytics Manager who understands key metric measurements and how to interpret them
  • Analytical mindset with good communication and interpersonal capabilities, able to work independently
  • Must be able to prioritize multiple assignments, with a high degree of accuracy, and function quickly in a fast-paced, deadline-oriented environment

Educational Qualification:

Graduate/Diploma Degree holder in Science/Commerce fields or any other equivalent educational background.

Next Steps:

If this opportunity as an Analytics Manager at Games2win excites you, please send us your completed assignment along with your updated resume to


Part 1:

Use the data set at this link for the questions below: 

Link for Data Set:

Questions based on the above table:

What are the SQL queries that you will use to get the below data points?

  1. What is the total number of unique users who made a purchase? How many items did they buy on average and what is the average price point of each item bought? 
  2. What is the total number of items sold and the average price point of the items overall? 
  3. What are the top 3 items sold daily and revenue from these top 3 items, daily? 
  4. What is the total revenue made from each item broken down by country and day? 

Part 2:

One of the reports we create for our games is a ‘funnel report’, which tells us about the flow that a user took to reach a particular screen.

For example, as per this table:

Data Category Unique Users Total Events
store 13881 19949
chapter_select_screen 9111 12164
garage 5632 7435
more_games_screen 314 350
  • 13881 unique users go to the Store Screen. The most popular source (i.e the previous screen through which user navigated to ‘Store’ Screen) is the ‘chapter_select_screen’, followed by the garage(screen) and the ‘more_games_screen’.
  • The game triggers unique events each time a screen is shown, such as: store, show_home, chapter_select_screen, show_in_game, garage, more_games_screen, show_end_screen.
  • Question: What is the query required to generate this report?  Keeping in mind that each event has a time-stamp (event_timestamp in microseconds, as mentioned in the dataset), we need to find the previous screen before the store was triggered (store screen is shown to the user).
  • Use the following data set for this question :

Part 3: 

  • Download our Game “Driving Academy Simulator 2019” from the Android StoreiTunes Store
    • Play the games for a few minutes:
    • Go to the CARS Section. You will notice that the “Muscle Cars” category is the default one that you start with.
    • Study the real data of that section as shown in the google sheet (Refer to this Link )
    • Answer the below questions:
    • If you were mandated to improve the sale of these (Muscle) cars – what would you do? Assume you have the freedom to change car positions, prices etc. If you wanted to run experiments, what would those be, and why?
  • Download and play our Game “Decisions” from the Android / iTunes store
    • Play the game for a few minutes.
    • The stories are presented to users in a universal layout. That means that everyone in the world sees stories in the same way. As an analyst, do you think that makes sense? If not, what do you recommend? How would you like to present the stories? What data would you ask for to make your decision? Do you believe in customization? What could Netflix / Hotstar teach us to present content better from an Analytics point of view?
  • Download and play our Game “International Fashion Stylist” from the Android / iTunes store
    • Play the game for a few minutes.
    • You will notice that some of the clothes are free, some locked, some available by watching videos. The player gets a few coins when they start and also for playing levels. Do you think we should continue having free clothes/clothes via videos or lock them all for coins? If people don’t want to buy coins, should we still allow them to play the game? (remember – playing the game generates ads that generate money)
  • Download and play this extremely popular game called Super Stylist from the Android / iTunes store. This game does very well in terms of in-app purchases and engagement. As an analyst, detail at least 5 (five) features/ game mechanics you found in this game that we do not have in our International Fashion Stylist Game you played above? What could we add in our game and why?

-End of Assignment-

Best of Luck!

Send your updated resume/CV along with the above-mentioned test assignment response to