Bulk updates

Use CSV files to upload your target budget data

Account target budgets

An account-level target budget can be defined for one or more accounts in bulk by uploading a CSV file with your data.

Start on the Budget view and download a prepopulated template with your data.

If you don't select any accounts before the download, the template will include data for all existing accounts.

You can then edit and upload the template to apply your changes. The CSV file headers are:

  • Account ID: Leave as is

  • Account name: Leave as is

  • Target budget this month: This will either show the current spend goal (for this month) or be blank if not defined previously. You can update it or leave it as is to keep the existing setting.

  • Target budget for next month: Same as above, for next month's spend goal. Once applied, you can see this value in the Future spend column within the Adalysis interface.

  • Target budget for month after next month: Same as above for the month after next.

The bulk upload allows you to define the budget for this month and the following two months. Alternatively, you can specify the spend goals of up to 12 months within each account individually.

Budget group target budgets

Budget group targets can be updated either for multiple accounts at once, or for a single account. The scope of the template you use depends on where you download it from:

If you don't select any budget groups before the download, the template will include all existing budget groups.

You can then edit and upload the template to apply your changes. The CSV file headers are:

  • Account ID: Leave as is

  • Account name: Leave as is

  • Budget group ID: Leave as is

  • Budget group name: Leave as is

  • Target budget for this month: This will show the current spend goal (for this month) or appear blank if not defined previously. You can update it or leave it as is to keep the existing setting.

  • Target budget for next month: Same as above, for next month's spend goal. Once applied, you can see this value in the Future spend column within the Adalysis interface.

  • Target budget for month after next month: Same as above for the month after next.

Last updated