Consolidation of data and setting up connections

Data sources:

• 1C (BAS): our sales, net margin (distribution between services and goods), workload of service posts, KPIs 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:

1. Design the logic of data connection without inflating the budget for heavy cloud storage.
2. 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 specific tables, registers, and in what format he should export.
3. Glue data by cross identifiers (phones, Client ID), so we can see the full path: from clicking on the ad and calling to closing the order in 1C.
4. 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 (post load, sales by managers).