Allocadia allows you to update your marketing spend data in real time so users can view the latest expected costs. Marketing spend data can also be updated in bulk to make the process easier and more efficient by importing new data into an existing Activity Plan.
- On the Activities tab (formerly Budget tab), click the Export Button next to the Search Bar, select Export All fields for Import
Note: This is ideal if you have POs or Actuals attached to the Activity Plan. If there are no POs or Actuals attached it may be easier to delete the existing Activity Plan and start fresh.
- Open the Excel document and update your data as required. If you delete any values from the document, it will be removed from the Activity Plan upon Import. Deleting rows from the spreadsheet will not remove them from the Activity Plan upon Import
Note: If you wish to add new Categories, Sub-categories or Line Items to the Excel document please use the spreadsheet format defined in our Preparing Spreadsheets for Import into Activity Plan article. To read the article click here.
- On the Home tab, click the Import button and select Activity Plan from the drop-down list
- On the Import Activity Plan window, select the Activity Plan that you would like to import, fill in the required fields and then click Next
- Map the spreadsheet column headers to the Allocadia column headers and select Update/Append data using matching ID for your Import Options
Note: If your information is not showing properly, cancel the Import and make sure your spreadsheet matches the importing requirements.
- Complete the rest of the import process, and click Import