(1) Description: I want you to create a Customer Feedback Dashboard for me: the goal is to receive all feedback into one place. We want to be able to draw conclusions from the feedback that will help shape our development road map, and what we need to improve in our platform to make the user experience better. We also want to be able to easily and clearly see the feedback that is mentioned the most, as that is the feedback we should pay the most attention to since most of our customers are saying the same thing.
(2) Technical Requirements: Backend/Database: Use Supabase (Postgres + Auth + Storage) as your primary backend. Store all ingested data (emails and screenshots) in structured tables with proper relations to customer records. Authentication & Access Control: Implement Supabase Auth with domain-restricted sign-up — only users with a @vamo.app email address should be able to create accounts. Enforce data access at the database level using Supabase Row Level Security (RLS) policies — all tables must have RLS enabled, and policies should ensure that only authenticated users with a verified @vamo.app email domain can read, insert, or modify any data. No application-level authorization checks alone — RLS must be the primary enforcement layer Make this system extensible (e.g. easy to add on and remove filters, if needed)
(3) Acceptance Criteria: A01: I need to be able to send and store all customer feedback that I receive in a central place. I should be able to email customer feedback to an email, and have it stored in our Dashboard A01.1: Each feedback should be stored under a Customer Email. The subject line should indicate which Customer to store the feedback under A01.2: I should be able to manually change the Customer email assigned to each feedback A01.3: If no customer is inputted, all unassigned feedback should be put into a tag for manual assignment A01.4: The body of the email will contain the actual feedback. I should either be able to copy and paste feedback (in text form) into the body, or attach screenshots, and the system should be able to read the text in the screenshot into the dashboard
A02: Feedback should be auto-tagged Tagging System: If a Customer is talking about a UI problem, the tag should be “UI” If a Customer is talking about a bug, the tag should be “Bug” If a Customer is talking about a Search Bar problem, the tag should be “Search Bar” If a Customer is talking about a Search Results problem, the tag should be “Search Results” If a Customer is talking about a Filter problem, the tag should be “Filter” If a Customer is talking about a Sequences problem, the tag should be “Sequences” If a Customer is talking about an Inbox problem, the tag should be “Inbox” If a Customer is talking about an Integrations problem, the tag should be “Integrations” Generally speaking, if a Customer’s tone/sentiment is positive, the tag should be “Positive Feedback" Generally speaking, if a Customer’s tone/sentiment is negative, the tag should be “Negative Feedback” A02.1: A piece of feedback should be able to have multiple tags A02.2: I should be able to change tags manually in the Dashboard after the system auto-tags it to the best of its ability
A03: There should be a filtering system A03.1: I should be able to filter all feedback by Customer A03.2: I should be able to filter all feedback by a specific tag A03.3: I should be able to filter all feedback within certain date ranges based on when the customer feedback was entered into the system A03.4: I should be able to apply all of these filters at once, or any combination of them
A04: I should be able to generate Customer feedback summaries. For example, if I want a summary of all of the feedback from all Users in the last week, it shouldn’t just output a list of every piece of feedback. It should summarize the feedback into the most salient points A04.1: I should be able to create summaries that have 1 or multiple or all customers A04.2: I should be able to create summaries that have 1 or multiple tags A04.3: For the summaries, it should give more weight/prioritize the feedback that has been mentioned multiple times or shares the same sentiment someone else has expressed in the given date range
(4) Deliverable: Submit a screen recording / video walkthrough of you using the application end-to-end demonstrating the ingestion of emails and screenshots, and the generated summaries (which can be daily or in a given time frame, whatever the user selects)
