📹Video Training - Q&A

Join us as we are discussing an internal informal discussion on how to edit the SmartModel™ on a variety of use cases.

Expand the boxes below to view the outline of the video

Outline: Use Cases + Questions We Will Answer

"Live Model" and Working in Excel

• What does the notion of live model mean? (min 0:39)

• My formulas are not calculating how do I fix that? (min 5:52)

Marketing Scenarios + CAC + New Ad Sources

• How do I override my forecast for an existing ad source? (min 1:34)

• How do I add a new ad source? (min 3:00)

• How do I adjust my CAC? (min 6:45)

• How should I think about CAC across channels even though Drivepoint only asks for a blended CAC? (min 7:20)

• How should I think about how a new ad source influences my CAC? (min 8:15)

Checking my Work by Utilizing Drivepoint Templates

• How can I check the Marketing changes that I made and which templates are the most useful? (min 9:15)

• How do I compare against a base plan? (min 10:35)

Adding new Wholesale/Retail Accounts

• How do I add a new account/chain that I am starting to sell in? (min 12:57)

• How do I name my Wholesale tabs correctly? (min 14:56)

Adding New SKUs + Changing my Sales Mix

• How do I add a new SKU (min 19:09)?

• How should I think about import shipping? (min 19:31)

• How should I think about landed unit costs? (min 19:53)

• How do I change my sales mix? (min 21:10)

• How should I indicate cannibalization of Sales by product with new product launches? (min 21:43)

• How do I change my channel pricing? (min 21:58)

• Is there an easy shortcut to

Other Tips

• As you are building scenarios, go big in your assumptions so that you can truly see the impact of the scenario. Instead of $4000 for Bing Ads, go for $400,000 in Bing Ads.

• If your product sales mix + pricing is generally pretty stable, we have a shortcut for assuming product information. (min 22:04)