Customer analysis/loyalty program data -- 2
$10-30 USD
Paid on delivery
Situation:
• A leading fashion brand has a loyalty program that has been in existence from 2016
• The loyalty program is open to any customers and customers who register can earn points based on below mentioned rules
• The brand would like to understand their loyalty customer behavior and therefore create new offers, schemes, etc. to improve their customer engagement based on this data
Loyalty program rules:
• Each customer gets 2 points for every 1 currency spend. Currency provided in the data can be assumed to be UAE Dirhams (AED)
• When a customer earns 500 points, they can redeem their points for a 5 AED cashback
• If a customer does not make any purchase within 6 months of registration (or) they have not made a purchase 1 year prior to December 2019, they are considered as “Inactive”, else they are considered “Active”
Complications:
• Due to Covid-19, program was halted in 2020 and resumed in 2022. No data is available for 2020 and 2021
• The program re-started in 2022
Key Questions:
• How many customers were active at the end of 2019?
• Do the loyalty customers spend more than other customers?
• How much do loyalty customers spend more per transaction than other customers?
• What is the growth in loyalty customers and their spend over the years?
• What is the % of loyalty program customers out of the total in terms of transactions and spend? How has this changed over the years?
• How is the customer behavior different across countries?
Candidates are free to use any tools at your disposal in order to complete the analysis.
Output:
• Based on answers to above questions, please create a presentation (in any presentation software) to showcase the answers
• The presentation should have 2 slides that contains your insights on the customer behavior, based on answers to these questions
• The presentation should also have 1 slide that contains your recommendation on what should the fashion brand do to engage their customers in 2022
Evaluation Criteria:
• Problem solving thought process and clarity of thought
• Analysis structure
• Data interpretation
• Ability to make sensible recommendations
• Bonus points – creativity
Project ID: #33874054
About the project
15 freelancers are bidding on average $29 for this job
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More
Hello, I hope you are doing well. I am interested to help you with this requirement. I can also help you in creating and designing Microsoft PowerApps, Power BI, Tableau as I have 3+ years of experience in both of t More
Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have more than 7 years of experience in More
My identity is clearly defined, and is easy for customers to understand. Customers understand and appreciate the value of, and enjoy doing business with “specialists.”
I am data entry operator. I much experience 2-3 days in the data entry work. You can trust me I'm your work emidetli fast fines. Please given your work project i am work done any creat any problem.
Hello, I hope you're having a good day. I believe that I am one of the best candidate to finish your project since I have experienced working in data analysis. I hope you can consider me as your freelancer to finish y More
I'm last 10 year data entry operator work home base project I have good speed for your project I am done project
I believe my previous jobs that I landed might add into the factors of being the best candidate as my skills matches the job requirements. I am very specific and goal-oriented person when it comes to completing the tas More
With my expertise in writing a broad range of content, combined with my outstanding interpersonal skills and commitment to exploring innovative and newsworthy story ideas and comprehensive topic coverage, I am position More
Certified Tableau Developer Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online Able to creatively stretch the capability of Tableau to customize and develop creat More
