In Progress

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.

Skills: node.js, React.js, Express JS, PostgreSQL, Redis

See more: react node express postgres, using postgresql with react, node-postgres example, node.js postgresql crud example, node postgres schema, react node js postgresql, node js postgresql stored procedure, node js postgresql tutorial, javascript, node.js, angular.js, react native

About the Employer:
( 0 reviews ) Manipal, India

Project ID: #21896184

Awarded to:


I know I don't stand out from the rest in anyway, but I know that with these few skills of mine and my appetite to learn new things I can add value to your organization Relevant Skills and Experience I have 3 years ex More

₹41666 INR in 20 days
(0 Reviews)

9 freelancers are bidding on average ₹54491 for this job


Greetings to you my dear!. I saw your project description in detail. I have experiences in web field using JavaScript frameworks and PHP frameworks, python frameworks. Also, I can develop mobile apps. - php, node. More

₹50000 INR in 20 days
(18 Reviews)

Dear Hiring Manager, Reading your job posting piqued my interest. I' m a senior web developer for 7+ years of experience and am very familiar with Python, PHP Framework( CodeIgniter, Laravel, WordPress, OpenCart, Cak More

₹70000 INR in 7 days
(1 Review)

Hello Sir, I have read your requirement carefully. you need a new web application right.?? I can do this job easily.. I have great knowledge in core,cordignetor and Laravel. More than 6+ year experience. I have alr More

₹60000 INR in 15 days
(0 Reviews)

Dear Employer,Greetings from D3itsolutions!!!!!!!!!!!!! I will glad to help you out with your project because i have very good experience in web & Mobile designing and development in different platform . We are ex More

₹56250 INR in 7 days
(0 Reviews)

hello i have read to your project requirements . i can create in your budget with wonderful themes and user interface and delivery to be on the time and provide for support 24*7

₹56250 INR in 7 days
(0 Reviews)

Hello, Greetings from Vixplor Analytics Pvt Ltd, a startup recognized by NASSCOM and TIE. We have gone through your requirement and interested to work on this. We have developed cross platform Website in React JS. Our More

₹50000 INR in 14 days
(0 Reviews)

Hi, My name is Shubham, I am Solution Architect with 8 years of IT experience in App and Web development, my core area of programming is the JAVA SCRIPT and I can also help you with framework like Ionic 4 and Phonegap. More

₹56250 INR in 7 days
(0 Reviews)

Hey, Would love to discuss this in detail. I have 4 years of experience in all things Salesforce, started as an intern in a Salesforce Development company and went on to become Team Lead for major clients. Experienced More

₹50000 INR in 30 days
(0 Reviews)