Preparing Spreadsheets for Budget Imports

Optimize.png 

Persona-ArticleFor.pngAllocadia-2017-HelpCentreGraphics-08.pngPersona-MarketingOps.pngPersona-Marketer.png

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:

    1. 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
    2. Rows: Empty rows will not be accepted and will stop the importing process
    3. Columns: You can keep columns you don't want to import on your spreadsheet and ignore them during the mapping process, saving you time in prepping your sheet for import                         
    4.  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 Formatting
      Grand Totals: * before text
      Category: ** before text
      Sub-Category: *** before text
      Line Item: Nothing before text
      Placeholder: ## before text
    5. 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
import_budget_example.PNG
Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.