Working with Excel tables for RFM analysis
18 USD PS: the phones are changed, data only as an example.
From the 2 tables you need to make 1 with the following fields:
- Last sale date (is the customers who bought 2 or more times. This field must have the date of the last sale. Take from the application table example, stone Date of sale)
The name
- My Name
by Father
The phone
The email
- Goods/Services (the last application) (example application table)
The sum of the last application (example application table)
- K-to sale (Table of Contact Examples)
- Sales amount (Table of Examples Contact)
- Website (Table of Applications)
and the!The !
A mandatory requirement for this task is a clearly described algorithm as such work we will perform independently in the future.
and the!The !
Applications 2
Client's review of cooperation with Viktoriia M.
Working with Excel tables for RFM analysisThank you, everything is done at a high level. I recommend cooperation.
Freelancer's review of cooperation with Volodimir Polishchuk
Working with Excel tables for RFM analysisA very friendly and responsible customer. It is pleasant to work that when a person is interested in the result.
-
1 day9 USD
387 3 0 1 day9 USD
Good day ! I will help you quickly and qualityly to solve your question - I can do it tonight (up to the end of the day). I can also suggest - further automatize this process and display the data visually.
-
1 day11 USD
1330 62 2 1 1 day11 USD
Welcome to,
I can write a macro to combine 2x tables in one...
If the order of the column does not change.
-
1 day11 USD
140 1 day11 USD
I work in the office.
Excel 3 years old.
I will do the work at a high level and quickly.
The price is agreed.
Current freelance projects in the category Data Processing
Assistance with personal social media, networking, and projects 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 ∙ 1 day 21 hours back ∙ 9 proposals |
Setting up and updating dashboards in Looker StudioWe have several dashboards created in Looker Studio that pull data from main Google Sheets.Last year, we regularly maintained and updated these sheets; however, the process was later halted, and the specialist who was managing the system no longer works with us. Currently, some… Data Processing ∙ 2 days 18 hours back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 8 days 22 hours back ∙ 20 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 9 days 15 hours back ∙ 18 proposals |
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
89 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 11 days 4 hours back ∙ 18 proposals |
Ostrog