Completions

Skill catalog

Per-location forecasting that does not wait for month-end

Sales, leads, conversion, CAC, LTV, churn, ROAS, GBP impressions — forecasted per location, per month, refreshed weekly.

The problem

Most multi-location operators run their forecast through a monthly Excel pivot by an analyst. By the time the forecast ships, the data is two weeks old, the assumptions are stale, and the per-location numbers were estimated from a rollup. A 200-location operator forecasting 80 metrics monthly has 16,000 forecast-metric-location-month cells to produce. Per-location forecasts end up being 6 to 12 months stale because the analyst cannot refresh that many cells. The CFO presents a board deck built on a 30-day-old rollup. Enterprise FP&A platforms (NetSuite, Anaplan, Pigment, Adaptive) do consolidation and corporate budgeting well — per-location, per-metric forecasting is your team to build on top. AI sales forecasting tools (Clari, Gong, Einstein Forecasting) focus on B2B pipeline. Predictive marketing analytics (HockeyStack, Dreamdata, Northbeam, Triple Whale) focus on multi-touch attribution for DTC. None of them produce 16,000 per-metric per-location per-month forecasts continuously.

What success looks like

Every metric you care about gets forecasted per location per month. Sales, lead volume, conversion rate, CAC, LTV, churn rate, ROAS by channel, GBP impressions, and the other 70-plus metrics that matter for the business. Forecasts refresh weekly. Multiple model families (Prophet for seasonality, LSTM for non-linear patterns, XGBoost for feature-rich tabular signals, ARIMA for stationary signals) run as an ensemble. Per-location patterns surface — a market with strong seasonality gets a different model weighting than a steady-state market. The CFO sees a current forecast at board prep. The marketing team sees forecast versus actual in time to react. The franchisees see their own location's forecast against their own actual.

How most operators solve this today

Several categories produce forecasts. None of them ship 16,000 per-location per-metric forecasts continuously refreshed:

  • Enterprise FP&A platforms (NetSuite Forecasting, Anaplan, Pigment, Adaptive Insights, Vena, Cube, Mosaic, Causal)

    $99 to $200,000+/year

    Built for corporate budgeting and consolidation. Per-location, per-metric forecasting using time-series ML is your team to build on top.

  • AI sales forecasting tools (Clari, Gong Forecast, Salesforce Einstein Forecasting, HubSpot Sales Forecasting, Aviso, Outreach Forecast, Boostup)

    $99 to $10,000+/user/year

    Focused on B2B sales pipeline forecasting. Multi-location marketing and operations metrics are out of scope.

  • Predictive marketing analytics (HockeyStack, Bizible, Demandbase, Dreamdata, Ruler Analytics, Funnel.io, Northbeam, Triple Whale, Rockerbox)

    $100 to $100,000+/year

    Strong on multi-touch attribution for DTC. Per-location per-metric forecasting at multi-location scale is not what they ship.

  • Analyst running Excel forecasts monthly

    $80-130k/year analyst time

    Works for top-of-house metrics. Per-location, per-metric depth is not feasible at 16,000 cells monthly.

  • Build it in-house

    Senior engineer ($130-220k) + data scientist ($140-250k) + analyst ($80-130k) + six to sixteen weeks

    A custom dbt plus Snowflake plus Python (Prophet, LSTM, XGBoost, ARIMA) pipeline gets you to v1. Maintenance across 16,000 forecast cells is the ongoing cost.

What changes when this is an agent skill

Per-metric, per-location, per-month forecasts run as an ensemble of four model families: Prophet handles seasonality (Q4 retail surges, school-calendar dental patterns), LSTM handles non-linear behavior (marketing-driven inflection points), XGBoost handles feature-rich tabular signals (multi-input drivers like spend, weather, and competitor activity), and ARIMA handles stationary signals (steady-state metrics). The ensemble weighting tunes per metric and per location based on what actually predicts well there. Forecasts refresh weekly. Output writes back to your reporting layer so your BI tool shows current forecasts alongside actuals. Anomalies (actuals diverging from forecast) emit signals so the marketing and ops teams can react in days, not month-end. Every forecast is versioned with the model ensemble that produced it and the input data window — so the CFO and the analyst can drill into any number and explain it.

Agents that include this skill

Skills live inside agent rentals. To get this skill in production, hire any of the agents below — context-tuning at onboarding is included in the first month.

FAQ

How is this different from enterprise FP&A (NetSuite, Anaplan, Pigment, Adaptive)?
FP&A platforms handle corporate budgeting and consolidation. Per-location, per-metric time-series forecasting using ML is your team to build on top. We bring the forecasting layer.
How is this different from AI sales forecasting (Clari, Gong, Einstein Forecasting)?
AI sales forecasting tools predict B2B pipeline. We forecast multi-location marketing and operations metrics — different problem, different signals.
How is this different from predictive marketing analytics (HockeyStack, Dreamdata, Northbeam, Triple Whale)?
Those platforms run multi-touch attribution and revenue modeling for DTC. Per-location, per-metric forecasting at hundreds of locations is not their scope.
Which forecasting models are used?
An ensemble of Prophet (seasonality), LSTM (non-linear patterns), XGBoost (feature-rich tabular signals), and ARIMA (stationary signals). Ensemble weights tune per metric and per location based on what predicts well there.
How often do forecasts refresh?
Weekly by default. High-velocity metrics can refresh daily. Low-volatility metrics can refresh monthly. Refresh cadence is configurable per metric.
Which metrics are forecasted?
Sales, lead volume, conversion rate, CAC, LTV, churn rate, ROAS by channel, GBP impressions, organic traffic, paid traffic, foot traffic, and any other per-location metric you ingest. Adding a new metric is a configuration change.
How is the forecast surfaced to the CFO and the marketing team?
Forecasts land in your reporting layer alongside actuals. Your BI tool of choice shows forecast versus actual. Variance alerts route to the marketing team in time to react.
Does this work for operators with under 50 locations?
Yes. The model accuracy improves with more training data per location, but it works at smaller scales too.

Hire one of the agents that includes this skill