The Bottom Line: Ecommerce Tactics for Profitable Growth artwork

Forecasting Series Part 2: How to create and analyse a forecast

The Bottom Line: Ecommerce Tactics for Profitable Growth · with Taylor Lagasse · March 20, 2024 · 20 min

Summary

This episode breaks down how to build and analyze an ecommerce forecast, using a real-world role-play scenario. It highlights how to set realistic goals, identify key performance levers like gross margin and customer repeat rates, and connect forecast metrics to actionable ad account targets, providing a blueprint for achieving profitable growth.

Key takeaways

Themes

aov and profitability optimizationcustomer retentionforecasting and planningpaid acquisition

Topics covered

affiliate marketing platformscustomer lifetime valueecommerce forecastinggoogle ads strategygross margin optimizationmeta ads strategyshopify appssnapchat ads strategytiktok ads strategy

Episode description

In this episode, Cody and Taylor discuss the process of building a forecast for a skincare brand. They start by setting goals and objectives, including the brand's desire to sell and exit within three years. They then dive into the details of the forecast, analyzing key metrics such as top line revenue and profitability as well as  identifying opportunities for improvement, such as reducing the cost of delivery and increasing customer acquisition. They also discuss how the forecast ties to in-ad account performance and the importance of performance reporting and execution.  00:00 Introduction and Overview 01:03 Setting Goals and Objectives 04:01 Analyzing the Forecast 05:07 Improving Cost of Delivery 08:50 Opportunities for Growth in Customer Acquisition 10:05 Tying Forecast to In-Ad Account Performance 12:20 Analyzing Average Cost Breakdown 13:51 Translating Forecast to Ad Channel Targets 19:53 Performance Reporting and Execution Brought to you by: MightyScout: Supercharge your agency with the fastest solution for Instagram & TikTok Influencer Tracking, Analytics & Reporting. Get more valuable work done for your clients without hiring more staff. ⁠https://mightyscout.com/⁠ And Social Snowball: Frictionless affiliate programs for your customers & creators. <a href="https://www.youtube.com/redirect?event=video_description&

Frequently asked about this episode

What does this episode say about aov and profitability optimization?
Focus on optimizing gross margin: Even a 10% improvement in gross margin (e.g., from 50% to 40% cost of delivery) can significantly impact profitability, potentially more than top-line revenue growth. Explore better manufacturer terms and test different offers/pricing in ads.
What does this episode say about customer retention?
Leverage returning customer data for reliable forecasting: Returning customer behavior is highly consistent. Ensure Klaviyo flows and upsell strategies are optimized for this segment, as it offers a stable base for your forecast.
What does this episode say about forecasting and planning?
Translate forecast goals into actionable ad targets: Use your desired AMER (Average Monthly Existing Revenue) as a universal prospecting target across all ad channels (e.g., 30-day click on Google, TikTok, Snapchat, and 28-day click on Meta).
What does this episode say about paid acquisition?
Integrate forecasting into agency onboarding: As an agency, use a detailed forecasting exercise as the initial step for client onboarding to align on goals and build a data-driven strategy.
What does this episode say about aov and profitability optimization?
Implement a tiered affiliate system and eliminate code leaks: Utilize platforms like Social Snowball to empower modern affiliates (creators, ambassadors) with tiered commissions and prevent coupon code leakage to protect margins.

Listen