📌 Method: MonthlyProductRevenue
This article explains how we calculate monthly revenue from product sales.
How is product revenue calculated?
Find all products purchased in the period
We retrieve all orders from the database.
Filter by segment
Data can be broken down by gender, age, or product category.
Calculate total revenue per month
We sum up all product sales.
Visualize data
Data is displayed in a range chart that shows monthly product revenue.
Example calculation
We calculate product revenue for January and February.
Month | Products sold | Average price | Total Revenue |
January | 150 | 200 kr. | 30.000 kr. |
February | 180 | 220 kr. | 39.600 kr. |
Calculate revenue for February:
180×220=39.600 kr.180 \times 220 = 39.600 \text{ kr.}180×220=39,600 kr.
Average product revenue per month:
30.000+39.6002=34.800 kr.\frac{30.000 + 39.600}{2} = 34.800 \text{ kr.}230,000+39,600=34,800 kr.
Why is this important?
✔ Understand which products are selling best
✔ Identify trends and seasonality
✔ Optimize inventory based on demand
💡 Result: A graph showing the product revenue per month.
Do you have any questions? Contact us via the Intercom chat! 😊