Analyse Customer RFM and Email Data

Completado Publicado Aug 11, 2015 Pagado a la entrega
Completado Pagado a la entrega

Hi there,

I've got a data set of my customers and I'd to do some RFM (Recency, Recency and Monetary) analysis to determine some meaningful segments for marketing.

The columns for the data are below. You will notice one is called RFM. Values range from 111 to 555.

I'd like to get a visual representation of the data and get some simple RFM analysis - with the aim of providing actionable insights as well as defining segments for automated email sending. The report should be 2-3 pages.

id,email,City,Country,Customer_ID,Department,Firstname,Joomla_ID,Lastname,Membership_Expiry_Date,Mobile,Organisation,Phone,Position,Postcode,RFM,State,Street1,Street2,SyncDate,Token,User_Type,Username,activate,activate_on,allowemail,allowpost,attendance_company,first_name,language,last_name,lead,platform,referral,referral_number,subscription_expiry_date,synd_date,timezone,userAgent,username,tags

Extracción de datos Procesamiento de datos Redacción de informes

Nº del proyecto: #8246465

Sobre el proyecto

8 propuestas Proyecto remoto Activo Aug 12, 2015

Adjudicado a:

shikhamehta

Hey, Since you already have the RFM score in the data, my suggestion is to create the dashboard that would allow you to slice the data based on different criteria say for example based on geography (say region) or d Más

$444 AUD en 10 días
(11 comentarios)
5.0

8 freelancers están ofertando un promedio de $394 por este trabajo

flashsaiful

Hello Dear, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$555 AUD en 10 días
(74 comentarios)
6.0
dionline

Hi, I have done my MBA in Marketing & Finance and worked for 6 years in a McKinsy as a Lead Strategy Consultant. Can you please tell me the exact number of words so that I can quote a fair price. I have written Más

$347 AUD en 8 días
(38 comentarios)
5.3
ssumit2606

I can possibly work on this as I have been working as Senior MIS & Data Analyst from last 4 years in India's largest IT Service Provider. I possess good Excel , Powerpoint and Analytical skills which will prove very us Más

$277 AUD en 7 días
(3 comentarios)
1.7
purnam79

I shall provide a meaningful analytical report as per requirement which would be helpful to get valuable insights..

$277 AUD en 10 días
(0 comentarios)
0.0
oyedelek

My major intension is to provide the satisfactory as well as perfectly done job/work or project to my would be client(s). Satisfaction of my clien(s) comes first. Thank you.

$444 AUD en 10 días
(0 comentarios)
0.0
ranasgautam

I bring with me close to 20 years of experience in Predictive Analytics, Informatics, Visualization and Consulting. Backed by ability to see across multiple domain areas and connect disparate pieces to come up with ne Más

$555 AUD en 10 días
(0 comentarios)
0.0