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 days45 USD
282 3 0 3 days45 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 days156 USD
421 13 0 5 days156 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 days84 USD
957 19 0 14 days84 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 day11 USD
263 1 day11 USD
Hello! I have experience working with spreadsheets, pivot tables, and dashboards. An example of my work is in the portfolio.
-
1 day11 USD
4461 102 0 1 day11 USD
Good day. I will be happy to help. I will complete everything quickly and efficiently. I have the necessary experience.
-
1 day11 USD
2148 75 0 1 day11 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
Looking for a content manager for social mediaThe task is to post about 30 posts on social media from a phone. Write to those who have some experience in this. Content Management, Information Gathering ∙ 12 hours 29 minutes back ∙ 11 proposals |
Parsing and inviting to my Telegram groupParsing and inviting to my Telegram group. You can start with 1000 participants, but generally, it is expected to reach up to 10,000 participants. Online Stores & E-commerce, Information Gathering ∙ 18 hours 11 minutes back ∙ 8 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 1 day 9 hours back ∙ 14 proposals |
Instagram account audit
67 USD
An audit of the Instagram account is required, which includes: analysis of account statistics; calculation of the Engagement Rate; analysis of follower activity; identification of the account's strengths and weaknesses; evaluation of the effectiveness of posts and the overall… Content Management, Information Gathering ∙ 1 day 19 hours back ∙ 19 proposals |
Services for gathering information on prices for construction materialsDescription of work on the analysis of prices for material resources The work involves searching for prices for construction materials according to the provided list of material resources. For each material resource, it is necessary to find at least three sources of price… Information Gathering ∙ 2 days 17 hours back ∙ 21 proposals |
Kherson