Developing a system of indicators for customer assessment and creating
Developing a system of indicators for customer assessment and creating an interactive model to forecast changes.
Actions required:
- Сreate a customer and customer base assessment system, which would include the following indicators (these indicators are subject to discussion and approval):
- CLV (€)
- LT (d)
- Retention rate (%) / Churn rate (%)
- Average Order (€)
- Average Order Frequency (d)
- CAC (€)
- Retention Cost (€/m)
- Gross Margin (%)
- Gross Margin Lifetime (€)
- Average Order per LT (pc)
- Average Order per LT (€)
- Average Revenue per User (€/y)
Identify and calculate the indicators from paragraph one which are not available from the onset.
Connect the system of indicators from the first paragraph with the Revenue and ROI indicators.
Build an interactive model (in Excel/Google Sheets, etc.) that would predict changes in CLV, Revenue, ROI, and Customer Quantity over a specific period (a month, a year, etc.).
What We Currently Have
- Order Dataset 10 Years
- CAC
- Retention Cost
- Gross Margin
- *other data may be available upon request.
-
7 days23 USD
293 2 0 7 days23 USD
Good day.
Power BI is best for creating an interactive scorecard for evaluating customers and creating an interactive model for predicting change. To see this in action, I propose a free trial release of the dashboard on your database. If this release report satisfies your request, we will further clarify the terms of reference, cost and timing of the creation of the original report.
-
Hello Olga
This task is not for PowerBI, GS or Excel. It is for Python or R.
"Order Dataset 10 Years" - CSV or DB?
"an interactive model" - Who should the model interact with and how?
Need more detailed specification, data subsample and discussion.
Regards,
Sergey
-
Current freelance projects in the category Data Processing
Setting up and optimizing the lawyer's existing social media accountsFor the startup (without launching advertising in the first stage) it is necessary: - to set up a Facebook page, Instagram, a lawyer's Telegram, a lawyer's association page, Meta Business Suite, a Telegram channel, and a consultation route Facebook → Instagram Telegram →… Data Processing, Customer Support ∙ 2 hours 18 minutes back ∙ 2 proposals |
Assistance with AI, personal social media, and operational tasks for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 23 hours 59 minutes back ∙ 7 proposals |
Video Content Operator / Data Entry (UBT)
25 USD
Package Import: Receiving source materials (lip syncs, performances) 38 clips of 2 minutes each Audio Overlay: Overlaying an official music track under the lip sync in CapCut or similar software (bulk sound mixing according to a template). Bulk Cutting / Splitting: Mass… Video Processing, Data Processing ∙ 1 day back ∙ 5 proposals |
Develop and create a space for a marketing agency in Notion
23 USD
I am looking for a performer who can help develop and create a space for a marketing agency. There is a rough template, it needs to be refined and implemented in Notion. Enterprise Resource Planning (ERP), Data Processing ∙ 1 day back ∙ 11 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 1 day 21 hours back ∙ 9 proposals |
Ukraine