Real-Time Walmart Analytics Dashboard
Timeline: 24 Months| Country: USA
Project Brief
Kanhasoft developed the Real-Time Walmart Analytics Dashboard, a robust SaaS platform designed specifically for Walmart sellers in the USA. This data-driven solution helps sellers monitor, analyze, and optimize their store performance by integrating directly with Walmart’s APIs. The platform fetches real-time data across sales, advertising (PPC), keyword rankings, and product-level metrics—transforming it into actionable visual insights. The system empowers users to make informed decisions, improve profitability, and track both organic and paid performance from a unified dashboard.
With support for multi-store access, historical comparisons, exportable reports, and subscription-based access, the platform offers scalability and usability for teams of all sizes. Features like role-based permissions, keyword rank tracking, and profitability breakdowns enable operations, marketing, and leadership teams to collaborate effectively. Deployed on AWS with a tech stack of Node.js, React.js, Python, and PostgreSQL, the platform ensures speed, security, and high availability—making it an essential tool for serious Walmart marketplace sellers.
Client's Need
The client needed a centralized analytics system to:
- Integrate with Walmart’s live APIs for sales, ads, and product data.
- Offer real-time insights on sales performance, keyword rankings, and profitability.
- Support multiple Walmart stores under one account with secure, role-based access.
- Enable report exports and implement subscription billing features.
Technologies
-
|
React JS
-
|
Node JS
-
|
Postgresql
-
|
Python
-
|
AWS
Start now with a pre-vetted developers.
Challenges
- Large API Data Volumes: Managing high-frequency data from Walmart APIs across multiple sellers while handling rate limits and ensuring accuracy.
- Real-Time KPI Updates: Delivering fast, dynamic performance metrics across various timeframes without slowing down the dashboard.
- Multi-Store Management: Supporting users with multiple Walmart stores and advertiser IDs within a single, organized dashboard.
- Heavy Data Exports: Allowing users to export large PPC, sales, and profit reports in Excel without performance issues.
- Keyword Rank Tracking: Monitoring organic keyword rankings over time without direct API support from Walmart.
Solution By Kanhsoft
Kanhasoft delivered a full-stack SaaS application that:
- End-to-End SaaS Platform: Developed a scalable, cloud-based analytics solution tailored for Walmart sellers with real-time data processing.
- Direct Walmart API Integration: Connected with Walmart's Advertising, Orders, and Catalog APIs to fetch live data on PPC, sales, item metadata, and keyword performance.
- Real-Time Dashboards: Built interactive dashboards for KPIs like TACoS, TRoAS, profit margins, keyword rankings, and SKU-level insights.
- Multi-Store & Multi-Advertiser Support: Enabled users to link and manage multiple Walmart store accounts from a unified dashboard.
- Advanced Reporting & Export: Implemented Excel export of high-volume data with filters, custom columns, and grouped views for PPC, Sales, and PnL reports.
- Keyword Rank Tracking Engine: Created a Python-based crawler to monitor and log organic keyword rankings over time, even without a public API.
- Efficient Data Handling: Used BullMQ for background job processing and PostgreSQL materialized views for faster query performance.
- User Management & Access Control: Integrated role-based access for teams and administrators, ensuring secure and segmented data visibility.
- Stripe-Based Billing System: Added monthly and yearly subscription plans with automated billing and user access control via Stripe.
- Robust Cloud Infrastructure: Deployed on AWS using EC2, RDS, S3, and CloudWatch to ensure scalability, uptime, and monitoring.
Key Features
- PPC Dashboard: View ad sales, spend, organic vs. paid comparisons, and advertiser-level metrics.
- Sales Dashboard: Analyze orders, units sold, TACoS, TRoAS, and category-wise performance.
- PnL Dashboard: Track gross/net profit, fees, and profitability by SKU or brand.
- Keyword Tracker: Monitor organic rank trends over time.
- Items Tab: View item metadata including GTIN, COGS, pricing, and search filters.
- Multi-Store Management: Manage multiple Walmart stores and advertiser IDs in one view.
- Subscription & Access: Stripe-integrated monthly/annual plans with role-based user permissions.
- Data Export: Export PPC, sales, and profit data to Excel with grouped or filtered views.