Компанія продає через Amazon Vendor Central в Європі, потрібно створити дашборд в power bi який буде працювати з АРІ амазона і рахувати профіт, більше деталей нижче:

Core Functionality:
Sales Analytics per ASIN
- Total sales per ASIN (in EUR)
- Number of units sold
- Comparison between two selected periods (e.g., month-over-month or year-over-year)
- Sales trend chart (with date range filtering)
Returns
- Number of returned units per ASIN
- Total return value
- Amazon refund compensation amount
- Return reasons (if available)
Marketing Promotions
- Promo spend per ASIN
- Number of units sold during promotions
- Types of promotions (e.g., discounts, buy 1 get 1)
Advertising Statistics
(Integration with Amazon Advertising API)
- Impressions, Clicks, CTR, CPC
- Total ad spend
- ACOS, ROAS
- Number of orders generated through ads
- Breakdown by campaign/ad group/keyword
ASIN Conversion Metrics
- Conversion rate: purchases / page views
- Product page traffic (Sessions / Page Views)
- Conversion trend over time
Profitability Calculation
For each ASIN, the following must be included:
- Profit in EUR, margin, ROI
- TACoS calculation
- To ensure accurate net profit calculation, include:
- Manufacturing cost per unit
- Advertising spend
- Promotion expenses
- Cost of returned items
- Other fees (e.g., logistics, Amazon deductions if any)
---
Additional Features
- Export to CSV / Excel
- Dashboard with filtering by country, product, and date
- Anomaly alerts (e.g., sudden drop in sales, spike in returns)
Technical Requirements
- API integration with Amazon Vendor API and Advertising API
- Multi-region support (Germany, France, Italy, etc.)
For the Seller account, we use the Sellerboard service, it calculates profit perfectly, we need a similar solution to obtain business profitability indicators