Circular Effectiveness analyzes Family Dollar Circulars. To improve the formatting of the report, we have updated the location of the SKU Desc column to now be next to the SKU column.
We have also updated the naming convention and column location of two metrics within the Circular Effectiveness Report:
● Actual Baseline Units –> Actual Baseline Comp Units
● Actual Baseline Dollars –> Actual Baseline Comp Dollars
The Custom Table Manager now has a new SKU Expand checkbox for Product > Item SKU! The SKU expansion functionality allows you to create custom tables that expands your list of Primary SKUs and Item SKUs to the Item SKU level.
The scheduled CIP and Platform upgrade has been completed. Upon login, you will now be taken to prime-16.42. The new CIP version is v4.13. You can review the new features of CIP here. You can review the features of prime-16.42 here. If you encounter any issues, please contact support@1010data.com.
Please be advised that CIP will be undergoing a maintenance period tonight beginning at 5PM PST in order to upgrade from v4.10 to v 4.13. In addition, the platform will be upgraded from prime-14.42 to prime-16.42.
As part of our routine maintenance please note that as of January 30, 2021, we will only retain 2.5 years of data on the system. The data retained will go back to WM Week 201826. This will affect all subject areas. You will not have to manually update your reports unless you have specific date filters that relate to the date range that has been purged. Please let us know if you have any questions or concerns.
Fully Loaded Margin Metrics
On Wednesday, January 13, 1010data released the following enhancements to the Fully Loaded Margin metrics in Sprouts Guided Ad Hoc:
New Metrics:
• Adjustments – Opening Promo
• Adjustments – Product Cost
• Adjustment – Shrink BTP
• Adjustments – Shrink
• Adjustments – Rebates
• Adjustments – Net Sales
• COGS – Product COGS
• Opening Promo
• Forecasted Opening Promo
• Forecasted Finished Margin
• Forecasted Rebates
• Forecasted COGS
• Forecasted Shrink
• Product Margin
• Product Margin %
• Finished Margin %
Updated Metrics:
• Total Billback is renamed to Rebates – Scan BB
• COGS – Shrink
Fifteen (15) metrics developed using Sage data will no longer be available in GAH. They will be supported in existing saved reports under their old labels followed by an (OLD) suffix.
To learn more about the definition of the new and updated Fully Loaded Margin metrics, please visit the Glossary tab in GAH.
For more details, please refer the detailed Release Notes.
Family Dollar Quick App reports have moved into a folder within the Report Launcher, making them easier to access for day-to-day reporting. These reports can be accessed by opening the Family Dollar Folder.
Family Dollar Quick App reports have moved into a folder within the Report Launcher, making them easier to access for day-to-day reporting. These reports can be accessed by opening the Family Dollar Folder.