Develop a web application with Postgres, Node, React & Express
₹37500-75000 INR
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.
Project ID: #21896184
About the project
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
7 freelancers are bidding on average ₹52024 for this job
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
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