Develop a web application with Postgres, Node, React & Express

Hi all

I need a web application built for basic clickstream analytics and marketing automation. For reference, checkout tools like Mixpanel and Amplitude.

These are tools used to understand user behaviour on websites and send the push notifications or emails based on the actions they have taken.

The tool has two parts:

a) Analysis: deals with helping site managers (referred to as users henceforth) understand how people use their website.

b) Marketing Automation: provides a way for defining the logic based on which communication needs to be sent out to the user. For example, users who watchlisted a product in the last 3 months, then added it to cart, but did not complete a purchase should get a notification nudging them to complete the purchase.

Part A: Analysis

The tool reads data that is already written in a Postgres database. The database has details of actions performed by the visitors on a site and some details in the metadata of the visitor profile. 

Different screens on the tool are used to filter and group event data (or visitor profiles) based on conditions specified by the user. 

Following are some examples:

i) Let's say the action 'Added to Cart' was performed 100 times in the last month, and user would want to see how different rated products performed across categories. So, we need to provide a way to group the count of 'Added to cart' action by productCategory and productRating (properties available in the database).

This is essentially a graphical query builder with where and group by clauses.

We'll have similar screens to create groups of visitors based on criteria specified by the user, and to then save this template. The criteria will be of the sort - visitors who performed a certain action and show certain properties (metadata of visitor profiles).

ii) Funnel analysis: Funnels are used to see the drop-off between consecutive steps in the user flow. For example if x people land on your homepage, what percentage moves on to view product details and of those how many complete the purchase.

Part B: Marketing Automation:

Website managers need a way to send out specific communications based on user activity. For example, when you add a product to your cart but not purchase it, you might get a notification to nudge you to buy. The logic for this would look straightforward, but one can see how instead of just one step, this could be a series of actions, for example having added to cart after watchlisting a product. We need to create a screen that allows the user to specify such conditions  and save the json in the db.

Another cron job that runs every minute will have to be developed which reads the json saved in the db and sends out the relevant communication via either android or ios notifications or emails.

The structure of the project is as follows:

Checkpoint 1: Backend for analysis

Checkpoint 2: Frontend for analysis

Checkpoint 3: Backend and frontend for marketing automation

Checkpoint 4: Cron job to send out notifications & emails.

Additionally, well-structured documentation is a must.

Please include the line 'I have read your description and checkpoints' in your proposal so I know you have read it.

Node.js React.js エクスプレスJS PostgreSQL Redis

プロジェクトID: #21896184

プロジェクトについて