E-commerce Performance Dashboard for Shopify, Shopee, and Lazada

Project Title: E-commerce Performance Dashboard for Shopify, Shopee, and Lazada

Project Description: This project is a comprehensive E-commerce Performance Dashboard designed and implemented using Retool. The dashboard provides a real-time overview of e-commerce operations across multiple sales channels (Shopify, Shopee, Lazada) for the brand "uma." It presents detailed insights into revenue, orders, gross profit, and profit margins, segmented by countries (USA and Philippines) over the last month.

Key Features:

Revenue and Profit Tracking: Displays total revenue, total orders, total gross profit, and margin percentages, both globally and by country (USA and Philippines).

Interactive Time Series Charts: Visualizes daily trends of total sales, gross profit, and gross margin percentages throughout the month.

Country-Based Segmentation: Allows users to filter and analyze performance metrics per country.

Detailed Daily Breakdown Table:

Date Range Selection: Filters like Yesterday, Last 7 days, Current month, Last month, or Custom date range.

Team Collaboration: Built and managed by "Team Retoolers" (teamretoolers.io).

Frontend: Retool

Data Sources: E-commerce platform APIs (Shopify, Shopee, Lazada)

Backend: Retool queries for live data fetching and aggregation

Monitor and optimize sales performance.

Identify low-margin or loss-making days quickly.

Compare performance between different markets.

Make informed decisions about marketing spend and operational costs.