Market Behavior Analysis
Budget: ₹600 – ₹1,500 INR
I'm seeking a skilled Market Analyst with an expertise in the technology sector. The goal of this project is to attain an in-depth understanding of consumer behavior on a global scale.
Key Responsibilities:
Task 1: (Revenue Cohort for Repeat Customers Acquired)
In the following task, the goal is to create a Month-on-Month Revenue Retention Analysis. Here we take the aggregate of the Revenues Generated by the Customers acquired in Month 0 and then the Revenue generated subsequently by the same customers in the following months.
Task 2: (Revenue Cohort of First Time Customers Acquired)
In this task, the goal is to create a Month-on-Month Revenue Analysis for the Customers who have been acquired for the first time in the respective month.
The customers whose first order falls into this month would be considered to be acquired in Month 0. And the customers who come back and repeat in the following months would show up in Month 1 and Month 2 and so on.
Data Sheet:-
https://docs.google.com/spreadsheets/d/1LkCHiVWNWpgpkZtZGWGcykFZxs9qH2eE28Fxi3bRkbc/edit?usp=sharing
Key Responsibilities:
Task 1: (Revenue Cohort for Repeat Customers Acquired)
In the following task, the goal is to create a Month-on-Month Revenue Retention Analysis. Here we take the aggregate of the Revenues Generated by the Customers acquired in Month 0 and then the Revenue generated subsequently by the same customers in the following months.
Task 2: (Revenue Cohort of First Time Customers Acquired)
In this task, the goal is to create a Month-on-Month Revenue Analysis for the Customers who have been acquired for the first time in the respective month.
The customers whose first order falls into this month would be considered to be acquired in Month 0. And the customers who come back and repeat in the following months would show up in Month 1 and Month 2 and so on.
Data Sheet:-
https://docs.google.com/spreadsheets/d/1LkCHiVWNWpgpkZtZGWGcykFZxs9qH2eE28Fxi3bRkbc/edit?usp=sharing