RealEstateManager | Implement basic functionality

[alexeysp11]

Description.

Basic functionality of RealEstateManager:

• MS SQL -> PostgreSQL.
• README (English, Russian).
• Implement the basic functionality of this application.
• Assess whether it is possible to use analytics on user activity in this application (if yes, by what parameters).

[alexeysp11]

Approximate description of functionality for user activity analytics

Implement a simplified version of the main dashboard of the personal account. The dashboard contains the following parameters: search quantity (mobile traffic, web traffic), number of clicks, number of orders. Deploy a web server that will give the necessary data to the frontend.

The data is as follows:

{
  "errors_last_3days": [
    {
      "count": 2,
      "code": 502
    },
    {
      "count": 720,
      "code": 599
    },
    {
      "count": 1780,
      "code": null
    }
  ],
  "errors_yesterday": [
    {
      "count": 615,
      "code": null
    },
    {
      "count": 305,
      "code": 599
    }
  ],
  "errors_last_hour": [],
  "data": [
    {
      "bookings_current_last_3days": 7556,
      "timeout_yesterday": 0.217542189065684,
      "zeroes_yesterday": 5.03052033295241,
      "avg_price_yesterday": 9447.87135852322,
      "clicks_current_last_hour": 428,
      "avg_price_last_hour": 10243.0263157895,
      "zeroes_last_hour": null,
      "mobile_pessimizer": 0.000999999974737875,
      "bookings_current_last_hour": 32,
      "searches_current_last_3days": 4445192,
      "bookings_previous_last_hour": 98,
      "str_yesterday": 14.9289099526066,
      "errors_yesterday": 0.376232384954177,
      "ctr_last_hour": 0.640574721245229,
      "gate_id": 20,
      "ctr_yesterday": 1.06052388326287,
      "searches_current_yesterday": 2188541,
      "bookings_previous_last_3days": 8647,
      "zeroes_last_3days": 5.55262854787825,
      "clicks_previous_last_hour": 784,
      "timeout_last_3days": 0.122851836321131,
      "errors_last_3days": 0.143953287057117,
      "bookings_previous_yesterday": 3641,
      "searches_previous_yesterday": 2050500,
      "searches_previous_last_hour": 88385,
      "str_last_hour": null,
      "clicks_previous_yesterday": 23364,
      "avg_price_last_3days": 10694.8964067661,
      "searches_current_last_hour": 66815,
      "web_pessimizer": 100.0,
      "ctr_last_3days": 1.12946752356254,
      "clicks_previous_last_3days": 60505,
      "str_last_3days": 15.0496942657398,
      "timeout_last_hour": null,
      "clicks_current_last_3days": 50207,
      "bookings_current_yesterday": 3465,
      "searches_previous_last_3days": 6118984,
      "errors_last_hour": null,
      "clicks_current_yesterday": 23210
    }
  ]
}

Analytics allows website owners to:

• Understand user behavior.
• Evaluate the effectiveness of marketing campaigns.
• Optimize content and user experience.
• Make informed decisions based on data.
• Increase conversions and revenue.