Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

05/27/26 15:32:09 (109 minutes ago)

Author:

232012

Comment:

--

AdvancedReports

@@ -4 +4 @@
 
 {{{#!div style="text-align: justify; width: 100%;"
-This report is meant to look at the best-selling items over **<period of time>** to figure out exactly when they will sell out and how products should be repurchased. By calculating how many copies of a specific vinyl, CD, or cassette are sold every day and comparing that speed to what is left in stock, the query will find items that will run out of stock in **<period of time>**. It then automatically calculates the perfect order amount to keep the store supplied for the next **<period of time>** without overspending, ensuring top money-makers are never missing from the shelves.
+This report is meant to look at the best-selling items over the last year to figure out exactly when they will sell out and how products should be repurchased. By calculating how many copies of a specific vinyl, CD, or cassette are sold every day and comparing that speed to what is left in stock, the query will find items that will run out of stock in less than a month. It then automatically calculates the perfect order amount to keep the store supplied for the next three months without overspending, ensuring top money-makers are never missing from the shelves.
 }}}
 
@@ -22 +22 @@
 
 {{{#!div style="text-align: justify; width: 100%;"
-This report is meant to look at items that are completely stuck in inventory. The query scans the database to find products that have either never been bought or have had zero sales for more than **<period of time>**, while also checking if customers are still adding them to their wishlists or ignoring them completely. It multiplies the current unsold stock by the item's original price to show managers exactly how much cash is frozen in dead inventory, making it easy to see which releases need discounts.
+This report is meant to look at items that are completely stuck in inventory. The query scans the database to find products that have either never been bought or have had zero sales for more than six months, while also checking if customers are still adding them to their wishlists or ignoring them completely. It multiplies the current unsold stock by the item's original price to show managers exactly how much cash is frozen in dead inventory, making it easy to see which releases need discounts.
 }}}
 
@@ -40 +40 @@
 
 {{{#!div style="text-align: justify; width: 100%;"
-This report checks if discounts and promotions created by product managers actually bring in more profit or just lose money. It monitors sales numbers **<period of time>** before and **<period of time>** after an administrator modifies a product to lower its price. By comparing the drop in profit margin per item against the increase in total orders, the query would prove whether the discount caused a big enough wave of new buyers to make the promotion successful or if it just hurt the overall revenue.
+This report checks if discounts and promotions created by product managers actually bring in more profit or just lose money. It monitors sales numbers 30 days before and 30 days after an administrator modifies a product to lower its price. By comparing the drop in profit margin per item against the increase in total orders, the query would prove whether the discount caused a big enough wave of new buyers to make the promotion successful or if it just hurt the overall revenue.
 }}}
 
@@ -60 +60 @@
 
 {{{#!div style="text-align: justify; width: 100%;"
-This report tracks how registered users behave over a **<period of time>** by looking at how they earn and spend their rewards points. It groups buyers based on the year they created their accounts and measures their total shopping history alongside their points balance to see who is saving up thousands of points and who is actively spending them. This helps find high-value users who hold a large number of unspent points, which represents a future discount cost and can indicate if customers stop buying completely once their free rewards are used up.
+This report tracks how registered users behave over a period of two years by looking at how they earn and spend their rewards points. It groups buyers based on the year they created their accounts and measures their total shopping history alongside their points balance to see who is saving up thousands of points and who is actively spending them. This helps find high-value users who hold a large number of unspent points, which represents a future discount cost and can indicate if customers stop buying completely once their free rewards are used up.
 }}}