Preparing for Reconciliation

Plan Reconciliation closes the loop between planning/forecasting in the Keen Platform and in-market execution. In order to reconcile a forecast, you’ll need two assets:

• A published plan

• An updated model

In order to reconcile your plan, you’ll need to create a new model with two key features.

1. A cadence that matches the inital model atop which your plan was built (week beginning/ending settings)

2. Additional weeks of actualized data, as compared to the inital model.

   1. For example, if your initial model ran thru Dec 2024 and you built a full-year 2025 plan atop this, you could build an updated model thru Q1 2025 to reconcile the first quarter of your annual plan.

   2. Your new model end date must exceed your plan’s start date; the overlapping period is eligible for reconcilation.

Any time you create a model, you’ll want to revisit the same fundamental framing questions you did initially, such as:

• What factors should be included?

  • Should any channels be split, aggregated, restated, or deleted

• Are the factor groups still relevant?

• Is the outcome metric and sales channel scope still appropriate?

• Are the revenue scope and margin still accurate?

• Should ROI Research be added, updated, removed, or updated?

Note: A full overview on Updatings Model is coming soon.

1. Factors included in either model will be reflected (both marketing tactics and environment factors).

2. Factor groupings are based on the groups that were in place when the updated model’s data snapshot was created.

3. If a factor has been renamed, the report uses the new name from the updated model.

4. If a factor’s accounting setting has changed, this will be discoverable by reviewing the Tactic Performance panels (specifically, activity and cost-per metrics).

5. If the outcome metric or top-line financials have changed, this will be discoverable by reviewing the Total Performance panels (specifically, revenue and sales volume)