Promo Velocity Forecast Prompt (High-Low Scenario + Confidence Ranges)
Using your current trend data and the details of your upcoming promotion, estimate projected sales velocity and model a range of possible outcomes.
Inputs:
  • Recent trend data (last 4–8 weeks): [insert weekly units or summary]
  • Promo start date: [insert date]
  • Forecast time frame: [insert time frame]
  • Projected promo lift (%): [insert percent]
Contextual factors to include:
  • Promo type and expected impact: [insert promo mechanics and rationale]
  • Historical promo performance: [insert comparison data, similar offer results, or benchmarks]
  • External influencing factors: [insert competitive activity, seasonality, retailer traffic, inventory position, marketing support, or distribution changes]
  • Channel nuances (if applicable): [insert online vs in-store differences, marketplace traffic patterns, or retailer-specific lift expectations]
Please calculate the following:
  1. Baseline average velocity from the trend data.
  2. Anomaly adjustments for stockouts, unusual spikes, or distribution disruptions.
  3. Adjusted baseline: baseline after anomaly correction.
  4. Promo lift application: apply the projected lift percent to the adjusted baseline.
  5. Scenario modeling:
  6. Confidence range: provide a high-low band for the forecast.
  7. Final forecast: return the projected velocity for the selected time frame (weekly or multi-week/month).
Please present the results in a clear table with these rows:
  • Baseline average velocity
  • Adjustments for anomalies
  • Adjusted baseline velocity
  • Promo lift percent provided
  • Most likely forecast
  • High scenario forecast
  • Low scenario forecast
  • Confidence range (high and low)
  • Final projected forecast for the selected time frame
After the table, provide a short written summary explaining how the scenarios differ and what operators should watch for during the promo period.
0
0 comments
Sabrina Valdez
1
Promo Velocity Forecast Prompt (High-Low Scenario + Confidence Ranges)
powered by
CPG AI ACCELERATOR
skool.com/cpg-ai-accelerator-2786
Where CPG founders unlock AI to scale smarter, faster, and leaner — without hiring more. Stay ahead, save time, and grow with the power of AI.
Build your own community
Bring people together around your passion and get paid.
Powered by