ecommerce sales analysis pro

The problem

Standard e-commerce dashboards often hide financial leaks by blending verified facts with guesses. Relying on uncleaned sales data leads to poor inventory and pricing decisions that prioritize the wrong products.

What it does

• Cleans raw sales exports by handling duplicates, returns, and outliers while enforcing strict currency conversion rules.
• Calculates "Margin Leak" in both percentage and total currency value to identify which products impact the bottom line most.
• Segments insights into "Proven" facts versus "Suggested" hypotheses to prevent acting on unverified assumptions.
• Generates a prioritized executive synthesis focusing on the highest-impact financial actions first.

Frameworks & tools

Shopify, Etsy, Amazon, WooCommerce, CSV, Excel, and Python for data processing.

Why this beats prompting it yourself

Standard prompts often hallucinate currency exchange rates or overlook the difference between a low-margin product and a high-volume margin killer. This skill enforces a professional audit workflow that explicitly separates data-backed facts from analytical suggestions.

Use cases

• Identify which best-sellers are losing the most profit in total value despite high revenue.
• Audit a messy multi-currency export to establish a single source of truth for reporting.
• Prioritize which products to reprice or discontinue based on real financial stakes.
• Analyze customer retention and seasonal trends with a clear distinction between proof and theory.

Known limitations

Cannot calculate margins if unit costs are missing from the data. Will not automatically fetch live exchange rates; requires manual confirmation of deduced rates.