Home > MEGA Report > Promo Residue
MEGA Report - Promo Residue
Experimental v1
This macro-enabled Excel Promo Residue workbook is designed to help stores find residual SKUs left over from promotional sales.
Online Report Access Help
Steps for retrieving online reports
1. Locate one of Mango's monthly Action, Review or Excel emails.
2. You will find the login link, username, and password in the body of the email.
3. Click the link and enter your credentials to log in.
4. On the left-hand navigation window, you'll see a Data Import + Multi-Store folder as well as a listing of all the stores in your organization.
5. Click on the desired folder and the contents will display on the right-hand side.
6. You may want to change the view to be Detail as it's easier to navigate.
7. If you click on a specific store you'll need to select the Excel or PDF folder depending on what report you're after.
8. The Excel folder houses store-specific workbooks like the Mango_IVA, Location, and Class Productivity, Delete Report, Vendor Analysis, etc.
9. You can either go back on your web browser or on the left-hand side, click the PDF folder.
10. The PDF folder contains that same reports that are emailed each month in the Action, Review, and Excel email.
11. Click on the file you'd like to download, a new page will load and you can click on the "Page icon" or the download button in the upper right.
12. If you'd like to download an entire folder of reports, say Data Import + Multi-Store, click on the root folder and then the download button.
13. And if you want to download EVERYTHING, then click on the highest root folder and then the download button.
I - Ext Avg Cost: QOH multiplied by Average Cost J - On Promo: Currently on promo as of the first of the month K - Promo Price: The current or most recent promotional price
L - Retail: Latest Retail Price
M - Rep Cost: Replacement Cost N - Regular Margin: Margin at retail price
O - Promo Margin: Margin at promo price P - Months Supply: remaining months supply if sold at promo Q - Non-Promo Months Supply: remaining months supply if sold at full retail
R - Promo Percent:
S - Promo Frequency TTM: Percent of months the SKU has been on promo in the last 12 T - Last Month Promo Sales Units: How many sold last month on promo
U - Action: Recommended steps to take on the SKU V - Last Action: