Configure an import action for your forecast results

It's essential to create an import action for your forecast results module so PlanIQ can use the action to save your predictions into the module, once the forecast run completes.

To configure the import action:

Use Excel to create a new CSV file.
Use this file to create your column headers.
Add column headers for the following data items, exactly as shown below:
- timestamp
- item_id
- forecast_action
  Note: Use this column to map the different sets of predictions from each forecast action.
- P1
- P2
- P3
  P1, P2, and P3 represent the three prediction quantiles you can apply to your forecast.
In the CSV file, add a placeholder entry for the timestamp column, and add an actual entry for the item_id column.
Keep the other columns empty. See the example below:

timestamp	item_id	forecast_action	P1	P2	P3
2021-01-01	[Insert one of your actual items or SKUs in this column]

In the module, select Data>Import to import the CSV file.
In the Set Default File dropdown, select either Admins Only, or Everyone.
Select Upload New File... and upload the CSV file.
Select the Mapping tab and map the source columns to the target columns.

Source	Target
Column 1: timestamp	Time
Column 2: item_id	Item_id
Column 3: forecast_action	[If you decide to map the forecast action, map it to the forecast_action_name dimension in your forecast results module.]
Column 4: P1
Column 5: P2
Column 6: P3

In the Mapping tab, select Only update imported cells.
Select the Time tab and select Dates.
Ensure the date format is Y-M-D.

CSV template

Use this CSV file as a template to set up your import action.

Every time you run a forecast action, this configuration imports the results into your forecast results module. You can use the module to compare the different sets of results against each other.