The bulk edit spreadsheet holds more than budgets. Alongside the money columns are the settings columns: account manager, goals, active schedule, and alert routing. Each one accepts a specific set of values, and this article is the reference for them. To download, edit, and upload the file, read edit budgets in bulk with a spreadsheet.
The two rules
Every settings cell follows the same two rules:
- Leave a cell blank to keep that value exactly as it is. A blank cell is never an instruction.
- Type
CLEARto empty the value and return it to its default.
Note:
CLEARis the only word that empties a value. Type it into the cell on its own.
One column is the exception: active_schedule can't be cleared, because an account or group always runs on at least one day. Set the days you want instead.
What each column accepts
| Column | Applies to | Accepted values | To clear |
|---|---|---|---|
account_manager | Accounts | A workspace member's email address | CLEAR |
primary_goal | Accounts and groups | A goal name (see the goal lists below) | CLEAR |
secondary_goal | Accounts and groups | A goal name (see the goal lists below) | CLEAR |
additional_context | Accounts and groups | Any note up to 2,000 characters | CLEAR |
active_schedule | Accounts and groups | All, Weekdays, Weekends, or a day list like Mon,Wed,Fri | Can't be cleared |
slack_channel | Accounts (Pro plan) | A channel name, such as #budget-alerts | CLEAR (falls back to the workspace default) |
email_recipients | Accounts (Pro plan) | One or more email addresses, separated by a semicolon | CLEAR (falls back to the workspace default) |
The account_manager value has to be someone already in the workspace. Invite them first, then set the cell to their email. For slack_channel, pick a channel that Pace has already been invited to.
Goals
Two columns set goals: primary_goal and secondary_goal. The accepted values depend on whether the row is an account or a campaign group.
Accounts
For primary_goal on an account:
- Google Ads, Meta Ads, LinkedIn Ads, and Microsoft Ads accounts accept CPA, ROAS, Conversions, Clicks, CTR, and Impressions.
- Google Ads accounts also accept Phone Calls.
- TikTok Ads accounts use their own objectives instead: Reach, Traffic, App Installs, Video Views, Lead Generation, Web Conversions, and Product Sales.
For secondary_goal on an account:
- Improve CTR, Reduce Cost Per Click, and Reduce Cost Per Conversion work on any platform.
- Improve Search Impression Share works on Google Ads only.
Campaign groups
A campaign group uses the same short list for both its primary and its secondary goal: CPA, ROAS, Conversions, Clicks, CTR, and Impressions. The secondary goal can't repeat the primary one.
Note: To set a conversion-action goal, open account settings (or campaign group settings for a group). The spreadsheet accepts the goal names above, not conversion actions.
Alert routing needs the Pro plan
The slack_channel and email_recipients columns route this account's alerts, and both are Pro plan features. On plans below Pro, Pace skips edits to these two columns and flags them in the review instead of applying them. slack_channel also needs a connected Slack workspace, so connect Slack in workspace settings before you set a channel.
Warning: The
email_recipientscell is the complete list for that account. Anyone not in the cell stops getting email alerts for it. To add someone, keep the existing addresses and add theirs alongside; to leave the list untouched, leave the cell blank.
Nothing changes until you apply
Pace previews every edit before it goes live. After you upload, it shows each change as its old value and its new value, and lists any cell it skipped or couldn't read. Check that screen, then apply. See edit budgets in bulk with a spreadsheet for the full download, review, and apply flow.