Cross-analytics
111 USD 1. Goal
To build end-to-end analytics in the information business so that we can:
see the full customer journey from the first touch to the sale
understand where each person came from
link all actions to one user
analyze the effectiveness of advertising, the bot, webinars, and sales
output analytics to Looker Studio (Google Data Studio)
We ask you to propose a solution and technical implementation from your side.
2. Overall Customer Journey (AS IS)
Targeted Advertising
Website
Chatbot (SendPulse)
Telegram Channel
WebinarStars
Application
Sale
CRM (custom-built) — recording all stages
3. Detailed Customer Journey from the Analytics Perspective
Step 1. Advertising → Website
The user transitions from the advertisement to the website.
We want to understand:
which advertising campaign they came from
so that this information is not lost at subsequent stages
Step 2. Website → Chatbot (SendPulse)
The user transitions from the website to the chatbot.
We want:
to identify this user
to save information about the traffic source
to continue working with the same person, not with “separate events”
Step 3. Chatbot → Telegram Channel
In the bot, the user transitions to the Telegram channel.
We want:
to record the fact of the transition/subscription (if possible)
to understand that this step was taken by a specific person
Step 4. Chatbot → WebinarStars
Registration for the webinar occurs through the chatbot.
Important:
the user registers for the webinar not directly, but through the bot
after registration, they simply transition to the webinar room
We want to see:
who registered
who attended
who left an application
and link this to previous stages
Step 5. WebinarStars → Application
During or after the webinar, the user leaves an application.
We want:
the application to be linked to the same person
to see which advertisement/path it came from
Step 6. Application → Sale
After the application, a sale occurs (or does not occur).
We want:
to see which applications reach payment
to track revenue by sources
to understand the effectiveness of each stage of the funnel
Step 7. CRM (custom-built)
CRM is the central point where all data should converge.
In the CRM, the following is stored:
one user
their journey
their actions
application
sale
There is a technical specialist who can assist with refining the CRM and integrations.
4. Analytics and Visualization
We have been recommended to use Looker Studio (Google Data Studio).
It is necessary to:
evaluate whether Looker Studio is suitable for this task, or propose an alternative
We want to see in the end:
the customer journey by stages
conversions between stages
advertising effectiveness
webinar effectiveness
revenue
Please propose the cost of work and time for completion
-
1 day111 USD
1562 7 0 1 day111 USD
I am among the top 5 developers in the category of "Artificial Intelligence and Machine Learning" among ~2100 specialists on the platform.
I guarantee:
- Fast and quality execution of the task
- Clear adherence to deadlines
- Regular communication throughout the entire process
I would be happy to discuss the details of your project in private messages.
-
25 days601 USD
297 1 25 days601 USD
Hello.
This project is about creating a true comprehensive analytics system for the info business, where every user action, from clicking on an ad to making a sale, is connected in a single customer journey. I would develop a unified strategy for data identification and transfer (saving UTM, user identifiers, bot parameters, webhook integration), so that data on traffic, bots, webinars, CRM, and sales are linked to a single user profile. I will centralize events in your own CRM (or a simplified data layer) and structure them for clear export to Looker Studio, with sales funnels, conversions, and revenue attribution by source.
-
2 days111 USD
324 1 0 2 days111 USD
Hello! I will do it quickly and efficiently.
Current freelance projects in the category Databases & SQL
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 2 days 15 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 4 days 18 hours back ∙ 55 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 4 days 19 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 5 days 7 hours back ∙ 10 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 5 days 13 hours back ∙ 13 proposals |
Kyiv