A proprietary Sophie Society spreadsheet that takes the percentages exposed by Consumer Behavior Analytics (Repeat Purchase Behavior Report) — repeat customers, repeat customer %, repeat ordered units, repeat ordered units %, plus product price — and outputs total customers, total units, average units per customer, and lifetime ACOS.
This is the missing link: Amazon's Brand Analytics never shows total customer count or LTV directly, so this tool exists specifically to reconstruct it from the percentages Amazon does expose.
Apply: Feed in the Brand Analytics repeat-purchase figures and current ACOS to back-calculate lifetime ACOS and average purchases per customer. Obtainable by commenting on the source video's post or emailing Sophie Society directly — it isn't a public self-serve tool.