Allocadia allows you to make use of budget sheets that have already been made by importing them into Allocadia rather than manually re-entering them. Having an up to date Activity Plan allows marketers to understand where they currently stand for spend allocation and goals the organization has set. For simple and successful importing there are a few formatting requirements that should be followed.
Best Practice: Export a budget sheet with a sample piece of data to create a template!
These requirements are as follows:
- First Row: Your first row must have headers. If there is a blank row you will be prompted to add the headers prior to import. Duplicate header names will not be accepted
- Rows: Empty rows will not be accepted and will stop the importing process
- Columns: You can keep columns you don't want to Import into your spreadsheet and ignore them during the mapping process, saving you time in prepping your sheet for import
- Activities Format: The first column should be where you title your activities and format them as either a Category, Sub-Category, Line Item, or Placeholder
Note: Activities FormattingGrand Totals: * before textCategory: ** before textSub-Category: *** before textLine Item: Nothing before textPlaceholder: ## before text
- Worksheets: The worksheet that you are importing MUST be your first tab in the workbook
Do's: Example of a properly formatted Activity Plan for import
Please sign in to leave a comment.