Create data aggregation in mongo.js / express.js
There is an API on Express + Mongo
In Mongo, there are tables:
1. User visits to the site (timestamp + url they visited + other details)
2. Campaigns (which advertising campaign they came from)
The connection between users and campaigns is through GET parameters within the URL that the user visits.
For example -
Campaign X is identified by the parameter "specialParam".
User Y visited on January 1, 2025, the link www.ourapp.com/some-page?specialParam
Therefore, the user came through ad campaign X.
An API endpoint needs to be created with aggregation that provides statistics on campaigns, as shown in the attached screenshot
Conversions - "purchases" by users, how to determine conversion will be discussed in more detail, not in the description.
Sessions - all visits within a half-hour period count as 1 "session". When the half hour expires, it counts as the next one.
Total entries - how many visits there were from the campaign over a period of time
Avg.pages - average value
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 4 hours 54 minutes back ∙ 9 proposals |
Development of Backend core (Python), Telegram FSM engine, and Stripe integrationWe are looking for an experienced Backend Developer (Middle/Senior) to create an independent Headless core for an EdTech product. The system operates on a strict monthly subscription model. The core logic must be completely isolated from the content. All development is conducted… Python, Databases & SQL ∙ 11 hours 4 minutes back ∙ 23 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 16 hours 44 seconds back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 19 hours 32 minutes back ∙ 32 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 4 hours back ∙ 36 proposals |
Тель-Авив