Minimum Version Required: 25.01
Pre-Conditions
Brand Strength Index is a weighted sum of sales data that results in a single numerical value that can be used to compare brands to each other. This value is recalculated each weekend.
Steps
Below is the overall calculation. Some of the variables below are defined in the 'Fields and Definitions' section of this Help Resource
(WHEN PotentialBuyers < 100 THEN 0 ELSE 1.0) * WeeklySalesPerPotentialBuyers
+
(WHEN Buyers13Week / PotentialBuyers < 0.01 OR Buyers13Week < 10 THEN 0
WHEN Buyers13Week / PotentialBuyers < 0.10 THEN 0.25
ELSE 0.5) * (WeeklySalesPerBuyers + WeeklySalesPerPlacements)
+
(WHEN Buyers13Week / PotentialBuyers < 0.01 THEN 0 ELSE 1.0) * (BuyerGrowth13WeekSales + PlacementGrowth13WeekSales + SalesGrowth13Week + SalesGrowthLastYear13Week)
Fields And Definitions
WeeklySalesPerPotentialBuyers = Sales13Week / 13 / PotentialBuyers
WeeklySalesPerBuyers = Sales13Week / 13 / Buyers13Week
WeeklySalesPerPlacements = Sales13Week / 13 / Placements13Week
BuyerGrowth13WeekSales = Buyers13WeekChange / Buyers13Week * Sales13Week / 13 / Buyers13Week
PlacementGrowth13WeekSales = Placements13WeekChange / Placements13Week * Sales13Week / 13 / Placements13Week
SalesGrowth13Week = Sales13WeekChange / 13 / Buyers13Week
SalesGrowthLastYear13Week = SalesLastYear13WeekChange / 13 / Buyers13Week