Cross-analytics for the CTO and tire center: 1C (BAS) + GA4 + Asterisk in Looker Studio

Web Programming, Marketing Research — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

I'm looking for a competent specialist for a one-time "turnkey" project with the possibility of further support on an hourly payment basis. The task is to set up an automatic dashboard in Looker Studio (focusing on the mobile version) that will show the real picture of marketing and operations.

Data sources:

1C (BAS): our sales, net margin (distribution between services and goods), workload of service posts, KPI of masters and managers.
GA4 + advertising accounts (Google Ads, Facebook): expenses, clicks, leads.
Binotel: call statistics and unique numbers.

We will NOT use intermediate Google Sheets as a database — this is fundamental. Data must be pulled directly (via OData or direct lightweight connectors).

What needs to be done:

Design the logic of data connection without inflating the budget for heavy cloud storage.
Prepare a clear technical specification for our in-house 1C programmer. You do not need to code in 1C, but you must detail for our developer which tables, registers, and in what format he should export.
Glue data by cross identifiers (phones, Client ID) so that we can see the full path: from clicking on the ad and calling to closing the order in 1C.
Set up the final dashboard in Looker Studio. It should be concise and convenient for daily viewing on a phone. Main blocks:
- Marketing (ROMI, cost per lead, CAC).
- Finance (Turnover, margin by categories, average check).
- Process efficiency (workload of posts, sales of managers).

Who I'm looking for:

A person with experience in web analytics and building reports specifically for the real sector (services, retail, ideally — auto services). You should understand the difference between turnover and margin and be able to communicate with 1C specialists in the same language.

Payment format:

We work exclusively through Safe (secure deal) on Freelancehunt. Payment will be divided into three logical steps:

Agreement on architecture and ready technical specification for our 1C programmer — 20%
Consolidation of data and setting up connections — 50%
Ready dashboard in Looker Studio, verification of numbers, and delivery of work — 30%

Please, in your response, specify: what solutions for connecting 1C and Looker Studio you have already implemented (without intermediate tables) and add a few screenshots of your real dashboards. Template responses will not be considered.

Proposals 7 Discussions

Oleg M.

22 0

Budget: 27000 UAH Deadline: 6 days

Hello!
We are the Business Atlas team, official partners of n8n. We have deep experience in the automotive sector and know exactly how to extract data from 1C and integrate it with marketing.
Our solution for your project:
1. Technical specification for 1C (BAS) via OData: I, as PM, will develop a detailed technical assignment for your programmer. We will clearly outline the registers (work orders, sales, post load) for publication in JSON via REST API.
2. End-to-end integration (n8n + API): Using n8n, we will link unique numbers from Binotel, Client ID from GA4, and client phones in 1C. You will see the journey from click to checkout.
3. Mobile-first Looker Studio: We will create a concise mobile dashboard:
Marketing: Expenses, CPL, CAC, ROMI.
Finance: Turnover, net margin (services/parts), average check.
Operations: KPI of masters and percentage of post load at the service station.
Why us:
We understand the niche: We have implemented systems for auto services, so we know the specifics of labor hours and post load.
Security: As partners of n8n, we deploy a self-hosted integration core on your VPS—no monthly limits and full control over data.
Timeline and real cost:
Project cost: $1,200 – $1,800 (depending on the final number of 1C registers and the readiness of your database for OData).
Timeline: 10–14 working days
Message me privately—we will discuss the details.

Similar project: Project Dashboard в Notion

Vasil Bodnaruk

199 2

Budget: 999 UAH Deadline: 1 day

Nikito, I see the task as complete end-to-end analytics without unnecessary storage and "workarounds." I have experience with integrations with BAS/1C, GA4, advertising cabinets, and phone systems, so I can design the connections for phone and Client ID, as well as prepare a clear technical specification for the 1C developer: which registers, tables, and export formats are needed. Separately, I will create a concise mobile-first dashboard in Looker Studio with ROMI, CAC, margin, and post loading. I am ready to discuss the architecture and show relevant cases.

Dmytro Kolba

1 0

Projects -
Rating -
Rating 339

Budget: 25000 UAH Deadline: 21 days

Good day. Specifically regarding architecture — without intermediate tables and heavy storage:

1C (BAS). Your programmer publishes 3–4 lightweight HTTP endpoints (OData or HTTP service) in the database: sales and margin by work orders broken down by services/products, loading posts, KPI for masters and managers. From me — a detailed technical specification: which registers and directories, which fields, JSON format, filters by periods. Looker Studio reads these endpoints directly through the community connector (Apps Script) — for free, without servers and storage.

Advertising and calls. GA4 and Google Ads — native connectors. Facebook Ads — there are free connector options, I will outline the pros and cons. Binotel — its call API connects with the same Apps Script connector.

Customer journey stitching (click → call → work order): by unique phone number (Binotel ↔ 1C) and gclid/Client ID (advertising ↔ GA4). I do the stitching at the connector level, not through blending in Looker — so the dashboard remains fast on mobile.

Dashboard: 3 mobile screens — Marketing (ROMI, CPL, CAC by channels), Finance (turnover, service margin vs products, average check), Operations (loading posts, KPI for managers).

Honestly regarding the portfolio: I won’t show screenshots of client dashboards — I have no NDA cases in this niche. Instead, I offer more: before the first stage, I will create a demo dashboard for you using test data from the service center with the same block structure — you will evaluate the design and logic before any payment. I work closely with Claude Code, so I prepare the technical specifications for your 1C specialist and connectors quickly and accurately.

Stages and Safe — as you have: 20/50/30. Approximately: ready technical specification — 2–3 days after discussion, full project — 2–3 weeks.

Danylo Holub

1 0

Projects -
Rating -
Rating 392

Budget: 10000 UAH Deadline: 20 days

Nikita, for the cross-sectional analytics of your CTO, it is important to build an architecture where 1C provides already prepared aggregated data to avoid overloading Looker Studio with unnecessary calculations. I will design the exchange logic via OData and prepare the structure of registers for your 1C programmer so that we can obtain clean margin and KPI without using intermediate tables.

After we retrieve data from BAS, GA4, and Asterisk, I will assemble a dashboard in Looker Studio with a focus on the mobile interface for quick operational control. This will allow us to see the actual profitability of each post and the effectiveness of managers in real time.

Is there currently a clear link in your BAS between sales and customer acquisition sources, or will this logic need to be built out through UTM tags in the CRM?