Development of a Google Sheet with formulas for the sales department
We are a language online school. We need tables for the sales department to track the performance of each manager and the overall effectiveness of the school.
1. Tables for managers
For each of the 5 managers (with the possibility of adding new ones in the future), a table is needed to track the following metrics:
✅How many applications the manager received.
✅How many communications were opened (the number of attempts to contact).
✅How many calls were successful or ended in a dialogue.
✅CR 2 (intensity): calculate the ratio of successful dialogues to the number of attempts.
✅How many trial lessons were scheduled.
✅CR 3 (application → trial appointment): calculate the percentage ratio of scheduled trials to the total number of applications.
✅Total payments for trial lessons.
✅CR 4 (reach to trials): the ratio of conducted trial lessons to scheduled ones.
✅How many trial lessons were conducted.
✅How many invoices were issued.
✅Total amount of issued invoices.
✅CR 5 (trial lesson → payment): the ratio of the number of payments to the number of conducted trial lessons.
✅Number of new payments.
✅Total income from new payments.
✅Average check for new clients (total income divided by the number of new payments).
✅Number of additional payments (repeat payments from current clients).
✅Total income from additional payments.
✅Average check for additional payments.
✅Total number of payments (new + additional).
The table should also have the ability to record:
The language chosen by the client.
The source of the application (where the client found out about us).
In addition, it is necessary to automatically calculate the salary of each manager using the formula:
Base rate depending on sales + % from sales (the formula will be provided separately).
Then we need the data from all the managers' tables (or sheets) to be integrated into a general dashboard where we can see all the information.
And there should be a separate table for building the monthly plan, which then goes to each manager and to the general one.
Here is an example of the tables we have; we would like something like this but with added formulas and more automation.
-
3 days48 USD
290 3 0 3 days48 USD
Good night. I am interested in your project. I have experience working with Google Sheets. We can discuss the price and deadlines after clarifying the details. I would be happy to collaborate.
-
5 days169 USD
458 13 0 5 days169 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
14 days90 USD
954 18 0 14 days90 USD
Good day.
I have completed projects with related tables with access restrictions. In my portfolio, there are examples of dashboards created in Google Sheets. I will implement your project according to all your wishes. If you are interested, I will outline how I see the initial structure of the tables and what information is needed from you. During the work, we will implement all the functions that you intend to automate using Google Sheets.
-
1 day12 USD
303 1 day12 USD
Hello! I have experience working with spreadsheets, pivot tables, and dashboards. An example of my work is in the portfolio.
-
1 day12 USD
3787 96 0 1 day12 USD
Good day. I will be happy to help. I will complete everything quickly and efficiently. I have the necessary experience.
-
1 day12 USD
2511 74 0 1 day12 USD
Valerii Li, hello! I am ready to start developing such a table, but please tell me, should the data be entered manually from the table or from the CRM system?
-
Відкрийте доступ до Вашого прикладу.
-
Current freelance projects in the category Information Gathering
Research and information gathering
25 USD
We are looking for an analytically minded and curious specialist, who will help us gather, structure, and analyze information on key topics related to the transformation of the large industry. Searching for current information and trends on topics:Innovations in heavy and large… Marketing Research, Information Gathering ∙ 1 hour 27 minutes ago ∙ 3 proposals |
Collection of a database of interior designers and furniture in Kyiv and Kyiv region
24 USD
Project: Collection of interior designers and furniture database in Kyiv and Kyiv region Goal: Obtain up-to-date contact details of designers for subsequent promotion of services/partnerships 1. Target Audience • Interior designers • Cabinet furniture designers • Private… Data Processing, Information Gathering ∙ 6 hours 4 minutes ago ∙ 3 proposals |
Gather Instagram contentThere is a lot of different content left from the Instagram account. The task is to distribute these files so that a content plan consisting of 12 posts and 5 highlights is created. I will provide an approximate structure. Data Processing, Information Gathering ∙ 9 hours 45 minutes ago ∙ 7 proposals |
A checker is needed for bulk verification of e-mail addresses
101 USD
Hello.I need a checker that will verify email address validity — by list.What I need:Upload a list of email addresses (txt or csv)The script/program checks:Does the mailbox existDoes it accept emails (is it valid)Is there an MX record (optional)Export: valid / invalid (with… Information Gathering, Bot Development ∙ 18 hours 44 minutes ago ∙ 4 proposals |
MACOS Tool that automatically generates an invoice in Pages format based on data from a Numbers file,I have a ready-made tool based on VBA Excel that automatically generates an invoice in Word and PDF formats based on data from an Excel file. It needs to be optimized (redesigned) to work on MACOS through pages and numbers. Enterprise Resource Planning (ERP), Information Gathering ∙ 22 hours 5 minutes ago ∙ 1 proposal |
Kherson