Find Jobs
Hire Freelancers

Data analysis for customer reorder rate and customer retention

$30-250 USD

En curso
Publicado hace alrededor de 10 años

$30-250 USD

Pagado a la entrega
I am looking to get an analysis on what's happening with our customer reorder rate and how many new customers we are acquiring vs how many customers we are losing. I need the following data points: 1) Graph displaying number of customers who order once, twice, three times, etc. X-axis = number of orders / Y-axis = number of customers. Need the percentage at each quantity. I then need to see how that has changed over time by quarter. Are we getting more reorders now or x quarters ago? 2) I need to see at what rate we are acquiring new customers vs rate that we are losing customers. I need a graph displaying how many new customers ordered per quarter and then how many customers per quarter we have that have not ordered in two years that quarter (last order date was two years ago that quarter). I would then like to be able to filter the above results by the dollar amount that the customer has ordered. Are we gaining or losing more large or small dollar customers. Is there a difference in reorder rate based on the size of their orders, etc. I can provide the following excel data sheets: 1) Customer ID, Date of first sale, Date of last sale (number of records ~50,000) 2) Customer ID, Transaction ID, Date, Amount (number of records ~109,000) If you need additional data just let me know and I'll see what I can do. If you can provide the results in an excel sheet so I can play with the filters that would be great. But if you work with Tableau or something similar and there is a viewer app then I'm ok with that as well. If you have any questions please let me know.
ID del proyecto: 5702326

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de UNITED STATES
Harbor City, United States
5,0
47
Forma de pago verificada
Miembro desde ago 10, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.