DBS
Below is an introduction to the project (what already exists) + what needs to be done next.
WHAT NEEDS TO BE DONE (our vision, briefly)
1) Design a “cross-cutting” attribution scheme and mandatory fields:
- what we consider a lead, how we distinguish duplicates, what statuses/stages, which fields are mandatory.
2) Close the main gap — online booking:
- ensure the transfer of the source/campaign (UTM/click-id) to the booking and further into ROapp
- option: gateway/bridge on our domain or rework/custom booking.
3) TikTok:
- propose a working solution on how to capture leads and their source, despite the absence of chats in CRM
- minimum: event/metadata tracking and a clear procedure, maximum: automation/export.
4) Gather analytics “in one place”:
- set up exports/data collection (ROapp + advertising accounts + Unitalk)
- create a dashboard (for example, Looker Studio) and quality control: “leads without source”, “lost leads”, conversion by funnel.
WHAT WE EXPECT FROM YOU
- Proposal of your architecture/approach (how you will solve online booking and TikTok).
- Understanding what data can actually be retrieved from ROapp/Apix Drive/Unitalk and advertising accounts.
- Implementation or setting up implementation: integrations/exports/storage/dashboard + documentation.
- Result: minimal manual labor, transparent attribution, unified statistics across all channels and campaigns without loss of leads.
WHAT IS ALREADY SET UP:
1) CRM: ROapp — we manage leads/clients and work on inquiries in it.
2) Sources of leads that we use: TikTok, Meta (Facebook/Instagram), Google, Seznam, calls, online booking from the website.
3) Messages are already getting into CRM (via Apix Drive) from:
- Telegram
- Facebook / Instagram (DM)
4) Call tracking: Unitalk — connected and integrates with ROapp, attribution/accounting for calls “in general” works.
5) Online booking: available on the website, but this is an external/separate reservation system (different domain) → further booking/contact goes into ROapp.
6) A table for manual marketing accounting exists, but maintaining it manually is difficult and there is a risk of loss/errors.
7) Limitation: TikTok messages/chats do not flow into ROapp (no integration / API is limited), and there is no convenient export of these chats from the CRM interface.
-
5 days174 USD
1632 18 1 1 5 days174 USDHello.
I can complete the task. I have experience in this area. The deadlines and cost are approximate - we need to discuss the details.
Write to me, I will do everything quickly and efficiently.
-
30 days407 USD
2259 5 1 30 days407 USDHello! I have reviewed your assignment and believe that I can successfully complete it. I would be happy to collaborate, please write to me personally for further details.
-
3 days232 USD
738 9 1 3 days232 USDHello! Having studied your project with great interest, I am ready to start working on it. Let's discuss the details to achieve the best result.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout 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 ∙ 7 hours 23 minutes back ∙ 3 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 9 hours 14 minutes back ∙ 28 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 ∙ 10 hours 21 minutes back ∙ 15 proposals |
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 19 hours 55 minutes back ∙ 6 proposals |
1C data integrationOrganize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 1 hour back ∙ 9 proposals |