Automation of A/B advertising reports from CRM

Budget: 1500 UAH Deadline: 3 days

Volodymyr, I see the task as building a reliable scheme: webhook → raw log → mapping of fields/statuses → normalization → cohort report by lead creation date. I haven't created similar A/B dashboards with CRM data, but I am well acquainted with log structure, automation, and real-time data handling. For the MVP, I would suggest Google Sheets + Make or n8n; for greater flexibility — Python + Looker Studio. I can show similar approaches and discuss the architecture.

Budget: 6000 UAH Deadline: 7 days

Hello! Your project is my stack: Make.com + webhook + Google Sheets.
What you will get:

You will see not just the number of leads but real sales - compare options A and B by revenue and ROI.
No manual data aggregation - the system automatically collects and normalizes all events from the CRM.
The template works with any CRM without rework - just change the field mapping.
Advertising budget decisions based on data, not feelings.

From experience: I have built webhook systems with automatic data processing and storage in Google Sheets.
Cost: we will discuss after clarifying the details. Ready for MVP in 5-7 days.

Budget: 1000 UAH Deadline: 7 days

Hello,

I understood the task — webhook from CRM → normalization + mapping → cohort A/B report by lead creation date (not by final status date) with metrics CPA / ROAS / ROI / quality leads / completed sales.

Answers to your questions:
1. **Have I done similar reports on CRM data:** yes — webhook receivers for KeyCRM and Pipedrive, event parsing, normalization into a single schema, BI shapes on top of this.
2. **Have I worked with webhook:** regularly. On the receiving end — Python (FastAPI) or n8n node; both are functional.
3. **What would I recommend for MVP:** it depends on how many leads per day and whether the system will scale to many projects. Honest breakdown:

- **up to 100 leads/day, 1–3 projects:** Google Sheets + Make + Apps Script. Can be set up in a week, the client can see the data themselves, sufficient for A/B.
- **100–1000 leads/day and/or several CRMs:** webhook → Python FastAPI receiver → Postgres → Looker Studio on View. Field mapping lives in the Postgres table `field_mapping`, you edit it without code when connecting a new CRM. MVP — 1.5–2 weeks.
- **n8n** — a compromise between the first two, but with 5–10 CRMs of different structures, it will hit no-code limitations; I would choose the Python option.

Architecture for the Python option:
- `Raw Events Log` — append-only table, each webhook row as JSON.
- `Field Mapping` — dictionary `(crm_name, src_path) → (std_field, transform_fn)`.
- `Normalized Leads` — materialized view or daily batch (for 1000/day — view will suffice).
- `Cohort Report` — SQL with window functions, by `date_trunc('day', created_at)`. Expand

Budget: 1500 UAH Deadline: 1 day

Hello!

Webhook integrations, CRM data processing, and analytical reports are our specialty.

About the project:

Webhook receiver — FastAPI server receives events from any CRM, stores Raw Events Log in PostgreSQL/SQLite.

Field Mapping — config file for each CRM: key names, statuses, structure. New project — new mapping without changing the code.

Normalized Leads — one line per lead, all statuses tracked by creation date (cohort logic as you described).

A/B Dashboard — automatic calculation of CPA, ROAS, ROI, quality vs all leads, comparison of options A and B.

MVP — I propose Python + FastAPI + Google Sheets (via API). More reliable than Make, more flexible than n8n, and Sheets is convenient for viewing reports without additional tools.
Ready to start immediately. Expand

Budget: 5000 UAH Deadline: 1 day

Good day. I am ready to complete this project as I have extensive experience in app development.

Budget: 2000 UAH Deadline: 3 days

Hello! I have reviewed the project and am ready to start working. I am confident you will be satisfied with the result.

Budget: 8000 UAH Deadline: 10 days

Hello! I am ready to complete your task, I have experience working on similar projects.

Budget: 1000 UAH Deadline: 1 day

Good day, I am writing on behalf of the company Devoxen. We specialize in such tasks. We have extensive experience in building analytics systems for CRMs, advertising platforms, and automating reporting. We have worked with webhook integrations, data normalization, status mapping between different CRMs, and building cohort/A-B reports with the correct metric attribution to the lead creation date. We have also implemented automated pipelines using Make, n8n, Python backend, and BI solutions.

For the MVP, we can offer a solution using Google Sheets + webhook receiver + Make/n8n for a quick launch, and then scale towards Looker Studio, Power BI, or a separate backend service with a database and dashboard if necessary. We can design a universal structure for Raw Events Log, Field Mapping, Normalized Leads, Cohort Report, and A/B Dashboard considering various CRMs and non-standard webhook structures.

We can proceed without unnecessary questions and time wastage. We also provide a guarantee and support if desired. We can start working on your project immediately after discussing the technical specifications.

I suggest moving to private messages for a more detailed dialogue.

Budget: 4500 UAH Deadline: 10 days

Hello, Volodymyr!

I am implementing a flexible A/B testing analytics system based on Make.com and Google Sheets. This is an ideal stack for an MVP that allows easy mapping of data from any CRM.

I will set up a webhook receiver so that each event goes into the log, and the final report calculates ROI and ROAS specifically based on the lead creation date. You will receive a transparent dashboard showing the actual profit from each Meta Ads creative. This will allow you to timely stop ineffective campaigns and scale profitable connections.

I have experience building similar end-to-end analytics and working with API/webhook. Could you let me know which CRM you are currently using?

Budget: 8000 UAH Deadline: 7 days

Good day!

I am a no-code automator, specializing in automating various business processes through the service Make.com.

Answers to your questions:
1. I have created a custom CRM system in Airtable for sales and a dashboard for comparing and visualizing data.
2. Yes, I have practical experience working with webhooks from various CRM systems.
3. For the MVP, I propose the Make.com stack, a template in Google Sheets or Airtable.
4. Examples of implemented automations for comparing reports from Meta and Google Ads, as well as CRM automation with a dashboard.
Links:
https://freelancehunt.com/showcase/work/avtomatizatsiya-facebook-ads-zvitiv/2028169.html

https://freelancehunt.com/showcase/work/rozrobka-analitichnogo-dashbordu-dlya-crm-sistemi/2034584.html

Feel free to reach out, and we can discuss the details, possible implementation options, and costs.)) Expand

Budget: 10000 UAH Deadline: 5 days

Hello, Volodymyr!
I have already worked on such tasks in the format of marketing analytics automation based on CRM + advertising data, including webhook events, lead normalization, and report generation for A/B tests.

For the MVP, I see several implementation options (depending on your requirements for flexibility and scalability):
- a quick option through Google Sheets + automation of webhook logic;
- a more reliable option with an intermediate data processing layer and subsequent visualization.

To accurately assess the scope, I need to clarify:
- which CRM you are currently working with (or planning to use several);
- whether there is already a Meta Ads structure with UTM / event tracking;
- what the monthly lead volume is;
- whether you only need an MVP or a system designed for scalability.

After this, I will be able to propose a specific architecture, timelines, and budget for your scenario. Expand

Budget: 6000 UAH Deadline: 4 days

Good day! I have had similar projects, but not based on data from the CRM itself, but I understand how to implement this MVP based on Google Sheets!!! Feel free to reach out!!!!