ANDYOU.PH

Each metric card needs a sparkline chart showing trend for selected date range. Generate one data point per day. Use same color scheme as card border. Charts should be interactive with tooltips showing date and value on hover.

Set up automated alerts for CVR and Rev/Session. Trigger when: (1) Value drops below threshold, (2) Downward trend for 3+ consecutive days, (3) Percentage drop exceeds 15% from 7-day average.

ALERT VISUAL EXAMPLE: Notice the CVR and Rev/Session cards above have red borders, red alert badges, and downward trending red charts. This is how all alert metrics should appear throughout the dashboard.

Trigger alert when bounce rate exceeds 45% for 2+ consecutive days or spikes 10% above 7-day average.

Each funnel needs separate data streams for ED (Erectile Dysfunction), WL (Weight Loss), and HR (Hair Regrowth). Track these 8 steps for each category: Landing Page Views → Quiz Start → Quiz Completed → Approved Results Page → Product Page View → Add to Cart → Initiate Checkout → Purchase. Calculate conversion rates between each step. Apply alert styling to steps with conversion rates below thresholds (to be defined per category).

Set category-specific alert thresholds. Monitor these critical drops: (1) Quiz Completion below 70%, (2) Add to Cart below 25%, (3) Checkout below 65%, (4) Any step with >20% day-over-day decline. Highlight alert steps with white border glow.

Implement tab switching functionality. Load product data dynamically based on selected category. Product names should link to actual PDPs (e.g., https://andyou.ph/products/ozempic). Implement sorting on each column header. Highlight rows where ATC% is below 20% (alert threshold).

Calculate weighted averages for all metrics based on total views/actions per category. This provides high-level category health before drilling into individual products. Color code rows based on performance: green for above benchmark, yellow for near benchmark, red for below.