How would you describe the lifecycle of a courier in Glovo? What do you think are the main challenges that we are trying to solve from a CRM perspective? The main challenges that Glovo try to solve are: 2. Pick one of the challenges mentioned above and create a multi-channel campaign to help you tackle it. What segment would you target? How would you measure the results? 3. Imagine that you need to set up an automated communication flow for recently acquired couriers with the aim of pushing them to start delivering orders. Describe how you would structure the flow. How would you determine if the campaign was successful or not? Please be as detailed as possible. How would you determine if the campaign was successful or not? 4. If you have some metrics like: Av. orders per courier/ week and Days of collaboration with Glovo, can you propose a possible analysis you could do and how these insights could be useful for CRM? 4. How these insights could be useful for CRM? 5. Technical - SQL: Can you make a SQL query that returns the avg total orders of couriers from ES that are not from Sevilla? If you are not familiar with SQL, can you elaborate on how you would frame the solution without coding?
