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.
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)
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.
No complex macros — only formulas, filters, and pivot tables.
It should be convenient: we upload new data → we see the current ROMI by sources.
A file with ready-made filters and a report + a short instruction on how to use it.
Budget: 100 EUR Deadline: 3 days
Hello.
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.
Budget: 250 EUR Deadline: 2 days
Hello!
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.
Budget: 160 EUR Deadline: 14 days
Good 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.
Budget: 40 EUR Deadline: 3 days
Good day.
I will complete the task without macros, formulas, and filters.
Budget: 25 EUR Deadline: 1 day
Hello, I will take on the implementation of this project. Please contact me to agree on the details.
Budget: 200 EUR Deadline: 3 days
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.
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.
Budget: 100 EUR Deadline: 3 days
I 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.
Budget: 75 EUR Deadline: 3 days
Good 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.
Budget: 100 EUR Deadline: 1 day
Good day. I will be happy to help. I have the necessary experience and skills!
Budget: 85 EUR Deadline: 1 day
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.
Budget: 120 EUR Deadline: 2 days
Hello!! I have a lot of experience working with GOOGLE SHEETS!!!! Feel free to contact me, I will do it well!!!!!!
Budget: 100 EUR Deadline: 5 days
Good 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!
Budget: 101 EUR Deadline: 7 days
Hello! 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!
