{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/e226de4d36e34984ba1f5709d78e07e3\" frameborder=\"0\" width=\"1900\" height=\"1425\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1425,"width":1900,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1425,"thumbnail_width":1900,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/e226de4d36e34984ba1f5709d78e07e3-d68e617a3fe085ce.gif","duration":187.62666700000003,"title":"CAC Ceiling Calculator Walkthrough","description":"This Loom explains how to use an audit Google Sheet to analyze revenue performance and marketing efficiency. It starts with entering gross sales, discounts, and returns to calculate net revenue, avoiding gross revenue since that change affects most brands’ numbers. Next, it uses inputs for four buckets, COGS, Marketing, OpEx, and Profit, to determine whether metrics fall in low, high, or in-range ranges and to identify quick wins. The key focus is step three, calculating the CAC ceiling as new customer AOV times gross margin times the allowed marketing factor, which for this example is about $11, and step four shows the conversion rate needed to hit the ceiling and AMER target. A quick wins tab flags specific fixes to prioritize based on impact."}