REPORT IN GOOGLE SHEETS
Task
It is necessary to set up filters and create reports from the original data table exported from the CRM system, which automatically calculates ROMI for each advertising source and income by days.
Example of data from which filters and reports need to be created.
From the original data as shown here > you can view an example of the original data we export here https://docs.google.com/spreadsheets/d/1ptDUBIW-S6NepltVSLRe4xIBuizRUI8CoHBK11-bRCM/edit?usp=drive_link
Example of revenue for the period (I have a sample table that you can use as a source) I can't share the link to this table yet, but I will grant access when we start working)
What needs to be done with this data:
From the input data we already have, create a summary table/report that shows:
Revenue for the period (as in the example above)
Advertising source;
Number of sales by source;
Revenue amount by source;
ROMI (%).
3. Add a date filter (for example, you can select a month or a week).
4. Ensure that the report updates automatically when new data is added.
Requirements
No complex macros — only formulas, filters, and pivot tables.
It should be convenient: we upload new data → we see the current ROMI by sources.
Result
A file with ready-made filters and a report + a short instruction on how to use it.
-
1 day29 USD1 day29 USD
Hello, I will take on the implementation of this project. Please contact me to agree on the details.
-
1 day99 USD1 day99 USD
Good day. I am ready to help. I have professional experience and do similar work regularly. I will do it in the most optimal way. Feel free to reach out.
-
2 days291 USD
104 2 days291 USDHello!
I am ready to create a report in Google Sheets with formulas, filters, pivot tables, and automatic data updates from CRM.
At Charged Development, we regularly create reports and dashboards for sales analytics, ROMI, and advertising effectiveness.
I will implement everything neatly and transparently: correct formulas, period filters, clean structure without macros, plus a short instruction for use.
The work will be done quickly and efficiently — I am ready to start immediately after confirmation.
-
14 days186 USD
957 19 0 14 days186 USDGood day.
I have reviewed the technical specifications.
I will create a table that will automatically generate reports when new data is added.
I will make the interface visually appealing through conditional formatting.
Graphs can be added to the reporting tab for better information perception.
Feel free to write, I will do it well and will continue to help even after the project is completed.
-
3 days47 USD
4777 375 2 3 3 days47 USDGood day.
I will complete the task without macros, formulas, and filters.
-
3 days233 USD
421 13 0 3 days233 USDHello!
I work with Excel and Google Sheets.
I am ready to help with 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 with formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
3 days116 USD
991 12 1 3 days116 USDI am ready to promptly and qualitatively complete your order. I have experience working on similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!
I work as a market analyst and develop sales reports.
-
3 days87 USD
1026 15 0 3 days87 USDGood day,
I can help with the implementation of the task.
We need to discuss both files in more detail, we can communicate in private messages.
-
1 day116 USD
4467 102 0 1 day116 USDGood day. I will be happy to help. I have the necessary experience and skills!
-
3 days116 USD
10130 117 0 3 days116 USDHello.
I am a NodeJS developer. I have experience with Google Sheets. I am ready to take it on. Write to me, and we will discuss.
-
2 days140 USD
3012 73 4 2 2 days140 USDHello!! I have a lot of experience working with GOOGLE SHEETS!!!! Feel free to contact me, I will do it well!!!!!!
-
5 days116 USD
348 5 days116 USDGood day!
I am ready to help with the implementation of a report for the automatic calculation of ROMI based on advertising sources. I have familiarized myself with the task and have experience creating similar interactive reports in Google Sheets without using macros — only formulas, pivot tables, and convenient filters.
🔹 What will be implemented:
Automatic report updates when new data is added;
Calculation of the number of sales, revenue, and ROMI for each source;
…
Filtering by dates (week, month, etc.);
Convenient report format with an example (as you have for revenue);
A short user guide.
I am ready to start working immediately; just provide access to the revenue example, and I can show a draft version of the report for approval on the first day.
If needed, I can create an even more flexible format, for example, with a separate sheet for analytics or comparing several periods.
I look forward to collaborating!
-
7 days118 USD
1322 13 1 7 days118 USDHello! I can do it, and if necessary, I can provide some support for a while.
Everything we need will be done through formulas; if needed, we can also create scripts and custom functions, but only if necessary.
Write to me, I will be happy to help!
-
Вітаю, з радістю візьмусь за реалізацію даного проєкту, маю досвід налаштування аналогічних звітів.
-
Current freelance projects in the category Databases & SQL
Vibe coding through Claude Code
350 USD
Develop a closed web platform for corporate events with personal invitations via unique links and QR codes. After scanning the QR code, the user is directed to a personal invitation page with a welcome message, a greeting by name, a photo and a message from the CEO, a countdown… AI Art, Databases & SQL ∙ 44 minutes back ∙ 15 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 4 hours 35 minutes back ∙ 25 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 4 days 4 hours back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 4 days 7 hours back ∙ 19 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 7 days 7 hours back ∙ 13 proposals |
Barcelona