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

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

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 Express JS PostgreSQL Redis

Project ID: #21896184

About the project

7 proposals Remote project Active 4 years ago

Awarded to:

emyboybeats

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)
0.0

7 freelancers are bidding on average ₹52024 for this job

kroim

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)
5.7
Appicsoftwares

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)
0.0
shankarinfoxeron

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)
0.0